About this Dataset

Strategic Measure High Frequency Transit Route Street Conditions

This table contains data that describes the condition of streets maintained by the City of Austin Public Works Department that host Cap Metro high frequency transit routes as of FY2019. The data in this dataset is a subset of the larger street conditions dataset also posted in the open data portal

Condition data is gathered by a contacted vendor, who drives the streets using a specially equipped vehicle that records the data used to determine street condition. The vendor drives every lane of every street in the city, covering one-third to one-half of the city every year. Street condition is then classified as excellent, good, fair, poor, or failed based on national street engineering standards.

This table contains data for the most recent set of assessment data. Year-to-year performance is reported using another table that contains aggregated values calculated using the method described above. Private streets and streets maintained by the Texas Department of Transportation are excluded from reporting and this data set, since maintenance of those roadways is the responsibility of those parties.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/Street-Conditions-High-Frequency-Transit-Routes/kqvg-gud8/
Organization: City of Austin
Last updated: 2020-11-12T13:22:01.922352
Tags: city-of-austin, infrastructure, infrastructure-maintenance, mobility, sd23, transportation

Tables

Table 1

@usgov.city_of_austin_strategic_measure_high_frequency_transi_2ec34a85.table_1

75.33 kB
1,837 rows
12 columns

CREATE TABLE table_1 (
  "segment_id" BIGINT,
  "street_name" VARCHAR,
  "from_limit_street" VARCHAR,
  "to_limit_street" VARCHAR,
  "functional_class" VARCHAR,
  "minimum_address_in_range" DOUBLE,
  "maximum_address_in_range" DOUBLE,
  "segment_width" DOUBLE,
  "segment_length" BIGINT,
  "lane_miles" DOUBLE,
  "grade" VARCHAR,
  "inspection_id" VARCHAR
);