Vital Signs: Street Pavement Condition - by segment (Updated October 2019)
VITAL SIGNS INDICATOR
Street Pavement Condition (T16)
FULL MEASURE NAME
Pavement condition index (PCI)
LAST UPDATED
October 2019
DESCRIPTION
Street pavement condition, more commonly referred to as the pavement condition index (PCI), reflects the quality of pavement on local streets and roads in the region. Calculated using a three-year moving average, PCI ranges from zero (failed) to 100 (brand-new) and has been used as a regional indicator of pavement preservation for over a decade.
DATA SOURCE
Metropolitan Transportation Commission: StreetSaver
CONTACT INFORMATION
vitalsigns.info@bayareametro.gov
METHODOLOGY NOTES (across all datasets for this indicator)
Pavement condition index (PCI) relies upon a three-year moving average for regional, county and city PCI to improve the reliability of the PCI data on an annual basis. The index ranges from 0 to 100, with 0 representing a failed road and 100 representing a brand-new facility. Segment PCI data is collected on a rolling basis but is imputed for interim years based on facility age and treatments using the MTC StreetSaver system. Pavement condition data was not collected in 2008. As such, 2007 and 2009 PCI scores were averaged to compute a 2008 estimate for the region, county and city datasets. Due to a lack of reported PCI data for the city of Palo Alto in 2007, an average could not be calculated, so Palo Alto is not included in the Regional Distribution chart.
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-street-pavement-condition-by-segment-efiw-kf2g\".\"vital_signs_street_pavement_condition_by_segment\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
