topic Re: Page Query in Definition Query in ArcGIS Pro Questions

Page Query in Definition Query

RobertBorchert — Thu, 23 Sep 2021 11:54:56 GMT

You can use Page Query to turn layers on and off if an attribute in the layer matches the map series page name. This is great but very limited and has no flexibility.

What I would like to know is there a way to limit visibility of a layer using Definition Query where a layer is visible depending on the Map Series page in use?

Re: Page Query in Definition Query

jcarlson — Thu, 23 Sep 2021 13:35:56 GMT

We do this in a Map Series of ours, but have to use the arcpy.mp to do it. A built-in solution would be nice, though. I'll definitely upvote your idea on this.

Re: Page Query in Definition Query

RobertBorchert — Thu, 23 Sep 2021 13:42:41 GMT

I would be fine writing it out in SQL in the definition query. But a drop down menu of selectable page names would be nice.

So is your script something that has to be executed each time or does it remain intact?

Re: Page Query in Definition Query

jcarlson — Thu, 23 Sep 2021 14:07:25 GMT

I run it once to get the entire series to export. It's for our annual tax map book, so the per-page query format doesn't change, just the attributes. The gist of it:

for feat in features: some_map.listLayers()[1].definitionQuery = f"some_attribute = {feat.attribute1} or some_attribute = {feat.attribute2}" # other layout things # export to PDF

Re: Page Query in Definition Query

RobertBorchert — Thu, 23 Sep 2021 14:20:30 GMT

I may try something that. This is for company wall maps and we will generate new PDF's of them 2 times a year, or after major restructuring. then if any of our employees or clients need a wall map they can plot it out.