topic Help required- extracting data from attribute table in arcgis pro in ArcGIS Pro Questions

Help required- extracting data from attribute table in arcgis pro

FawazAmjad35 — Thu, 25 Jan 2024 14:07:06 GMT

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.

Re: Help required- extracting data from attribute table in arcgis pro

JakeSkinner — Thu, 25 Jan 2024 14:12:39 GMT

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

Re: Help required- extracting data from attribute table in arcgis pro

SLouq — Thu, 25 Jan 2024 14:18:14 GMT

create a 120 mile buffer from school campus address.

Select student addresses which fall outside buffer.

Re: Help required- extracting data from attribute table in arcgis pro

DavidPike — Thu, 25 Jan 2024 18:29:08 GMT

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.

Re: Help required- extracting data from attribute table in arcgis pro

FawazAmjad35 — Thu, 25 Jan 2024 19:37:21 GMT

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