SDDOT_HPMS_Data_specifications_24RFP11610.xlsx

21 KB Posted

Attached to
Highway Performance Monitoring System Reporting Tool
Solicitation number
24RFP11610
Issued by
Harding County, South Dakota

About this file

Written by GovTribe AI ·

This is a data specifications file from the South Dakota Department of Transportation (SDDOT) detailing the required fields and data sources for Highway Performance Monitoring System (HPMS) reporting. The file contains a comprehensive list of 73 data fields that must be tracked and reported, including information about road facilities, traffic patterns, infrastructure conditions, and various highway designations. The data is sourced from multiple systems including the Roadway Information System (RIS), Bridge Files, Sample Databases, and dTims pavement management system.

The specification details the primary data sources used by SDDOT, including their PC/SQL server system for highway reference markers, the Roadware van data collection system, AASHTOWare's BridgeManagement system, and Deighton Software's dTims for pavement analysis. The data fields cover various categories including road characteristics (lanes, signals, width), traffic data (AADT, peak factors), infrastructure condition (IRI, rutting, cracking), and administrative designations (NHS, STRAHNET, county codes). This specification appears to be part of RFP #24RFP11610 for acquiring HPMS Management Software to replace SDDOT's current in-house program.

View the file

Other files

File Type Posted
Amended SDDOT_HPMS_Requirements_24RFP11610.xlsx XLSX spreadsheet
RFP Document.pdf PDF
SDDOT_HPMS_Costs_24RFP11610.xlsx XLSX spreadsheet
SDDOT_HPMS_Vendor_Questions_24RFP11610.docx DOCX document
Response to Offeror Questions document.pdf PDF
CSDDOT_HPMS_Requirements_24RFP11610 (002).xlsx XLSX spreadsheet
RFP Document.pdf PDF
SDDOT_HPMS_Vendor_Questions_24RFP11610.docx DOCX document
SDDOT_HPMS_Data_specifications_24RFP11610.xlsx XLSX spreadsheet
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
Try for free Login

Text version

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

Field List

State TrunkNSTRI
HPMS Item #Data NameData TypeSourceSource
1F_SYSTEMDesignationsRISNSTRI
2URBAN_CODEEventsRISNSTRI
3FACILITY_TYPEEventsCalculated
4Structure_TypeEventsBridge FileBridge File
5ACCESS_CONTROLEventsRISCalculated
6OWNERSHIPEventsRISNSTRI
7THROUGH_LANESEventsRISNSTRI
8MANAGED LANES OPERATIONS TYPEEventsSample DatabaseSample Database
9MANAGED LANESEventsSample DatabaseSample Database
10PEAK_LANESEventsCalculated?NSTRI
11COUNTER_PEAK_LANESEventsCalculated?Calculated
12TURN_LANES_REventsSample DatabaseSample Database
13TURN_LANES_LEventsSample DatabaseSample Database
14SPEED_LIMITEventsRISNSTRI
15TOLL_IDEventsSample DatabaseSample Database
16TOLL_TYPESample DatabaseSample Database
17ROUTE_NUMBERIDRISNSTRI
18ROUTE_SIGNINGRISCalculated
19ROUTE_QUALIFIERRISCalculated
20ALTERNATIVE_ROUTE_NAMESample DatabaseSample Database
21AADTEventsRIS TrafficNSTRI
22AADT_SINGLE_UNITEventsRIS TrafficSample Database
23PCT_PEAK_SINGLEEventsRIS TrafficSample Database
24AADT_COMBINATIONEventsRIS TrafficSample Database
25PCT_PEAK_COMBINATIONEventsRIS TrafficSample Database
26K_FACTOREventsRIS TrafficSample Database
27DIR_FACTOREventsRIS TrafficCalculated
28FUTURE_AADTEventsRIS TrafficCalculated
29TYPE_SIGNALEventsSample DatabaseSample Database
30PCT_GREEN_TIMEEventsSample DatabaseSample Database
31NUMBER_SIGNALSEventsSample DatabaseSample Database
32STOP_SIGNSEventsSample DatabaseSample Database
33AT_GRADE_OTHEREventsSample DatabaseSample Database
34LANE_WIDTHEventsRISCalculated
35MEDIAN_TYPEEventsRISSample Database
36MEDIAN_WIDTHEventsRISSample Database
37SHOULDER_TYPEEventsRISNSTRI
38SHOULDER_WIDTH_REventsRISCalculated NSTRI
39SHOULDER_WIDTH_LEventsRISCalculated NSTRI
40PEAK_PARKINGEventsSample DatabaseNSTRI
41WIDENING_OBSTACLESample DatabaseSample Database
42WIDENING_POTENTIAL & OBSTACLEEventsSample DatabaseSample Database
43CURVE_A,B,C,D,E,FEventsRISSample Database
44TERRAIN_TYPEEventsSample DatabaseNSTRI
45GRADE_A,B,C,D,E,FEventsRISSample Database
46PCT_PASS_SIGHTEventsRISSample Database
47IRIEventsRISSample Database
48PSREventsSample DatabaseSample Database
49SURFACE_TYPEEventsdTimsNSTRI
50RUTTINGEventsdTimsSample Database
51FAULTINGEventsdTimsSample Database
52PERCENT_CRACKINGEventsdTimsSample Database
53CRACKING_TRANSVERSEdTimsSample Database
54YEAR_LAST_IMPROVEventsdTimsSample Database
55YEAR_LAST_CONSTRUCTIONEventsdTimsSample Database
56LAST_OVERLAY_THICKNESSEventsdTimsSample Database
57THICKNESS_RIGIDEventsdTimsSample Database
58THICKNESS_FLEXIBLEEventsdTimsSample Database
59BASE_TYPEEventsdTimsSample Database
60BASE_THICKNESSEventsdTimsSample Database
61CLIMATE_ZONEFHWAFHWA
62SOIL_TYPEEventsFHWAFHWA
63County CodeEventsRIS
64NHSDesignationsRIS
65STRAHNETDesignationsFHWAFHWA
66National Truck NetworkDesignationsFHWAFHWA
67Future National Highway SystemFHWAFHWA
68Maintenance & OperatonsEventsFHWAFHWA
69CapacityFHWAFHWA
70Directional Through LanesEvents
72National Highway Freight Network (NHFN)Designations
73Is RestrictedEvents

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 TrafficA sub utility of RIS
CalculatedThese fields are calculated base on the information in other fields in the submittal
Bridge FileThis is AASHTOWare's BridgeManagement system
Sample DatabaseThis is a database maintained by DOT. Used, as the name implies, for tracking sample road segments
dTimsFrom 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 .