Zip Code Population by County

HI,  My county shares several zip codes with other counties.  How can I best determine the population for the portion of the zip code that is only in my county?  Thanks!

 

    

Marti Morris

Data Analyst

Public Health

 

Phone: 704.853-5097 

Mobile: 704-996-0422

 

991 W. Hudson Blvd.

Gastonia, NC 28052

 

www.gastongov.com

 

| | |  

Parents
  • Using Geocorr at the University of Missouri I got what I think you're looking for by using ZCTA as the "source" and county as the "target" example below, link is

    mcdc.missouri.edu/.../geocorr2022.html

    ZIP census
    tabulation
    area
    ZIP Code name County code County name Total population
    (2020 Census)
    zcta-to-county
    allocation
    factor
    21771 Mount Airy, MD 24013 Carroll MD 13,276 0.4325
    24021 Frederick MD 13,868 0.4518
    24027 Howard MD 3,172 0.1033
    24031 Montgomery MD 381 0.0124
  • Dear Marti,

    I'm not sure how Geocorr works.  Since I use R I download the mapping data and check for the tracts (or block groups in this case) that have an intersection with the chosen ZCTA geography.  This method uses only the "raw" mapping data so it is pretty complicated. Once I have the tracts (or block groups) that intersect the larger geography I add up the populations for the individual tracts (or blockgroups). Likely not too helpful  in this case.

    Dave

  • Geocorr works by reducing both source and target geographies into collections of blocks -- the "atoms", if you will. We know the population of every block. So we can take all the blocks that are in ZCTA 21771 (say) and add up the populations of all those blocks that are also in county #24013, divide by the total ZCTA population to get the allocation factor, then repeat for any other counties that are partially covered by that ZCTA. That's why the allocation factors should always add up to 1, although there are sometimes rounding errors.

  • Yes entirely possible to do it yourself with block definition files and block populations. Did it in Florida after 2000 census to find the 1990 footprint of some  areas, for comparison, that had changed radically in 10 years. 
    it makes more sense now than it will in 5 years as change continues

  • Dear Glenn,

    I'm curious does Geocorr give you the fips codes for the "common" block groups ? What about statistics other than the total population ?

    Dave

  • Just as a comment, if you use my "brute force" method you can't just check for a "non-null" intersection between polygons. Some "adjacent" polygons may have a non-zero intersecting area because of an intersection along the border of two adjacent polygons.  I think that i allow 400 sq meters or so of overlap without including the polygon within the the larger polygon.

  • Thank you for taking the time to reply!  Since I'm not familiar with R, this is a little beyond my skillset, but I appreciate the concept as you've described it.

Reply Children
No Data