I need to calculate stop times of bus lines (extrapolation)
- Shapefile with all stops
- Shapefile with control points where bus time was taken
- Shapefile with all bus routes
- CSV file with times in first stops on the route, final stops and control points where time was taken.
All of the Shapefiles have an attribute "route number" which identifies to which transport route they refer.
I need to find a tool (and procedure) that helps me extrapolate times in each of the stop on the route, using the departure time, arrival time and times at control points on the route (which are not stops). I suppose I actually need to calculate distances first and then times based on those distances.
I am unix user so OS tools would be preferable
Any suggestion how to crack this? Attributes described below.
Description: Locations of bus stops Attributes: Cod_ubic_p - stop location Code_variant - bus line (referenced in *Bus* shp file) Ordinal - order corresponding to the stop in the journey of the variant (bus line)
Description: Locations of control points Attributes: Cod_ubic_c - control point code Code_variant - bus line type (referenced in Bus_lines) Ordinal - order of given control point in the path of the variant
(bus line) Desc_locat - Description of Control Point location
Description: Routes of bus lines Attributes: Cod_line - Transportation line code Desc_line - Description of the transport line (eg 112, D16, etc) Ordinal - Correlative number of the sub-line of the line Code_subline - Code of the transportation sub-line Subline Desc - Description of the sub-line Cod_variant - Code of the route (to link with *Stops* shp) Desc_variant - Type (Variant) description (A = Ascending, D = descending)
csv sheet Timetables
Description: Timetables Attributes: COD_LINE - Transportation line code CODE_DAY_TYPE - Code for the day of the week LEAVES_FROM - Origin of the bus route DEPARTURE - Depature time DESTINATION - Destination of bus route ARRIVAL - Arrival time DESC_LOCAT - Description of Control Point (Stop) location COD_UBIC_C - control point code (referenced in *control_points* shp file) TIME - Time at control point location ORDINAL - Correlative number of the sub-line of the line DESC_VARIANT - Type (Variant) description (A = Ascending, D = descending)