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,
[login to view URL]
[login to view URL]
and how the raw GPX is generated from a sciptlet (the video shows GoogleMap CueSheet, but since then I have switched to GMapToGPX [login to view URL] (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.
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.
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-commerce solutions and acting as an offshore development center for overseas development firms.