Highway Grades in Colorado 2021

Name: Highway Grades in Colorado 2021
Creator: CDOT
Published: 2021-11-09T21:55:12

Highway grades in sections across Colorado. Contains detailed data for state highways, including grades from the Colorado Department of Transportation (CDOT).

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/highway-grades-in-colorado-2021-jr8i-33tp\".\"highway_grades_in_colorado_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

highway_grades_in_colorado_2021

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

GeospatialCollection MethodProf Grade GPS (sub-meter)Horizontal AccuracyNot specifiedCoordinate System DisclaimerNot specifiedHorizontal Coordinate SystemNot specifiedWeb Display Coordinate SystemNot specified

Data QualityExpected Update FrequencyManual - annual - 3-4 update cycle

Data UpdatesUpdate TypeManual - annual - 3-4 update cycleUpdate MethodNot specifiedUpdate ScheduleNot specifiedSource Update ScheduleNot specifiedTotal Records At Initial Publish87,627

Data DescriptionSingle RowGrade data per road segment. Collection ModeGPS, digitzing from aerial photographyLong DescriptionThis dataset contains all roadway segments that are under CDOT’s jurisdiction. This data is collected for the State’s public roadway inventory to meet Federal reporting requirements for the Highway Performance Monitoring System (HPMS). Fields describe roadway segments identified by beginning and ending measured points, plus fields that store various data related to curves. Collection MethodTo measure horizontal curvature, Fugro Roadware utilizes high accuracy Trimble GPS (+/- 2 feet) and the Applanix POS LV System.Newest Record in Dataset2018Oldest Record in Dataset2016Data Collection InstrumentNot specifiedField Names, comma delimitedroute, refpt, endrefpt, runlength_from, runlength_to, seg_length, curve_updateyr, pricurve, pricurveclass, seccurve, seccurveclass, grade_updateyr, prigrade, prigradeclass, secgrade, secgradeclass, objectidDate of Initial Dataset Creation2016 for curve data, 2018 for grade data

Dataset CoverageGranularityNot specifiedUnit of AnalysisVector Line DataGeographic CoverageState

Contributing Agency InformationCitationCDOT - Colorado Department of TransportationData SourceGRDMS - Geographic Roadway Database Management SystemAgency Program Pagehttps://dtdapps.coloradodot.info/otisAgency Data Series Pagehttps://dtdapps.coloradodot.info/otis/HighwayData

Additional Dataset DocumentationData DictionaryNot specifiedAdditional MetadataNot specifiedTechnical DocumentationNot specified

About

Highway Grades in Colorado 2021

5 hours ago (updated)

5 hours ago (indexed)

Topics