Attachment A.pdf

PDF 322 KB Posted

Attached to
PAVEMENT DATA COLLECTION State and local contract opportunity
Solicitation number
5400025010
Issued by
Richland County, South Carolina

About this file

Written by GovTribe AI ·

This document is a technical specification file for the South Carolina Department of Transportation (SCDOT) detailing data schemas and collection requirements for pavement assessment and monitoring purposes. The file establishes standardized database field definitions and data input requirements for the Highway Pavement Management and Analysis (HPMA) database system used to track road condition across South Carolina's transportation network.

The document defines four primary data collection schemas: roughness/International Roughness Index (IRI) data, distress data for bituminous and jointed concrete pavements, distress data for continuously reinforced concrete and composite pavements, rater remarks, and image documentation. Each schema specifies required fields including route identification (route code, county number, route type and number, direction), collection parameters (data year, collection date, beginning and ending milepost, lane identification), and pavement condition measurements. Distress data collection is organized by pavement type (bituminous, jointed concrete, continuously reinforced concrete, and bituminous/concrete composite) and categorizes ten distress types by severity levels (low, moderate, high), with measurements reported as percentage area, average rut depth, severity/extent ratings, or occurrence counts depending on distress type. The schema also requires operator identification, rater identification, route segmentation numbers, and supplementary remarks documenting surface conditions such as new pavements or bridge locations.

View the file

Other files for this state and local contract opportunity

Other files attached to PAVEMENT DATA COLLECTION, newest first.
File Type Posted
Amendment 3.pdf PDF
Amendment 1.pdf PDF
Attachment E.pdf PDF
Attachment F.pdf PDF
Amendment 2.pdf PDF
Attachment D.pdf PDF
Attachment C.pdf PDF
Solicitation.pdf PDF
Attachment G.xlsx XLSX spreadsheet
Attachment B.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Table 1 – ROUGHNESS/IRI DATA SCHEMA

HPMA

DATABASE

FIELD

DEFINITION DATA INPUT

HR_ROUTCOD Route Code SCDOT LRS

HR_COUNTY County Number 0-46

HR_CNTYSQ County Sequence

HR_ROUTTYP Route Type I-,US,SC,S-

HR_ROUTNUM Route Number 1-99,999

HR_ROUTAUX Route Auxiliary ALT,BUS,CON… (TTT)

HR_DIRECTN Route Direction N,E,S,W

HR_INTCHG Interchange Number

HR_RAMPID Ramp ID Number

HR_LANEID Lane ID 1,2,3

HR_DATYEAR Data Year YYYY

HR_DATE Data Collection Date YYYY/MM/DD

HR_BEGMILE Route Beginning Milepost 0.000 - 999.999

HR_ENDMILE Route Ending Milepost 0.000 - 999.999

HR_IRI_RT IRI Rt IRI - Right Wheel path

HR_IRI_LT IRI Lt IRI - Left Wheel path

HR_RUT_RT Rut Rt Rutting - Right Wheel path

HR_RUT_LT Rut Lt Rutting - Left Wheel path

HR_PSI SCDOT Pavement Servicability Index Calculated

HR_PSI_OVD Override

HR_SOURCE Source

HR_SPEED Speed

HR_RUT_DL Rut Dual

HR_SLOPE Slope

HR_RUTMAXL Rut Max.L

HR_RUTMAXR Rut Max.R

HR_FAULT Fault Height

HR_HC_IRI Half-Car IRI

HR_SEGNUM Route Segmentation Number

HR_LANES Number of Lanes 1-9

HR_OPNO Operator ID

HR_RATER Rater ID Rater ID/Company ID (TT)

SOFTWARE CALCULATED

REQUIRED DATA

ROUTE/LOCATION/COLLECTION IDENTIFICATION

Table 2 – DISTRESS DATA SCHEMA – Bituminous and Jointed Concrete

BITUMINOUS

(BIT)

JOINTED CONCRETE

(CON)

HC_ROUTCOD Route Code SCDOT LRS SCDOT LRS

HC_COUNTY County Number 0-46 0-46

HC_CNTYSQ County Sequence

HC_ROUTTYP Route Type I-,US,SC,S- I-,US,SC,S-

HC_ROUTNUM Route Number 1-99,999 1-99,999

HC_ROUTAUX Route Auxiliary ALT,BUS,CON… ALT,BUS,CON…

HC_DIRECTN Route Direction N,E,S,W N,E,S,W

