colorado-gov/construction-projects-endpoints-for-funded-roads-py3d-8rcb
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 hours ago
Indexed 2 hours ago

Construction Projects Endpoints for Funded Roads in Colorado 2017

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 August 2010 through March 2017 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-py3d-8rcb\".\"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