Käynnissä

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.

Taidot: Karttatiede ja kartat, MySQL, PHP, XML

Näytä lisää: database design bike, product database design, mysql database free, sql create database, create database using php, connect php mysql database, googlemap my, google design draw, garmin api, free created web sites, degree coding, database design web, mysql bicycle routes, mapping api, info product creation, video mapping, table creation, ssrs, ssrs sql, ssrs report, sql database report, route, google form report, database design, database design sql

About the Employer:
( 0 reviews ) Las Vegas, United States

Projektin tunnus: #1743725

Myönnetty käyttäjälle:

KRodri

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

600 $ USD 10 päivässä
(37 arvostelua)
5.7

8 freelanceria on tarjonnut keskimäärin 1086 $ tähän työhön

buraqtech

Check your PMB for details!!!

1285 $ USD 22 päivässä
(69 arvostelua)
7.7
influxive

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 25 päivässä
(20 arvostelua)
6.1
beyondprograms

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

2000 $ USD 20 päivässä
(14 arvostelua)
6.1
pawanyadav777

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 Lisää

1000 $ USD 30 päivässä
(1 arvostelu)
3.4
XzP53FE1y

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

750 $ USD 1 päivässä
(0 arvostelua)
0.0
JavaSpringGrails

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

750 $ USD 3 päivässä
(0 arvostelua)
0.0
bassthiam

Hi, subscribing. please read my private message.

800 $ USD 25 päivässä
(0 arvostelua)
0.0