Assistance with making a selection in an attribute table from an imported csv file

[JasonRamsay]

Hi there,

I'm using ArcGIS Pro 3.0 and I'm attempting to export a number of property boundaries from a very large dataset. I have the addresses of the properties I need to export in csv format; however, using the select by attributes tool and manually selecting each property would be extremely tedious. I don't have much experience with relates, but if my understanding is correct, this would also be difficult as I would have to assign a shared OID to each of the properties.

I've tried searching for an alternative way to select each property I need, but have been unable to find anything. Could someone please give me a suggestion as to how I might use the addresses in my csv spreadsheet to select the corresponding addresses in the attribute table of the shapefile?

Thanks in advance.

[DanPatterson]

are they associated with a few street names? anything spatial that can be used?

Do you have a street/road file?

Perhaps you need to provide a key to any commonality that the properties share to limit the search criteria (like show a portion of the table information you have)

[JasonRamsay]

Hi Dan,

Thanks for the response. I'll give some clarification. Each property has the same address in both tables. So, I could simply take the addresses from the csv spreadsheet and put them through the select by attributes tool to select the appropriate property in the properties shapefile. However, due to the large number of properties I need to select, this approach would take a very long time. I was wondering whether there is a way to automate this process.

Thanks for the help.

[DanPatterson · Accepted solution]

you could try Add Join (Data Management)—ArcGIS Pro | Documentation for a temporary join or

Join Field (Data Management)—ArcGIS Pro | Documentation for a permanent join

The information with matching addresses would then have joined information.

Fields in the joined table that are not Null are the ones you want and those that don't are not the ones you want.  You could query (select by attributes) one of those fields for not Null

[JasonRamsay]

That worked perfectly! Thank you!