colorado-gov/construction-projects-endpoints-for-funded-roads-2cwd-2w55
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/construction-projects-endpoints-for-funded-roads-2cwd-2w55\".\"construction_projects_endpoints_for_funded_roads\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • construction_projects_endpoints_for_funded_roads
     
     
     
     
     
Upstream Metadata