Safety CounterMeasure Data - By Month

This dataset is used to track Act 100 monthly safety countermeasures installed by HDOT to potentially reduce future fatalities and serious injuries. The dataset captures each countermeasure data point by month. The dataset is set to refresh/update everyday. New countermeasure rows will be appended to the dataset at the change of each month.

This dataset uses the Raw data (https://highways.hidot.hawaii.gov/Safety-Countermeasures/Safety-Countermeasure-Data-Raw-and-Compiled/9ij2-rgxm) and pivots that data and aggregates it by month for each countermeasure.

The script for that data transformation is here: https://github.com/Grant-Thornton-US/hdot-scripts/blob/master/Python/Act100/SafetyCounterMeasures_Summary_By_Month.py

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/safety-countermeasure-data-by-month-i3kx-mm3w\".\"safety_countermeasure_data_by_month\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.