SDDOT_HNAR_25RFP12707_Data_specifications.xlsx

22 KB Posted

Attached to
Highway Needs and Analysis Report Tool
Solicitation number
25RFP12707
Issued by
Harding County, South Dakota

About this file

Written by GovTribe AI ·

This file is a data specifications spreadsheet for the South Dakota Department of Transportation's (SDDOT) Highway Needs and Analysis Report Tool RFP (#25RFP12707). The document outlines 73 different data fields that need to be captured in the proposed cloud-based solution, including information about road systems, urban codes, facility types, traffic data, structural elements, and various highway characteristics. The data specifications are designed to integrate with SDDOT's existing systems including their Roadway Information System (RIS), Bridge Management system, and Deighton Software's pavement management system (dTims).

The specifications detail the data sources for each field, with many pulling from RIS, NSTRI (assumed to be a legacy or current system), sample databases, and calculated fields. Key data categories include system designations, events tracking, traffic measurements, structural characteristics, and maintenance information. The document includes a data source description section that explains the main systems involved, including the PC/SQL server-based RIS, Bridge Management system, and dTims pavement management system that analyzes pavement distress data through annual uploads.

View the file

Other files

File Type Posted
RFP Document.pdf PDF
Response to Offeror Questions document.pdf PDF
SDDOT_HNAR_25RFP12707_NeedsBookSample.pdf PDF
SDDOT_HNAR_25RFP12707_Requirements.xlsx XLSX spreadsheet
SDDOT_HNAR_25RFP12707_Costs.xlsx XLSX spreadsheet
SDDOT_HNAR_25RFP12707_Vendor_Questions.docx DOCX document
RFP Document.pdf PDF
SDDOT_HNAR_25RFP12707_NeedsBookSample.pdf PDF
SDDOT_HNAR_25RFP12707_Requirements.xlsx XLSX spreadsheet
SDDOT_HNAR_25RFP12707_Costs.xlsx XLSX spreadsheet
SDDOT_HNAR_25RFP12707_Data_specifications.xlsx XLSX spreadsheet
SDDOT_HNAR_25RFP12707_Vendor_Questions.docx DOCX document
Show all 12

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

SAMPLE ONLY
This is what was created for HPMS' RFP
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 .