Is a SQL String Aggregate possible in arcgis?

المشرف العام

Administrator
طاقم الإدارة
I have created a feature class from the results of a 1:many join between a table and a polygon layer in ArcGIS 10.3. The polygon layer contains land parcels and the table contains names. Where a 1:many join was present, ArcGIS duplicated the geometry so that for example if "john" and "Robert" both were owners, two polygons would have been created- one for john one for robert.

I would now like to aggregate the results into a single field, so that I again only have 1 geometry containing a field with comma separated values for names e.g.

Parcelid: "10"names: "john,robert"



أكثر...
 
أعلى