I have two datasets with columns described below:

A list of all "place" names derived from here (US Census):

enter image description here

And this one, a list of county FIPS codes, also derived from the US Census (here)

enter image description here

I need to match the placefp codes (shown above in the first able) with the countyfips codes (shown above in second table), e.g. get the county for every "place." I can't seem to find a mapping of the place FIPS to the county FIPS, and it doesn't appear that the counties are included

Where could I find a mapping of the "place" FIPS codes to the county FIPS codes?

  • If this is open data then it may be worth researching/asking at the Open Data Stack Exchange. – PolyGeo Apr 11 '18 at 23:42
  • You can do a join on state code and county name – Ian Turton Apr 12 '18 at 7:26
  • @IanTurton just didn't know if that would be sufficient to accurately match up the records. – Joseph Dasenbrock Apr 12 '18 at 16:03

Check out the Urban Area Relationship Files published by the Census.

The 2010 urban area relationship files provide simple relationships between the 2010 urban areas and other 2010 Census tabulation geography: counties, county subdivisions (in states with governmental minor civil divisions only), places (incorporated places and census designated places), metropolitan and micropolitan statistical areas, New England city and town metropolitan and micropolitan statistical areas (NECTAs), and ZIP Code tabulation areas (ZCTAs). A 2010 urban area relationship file also describes the relationship between 2010 and Census 2000 urban areas. From these files, data users may determine which urban areas exist within the other geographies and vice versa.

EDIT: Actually, this appears to only map UA to county, UA to place, etc. not the place to county. Have you tried any spatial joins between the place and the county layers?

EDIT2: Found a FIPS reference file produced by the Census for year 2016. There's probably a similar file for your year of interest, although I did not immediately find the 2010 file.

2016 FIPS file: https://www.census.gov/geographies/reference-files/2016/demo/popest/2016-fips.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.