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.

  • 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. – Vince Jul 11 '15 at 22:26
  • I'm not familiar with file geodatabases... any extra hints you could provide? Thanks – user32882 Jul 11 '15 at 22:30
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.

  • Thank you, I will further document myself on this and let you know how it works out... – user32882 Jul 11 '15 at 22:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.