topic Re: Automated Query in Mapping Questions

Automated Query

Anonymous User — Tue, 14 Dec 2010 13:34:19 GMT

Original User: gvj4

I am creating a series of maps that focuses on a parcel and an easement.
Each sketch should only include that particular parcel and the easment that crosses the parcel.

I've created an index layer and mapbook series that zooms to each parcel.

I'd like to automatically query out specific easement and parcel features when I select the mapbook page.

Does anyone have experience doing this sort of thing?

Thanks,

Gaston Jones

Re: Automated Query

EricAubert — Wed, 15 Dec 2010 16:13:28 GMT

Gaston, great question! One possible way would be to change the definition query dynamically. I wish we could dynamically query out a dataset in a DataDrivenPage but I'm afraid it's not possible for the time being in arcpy. Try this:

if tile == "TILE X":
[INDENT]layer.definitionQuery = "PARCEL_ID = 89 and EASEMENT = "RIGHT-OF-WAY"[/INDENT]

Re: Automated Query

Anonymous User — Thu, 16 Dec 2010 13:27:40 GMT

Original User: jbarrette

Eric, Gaston,

Have you tried looking at the Page Definition option available on the Definition Query tab? This button becomes available for Data Driven Page (DDP) enabled maps. If the feature tables you want to query (or not) have also have a field that matches the DDP then this may be a solution.

Eric is correct in that this can done with arcpy.mapping using the layer.definitionQuery property. Arcpy.mapping was designed to extend the out-of-the box capabilities of DDP.

Jeff