I have a table that has a field that matches a field in a feature class. the table has M records for 1 row in the feature class. I would like each row in the table to have the geometry of the feature class. This would result in stacked geometries with different attributes.

If this were a 1:1 relationship, I would join the table to the FC and then export for the result I want. if I join the FC to the table the attributes line up, but there is no geometry included in the table.

Any Ideas on a tool or workflow for this?

I am working with 10.3 standard.

  • The attribute transfer toolbar will do this. But it’s a manual clicking process. Possible with python. – Fezter Nov 14 '17 at 19:14
  • You should perform the 1-to-Many join and export the results, looking for stacked Polygons. I know ArcGIS 10.4 and 10.5 support this when you save the results to a new Feature Class. – klewis Nov 14 '17 at 19:16
  • What type of geometry? – FelixIP Nov 14 '17 at 19:28
  • the geometry is polygon – Randy W. Nov 14 '17 at 19:32
  • Fezter- the attribute transfer tool will not do what I am looking for, as there is no shape field in the table to store geometry – Randy W. Nov 14 '17 at 19:52
  • Transfer coordinates of polygon centroids into table.
  • Create XY events from relevant columns
  • Buffer points to get M wrong shape polygons:

enter image description here

Run this field calculator expression on field Shape:

mxd = arcpy.mapping.MapDocument("CURRENT")
def getShape(id):
 with arcpy.da.SearchCursor (LR,["ID","Shape@"],'"ID" ='+str(id)) as cursor:
  for i,shp in cursor:  break
 return shp


getShape( !ID! )

To import correct shapes:

enter image description here

In the picture above "table" polygons labelled by one of their attribute. NOTE: tested on shapefiles with common field ID of integer type. Query in search cursor will change if used on FGDB or different field type.

  • I like the method of creating false geometries. I am going to give this a try. – Randy W. Nov 15 '17 at 18:02

You could create a model or script some geoprocessing tools which iterate over the similar field from the table, join to the same records in the feature class, export the joined feature class. Repeat this for all values, then merge your results together.

  • if you join a feature class to a table the result is a table. The geometry is not included in this operation. – Randy W. Nov 14 '17 at 19:46
  • if you join a feature class to a table then export the feature class it contains the data from the table – Maksim Nov 14 '17 at 19:46
  • I have thought of using a search cursor to read the geometry of the table record, and then writing the geometry into the table, but I don't know how to add a field of type "shape" to store the geometry. – Randy W. Nov 14 '17 at 19:48
  • what youre going to want to do is join a record from the table to its geometry in the feature class, export that joined feature class record, repeat, then combine everything at the end – Maksim Nov 14 '17 at 19:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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