Texas DOT (TxDOT) Work Zone Data Schema Version 2.0

This dataset provides lane closure occurrences within the Texas Department of Transportation (TxDOT) highway system in a tabular format.

A continuously updating archive of the TxDOT WZDx feed data can be found at <a href="http://usdot-its-workzone-raw-publicdata.s3.amazonaws.com/index.html" target="_blank" rel="noopener">ITS WorkZone Raw Data Sandbox</a> and the <a href="http://usdot-its-workzone-publicdata.s3.amazonaws.com/index.html" target="_blank" rel="noopener">ITS WorkZone Semi-Processed Data Sandbox</a>. The <a href="http://txdot-its-c2c.txdot.gov/WZDx/2.0" target="_blank" rel="noopener">live feed</a> is currently compliant with the <a href="https://github.com/usdot-jpo-ode/jpo-wzdx/tree/v2.0" target="_blank" rel="noopener">Work Zone Data Exchange (WZDx) Specification version 2.0</a>.

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 \"datahub-transportation-gov/texas-dot-txdot-work-zone-data-schema-version-20-h4kh-i7b7\".\"texas_dot_txdot_work_zone_data_schema_version_20\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.