HC_INTCHG Interchange Number

HC_RAMPID Ramp ID Number

HC_LANEID Lane ID Number 1,2,3 1,2,3

HC_DATYEAR Data Year YYYY YYYY

HC_DATE Data Collection Date YYYY/MM/DD YYYY/MM/DD

HC_BEGMILE Route Beginning Milepost 0.000 - 999.999 0.000 - 999.999

HC_ENDMILE Route Ending Milepost 0.000 - 999.999 0.000 - 999.999

HC_PAVETYP Pavement Type 1 2

HC_PDI SCDOT Pavemt Distress Index Calculated Calculated

HC_PDI_OVD Index Override

HC_SOURCE Data Source Notes Segments Not Rated (NR) Notes Segments Not Rated (NR)

D_01_S1 Distress 1 - Low Severity Fatigue Cracking - Low Transverse Crack - Low

D_01_S2 Distress 1 - Moderate Severity Fatigue Cracking - Moderate Transverse Crack - Moderate

D_01_S3 Distress 1 - High Severity Fatigue Cracking - High Transverse Crack - High

D_02_S1 Distress 2 - Low Severity Transverse Crack - Low Longitudinal Crk - Low

D_02_S2 Distress 2 - Moderate Severity Transverse Crack - Moderate Longitudinal Crk - Moderate

D_02_S3 Distress 2 - High Severity Transverse Crack - High Longitudinal Crk - High

D_03_S1 Distress 3 - Low Severity Longitudinal Crk - Low Spalling - Low

D_03_S2 Distress 3 - Moderate Severity Longitudinal Crk - Moderate Spalling - Moderate

D_03_S3 Distress 3 - High Severity Longitudinal Crk - High Spalling - High

D_04_S1 Distress 4 - Low Severity Raveling/Weather - Low Faulting - Low

D_04_S2 Distress 4 - Moderate Severity Raveling/Weather - Moderate Faulting - Moderate

D_04_S3 Distress 4 - High Severity Raveling/Weather - High Faulting - High

D_05_S1 Distress 5 - Low Severity Rutting - Low Surface Deterioration - Low

D_05_S2 Distress 5 - Moderate Severity Surface Deterioration - Moderate

D_05_S3 Distress 5 - High Severity Surface Deterioration - High

D_06_S1 Distress 6 - Low Severity Patching - Low Water Pumping - Low

D_06_S2 Distress 6 - Moderate Severity Patching - Moderate. Water Pumping - Moderate

D_06_S3 Distress 6 - High Severity Patching - High Water Pumping - High

D_07_S1 Distress 7 - Low Severity Trans Ck Length - Low Patching - Low

D_07_S2 Distress 7 - Moderate Severity Trans Ck Length - Moderate Patching - Moderate.

D_07_S3 Distress 7 - High Severity Trans Ck Length - High Patching - High

D_08_S1 Distress 8 - Low Severity Punchouts - Low

D_08_S2 Distress 8 - Moderate Severity Punchouts - Moderate

D_08_S3 Distress 8 - High Severity Punchouts - High

D_09_S1 Distress 9 - Low Severity Fault Height - Low

D_09_S2 Distress 9 - Moderate Severity Fault Height - Moderate

D_09_S3 Distress 9 - High Severity Fault Height - High

D_10_S1 Distress 10 - Low Severity Trans Ck Length - Low

D_10_S2 Distress 10 - Moderate Severity Trans Ck Length - Moderate

D_10_S3 Distress 10 - High Severity Trans Ck Length - High

HC_OPNO Operator Number

HC_PDI2 Secondary PDI Calculation

HC_SEGNUM Route Segmentation Number

D_01_INDEX Distress 1 Index Value

D_02_INDEX Distress 1 Index Value

D_03_INDEX Distress 1 Index Value

D_04_INDEX Distress 1 Index Value

D_05_INDEX Distress 1 Index Value

D_06_INDEX Distress 1 Index Value

D_07_INDEX Distress 1 Index Value

D_08_INDEX Distress 1 Index Value

D_09_INDEX Distress 1 Index Value

D_10_INDEX Distress 1 Index Value

HC_LANES Number of Lanes 1-9 1-9

HC_RATER Rater ID Rater ID/Company ID (TT) Rater ID/Company ID (TT)

SOFTWARE CALCULATED

REQUIRED DATA

ROUTE/LOCATION/COLLECTION IDENTIFICATION

HPMA

DATABASE

FIELD

DEFINITION

