Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I need to create duplicate features (in this case parcels), using a related table to populate ID fields. In essence, I need to use a related table of parcel owners to create duplicate parcels, each with its own unique ID from the related owner table. The related table already contains the many-to-one link to parcels, I just want to force a one-to-one relationship between the owners and parcels, by creating a duplicate parcel for each owner record.

Thanks in advance for any suggestions!

Jodi

share|improve this question
2  
Why can't you just join the feature table to the owner table? You'll still get multiple rows per shape (since it'll be a one-to-many relation, feature to owner) which, in essence, means you'll see a "one-to-one" relationship when viewing tabular data. –  Michael Todd Sep 20 '10 at 18:47
    
Which software? which version? –  Jay Cummins Sep 20 '10 at 19:55
    
ArcGIS 9.3.1 I would like to actually duplicate the geometry not just see a 1:1 in the table. –  Jodi Sep 20 '10 at 22:39
    
Since each polygon would overlay a polygon of the exact same shape, you really won't glean any benefit (that I can think of) from having multiple shapes. Are you doing this for something other than symbolizing features on a map? –  Michael Todd Sep 20 '10 at 23:07
    
Not to be used for symoblizing features. By making duplicate shapes, I want to gain the ability to find the spatial location of a feature in a related table (a reverse or many-to-one, so to speak). And by having duplicate shapes "stacked" on top of eachother, one can use the select or identify tool to capture all records without having to look up records in a related table. –  Jodi Sep 21 '10 at 1:53
show 2 more comments

6 Answers

I've just done it with our parcel-feature and owner-table.

i made a join on the Parcels to the Owners, and selecting "Keep only matching records" - right after the join - make a "Copy Features" from the ArcToolbox - and it will make duplicates of all parcels where there are owners for it.

It worked for me.... finally...

Mads Gren GIS-coordinator Lemvig Denmark

share|improve this answer
add comment

We use a spatial view in SDE to achieve a similar result. In our case it is because we have parcels with multiple owners (condos, townhomes, etc.). We import a file into SDE on a nightly basis that contains all of the property owners in the county, each with unique id that relates back to a specific parcel. We create a spatial view using this table and our parcel polygon feature class. The result is a spatial view with stacked parcels, one parcel for each individual owner. When you identify this layer in ArcMap, you get a result for all of the owners. We are at Arc 9.3.1. This layer has been very beneficial for our tax department.

share|improve this answer
    
Unfortunately, no SDE or INFO available. I'm thinking its not possible in ArcView? –  Jodi Sep 21 '10 at 17:48
    
With ArcMap you should have a license of ArcSDE that you can wire into SQL Server Express. You should be able to push your parcels feature class and owner table into the database, create your spatial view, and then push it back out again as a shapefile or personal/file geodatabase (unwind the relationship). –  mwalker Oct 21 '10 at 17:31
add comment

Mads Grens answer works perfectly.

  1. You join your owner table to your parcel table with the keep only matching records option enabled.

  2. Use the Copy Features in ArcToolbox (Data Management Tools -> Features) to copy your parcels to a new Feature Class. The new Feature Class contains every parcel one time per owner, meaning that if a parcel has two owners, the parcel will figure two times in the new Feature Class - it is simply dublicated with the Copy Features Tool.

All this you can put in to a Model in Model Builder - You find Add Join under Data Management Tools -> Joins. The Model can then be run every time, that your base data are updated.

Thats it from me.

share|improve this answer
add comment

Simply select the parcels that you want duplicated (a 'where in' clause would work well) and create a new shapefile of the selection. Merge the two files. Done.

share|improve this answer
add comment

This geoprocessing tool may help if you don't want to get into SQL views - http://aalbs.blogspot.com/2010/02/table-to-feature-class-merger.html

share|improve this answer
add comment

In ArcMap 10, use the MAKE QUERY TABLE. First, make sure the table and feature class are in the same geodatabase. The MAKE QUERY TABLE tool will create a feature layer so you'll have to use COPY to create a permanent feature class. You can then export this feature class to a shapefile.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.