New answers tagged census
The Field Calculator is the wrong tool for the job for the summary portion. Either use the Summary Statistics tool to create a summary table that has the FID as the case field and join it to the original and calculate the value over or create a standalone Python script that uses cursors and a dictionary to do the sums and write the values. For the Python ...
The National Historical Geographic Information System (NHGIS) might be worth looking at. They have made available aggregate US census data and GIS-compatible boundary files.
For metro data you would likely need to create a new shapefile and manually input the data for your cities. You can find historical city populations out there but I'm not sure if it's the most practical idea to use it. You should focus on using counties. https://www.census.gov/population/www/censusdata/pop1790-1990.html That is a link to historical US ...
Top 50 recent answers are included