topic Re: Problem comparing ESRI census tract centroid to SQL Server point centroid in Data Management Questions https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233375#M13262 <HTML><HEAD></HEAD><BODY><P>You can use the Select By Location tool and specify a search radius within that. &nbsp;Also, you can select a feature within ArcMap and use only that selected feature (center point) as the search input.&nbsp;</P></BODY></HTML> Fri, 28 Jul 2017 18:02:51 GMT MitchHolley1 2017-07-28T18:02:51Z Problem comparing ESRI census tract centroid to SQL Server point centroid https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233372#M13259 <HTML><HEAD></HEAD><BODY><P>How would I make a valid comparison using ARCGIS census tract population centroids within a one mile radius of an address to the results using a SQL Server geography spatial index of latitude and longitude points of centers of population within a one mile radius around the same address?&nbsp; When counting the census tracts with population weighted centroids from ESRI ARCGIS that are within a one mile radius around an address in San Francisco, California as compared to the US Census Bureau center of population census tract points within a one mile radius of the same address as indicated by latitude and longitude using a SQL Server geography spatial index of the points, I am computing significantly different results.&nbsp;&nbsp;</P></BODY></HTML> Thu, 27 Jul 2017 19:36:12 GMT https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233372#M13259 LizKuhn 2017-07-27T19:36:12Z Re: Problem comparing ESRI census tract centroid to SQL Server point centroid https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233373#M13260 <HTML><HEAD></HEAD><BODY><P>What are you trying to compare? &nbsp;Number of results yielded by each process? &nbsp;Difference of address values between the two?</P></BODY></HTML> Thu, 27 Jul 2017 19:55:13 GMT https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233373#M13260 MitchHolley1 2017-07-27T19:55:13Z Re: Problem comparing ESRI census tract centroid to SQL Server point centroid https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233374#M13261 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 11.0pt; color: #1f497d;">The number of tracts returned within a one mile radius.</SPAN></P></BODY></HTML> Fri, 28 Jul 2017 13:57:15 GMT https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233374#M13261 LizKuhn 2017-07-28T13:57:15Z Re: Problem comparing ESRI census tract centroid to SQL Server point centroid https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233375#M13262 <HTML><HEAD></HEAD><BODY><P>You can use the Select By Location tool and specify a search radius within that. &nbsp;Also, you can select a feature within ArcMap and use only that selected feature (center point) as the search input.&nbsp;</P></BODY></HTML> Fri, 28 Jul 2017 18:02:51 GMT https://community.esri.com/t5/data-management-questions/problem-comparing-esri-census-tract-centroid-to/m-p/233375#M13262 MitchHolley1 2017-07-28T18:02:51Z