Vital Signs: Highway Pavement Condition – by segment

VITAL SIGNS INDICATOR

Highway Pavement Condition (T17)

FULL MEASURE NAME

Distressed share of highway lane-miles

LAST UPDATED

February 2017

DESCRIPTION

Highway pavement condition, measured by the share of highway lane-miles flagged as “distressed” by Caltrans, reflects the regional pavement quality on the highway system. The dataset includes regional and road segment tables.

DATA SOURCE

California Department of transportation: Highway Pavement Condition Inventory

CONTACT INFORMATION

vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator)

Caltrans datasets only include regional performance on a historical basis and rely on "distressed" lane-mileage as an indicator for poor pavement condition. The geospatial data for 2015 provides the condition on each lane-mile for each segment of roadway; data on a corridor basis reflects a sum of all lane-mileage for that corridor.

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 \"bayareametro-gov/vital-signs-highway-pavement-condition-by-segment-ib6k-87ry\".\"vital_signs_highway_pavement_condition_by_segment\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.