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 
"}
EOF

See the Splitgraph documentation for more information.