Can someone advise if there is a way to get a list of county subdivisions associated with all census tracts?
Thanks for any help
Right, I'd forgotten you may be looking for the 2020 relationships, and Geocorr doesn't have those yet. (Looking forward to that, Glenn!)Joe Germuska shared another good idea, but you wouldn't need…
You could do this with the geoheader files from the PL-94 (redistricting) release:
- Select all the blocks (sumlev 750)
- keep the STATE, COUNTY,TRACT, and COUSUB columns
- reduce to unique rows
- combine STATE, COUNTY,TRACT, for unique tract ID and STATE, COUSUB for unique county subdivision ID
If you use python, I've got this code to simplify reading in the data
https://gist.github.com/JoeGermuska/8da7a3e5e86600f26a48f2d3ce68910b
or you could do it with csvgrep and csvcut from the csvkit tools
https://csvkit.readthedocs.io/en/latest/