0

I have two sets of data:

  1. list of parcel numbers and locations which I am interested in
  2. Address database for the county (shapefile)

In dataset 2 there can be multiple instances of the same parcel number with different addresses.

However in dataset 1 there is only 1 unique instance of each parcel number.

I would like to use dataset 1 to extract ALL instances of the same APN in dataset 2.

I have tried a table join but this will not work since table join looks for one and only one corresponding value for parcel number.

I need all corresponding values.

  • You are dealing with 1 '1-N' join, which is not supported in Join and Relates option. You might want to import your data into a .GDB and use a relationship class to relate those two tables. – dof1985 Jul 26 '15 at 6:18
  • 1
    A relationship class is one way, but you may find it simpler to just use a Relate in place of your Join - its available in the same place. – PolyGeo Jul 26 '15 at 6:20
  • I think relate might work. Ill let you know how it goes. Thanks – user32882 Jul 26 '15 at 6:37
  • Join 1 to 2. Summarise per parcel id. Joint this back to 1 – FelixIP Jul 26 '15 at 9:32
  • 4
    If both are in the same geodatabase and you have ArcGIS version 10.1 or higher, you can Join 1 to 2 and export the features from the table of contents to get all of the parcels multiplied by the addresses joined to them. The 1-N relationship is converted to a 1-1 relationship where all addresses will be associated with the parcel shapes and fields. This only occurs with export/copy features etc for joined data in the same geodatabase. The address ObjectID should be presevered so you can join the result back to the address features/table (although a custom permanent ID field is better).. – Richard Fairhurst Jul 26 '15 at 12:48
1

If both are in the same geodatabase and you have ArcGIS version 10.1 or higher, you can Join 1 to 2 and export the features from the table of contents to get all of the parcels multiplied by the addresses joined to them. The 1-N relationship is converted to a 1-1 relationship where all addresses will be associated with the parcel shapes and fields. This only occurs with export/copy features etc for joined data in the same geodatabase. The address ObjectID may be preserved so you can join the result back to the address features/table, although a custom permanent ID field is better to ensure that relate/join is possible.

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.