Building 118th Congress Congressional Districts from Census Tracts

I am using the ACS to produce some demographic statistics by Congressional District (CD), based on the districts drawn for the 118th Congress. The ACS data tool (data.census.gov) is still using boundaries from the 116th Congress. The smallest geography that can be extracted from the ACS data tables is census tract, so I am attempting to sum up census tracts by congressional district.

To do this, I used the GeoCorr tool at the Missouri Census Data Center (https://mcdc.missouri.edu/) to generate a crosswalk from census tracts to CDs. This gives me factors to apply when a census tract crosses multiple CDs. But that gives me multiple records for such census tracts, causing a many-to-many merge situation when I try to merge this crosswalk with the ACS tract-level data.

First, is this the best way to go about constructing 118th Congress district-based estimates from the ACS?

Second, how should I resolve the many to many merge?

Thank you!

Top Replies