Đang Thực Hiện

Bike route mapping/database

I used to have a Windows/MSSQL/SSRS server that served road bicycle routes in the form of an SSRS report. This document and the underlying MSSQL database provided web users with a 2 page document contaning information about the bicycle route

total distance

total ascent

degree of difficulty

hyperlink to the starting point

hyperlinks to the route in GPX, KML and CRS (Garmin) format (all three are XML formats)

I wish to port this to a PHP interface that will connect to a MySQL backend. This interface will provide users with the finished product (i.e. display the selected bike route), and offer the possibility to save the bike route to a PDF document, It will also offer to certain users the possibility to create a new route based on a raw XML/GPX document.

These 2 videos illustrate how the route is created,

[url removed, login to view]

[url removed, login to view]

and how the raw GPX is generated from a sciptlet (the video shows GoogleMap CueSheet, but since then I have switched to GMapToGPX [url removed, login to view] (don't forget to click on "Full" when you generate the GPX with GMapToGPX).

Basically the "special" user would draw the route on Google Maps, generate the raw GPX with the GMapToGPX scriptlet, click on "Full", copy the raw GPX and paste it into a PHP web page. When the raw GPX is uploaded to the PHP page, a new route is created in the MySQL database with all the info contained on the PDF example.

I can assist with any SQL coding required on the MySQL backend (stored procs, triggers, table creation, database design, etc.). I have 15 years experience working with databases, but PHP is not my strong suit (although I dabble in it for a couple of Joomla web sites I manage).

I'm also open to using the Google Maps API to draw the route and generate the waypoints. That would depend on the additional work involved.

The attached zip file contains an example of the PDF, CRS, GPX, KML and raw GPX for a given bicycle route. I also included the create table in SQL for the routes table. There are other reference tables involved, but this will you an idea.

Feel free to contact me if you have any further questions.

Thank you.

Kĩ năng: Bản đồ học & Bản đồ, MySQL, PHP, XML

Xem nhiều hơn: database design bike, www v m create php, www coding org, web design generate using php, product database design, mysql database for free, my sql create database, mapping document, how to work for google maps, how to draw web design, how to create database using php, how to create a database using php, how to connect to mysql database using php, how to connect php with mysql database, googlemap my, google design draw, garmin com, garmin api, free created web sites, draw my idea, degree in coding, database design web, create mysql database using php, mysql bicycle routes, create bike route google maps

Về Bên Thuê:
( 0 nhận xét ) Las Vegas, United States

ID dự án: #1743725

Được trao cho:


Hello I can do this project Will provide plans as soon as we discuss details Thanks

$600 USD trong 10 ngày
(37 Đánh Giá)

8 freelancer đang chào giá trung bình $1086 cho công việc này


Check your PMB for details!!!

$1285 USD trong 22 ngày
(69 Nhận xét)

Hello Sir/Mam We can do this project for you. Our bid is tentative right now, we will finalize bid amount once specifications are discussed and finalized.

$1499 USD trong 25 ngày
(20 Nhận xét)

i can help you to bridge the gap between php and .net for this app

$2000 USD trong 20 ngày
(14 Nhận xét)

hi sir Dolphinesoft is a professional Software Development Company providing complete IT solutions. website designing, software development and internet marketing and full featured web services including B2B and B2C e Thêm

$1000 USD trong 30 ngày
(1 Nhận xét)

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

$750 USD trong 1 ngày
(0 Nhận xét)

I wrote one of the more popular GPX mapping applications on the interntet: [login to view URL] . I can get this done for you.

$750 USD trong 3 ngày
(0 Nhận xét)

Hi, subscribing. please read my private message.

$800 USD trong 25 ngày
(0 Nhận xét)