topic Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series in ArcGIS Pro Questions

Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Fri, 29 Mar 2024 13:31:36 GMT

In ArcMap, I could use Data Driven Pages to step through features in a layer, and the map would automatically pan/zoom to each feature. I had two layers set up (in addition to my index layer) with page queries--one that matched, and one that didn't match. I could symbolize these two layers differently and create a kind of spotlight effect, where the page-queried feature was brighter and bolder, and the non-page-queried features were faded. In addition to this, the attribute table of the "matched" page queried layer only contained attributes for the matched feature. This made reviewing polygons, feature by feature, a breeze. Now, with Map Series in ArcGIS Pro, the attribute table is not limited to the matched page query features, and the map does not automatically pan/zoom. (I know it does in the Layout View, but I need the ability to zoom in/out and modify features without having to activate the frame and cycling through a bunch of clicks/tools).

So, there's a lot to unpack here, but my main question is: Is there a way to limit the attribute table in a Map View to only those features that match the page query?

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Fri, 29 Mar 2024 19:53:18 GMT

Yes there is a way to limit the attribute table in a Map View to only those features that match the page query. In the attribute table, lower right you'll see a funnel to the right of the word "Filters" - click the funnel to activate the "Filter by Extent" command. This will filter the table by spatial extent,

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Fri, 29 Mar 2024 20:20:49 GMT

Thank you for the suggestion, but it doesn't accomplish what I need. What you suggest filters the table by, as you explained, spatial extent--or, all features that are visible in the current extent. What I need is for the table to be filtered to only those features that satisfy the Page Query.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Fri, 29 Mar 2024 20:35:13 GMT

Gotcha - thank you for the clarification. Question - do you have a screen grab of the ArcMap UI area where the attribute table is filtered by the Page Query?

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Fri, 29 Mar 2024 20:44:47 GMT

I wish! I lost access to ArcMap two days ago. Sorry about that.

It was pretty simple though... In the Layout View of ArcMap, I could step through each page using the Data Driven Pages toolbar, and the attribute table of my page-queried layer would update at each step to only show me the queried feature/features.

It just seemed to be the natural functionality of Data Driven Pages as I did not employ any special Python coding or anything to accomplish it.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Fri, 29 Mar 2024 21:01:56 GMT

2 days ago! Well that's a bummer! But I believe I've figured it out as I have ArcMap and ArcGIS Pro on my laptop. In ArcMap, what you had to do was go to Layers Property, click the Definition Query tab followed by the Page Definition button. In the new window, you would enable the property and identify the field name that had the correct page name field and then click "match" for the show features that radio button.

Now in Pro, you go to the Layer Properties as well but click the Page Query tab. In that tab, identify the same field as ArcMap and match as well. Voila - the attribute table only shows those features that meet the Page Query.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Fri, 29 Mar 2024 22:23:17 GMT

Thank you again for trying to figure this one out. But I had everything set up like that and my attribute table is still displaying all features in the layer, even though I have a Page Query in place.

What's weird is that only the features that match the Page Query are displayed in the map! So that appears to be working correctly. It's just the attribute table that seems to be disregarding the Page Query.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Mon, 01 Apr 2024 14:28:25 GMT

To get my attribute table to filter based on the Page Query, I did go in and do some field calculation in a new field called PageName. Those features that intersected A1, I calculated A1 and so on. Then the Page Query workflow worked. Not sure why this is needed as ArcMap did not require this workflow.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Mon, 01 Apr 2024 14:38:44 GMT

@Robert_LeClair can you please elaborate more on this workflow?

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Wed, 03 Apr 2024 19:58:09 GMT

@Robert_LeClair If you have time, will you please consider elaborating on the workflow you describe? Mainly, when you say "Those features that intersected A1, I calculated A1 and so on"... I understand how to add and calculate fields, just not sure how to utilize this to get the Page Query to limit the features in the attribute table.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Wed, 03 Apr 2024 20:52:18 GMT

Hi @MitchellDrennan - apologies for the tardy response. Have been teaching classes in person the last two days. So I tried a Spatial Join (gp tool) workflow where I joined each feature class with the GridIndex layer to create a new FC with both the input feature class and GridIndex attributes merged together. Then you can "see" what features fall in grid index A1, A2 and so on. Then I went to the Layer Properties of each feature class to apply the Page Query. Not as clean or as easy as ArcMap for some reason. Not sure why.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Thu, 04 Apr 2024 18:45:43 GMT

