topic Re: Fishnet grid attributes - One to Many relationship in Data Management Questions

Fishnet grid attributes - One to Many relationship

ChristopherAbbott — Wed, 13 Apr 2016 19:52:30 GMT

Fishnet grid attributes. We generated a fish net grid over a township with over 200 subdivisions. We need would like to create single attribute entries for each municipal area with the list of the grid cells that cover it. When running a spatial join it duplicates the attribute rows as 'Stone Harbor' A3, Stone Harbor A4, Stone Harbor B3.

I would like e.g. Column 1 'Stone Harbor', Column 2 'A3', Column 3 'A4', Column 4 'B3'.

Any thoughts or blogs on the issue?

Thanks, Chris

Re: Fishnet grid attributes - One to Many relationship

DanPatterson_Retired — Sat, 11 Dec 2021 19:07:49 GMT

If everything is as shown, you can split the string into 4 new columns.

this should give you some ideas

>>> a
'stone harbour ??'
>>> b = " ".join(a.split(" ")[:-1])
>>> c = " ".join(a.split(" ")[-1:])
>>> a
'stone harbour ??'
>>> b
'stone harbour'
>>> c
'??'

Re: Fishnet grid attributes - One to Many relationship

WesMiller — Thu, 14 Apr 2016 12:21:53 GMT

You could put all the grids in a single field. When you do your spatial join use Join operation Join_one_to_one and in the field map section right click the grid field and choose properties and set Merge rule to join and choose your delimiter.

This would produce a feature class with

Name Grid

Stone Harbor A1,A2,A3,A4,B3

Using the field mapping control—Help | ArcGIS for Desktop