The purpose of the project is to produce a Google Map with a list of plotted markers which are connected visually to represent a bus route.
The basics of the functionality here will be to read a list of addresses from a database table and plot markers on a Google Map. Each address will have a sorting order relative to the route, which will allow the address markers to be connected visually on the map. The feature should be function-based, where the following parameters may be passed in
* routeID
* map size
* Google Map type (map, satellite, hybrid)
The project should be built on the following platform: ColdFusion9 or higher, JavaScript, SQL Server 2008.
In this project, <cfmap> may not be used to generate the map. This is because when Google Maps has a major API update, your code that uses <cfmap> is dependent on Adobe updating the tag to reflect the new API, which often results in broken code. The latest stable Google Map API should be used. It should be built in a manner that would be simple to update after an API update.
Also, it must be considered that although the map is being built for the web, the primary method of access would be a tablet or similar device like a smartphone. The output should provide for mobile browser or regular browser access.
The following is the DB table structure:
1. Table of bus routes B_TransRoutes
* routeID (primary key)
* routeName
2. Table of addresses - B_Students
* addressID (primary key)
* address
* city
* state
* zip
3. Table of addressIDs/bus routeIDs/sorting orders - B_TransRouting
* routeID (partial primary key, foreign key trk_TransRoutes)
* addressID (partial primary key, foreign key trk_Students)
* sortorder