A Gentle Introduction to


Edinburgh Buses

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.

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


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

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.