0

I have 2 databases:

Database 1: Point Shapefile with adress and APN (parcel numbers) as attributes. (Huge number of points, addresses for an entire metropolitan area).

Database 2: CSV file with a smaller database of addresses and APN numbers, and a few other fields. This one is not georeferenced.

I would like to construct a query in Select by Attributes where I reference database 2 and search for APN's within database 1 corresponding to all the ones in database 2. Ultimately I would like to isolate all corresponding points and display them on the map.

This is like a batch form of the following query:

SELECT*FROM ADDRESS_APN WHERE "APN" = '###' AND "APN"='####' AND ......

Only thing is there are about 565 values so it is unfeasible to have an AND statement for each value. I would much rather reference the CSV file.

Improve this question
2
  • 2
    A CSV file is not a database. If you want query performance, you should load the CSV into a file geodatabase and create an index. Commented Jul 11, 2015 at 22:26
  • I'm not familiar with file geodatabases... any extra hints you could provide? Thanks Commented Jul 11, 2015 at 22:30

1 Answer 1

Reset to default
2

Even if you could stomach writing 565 AND statements, that wouldn't give you what you wanted. What you're actually seeking to do is known as a table join. You want to select the records of one of your tables that have a match in the other table. Once you have your tables loaded in ArcGIS (and you will probably need to load your CSV to something indexed by ArcGIS) you want to perform a join according to your APN field, ignoring all records that don't exist in both tables.

Improve this answer
1
  • Thank you, I will further document myself on this and let you know how it works out... Commented Jul 11, 2015 at 22:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.