Skip to end of metadata
Go to start of metadata

Pavement Condition is for storing the annual pavement distress survey results and their locations. Out of the box, the table is named PMSX_CONDITION_SURVEY, and the corresponding window can be navigated to by following the steps below:

  1. Click Asset Performance 
  2. Select Pavement Condition Survey in the drop-down menu

The biggest feature of the Pavement Condition data that the condition data has an EFF_YEAR (Year) column, to record data from each data year, and some additional out-of-the-box pavement condition columns.

Out of the box, the datasets has these columns:

OrderColumn LabelColumn NameData TypeRequired to Run PMS at MinimumImport Source File Header (csv)Description
1PMS Condition Survey IDPMSX_CONDITION_SURVEY_IDInteger

System generated ID value for the table.
2YearEFF_YEARIntegerYYEARYear of the data
3Segment IDPMSX_SEGMENT_IDIntegerYSEGMENT_IDSegment ID
4Inspection Sample IDINSP_SAMPLE_IDIntegerYINSPECTION_SAMPLE_IDSample ID of the inspection
5File NameFILE_NAMEString
FILE_NAMEFile name
6Inspection DateINSPECTION_DATEDate
INSPECTION_DATE;Inspection Date, format dd-MMM-yy
7Inspection LengthINSPECTION_LENGTHNumber (22,3)
INSPECTION_LENGTHInspection Length
8Inspection WidthINSPECTION_WIDTHNumber (22,3)
INSPECTION_WIDTHInspection Width
9Inspection AreaINSPECTION_AREANumber (22,3)
INSPECTION_AREAInspection Area
10Length (Measured)LENGTH_MEASUREDNumber (22,3)
LENGTH_MEASUREDMeasured Length
11LaneLANE_IDInteger
LANEInspection Lane
12DirectionDIRECTIONString
DIRECTIONTravel Direction
13Start LongitudeLONGITUDE_STARTNumber (22,9)
LONGITUDE_STARTInspection area start longitude
14Start LatitudeLATITUDE_STARTNumber (22,9)
LATITUDE_STARTInspection area start latitude
15End LongitudeLONGITUDE_ENDNumber (22,9)
LONGITUDE_ENDInspection area end longitude
16End LatitudeLATITUDE_ENDNumber (22,9)
LATITUDE_ENDInspection area end latitude
17Pavement Condition Index (PCI)PMS_PCI_INDEXNumber (22,2)
PMS_PCI_INDEX

Pavement Condition Index

NOTE: System can either use the imported PCI value, or calculate PCI based on the distress value imported. See User Manual for detals.

18IRI (Left Wheelpath)PMS_IRI_LEFTNumber (22,2)
PMS_IRI_LEFTIRI - Left Wheelpath
19IRI (Right Wheelpath)PMS_IRI_RIGHTNumber (22,2)
PMS_IRI_RIGHTIRI - Right Wheelpath
20IRIPMS_IRI_VALUENumber (22,2)
PMS_IRI_VALUEAverage IRI
21Rutting (Left Wheelpath)PMS_RUTTING_LEFTNumber (22,2)
PMS_RUTTING_LEFTRutting - Left Wheelpath
22Rutting (Right Wheelpath)PMS_RUTTING_RIGHTNumber (22,2)
PMS_RUTTING_RIGHTRutting - Right Wheelpath
23RuttingPMS_RUTTING_VALUENumber (22,2)
PMS_RUTTING_VALUEAverage Rutting
24Pavement TypeWC_IDInteger
PAVEMENT_TYPEPavement Type
25AC Alligator Cracking LowAC_ALLIGATOR_CRACKING_Lnumeric
AC_ALLIGATOR_CRACKING_LAC Alligator Cracking Low
26AC Alligator Cracking MedAC_ALLIGATOR_CRACKING_Mnumeric
AC_ALLIGATOR_CRACKING_MAC Alligator Cracking Med
27AC Alligator Cracking HighAC_ALLIGATOR_CRACKING_Hnumeric
AC_ALLIGATOR_CRACKING_HAC Alligator Cracking High
28AC Bleeding LowAC_BLEEDING_Lnumeric
AC_BLEEDING_LAC Bleeding Low
29AC Bleeding MedAC_BLEEDING_Mnumeric
AC_BLEEDING_MAC Bleeding Med
30AC Bleeding HighAC_BLEEDING_Hnumeric
AC_BLEEDING_HAC Bleeding High
31AC Block Cracking LowAC_BLOCK_CRACKING_Lnumeric
AC_BLOCK_CRACKING_LAC Block Cracking Low
32AC Block Cracking MedAC_BLOCK_CRACKING_Mnumeric
AC_BLOCK_CRACKING_MAC Block Cracking Med
33AC Block Cracking HighAC_BLOCK_CRACKING_Hnumeric
AC_BLOCK_CRACKING_HAC Block Cracking High
34AC Bumps and Sags LowAC_BUMPS_AND_SAGS_Lnumeric
AC_BUMPS_AND_SAGS_LAC Bumps and Sags Low
35AC Bumps and Sags MedAC_BUMPS_AND_SAGS_Mnumeric
AC_BUMPS_AND_SAGS_MAC Bumps and Sags Med
36AC Bumps and Sags HighAC_BUMPS_AND_SAGS_Hnumeric
AC_BUMPS_AND_SAGS_HAC Bumps and Sags High
37AC Corrugation LowAC_CORRUGATION_Lnumeric
AC_CORRUGATION_LAC Corrugation Low
38AC Corrugation MedAC_CORRUGATION_Mnumeric
AC_CORRUGATION_MAC Corrugation Med
39AC Corrugation HighAC_CORRUGATION_Hnumeric
AC_CORRUGATION_HAC Corrugation High
40AC Depression LowAC_DEPRESSION_Lnumeric
AC_DEPRESSION_LAC Depression Low
41AC Depression MedAC_DEPRESSION_Mnumeric
AC_DEPRESSION_MAC Depression Med
42AC Depression HighAC_DEPRESSION_Hnumeric
AC_DEPRESSION_HAC Depression High
43AC Edge Cracking LowAC_EDGE_CRACKING_Lnumeric
AC_EDGE_CRACKING_LAC Edge Cracking Low
44AC Edge Cracking MedAC_EDGE_CRACKING_Mnumeric
AC_EDGE_CRACKING_MAC Edge Cracking Med
45AC Edge Cracking HighAC_EDGE_CRACKING_Hnumeric
AC_EDGE_CRACKING_HAC Edge Cracking High
46AC Joint Reflection Cracking LowAC_JT_REFLECT_CRACKING_Lnumeric
AC_JT_REFLECT_CRACKING_LAC Joint Reflection Cracking Low
47AC Joint Reflection Cracking MedAC_JT_REFLECT_CRACKING_Mnumeric
AC_JT_REFLECT_CRACKING_MAC Joint Reflection Cracking Med
48AC Joint Reflection Cracking HighAC_JT_REFLECT_CRACKING_Hnumeric
AC_JT_REFLECT_CRACKING_HAC Joint Reflection Cracking High
49AC Lane Shoulder Drop Off LowAC_LN_SHLDR_DROPOFF_Lnumeric
AC_LN_SHLDR_DROPOFF_LAC Lane Shoulder Drop Off Low
50AC Lane Shoulder Drop Off MedAC_LN_SHLDR_DROPOFF_Mnumeric
AC_LN_SHLDR_DROPOFF_MAC Lane Shoulder Drop Off Med
51AC Lane Shoulder Drop Off HighAC_LN_SHLDR_DROPOFF_Hnumeric
AC_LN_SHLDR_DROPOFF_HAC Lane Shoulder Drop Off High
52AC Long Cracking LowAC_LONG_CRACKING_Lnumeric
AC_LONG_CRACKING_LAC Long Cracking Low
53AC Long Cracking MedAC_LONG_CRACKING_Mnumeric
AC_LONG_CRACKING_MAC Long Cracking Med
54AC Long Cracking HighAC_LONG_CRACKING_Hnumeric
AC_LONG_CRACKING_HAC Long Cracking High
55AC Trans Cracking LowAC_TRANS_CRACKING_Lnumeric
AC_TRANS_CRACKING_LAC Trans Cracking Low
56AC Trans Cracking MedAC_TRANS_CRACKING_Mnumeric
AC_TRANS_CRACKING_MAC Trans Cracking Med
57AC Trans Cracking HighAC_TRANS_CRACKING_Hnumeric
AC_TRANS_CRACKING_HAC Trans Cracking High
58AC Long Trans Cracking LowAC_LONG_TRANS_CRACKING_Lnumeric
AC_LONG_TRANS_CRACKING_LAC Long Trans Cracking Low
59AC Long Trans Cracking MedAC_LONG_TRANS_CRACKING_Mnumeric
AC_LONG_TRANS_CRACKING_MAC Long Trans Cracking Med
60AC Long Trans Cracking HighAC_LONG_TRANS_CRACKING_Hnumeric
AC_LONG_TRANS_CRACKING_HAC Long Trans Cracking High
61AC Patching and Util Crack Patching LowAC_PATCHING_Lnumeric
AC_PATCHING_LAC Patching and Util Crack Patching Low
62AC Patching and Util Crack Patching MedAC_PATCHING_Mnumeric
AC_PATCHING_MAC Patching and Util Crack Patching Med
63AC Patching and Util Crack Patching HighAC_PATCHING_Hnumeric
AC_PATCHING_HAC Patching and Util Crack Patching High
64AC Polished AggregateAC_POLISHED_AGGRGATEnumeric
AC_POLISHED_AGGRGATEAC Polished Aggregate
65AC Potholes LowAC_POTHOLES_Lnumeric
AC_POTHOLES_LAC Potholes Low
66AC Potholes MedAC_POTHOLES_Mnumeric
AC_POTHOLES_MAC Potholes Med
67AC Potholes HighAC_POTHOLES_Hnumeric
AC_POTHOLES_HAC Potholes High
68AC Railroad Crossing LowAC_RR_CROSSING_Lnumeric
AC_RR_CROSSING_LAC Railroad Crossing Low
69AC Railroad Crossing MedAC_RR_CROSSING_Mnumeric
AC_RR_CROSSING_MAC Railroad Crossing Med
70AC Railroad Crossing HighAC_RR_CROSSING_Hnumeric
AC_RR_CROSSING_HAC Railroad Crossing High
71AC Rutting HighAC_RUTTING_Hnumeric
AC_RUTTING_HAC Rutting High
72AC Rutting LowAC_RUTTING_Lnumeric
AC_RUTTING_LAC Rutting Low
73AC Rutting MedAC_RUTTING_Mnumeric
AC_RUTTING_MAC Rutting Med
74AC Shoving LowAC_SHOVING_Lnumeric
AC_SHOVING_LAC Shoving Low
75AC Shoving MedAC_SHOVING_Mnumeric
AC_SHOVING_MAC Shoving Med
76AC Shoving HighAC_SHOVING_Hnumeric
AC_SHOVING_HAC Shoving High
77AC Slippage Cracking HighAC_SLIPPAGE_CRACKING_Hnumeric
AC_SLIPPAGE_CRACKING_HAC Slippage Cracking High
78AC Slippage Cracking LowAC_SLIPPAGE_CRACKING_Lnumeric
AC_SLIPPAGE_CRACKING_LAC Slippage Cracking Low
79AC Slippage Cracking MedAC_SLIPPAGE_CRACKING_Mnumeric
AC_SLIPPAGE_CRACKING_MAC Slippage Cracking Med
80AC Swell HighAC_SWELL_Hnumeric
AC_SWELL_HAC Swell High
81AC Swell LowAC_SWELL_Lnumeric
AC_SWELL_LAC Swell Low
82AC Swell MedAC_SWELL_Mnumeric
AC_SWELL_MAC Swell Med
83AC Raveling HighAC_RAVELING_Hnumeric
AC_RAVELING_HAC Raveling High
84AC Raveling LowAC_RAVELING_Lnumeric
AC_RAVELING_LAC Raveling Low
85AC Raveling MedAC_RAVELING_Mnumeric
AC_RAVELING_MAC Raveling Med
86AC Weathering (Surface Wear) HighAC_WEATHERING_Hnumeric
AC_WEATHERING_HAC Weathering (Surface Wear) High
87AC Weathering (Surface Wear) LowAC_WEATHERING_Lnumeric
AC_WEATHERING_LAC Weathering (Surface Wear) Low
88AC Weathering (Surface Wear) MedAC_WEATHERING_Mnumeric
AC_WEATHERING_MAC Weathering (Surface Wear) Med
89PCC Blow up Buckling LowPCC_BLOWUP_BUCKLING_LInteger
PCC_BLOWUP_BUCKLING_LPCC Blow up Buckling Low
90PCC Blow up Buckling MedPCC_BLOWUP_BUCKLING_MInteger
PCC_BLOWUP_BUCKLING_MPCC Blow up Buckling Med
91PCC Blow up Buckling HighPCC_BLOWUP_BUCKLING_HInteger
PCC_BLOWUP_BUCKLING_HPCC Blow up Buckling High
92PCC Corner Break LowPCC_CORNER_BREAK_LInteger
PCC_CORNER_BREAK_LPCC Corner Break Low
93PCC Corner Break MedPCC_CORNER_BREAK_MInteger
PCC_CORNER_BREAK_MPCC Corner Break Med
94PCC Corner Break HighPCC_CORNER_BREAK_HInteger
PCC_CORNER_BREAK_HPCC Corner Break High
95PCC Divided Slab LowPCC_DIVIDED_SLAB_LInteger
PCC_DIVIDED_SLAB_LPCC Divided Slab Low
96PCC Divided Slab MedPCC_DIVIDED_SLAB_MInteger
PCC_DIVIDED_SLAB_MPCC Divided Slab Med
97PCC Divided Slab HighPCC_DIVIDED_SLAB_HInteger
PCC_DIVIDED_SLAB_HPCC Divided Slab High
98PCC Durability Crack LowPCC_DURABILITY_CRACK_LInteger
PCC_DURABILITY_CRACK_LPCC Durability Crack Low
99PCC Durability Crack MedPCC_DURABILITY_CRACK_MInteger
PCC_DURABILITY_CRACK_MPCC Durability Crack Med
100PCC Durability Crack HighPCC_DURABILITY_CRACK_HInteger
PCC_DURABILITY_CRACK_HPCC Durability Crack High
101PCC Faulting LowPCC_FAULTING_LInteger
PCC_FAULTING_LPCC Faulting Low
102PCC Faulting MedPCC_FAULTING_MInteger
PCC_FAULTING_MPCC Faulting Med
103PCC Faulting HighPCC_FAULTING_HInteger
PCC_FAULTING_HPCC Faulting High
104PCC Joint Seal LowPCC_JOINT_SEAL_Lnumeric
PCC_JOINT_SEAL_LPCC Joint Seal Low
105PCC Joint Seal MedPCC_JOINT_SEAL_Mnumeric
PCC_JOINT_SEAL_MPCC Joint Seal Med
106PCC Joint Seal HighPCC_JOINT_SEAL_Hnumeric
PCC_JOINT_SEAL_HPCC Joint Seal High
107PCC Lane Shoulder LowPCC_LANE_SHOULDER_Lnumeric
PCC_LANE_SHOULDER_LPCC Lane Shoulder Low
108PCC Lane Shoulder MedPCC_LANE_SHOULDER_Mnumeric
PCC_LANE_SHOULDER_MPCC Lane Shoulder Med
109PCC Lane Shoulder HighPCC_LANE_SHOULDER_Hnumeric
PCC_LANE_SHOULDER_HPCC Lane Shoulder High
110PCC Linear Cracking LowPCC_LINEAR_CRACKING_LInteger
PCC_LINEAR_CRACKING_LPCC Linear Cracking Low
111PCC Linear Cracking MedPCC_LINEAR_CRACKING_MInteger
PCC_LINEAR_CRACKING_MPCC Linear Cracking Med
112PCC Linear Cracking HighPCC_LINEAR_CRACKING_HInteger
PCC_LINEAR_CRACKING_HPCC Linear Cracking High
113PCC Patching Large LowPCC_PATCHING_LARGE_LInteger
PCC_PATCHING_LARGE_LPCC Patching Large Low
114PCC Patching Large MedPCC_PATCHING_LARGE_MInteger
PCC_PATCHING_LARGE_MPCC Patching Large Med
115PCC Patching Large HighPCC_PATCHING_LARGE_HInteger
PCC_PATCHING_LARGE_HPCC Patching Large High
116PCC Patching Small LowPCC_PATCHING_SMALL_LInteger
PCC_PATCHING_SMALL_LPCC Patching Small Low
117PCC Patching Small MedPCC_PATCHING_SMALL_MInteger
PCC_PATCHING_SMALL_MPCC Patching Small Med
118PCC Patching Small HighPCC_PATCHING_SMALL_HInteger
PCC_PATCHING_SMALL_HPCC Patching Small High
119PCC Polished AggregatePCC_POLISHED_AGGRGATEInteger
PCC_POLISHED_AGGRGATEPCC Polished Aggregate
120PCC PopoutsPCC_POPOUTSnumeric
PCC_POPOUTSPCC Popouts
121PCC PumpingPCC_PUMPINGInteger
PCC_PUMPINGPCC Pumping
122PCC Punchout LowPCC_PUNCHOUT_LInteger
PCC_PUNCHOUT_LPCC Punchout Low
123PCC Punchout MedPCC_PUNCHOUT_MInteger
PCC_PUNCHOUT_MPCC Punchout Med
124PCC Punchout HighPCC_PUNCHOUT_HInteger
PCC_PUNCHOUT_HPCC Punchout High
125PCC Railroad Crossing LowPCC_RR_CROSSING_LInteger
PCC_RR_CROSSING_LPCC Railroad Crossing Low
126PCC Railroad Crossing MedPCC_RR_CROSSING_MInteger
PCC_RR_CROSSING_MPCC Railroad Crossing Med
127PCC Railroad Crossing HighPCC_RR_CROSSING_HInteger
PCC_RR_CROSSING_HPCC Railroad Crossing High
128PCC Scaling LowPCC_SCALING_LInteger
PCC_SCALING_LPCC Scaling Low
129PCC Scaling MedPCC_SCALING_MInteger
PCC_SCALING_MPCC Scaling Med
130PCC Scaling HighPCC_SCALING_HInteger
PCC_SCALING_HPCC Scaling High
131PCC ShrinkagePCC_SHRINKAGEInteger
PCC_SHRINKAGEPCC Shrinkage
132PCC Spalling Joint LowPCC_SPALLING_JOINT_LInteger
PCC_SPALLING_JOINT_LPCC Spalling Joint Low
133PCC Spalling Joint MedPCC_SPALLING_JOINT_MInteger
PCC_SPALLING_JOINT_MPCC Spalling Joint Med
134PCC Spalling Joint HighPCC_SPALLING_JOINT_HInteger
PCC_SPALLING_JOINT_HPCC Spalling Joint High
135PCC Spalling Corner LowPCC_SPALLING_CORNER_LInteger
PCC_SPALLING_CORNER_LPCC Spalling Corner Low
136PCC Spalling Corner MedPCC_SPALLING_CORNER_MInteger
PCC_SPALLING_CORNER_MPCC Spalling Corner Med
137PCC Spalling Corner HighPCC_SPALLING_CORNER_HInteger
PCC_SPALLING_CORNER_HPCC Spalling Corner High
138Slab CountSLAB_COUNTInteger
SLAB_COUNTSlab count
139Lane DeviationLANE_DEVInteger
LANE_DEVLane Deviation flag (1 or 0)
140ConstructionCONSTRUCTIONInteger
CONSTRUCTIONConstruction flag (1 or 0)
141BridgeBRIDGEInteger
BRIDGEBridge flag (1 or 0)
142Rail Road CrossingRR_CROSSINGInteger
RR_CROSSINGRail road crossing flag (1 or 0)
143CommentsCOMMENT_STRString
COMMENT_STR
144Operator 1OPERATOR_1String
OPERATOR_1Operator 1
145Operator 2OPERATOR_2String
OPERATOR_2Operator 2
146User UpdateUSER_UPDATEString


147Date UpdateDATE_UPDATEdate


148GeometryGEOMGeometry


Table and Window Configuration

The configuration of this dataset starts by expanding the PMSX_CONDITION_SURVEY table structure to include customer-specific pavement condition data collected in the survey, such as block cracking, cracking extent and/or severity from different zones, bleeding, etc.

Similar to Roadway Inventory data, when adding columns to the table, pay special attention to the type of data to be added: Is it List or Simple Value. Then, follow the instruction detailed in Create and Import Lookup Values and Add Columns to a Table and add them into the PMSX_CONDITION_SURVEY table.

After all the columns have been added to the table, follow the instruction detailed in Add Columns to a Data Window to add those columns to the window.

At this point, the system will have an empty PMSX_CONDITION_SURVEY table and the window will display an empty dataset.

Import Data

The next step is to create an Import Configuration, and load the data into the table. Follow the instruction detailed in Load Data into Tables to create the import on pavement condition table.

Out of the box, a standard import using csv file has been configured that matches the PMSX_CONDITION_SURVEY table configuration. It uses a csv file. The file specification and column mapping is detailed in the table above.

If there is client-specific configuration to PMSX_CONDITION_SURVEY to track additional pavement condition data element, 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_CONDITION_SURVEY table and window
  • Import configuration into the PMSX_CONDITION_SURVEY table

The guideline for updating or creating additional import configuration is similar to roadway inventory data. One difference is that most of the time, when updating roadway inventory data, you would replace the entire dataset because roadway inventory is not differentiated by year, whereas for condition data, you will only import (or replace) the data with a specific year (or latest year), and leave the historical data untouched. This can be achieved by specifying a Replace Where Clause in the import Configuration, for example:

EFF_YEAR=2019

After running the import, the system will have a populated PMSX_CONDITION_SURVEY table and the window will display the corresponding data.

  • No labels