Open repository in Console
Readme
Updated 1 year ago
‧ Indexed 2 hours ago
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.