SURFACE TYPES

Table 3 – DISTRESS DATA SCHEMA – Continuous Concrete and Composite

CONTINOUS REINFORCED

CONCRETE (CRC)

COMPOSITE-

BITUMINOUS/CONCRETE (BOC)

HC_ROUTCOD Route Code SCDOT LRS SCDOT LRS

HC_COUNTY County Number 0-46 0-46

HC_CNTYSQ County Sequence

HC_ROUTTYP Route Type I-,US,SC,S- I-,US,SC,S-

HC_ROUTNUM Route Number 1-99,999 1-99,999

HC_ROUTAUX Route Auxiliary ALT,BUS,CON… ALT,BUS,CON…

HC_DIRECTN Route Direction N,E,S,W N,E,S,W

HC_INTCHG Interchange Number

HC_RAMPID Ramp ID Number

HC_LANEID Lane ID Number 1,2,3 1,2,3

HC_DATYEAR Data Year YYYY YYYY

HC_DATE Data Collection Date YYYY/MM/DD YYYY/MM/DD

HC_BEGMILE Route Beginning Milepost 0.000 - 999.999 0.000 - 999.999

HC_ENDMILE Route Ending Milepost 0.000 - 999.999 0.000 - 999.999

HC_PAVETYP Pavement Type 3 4

HC_PDI SCDOT Pavemt Distress Index Calculated Calculated

HC_PDI_OVD Index Override

HC_SOURCE Data Source Notes Segments Not Rated (NR) Notes Segments Not Rated (NR)

D_01_S1 Distress 1 - Low Severity Transverse Crack - Low Fatigue Cracking - Low

D_01_S2 Distress 1 - Moderate Severity Transverse Crack - Moderate Fatigue Cracking - Moderate

D_01_S3 Distress 1 - High Severity Transverse Crack - High Fatigue Cracking - High

D_02_S1 Distress 2 - Low Severity Longitudinal Crk - Low Transverse Crack - Low

D_02_S2 Distress 2 - Moderate Severity Longitudinal Crk - Moderate Transverse Crack - Moderate

D_02_S3 Distress 2 - High Severity Longitudinal Crk - High Transverse Crack - High

D_03_S1 Distress 3 - Low Severity Spalling - Low Longitudinal Crk - Low

D_03_S2 Distress 3 - Moderate Severity Spalling - Moderate Longitudinal Crk - Moderate

D_03_S3 Distress 3 - High Severity Spalling - High Longitudinal Crk - High

D_04_S1 Distress 4 - Low Severity Faulting - Low Raveling/Weather - Low

D_04_S2 Distress 4 - Moderate Severity Faulting - Moderate Raveling/Weather - Moderate

D_04_S3 Distress 4 - High Severity Faulting - High Raveling/Weather - High

D_05_S1 Distress 5 - Low Severity Surface Deterioration - Low Rutting - Low

D_05_S2 Distress 5 - Moderate Severity Surface Deterioration - Moderate

D_05_S3 Distress 5 - High Severity Surface Deterioration - High

D_06_S1 Distress 6 - Low Severity Water Pumping - Low Patching - Low

D_06_S2 Distress 6 - Moderate Severity Water Pumping - Moderate Patching - Moderate.

D_06_S3 Distress 6 - High Severity Water Pumping - High Patching - High

D_07_S1 Distress 7 - Low Severity Patching - Low Trans Ck Length - Low

D_07_S2 Distress 7 - Moderate Severity Patching - Moderate. Trans Ck Length - Moderate

D_07_S3 Distress 7 - High Severity Patching - High Trans Ck Length - High

D_08_S1 Distress 8 - Low Severity Punchouts - Low

D_08_S2 Distress 8 - Moderate Severity Punchouts - Moderate

D_08_S3 Distress 8 - High Severity Punchouts - High

D_09_S1 Distress 9 - Low Severity Trans Ck Length - Low

D_09_S2 Distress 9 - Moderate Severity Trans Ck Length - Moderate

D_09_S3 Distress 9 - High Severity Trans Ck Length - High

D_10_S1 Distress 10 - Low Severity

D_10_S2 Distress 10 - Moderate Severity

D_10_S3 Distress 10 - High Severity

HC_OPNO Operator Number

HC_PDI2 Secondary PDI Calculation

HC_SEGNUM Route Segmentation Number

D_01_INDEX Distress 1 Index Value

D_02_INDEX Distress 1 Index Value

