ArcPro Model building, output result and de a def query on a different layer

Question

I am a basic user of model builder in ArcPro and would love to be pointed into the right direction for the below example.
I have 2 layer that I am needing to work from, sub-unit layer with lots of attributes (planned start date) and the other just outline of these so doent have the dates etc

What I need to do is query a date range to get my set and then ONLY dis display the outline of the whole unit.

So from the screen shot below the sub-units in my date range are the dots, but I need to do maps with the WHOLE blue/yellow layer

I tried unions, joins intersects but I still every query I did based on the date range only gave me the dot polygons.

So here is where my manual step came in, I would open the attribute table (of my model output layer) copy the numbers over and do a def query (includes the value) on the outline layer and then create my map series from that.

How do I build that into the model? ie output list , def query on different layer.
Or is there something I could change in model

Thanks 🙂

DianaKing001 · Answer

Hi Duncan

ok, I appreciate your time spent trying to understand this.  I have another think about how I go about this.

However I do want to work out for future models if I can do a def query on a different layer from the results obtained in a say part one of a model.

Again thanks for your help.

Hornbydd · Answer

OK now you have described you data better and what you have tried, I need to ask do you have the following scenario:

You select your yellow polygons by a date and those selected polygons can exist in more than one blue polygon, so when you produce your map you might be showing 2 or more blue polygons?

OR

You select your yellow polygons by a date and that selection only exists within a single blue polygon, so this case your map only ever shows 1 blue polygon, like you show in your original question?

I ask this as the index layer in a map series requires a SINGLE feature to step over but if your units are selecting by date across multiple blue polygons you can't do what you want using the GUI in ArcPro, you are going to have to script this. I don't think modelbuilder is the solution either as it has little to no interaction with a layout, you would need to control the layout using arcpy.

DianaKing001 · Answer

Sorry for the confusion, no I only want the WHOLE shape of the blue polygons that have the dot layer in it.

So the dot layer is sub units of the blue layer.  Dot layer is the only one that holds the dates.
Dot Layer Attributes (Planned date, unit name)
Blue Layer Attributes (Unit name)

So I query the dot layer and find the unit names that fall in the date range and then I want to do a map series with the blue layer based on the dot layers findings.

I tried using the clips, joins, unions, and found my results were clipping the blue shape and only returning part of it (the shapes where the dot were)
When I used selection within etc, as the dot layer seemed to have slivers my results returned too many blue polygons

The only way I have found to get the result I need is take the unit name list from the dot layer and then do a def query on the blue layer using that list.  All manual.

I was hoping to be smarted and put this all into a model, but struggling.

🙂