Massachusetts Department of Transportation (MassDOT) Work Zone Data Exchange (WZDx) v3.1 Feed Sample

This dataset provides information on work zones in the state of Massachusetts in a tabular format and is updated daily based on the <a href="https://wzdx.massdot-swzm.com/massdot_wzdx_v3.1.geojson" target="_blank" rel="noopener">live MassDOT Work Zone Data Exchange (WZDx) Feed</a>.

A continuously updating archive of the MassDOT 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>. This <a href="https://wzdx.massdot-swzm.com/massdot_wzdx_v3.1.geojson" target="_blank" rel="noopener">live feed</a> is currently compliant with the <a href="https://github.com/usdot-jpo-ode/jpo-wzdx/tree/v3.1" target="_blank" rel="noopener">WZDx Specification v3.1</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/massachusetts-department-of-transportation-massdot-6m7q-g56h\".\"massachusetts_department_of_transportation_massdot\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.