Problem comparing ESRI census tract centroid to SQL Server point centroid

183
3
07-27-2017 12:36 PM
Highlighted
New Contributor

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?  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.  

Reply
0 Kudos
3 Replies
Highlighted
MVP Regular Contributor

What are you trying to compare?  Number of results yielded by each process?  Difference of address values between the two?

Reply
0 Kudos
Highlighted
New Contributor

The number of tracts returned within a one mile radius.

Reply
0 Kudos
Highlighted
MVP Regular Contributor

You can use the Select By Location tool and specify a search radius within that.  Also, you can select a feature within ArcMap and use only that selected feature (center point) as the search input. 

Reply
0 Kudos