Cost Per Mile Calculations

The information provided in this dataset is used for performance metrics in the Annual Report and the Act100 Report. Data for these metrics are being pulled from the mileage and expenditure datasets. This dataset provides metrics certain metrics including total number of lane miles cost per lane mile. Mileage: https://highways.hidot.hawaii.gov/Federal-Assets/Lane-Miles-and-Mileage/da8i-cb44 Expenditures: https://highways.hidot.hawaii.gov/HWYAC-Official/ProjectType-Costs-by-Year/utpi-67wr

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/cost-per-mile-calculations-727p-gh8g\".\"cost_per_mile_calculations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.