How to aggregate Stop2Stop, Mode2Mode and Line2Line transfers at each stop node?


Product(s):Cube
Version(s):6.1 to 6.5
Area:Public Transport

 

Post-processing of PT “standard” outputs allows to obtain detailed results and visualization maps. Particularly useful outputs are provided by the powerful file-processing capabilities of the Matrix program.

Solution

The attached catalog provides with an example of post-processing to obtain 3 useful Summary Tables:
1. the Boarding and Alighting Passengers by stop/station,
2. the Mode 2 Mode Transfers by stop/station, and
3. the Line 2 Line Transfers by stop/station

Matrix program #1 creates a “test matrix” with 100 trips between every OD pairs, and Public Transport program #2 undertake path building and loading (in one single program) with this “test matrix”.

1. Boarding and Alighting Passengers by stop/station

The 1st task is achieved by post-processing and combining the information from the FILEO STOP2STOP output tables from a PT loading process, obtained with the following sub-keywords:


Matrix Program #3 calculates Direct Boarding and Direct Alighting Passengers at each stop node (first and last leg in the OD patterns) from the FirstLast report. Whilst Matrix Program #4 calculates the total Boarding and Alighting Passengers at each stop node from the Adjacent report.

Matrix Program #5 combine the 2 tables to obtain a summary table of Direct, Total and Transferring (Interchange) Boarding and Alighting for every stop node, as below:


2. Mode 2 Mode Transfers by stop/station

The PT program #2 also creates the Report File (REPORTO) containing the TRACEI TRACEJ report for every pair of zones.

This Route Evaluation report is processed within Matrix Program #6 and Route Bundles are converted in DBF [and CSV] format.

Assuming MODE<100 for TRANSITS and MODE>=100 for NON-TRANSIT modes, Matrix Programs #7 and #8 summarize this Route Bundles table to obtain Transit Mode-to-Mode transfers at each stop node.

The final table is the one below:


3. Line 2 Line Transfers by stop/station

The CSV TRACEI and TRACEJ report, is processed within Matrix program #10, to create a DBF table containing the Lines information associated to each Transit Leg in the Route Bundle.

Matrix programs #11 and #12 finally summarize this information in an output table containing Transit Line-to-Line transfers at each stop node, as shown in the table below:


In using this process, please note that the post-processing of the TRACEI and TRACEJ report can be a quite time consuming and memory intensive process for very big PT networks with lot of routes. Therefore there are cases in which it might be better to undertake this analysis for specific/isolated OD pairs only.

Finally, you can modify these scripts, to include additional information (e.g. costs) or different levels of aggregation.

communities.bentley.com/.../8512.Ridership_5F00_Processing_5F00_ByStation.zip