Use python to apply a definition query to an existing Layerfile.

Question

I will start with I know nothing about python, other than I need it now.  I have created a simple model that uploads a xyz file to a sql table with a survey id, creates an event theme, saves that to a .lyr file, and applies symbology.  However, I need one more thing.

I need some python code that will allow me to apply a definition query to query a single survey id and i need to be able to make it a parameter with the model.  Can anyone help out with this?  Thanks

export.py.zip

GregDreaper · Answer

OK, so everything works great from Catalog or toolbox.  However when I publish to ArcGIS server I get this error, " Geoprocessing service initialization failed.
Invalid parameter: Tool - Survey Loader Tool v2 : Parameter - Input : Data Type - Multiple Value."  I assume the ASCII 3D to Feature Class input parameter is causing this.  Does anyone know a work around?  Thanks!

GregDreaper · Answer

Awesome!  Thanks Buddy!  You have made lives easier.

BenjaminGale · Answer

Should be fixed now. 🙂
#==========================
# DEFINITION QUERY
#==========================
# Benjamin Gale - May 2012
#==========================

import arcpy

#Get parameters
lyrName = arcpy.GetParameterAsText(0)
defQuery = arcpy.GetParameterAsText(1)

lyr = arcpy.mapping.Layer(lyrName)
lyr.definitionQuery = defQuery

#Refresh ActiveView
arcpy.RefreshActiveView()
#Save layer (will only occur if the layer is a .lyr file)
lyr.save()

DefQuery.zip