SDDOT_HPMS_Data_specifications_24RFP11610.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
Highway Performance Monitoring System Reporting Tool
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 PDF
RFP Document.pdf 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 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 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 .