topic Re: Spatial Join Merge Rules? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/spatial-join-merge-rules/m-p/420927#M18704 <HTML><HEAD></HEAD><BODY><P>Try swapping your target and join features, but retain the 'sum' merge rule</P></BODY></HTML> Sun, 26 Apr 2020 11:46:03 GMT DavidPike 2020-04-26T11:46:03Z Spatial Join Merge Rules? https://community.esri.com/t5/arcgis-pro-questions/spatial-join-merge-rules/m-p/420926#M18703 <HTML><HEAD></HEAD><BODY><P>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?&nbsp;</P><P></P><P>If you need more clarification please don't hesitate to ask</P><P></P><P>spatial join‌ <A href="https://community.esri.com/t5/tag/points density/tg-p">#points density</A>‌ <A href="https://community.esri.com/t5/tag/population density/tg-p">#population density</A>‌ <A href="https://community.esri.com/t5/tag/density analysis/tg-p">#density analysis</A>‌ <A href="https://community.esri.com/t5/tag/density/tg-p">#density</A>‌ <A href="https://community.esri.com/t5/tag/merge rule/tg-p">#merge rule</A>‌ <A href="https://community.esri.com/t5/tag/census block/tg-p">#census block</A>‌ population data&nbsp;<A href="https://community.esri.com/t5/tag/arcpro 2.3/tg-p">#arcpro 2.3</A>‌ <A href="https://community.esri.com/t5/tag/arcpro/tg-p">#arcpro</A>‌</P></BODY></HTML> Fri, 24 Apr 2020 22:05:47 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join-merge-rules/m-p/420926#M18703 AnalieArmendariz 2020-04-24T22:05:47Z Re: Spatial Join Merge Rules? https://community.esri.com/t5/arcgis-pro-questions/spatial-join-merge-rules/m-p/420927#M18704 <HTML><HEAD></HEAD><BODY><P>Try swapping your target and join features, but retain the 'sum' merge rule</P></BODY></HTML> Sun, 26 Apr 2020 11:46:03 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join-merge-rules/m-p/420927#M18704 DavidPike 2020-04-26T11:46:03Z