Select related records and definition query in an ArcGIS Pro Python Notebook

JohnEsch2 — Tue, 22 Apr 2025 15:19:18 GMT

Question 1 Select related records in a Notebook

I have a many step ArcGIS Pro Python Notebook to format a layer (add fields, run calculations, make selection, populate field based on selection, clear selection, join a table, export feature…)

All of these are working fine in my Notebook, but one of the later steps is to add a relate from my main layer (layer1) to another layer (layer2), then make a selection on Layer1 (arcpy.management.SelectLayerByAttribute). I would like to then select related records in layer2. I can easily do this in Layer1 attribute table (Select Related Record), I can also manually for the Layer1 Selection tab under put a check in the box next to Automatically select related data. But I would rather have the select related records as another line in my Notebook. Is there an arcpy script available to select related records?

Question 2 Definition query on a layer in a Notebook

I have another ArcGIS Pro Python Notebook where I need to start out with a definition query on a layer, then a series of steps on that queried layer. I can easily manually create a definition query on the layer, then run the remaining steps of the Notebook. I would like to have the definition query on the layer as a step in the Notebook.

Thanks

topic Select related records and definition query in an ArcGIS Pro Python Notebook in ArcGIS Pro Questions

Select related records and definition query in an ArcGIS Pro Python Notebook