With Management Sections developed, we are ready to perform network analysis. In Pavement Analyst, the Network Master table is the starting point for all network analyses. These analyses depend on the columns included in the table. The columns to be included can be decided based on decision-making and reporting requirements for each customer.
Network Master table is a key table in Pavement Analyst, which combines data from the various sources (asset data, pavement condition, traffic data, pavement structure). It is the starting point for all network analyses and should contain the latest information for all pavement sections. It represents the current structure, traffic, classification, and condition for the network as a whole. See an example of possible columns in Network Master below. Since Network Master provides input to analysis, it must contain information for the full network for planning and reporting purposes.
Column Category | Example Columns |
---|---|
Location | PMS Section #, LOC_IDENT (Route, Begin / End Milepoint, Direction, Lane) |
Jurisdiction | Statewide Data Owner, Maintenance Jurisdiction, District, County |
Roadway Inventory | Length, Number of Lanes, Lane Width, Shoulder Width, Total Lane Miles, Functional Class |
Pavement Data | Pavement Type, Condition Data Year, IRI, Rutting, Faulting, Cracking |
Traffic | Traffic Data Year, AADT, VMT, ESAL |
Maintenance History | Last Treatment Type, Number of Years since Last Treatment, Last Rehab Type, Number of Years since Last Rehab, Most Recent Contract (Link to history), Pavement Age |
Structure | Total Surface Depth, Structural Class |
Two things need to be noted regarding the columns in Network Master:
Because Network Master is the input data stream for network analysis, it must be re-calculated at least once per year for the current data set to be used in network analysis, and it should also be re-calculated each time any of the condition indicator settings have changed.
Network Master typically uses the current pavement management sections as the master for pavement section definitions. Other data (such as pavement management inventory, traffic, condition in the form of performance index, and construction history) are then assigned to the Network Master when it is filled. Data for the Network Master is aggregated according to rules developed for each client, using the Update Target Table function.
The Network Master Data window shows all road sections in the Network Master and provides descriptive information about each road section. All the columns in Network Master that are calculated using the formulas can be configured by right click and select “Update Target Table” command (pic below).
Out of the box, Network Master Data window is located in Pavement Analyst > Analysis > Network Analysis > Network Master > Network Master Data menu. The table is named NETWORK_MASTER. Out of the box, the table has the following columns:
COLUMN_NAME | DATA_TYPE | DATA_LENGTH | NULLABLE | COMMENTS |
---|---|---|---|---|
LOC_IDENT | NUMBER | 22 | N | Location # used in SETUP_LOC_IDENT table to store the record’s location in the LRS. This is a system column. |
PMS_SECTION_ID | NUMBER | 22 | Y | PMS Section ID. Usually set to same value as LOC_IDENT |
LANE_MILES | NUMBER | 22 | Y | Lane-miles of the section |
LENGTH | NUMBER | 22 | Y | Length of the section |
DISTRICT_ID | NUMBER | 22 | Y | District |
FUNCTIONAL_CLASS_ID | NUMBER | 22 | Y | Functional class |
WC_ID | NUMBER | 22 | Y | Pavement type |
NHS_TYPE_ID | NUMBER | 22 | Y | NHS type |
SHOULDER_WIDTH | NUMBER | 22 | Y | Shoulder width |
SEC_WIDTH | NUMBER | 22 | Y | Width of the section |
NUMBER_OF_LANES | NUMBER | 22 | Y | Number of lanes |
WC_ID | NUMBER | 22 | Y | Pavement type |
OWNER_ID | NUMBER | 22 | Y | Owner |
STATE_OWNER_ID | NUMBER | 22 | Y | State-wide owner |
IS_INTERSTATE | NUMBER | 22 | Y | Interstate flag |
IS_NHS | NUMBER | 22 | Y | National Highway System (NHS) flag |
PMS_SEGMENTATION_TYPE_ID | NUMBER | 22 | Y | Pavement segmentation set, e.g. Management Sections, MAP-21 sections. This allows the Network Master to have multiple sets of segmentations. When running analysis in the Optimization Analysis window, user can choose which set of run analysis window. |
PAVE_AGE | NUMBER | 22 | Y | Pavement age |
TRAFFIC_DATA_YEAR | NUMBER | 22 | Y | Traffic Data Year |
AADT | NUMBER | 22 | Y | AADT |
PCT_TRUCK | NUMBER | 22 | Y | Truck percent |
PMS_WORK_CODE_ID | NUMBER | 22 | Y | Last treatment work code |
PMS_TREATMENT_ID | NUMBER | 22 | Y | Last treatment type |
PMS_AUTO_DATA_YEAR | NUMBER | 22 | Y | Condition data year |
PMS_IRI_VALUE | NUMBER | 22 | Y | IRI value |
PMS_RUTTING_VALUE | NUMBER | 22 | Y | Rutting value |
PMS_FAULTING_VALUE | NUMBER | 22 | Y | Faulting value |
PMS_PCT_CRACKING | NUMBER | 22 | Y | Percent cracking |
STATE_COND_CAT_ID | NUMBER | 22 | Y | Condition category using agency criteria |
MAP21_COND_CAT_ID | NUMBER | 22 | Y | Condition category using FHWA criteria |
COMMENT_STR | VARCHAR2 | 4000 | Y | Comments |
DATE_UPDATE | DATE | 7 | Y | Last update user of the record |
USER_UPDATE | VARCHAR2 | 400 | Y | Last update date of the record |
The data in Network Master does not change during optimization analysis even if the analysis is multi-year. Network Master data is copied to USER_OPTIMIZATION_ENGINE table where data is processed and changed by the application to provide analysis results.
Configuration of Network Master includes two main steps:
Note: It is expected that some prior knowledge of writing SQL statements exists in order to complete this element. |
The SQL statements are placed in the Update_Source and Where_Clause fields. For the data to be successfully and correctly updated, these fields must be completed correctly.
A general form for the SQL statement is:
SELECT (update_source) AS column_name FROM table_name A WHERE where_clause |
Such that:
Note: The best way to learn to write Update Source SQL is to find several existing examples and place them into the SELECT statement configuration shown above. |
The example below details how a full Update Source SQL statement is constructed.
The detailed steps for the process are as follows:
After all the configuration is done, when it is time to update Network every year, the system has provided a system to update Network Master out of the box. It includes both “copying management sections into Network Master” and “Run Update Target Table on Network Master”. The system job is named Pavement Analyst: Create and Update Network Master using Management Sections.
Once the Management Sections are created, another similar system job Pavement Analyst: Create and Update Network Master using 0.1-Mile Sections can be used to create 0.1-mile uniform-length sections into Network Master. This can be used to achieve the reporting needs from MAP-21 Act.