I'm using ArcGIS Pro 3.0. I have two Polygon feature classes, one contains parcel information, the other building footprints. I have many parcels that contain multiple buildings. In the attached photo, this one parcel has 149 records associated with it, and it contains 33 buildings. I am trying to do a spatial join (with the buildings as target features) and keep ALL 149 records associated with the parcel in the join. The merge rules allow me to choose to keep only the first or last record and associate the same record to all 33 buildings. I tried to concatenate (join on merge rules) but still only one record was kept. I need, at the very least, for all 149 records to be attached to each building when I join the features. Optimally, I would like each building to have only the subset of the 149 records associated with it joined, which could be accomplished if I had building addresses in the building feature class, which I do not. Any suggestions would be appreciated.
