Help required- extracting data from attribute table in arcgis pro

[FawazAmjad35]

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.

[JakeSkinner · Accepted solution]

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

[SLouq]

create a 120 mile buffer from school campus address.

Select student addresses which fall outside buffer.

[FawazAmjad35 · Accepted solution]

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

[DavidPike]

https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/near.htm

might be preferable for posterity so you can refer back to a distance for each record.  If the distance criteria changes you can just select by attribute (distance) instead.

Of course you need to geocode you table first. that's most of the battle.