TTCTrip Planner

Program Design

This computer program allow two types of user's input; entry of address, places or portal code (e.g. Rogers Centre, 200 Bay St.) and entry of the exact intersections of bus stops    
(e.g. Bathurst & Front).

The basic program design can be summarized by the flowchart below.

 

Database Designs

To Top
The program uses two local databases stored on hard drive and one online database stored on both my own server and Google servers.

Local database #1 (database.txt)

This database stores infomation of bus stop names, number of routes stopping there, and the route # of the stopped buses.

Example record: 4$Bathurst College$2$506,511

The record has four parts, each one seperated by a '$' sign with no spaces.
The first part is the order of the record among all 109 records.(e.g. 4)
The second part is the intersection of the bus stop. (e.g. Bathurst College)
The third part is the number of routes stopping at the bus stop. (e.g. 2)
The fourth part is the route # of these buses. (e.g. 506,511)

Local database #2 (distance.txt)

To Top
This database contains distance between all possible combinations of stops.
There are about 11000 records.

Example record: Bathurst/Station To Bathurst Queen^2.07975 kilometres

Online Database (example12.xml)

To Top
This database is stored on my own server (hwrms.com), containing longitude&latitude for each stop. This info is used to find the closest stop to user provided address (when user enters address, places, or postal codes).

This database is built according to the Google Maps SDK standard, bacause it is used with Google Maps SDK to generate results.

Example record:

<marker lat="43.647194" lng=" -79.403989" html="Bathurst Queen" label="Bathurst Queen"/>