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
"}
EOFSee the Splitgraph documentation
for more information.
