Icon for Socrata external plugin
Open repository in Console
Updated 16 days ago
Indexed 1 hour ago


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" \
{"sql": "
    SELECT *
    FROM \"highways-hidot-hawaii-gov/hdotcrashlayer-qtij-gda6\".\"hdotcrashlayer\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • hdotcrashlayer