Icon for Socrata external plugin
Open repository in Console
Updated 11 hours ago
Indexed 2 hours ago

Construction Projects Endpoints for Funded Roads 2024

Point locations of mileposts for start and end of road projects and associated improvement codes and timelines for active construction projects on funded roads in Colorado through 2024 from the Colorado Department of Transportation (CDOT). Use this data with Construction Projects Line Segments.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"colorado-gov/construction-projects-endpoints-for-funded-roads-2cwd-2w55\".\"construction_projects_endpoints_for_funded_roads\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • construction_projects_endpoints_for_funded_roads
Upstream Metadata