I have two data sets. Each data set has a Parcel ID and square footage for building footprints. One was created by a government agency for tax assessment. The other by a small operation that traced the footprints of buildings from aerial imagery. There is no common attribute file between the buildings, only the tax parcels. We processed the footprints to find area (ft^2), but the data set do not match. I would like to join the government tax database to the file of the traced building footprints.

Does anyone know of a way to join the buildings by parcel by relative size?

Excel Worksheet showing area of footprints on one parcel.

I am using ArcMAP 10.x Sublime Text 3.0 MS Excel 2016

Windows 7 Pro Intel i7-4930k 3.40GHz 64 GB RAM 64-bit OS Two NVIDIA 1080 GPU

closed as unclear what you're asking by PolyGeo Mar 10 '17 at 23:33

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Sort them both in ascending order and join. Risky thing though – FelixIP Feb 27 '17 at 23:06
  • Which one is the matching field (Parcel ID)? Does the Tax Data have a spatial component or is it just a table? Are you trying to find the largest building for each Parcel ID or match each building with its row in the tax table? – Michael Stimson Feb 27 '17 at 23:11
  • Is the Parcel ID a common attribute (do both datasets have Parcel ID, do they match)? If it is, you can use Parcel ID to join the tables. If they are both spatial tables, you can use a spatial join. – jbalk Feb 28 '17 at 1:48
  • @Michael, the matching field is the Parcel ID, the table above is the result of two tables that were merged. The Tax data can be referenced by address and Parcel ID. The addresses, after being concatenated do not match the addressing pins from an addressing file, nor do those pins reference the building footprints. My goal is to join all of the assessor's data to the building footprints. – Neil Feb 28 '17 at 2:48
  • @jbalk, both data set do have a common attribute, Parcel ID. The issue is that there are multiple buildings per parcel. If there was only one building per Parcel that solution would work. – Neil Feb 28 '17 at 2:48