topic Re: Change definition query in Python Questions

Change definition query

MarkPaulson — Sun, 21 Apr 2013 03:28:19 GMT

I have three feature classes that have multiple features in each layer. Each feature class has a field called parcel_no. I turn different parcels on by a definition query on each layer such as parcel_no = 1. This will show all three layer for parcel 1. I would like to run a script that will change the definition query for all three layers, say from parcel_no = 1 to parcel_no = 5. New to python and need to be pointed in the right direction.

Re: Change definition query

JakeSkinner — Fri, 10 Dec 2021 20:35:39 GMT

Hi Mark,

I would recommend using a Python Add-In Combo Box. You can select the query from the drop down and apply it to the desired layers. Here is an example of the code to use for the combo box:

import arcpy
import pythonaddins

class ComboBoxClass1(object):
    """Implementation for Query_addin.combobox (ComboBox)"""
    def __init__(self):
        self.items = ['"parcel_no" = 1', '"parcel_no" = 2', '"parcel_no" = 3', '"parcel_no" = 4', '"parcel_no" = 5']
        self.editable = False
        self.enabled = True
        self.dropdownWidth = 'WWWWWWWWWW'
        self.width = 'WWWWWWWWWW'
    def onSelChange(self, selection):
        self.mxd = arcpy.mapping.MapDocument("CURRENT")
        for lyr in arcpy.mapping.ListLayers(self.mxd):
            if lyr.name.lower() == "parcels1":
                lyr.definitionQuery = selection
            if lyr.name.lower() == "parcels2":
                lyr.definitionQuery = selection
            if lyr.name.lower() == "parcels3":
                lyr.definitionQuery = selection
        arcpy.RefreshTOC()
        arcpy.RefreshActiveView()

Re: Change definition query

curtvprice — Mon, 22 Apr 2013 11:44:02 GMT

This is done by modifying the Layer object's definitionQuery property. There are several examples to get you started in the help here:

Desktop 10.1 Help: (arcpy.mapping)

import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Project\Project.mxd") df = arcpy.mapping.ListDataFrames(mxd)[0] # first data frame lyrs = arcpy.mapping.ListLayers(mxd, "" , df) fixLayers = ["Test1 polygon","Test2 polygon"] newParcel = 5 for lyr in lyrs:   if lyr.name in fixLayers:       lyr.definitionQuery = "parcel_no = {0}".format(newParcel) arcpy.RefreshActiveView() del mxd # release the object (the map will not be deleted)

Re: Change definition query

MarkPaulson — Wed, 24 Apr 2013 02:19:39 GMT

Thanks for the direction. Ended up setting 15 bookmarks (1-15) and used a for loop to set the definition query for each parcel. Many thanks.