nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro - Modifying Layer Definition query via ArcPY

janrykr1

Let's say I need to add a new statement to an existing Def query to all layers in a group which would like like something like this:

aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
m <SPAN class="operator token">=</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Map"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> m<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>supports <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"longname"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 parent <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN>longName<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN>
 
 <SPAN class="keyword token">if</SPAN> parent <SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">"Group"</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">.</SPAN>longName<SPAN class="punctuation token">)</SPAN>
  <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>supports<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DEFINITIONQUERY"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
   oldDefQuery <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN>definitionQuery
   lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> None
   newDefQuery <SPAN class="operator token">=</SPAN> oldDefQuery <SPAN class="operator token">+</SPAN> <SPAN class="string token">" CODE = 0"</SPAN> 
   lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> newDefQuery‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

What happens after running the script is that the old definition query becomes inactive and the newly created query is added and becomes active. However they both remain the same query name and seem to clash with each other so that no feature pass through the query (don't mind the fieldnames):

There seem to be no detailed explanation on the definitionQuery property at Layer—ArcPy | ArcGIS Desktop

So the questions are:

How to achieve this to work properly:
- Modify the existing one? - This used to work in ArcMAP
- Remove the initial query completely and place a new modified query?
Is there any documentation on how to control the functions in the definition query tab on layer properties via Arcpy??

Thanks heaps!

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

MikeLachance1

Hi Joseph, sorry for the late reply. What is posted is the entirety of the code within my "Clear All Filters" GP script tool that my users run. Were you interested in seeing the script for setting definition queries as well?

Joseph_Kinyon

Mike,

Would love to see the whole script tool you created if you have a moment.
What you have created is very close to my tool.

Select Layers>choose or write query definition (or set to clear)>check if definition query exists > update definition query

MikeLachance1

I was able to get this method to work as well. For context: I am running script tools that allow users to set and clear definition queries for multiple layers. When setting, they select a value from a drop down list and run the script which creates and applies the query with their selected value to all the relevant layers. When clearing, they simply run the script tool and all definition queries are cleared from the relevant layers.

Here is an example of the syntax I used for clearing queries. I am into an issue where it gave an error if the layer didn't already have a DQ on it, so it couldn't overwrite it. So I check for existing DQs first, if there is one, I overwrite it, if there isn't one, I create and apply one.

aprx = arcpy.mp.ArcGISProject("CURRENT")
    m = aprx.activeMap
    lyrs = m.listLayers()
    
    for lyr in lyrs:
        if lyr.name in ('TEST_PT', 'TEST_LINE', 'TEST_POLY'):
            cim_layer = lyr.getDefinition('V2')
            
            if cim_layer.featureTable.definitionFilterChoices:
                cim_layer.featureTable.definitionFilterChoices[0].definitionExpression = None
                cim_layer.featureTable.definitionExpression = None
                
            else:
                cim_layer.featureTable.definitionExpression = None
            
            lyr.setDefinition(cim_layer)

Doing it this way allowed me to create, apply, and clear definition queries without creating a massive list of deactivated queries for each layer. Hope this helps others.

JimP-notUniqueAtAll

Sorry, lyr.definitionQuery = None does not work. It still is keeping all query clauses. Frustrating.

LindsayRaabe_FPCWA

For others looking for help in this space.

I've just tested the below line in a python script that looks at a set map (Data Editing) in the Current project, and had the last 2 lines repeated for all the different layer names that I wanted it to update. It successfully deleted the definition query from each layer.

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("Data Editing")[0]

for lyr in m.listLayers("Layer 1"):    ###Repeat these 2 lines for each layer
    lyr.definitionQuery = None

for lyr in m.listLayers("Layer 2"):    
    lyr.definitionQuery = None

I plan to write a simple script that can be used on any project and map which will just go through all layers in the current map and wipe and definition queries. Variations of this could include a 3rd line for each layer that adds a replacement query in the originals place.

danashney

This seemed to work. It changed the def query without the duplication. Note that you have to change two CIM properties to get this to change without duplication AND to make the new query the 'active' query.

# sorry for bad indents; I don't know how to format this here

# batch change (all maps in project) definition query for a specified layer
# optional param - specify which map you want to target, default is that it does all of them

def batch_change_definition_query(layer_name, definition_query, my_map = None):
aprx = arcpy.mp.ArcGISProject("CURRENT")
for map in aprx.listMaps(my_map):
for layer in map.listLayers():
if layer.name == layer_name:
cim_layer = layer.getDefinition('V2')
cim_layer.featureTable.definitionFilterChoices[0].definitionExpression = definition_query
cim_layer.featureTable.definitionExpression = definition_query
layer.setDefinition(cim_layer)

JoshuaBixby

Since Esri exposed the CIM model to ArcPy starting with Pro 2.4 (or was it 2.3), it opened the doors to doing a lot more within Pro that wasn't available strictly through ArcPy in the past with Pro.

janrykr1

No, haven't solved this entirely. The easiest workaround was to go back to ArcMap.

JoshuaBixby

Since I am not sure of the OP's code indentations, I will focus on once you have a reference to a layer:

sql <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># Additional WHERE clause to append to existing</SPAN>

lyr_cim <SPAN class="operator token">=</SPAN> lyr<SPAN class="punctuation token">.</SPAN>getDefinition<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'V2'</SPAN><SPAN class="punctuation token">)</SPAN>
cim_ft <SPAN class="operator token">=</SPAN> lyr_cim<SPAN class="punctuation token">.</SPAN>featureTable
defExpName <SPAN class="operator token">=</SPAN> cim_ft<SPAN class="punctuation token">.</SPAN>definitionExpressionName
defExpIdx <SPAN class="operator token">=</SPAN> next<SPAN class="punctuation token">(</SPAN>
    i <SPAN class="keyword token">for</SPAN>
    i<SPAN class="punctuation token">,</SPAN>n <SPAN class="keyword token">in</SPAN>
    enumerate<SPAN class="punctuation token">(</SPAN>cim_ft<SPAN class="punctuation token">.</SPAN>definitionFilterChoices<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> n<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN> defExpName
<SPAN class="punctuation token">)</SPAN>
cim_ft<SPAN class="punctuation token">.</SPAN>definitionExpression <SPAN class="operator token">+=</SPAN> sql
cim_ft<SPAN class="punctuation token">.</SPAN>definitionFilterChoices<SPAN class="punctuation token">[</SPAN>defExpIdx<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> cim_ft<SPAN class="punctuation token">.</SPAN>definitionExpression
lyr<SPAN class="punctuation token">.</SPAN>setDefinition<SPAN class="punctuation token">(</SPAN>lyr_cim<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

FPCWAGIS_Admin

Did you ever manage to solve this?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.