Help required- extracting data from attribute table in arcgis pro

Question

Hi there,

I have an attribute table of nearly 575 records in arcgis pro. My task is to find through geocoding process students living over 120 miles away from a school campus. In the attribute table there is no column of 'distance' between student and school campus but instead I have street address of campus which is same for all 575 records however the student city address of where they live are different. Again how can I extract data through geocoding process only students living over 120 miles from a school campus. Much appreciate if you can advise on how to approach this task.

jskinner · Accepted Answer

Hi @FawazAmjad35,

Here is a workflow you could do:

1.  Create a separate table of only the school campus address

2.  Geocode the school campus address

3.  Buffer the result by 120 miles

4.  Geocode the attribute table that contains all 575 records

5.  Perform a Select by Location to select the addresses that do not intersect the 120 mile buffer

FawazAmjad35 · Accepted Answer

to select student addresses which fall outside buffer, would I be using SQL Query tool for it?