Welcome to the State of California 

Healthy Communities Data and Indicators Project (HCI)

Goals

The goal of HCI is to enhance public health by providing data, a standardized set of  statistical measures, and tools that a broad array of sectors can use for planning healthy communities and evaluating the impact of plans, projects, policy, and environmental changes on community health. The initial phase of the project (2012-2014) was a 2-year collaboration of the California Department of Public Health (CDPH) and the University of California, San Francisco (UCSF) with funding by the Strategic Growth Council (SGC), to create and disseminate indicators linked to the Healthy Communities Framework. This framework was developed by the SGC Health in All Policies Task Force with extensive public discussion and input from community stakeholders and public health organizations (read the Task Force report to the SGC). 

Project Description

Project Summary and Background (PDF, 61KB)

Core List of Indicators (10/17/2014) (PDF, 302KB)

Products

Data and Indicators Now Available: Excel files with data for California, its counties, cities, towns, and census tracts (depending on availability) and narrative pdf files for each indicator.

Users' Tool Kit: creating maps, graphs, tables, and explanatory texts with the indicators' data files.

Technical Information: detailed information about the project, indicator production, and SAS code.

Contact

Please send your comments or questions to (HCIOHE@cdph.ca.gov).

 

Back to Office of Health Equity Home Page

 

Healthy Communities Framework

 

 Back to top

 

Data and Indicators Now Available

The first phase of the HCI (2012-2014) produced 21 indicators from the core list. We are starting a second phase and we are now vetting data sources and developing the methods to construct the remaining indicators, and to update the ones already produced. As we construct indicators, we would like to share the information we have gathered about each indicator – its significance to health, evidence that links the indicator to health outcomes, data sources, bibliographic references, the methods we used, and limitations that impact the interpretation of the indicator. We also will share examples of maps, charts, and tables from the data files we have created and posted below. We invite you to download the pdfs and Excel data files and use them to create maps, charts, and tables of your own community. Please give us your feedback so we can improve these data products. We will post data for additional indicators as they become available.

  

Healthy Communities Framework ‒ What is a Healthy Community?

►Meets Basic Needs of All

pdf    xls    ■■■■■  Food Affordability: average cost of a market basket of nutritious food items relative to income 

