Difference between revisions of "Edinburgh Buses."

From SQLZOO
Jump to: navigation, search
(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>
  on the front of the vehicle. Oddly these numbers often include
+
  <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>
  letters</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
+
  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">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.

FieldTypeNotes
idINTEGERArbitrary value
nameCHAR(30)The name of an area served by at least one bus

route

A route is the path through town taken by a bus.

FieldTypeNotes
numCHAR(5)The number of the bus - as it appears on the front of the vehicle. Oddly these numbers often include letters
companyCHAR(3)Several bus companies operate in Edinburgh. The main one is Lothian Region Transport - LRT
posINTEGERThis indicates the order of the stop within the route. Some routes may revisit a stop. Most buses go in both directions.
stopINTEGERThis 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.
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense