AnsweredAssumed Answered

Spatial Join Merge Rules?

Question asked by afa18_TxSt on Apr 24, 2020
Latest reply on Apr 26, 2020 by

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