I have an old script tool that I'm migrating to ArcGIS Pro. The tool only has two parameters (Subbasin: string, Directory: folder) and it is supposed export a PDF mapbook of the features for the subbasin number entered. I wrote the code and tested it in the Python console window in Pro. It works fine. I have exported >20 mapbooks. I configured it as a script tool and two things happen: * Whatever subbasin is entered, the resulting section set for mapsheets is always the selection set that was desired on the previous run of the tool—seriously weird! * The PDF export file is never created. The exportToPDF function seems to run, but no file is generated and no exception is thrown. The logic is as follows: * Check the map for the required layers * Apply the definition query for the desired subbasin * Perform selections to get the desired mapsheet grid* Select inspection results for the desired subbasin * Select mapsheets for previously selected inspection results * Apply definition query to based on mapsheet selection* Get selection set for mapsheet * Use selection set to make query string for definition query. * Apply definition query to Inspection Mapsheets layer * Change Layout text elements * Refresh map series * Export map series as PDF I added the mapbook derived output the last time i tried to get it to work. ResultsEx_GeoNet.py.zip

Here's what is happening: The SelectLayerByLocation_management function is using the subbasin layer— before the definition query is applied— as the selecting features input. Whatever definition query is applied to the subbasin layer when the project is opened is the one used for the spatial selection. Even though I get the correct layer object and use it as a parameter in the selection (line 33). In the image below there was no definition query applied to the subbasin layer before the tool ran, so the selecting features were all the subbasins. I even had the tool sleep for 30 sec (line 30) while I manually refreshed the map to no effect ( BTW, there is no refresh method in the Map class of the mp module ). Next step is to export the layer with the definition query applied then use that output as the selecting features in the spatial selection. EDIT: CopyFeatures_management does the same thing as SelectLayerByLocation_management This is only an issue when run as a GP tool. No issue in the python console. Sure would be nice if someone from Esri would comment on this... import arcpy from arcpy import env import time # Global variables # ---------------- aprx = arcpy . mp . ArcGISProject ( 'CURRENT' ) myMap = aprx . listMaps ( 'Map' ) [ 0 ] sbCode = arcpy . GetParameterAsText ( 0 ) sbAIName = f 'Subbasin {sbCode}' sbDefQ = f 'AREA_CODE = {sbCode}' # Get the layer objects mshLayer = myMap . listLayers ( 'Mapsheets' ) [ 0 ] mshAILayer = myMap . listLayers ( 'AI Mapsheets' ) [ 0 ] aiResultLayer = myMap . listLayers ( 'AI Results' ) [ 0 ] sbAILayer = myMap . listLayers ( 'Subbasin *' ) myMap . clearSelection ( ) for sb in sbAILayer : arcpy . AddMessage ( f 'Layer name start of loop: {sb}' ) arcpy . AddMessage ( f 'Subbasin query string: {sbDefQ}' ) sb . definitionQuery = sbDefQ arcpy . AddMessage ( 'Definition query applied to AI Subbasins.' ) sb . name = sbAIName arcpy . AddMessage ( f 'AI Subbasin layer name changed to {sbAIName}' ) arcpy . AddMessage ( f 'Layer name end of loop: {sb}' ) arcpy . AddMessage ( 'Sleeping for 30 seconds...' ) time . sleep ( 30 ) # Manually refresh the map during sleep # Layer object again to ensure I have the correct one for selecting feature below sbSelection = myMap . listLayers ( sbAIName ) [ 0 ] # Perform spatial selections # -------------------------- # Select Acoustic Inspection results in desired subbasin resultsSelect = arcpy . SelectLayerByLocation_management ( aiResultLayer , 'WITHIN' , sbSelection , 0 , 'NEW_SELECTION' ) arcpy . AddMessage ( resultsSelect )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Works in ArcGIS Pro Python Console but FUBAR with script tool

BradJones3

I have an old script tool that I'm migrating to ArcGIS Pro. The tool only has two parameters (Subbasin: string, Directory: folder) and it is supposed export a PDF mapbook of the features for the subbasin number entered.

I wrote the code and tested it in the Python console window in Pro. It works fine. I have exported >20 mapbooks.

I configured it as a script tool and two things happen:

Whatever subbasin is entered, the resulting section set for mapsheets is always the selection set that was desired on the previous run of the tool—seriously weird!
The PDF export file is never created. The exportToPDF function seems to run, but no file is generated and no exception is thrown.

The logic is as follows:

Check the map for the required layers
Apply the definition query for the desired subbasin
Perform selections to get the desired mapsheet grid
1. Select inspection results for the desired subbasin
2. Select mapsheets for previously selected inspection results
Apply definition query to based on mapsheet selection
1. Get selection set for mapsheet
2. Use selection set to make query string for definition query.
3. Apply definition query to Inspection Mapsheets layer
Change Layout text elements
Refresh map series
Export map series as PDF

I added the mapbook derived output the last time i tried to get it to work.

ResultsEx_GeoNet.py.zip

Find more posts tagged with

Accepted answers

All comments

curtvprice

Sure would be nice if someone from Esri would comment on this...

