2018 Pavement Section Report
Additional pavement information drilled down from the street branch report. This includes pavement section data such as street surface type, functional classification, true area (in both feet and yards), length (in both feet and miles) and the section's Pavement Condition Index (PCI) rating. Please see the Bloomington project summary document for more detailed information regarding the PCI ratings.
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 \"bloomington-in-gov/2018-pavement-section-report-mx3s-rmi4\".\"2018_pavement_section_report\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
