HDOT_Crash_Layer

This is crashes data from FARS data and included additional fields that identified some crash factors that SHACA has to offer from Hawaii Police department reports. Its contains involved vehicle types, contributing factory to the crashes, and geolocation of the accidents.

(0, 0) coordinates will be defaulted to corresponded countries.

Default location by countries:

HON: (21.480852, -157.923130)

HAW: (19.486706, -155.618117)

MAU: (20.743359, -156.202115)

KAU: (22.072295, -159.510240)

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/hdotcrashlayer-qtij-gda6\".\"hdotcrashlayer\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.