|
This database consists of two tables: stops and routes
This is a list of areas served by buses. The detail does not really include each actual bus stop - just areas within Edinburgh and whole towns near Edinburgh.
| Field | Type | Notes |
|---|---|---|
| id | INTEGER | Arbitrary value |
| name | CHAR(30) | The name of an area served by at least one bus |
A route is the path through town taken by a bus.
| Field | Type | Notes |
|---|---|---|
| num | CHAR(5) | The number of the bus - as it appears on the front of the vehicle. Oddly these numbers often include letters |
| company | CHAR(3) | Several bus companies operate in Edinburgh. The main one is Lothian Region Transport - LRT |
| pos | INTEGER | This indicates the order of the stop within the route. Some routes may revisit a stop. Most buses go in both directions. |
| stop | INTEGER | This references the stops table |
As different companies use numbers arbitrarily the num and the company are both required to identify a route.
TRAVELINE is your one-stop information point for details of
all local public transport services in Lothian, and complementary
facilities provided by The City of Edinburgh Council. To contact
TRAVELINE you can phone:
0800 23 23 23 local calls
0131 225 38 58 national calls.