This dataset contains R/ECAP data for the nine-county San Francisco Bay Region at the census tract level.

To assist communities in identifying racially/ethnically-concentrated areas of poverty (R/ECAPs), HUD has developed a census tract-based definition of R/ECAPs.

To assist communities in identifying racially/ethnically-concentrated areas of poverty (R/ECAPs), HUD has developed a census tract-based definition of R/ECAPs. The definition involves a racial/ethnic concentration threshold and a poverty test. The racial/ethnic concentration threshold is straightforward: R/ECAPs must have a non-white population of 50 percent or more. Regarding the poverty threshold, Wilson (1980) defines neighborhoods of extreme poverty as census tracts with 40 percent or more of individuals living at or below the poverty line. Because overall poverty levels are substantially lower in many parts of the country, HUD supplements this with an alternate criterion. Thus, a neighborhood can be a R/ECAP if it has a poverty rate that exceeds 40% or is three or more times the average tract poverty rate for the metropolitan/micropolitan area, whichever threshold is lower. Census tracts with this extreme poverty that satisfy the racial/ethnic concentration threshold are deemed R/ECAPs.

Data Source: Decennial census (2010); American Community Survey (ACS), 2006-2010; Brown Longitudinal Tract Database (LTDB) based on decennial census data, 2000 & 1990 References: Wilson, William J. (1980). The Declining Significance of Race: Blacks and Changing American Institutions. Chicago: University of Chicago Press.

Data Source: American Community Survey (ACS), 2009-2013; Decennial Census (2010); Brown Longitudinal Tract Database (LTDB) based on decennial census data, 1990, 2000 & 2010.

Related AFFH-T Local Government, PHA Tables/Maps: Table 4, 7; Maps 1-17.

Related AFFH-T State Tables/Maps: Table 4, 7; Maps 1-15, 18.

References: Wilson, William J. (1980). The Declining Significance of Race: Blacks and Changing American Institutions. Chicago: University of Chicago Press.

Plan Bay Area 2050 utilized this single data layer to inform the Plan Bay Area 2050 Equity PriorityCommunities (EPC).

This data set was developed using American Community Survey (ACS) 2014-2018 data for eight variables considered.

This data set represents all tracts within the San Francisco Bay Region and contains attributes for the eight Metropolitan Transportation Commission (MTC) Equity Priority Communities tract-level variables for exploratory purposes. These features were formerly referred to as Communities of Concern.

Plan Bay Area 2050 Equity Priority Communities (tract geography) are based on eight ACS 2014-2018 (ACS 2018) tract-level variables:

People of Color (70% threshold) Low-Income (less than 200% of Federal poverty level, 28% threshold) Level of English Proficiency (12% threshold) Seniors 75 Years and Over (8% threshold) Zero-Vehicle Households (15% threshold) Single-Parent Households (18% threshold) People with a Disability (12% threshold) Rent-Burdened Households (14% threshold)

If a tract exceeds both threshold values for Low-Income and People of Color shares OR exceeds thethreshold value for Low-Income AND also exceeds the threshold values for three or more variables, it is a EPC.

Detailed documentation on the production of this feature set can be found in the MTC Equity Priority Communities project documentation.

These geographic designations were created to define geographic areas within San Francisco that have a higher density of vulnerable populations. These geographic designations will be used for the Health Care Services Master Plan and DPH's Community Health Needs Assessment. aov_fin - 1 = YES aov_fin - 0 = NO AOV's were defined using 2012-2016 ACS data at the census tract level and the following criteria: 1) Top 1/3rd for < 200% poverty or < 400% poverty & top 1/3rd for persons of color OR 2) Top 1/3rd for < 200% poverty or < 400% poverty & top 1/3rd for youth or seniors (65+) OR 3) Top 1/3rd for < 200% poverty or < 400% poverty & top 1/3rd for 2 other categories (unemployment, high school or less, limited English proficiency persons, linguistically isolated households, or disability) Tracts that had unstable data for an indicator were automatically given zero credit for that indicator. That is why two language variables are included in the bonus group, because there tend to be a high number of tracts with unstable data for language variables.

The index is constructed using socioeconomic and demographic, exposure, health, and housing indicators and is intended to serve as a planning tool for health and climate adaptation. Steps for calculating the index can be found in in the "An Assessment of San Francisco’s Vulnerability to Flooding & Extreme Storms" located at https://sfclimatehealth.org/wp-content/uploads/2018/12/FloodVulnerabilityReport_v5.pdf.pdfData Dictionary: (see attachment here also: https://data.sfgov.org/Health-and-Social-Services/San-Francisco-Flood-Health-Vulnerability/cne3-h93g)

Field Name Data Type Definition Notes (optional)

Census Blockgroup Text San Francisco Census Block Groups

Children Numeric Percentage of residents under 18 years old. American Community Survey 2009 - 2014.

Chidlren_wNULLvalues Numeric Percentage of residents under 18 years old. American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

Elderly Numeric Percentage of residents aged 65 and older. American Community Survey 2009 - 2014.

Elderly_wNULLvalues Numeric Percentage of residents aged 65 and older. American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

