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; } } }

Layer definition query and symbology not updating using arcpy

AZumwalt

Layer definition query and symbology not updating using arcpy - what am I missing?

import arcpy, os
arcpy.env.overwriteOutput = True
grab = arcpy.GetParameterAsText(0)
prep_list = grab.split(";")

mxd_c = arcpy.mapping.MapDocument(r"T:\GIS\Projects\GIS\Online\MapDocuments\FeederMapCover.mxd")
lyrs_c = arcpy.mapping.ListLayers(mxd_c)

feederList = ["HB2", "HB3"]
print "got feeder list"
arcpy.AddMessage("...starting map book...")

for feeder in feederList:
        arcpy.env.overwriteOutput = True
        for lyr in arcpy.mapping.ListLayers(mxd_c):
            if lyr.name == "Overhead":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
            if lyr.name == "Primary Underground Conductor":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
        print "Definition Queries Set" + feeder
        # Find Overview Data Frame and Zoom to the Map Index
        df = arcpy.mapping.ListDataFrames(mxd_c, "Layers")[0]
        zoomLayer = arcpy.mapping.ListLayers(mxd_c, "Overhead", df)[0]
        df.extent = zoomLayer.getSelectedExtent(False)
        df.scale = df.scale * 1.5
        print "Zoomed Successfully"

        # Make and Add the FeederMapIndexLAYER feature layer to the map and refresh the view
        arcpy.env.workspace = r"T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb"
        FeederMap = "T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb\FeederMapIndex"
        arcpy.MakeFeatureLayer_management(FeederMap,  "FeederMapIndexLAYER")
        print "Feature Layer Created"
        addLayer = arcpy.mapping.Layer('FeederMapIndexLAYER')
        print "Feature Layer Added to Map"
        arcpy.mapping.AddLayer(df, addLayer)
        arcpy.RefreshTOC()
        arcpy.RefreshActiveView()

        # Field Calculator InMap = 0
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression= 0 )
        print "Index Field Calculator Worked"

        # Select FeederMapIndexLayer polygons that intersect Overhead Lines and Calculate FeederMapIndex = 1
        Selection = arcpy.SelectLayerByLocation_management('FeederMapIndexLAYER', 'INTERSECT', 'Overhead')
        print "Index Selection Completed"
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression= 1 )
        print "Index Field Calculator Worked"

        #Set FeederMapIndex Layer Definition Query and Refresh Map
        for lyr in arcpy.mapping.ListLayers(mxd_c):
            if lyr.name == "FeederMapIndexLAYER":
                lyr.definitionQuery = "InMap = 1"
                arcpy.RefreshTOC()
                arcpy.RefreshActiveView()
                print "Index Definition Query Worked"

        #Export the Map to a PDF
        arcpy.ApplySymbologyFromLayer_management('FeederMapIndexLAYER', 'C:/Users/azumwalt.UECOOP/Desktop/FeederMapIndex.lyr')
        arcpy.RefreshTOC()
        arcpy.RefreshActiveView()
        outputPath = r"Z:\FeederMaps\PDFs\Map" + feeder + "Cover.pdf"
        arcpy.mapping.ExportToPDF(mxd_c, outputPath)
        print"Map Book Printed" + feeder

print "complete"

Trouver plus de publications taguées avec

Accepted answers

All comments

AZumwalt

I ended up just using this (albeit long) workaround:

Make Overhead a Layer

Add Layer to Map (probably could remove this step)

FeatureClassToFeatureClass (with expression)

Make New Feature Class a Layer

SelectLayerByLocation using new Layer

- I'm also going to have to delete the new feature class at some point.

import arcpy
arcpy.env.overwriteOutput = True
grab = arcpy.GetParameterAsText(0)
prep_list = grab.split(";")

mxd_c = arcpy.mapping.MapDocument(r"T:\GIS\Projects\GIS\Online\MapDocuments\FeederMapCover.mxd")
lyrs_c = arcpy.mapping.ListLayers(mxd_c)
df = arcpy.mapping.ListDataFrames(mxd_c)[0]

print "got feeder list"
arcpy.AddMessage("...starting map book...")

