AnsweredAssumed Answered

Spatial Join Merge Rules?

Question asked by afa18_TxSt on Apr 24, 2020
Latest reply on Apr 26, 2020 by Davepike101@hotmail.com

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

Outcomes