Connor at 09:27, 18 July 2012

2012-07-18T09:27:03Z

Connor: Created page with "

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 in..."

2012-07-18T09:26:00Z

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..."

New page

<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
include each actual bus stop - just areas within Edinburgh and whole
towns near Edinburgh.</p>
<table border="1">
<tr><th>Field</th><th>Type</th><th>Notes</th></tr>
<tr><td notranslate="1">id</td><td notranslate="1">INTEGER</td><td>Arbitrary value</td></tr>
<tr><td notranslate="1">name</td><td notranslate="1">CHAR(30)</td><td>The name of an area served by
at least one bus</td></tr>
</table>

<h2>route</h2>
<p>A route is the path through town taken by a bus.</p>
<table border="1">
<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
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">stop</td><td>INTEGER</td><td>This references the stops table</td></tr>
</table>
<p>As different companies use numbers arbitrarily the num and the
company are both required to identify a route.</p>
<hr/>
<h3>Footnotes</h3>
<ul>
<li>This data has been scanned in from the Edinburgh Travelmap published
by TRAVELINE, City of Edinburgh Council.
<p><b>TRAVELINE</b> 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
<b>TRAVELINE</b> you can phone:<br/>
0800 23 23 23 local calls<br/>
0131 225 38 58 national calls.</p>
</li>
<li>Many infrequent services have been omitted</li>
<li>Many route variations have been ignored. These include peak
time limited stop services and truncated services.</li>
</ul>

@@ Line 16: / Line 16: @@
 <table border="1">
   <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>
 </table>

Edinburgh Buses. - Revision history

Connor at 09:27, 18 July 2012

Connor: Created page with "

Edinburgh Buses

stops