How many buses an hour are there between two bus stops (stoppoints), including the geolocations (line).
This is actually a view into mv_link_frequency_* tables, which each have a gist index on the geolocation data (line).
PK: vjcode_id
A bus which departs at deptime (for the days in days_mask) and goes on the path described by journeypattern_id.
PK: journeypattern_id
Links to service_id and route_id
PK: jpsection_id
Links to journeypattern_id
PK: jptiminglink_id
A line between two bus stops (stoppoints) with timing (runtime) information for a given bus route (routelink_id).
The line belongs to a jpsection_id and jptiminglink_id.
PK: line_id
The number on the front of the bus.
PK: route_id
PK: routelink_id
A line between two bus stops (stoppoints).
PK: service_id