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
"}
EOFSee the Splitgraph documentation
for more information.
