Đ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 thêm: 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

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

Mã Dự Án: #1743725

Đã trao cho:

KRodri

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á)
5.7

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

buraqtech

Check your PMB for details!!!

$1285 USD trong 22 ngày
(69 Đánh Giá)
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 trong 25 ngày
(20 Đánh Giá)
6.1
beyondprograms

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

$2000 USD trong 20 ngày
(14 Đánh Giá)
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 Thêm

$1000 USD trong 30 ngày
(1 Đánh Giá)
3.4
XzP53FE1y

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 Giá)
0.0
JavaSpringGrails

I wrote one of the more popular GPX mapping applications on the interntet: https://chrislacy.net/map/ . I can get this done for you.

$750 USD trong 3 ngày
(0 Đánh Giá)
0.0
bassthiam

Hi, subscribing. please read my private message.

$800 USD trong 25 ngày
(0 Đánh Giá)
0.0