Roadway Inventory is for storing various roadway characteristics and their locations, such as Functional Class, Number of Lanes, Lane Width, Shoulder Width, etc. Out of the box, the table is named PMSX_SEGMENT, and the corresponding window can be navigated to by clicking Asset Inventory and selecting Roadway Segment or Pavement Segment from the drop-down menu.
Out of the box, the table has these columns:
| Column Label | Column Name | Data Type | Required to Run PMS at Minimum | Description | Import Source Shape File Header | Import Source Shape File Data Type |
|---|---|---|---|---|---|---|
| Segment ID | PMSX_SEGMENT_ID | Integer | Y | ID used through out the system to identify each segment. Primary Key of the table. | SEG_ID | Long Integer |
| Segment Name | SEGMENT_NAME | String | If there is a name assigned to the segment | SEG_NAME | Text | |
| Segment Sequence | SEGMENT_SEQUENCE | String | Allows the system to sort the segment | SEG_SEQ | Long Integer | |
| Segment Strength | SEGMENT_STRENGTH | String | SEG_STR | |||
| Segment Thickness | SEGMENT_THICKNESS | String | SEG_THC | |||
| Road Name | ROAD_NAME | String | Street/Road name of the segment | ROAD_NAME | Text | |
| From Description | DESCRIPTION_FROM | String | Begin description of the segment | DESCR_FROM | Text | |
| To Description | DESCRIPTION_TO | String | End description of the segment | DESCR_TO | Text | |
| Start Distance | DISTANCE_START | Number (22,3) | Begin distance measure of the segment | DIST_START | Double | |
| End Distance | DISTANCE_END | Number (22,3) | End distance measure of the segment | DIST_END | Double | |
| Start Latitude | LATITUDE_START | Number (22,9) | Begin latitude of the segment | START_LAT | Double | |
| Start Longitude | LONGITUDE_START | Number (22,9) | Begin longitude of the segment | START_LONG | Double | |
| End Latitude | LATITUDE_END | Number (22,9) | End latitude of the segment | END_LAT | Double | |
| End Longitude | LONGITUDE_END | Number (22,9) | End longitude of the segment | END_LONG | Double | |
| AADT | AADT | Integer | Y | AADT on the segment | AADT | Long Integer |
| Length | LENGTH | Number (22,3) | Y | Length of the segment | LENGTH | Double |
| Number of Lanes | NUMBER_OF_LANES | Integer | Number of lanes on the segment | NUM_LANES | Long Integer | |
| Lane Miles | LANE_MILES | Number (22,3) | Y | Lane-miles of the segment | LANE_MILES | Double |
| Segment Area | SEGMENT_AREA | Number (22,3) | Segment area | SEG_AREA | Double | |
| Lane Width (Per Lane) | PER_LANE_WIDTH | Number (22,3) | Per lane width | PER_LN_WID | Double | |
| Shoulder Width | SHOULDER_WIDTH | Number (22,3) | Shoulder width | SHLDR_WID | Double | |
| Segment Width | SEGMENT_WIDTH | Number (22,3) | Segment width in total | SEG_WID | Double | |
| Percent Truck | PCT_TRUCK | Number (22,2) | Truck percentage | PCT_TRUCK | Double | |
| Last Rehab Year | YEAR_LAST_REHAB | Integer | Last year of rehabilitation on the segment | YEAR_REHAB | Long Integer | |
| Last Preventive Maintenance Year | YEAR_LAST_PM | Integer | Last year of preventive treatment on the segment | YEAR_PM | Long Integer | |
| Address: Left Side From | ADDRESS_LEFT_FROM | Integer | Left side of the segment: Begin address | ADDR_L_FRO | Double | |
| Address: Left Side To | ADDRESS_LEFT_TO | Integer | Left side of the segment: End address | ADDR_L_TO | Double | |
| Address: Right Side From | ADDRESS_RIGHT_FROM | Integer | Right side of the segment: Begin address | ADDR_R_FRO | Double | |
| Address: Right Side To | ADDRESS_RIGHT_TO | Integer | Right side of the segment: End address | ADDR_R_TO | Double | |
| Address: From | ADDRESS_FROM | Integer | Segment Begin Address | ADDR_FROM | Double | |
| Address: To | ADDRESS_TO | String | Segment End Address | ADDR_TO | Double | |
| Zip Code | ZIP_CODE | String | Zip code | ZIP_CODE | Text | |
| City | CITY_ID | Integer | City | CITY | Text | |
| County | COUNTY_ID | Integer | County | COUNTY | Text | |
| Maintenance Jurisdiction | MAINTENANCE_JUR_ID | Integer | Maintenance Jurisdiction | JURIS | Text | |
| NHS Type | NHS_TYPE_ID | Integer | NHS Designation | NHS | Text | |
| Functional Class | FUNCTIONAL_CLASS_ID | Integer | Y | Functional Class | FC | Text |
| Pavement Type | WC_ID | Integer | Y | Pavement Type | PVT_TYPE | Text |
| One-way Street? | ONEWAY | Integer | Whether the segment is one-way | ONEWAY | Text | |
| Divided Street (median) | DIVIDED | Integer | Whether the segment is divided (with a median) | DIVIDED | Text | |
| Comment | COMMENT_STR | String | Comment | |||
| User Update | USER_UPDATE | Integer | Last update user | |||
| Date Update | DATE_UPDATE | Date | Last update date/time | |||
| Geometry | GEOM | Geometry | Geometry. Hidden from the window. | SHAPE | Geometry |
Import Data
The next step of configuring Roadway Inventory data is to create an import routine (often called Import Configuration in AgileAssets system), and load the data into the table. An Import Configuration includes the following:
- Specify data source
- Specify rules of import (e.g., how existing data is imported)
- Column mapping and data conversion
Out of the box, a standard import using SHAPE file (*.shp) has been configured that matches the PMSX_SEGMENT configuration. The file specification and column mapping is detailed in the table above.
If there is client-specific configuration to PMSX_SEGMENT table to track additional roadway segment data, the template can be expanded to include those fields. In addition, the following objects needs to be updated to reflect those changes to ensure all the steps in the import are running correctly:
- PMSX_SEGMENT table and window
- Import configuration into the PMSX_SEGMENT table
Preferably, if additional import is needed, the import configuration should be setup in a way so that the next time when data needs to be updated, it will simply read the new data source and run the same import configuration. Occasionally, the initial data load and on-going data import use different data sources, and therefore separate import configurations have to be created.
To update an Import Configuration or update the existing one, follow the instruction detailed in Import Data into Tables.
After running the import, the system will have a populated table and the window will display the corresponding data.
