I am doing an analysis that places a buffer around X property, then identifies all the parcels within that buffer to store in a database and perform analysis on later.
Currently, I have two separate databases. One for all the properties I run the buffer on, then a second which includes all of the parcels that are within the buffer. Each record in the second database has a reference field to the first so I know where they all belong. The issue is there is massive duplication of properties in the second database since many of the buffers would end up overlapping each other. In turn I'm adding the same parcels to the second database, they just reference different records to the first. I feel like this is hugely inefficient.
Is there a better way to do this?
I thought I could just add a field to the Parcel data and use Calculate Field to just append any reference fields together. Is my "Better Way" suggested below the best way to do this, if so is there a reason why the Model Builder does not properly select the parcels so I can then calculate the field?