SDDOT_HPMS_Data_specifications_24RFP11610.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- 24RFP11610
- Issued by
- Harding County, South Dakota
About this file
This is a data specification file for a South Dakota Department of Transportation (SDDOT) Highway Performance Monitoring System (HPMS) project, identified as 24RFP11610. The file details 73 different data fields required for highway monitoring and assessment, covering various aspects of roadway infrastructure including system designations, events, and calculated metrics.
The specification outlines multiple data sources including the Roadway Information System (RIS), AASHTOWare Bridge Management system, Deighton Software (dTims), and various sample databases. Key data categories include facility characteristics (lanes, signals, geometry), traffic information (AADT, peak factors), physical conditions (surface type, rutting, cracking), structural elements (median type, shoulder width), and administrative designations (NHS, STRAHNET). The data is sourced from various systems including PC/SQL server systems, Roadware van data collection, Pavement Management, and Accidents Records System databases. Data collection appears to be both automated and manual, with some fields requiring calculation based on other collected data points.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amended SDDOT_HPMS_Requirements_24RFP11610.xlsx | XLSX spreadsheet | |
| SDDOT_HPMS_Data_specifications_24RFP11610.xlsx | XLSX spreadsheet | |
| Response to Offeror Questions document.pdf | ||
| RFP Document.pdf | ||
| SDDOT_HPMS_Costs_24RFP11610.xlsx | XLSX spreadsheet | |
| SDDOT_HPMS_Vendor_Questions_24RFP11610.docx | DOCX document | |
| CSDDOT_HPMS_Requirements_24RFP11610 (002).xlsx | XLSX spreadsheet | |
| RFP Document.pdf | ||
| SDDOT_HPMS_Vendor_Questions_24RFP11610.docx | DOCX document | |
| SDDOT_HPMS_Costs_24RFP11610.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Field List
| State Trunk | NSTRI | |||
| HPMS Item # | Data Name | Data Type | Source | Source |
| 1 | F_SYSTEM | Designations | RIS | NSTRI |
| 2 | URBAN_CODE | Events | RIS | NSTRI |
| 3 | FACILITY_TYPE | Events | Calculated | |
| 4 | Structure_Type | Events | Bridge File | Bridge File |
| 5 | ACCESS_CONTROL | Events | RIS | Calculated |
| 6 | OWNERSHIP | Events | RIS | NSTRI |
| 7 | THROUGH_LANES | Events | RIS | NSTRI |
| 8 | MANAGED LANES OPERATIONS TYPE | Events | Sample Database | Sample Database |
| 9 | MANAGED LANES | Events | Sample Database | Sample Database |
| 10 | PEAK_LANES | Events | Calculated? | NSTRI |
| 11 | COUNTER_PEAK_LANES | Events | Calculated? | Calculated |
| 12 | TURN_LANES_R | Events | Sample Database | Sample Database |
| 13 | TURN_LANES_L | Events | Sample Database | Sample Database |
| 14 | SPEED_LIMIT | Events | RIS | NSTRI |
| 15 | TOLL_ID | Events | Sample Database | Sample Database |
| 16 | TOLL_TYPE | Sample Database | Sample Database | |
| 17 | ROUTE_NUMBER | ID | RIS | NSTRI |
| 18 | ROUTE_SIGNING | RIS | Calculated | |
| 19 | ROUTE_QUALIFIER | RIS | Calculated | |
| 20 | ALTERNATIVE_ROUTE_NAME | Sample Database | Sample Database | |
| 21 | AADT | Events | RIS Traffic | NSTRI |
| 22 | AADT_SINGLE_UNIT | Events | RIS Traffic | Sample Database |
| 23 | PCT_PEAK_SINGLE | Events | RIS Traffic | Sample Database |
| 24 | AADT_COMBINATION | Events | RIS Traffic | Sample Database |
| 25 | PCT_PEAK_COMBINATION | Events | RIS Traffic | Sample Database |
| 26 | K_FACTOR | Events | RIS Traffic | Sample Database |
| 27 | DIR_FACTOR | Events | RIS Traffic | Calculated |
| 28 | FUTURE_AADT | Events | RIS Traffic | Calculated |
| 29 | TYPE_SIGNAL | Events | Sample Database | Sample Database |
| 30 | PCT_GREEN_TIME | Events | Sample Database | Sample Database |
| 31 | NUMBER_SIGNALS | Events | Sample Database | Sample Database |
| 32 | STOP_SIGNS | Events | Sample Database | Sample Database |
| 33 | AT_GRADE_OTHER | Events | Sample Database | Sample Database |
| 34 | LANE_WIDTH | Events | RIS | Calculated |
| 35 | MEDIAN_TYPE | Events | RIS | Sample Database |
| 36 | MEDIAN_WIDTH | Events | RIS | Sample Database |
| 37 | SHOULDER_TYPE | Events | RIS | NSTRI |
| 38 | SHOULDER_WIDTH_R | Events | RIS | Calculated NSTRI |
| 39 | SHOULDER_WIDTH_L | Events | RIS | Calculated NSTRI |
| 40 | PEAK_PARKING | Events | Sample Database | NSTRI |
| 41 | WIDENING_OBSTACLE | Sample Database | Sample Database | |
| 42 | WIDENING_POTENTIAL & OBSTACLE | Events | Sample Database | Sample Database |
| 43 | CURVE_A,B,C,D,E,F | Events | RIS | Sample Database |
| 44 | TERRAIN_TYPE | Events | Sample Database | NSTRI |
| 45 | GRADE_A,B,C,D,E,F | Events | RIS | Sample Database |
| 46 | PCT_PASS_SIGHT | Events | RIS | Sample Database |
| 47 | IRI | Events | RIS | Sample Database |
| 48 | PSR | Events | Sample Database | Sample Database |
| 49 | SURFACE_TYPE | Events | dTims | NSTRI |
| 50 | RUTTING | Events | dTims | Sample Database |
| 51 | FAULTING | Events | dTims | Sample Database |
| 52 | PERCENT_CRACKING | Events | dTims | Sample Database |
| 53 | CRACKING_TRANSVERSE | dTims | Sample Database | |
| 54 | YEAR_LAST_IMPROV | Events | dTims | Sample Database |
| 55 | YEAR_LAST_CONSTRUCTION | Events | dTims | Sample Database |
| 56 | LAST_OVERLAY_THICKNESS | Events | dTims | Sample Database |
| 57 | THICKNESS_RIGID | Events | dTims | Sample Database |
| 58 | THICKNESS_FLEXIBLE | Events | dTims | Sample Database |
| 59 | BASE_TYPE | Events | dTims | Sample Database |
| 60 | BASE_THICKNESS | Events | dTims | Sample Database |
| 61 | CLIMATE_ZONE | FHWA | FHWA | |
| 62 | SOIL_TYPE | Events | FHWA | FHWA |
| 63 | County Code | Events | RIS | |
| 64 | NHS | Designations | RIS | |
| 65 | STRAHNET | Designations | FHWA | FHWA |
| 66 | National Truck Network | Designations | FHWA | FHWA |
| 67 | Future National Highway System | FHWA | FHWA | |
| 68 | Maintenance & Operatons | Events | FHWA | FHWA |
| 69 | Capacity | FHWA | FHWA | |
| 70 | Directional Through Lanes | Events | ||
| 72 | National Highway Freight Network (NHFN) | Designations | ||
| 73 | Is Restricted | Events |
Data Source description RIS Roadway Information System This system is a PC/SQL server system. It consists of the inventory of highway reference markers (MRM) and the other roadway data attributes that are located using these reference markers.
It pulls data from our "Roadware" van data collection system, the Pavement Management and Accidents Records System databases
| RIS Traffic | A sub utility of RIS |
| Calculated | These fields are calculated base on the information in other fields in the submittal |
| Bridge File | This is AASHTOWare's BridgeManagement system |
| Sample Database | This is a database maintained by DOT. Used, as the name implies, for tracking sample road segments |
| dTims | From Deighton Software, this application analyzes pavement data; distress data about pavement that is collected from other applications. This collected data is uploaded annually into dTims pavement management system |
image1.png
File details come from the government source that posted it. Updated .