topic New at Python scripting (Definition query and Looping) in Python Questions

New at Python scripting (Definition query and Looping)

AdamTomko1 — Thu, 31 Mar 2011 12:08:27 GMT

I am trying to create a script that Loops through a layer and creates multiple defintion queries on that layer. The layer is building lines and i want to create multiple definition queries so that each floor can be queried out and then mapped. I am having trouble getting started. I tried creating a script that simply creates a definition query for a layer in a mxd. It says the script is executing but when i open up the project nothing changes. Any help would be appreciated. Some of my scrip is below.

import arcpy, os

mxd = arcpy.mapping.MapDocument("M:/nih/AsbestosAbatement/Floorplans/BLDG_6A/Floorplanpdf.mxd")

for lyr in arcpy.mapping.ListLayers(mxd):
    if lyr.name == "BuildingFloorLInes":
        layer.definitionQuery =[FLR] = '02'
        layer.update

print 2

Re: New at Python scripting (Definition query and Looping)

JasonScheirer — Sat, 11 Dec 2021 07:23:33 GMT

You need to save the MXD when you're done.

import arcpy, os

mxd = arcpy.mapping.MapDocument("M:/nih/AsbestosAbatement/Floorplans/BLDG_6A/Floorplanpdf.mxd")

for lyr in arcpy.mapping.ListLayers(mxd, "BuildingFloorLines"):
    layer.definitionQuery = "[FLR] = '02'"

mxd.save()

print 2

If you're currently in arcmap and want to act on the active map:

import arcpy, os

mxd = arcpy.mapping.MapDocument("current")

for lyr in arcpy.mapping.ListLayers(mxd, "BuildingFloorLines"):
    layer.definitionQuery = "[FLR] = '02'"

arcpy.RefreshActiveView()
arcpy.RefreshTOC()

print 2

Re: New at Python scripting (Definition query and Looping)

StevenArebalo — Thu, 31 Mar 2011 12:50:23 GMT

layer.definitionQuery =[FLR] = '02'

layer.definitionQuery='[FLR]="02"'

Your query isn't held together with outer quotes. Don't know how layer.definitionQuery reacts to ambiguous assignments, but it may be set to "" and would explain returning all records.

*beat to the punch*