pdf    xls    ■■■■■  Access to healthy foods: retail food environment index  

    pdf    xls    ■■■■■ Access to Parks: Percent of residents within ½ mile of a park, beach, or open space

    pdf         ■ Public Transit Access: Percent of population residing within ½ mile of a major transit stop

     Bay Area*          Southern California        San Diego County          Sacramento County Area

    pdf          ■■■■■■■■ Severe and fatal road traffic injuries (rate per mile traveled) (rev.12/17/13)

    Alameda-Nevada Counties, State, Regions      Orange-Yuba Counties 

    pdf    xls    ■■■■■ Percent of residents mode of transportation to work (rev.12/12/13)

    pdf    xls    ■■■■■ Miles per capita by car, public transit, and walk/bicycle 

    pdf    xls    ■■■■■ Percent of residents by time walking and bicycling  (rev. 3/26/14)

    pdf         ■■■■■■■■■ Housing Cost Burden: Percent of households incurring housing cost burdens (rev. 7/30/14)

                                 Alameda-Nevada Counties, State, Regions     Orange-Sutter Counties   Tehama-Yuba Counties

    pdf    xls   ■■■■■ Household Crowding: Percent of household overcrowding and severe overcrowding

    ►Quality and Sustainability of Environment

    pdf    xls     ■■■■■ Annual Average Number of Unhealthy Days of Ozone Air Pollution   

    pdf    xls     ■■■■■ Average Ambient PM2.5 Concentration   

    pdf        ■■■■■ Unsafe Drinking Water: Percent of the population served by Community Water Systems not meeting Safe Drinking Water Act  regulations

    Alameda-Nevada Counties, State, Regions   Orange-Yuba Counties

    Adequate Levels of Economic, Social Development

    pdf    xls     ■■■■■ High School or Greater Educational Attainment in the Population Aged 25 Years and Older    

    pdf    xls     ■■■■■ Living Wage (single mother with children and married couple with children) 

    pdf    xls     ■■■■■ Poverty Rate: Overall, Concentrated, and Child (under 18 years of age)

    pdf   xls     ■■■■■ Unemployment Rate

    Health and Social Equity

    pdf    xls     ■■■■■ Income Inequality: Household income relative to the number of households (Gini Index) (rev. 3/26/14)

    Social Relationships that are Supportive and Respectful

    pdf     xls     ■■■■■ Number of Violent Crimes per 1,000 population  

    pdf     xls    ■■■■■ Voter Registration/Participation: Percent of the eligible population registered to vote and the percent who voted in statewide elections

    pdf      ■■■■■ Proximity to Alcohol Outlets: Percent of the population within ¼ mile of alcohol outlets

    Alameda-Nevada Counties, State, Regions   Orange-Yuba Counties

                                                                                                                                                                                                                                                          

    * Replaces previous indicator based on residence within ½ mile of a regional transit stop and  ¼ of a local transit stop 

     

    Back to Data and Indicators Now Available

    Back to top

     

     

    Users' Tool Kit

    In this section we have included the materials and procedures – a tool kit – that a person moderately skilled in Excel can use to create maps, graphs, tables and explanatory text for indicators for their community or geographic area of interest. The tool kit will show you:

    • Step-by-step instructions to combine data and templates into custom reports for your community.
    • Templates for creating maps, graphs, tables, and explanatory text.
    • A framework to help you interpret results.

     

    Step-by-step Instructions

    How-To Manual and Illustrative Guide

             High Resolution PDF (27 MB) or Low Resolution PDF (6 MB)

    Templates and Examples

    xls  Template for a Community Report Card

    xls  Example of a Community Report Card

    shp Map templates: four shape files, boundaries for California Census tracts, cities/towns (places), counties and regions (2010)

     

    Back to top 

     

      

    Technical Information

    In this section we have included a Technical Manual that presents definitions, data sources, data preprocessing, and methodological details on the construction of the 21 indicators completed up to date.  It also presents data sources and methodological notes about the indicators under construction.  Each indicator is presented as a separate chapter in the manual in two separate sections “Completed Indicators” and “Indicators under Construction.”  The intended audience of this technical manual is epidemiologists or data analysts interested in replicating the construction of the indicators. 

    pdf Technical Manual

    In addition to the Technical Manual we include the SAS files that were used to construct the indicators and that were used to generate the data files.  These files are intended as a reference for the coding used. The formatted source data is needed to reproduce the analysis.  The source data is available upon request.

     

    SAS files

    sas Food Affordability: average cost of a market basket of nutritious food items relative to income
    sas Access to healthy foods: retail food environment index  
    sas Access to Parks: Percent of residents within ½ mile of a park, beach, or open space

     sas Public Transit Access: Percent of population residing within ½ mile of a major transit stop

     sas Severe and fatal road traffic injuries (rate per mile traveled)

    sas Percent of residents mode of transportation to work

    sas Miles per capita by car, public transit, and walk/bicycle 

    sas Percent of residents by time walking and bicycling

     sas Housing Cost Burden: Percent of households incurring housing cost burdens (ACS data)

     sas Housing Cost Burden: Percent of households incurring housing cost burdens (CHAS data)      

     sas Household Crowding: Percent of household overcrowding and severe overcrowding

    sas Annual Average Number of Unhealthy Days of Ozone Air Pollution  

    sas Average Ambient PM2.5 Concentration  

    sas Unsafe Drinking Water: Percent of the population served by Community Water Systems not meeting Safe Drinking Water Act  regulations

    sas High School or Greater Educational Attainment in the Population Aged 25 Years and Older   

    sas Living Wage (single mother with children and married couple with children) 

    sas Poverty Rate: Overall, Concentrated, and Child (under 18 years of age)

    sas Unemployment Rate

    sas Income Inequality: Household income relative to the number of households (Gini Index)

    sas Number of Violent Crimes per 1,000 population  

    sas Voter Registration/Participation: Percent of the eligible population registered to vote and the percent who voted in statewide elections

    sas Proximity to Alcohol Outlets: Percent of the population within ¼ mile of alcohol outlets

     

    Back to top

     

     
     
    Last modified on: 11/3/2014 6:03 PM