- API
Vital Signs: Life Expectancy – by ZIP Code
data.bayareametro.gov | Last Updated 2018-07-06T18:05:06.000ZVITAL SIGNS INDICATOR Life Expectancy (EQ6) FULL MEASURE NAME Life Expectancy LAST UPDATED April 2017 DESCRIPTION Life expectancy refers to the average number of years a newborn is expected to live if mortality patterns remain the same. The measure reflects the mortality rate across a population for a point in time. DATA SOURCE State of California, Department of Health: Death Records (1990-2013) No link California Department of Finance: Population Estimates Annual Intercensal Population Estimates (1990-2010) Table P-2: County Population by Age (2010-2013) http://www.dof.ca.gov/Forecasting/Demographics/Estimates/ U.S. Census Bureau: Decennial Census ZCTA Population (2000-2010) http://factfinder.census.gov U.S. Census Bureau: American Community Survey 5-Year Population Estimates (2013) http://factfinder.census.gov CONTACT INFORMATION vitalsigns.info@mtc.ca.gov METHODOLOGY NOTES (across all datasets for this indicator) Life expectancy is commonly used as a measure of the health of a population. Life expectancy does not reflect how long any given individual is expected to live; rather, it is an artificial measure that captures an aspect of the mortality rates across a population that can be compared across time and populations. More information about the determinants of life expectancy that may lead to differences in life expectancy between neighborhoods can be found in the Bay Area Regional Health Inequities Initiative (BARHII) Health Inequities in the Bay Area report at http://www.barhii.org/wp-content/uploads/2015/09/barhii_hiba.pdf. Vital Signs measures life expectancy at birth (as opposed to cohort life expectancy). A statistical model was used to estimate life expectancy for Bay Area counties and ZIP Codes based on current life tables which require both age and mortality data. A life table is a table which shows, for each age, the survivorship of a people from a certain population. Current life tables were created using death records and population estimates by age. The California Department of Public Health provided death records based on the California death certificate information. Records include age at death and residential ZIP Code. Single-year age population estimates at the regional- and county-level comes from the California Department of Finance population estimates and projections for ages 0-100+. Population estimates for ages 100 and over are aggregated to a single age interval. Using this data, death rates in a population within age groups for a given year are computed to form unabridged life tables (as opposed to abridged life tables). To calculate life expectancy, the probability of dying between the jth and (j+1)st birthday is assumed uniform after age 1. Special consideration is taken to account for infant mortality. For the ZIP Code-level life expectancy calculation, it is assumed that postal ZIP Codes share the same boundaries as ZIP Code Census Tabulation Areas (ZCTAs). More information on the relationship between ZIP Codes and ZCTAs can be found at http://www.census.gov/geo/reference/zctas.html. ZIP Code-level data uses three years of mortality data to make robust estimates due to small sample size. Year 2013 ZIP Code life expectancy estimates reflects death records from 2011 through 2013. 2013 is the last year with available mortality data. Death records for ZIP Codes with zero population (like those associated with P.O. Boxes) were assigned to the nearest ZIP Code with population. ZIP Code population for 2000 estimates comes from the Decennial Census. ZIP Code population for 2013 estimates are from the American Community Survey (5-Year Average). ACS estimates are adjusted using Decennial Census data for more accurate population estimates. An adjustment factor was calculated using the ratio between the 2010 Decennial Census population estimates and the 2012 ACS 5-Year (with middle year 2010) population estimates. This adjustment factor is particularly im
- API
Vital Signs: Street Pavement Condition - by County (Updated August 2018)
data.bayareametro.gov | Last Updated 2018-08-21T00:38:43.000ZVITAL SIGNS INDICATOR Street Pavement Condition (T16) FULL MEASURE NAME Pavement condition index (PCI) LAST UPDATED August 2018 DESCRIPTION Street pavement condition, more commonly referred to as the pavement condition index (PCI), reflects the quality of pavement on local streets and roads in the region. Calculated using a three-year moving average, PCI ranges from zero (failed) to 100 (brand-new) and has been used as a regional indicator of pavement preservation for over a decade. DATA SOURCE Metropolitan Transportation Commission: StreetSaver CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Pavement condition index (PCI) relies upon a three-year moving average for regional, county, and city PCI to improve the reliability of the PCI data on an annual basis. The index ranges from 0 to 100, with 0 representing a failed road and 100 representing a brand-new facility. Segment PCI data is collected on a rolling basis but is imputed for interim years based on facility age and treatments using the MTC StreetSaver system. Due to the lack of reported PCI data in 2007, the city of Palo Alto is not included in the Regional Distribution chart.
- API
Vital Signs: Housing Affordability - County Overall
data.bayareametro.gov | Last Updated 2019-10-25T20:43:28.000ZHousing Affordability (EQ2) FULL MEASURE NAME Housing Affordability LAST UPDATED October 2018 DATA SOURCE U.S Census Bureau: Decennial Census Form STF3 – https://nhgis.org (1980-1990) Form SF3a – https://nhgis.org (2000) U.S. Census Bureau: American Community Survey Form B25074 (2009-2017) Form B25095 (2009-2017) http://api.census.gov Image: Flickr (Creative Commons license), Photographer: Frank Kehren, https://www.flickr.com/photos/fkehren/8481894011 CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) The share of income brackets used for different Census and ACS forms varied over time. To allow for historical comparisons, the Census Bureau merges housing expenditure brackets into three consistent bins (less than 20 percent, 20 percent to 34 percent, and more than 35 percent) that work for all years. The highest income bracket for renters in the ACS data was $100,000 or more, while the homeowner dataset included brackets for $100,000 to $149,999 and $150,000 and above. These brackets were merged together to allow for uniform comparison across tenure. While some studies use 30 percent as the affordability threshold, Vital Signs uses 35 percent as this is the closest break point using the standardized affordability brackets above. Historical data for Napa County is unavailable due to an insufficient sample size for renters in a number of years, making it impossible to calculate affordability for all households. All ACS data is for a single year, rather than a rolling average. Income breakdown data is only provided for one year as it is not possible to compare consistent inflation-adjusted income brackets over time given Census data limitations.
- API
Vital Signs: Jobs – by subcounty
data.bayareametro.gov | Last Updated 2020-04-13T23:19:44.000ZVITAL SIGNS INDICATOR Jobs (LU2) FULL MEASURE NAME Employment estimates by place of work LAST UPDATED March 2020 DESCRIPTION Jobs refers to the number of employees in a given area by place of work. These estimates do not include self-employed and private household employees. DATA SOURCE California Employment Development Department: Current Employment Statistics 1990-2018 http://www.labormarketinfo.edd.ca.gov/ U.S. Census Bureau: LODES Data Longitudinal Employer-Household Dynamics Program (2005-2010) http://lehd.ces.census.gov/ U.S. Census Bureau: American Community Survey 5-Year Estimates, Tables S0804 (2010) and B08604 (2010-2017) https://factfinder.census.gov/ Bureau of Labor Statistics: Current Employment Statistics Table D-3: Employees on nonfarm payrolls (1990-2018) http://www.bls.gov/data/ METHODOLOGY NOTES (across all datasets for this indicator) The California Employment Development Department (EDD) provides estimates of employment, by place of employment, for California counties. The Bureau of Labor Statistics (BLS) provides estimates of employment for metropolitan areas outside of the Bay Area. Annual employment data are derived from monthly estimates and thus reflect “annual average employment.” Employment estimates outside of the Bay Area do not include farm employment. For the metropolitan area comparison, farm employment was removed from Bay Area employment totals. Both EDD and BLS data report only wage and salary jobs, not the self-employed. For measuring jobs below the county level, Vital Signs assigns collections of incorporated cities and towns to sub-county areas. For example, the cities of East Palo Alto, Menlo Park, Portola Valley, Redwood City and Woodside are considered South San Mateo County. Because Bay Area counties differ in footprint, the number of sub-county city groupings varies from one (San Francisco and San Jose counties) to four (Santa Clara County). Estimates for sub-county areas are the sums of city-level estimates from the U.S. Census Bureau: American Community Survey (ACS) 2010-2017. The following incorporated cities and towns are included in each sub-county area: North Alameda County – Alameda, Albany, Berkeley, Emeryville, Oakland, Piedmont East Alameda County - Dublin, Livermore, Pleasanton South Alameda County - Fremont, Hayward, Newark, San Leandro, Union City Central Contra Costa County - Clayton, Concord, Danville, Lafayette, Martinez, Moraga, Orinda, Pleasant Hill, San Ramon, Walnut Creek East Contra Costa County - Antioch, Brentwood, Oakley, Pittsburg West Contra Costa County - El Cerrito, Hercules, Pinole, Richmond, San Pablo Marin – all incorporated cities and towns Napa – all incorporated cities and towns San Francisco – San Francisco North San Mateo - Brisbane, Colma, Daly City, Millbrae, Pacifica, San Bruno, South San Francisco Central San Mateo - Belmont, Burlingame, Foster City, Half Moon Bay, Hillsborough, San Carlos, San Mateo South San Mateo - East Palo Alto, Menlo Park, Portola Valley, Redwood City, Woodside North Santa Clara - Los Altos, Los Altos Hills, Milpitas, Mountain View, Palo Alto, Santa Clara, Sunnyvale San Jose – San Jose Southwest Santa Clara - Campbell, Cupertino, Los Gatos, Monte Sereno, Saratoga South Santa Clara - Gilroy, Morgan Hill East Solano - Dixon, Fairfield, Rio Vista, Suisun City, Vacaville South Solano - Benicia, Vallejo North Sonoma - Cloverdale, Healdsburg, Windsor South Sonoma - Cotati, Petaluma, Rohnert Park, Santa Rosa, Sebastopol, Sonoma
- API
Vital Signs: Life Expectancy – Bay Area
data.bayareametro.gov | Last Updated 2018-07-06T18:05:05.000ZVITAL SIGNS INDICATOR Life Expectancy (EQ6) FULL MEASURE NAME Life Expectancy LAST UPDATED April 2017 DESCRIPTION Life expectancy refers to the average number of years a newborn is expected to live if mortality patterns remain the same. The measure reflects the mortality rate across a population for a point in time. DATA SOURCE State of California, Department of Health: Death Records (1990-2013) No link California Department of Finance: Population Estimates Annual Intercensal Population Estimates (1990-2010) Table P-2: County Population by Age (2010-2013) http://www.dof.ca.gov/Forecasting/Demographics/Estimates/ CONTACT INFORMATION vitalsigns.info@mtc.ca.gov METHODOLOGY NOTES (across all datasets for this indicator) Life expectancy is commonly used as a measure of the health of a population. Life expectancy does not reflect how long any given individual is expected to live; rather, it is an artificial measure that captures an aspect of the mortality rates across a population. Vital Signs measures life expectancy at birth (as opposed to cohort life expectancy). A statistical model was used to estimate life expectancy for Bay Area counties and Zip codes based on current life tables which require both age and mortality data. A life table is a table which shows, for each age, the survivorship of a people from a certain population. Current life tables were created using death records and population estimates by age. The California Department of Public Health provided death records based on the California death certificate information. Records include age at death and residential Zip code. Single-year age population estimates at the regional- and county-level comes from the California Department of Finance population estimates and projections for ages 0-100+. Population estimates for ages 100 and over are aggregated to a single age interval. Using this data, death rates in a population within age groups for a given year are computed to form unabridged life tables (as opposed to abridged life tables). To calculate life expectancy, the probability of dying between the jth and (j+1)st birthday is assumed uniform after age 1. Special consideration is taken to account for infant mortality. For the Zip code-level life expectancy calculation, it is assumed that postal Zip codes share the same boundaries as Zip Code Census Tabulation Areas (ZCTAs). More information on the relationship between Zip codes and ZCTAs can be found at https://www.census.gov/geo/reference/zctas.html. Zip code-level data uses three years of mortality data to make robust estimates due to small sample size. Year 2013 Zip code life expectancy estimates reflects death records from 2011 through 2013. 2013 is the last year with available mortality data. Death records for Zip codes with zero population (like those associated with P.O. Boxes) were assigned to the nearest Zip code with population. Zip code population for 2000 estimates comes from the Decennial Census. Zip code population for 2013 estimates are from the American Community Survey (5-Year Average). The ACS provides Zip code population by age in five-year age intervals. Single-year age population estimates were calculated by distributing population within an age interval to single-year ages using the county distribution. Counties were assigned to Zip codes based on majority land-area. Zip codes in the Bay Area vary in population from over 10,000 residents to less than 20 residents. Traditional life expectancy estimation (like the one used for the regional- and county-level Vital Signs estimates) cannot be used because they are highly inaccurate for small populations and may result in over/underestimation of life expectancy. To avoid inaccurate estimates, Zip codes with populations of less than 5,000 were aggregated with neighboring Zip codes until the merged areas had a population of more than 5,000. In this way, the original 305 Bay Area Zip codes were reduced to 218 Zip
- API
Vital Signs: Street Pavement Condition - by City (Updated August 2018)
data.bayareametro.gov | Last Updated 2018-08-21T00:42:13.000ZVITAL SIGNS INDICATOR Street Pavement Condition (T16) FULL MEASURE NAME Pavement condition index (PCI) LAST UPDATED August 2018 DESCRIPTION Street pavement condition, more commonly referred to as the pavement condition index (PCI), reflects the quality of pavement on local streets and roads in the region. Calculated using a three-year moving average, PCI ranges from zero (failed) to 100 (brand-new) and has been used as a regional indicator of pavement preservation for over a decade. DATA SOURCE Metropolitan Transportation Commission: StreetSaver CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Pavement condition index (PCI) relies upon a three-year moving average for regional, county, and city PCI to improve the reliability of the PCI data on an annual basis. The index ranges from 0 to 100, with 0 representing a failed road and 100 representing a brand-new facility. Segment PCI data is collected on a rolling basis but is imputed for interim years based on facility age and treatments using the MTC StreetSaver system. Due to the lack of reported PCI data in 2007, the city of Palo Alto is not included in the Regional Distribution chart.
- API
Vital Signs: Street Pavement Condition - Bay Area (Updated October 2019)
data.bayareametro.gov | Last Updated 2019-10-15T03:16:14.000ZVITAL SIGNS INDICATOR Street Pavement Condition (T16) FULL MEASURE NAME Pavement condition index (PCI) LAST UPDATED October 2019 DESCRIPTION Street pavement condition, more commonly referred to as the pavement condition index (PCI), reflects the quality of pavement on local streets and roads in the region. Calculated using a three-year moving average, PCI ranges from zero (failed) to 100 (brand-new) and has been used as a regional indicator of pavement preservation for over a decade. DATA SOURCE Metropolitan Transportation Commission: StreetSaver CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Pavement condition index (PCI) relies upon a three-year moving average for regional, county and city PCI to improve the reliability of the PCI data on an annual basis. The index ranges from 0 to 100, with 0 representing a failed road and 100 representing a brand-new facility. Segment PCI data is collected on a rolling basis but is imputed for interim years based on facility age and treatments using the MTC StreetSaver system. Pavement condition data was not collected in 2008. As such, 2007 and 2009 PCI scores were averaged to compute a 2008 estimate for the region, county and city datasets. Due to a lack of reported PCI data for the city of Palo Alto in 2007, an average could not be calculated, so Palo Alto is not included in the Regional Distribution chart.
- API
Vital Signs: Housing Affordability - County by Income
data.bayareametro.gov | Last Updated 2019-10-25T20:43:10.000ZHousing Affordability (EQ2) FULL MEASURE NAME Housing Affordability LAST UPDATED October 2018 DATA SOURCE U.S Census Bureau: Decennial Census Form STF3 – https://nhgis.org (1980-1990) Form SF3a – https://nhgis.org (2000) U.S. Census Bureau: American Community Survey Form B25074 (2009-2017) Form B25095 (2009-2017) http://api.census.gov Image: Flickr (Creative Commons license), Photographer: Frank Kehren, https://www.flickr.com/photos/fkehren/8481894011 CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) The share of income brackets used for different Census and ACS forms varied over time. To allow for historical comparisons, the Census Bureau merges housing expenditure brackets into three consistent bins (less than 20 percent, 20 percent to 34 percent, and more than 35 percent) that work for all years. The highest income bracket for renters in the ACS data was $100,000 or more, while the homeowner dataset included brackets for $100,000 to $149,999 and $150,000 and above. These brackets were merged together to allow for uniform comparison across tenure. While some studies use 30 percent as the affordability threshold, Vital Signs uses 35 percent as this is the closest break point using the standardized affordability brackets above. Historical data for Napa County is unavailable due to an insufficient sample size for renters in a number of years, making it impossible to calculate affordability for all households. All ACS data is for a single year, rather than a rolling average. Income breakdown data is only provided for one year as it is not possible to compare consistent inflation-adjusted income brackets over time given Census data limitations.
- API
Vital Signs: Street Pavement Condition - by decade (Updated August 2018)
data.bayareametro.gov | Last Updated 2018-08-21T00:44:35.000ZVITAL SIGNS INDICATOR Street Pavement Condition (T16) FULL MEASURE NAME Pavement condition index (PCI) LAST UPDATED August 2018 DESCRIPTION Street pavement condition, more commonly referred to as the pavement condition index (PCI), reflects the quality of pavement on local streets and roads in the region. Calculated using a three-year moving average, PCI ranges from zero (failed) to 100 (brand-new) and has been used as a regional indicator of pavement preservation for over a decade. DATA SOURCE Metropolitan Transportation Commission: StreetSaver CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Pavement condition index (PCI) relies upon a three-year moving average for regional, county, and city PCI to improve the reliability of the PCI data on an annual basis. The index ranges from 0 to 100, with 0 representing a failed road and 100 representing a brand-new facility. Segment PCI data is collected on a rolling basis but is imputed for interim years based on facility age and treatments using the MTC StreetSaver system. Due to the lack of reported PCI data in 2007, the city of Palo Alto is not included in the Regional Distribution chart.
- API
Vital Signs: Jobs By Industry – Bay Area
data.bayareametro.gov | Last Updated 2019-08-13T16:19:32.000ZVITAL SIGNS INDICATOR Jobs by Industry (EC1) FULL MEASURE NAME Employment by place of work by industry sector LAST UPDATED July 2019 DESCRIPTION Jobs by industry refers to both the change in employment levels by industry and the proportional mix of jobs by economic sector. This measure reflects the changing industry trends that affect our region’s workers. DATA SOURCE California Employment Development Department: Current Employment Statistics 1990-2017 http://www.labormarketinfo.edd.ca.gov/ CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) The California Employment Development Department (EDD) provides estimates of employment by place of work and by industry. Industries are classified by their North American Industry Classification System (NAICS) code. Vital Signs aggregates employment into 11 industry sectors: Farm, Mining, Logging and Construction, Manufacturing, Trade, Transportation and Utilities, Information, Financial Activities, Professional and Business Services, Educational and Health Services, Leisure and Hospitality, Government, and Other. EDD counts all public-sector jobs under Government, including public transportation, public schools, and public hospitals. The Other category includes service jobs such as auto repair and hair salons and organizations such as churches and social advocacy groups. Employment in the technology sector are classified under three categories: Professional and Business Services, Information, and Manufacturing. The latter category includes electronic and computer manufacturing. For further details of typical firms found in each sector, refer to the 2012 NAICS Manual (http://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2012). The Bureau of Labor Statistics (BLS) provides industry estimates for non-Bay Area metro areas. Their main industry employment estimates, the Current Employment Survey and Quarterly Census of Employment and Wages, do not provide annual estimates of farm employment. To be consistent, the metro comparison evaluates nonfarm employment for all metro areas, including the Bay Area. Industry shares are thus slightly different for the Bay Area between the historical trend and metro comparison sections. The location quotient (LQ) is used to evaluate level of concentration or clustering of an industry within the Bay Area and within each county of the region. A location quotient greater than 1 means there is a strong concentration for of jobs in an industry sector. For the Bay Area, the LQ is calculated as the share of the region’s employment in a particular sector divided by the share of the nation’s employment in that same sector. Because BLS does not provide national farm estimates, note that there is no LQ for regional farm employment. For each county, the LQ is calculated as the share of the county’s employment in a particular sector divided by the share of the region’s employment in that same sector.