topic Re: Batch Export of rows in attribute Table in ArcGIS Online Questions

Batch Export of rows in attribute Table

TimothyODoherty — Fri, 20 Jan 2023 15:10:35 GMT

Hi,

I am working in ModelBuilder and having trouble exporting the data into individual features.

I have an attribute table with >500,000 polyliones, I have the grouped the polylines into ~250 groups and want to export each group as their own feature. My plan was to use the 'select layer by attribute' tool but how would I batch run this to export all features in one simple tool?

Re: Batch Export of rows in attribute Table

RhettZufelt — Fri, 20 Jan 2023 16:16:37 GMT

Sounds like the Split by Attributes tool.

Re: Batch Export of rows in attribute Table

TimothyODoherty — Mon, 23 Jan 2023 09:44:37 GMT

Yes, I understand that Rhett. But what I am struggling with would be how to I run a 'Select by Attribute Tool' for each unique value in my field?

Re: Batch Export of rows in attribute Table

RhettZufelt — Mon, 23 Jan 2023 17:39:09 GMT

I don't mess with models much, but suspect an interator would work here.

I'd use python and:

create an empty list

use search cursor to populate the list with all the values of the field

turn that list into a set (so is uniuqe without duplicates)

iterate through the list and pass that to the Select By Attributes

export.

fc = r'Database Connections\pathtofeatureclass' search_field = 'AttField' AttList = [] with arcpy.da.SearchCursor(fc, [search_field]) as cursor: for row in cursor: AttList.append(row[0]) AttSet = set(AttList) for att in AttSet: where = f"{search_field} = '{att}'" arcpy.management.SelectLayerByAttribute(fc, "NEW_SELECTION", where) ## Export or other stuff

Should work if running in Pro with fc loaded. If not, will probably have to make feature layer first as the SelectByAttributes needs a view/layer not a feature class. If so, could skip the SelectByAttributes and just pass the same where clause to the MakeFeatureLayer GP tool, then export the feature layer.