That's quite alright!

So the process you describe would have to be repeated each time the target feature class was edited in order to ensure you are working with the latest data, right?

My setup is this: I have a Layout with two Map Frames. One of those Map Frames is my main Map Frame (we'll call this Map Frame A), and the other serves as a smaller, inset, "zoom" map. I'll call this Map Frame B. Bot Map Frames reference the same source data.

I set up the Map Series on Map Frame A, and use a Page Query on a Feature Layer in Map Frame B so that only the matching feature is displayed.

As I step through the Map Series, the extent of Map Frame A automatically centers on the matching feature. However, the extent of Map Frame B does not automatically center on the matching feature. In ArcMap, I could simply right click on the Feature Layer in Map Frame B and "zoom to layer" to get the extent to center on the matching feature. In ArcGIS Pro, however, the same process results in zooming out to the extent of the entire feature layer.

Is there a different way I should attempt to re-create my old ArcMap workflow?

Or is there any way to have a Map Series control two Map Frames in a Layout?

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Thu, 04 Apr 2024 21:31:03 GMT

So question for you - you're recreating the ArcMap workflow in ArcGIS Pro vs. importing the *.mxd into a new ArcGIS Pro project file? Correct? I wonder if you import the working *.mxd into ArcGIS Pro, will the new *.aprx work the way it did in ArcMap.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Thu, 04 Apr 2024 21:51:41 GMT

Good question. However, I did import the .mxd into ArcGIS Pro. I did not build this Project in ArcGIS Pro.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Thu, 04 Apr 2024 22:04:30 GMT

I also re-created a simple project in ArcGIS Pro from scratch, mimicking my setup in ArcMap, thinking that maybe there was an issue with the .mxd import, but the Page Query behaved the exact same way--that is, the attribute table and layer extent is not limited to only the matching features. It seems like this is just the way the Map Series function works unfortunately. I'm open to suggestions though!

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Fri, 05 Apr 2024 14:34:11 GMT

Well I believe I found the solution to this conundrum. It's BUG-000128342 - "The attribute table data is not filtered to reflect visible features after defining a page query for a map series in ArcGIS Pro." The explanation is "This is by design. Unlike ArcMap, ArcGIS Pro can support many maps and layouts. Multiple maps and layouts can also be shown at the same time. Because of this, the attribute table is not automatically limited to match the map series. If data based on the page query is needed to be shown, use a table frame on the layout."

So the closest one can get to with regard to ArcMap functionality is to spatially join the FC to the GridIndex, do field calculations of A1, A2, A3 and so on. Then use the Page Query to the PageName field to partially limit the attributes but not 100% like ArcMap did. Not an ideal solution by any means. Sorry...

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

MitchellDrennan — Wed, 10 Apr 2024 21:39:28 GMT

Robert, thanks again for digging into this. There are a couple of ways I feel Map Series could be more useful in ArcGIS Pro.

-Include the ability to set up and use Map Series in a Map (as of now I think it can only be done in a Layout)

-If the attribute table is not limited to match the Map Series by design, perhaps you could filter the attribute table by Map Series (similar to how you can filter the table by Map Extent currently)

Thank you.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Robert_LeClair — Thu, 11 Apr 2024 16:15:44 GMT

I agree with you on how the Map Series workflow could be improved. I don't believe there is an ArcGIS Idea for this presently in the Esri Community for ArcGIS Pro. I would recommend creating such an idea as it will get visibility with the ArcGIS Pro development team. As I work in the Training Services group, I have zero sway in any development decisions as you might suspect.

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

NickJones7 — Mon, 10 Feb 2025 17:17:56 GMT

I really need to vent. I can't tell you how irritating this is. I really want to like ArcGIS Pro, but things like this make it difficult. You can have a filter by extent button but you can't make a filter by map series button? Come on!!!

Re: Limit attribute table in Map View to only those features matching the Page Query of a Map Series

Bud — Tue, 11 Feb 2025 21:10:44 GMT

@MitchellDrennan Did you submit an idea?