# Make and Add the FeederMapIndexLAYER feature layer to the map
FeederMap = "T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb\FeederMapIndex"
Overhead =  "Database Connections\ElectricModel - azumwalt.sde\ElectricModel.DBO.UEC\ElectricModel.DBO.Overhead"
arcpy.MakeFeatureLayer_management(FeederMap, "FeederMapIndexLAYER")
arcpy.MakeFeatureLayer_management(Overhead, "OverheadLAYER")
layer = arcpy.mapping.Layer("FeederMapIndexLAYER")
layerOH = arcpy.mapping.Layer("OverheadLAYER")
arcpy.mapping.AddLayer(df,layer,"AUTO_ARRANGE")
arcpy.mapping.AddLayer(df,layerOH,"BOTTOM")
expression = "esUplineFeeder = 'HB2'"
arcpy.FeatureClassToFeatureClass_conversion(Overhead, "T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb","OverheadDeleteMe",expression)
arcpy.MakeFeatureLayer_management("T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb\OverheadDeleteMe","OverheadDeleteMe", )
overheadDeleteMe = arcpy.mapping.Layer("OverheadDeleteMe")
arcpy.mapping.AddLayer(df,overheadDeleteMe,"BOTTOM")

print "Feature Layer Added to Map"
for lyr in arcpy.mapping.ListLayers(mxd_c):
    if lyr.name == "Overhead":
        lyr.definitionQuery = "esUplineFeeder = 'HB2'"
arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression=0)
arcpy.SelectLayerByLocation_management('FeederMapIndexLAYER', 'INTERSECT', "OverheadDeleteMe")
arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression=1)
mxd_c.saveACopy("Z:\FeederMaps\MXDs\SHORTTEST_.mxd")

Not sure this is really a "correct answer" but more of a workaround.

Also - I'm not using Pro yet to do this as I want to create a tool and upload it using WebAppBuilder and I believe with Pro you have to have Portal and we are not quite there yet. (Correct me if I'm wrong).

AZumwalt

You mean doing this in Pro instead?

DanPatterson_Retired

the only thing you haven't tried is saving the layers to disk (ie as .lyrx files) prior to selectlayerbylocation

AZumwalt

I'm at a loss. I can't get these two lines to work properly outside of ArcMap.

The arcpy.SelectLayerByLocation_management tool does not recognize any definition queries set either in the code or in the map beforehand. Does anyone else have this issue? Is this a bug?

arcpy.SelectLayerByLocation_management('FeederMapIndexLAYER', 'INTERSECT', 'OverheadLAYER')
arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression=1)

AZumwalt

Hi Xander,

I updated the code so the feature layer is created before I iterated through the feeders - thank you!

Now when I open up the first mxd (TEST1) - having only run the code up until this point. The definition queries are present. When I manually type in the code into ArcMap (see screenshot) it works! Yay!

BUT.... When I run the code until the second mxd (TEST2) with seemingly the same code that was manually entered in ArcMap and open the map... It is obvious a selection was made before the CalculateField_managemenet tool was run (although nothing is selected when I open the map), and instead of just the overhead with the def. query being used during SelectLayerByLocation, ALL of the overhead was used. So every index that intersected an overhead line (1032/2032) is now InMap = 1. There should only be 17.

I'm not sure why what I'm running in ArcMap is not doing the same thing in my code. Am I missing something obvious?

Updated Code:

import arcpy
arcpy.env.overwriteOutput = True
grab = arcpy.GetParameterAsText(0)
prep_list = grab.split(";")

mxd_c = arcpy.mapping.MapDocument(r"T:\GIS\Projects\GIS\Online\MapDocuments\FeederMapCover.mxd")
lyrs_c = arcpy.mapping.ListLayers(mxd_c)
df = arcpy.mapping.ListDataFrames(mxd_c)[0]

feederList = ["HB2", "HB3"]
print "got feeder list"
arcpy.AddMessage("...starting map book...")

# Make and Add the FeederMapIndexLAYER feature layer to the map
arcpy.env.workspace = r"T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb"
FeederMap = "T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb\FeederMapIndex"
arcpy.MakeFeatureLayer_management(FeederMap, "FeederMapIndexLAYER")
print "Feature Layer Created"
layer = arcpy.mapping.Layer("FeederMapIndexLAYER")
arcpy.mapping.AddLayer(df,layer,"AUTO_ARRANGE")
print "Feature Layer Added to Map"

for feeder in feederList:
        arcpy.env.overwriteOutput = True
        for lyr in arcpy.mapping.ListLayers(mxd_c):
            if lyr.name == "Overhead":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
            if lyr.name == "Underground":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
        mxd_c.saveACopy("Z:\FeederMaps\MXDs\TEST1_" + feeder + ".mxd")
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression=0)
        arcpy.SelectLayerByLocation_management('FeederMapIndexLAYER', 'INTERSECT', 'Overhead')
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression=1)
        mxd_c.saveACopy("Z:\FeederMaps\MXDs\TEST2_" + feeder + ".mxd")

