Database Destinations + Google Maps
- or -
Post a project like this4069
£150(approx. $188)
- Posted:
- Proposals: 3
- Remote
- #216285
- Awarded
Description
Experience Level: Expert
I need someone that is familiar with creating journey timetables and using Google Maps.
Essentially I need a front end and admin system that will use pre-populated journey times to calculate a journey.
id Destinations Name
1D Dest1 Bristol
2D Dest2 London (channel tunnel)
3D Dest3 Ebbsfleet (channel tunnel)
4D Dest4 Ashford (channel tunnel)
5D Dest5 Lille
6D Dest6 Paris
7D Dest7 Lyon
Connections
-----------
id From To Time
1C 1D 2D 3 hours
2C 2D 5D 1 hours 20 mins
3C 2D 6D 2 hours 15 mins
4C 2D 7D 4 hours 15 mins
5C 3D 5D 1 hours 05 mins
6C 3D 6D 2 hours
7C 3D 7D 4 hours
9C 4D 6D 1 hours 55 mins
10C 4D 7D 3 hours 50 mins
Using the info above or similar I need a formula to calculate journey time from Bristol to Lyon i.e. (1C and 4C). I think it will need to cross reference or join Db. .e.g. if journey does not exist in connections then cross reference it until a connection is found and then select the connections with the shortest journey time for each train trip or railway journey.
Also I need these points plotted out in Google Maps showing a line between each destination.
Essentially I need a front end and admin system that will use pre-populated journey times to calculate a journey.
id Destinations Name
1D Dest1 Bristol
2D Dest2 London (channel tunnel)
3D Dest3 Ebbsfleet (channel tunnel)
4D Dest4 Ashford (channel tunnel)
5D Dest5 Lille
6D Dest6 Paris
7D Dest7 Lyon
Connections
-----------
id From To Time
1C 1D 2D 3 hours
2C 2D 5D 1 hours 20 mins
3C 2D 6D 2 hours 15 mins
4C 2D 7D 4 hours 15 mins
5C 3D 5D 1 hours 05 mins
6C 3D 6D 2 hours
7C 3D 7D 4 hours
9C 4D 6D 1 hours 55 mins
10C 4D 7D 3 hours 50 mins
Using the info above or similar I need a formula to calculate journey time from Bristol to Lyon i.e. (1C and 4C). I think it will need to cross reference or join Db. .e.g. if journey does not exist in connections then cross reference it until a connection is found and then select the connections with the shortest journey time for each train trip or railway journey.
Also I need these points plotted out in Google Maps showing a line between each destination.
Andrew D.
92% (10)Projects Completed
20
Freelancers worked with
20
Projects awarded
16%
Last project
3 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies