Basic datasets needed for a pavement management system to function include:

Pavement Express includes the basic tables and windows for these 3 datasets. As part of the configuration process, the datasets can be expanded to fit different needs, and import routines will be setup to update these datasets on a regular basis.

The Inventory Map window is a one-stop shop that gives user the ability to see what is happening within their road networks. Users  are able to review pavement information and determine roads conditions such as: Problem Spots, PCI Scores, Surface Age, Average Daily Traffic, etc. on the fly.

To access the Inventory Map window, follow these steps:

1. Open the left navigation menu using the hamburger icon
2. Click Asset Inventory
3. Select Inventory Map

Roadway Segment

Roadway Inventory is for storing various roadway characteristics and their locations, such as Functional Class, Number of Lanes, Lane Width, Shoulder Width, etc. The table is named PMSX_SEGMENT, and the corresponding window is located under Pavement Express > Asset Inventory > Roadway Segment menu. For detailed process of navigating in this window, follow this link.

Because Pavement Express does not use LRS, Roadway Segment data is a general dataset (see detailed discussion in System Foundation Configuration Guide) that features all the segments in the network.

The Roadway Segment Import Configuration will include an import routine that allows the user to update the data on a regular basis. To execute the import routine, follow these steps. For more information about Import configuration in the system, see Load Data into Tables.

1. Open the left navigation menu using the hamburger icon
2. Click Setup 
3. Click Data Import 
4. Right-click the PMSX_SEGMENT that matches your segment type - Parking Lot or Roadway
5. Select Edit Config
   
6. In the pop-up window, use Edit Files button to upload the shape file that matches the data structure from Roadway Segment Import Configuration
7. Click Select Source to select the file that was just uploaded
8. Click Import to run the import.
9. When the import has finished, click the Import Log tab to view the results

Pavement Condition

Pavement Condition is for storing the annual pavement condition survey results. The table is named PMSX_CONDITION_SURVEY, and the corresponding window is located under Pavement Express > Asset Performance > Pavement Condition Survey menu. For detailed process of navigating in this window, follow this link.

System can store all the pavement distress defined in ASTM D6433-18: Standard Practice for Roads and Parking Lots Pavement Condition Index Surveys standard, and then calculate Pavement Condition Index (PCI) based on the distress. Alternatively, if the PCI has already been calculated prior to import, the system can import them directly as well.

The Pavement Condition Data Configuration will include an import routine that allows the user to update the data on a regular basis. To execute the import routine, follow these steps. For more information about Import configuration in the system, see Load Data into Tables.

1. Open the left navigation menu using the hamburger icon
2. Click Setup 
3. Click Data Import 
4. Right-click the PMSX_CONDITION_SURVEY Import - Parking Lot or Roadway, depending on data, and select Edit Config.
   
5. In the pop-up window, use Edit Files button to upload the file that matches the data structure from Pavement Condition Data Configuration.
6. Click Select Source button to select the file that was just uploaded.
7. If you haven't imported the new condition data yet, select Append radio button under Import Method:
   
   If you have already imported this year's condition data and want to re-upload a new batch of file it, select Replace radio button under Import Method, and update the Replace Where Clause:
   
8. Click Import to run the import.
9. When the import has finished, click the Import Log tab to view the results.

Calculate PCI

If the PCI has been calculated prior to import, then executing the import above will populate the table with the PCI value.

If the PCI has not been calculated prior to import, then follow these steps after executing the data import:

1. Open the left navigation menu using the hamburger icon
2. Click Asset Performance
   
3. Click Calculated PCI
4. In the Inspection pane in the top left, right-click and select Insert to insert a new inspection and fill in the Year that matches to the data year in the imported condition data. Then click Save.
   
5. Click the waffle icon to open the module menu and select System. Select Tools > System Job > Schedules.
6. In the Schedules window, select Pavement Express: Build Inspection Table from Condition Survey system job.
7. In the Executables pane to the right, right-click the Calculate Pavement Inspection Table based on Condition Survey results executable, and select Define Argument(s). In the pop-up window, select the Inspection that was just created. Click OK.
   
8. Right click the Pavement Express: Build Inspection Table from Condition Survey system job, and select Rub Job. Wait for the job to finish. Text in pop-up window will conclude "...is done." Then click Close.
9. Next, select Pavement Express: Calculate Pavement Condition Index (PCI) in Inspection Table system job. In the right pane, right-click the Calculate Pavement Condition Index (PCI) from Inspection Data executable, and select Define Argument(s). In the pop-up window, select the Inspection that was just created. Click OK.
10. Right-click the Pavement Express: Calculate Pavement Condition Index (PCI) in Inspection Table system job, and select Rub Job. Wait for the job to finish. Text in pop-up window will conclude "...is done." Then click Close.
11. The Pavement Condition Index (PCI) column in Pavement Condition Survey window is now calculated.

Pavement Structure (Construction History)

Pavement Structure (Construction History) is for storing the completed construction projects, their linear locations and material layer information of each construction location. Unlike other dataset, there are 4 system tables used for this function, and the corresponding window can be navigated to by following the steps below:

1. Open the left navigation menu using the hamburger icon
2. Click Asset Inventory
   
3. Click Construction History Overview
   

There are 4 datasets storing the pavement structure data:

• Construction History Project: This dataset stores the project-level information about each construction project and does not store any location information. The Treatment type and Completion Year information is also stored in this table.
• Typical Sections: This dataset stores Typical Sections under each project. A Typical Section is defined as the unique composition of a series of material layers within each project. In other words, within each Typical Section, the material layer compositions are expected to be the same for different locations. Each Typical Section can have multiple locations.
• Locations: This dataset is the segments (from Roadway Segments) included in this typical section.
• Material Layers: This dataset stores the material layer information for each typical section under the project (i.e., Within each Typical Section, the material layer composition is expected to be the same). This is the PMSX_TASBUILT table in the system.