GIS in the WIC Environment PHFE-WIC Mike Whaley November 2009 NWA Tech Conference
PHFE-WIC • California Local Agency g y • 700 WIC employees, 63 WIC locations • 330,000 enrolled in WIC in our local agency 330,000 enrolled in WIC in our local agency • 46 Servers 74 firewalls/routers 750 workstations 46 Servers, 74 firewalls/routers, 750 workstations • Software development, 15 systems developed
GIS Source Data • California WIC MIS System – ISIS y • Share MONTHLY demographic information with us Share MONTHLY demographic information with us – 350,000 individuals monthly; 1.3 million unique – Addresses, WIC services, weights, risks, income, breastfeeding, education language ethnicity DOB EDD etc education, language, ethnicity, DOB, EDD, etc… – Automated 2000 charts
GIS Mapping pp g • Map center locations > p • Map participants in areas for center location planning >
WIC Data Used in Research • Obesity rates in 4 year old children Age 4 Obesity Rates by Zipcode Data Collected March 2009 - WIC Children Only • Green zip codes: < 20% of G i d < 20% f the kids are obese. Y2009Rate (Sum) 7% - 16% 16% - 19% 20% - 22% 22% - 23% 23% - 26% 26% - 35% Only zipcodes with more than 25 age 4 children in the sample are included. SAS Map
WIC Data in Outreach Planning • Impact of the economy on WIC in the last year? Impact of Economy on WIC This Last Year? Change in Total WIC Population by Zipcode (2008 to 2009) Data Collected March of Each Year • March 2008 VS March 2009 • Green zipcodes have had a decrease in WIC participation participation. • Overlay other Overlay other data sources ChangeInTotalPopulation (Sum) -345 - -35 -29 - -2 -1 - 4 5 - 24 25 - 56 57 - 404 such as food Data Source: WIC Data Mining Dataset - WIC ISIS System stamps? stamps? SAS Map
WIC Data for the Public • Publish WIC data in a GIS format on the Internet. • Available to: • Available to: – the public – Politicians – Community groups
WIC Data for the Public • We entered into a partnership with a non-profit. ($7000/yr) Map of medical facilities in an area facilities in an area – HealthCity.org • Contains community services information. i i f ti Education, legal services, animal services, public assistance, disaster services, arts & culture, volunteer activities, counseling, etc…
Healthy City Data Sources y y • Population datasets • Adults lacking health insurance – Green areas are bad
WIC Data on HealthyCity.org y y g • PHFE-WIC partnered p with First Five LA • Yearly datasets since 2003 up to 2009 • All of LA County County wide By city y y Zip code Census tract SPA WIC Participants by Zipcode
What WIC Data is Available? • Moms, infants, children , , • By age (teens, etc…) • Race, Weight/Obesity Race, Weight/Obesity • Preferred languages • Breastfeeding statistics Breastfeeding statistics • Education & Income Green areas Green areas have a significant percent of the population living l ti li i below the By year … with trending poverty level.
Who can see this WIC data? • Available FREE to the public, no passwords • Politicians – during outreach visits g • Community groups • Research grants g www HealthyCity org www.HealthyCity.org
How does this work? • We do not give them the raw data. Healthy City website • We publish available data using web service using web service web service web service technology. • We create summary levels Across internet and hide certain things to maintain confidentiality. PHFE W b S PHFE Web Service i • We maintain control of what is PHFE Database published and pub s ed a d when (and track) Servers @ PHFE
Plans • Other California counties have contacted us to do this for their county. • We hope to go California state wide this year. • The same software architecture would be used.
Examples…. Depending on time g p p
By City, zip, census tract, county
Families with 0 to 4 years of education
Public WIC GIS Information • Questions? Greener zip codes h have higher WIC hi h WIC breastfeeding rates www.HealthyCity.org www.HealthyCity.org www.LAWICData.org
Recommend
More recommend