D_03_INDEX Distress 1 Index Value

D_04_INDEX Distress 1 Index Value

D_05_INDEX Distress 1 Index Value

D_06_INDEX Distress 1 Index Value

D_07_INDEX Distress 1 Index Value

D_08_INDEX Distress 1 Index Value

D_09_INDEX Distress 1 Index Value

D_10_INDEX Distress 1 Index Value

HC_LANES Number of Lanes 1-9 1-9

HC_RATER Rater ID Rater ID/Company ID (TT) Rater ID/Company ID (TT)

SURFACE TYPE

SOFTWARE CALCULATED

REQUIRED DATA

ROUTE/LOCATION/COLLECTION IDENTIFICATION

HPMA DATABASE

FIELD

DEFINITION

Table 4 – Distress Collection by Pavement Type Distress

Number Distress Type Reporting

1 Fatigue Cracking % Area

2 Transverse Cracking % Area

3 Longitudinal Cracking % Area

4 Raveling/Weathering % Area

5 Rutting Avg. Rut

6 Patching % Area

7 Transverse Crack Length Value

1 Transverse Cracking % Slabs

2 Longitudinal Cracking % Slabs

3 Spalling % Slabs

4 Faulting Severity/Extent

5 Surface Deterioration % Area

6 Water Pumping Severity/Extent

7 Patching % Area

8 Punchouts Severity/Occurance

9 Fault Height Value

10 Transverse Crack Length Value

1 Transverse Cracking % Slabs

2 Longitudinal Cracking % Slabs

3 Spalling % Slabs

4 Faulting Severity/Extent

5 Surface Deterioration % Area

6 Water Pumping Severity/Extent

7 Patching % Area

8 Punchouts Severity/Occurance

9 Transverse Crack Length Value

1 Fatigue Cracking % Area

2 Transverse Cracking % Area

3 Longitudinal Cracking % Area

4 Raveling/Weathering % Area

5 Rutting Avg. Rut

6 Patching % Area

7 Transverse Crack Length Value

1 - Bituminous (BIT)

2 - Jointed Concrete (CON)

3 - Continuously Reinforced Concrete (CRC)

4 - Bituminous/Concrete Composite (BOC)

Table 5 – RATER REMARKS DATA SCHEMA

HPMA

DATABASE

FIELD

DEFINITION DATA INPUT

HR_ROUTCOD Route Code SCDOT LRS

HR_COUNTY County Number 0-46

HR_CNTYSQ County Sequence

HR_ROUTTYP Route Type I-,US,SC,S-

HR_ROUTNUM Route Number 1-99,999

HR_ROUTAUX Route Auxiliary ALT,BUS,CON… (TTT)

HR_DIRECTN Route Direction N,E,S,W

HR_INTCHG Interchange Number

HR_RAMPID Ramp ID Number

HR_LANEID Lane ID 1,2,3

HR_DATYEAR Data Year YYYY

HR_DATE Data Collection Date YYYY/MM/DD

HR_BEGMILE Route Beginning Milepost 0.000 - 999.999

HR_ENDMILE Route Ending Milepost 0.000 - 999.999

HC_REMARKS Rater Comments New Surface,Bridge….

HR_SEGNUM Route Segmentation Number

ROUTE/LOCATION/COLLECTION IDENTIFICATION

SOFTWARE CALCULATED

Table 6 – IMAGE SCHEMA

HPMA

DATABASE

FIELD

DEFINITION DATA INPUT

HR_ROUTCOD Route Code SCDOT LRS

RA_COUNTY County Number 0-46

RA_ROUTTYP Route Type I-,US,SC,S-

RA_ROUTNUM Route Number 1-99,999

RA_ROUTAUX Route Auxiliary ALT,BUS,CON… (TTT)

RA_DIRECTN Route Direction N,E,S,W

RA_BEGMILE Image Location Mile Point 0.000 - 999.999

RA_YEAR Data Year YYYY

RA_DATE Data Collection Date YYYY/MM/DD

RA_LANE Lane ID 1,2,3

RA_IMGTYPE Image Type

RA_FOLDER Image Folder \SYSTEM\LRS\

RA_FILENAM File Name LRS&MP

ASSETNUM Asset Type

MULTI_KEY Multi Occur Key

ASSET_ID Asset ID

LAT Latitude 34.0000000

LONG Longitude -81.0000000

ROUTE/LOCATION/COLLECTION IDENTIFICATION

File details come from the government source that posted it. Updated .