Icon for Socrata external plugin
Updated over 1 year ago
Indexed 4 hours ago

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:


NameSocrata field nameColumn name in sgr mountData typeDescription
Fiscal Year Beginsfiscal_year_beginsfiscal_year_beginsCalendar dateDate that fiscal year begins
Fiscal Yearfiscal_yearfiscal_yearTextFiscal year that the Comprehensive Infrastructure Assessment was conducted
Percent Unsatisfactorypercent_unsatisfactorypercent_unsatisfactoryNumberPercent of infrastructure in poor or failed condition
Percent Satisfactorypercent_satisfactorypercent_satisfactoryNumberPercent of infrastructure in excellent, good, or fair condition
Failed Conditioncondition_failedcondition_failedNumberPercent of infrastructure in failed condition
Poor Conditioncondition_poorcondition_poorNumberPercent of infrastructure in poor condition
Fair Conditioncondition_faircondition_fairNumberPercent of infrastructure in fair condition
Good Conditioncondition_goodcondition_goodNumberPercent of infrastructure in good condition
Excellent Conditioncondition_excellentcondition_excellentNumberPercent of infrastructure in excellent condition
  • strategic_measureinfrastructure
Upstream Metadata