HawaiiTT202004

Hawaii Truck Traffic April 2020 (04/2020).

This dataset displays truck traffic for April 2020 on all roads on the Hawaii State Highway System. This data is refreshed on a yearly basis.

Some data provided in this dataset includes: VMT, Route number, Name of road, etc.

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/hawaiitt202004-sa6n-q49r\".\"hawaiitt202004\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.