Difference between revisions of "Edinburgh Buses."
From SQLZOO
(Created page with "<h3>Edinburgh Buses</h3> <p>This database consists of two tables: stops and routes</p> <h2>stops</h2> <p>This is a list of areas served by buses. The detail does not really in...") |
|||
| Line 16: | Line 16: | ||
<table border="1"> | <table border="1"> | ||
<tr><th>Field</th><th>Type</th><th>Notes</th></tr> | <tr><th>Field</th><th>Type</th><th>Notes</th></tr> | ||
| − | <tr><td notranslate="1">num</td><td>CHAR(5)</td><td>The number of the bus - as it appears | + | <tr><td notranslate="1">num</td><td>CHAR(5)</td><td>The number of the bus - as it appears on the front of the vehicle. Oddly these numbers often include letters</td></tr> |
| − | + | <tr><td notranslate="1">company</td><td>CHAR(3)</td><td>Several bus companies operate in Edinburgh. The main one is Lothian Region Transport - LRT</td></tr> | |
| − | + | <tr><td notranslate="1">pos</td><td>INTEGER</td><td>This indicates the order of the stop within the route. Some routes may revisit a stop. Most buses go in both directions.</td></tr> | |
| − | <tr><td notranslate="1">company</td><td>CHAR(3)</td><td>Several bus companies operate in | + | |
| − | + | ||
| − | <tr><td notranslate="1">pos</td><td>INTEGER</td><td>This indicates the order of the stop | + | |
| − | + | ||
| − | + | ||
<tr><td notranslate="1">stop</td><td>INTEGER</td><td>This references the stops table</td></tr> | <tr><td notranslate="1">stop</td><td>INTEGER</td><td>This references the stops table</td></tr> | ||
</table> | </table> | ||
Latest revision as of 10:27, 18 July 2012
Contents |
Edinburgh Buses
This database consists of two tables: stops and routes
stops
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 |
route
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.
Footnotes
- This data has been scanned in from the Edinburgh Travelmap published
by TRAVELINE, City of Edinburgh Council.
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. - Many infrequent services have been omitted
- Many route variations have been ignored. These include peak time limited stop services and truncated services.
