I have all the postal code destinations of a city plotted as points (reference table). I also have a table of people and their age and postal code. I need to map this.
Using a geocoder, i plotted all the people by postal code. However, there are many people within the same postal code. Therefore, whereas there may be 5 individuals, it only shows up as one dot on the map.
I did a spatial join to do this (essentially joining city postal code points with people's postal code points), and it works, BUT, the problem is the people's postal code points are being joined with more than 1 city postal code points. I think this is because of the overcrowing of city postal code points resulting in spatial overlap between more than one point.
I am pretty bad at explaining this, so i attached an image of what i am hoping for. the colour represents the age range, and the size of the dot represents the number of individuals living at the postal code. Essentially what i am asking is: how can you do a 1 to 1 (point to point) spatial join. Without the 1 to 1 join, some dots (as seen on my sample image) are larger than what they are supposed to.
أكثر...
Using a geocoder, i plotted all the people by postal code. However, there are many people within the same postal code. Therefore, whereas there may be 5 individuals, it only shows up as one dot on the map.
I did a spatial join to do this (essentially joining city postal code points with people's postal code points), and it works, BUT, the problem is the people's postal code points are being joined with more than 1 city postal code points. I think this is because of the overcrowing of city postal code points resulting in spatial overlap between more than one point.
I am pretty bad at explaining this, so i attached an image of what i am hoping for. the colour represents the age range, and the size of the dot represents the number of individuals living at the postal code. Essentially what i am asking is: how can you do a 1 to 1 (point to point) spatial join. Without the 1 to 1 join, some dots (as seen on my sample image) are larger than what they are supposed to.
أكثر...