-
Notifications
You must be signed in to change notification settings - Fork 29
Route choice schema
pt_edge
Column name | Description |
---|---|
start_stop | Stop id for the starting vertex. |
end_stop | Stop id for the ending vertex. |
r_type | Service Line type, can be "BUS", "LRT" or "WALK". |
service_line | If the edge is a route segment, it will have the primary bus service line in that route segment. If it is a walking leg, it will have string "Walk". |
road_index | Index for road type 0 for BUS, 1 for LRT, 2 for Walk. |
stop_link_sequence | The sequence number of the stop at this edge along the service_line . |
road_edge_id | Strings of passing road segments by current edge as specified in edge_id. Example:”4/15/35/43”, each number corresponds to a road segment between two adjacent stops along service lines. Road_edge_id containing single “edge_id” are referring to the road segment between two adjacent stops along service lines as specified in R_service_lines. Road_edge_id containing more than 1 “edge_id” are virtual edges representing traversing the edges sequentially without a transfer in between. |
r_service_lines | If the edge is a route segment, it will have bus service lines in that route segment. If it is a walking leg, it will have string "Walk". |
link_travel_time | Estimated travel time (in seconds) on current edge. If it is a transit leg such as RTS or Bus, it is the estimated in-vehicle travel time on current route segment. If it is a walking leg, it is the estimated walking time on current walking leg. |
edge_id | Id for current edge. |
wait_time | Estimated waiting time to embark on current edge. Data obtained from scheduled service line information. |
walk_time | Estimated walk time in the current edge, estimated based on direct distance and 4km/h walking speed in seconds. |
transit_time | Estimated travel time on transit legs for bus and MRT/LRT in seconds. |
transfer_penalty | Transfer penalty used to impose penalty on transfers for shortest path searching which assumes path cost is the addition of edge attributes in seconds. |
day_transit_time | Estimated transit time for buses and MRT/LRT in day time in seconds. Night bus services will have very large value in this column. |
dist | Estimated distance from travel time table in kilometers. |
pt_path
Column name | Description |
---|---|
pathset_origin_node | Node id of the path's origin node. |
pathset_dest_node | Node id of the path's destination node. |
scenario | Contains the algorithm used to generate the path and it's iteration number. |
path | Comma separated list of pt_edge ids that make up the path. |
path_travel_time_secs | Estimated travel time to traverse the path in seconds. |
total_distance_kms | Estimated distance traversed over path in kilometers. |
path_size | The degree of overlap for each path within its path set. |
total_cost | The computed total cost for traversing this path. |
total_in_vehicle_travel_time_secs | Estimated travel time spent in a vehicle in seconds. |
total_waiting_time | Estimated travel time spent waiting in seconds. |
total_walking_time | Estimated travel time spent walking in seconds. |
total_number_of_transfers | Total number of public transport transfers required while traversing this path. |
is_min_distance | Indicates that this path is the minimum distance between the two nodes. |
is_valid_path | Indicates that this path is valid. |
is_shortest_path | Indicates that this path is the shortest between the two nodes. |
is_min_in_vehicle_traveltime | Indicates that this path is the minimum in vehicle travel time between the two nodes. |
is_min_number_of_transfers | Indicates that this path has the minimum number of public transport transfers between the two nodes. |
is_min_walking_distance | Indicates that this path has the minimum walking distance between the two nodes. |
is_min_travel_on_mrt | Indicates that this path has the minimum travel on MRT between the two nodes. |
is_min_travel_on_bus | Indicates that this path has the minimum travel on Bus between the two nodes. |
pt_vertex
This table contains vertices that make up the public transport graph.
Column name | Description |
---|---|
stop_id | Stop id for stops as specified by public transport body. It can bus stops, train stations or SimMobility nodes (Starts with N_). |
stop_code | Stop codes for stops specified by public transport body. |
stop_name | Name of stop as per public transport body. |
stop_lat | Latitude of the stop. |
stop_lon | Longitude of the stop. |
ezlink_name | EZlinkName of the stop, usually same as stop code. |
stop_type | Type of stop, can be '0' for SimMobility nodes, '1' for Bus stops and '2' for MRT/LRT Stations. |
stop_desc | Description of stops. Usually street where the stop is located. |
pt_od
This table contains a list of origin and destination node ids for which public transit paths are to be generated during pathset generation.
Column name | Description |
---|---|
origin | Path origin node id. |
destination | Path destination node id. |
pvt_path
Column name | Description |
---|---|
pathset_origin_node | Node id of the path's origin node. |
pathset_dest_node | Node id of the path's destination node. |
scenario | Contains the algorithm used to generate the path and it's iteration number. |
path | Comma separated list of link ids that make up the path. |
partial_utility | Travel time independent part of utility. |
path_size | The degree of overlap for each path within its path set. |
signal_number | Estimate number of signals passed traversing this path. |
right_turn_number | Estimated number of right turns taken traversing this path. |
length | Estimated total distance covered traversing this path in meters. |
highway_distance | Estimated distance traveled on highways traversing this path in meters. |
min_distance | Indicates that this path is the minimum distance between the two nodes. |
min_signal | Indicates that this path passes the least amount of signals between the two nodes. |
min_right_turn | Indicates that this path has the least amount of right turns between the two nodes. |
max_highway_usage | Indicates that this path has the most amount of highway usage between the two nodes. |
valid_path | Indicates that this path is valid. |
shortest_path | Indicates that this path is the shortest between the two nodes. |
default_travel_time | Estimated travel time traversing this path in seconds. |
min_default_tt | Indicates that this path has the lowest travel time between the two nodes. |
pvt_od
This table contains a list of origin and destination node ids for which private transit paths are to be generated during pathset generation.
Column name | Description |
---|---|
origin | Path origin node id. |
destination | Path destination node id. |
erp_gantry_zone
This table contains a list of ERP gantry zones used in Cordon-based tolling policies.
Column name | Description |
---|---|
Gantry_no | ID of ERP Gantry. |
Zone_Id | Zone id of the zone the gantry is located in. |
erp_section
This table contains a list of ERP sections used in Cordon-based tolling policies.
Column name | Description |
---|---|
section_id | ID of Section. |
link_id | Corresponding link id for section. |
ERP_Gantry_No | ID of ERP Gantry in section. |
aimsun_id | ID in AIMSUN. |
erp_surcharge
This table contains a list of ERP surcharges used in Cordon-based tolling policies.
Column name | Description |
---|---|
Gantry_No | ID of ERP Gantry. |
Start_Time | Time of day at which tolling begins in HH:mm:ss. |
End _Time | Time of day at which tolling ends in HH:mm:ss. |
Rate | Flat tolling rate. |
Vehicle_Type_Id | Vehicle type id the toll in applicable to. |
Vehicle_Type_Desc | Vehicle description. |
Day | Days on which the toll is applicable. |
tolling_zones
This table contains a list of tolling zones used in distance-based and/or time-based tolling policies.
Column name | Description |
---|---|
link_id | ID of link in tolling zone. |
tolling_zone_id | ID of tolling zone. |
tolling_type | Type of tolling zone, can be '0' for Distance Based or '1' for Time Based. |
tolling_zone_rates
This table contains a list of tolling zone rates used in distance-based and/or time-based tolling policies.
Column name | Description |
---|---|
tolling_zone_id | ID of tolling zone. |
start_time | Time of day at which tolling begins in HH:mm:ss. |
end_time | Time of day at which tolling ends in HH:mm:ss. |
beta_flat | Flat tolling rate. |
beta_dist | Per distance tolling rate. |
beta_dist_sq | Per distance2 tolling rate. |
upper_bound | Toll rate upper bound. |
veh_type_id | Vehicle type id the toll in applicable to. |
veh_desc | Vehicle description. |