An important property of Layer objects is the ability to dynamically set definition queries. A definition query is a SQL statement
where clause that limits the data available for display, query, or other data operations (buffers, intersections, etc.) to only the rows that match the
where clause. Definition queries could be set in an MXD by opening a layer's properties menu and using the Definition Query tab, but here we are concerned with how to add them programmatically. Following is an example of how to do this:
layersList = arcpy.mapping.ListLayers(mxdObject,"",dataFrame) busStops = layersList busStops.definitionQuery = "NAME = '71 IB' AND BUS_SIGNAG = 'Ferry Plaza'"
This valuable property can be utilized to reformat the ...