Pavement Express uses a defined set of segments throughout the entire the system. Each segment has a Segment ID as the unique identifier, and the same Segment ID is used across different tables for the same segment.
Note: This functionality is from Pavement standard, which can segment the linear network differently for different datasets.
Data flow defines how data arrives at the network and performance master files. They are primarily driven by these tools:
- Update Target Table
Running Import will copy the segments from one table to another. Detailed import configuration about import can be found here.
Update Target Table
After using import to copy the segment into the target table, to to populate the attributes of the resulting segments, the system provides a tool named Update Target Table. This function allows the user to program a set of data calculation rules in SQL script and store them with each specified column in each table. Therefore, whenever new sections are added to the table or existing attributes need to be updated, users can execute the command in the system to run these stored SQL script for these columns to update the corresponding attributes, and bring/aggregate data from other tables into the target table.
Whenever a section data table contains attributes with calculated values or values derived from data in other tables, then the Update Target Table right-click command will be available. This command allows you to select columns to update and recalculates the values or retrieves the values from the source table for existing records and non-location reference data columns, using a predefined SQL statement.
For example usage of Update Target Table, see Configure Network Master in Pavement Express.