Safety Counter Measure Summarized Data

This is a summarized dataset of the Act 100 Safety Countermeasure data. This dataset provides the current total of countermeasure data year to date. Data is set to update daily.

This dataset takes the raw and compiled version of the safety data (https://highways.hidot.hawaii.gov/Safety-Countermeasures/Safety-Countermeasure-Data-Raw-and-Compiled/9ij2-rgxm) and summarizes it. This simply aggregates all the branches and districts data for the entire year to date and converts the data to the units specified in each row.

Here is a link to the script that is used to transform the raw data into this dataset: https://github.com/Grant-Thornton-US/hdot-scripts/blob/master/Python/Act100/SafetyCountermeasures_Summary.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-counter-measure-summarized-data-mmvn-5vj9\".\"safety_counter_measure_summarized_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.