Joining data on congressional districts

Unfortunately, it is not a straightforward process to conduct the process if you’re not familiar with geospatial software. The basic outline is:

  1. Obtain 51 census block shapefiles from 2000
  2. Obtain the CD and ZCTA shapefiles
  3. Merge them into a nationwide file
  4. Convert the blocks to centroids
  5. Overlay the centroids on the CD shapefile
  6. Overlay the centroids on the ZCTA shapefile
  7. Merge the results of (4) and (5) into a single data file
  8. Merge the results of (6) with the 2000 census block populations
  9. Roll up (8) by unique combinations of ZCTA and CD codes

You would also be handling large files because there were ~7 million census blocks in 2000.