New Lane Closure Merged Data

Lane Closure Spatial data from ArcGIS aggregated by variables such as Route, Direction, Mile Post, Closure Begin and End Dates, Active, Weekday and Weekend formatted into Socrata in LineString format and replaced hourly via a script. The base data is generated from entries by HiDOT personnel into a survey123 dataset. This data is primarily used for visualizations and reporting purposes only.

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 \"highways-hidot-hawaii-gov/new-lane-closure-merged-data-ypxs-ramh\".\"new_lane_closure_merged_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.