Spatial Join Merge Rules?

04-24-2020 03:05 PM
New Contributor

Hey all I'm creating a spatial join with apartments in a city and census blocks. In the apartment attribute table there's a field containing number of beds per apartment. The reason for the spatial join is to see the density of beds to population per census block. My problem is when i go ahead and join the two shapefiles, for every apartment complex I get the population count for EVERY apartment complex. I want to be able to see the total number of beds per block so that i get a more accurate density. I've tried the Merge rule sum for the number of beds attribute, but it doesn't seem to be working. Is there any other merge rule I could use? 

If you need more clarification please don't hesitate to ask

spatial join‌ #points density#population density#density analysis#density#merge rule#census block‌ population data #arcpro 2.3#arcpro

0 Kudos
1 Reply
MVP Frequent Contributor

Try swapping your target and join features, but retain the 'sum' merge rule

0 Kudos