Best practice to save bus routes in a database

views:

461

answers:

Best practice to save bus routes in a database

Hello everyone...

I have a project that consist of a system that helps to manage a bus transportations company.

I have to store in my database the daily routes of all bus.

How do I do that? And what can I use to help user to design routes?

I'm wondering use Google Maps or something like that, to help users "design" all routes.

I can't figure ir out :S

Best reguards.

Like Josh suggested: If you're talking about a route, I'd store a list of lat/long waypoints to describe a route.

Some Links:

Google Maps .NET Control

Part 2 Advanced Usage

Part 3

(Found at this spot)

John Weldon 2009-05-13 22:56:18

With route I mean something like in Google Maps that we can design all path from one point X to another point Y. Am I clear? Sorry about my poor english :S

rpf 2009-05-14 19:11:46

Yes, you're clear. That is exactly how you'd store a route to use with google maps; A list of latitude/longitude pairs (called waypoints) describing specific stops or changes in direction along the route.

John Weldon 2009-05-14 19:56:41

How can I have access to that waypoints using ASP.NET and GoogleMaps?

rpf 2009-05-20 08:35:15

Updated answer with some links

John Weldon 2009-05-20 13:35:18

+1 A:

Have a "StopLocation" table, indicating every possible location any bus can stop at.

Have a "BusSchedule" table, which would be the schedule of a single bus for a day.

Then have a "BusStop" table.

This would have a foreign key reference to the "BusSchedule", a foreign key reference to "StopLocation", and the time it is due to stop there.

Andrew Shepherd 2009-05-13 23:06:59

If the goal is not a geographically accurate description of the route this would be great. +1

John Weldon 2009-05-14 19:57:53

ansaurus

tags:

views:

answers:

Best practice to save bus routes in a database

related questions