Now that you have the problem so well defined, I would contact Esri support so they can reproduce and fix it!

BradJones3

Here's what is happening:

The SelectLayerByLocation_management function is using the subbasin layer— before the definition query is applied— as the selecting features input.</CODE>Whatever definition query is applied to the subbasin layer when the project is opened is the one used for the spatial selection. Even though I get the correct layer object and use it as a parameter in the selection (line 33).In the image below there was no definition query applied to the subbasin layer before the tool ran, so the selecting features were all the subbasins.I even had the tool sleep for 30 sec (line 30) while I manually refreshed the map to no effect (BTW, there is no refresh method in the Map class of the mp module).Next step is to export the layer with the definition query applied then use that output as the selecting features in the spatial selection.EDIT: CopyFeatures_management does the same thing as SelectLayerByLocation_managementThis is only an issue when run as a GP tool.  No issue in the python console.Sure would be nice if someone from Esri would comment on this...<CODE class="">

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> time


<SPAN class="comment token"># Global variables</SPAN>
<SPAN class="comment token"># ----------------</SPAN>
aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'CURRENT'</SPAN><SPAN class="punctuation token">)</SPAN>
myMap <SPAN class="operator token">=</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Map'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
sbCode <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
sbAIName <SPAN class="operator token">=</SPAN> f<SPAN class="string token">'Subbasin {sbCode}'</SPAN>
sbDefQ <SPAN class="operator token">=</SPAN> f<SPAN class="string token">'AREA_CODE = {sbCode}'</SPAN>
<SPAN class="comment token"># Get the layer objects</SPAN>
mshLayer <SPAN class="operator token">=</SPAN> myMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Mapsheets'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
mshAILayer <SPAN class="operator token">=</SPAN> myMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'AI Mapsheets'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
aiResultLayer <SPAN class="operator token">=</SPAN> myMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'AI Results'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
sbAILayer <SPAN class="operator token">=</SPAN> myMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Subbasin *'</SPAN><SPAN class="punctuation token">)</SPAN>

myMap<SPAN class="punctuation token">.</SPAN>clearSelection<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> sb <SPAN class="keyword token">in</SPAN> sbAILayer<SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'Layer name start of loop: {sb}'</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'Subbasin query string: {sbDefQ}'</SPAN><SPAN class="punctuation token">)</SPAN>
    sb<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> sbDefQ
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Definition query applied to AI Subbasins.'</SPAN><SPAN class="punctuation token">)</SPAN>
    sb<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> sbAIName
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'AI Subbasin layer name changed to {sbAIName}'</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'Layer name end of loop: {sb}'</SPAN><SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Sleeping for 30 seconds...'</SPAN><SPAN class="punctuation token">)</SPAN>
    time<SPAN class="punctuation token">.</SPAN>sleep<SPAN class="punctuation token">(</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Manually refresh the map during sleep</SPAN>

<SPAN class="comment token"># Layer object again to ensure I have the correct one  for selecting feature below</SPAN>
sbSelection <SPAN class="operator token">=</SPAN> myMap<SPAN class="punctuation token">.</SPAN>listLayers<SPAN class="punctuation token">(</SPAN>sbAIName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Perform spatial selections</SPAN>
<SPAN class="comment token"># --------------------------</SPAN>
<SPAN class="comment token"># Select Acoustic Inspection results in desired subbasin</SPAN>
resultsSelect <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>aiResultLayer<SPAN class="punctuation token">,</SPAN>
                                                       <SPAN class="string token">'WITHIN'</SPAN><SPAN class="punctuation token">,</SPAN>
                                                       sbSelection<SPAN class="punctuation token">,</SPAN>
                                                       <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN>
                                                       <SPAN class="string token">'NEW_SELECTION'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN>resultsSelect<SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

BradJones3

That's the problem...There were no selections. The selections are cleared each time. And I'm deleting the display cache.

I may try rebuilding the project from scratch.

bixb0012

Since you imported the maps and layouts into the new project, you must also be importing the selections on layers from the other project. What if you clear all selections from the original project before importing maps and layouts into new project and running script tool?

BradJones3

I tested everything in the Python console before I moved it to the script tool. So the first time it ran as a script tool the mapsheets/grid selection was same as the previous run in the console—not the desired result.

I created a new project, imported the maps and layouts, and created another script tool and the result is the same. The mapsheet/grid selection result is what was desired in the last run in the other project.

bixb0012

Whatever subbasin is entered, the resulting section set for mapsheets is always the selection set that was desired on the previous run of the tool

What happens on the first run, since there is no previous run?

BradJones3

I gave the layers completely unique names as a quick test and the result is the same.

I think I may just rebuild it as an ArcGIS Pro add-in.

curtvprice

That does seem mysterious. Just a wild guess: one issue has bit me in the past with geoprocessing is that if you provide a string "foobar", if you have a layer named "foobar" in the session and a dataset named "foobar" in the current workspace, you sometimes get one or the other (I think this layer gets precedence, but I'm not sure, and it may depend on context). My fix for this is has been to make sure when I reference an input if I want the dataset (not the layer), I convert it to a full path.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.