Description: <DIV STYLE="text-align:Left;"><DIV><P><SPAN>City-wide equity index of overburden for the City of Tumwater Stormwater division. Indicators include: housing cost burden (HousingCos); homeownership rate (PctOwnerOc); lead risk from housing (LeadRisk); condition of housing (CondHousin); poverty rate (PctPoverty); median household income(Median_hou); unemployment rate (PctUnemplo); percent utilizing SNAP/food stamps or cash assistance (PctUsingSN); percent of land area within 200ft of a high-traffic road (HTRpctImpa); canopy cover as percent of impervious surface (CanopyCover); percent of land area within 1 mile of a toxic site or spill (pct1miTox); percent of impervious surface area (Impervious); percent of residents without a high school diploma or equivalent (PctLessHS); percent of residents with any college degree (PctDegree); percent of low-income elementary students (PCTLOWINCO); percent of high school students in dual enrollment programs (PctDualCre); student-teacher ratio (STUTEACHRA); percent of residential parcels within 1 mile of a bus stop (PctBusParc); percent of residential parcels within 1 mile of a grocery store (PctGrocPrc); percent of residential parcels within 1 mile of a library (PctLibPrcl); and percent of residential parcels within 1 mile of a park entrance (PctPrksPrcl). </SPAN></P><P><SPAN>Spatial Reference: NAD_1983_HARN_StatePlane_Washington_South_FIPS_4602_Feet</SPAN></P><P><SPAN>Housing cost burden (HousingCos) for City of Tumwater block groups was calculated using 2019 ACS 5-year estimates of median household income and median contract rent. Retrieved 12/30/21 from https://data.census.gov/cedsci/table?q=median%20income&g=0500000US53067%241500000&tid=ACSDT5Y2019.B19013and https://data.census.gov/cedsci/table?q=median%20rent&g=0500000US53067%241500000&tid=ACSDT5Y2019.B25058</SPAN></P><P><SPAN>Housing tenure/homeownership (PctOwnerOcc) rate in City of Tumwater block groups was calculated using 2019 5-year ACS estimates for housing tenure. Retrieved 12/30/21 from https://data.census.gov/cedsci/table?t=Owner%2FRenter%20%28Tenure%29&g=0500000US53067%241500000&tid=ACSDT5Y2019.B25003</SPAN></P><P><SPAN>Average age of housing for City of Tumwater block groups was used as a proxy for lead risk from housing (LeadRisk). Calculated using Thurston County parcel data. Thurston parcels were filtered to residential parcels only. Effective year built is incomplete for this dataset and thus a sample set was utilized. All parcels with non-null effective year built was used as the total population variable and. Parcels with an effective year built of 1944 or earlier (referred to as high risk) and parcels with an effective year built of 1945-1978 (referred to as moderate risk) were separated from the total population. A ratio of high-risk parcels to non-null parcels and a ratio of moderate risk parcels to non-null parcels were calculated. The moderate risk ratio was multiplied by a factor of 0.5 to account for decreased lead risk in housing built post-1945 and then added to the high-risk ratio for each block group to obtain a total risk ratio. Retrieved 12/22/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Condition of housing (CondHousin) for City of Tumwater block groups was derived from Thurston County parcel data. Thurston parcels were filtered to residential parcels only. Condition of housing is incomplete for the dataset and thus a sample set was utilized. All parcels with non-null condition of housing was used as the total population variable. Condition of housing ratings (excellent, very good, good, average, fair, poor, and very poor) were assigned weights from 0-7 with excellent being the highest and very poor the lowest. A percentage of non-null parcels was calculated for each category which was then multiplied by the category weight. Each score was added together for an overall potential rating of 0-7. Retrieved 12/22/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Percent of residents living below the poverty line (PctPoverty) in City of Tumwater block groups according to 2019 5-year ACS estimates. Retrieved 12/30/21 from https://data.census.gov/cedsci/table?g=0500000US53067%241500000&d=ACS%205-Year%20Estimates%20Detailed%20Tables&tid=ACSDT5Y2019.B17021</SPAN></P><P><SPAN>Median household income (MedianHou) within City of Tumwater block groups created using 2019 5-year ACS estimates. Retrieved 12/30/21 from https://data.census.gov/cedsci/table?q=median%20income&g=0500000US53067%241500000&tid=ACSDT5Y2019.B19013</SPAN></P><P><SPAN>Percentage of residents in the labor force and unemployed (PctUnemplo) within City of Tumwater block groups was determined using 2019 ACS 5-year estimates. Retrieved 12/27/2021 from https://data.census.gov/cedsci/table?q=employment%20status&g=0500000US53067%241500000&tid=ACSDT5Y2019.B23025</SPAN></P><P><SPAN>Percentage of residents utilizing cash assistance or SNAP/food stamps (PctUsingSN) within City of Tumwater block groups was determined using 2019 ACS 5-year estimates. Retrieved 12/22/21 from https://data.census.gov/cedsci/table?t=Income%20and%20Poverty&g=0500000US53067%241500000&tid=ACSDT5Y2019.B19058</SPAN></P><P><SPAN>Percent of land area within 200ft of a high traffic road (HTRpctImpa) data derived from Thurston Street Address TCOMM dataset (Thurston Geodata). Parking lot and alley road classes and 'streets' with speed limits less than 35 miles per hour have been excluded from the analysis. Retrieved 12/22/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-street-address-tcomm/explore?location=47.014250%2C-122.837100%2C10.90</SPAN></P><P><SPAN>Canopy cover (CanopyCover) normalized by impervious surface and displayed by City of Tumwater block groups was calculated using data from the Multi Resolution Land Characteristic consortium (MRLC). Retrieved 12/17/21 from https://www.mrlc.gov/data?f%5B0%5D=category%3ATree%20Canopy&f%5B1%5D=category%3Aland%20cover&f%5B2%5D=region%3Aconus</SPAN></P><P><SPAN>Percent of land area within 1-mile of toxic sites or spills (pct1miTox) in City of Tumwater block groups was calculated using Washington Department of Ecology toxics data. Retrieved 12/15/21 from https://apps.ecology.wa.gov/cleanupsearch/reports/cleanup/all</SPAN></P><P><SPAN>Percent imperviousness within each City of Tumwater census block group (Impervious) determined using Zonal Statistics as table where NLCD 2019 developed impervious data (mask extracted by Thurston census blocks) was the input value raster and 2018 Census block groups from US Census Bureau was the zone data. The 'mean' statistic represents percent imperviousness within each census block. View reference information for NLCD database here: https://www.mrlc.gov/data/legends/national-land-cover-database-2019-nlcd2019-legend</SPAN></P><P><SPAN>Educational attainment (less than high school and those with any college degree) within City of Tumwater block groups determined using 2019 ACS 5-year Estimates of educational attainment for the population over 25 years of age. Retrieved 12/22/21 from https://data.census.gov/cedsci/table?t=Educational%20Attainment&g=0500000US53067%241500000&tid=ACSDT5Y2019.B15003</SPAN></P><P><SPAN>Percentage of low-income students (PCTLOWINCOME) by City of Tumwater block groups were calculated using data from the Washington Office of Superintendent of Public Instruction (OSPI) 2019-2020 Report Card and school catchment areas from Thurston Geodata. Retrieved 12/26/21 from https://data.wa.gov/Education/Report-Card-Enrollment-2019-20-School-Year/gtd3-scgaand https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-school-districts/explore?location=47.025912%2C-122.889912%2C9.26</SPAN></P><P><SPAN>The Washington State Report Card from the Washington State Office of Superintendent of Public Instruction was utilized to determine the student-teacher ratio (STUTEACHRA) in each public elementary school in the City of Tumwater. Elementary school catchment areas from Thurston Geodata utilized. Retrieved 12/15/21 from https://data.wa.gov/Education/Report-Card-Teacher-Ratio-Program-Certificate-2019/7mj8-fhanand 12/26/21 fromhttps://gisdata-thurston.opendata.arcgis.com/datasets/thurston-school-districts/explore?location=47.025912%2C-122.889912%2C9.26</SPAN></P><P><SPAN>Percentage of dual enrollment high school students (PctDualCr) by City of Tumwater block groups were calculated using data from the Washington Office of Superintendent of Public Instruction (OSPI) 2019-2020 Report Card and school catchment areas from Thurston Geodata. Retrieved 12/15/21 from https://data.wa.gov/Education/Report-Card-SQSS-for-2019-20/nfpj-mzp6</SPAN></P><P><SPAN>Percent of residential parcels in City of Tumwater block groups within 1 mile of a bus stop (PctBusPrcl) was calculated using the parcel dataset from Thurston Geodata and manually collected grocery store data. Retrieved 12/15/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Percent of residential parcels in City of Tumwater block groups within 1 mile of a grocery store(PctGrocPrc) was calculated using the parcel dataset from Thurston Geodata and manually collected grocery store data. Retrieved 12/15/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Percent of residential parcels in City of Tumwater block groups within 1 mile of a library (PctLibPrcl) was calculated using the parcel dataset from Thurston Geodata and Washington state library data from the Washington State Geodata portal. Retrieved 12/20/21 from https://geo.wa.gov/datasets/washington-library-locations/explore?location=47.135995%2C-120.589354%2C7.52and 12/30/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Percent of residential parcels in City of Tumwater block groups within 1 mile of a park entrance or natural area (PctPrkPrcl) was calculated using the parcel dataset from Thurston Geodata and Parks from Thurston Geodata. Park entrances were approximated using vertices. Retrieved 12/19/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parks/explore and 12/30/21 from https://gisdata-thurston.opendata.arcgis.com/datasets/thurston-parcels/explore?location=46.971500%2C-122.701000%2C10.92</SPAN></P><P><SPAN>Each category was normalized and a z-score was calculated. Each indicator was then assigned a z-class according to its z-score. For factors that add additional burden, a z-score between 1-2 received a z-class of “1” and a z-score greater than 2 received a z-class of “2”. For factors that advantage residents (i.e. Median income, percent of residents with a college degree), a z-score between -2 - -1 received a z-class of “1” and a z-score less than -2 received a z-class of “2”. </SPAN></P><P><SPAN>In two cases, no burden was observed but significant privilege was observed. In these cases (canopy cover by impervious surface, and percent of high school students enrolled in dual enrollment programs), block groups with a z-score greater than 1 received a negative z-class score of “-1” to represent alleviation of burden. </SPAN></P><P><SPAN>All z-class scores were added to obtain a composite index score (CompTUM) with a potential range of -2 to 34, with higher scores representing the highest burden. Composite index scores then received their own z-scores. Block group composite index z-scores were classified using quantile classification with 6 classes: high burden, elevated burden, moderate burden, average burden, decreased burden, and limited burden</SPAN></P></DIV></DIV>