Cook County Nutrition Program Mapping Project Final Report March 20, 2007 Project Members: CLOCCWork John Brady Allison Fitzpatrick Phillip Jones (GIS 242, Section 801) Project Client: Consortium to Lower Obesity in Chicago Children (CLOCC) Client Contact: Lara Jones Jaskiewicz2 Table of Contents 1. Introduction……………………………………………………………………………3 2. Needs Assessment 2.1 Background…………………………………………………………………..4 2.2 Literature Review……………………………………………………………4 2.3 Project Goal………………………………………………………………….7 2.4 Objectives……………………………………………………………………7 2.5 Information Products………………………………………………………...8 3. System Requirements 3.1 Introduction………………………………………………………………….9 3.2 Data Requirements as a Conceptual Database Design……………………..11 3.2.1 Matrix of Need to Know Questions cross-referenced with entity class…………………………………………………..11 3.2.2 Entity Relationship Modeling…………………………………….11 3.2.3 Entity Relationship Diagram……………………………………..14 3.3 Software Requirements……………………………………………………..15 3.3.1 Matrix of Need to Know Questions cross-referenced with software functions…………………………………………..15 3.4 Personnel Requirements…………………………………………………….15 3.5 Timing………………………………………………………………………16 3.6 Institutional Requirements…………………………………………………..17 4. Data Acquisition 4.1 Introduction…………………………………………………………………18 4.2 Data Dictionary……………………………………………………………..19 4.3 Data Source Steps…………………………………………………………..21 4.4 Fitness for Use………………………………………………………………21 4.5 Data Acquisition Constraints………………………………………………..22 5. Data Analysis 5.1 Introduction………………………………………………………………….22 5.2 Analysis Plan………………………………………………………………..24 6. Results 6.1 Introduction………………………………..………………………………..35 6.2 Maps 6.1-6.10 and descriptions…………………………………………….35 Works Cited for Literature Review……………………………………………………..493 1- Introduction CLOCCWork consists of John Brady, Allison Fitzpatrick, and Phillip Jones. The group worked with Ms. Lara Jones Jaskiewicz who is the Project Manager of the Chicago Consortium to Lower Obesity in Chicago Children (CLOCC). The overall goal of the project was to create documentation on nutrition programs in Cook County. Ms. Jones Jaskiewicz intent for the project was to ‘outline and map Federal, State, and local nutrition programs in Chicago and Illinois.’ Ms. Jones envisioned maps that would ‘cover the flow of funding between agencies and organizations, individual program structure and eligibility requirements, what organizations provide the program for Chicago/Illinois residents, and how residents can access the program. Ms. Jones Jaskiewicz sought our assistance this project because of the strong need for the integration and compilation of data on the funding and servicing of nutrition and feeding programs. Ultimately, CLOCCWork came to understand the necessity of research beyond what could be accomplished by three people in two months. The scope of the group’s project had to limited more than was initially envisioned. With the data that was acquired, the group was able to focus on two programs, the Special Supplemental Nutrition Program for Women, Infants, and Children (WIC), as well as the Commodity Supplemental Food Program (CSFP), and was able to also show access to these programs via localized public transportation (the El Train), and income demographics around the program facilites.4 2- Needs Assessment 2.1 Background The Consortium to Lower Obesity in Chicago Children (CLOCC) “is a nationally recognized childhood obesity prevention program housed within the Center for Obesity Management and Prevention (COMP) at the Children’s Memorial Research Center of Children’s Memorial Hospital. CLOCC is a data-driven effort that brings together hundreds of organizations and individuals in Chicago, with a common goal of protecting Children from the effects of the obesity epidemic.” The primary contact for this project is Project Director, Lara Jones Jaskiewicz. The expected purpose of the project was to outline and map Federal, State and local nutrition programs in Chicago and Illinois. Contact information was provided by CLOCC’s project director to representatives of the Interagency Nutrition Council (INC) and Chicago Food System Collaborative (CFSC). These contacts were to assist in obtaining information needed from agencies and programs concerned with this project; Special Supplemental Nutrition Program for Women, Infants & Children (WIC), Commodity Supplemental Food Program (CSFP), Child and Adult Food Care Program (CACFP), The Emergency Food Assistance Program (TEFAP), Food Stamp Program (FSP), Summer Nutrition Participation (SNP). 2.2 Literature Review In conducting its literature review, CLOCCWork found that nearly every resource the group obtained called for reforms that directly coincided with the goal or the project;5 ‘map federal, state, and local nutrition programs in Chicago…The map will cover the flow of funding between agencies and organizations, individual program structure and eligibility requirements…and how residents can access the programs.’ Due to time