NonWhite Numeric Percentage of residents that do not identify as white (not Hispanic or Latino). American Community Survey 2009 - 2014.

NonWhite_wNULLvalues Numeric Percentage of residents that do not identify as white (not Hispanic or Latino). American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

Poverty Numeric Percentage of all individuals below 200% of the poverty level. American Community Survey 2009 - 2014.

Poverty_wNULLvalues Numeric Percentage of all individuals below 200% of the poverty level. American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

Education Numeric Percent of individuals over 25 with at least a high school degree. American Community Survey 2009 - 2014.

Education_wNULLvalues Numeric Percent of individuals over 25 with at least a high school degree. American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

English Numeric Percentage of households with no one age 14 and over who speaks English only or speaks English "very well". American Community Survey 2009 - 2014.

English_wNULLvalues Numeric Percentage of households with no one age 14 and over who speaks English only or speaks English "very well". American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

Elevation Numeric Minimum elevation in feet. United States Geologic Survey 2011.

SeaLevelRise Numeric Percent of land area in the 100-year flood plain with 36-inches of sea level rise. San Francisco Sea Level Rise Committee, AECOM 77inch flood inundation layer, 2014.

Precipitation Numeric Percent of land area with over 6-inches of projected precipitation-related flood inundation during an 100-year storm. San Francisco Public Utilities Commission, AECOM, 2015.

Diabetes Numeric Age-adjusted hospitalization rate due to diabetes; adults 18+. California Office of Statewide Health Planning and Development, 2004-2015.

MentalHealth Numeric Age-adjusted hospitalization rate due to schizophrenia and other psychotic disorders. California Office of Statewide Health Planning and Development, 2004-2015.

Asthma Numeric Age-adjusted hospitalization rate due to asthma; adults 18+. California Office of Statewide Health Planning and Development, 2004 - 2015.

Disability Numeric Percentage of total civilian noninstitutionalized population with a disability. American Community Survey 2009 - 2014.

Disability_wNULLvalues

Percentage of total civilian noninstitutionalized population with a disability. American Community Survey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

HousingQuality Numeric Annual housing violations, per 1000 residents. San Francisco Department of Public Health, San Francisco Department of Building Inspections, San Francisco Fire Department, 2010 - 2012.

Homeless Numeric Homeless population, per 1000 residents. San Francisco Homeless Count 2015.

LivAlone Numeric Households with a householder living alone. American Community Surevey 2009 - 2014.

LivAlone_wNULLvalues Numeric Households with a householder living alone. American Community Surevey 2009 - 2014. Because the American Community Survey uses survey estimates, all data is attached to a margin of error. When the coefficient of variation is over .3, the SFDPH considers this data unstable and gives it a NULL value. However, because principal component analysis and the final development of the flood health index could not use NULL values, SFDPH used this unstable data for these limited purposes. For the purpose of transparency, SFDPH has included both datasets with NULL values and without NULL values.

FloodHealthIndex Numeric Comparative ranking of flood health vulnerability, by block group. The Flood Health Index weights the six socioeconomic and demographic indicators (Children, Elderly, NonWhite, Poverty, Education, English) as 20% of the final score, the three exposure indicators (Sea Level Rise, Precipitation, Elevation) as 40% of the final score, the four health indicators (Diabetes, MentalHealth, Asthma, Disability) as 20% of the final score, and the three housing indicators (HousingQuality, Homeless, LivAlone) as 20% of the final score. For methodology used to develop the final Flood Health Index, please read the San Francisco Flood Vulnerability Assessment Methodology Section.

FloodHealthIndex_Quintiles Numeric Comparative ranking of flood health vulnerability, by block group. The Flood Health Index weights the six socioeconomic and demographic indicators (Children, Elderly, NonWhite, Poverty, Education, English) as 20% of the final score, the three exposure indicators (Sea Level Rise, Precipitation, Elevation) as 40% of the final score, the four health indicators (Diabetes, MentalHealth, Asthma, Disability) as 20% of the final score, and the three housing indicators (HousingQuality, Homeless, LivAlone) as 20% of the final score. For methodology used to develop the final Flood Health Index, please read the San Francisco Flood

This web map represents all urbanized tracts within the San Francisco Bay Region, and contains attributes for the eight Metropolitan Transportation Commission (MTC) Equity Priority Communities (EPC) tract-level variables for exploratory purposes. These features were formerly referred to as Communities of Concern (CoC).MTC 2018 Equity Priority Communities (tract geography) is based on eight ACS 2012-2016 tract-level variables:Persons of Color (70% threshold)Low-Income (less than 200% of Fed. poverty level, 30% threshold)Level of English Proficiency (12% threshold)Elderly (10% threshold)Zero-Vehicle Households (10% threshold)Single Parent Households (20% threshold)Disabled (12% threshold)Rent-Burdened Households (15% threshold)If a tract exceeds both threshold values for Low-Income and Minority shares OR exceeds the threshold value for Low-Income AND also exceeds the threshold values for three or more variables, it is a EPC.Detailed documentation on the production of this feature set can be found in the MTC Equity Priority Communities project documentation.