For my master’s thesis I’m using ArcMap to create maps based on a large historical dataset. I’m mapping individual movements over long periods of time. I’m struggling to design the database and figure out how I’m going to actually make the maps. Here, I’ve made a basic, scaled-down example of my project. I want to map which counties the individuals are living in, in 1880 and in 1910.
I have a spreadsheet of individual data:
It gives the county that each individual is living in in each year. There is no spatial data in it, just the names of counties and county ID
Using a file geodatabe, I made a feature classes of county boundaries as polygons:
Because the boundaries of counties change over the decades, I made one for 1880 and one for 1910. The counties each have a unique id (ID_NUM). I can use this unique ID to join or relate the two tables together.
My question is where do I go from here?
I want to create two maps. Where the individuals are living 1880 and where they are living in 1910.
Do I join or relate the individual table to both county tables?
Once the tables are connected somehow, how do I use the symbology of the county maps to show where the individuals are living?
How do I give spatial data to the individuals based on the spatial data from the county tables?
I don’t know exactly how to ask for what I need. I’m just at the start of this project and I’m feeling overwhelmed in how to design it.
I am looking to find out the number of individuals living in each county at each time period. Sort of like a population density map