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/
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Failed Condition | condition_failed | condition_failed | Number | Percent of infrastructure in failed condition |
| Percent Satisfactory | percent_satisfactory | percent_satisfactory | Number | Percent of infrastructure in excellent, good, or fair condition |
| Fair Condition | condition_fair | condition_fair | Number | Percent of infrastructure in fair condition |
| Poor Condition | condition_poor | condition_poor | Number | Percent of infrastructure in poor condition |
| Good Condition | condition_good | condition_good | Number | Percent of infrastructure in good condition |
| Excellent Condition | condition_excellent | condition_excellent | Number | Percent of infrastructure in excellent condition |
| Fiscal Year Begins | fiscal_year_begins | fiscal_year_begins | Calendar date | Date that fiscal year begins |
| Fiscal Year | fiscal_year | fiscal_year | Text | Fiscal year that the Comprehensive Infrastructure Assessment was conducted |
| Percent Unsatisfactory | percent_unsatisfactory | percent_unsatisfactory | Number | Percent of infrastructure in poor or failed condition |