About this Dataset

Strategic Measure Infrastructure Condition Aggregated

This dataset provides an overall view of infrastructure condition for all assets included in the Comprehensive Infrastructure Assessment (CIA) for that year. Overall condition is calculated by multiplying condition percentages for each network by the current replacement value for that network. These values are then added up for each condition, and divided by the total current replacement value to calculate the percentage of all assets in each condition. Assets that do not have current replacement values or for which condition is unknown are excluded from these calculations.

Data comes from the survey of participating departments conducted every two years during the compilation of the CIA. Each row of the table shows the distribution of asset conditions for the CIA conducted for the year listed.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/Percentage-of-infrastructure-classified-as-poor-or/smwq-cx27/
Organization: City of Austin
Last updated: 2021-08-07T11:42:36.841836
Tags: city-of-austin, infrastructure, infrastructure-management, sd23

Tables

Table 1

@usgov.city_of_austin_strategic_measure_infrastructure_condit_5e04f776.table_1

7.48 KB
1 row
9 columns


CREATE TABLE table_1 (
  "fiscal_year" VARCHAR,
  "fiscal_year_begins" TIMESTAMP,
  "excellent_condition" DOUBLE,
  "good_condition" DOUBLE,
  "fair_condition" DOUBLE,
  "poor_condition" DOUBLE,
  "failed_condition" DOUBLE,
  "percent_satisfactory" DOUBLE,
  "percent_unsatisfactory" DOUBLE
);