POST
|
Hey Darren, No, I don't think the script limits the FC to one row. There are four separate polygons in the featureclass. I think the only way to change symbology in a script is by using arcobjects. I'm not using DDP. I will try to test the if elif clause. Thanks again for your help. Jeff
... View more
06-28-2016
09:48 AM
|
0
|
1
|
894
|
POST
|
Here is the cursor version if anyone has ideas.... FC = r"\\swf-netapp1\RefGIS\FY-15_FLD_Support\Geospatial\Automation_Tools\Daily_Lake_Map.gdb\Grapevine_Lake_Poly" # Sets the field to take pool level from Fields = ['Pool_Status'] with arcpy.da.UpdateCursor(FC, Fields, "NAME = 'Grapevine Lake'") as cursor: for row in cursor: if (row[0] == "'SP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake SP'" elif (row[0] == "'CP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake CP'" elif (row[0] == "'FP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake FP'" elif (row[0] == "'SC'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake SC'" cursor.updateRow(row) mxd.save() del mxd print '6 - Joined Lake_Flood_Point to Lakes Poly and set pool poly color'
... View more
06-28-2016
05:36 AM
|
0
|
1
|
894
|
POST
|
Thanks for the help on this. I'm trying to apply one definition query based upon what the data is in Pool_Status. This is in an effort to fully automate a lake level map. This is the only way I can think of to change the color of a text box without fooling with arc objects. I have 25 lakes that I'm creating 4 different polygons for each that change color if the pool level is raised. Each will be represented by the polygon selected in the definition query. I'm thinking a cursor is not the best approach here.Thanks again. Jeff
... View more
06-28-2016
05:30 AM
|
0
|
0
|
894
|
POST
|
Hi- I'm trying to change the polygon selection based upon a field in it's own attribute table. I have 4 polygons in the feature class each representing a different lake levels and I would like to be able to change the polygon to the one that represents the data in the Pool_Status field. My code runs in pyscripter, but does not update the .mxd. Any help is appreciated. Here is my code: import arcpy mxd = arcpy.mapping.MapDocument(r'\\swf-netapp1\RefGIS\FY-15_FLD_Support\Geospatial\Automation_Tools\LM_Test.mxd') # Updates the color of the poly to reflect pool level # Sets the field to take pool level from df = arcpy.mapping.ListLayers(mxd, "Grapevine_Lake_Pool") for lyr in arcpy.mapping.ListLayers(mxd, "Pool_Status", df): if ([Pool_Status] == "'SP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake SP'" elif ([Pool_Status] == "'CP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake CP'" elif ([Pool_Status] == "'FP'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake FP'" elif ([Pool_Status] == "'SC'"): for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'Grapevine Lake Pool': lyr.definitionQuery = "NAME = 'Grapevine Lake SC'" mxd.save() del mxd
... View more
06-27-2016
10:48 AM
|
0
|
7
|
3146
|
POST
|
Thanks Dan. I tried what you suggested to no avail. Link is still broken. May just try to repair it with python. Appreciate you taking the time to help. Jeff
... View more
06-14-2016
12:05 PM
|
0
|
0
|
514
|
POST
|
Hi Blake, Thanks for the reply. I'm am using the example from ESRI. I'm using Pyscripter. I'm automating a update of an .mxd, so I need to do the work from the outside. I'm going to be joining the table next and doing field calcs to update a feature class with daily lake level numbers. My goal is to not have to open the .mxd at all. I'm not sure why it works but the link is broken... Anyhow, thanks again. Jeff
... View more
06-13-2016
10:33 AM
|
0
|
2
|
514
|
POST
|
Hi, I'm having trouble adding a table to an .mxd using Python. The script adds the table, but it has a broken link. I can fix it by setting the data source manually. Any Ideas? Here is my script: import arcpy mxd = arcpy.mapping.MapDocument(r'\\swf-netapp1\RefGIS\FY 15_FLD_Support\Geospatial\Automation_Tools\LM_Test.mxd') df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] flyxsection_tbl = arcpy.mapping.TableView(r'\\swf-netapp1\RefGIS\FY-15_FLD_Support\Geospatial\Automation_Tools\Daily_Lake_Map.gdb\flyxsection') arcpy.mapping.arcpy.AddTableView(df, flyxsection_tbl) mxd.save() del mxd, flyxsection_tbl print ' Script Complete' Thanks, Jeff
... View more
06-13-2016
10:05 AM
|
0
|
4
|
2525
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|