topic Re: How to find a query layer in a map document using arcpy in Python Questions

How to find a query layer in a map document using arcpy

MattFrancis — Fri, 11 Jun 2021 21:03:14 GMT

I have a bunch of map documents with gobs of layers in each. I have a script the goes through each map document, and each dataframe, and then inspects each layer in the dataframe. I am trying to determine if the layer is a query layer, but I do not know how to determine that.

import arcpy import os tfolder = r"\\tstvmmapservb\f$\ArcGIS\MXDs\NISC" for f in os.listdir(tfolder): map_document = os.path.join(r"\\tstvmmapservb\f$\ArcGIS\MXDs\NISC", f) print("mxd: {}").format(map_document) mxd = arcpy.mapping.MapDocument(map_document) for df in arcpy.mapping.ListDataFrames(mxd, "*"): lyrs = arcpy.mapping.ListLayers(mxd, "", df) for lyr in lyrs: if lyr.isBroken: #print("{} is broken. Skipping".format(lyr.name)) continue desc = arcpy.Describe(lyr) if desc.dataType == "GroupLayer": #print("{} is a group layer. Skipping".format(lyr.name)) continue if desc.dataElement.dataType == "FeatureClass": print("{} is a feature class. Skipping".format(lyr.name)) continue if lyr.supports("SERVICEPROPERTIES"): #print("{} is a service. Skipping".format(lyr.name)) continue print(lyr)

Re: How to find a query layer in a map document using arcpy

DanPatterson — Fri, 11 Jun 2021 22:28:43 GMT

would "supports" "definition query" help?

Layer—ArcGIS Pro | Documentation

supports (layer_property)

DEFINITIONQUERY A layer's definition query string.

Re: How to find a query layer in a map document using arcpy

DavidPike — Sat, 12 Jun 2021 12:21:45 GMT

A query layer for me in Oracle returns a '%' in the dataSource and datasetName properties.

maybe:

if '%' in lyr.datasetName: pass

Re: How to find a query layer in a map document using arcpy

RandyBurton — Sat, 12 Jun 2021 20:04:42 GMT

Per @DanPatterson's suggestion, if the layer supports DEFINITIONQUERY, then check the definition property for a string with length. If it has length, the layer is using a query.

for lyr in lyrs: if lyr.supports("DEFINITIONQUERY"): if len(lyr.definitionQuery.strip()): # a string with length print lyr.name, lyr.definitionQuery

(My version of ArcMap allowed spaces as a definition query, so stripping them before checking length is advised.)

Re: How to find a query layer in a map document using arcpy

MattFrancis — Thu, 17 Jun 2021 14:09:36 GMT

Not really; most layers have definition queries. It is similar, but I am looking for a query layer's definition, and not a layer's definition query.

Re: How to find a query layer in a map document using arcpy

MattFrancis — Thu, 17 Jun 2021 17:38:41 GMT

Thanks; I am not getting a "%" and might be getting an underscore, but looking for that character will turn up many false positives.

Re: How to find a query layer in a map document using arcpy

MattFrancis — Fri, 18 Jun 2021 12:41:59 GMT

Similarly, I have an XY Event Layer (In layer properties, Source tab, Data Type: XY Event Source) and desc.dataElement.dataType == "FeatureClass" is true for an XY Event Layer, though it is clearly not an SDE Feature Class.