Child and Adult Care Food Program (CACFP) Sites, 2020

cde.ca.gov-cacfp_sites-1.2.1 Last Update: 2021-02-25T01:20:08

The Child and Adult Care Food Program (CACFP) provides federal funding to participating child care and adult day care centers, allowing the centers to serve nutritious meals to enrolled participants

California Department of Education CACFP sites file, with extra features, include:

• Sites geocoded to Lat/Lon and Census tract
• The program_types field is broken out into dummy variables
• CDS codes are matched from the CDE schools list.

CDS Code Matching

There are 5 different methods for matching sites to schools in the schools file, each with its own code:

• fhs: Fuzzy hash string, a has string based n the address.
• fhs_nz: The fuzzy hash strin, but without the zip code, which occasionally is wrong or changes.
• name_city: A lightly normalized ( alpha only, lowercase, combination of the site name and the site city
• name_county: A lightly normalized combination of the site name and county
• mp_name: The site name and county, with each word converted to it's metaphone.

The matching method code is included in the match_type columns. For many of the matching types there can be more than one CDS code associated with the matching string, particularly the strings based on addresses. The match_qc value is the inverse of the number of values with the same matching code, so if the algorithm selected the first of 5 CDS codes, the match_qc value is .2

Only about of the 35% of the 5076 sites are matched. The number matched for each type of matching tecchnique is:

Not Matched    3292
fhs            1602
name_city       161
name_county      19
mp_name           1
fhs_nz            1

Versions

1. Initial version
2. Add faked CDS codes for sites that are not schools

Documentation Links

• Program home page
• Download page

Contacts

• Wrangler Eric Busboom, Civic Knowledge

Resources

• cacfp_sites. CACFP sites, with location geocode and program type dummy variables

References

• site_geocodes, data/geocodes.csv. Externally geocoded site locations. Geocoded with Geocodio.io
• cacfp_sites_source. List of Child and Adult Care Food Program (CACFP) sites
• schools, metapack+http://library.metatab.org/cde.ca.gov-schools-1.csv#public_schools. California schools and districts
• ca_county_codes, metapack+http://library.metatab.org/sandiegodata.org-county_codes-ca-1.csv#ca_county_codes. California government codes for counties, used in CDS codes