Select to view content in your preferred language

Union / intersect + Concatenate

2615
4
09-09-2010 04:43 AM
KernoaAntoine
Emerging Contributor
hye,
i Would like to concatenate different values from the same field:
After "Intersect" and "Union" geoprocessing there are entities in double with différentes values.

ex: in the field 'Type' there is the same identity (same geometry and coord) wich values are "RV" and "Rg".

Il would like to delete and keep one of these 2 entities and concatenate their values in a new field:
RV,Rg
2 entities (RV and Rg) -> 1 entitie RV,Rg



I'm french...:confused:I hope you'll understand what i need !

Thank you
0 Kudos
4 Replies
JamesHood
Regular Contributor
step 1 - create new field = rv_type
step 2 - create new field = rg_type
step 3 - select by attributes  features  with type = rv
step 4 - calculate rv_type = rv
step 5 - select by attributes  features with type = rg
step 6 - calculate rg_type = rg
step 7 - union overlapping features
step 8 - Select features by attribute...  SQL WHERE: rv_type = "rv" AND rg_type = "rg"
step 9 - calculate type field = "rv and rg"
step 10 -  Delete rv_type, Delete rg_type
0 Kudos
KernoaAntoine
Emerging Contributor
HEllo,

I already try this solution, but i have too many  different values (RM, Rm Rv... x12) , so it's a little bit too long !

I have to do this with a lot af geodatabase....

Thx !
0 Kudos
PavelVranka
Emerging Contributor
I have the very same need. Have you found any solution?
0 Kudos
DaleHoneycutt
Deactivated User
I may be wrong here, but it sounds like you want to use the Concatenate Row Values tool found here: http://www.arcgis.com/home/item.html?id=52dfcef46fdb4c76bfbc08dc01570f3c
0 Kudos