topic Census Tracts and Addresses in Data Management Questions https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93707#M5513 <HTML><HEAD></HEAD><BODY><P>I have a dataset of patient addresses. I want to combine the address with cesus tracts. how would I go about inputing how may addresses are in each census tract so I can symoblize that amount and not show the exact location of the patients?</P></BODY></HTML> Tue, 27 Mar 2018 17:49:12 GMT StephenGrassia3 2018-03-27T17:49:12Z Census Tracts and Addresses https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93707#M5513 <HTML><HEAD></HEAD><BODY><P>I have a dataset of patient addresses. I want to combine the address with cesus tracts. how would I go about inputing how may addresses are in each census tract so I can symoblize that amount and not show the exact location of the patients?</P></BODY></HTML> Tue, 27 Mar 2018 17:49:12 GMT https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93707#M5513 StephenGrassia3 2018-03-27T17:49:12Z Re: Census Tracts and Addresses https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93708#M5514 <HTML><HEAD></HEAD><BODY><P>Hi Stephen,</P><P></P><P>If you have ArcGIS Pro you can use the <A href="http://pro.arcgis.com/en/pro-app/tool-reference/analysis/summarize-within.htm">Summarize Within</A> tool.&nbsp; If you are using ArcGIS Desktop, you can accomplish this using the Spatial Join tool.&nbsp; Before running the tool, create a new field in the patient address feature class called something like "COUNT".&nbsp; Calculate the value of this to 1 for each row.&nbsp; When executing the Spatial Join you can specify a merge rule to SUM.&nbsp; Here is a very old help document that shows this:</P><P></P><P><A class="link-titled" href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Example%20of%20aggregating%20field%20values%20with%20Spatial%20Join" title="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Example%20of%20aggregating%20field%20values%20with%20Spatial%20Join">ArcGIS Desktop Help 9.2 - Example of aggregating field values with Spatial Join</A>&nbsp;</P></BODY></HTML> Tue, 27 Mar 2018 18:25:08 GMT https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93708#M5514 JakeSkinner 2018-03-27T18:25:08Z Re: Census Tracts and Addresses https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93709#M5515 <HTML><HEAD></HEAD><BODY><P>It worked. Thank you so much</P></BODY></HTML> Wed, 28 Mar 2018 15:04:37 GMT https://community.esri.com/t5/data-management-questions/census-tracts-and-addresses/m-p/93709#M5515 StephenGrassia3 2018-03-28T15:04:37Z