tyler.p.bragg

Create Duplicate Geometry in One to Many Join

Discussion created by tyler.p.bragg on Jun 23, 2011
Latest reply on Jul 15, 2011 by tyler.p.bragg
I have researched this one and can't seem to find an easy way to do it: 

I'm trying to join a feature class of parcel polygons with a table based on one field, which will result in a one (parcels) to many (table) join.  Then, for every unique record in the table (which has multiple records for each parcel polygon), I want to duplicate or copy the matching parcel polygon and create a new feature class that contains all the records from the table with the parcel geometry. 

I have a script that will do it, but it is very slow as it reads through each record in the parcel feature class, matches with records in the table, then copys the geometry from the parcels for each table record and attributes accordingly.  I'm just trying to find out if there's an easier/faster way to do this. 

If the explanation is not clear, try this:  Parcel feature class primary key is the ParcelID.  Table primary key is the OwnershipID, which identifies all owners of each parcel (so you can have parcel1-owner1, parcel1-owner2, parcel1-owner3, etc.).  Table also contains ParcelID, which has the same parcelID for every owner of the property.  This is the join field.  I want to then copy the parcel geometry so that I have geometry for each owner in a new feature class. 

The issue is that I have to conduct further analysis on an owner basis, and I need the parcel shape for each owner in order to do this. 

Again, my script seems to work fine, it just takes a long time to run because it has to cycle through every record.  Any suggestions?

Tyler

Outcomes