AlixVezina_0-1732129973304.png

MatthewProctorBrown_4-1732130487493.png

MatthewProctorBrown_5-1732130504553.png

2021-04-28 10_13_38-V5 HortPark and StreetGarden Audit (AGOL) - Data.png

abureaux_1-1732132888621.png

abureaux_2-1732132997274.png

XanderBakker

I see that you add a layer ( the same layer) for every feeder and you use the same name for them. This might make it harder for the code to reference the one you want. Why would you want to add the same layer twice? Isn't it possible to use the same layer for both feeders?

What do you see in the saved MXD? The query definition is properly set and the correct records have the value 1?

AZumwalt

Hello again,

So I am saving mxd's at regular intervals now but when it comes to intersecting the FeederMapIndexLayer with "Overhead" it's not recognizing the definition query - it just intersects it with ALL of the overhead lines. When I open the mxd the definition query is present.... any thoughts?

import arcpy
arcpy.env.overwriteOutput = True
grab = arcpy.GetParameterAsText(0)
prep_list = grab.split(";")

mxd_c = arcpy.mapping.MapDocument(r"T:\GIS\Projects\GIS\Online\MapDocuments\FeederMapCover.mxd")
lyrs_c = arcpy.mapping.ListLayers(mxd_c)

feederList = ["HB2", "HB3"]
print "got feeder list"
arcpy.AddMessage("...starting map book...")

for feeder in feederList:
        arcpy.env.overwriteOutput = True
        for lyr in arcpy.mapping.ListLayers(mxd_c):
            if lyr.name == "Overhead":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
            if lyr.name == "Underground":
                lyr.definitionQuery = "esUplineFeeder = '" + feeder + "'"
        print "Definition Queries Set" + feeder

        # Make and Add the FeederMapIndexLAYER feature layer to the map
        arcpy.env.workspace = r"T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb"
        FeederMap = "T:\GIS\Projects\GIS\Online\SpatialData\FeederMaps.gdb\FeederMapIndex"
        arcpy.MakeFeatureLayer_management(FeederMap,  "FeederMapIndexLAYER")
        print "Feature Layer Created"
        addLayer = arcpy.mapping.Layer('FeederMapIndexLAYER')
        print "Feature Layer Added to Map"

        # Field Calculator InMap = 0
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression= 0 )
        print "Index Field Calculator Worked"

        # Select FeederMapIndexLayer polygons that intersect Overhead Lines and Calculate FeederMapIndex = 1
        Selection = arcpy.SelectLayerByLocation_management('FeederMapIndexLAYER', 'INTERSECT', 'Overhead')
        print "Index Selection Completed"
        arcpy.CalculateField_management("FeederMapIndexLAYER", "InMap", expression= 1 )
        print "Index Field Calculator Worked"
        mxd_c.saveACopy("Z:\FeederMaps\MXDs\TEST1_" + feeder + ".mxd")

AZumwalt

Thanks for all your help guys! I am getting the notice "Cannot find reference "saveACopy" in mapping.py." I'm using pycharm and am not sure how to correct this. My Project Interpreter is referencing 10.6:

If this needs to be in a new thread let me know. I just want to be able to save my mxd's to troubleshoot

XanderBakker

Since you don't save the mxd at the end, you can investigate in the mxd to see if things were set properly or not. Since you also have selections going on, it would be good to or save the mxd (perhaps using save a copy with different names to be able to see the intermediate result in the mxd and validate if things go right) or include a number of print statements printing a property of a layer after setting it to be sure it works.

DanPatterson_Retired

therein lies the problem... from RefreshActiveView

RefreshActiveView is only needed if you want to see the active view of the current map document updated.

arcpy.mapping export, save, and printing functions will generate the expected updated results without use of RefreshActiveView.

So you need to save or export or print the mxd before seeing anything reflected in the document.

You do have an Export to pdf line, is that the issue?

You might try running in "current" mode to see it you get what you are looking for

AZumwalt

The current map document is not open. I just added the rest of the code so you can see all of it.

XanderBakker

Would be best to include the complete code since your variable "mxd_c" is probably defined somewhere before, but we can't see how it has been defined.

DanPatterson_Retired

Is ArcMap open and the "current" document specified?

If Python is used to modify the table of contents within the current map document (e.g., change a layer name), the map will not automatically update with the changes. RefreshTOC is only needed if you want to see the table of contents updated.

See the code snippet in that topic... I don't see this line

mxd = arcpy.mapping.MapDocument("CURRENT")

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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