Latest Contributions by DeanAnderson2

This issue or similar ones have been previously been reported to ESRI   (Esri Case #03242592) by me.  I thought it was fixed at 11.x.  This was also reported to this group (with no solution) back in 2019 (arcpy.da.Editor Not Working Properly) I am working on a project to develop best practices for migrating a series of tools that run in an ArcPro/Fabric GDB environment to an ArcPro/Fabric branched version environment (ArcProFabric 3.1+/Enterprise 11.1+).  I am running into a consistently inconsistent problem with converting my Scripts/tools.   Attached is a zip file the contains  a toolbox with  the tool (UpdateCogoArea) and associated python script (UpdateCoGoArea.py). For selected taxlots this tool calculates two attributes (TaxlotFeet/TaxlotAcre) from the CalculatedArea field and calculates the MapAcres field from the Shape_Area field.  It’s a simple calculation and the three attributes are required for our state standard.    Tool Requirements:  ActiveBranchVersion, Selected Taxlots (Fabric) with the CalculatedArea field and the three required fields ('TaxlotAcre',"TaxlotFeet",'MapAcre’) all numeric/double.  You can run this tool on your data if you add the fields and change the reference to your parcel fabric layer.   Options: Within the python script you can change how the tool runs. It can either use the CalculateFields tool or use “arcpy.da.Editor” with an update cursor.  (Line 42/43) In the script (useCalcFields = True or False.) Issues:  The CalcFields Option works great.  I do not set the edit environment etc.  The UpdateCusor option causes strange results.  When you run it a) the attributes are not updated (however if you open and close the session) they  will be.  b) if you spatially select the  polygons and try to look at the attributes the table will come up with two records selected but you will NOT be able to see them (unless you open and close the project). My Question?   Am I referencing the versioned workspace incorrectly? (I display the version and workspace  as part of the script messages)  Am I using the UpdateCursor with the arcpy.da.Editor incorrectly ? Is there a problem with our services or the software ?  To Test:    Add the three fields ('TaxlotAcre',"TaxlotFeet",'MapAcre’) to your ParcelFabric parceltype.     Edit the UpdateCogoArea  script and tool to reference YOUR parcel fabric layer (my layer is called Taxlot)  make sure the python script has useCalcFields = false (line 43). This will run the tool using the da.editor and update cursor option.   Open the project, select a couple fabric polygons (with calculatedarea populated) and run the tool (messages are below). See if the calcs worked, with the table open spatially select your polygons again – Note if the fields are updated and attributes updated. Close and re-open the project.  Does this look and act as expected ?  Select the polygons and calculate the three fields equal to zero.  Close the project.  Edit the python script and change useCalcFields = True and save Open the project.  Select the polygons and re-run the tool. Review the results (Everything should operate as expected).  For those that do not want to to the test here the two alternative. Again CalculateFields works but UpdateCursor and edit session does not. I have included tool messages for reference after the following code.  # -------- This works --------- if useCalcFields: arcpy.management.CalculateFields(mapTaxlotLyr, "Python3",[["TaxlotAcre", "round(!CalculatedArea! / 43560,2)"],["TaxlotFeet", "round(!CalculatedArea!,2)"],["MapAcres", "round(!Shape__Area! / 43560,2)"]]) arcpy.AddMessage('Used CalcFields') sys.exit('Calcone') # ----------- This does NOT work ---------- # get workspace and version  thisProject = arcpy.mp.ArcGISProject("CURRENT") Map= thisProject.activeMap mapTaxlotLyr = Map.listLayers("Taxlot")[1] # set data source and version (Not Needed for "CalcFields" but used with edit session) MapLayerDataSource = mapTaxlotLyr.dataSource lastslash = MapLayerDataSource.rfind("/") WorkSpace = MapLayerDataSource[:lastslash] arcpy.AddMessage("WorkSpace: " + WorkSpace) AfterVEq = MapLayerDataSource.rfind("VERSION=") + 8 Version = MapLayerDataSource[AfterVEq:] BeforeVID = Version.rfind(";") Version = Version[:BeforeVID] arcpy.AddMessage ("Version: " + str(Version)) # Do the edit  edit = arcpy.da.Editor(WorkSpace) edit.startEditing(with_undo=False, multiuser_mode=True) edit.startOperation() with arcpy.da.UpdateCursor(mapTaxlotLyr,['CalculatedArea','shape__Area','TaxlotAcre',"TaxlotFeet",'MapAcres','Taxlot']) as cursor: for row in cursor: row[2] = 0 row[3] = 0 row[4] = 0 if row[0] != None: row[2] = round(row[0] / 43560,2) row[3] = round(row[0],2) if row[1]!= None: row[4] = round(row[1] / 43560,2) arcpy.AddMessage('Taxlot: ' + row[5]) arcpy.AddMessage('TaxlotAcre: ' + str(row[2])) arcpy.AddMessage('TaxlotFeet: ' + str(row[3])) arcpy.AddMessage('MapAcre: ' + str(row[4])) cursor.updateRow(row) # End Edit Session edit.stopOperation() edit.stopEditing(save_changes=True) Below are my messages referencing the version and versioned workspace...  I would VERY much appreciate ANY Help.  Thanks  ... View more

I am working with a new taxlot dataset that requires building the fabric from just polygons (which is new to me).  I am following the documented recommendation to use "SimplifyByStraightLinesAndCircularArcs" (without it I end up creating WAY to many lines).  In some cases the conversion converts lines to curves that I do not think should be converted and it is a problem.  I have changed the parameters for max_offset,  max_arc_angle_step, min_arc_angle, and min_vertex_count to MANY alternatives. Some of the silly (see below) and some push the options to extremes.  But the changes do not seem to impact the outcome. For example, you would think a max offset of .01 would mean lines would not deviate from the original by more the .01 (or so).  But that is not the case and it appears I get offsets close to .1.        arcpy.edit.SimplifyByStraightLinesAndCircularArcs(         in_features=OutClassTxLtPly,         max_offset="0.01 Feet",         fitting_type="FIT_TO_VERTICES",         circular_arcs="CREATE",         max_arc_angle_step=2,         min_vertex_count=4,         min_radius=None,         max_radius=None,         min_arc_angle=2,         closed_ends="PRESERVE",         anchor_points=None     ) The taxlot dataset I am converting is pretty typical and contains rural and urban maps.  My question is...  Is there a best practice or are there recommended options (besides using the defaults) for running this tool on parcels to create an optimal result ???      ... View more

I have an issue with cleaning up after my conversion process. I am using 2.9X ArcPro.  I have many multi-part taxlots in ArcMap and need these to persist in ArcPro/Fabric.  I have good line attributes and want to build my taxlot parcel polygons from my good line attributes. (I understand the limitations of this and address it in my conversion process) Here is the part of my process that is generating the problem.  Convert ArcMap taxlotlines to ArcPro Fabric Taxlot_lines (works as expected - uses esri tool etc...) Split the arcmap taxlot polygons into multipart ArcPro polygons  (works as expected)  Generate points (polygon centroids) from the new multi-part ArcPro polygons (works as expected)  Create New ArcPro Polygons for converted ArcPro Taxlot_lines & New Points (works as expected)  Use Dissolve (or pairwise dissolve) to re-created multi-part polygons (Problem - Dissolve generates a small number  number of tiny slivers - see below).  Dissolve has no tolerance and it does not matter what option I use. Dissolve just seems to do this.   The rest of my process works as expected     Question: What is the best way to get rid of these slivers in 2.9?   When I build parcels from my polygons the slivers at duplicate lines or "near duplicate lines" in my taxlot_lines feature class.  My fabric has less then 20,000 polygons.   Due to upgrade issues with servers my folks will NOT be able to upgrade to 3.x / 11.x for quite some time.  ... View more

We use a lot of tools/scripts to calculate values within the ArcPro/Parcel Fabric Branched Version Environment (when it makes sense not to use tasks or calc attribute rules).   I am testing Version 3.0+ and have run into the following problem and am hoping that I may doing something wrong.  After a lot of testing I have created the following simple script that that illustrates the problem. (This all works fine in 2.94 and in a standard GeoDatabase). We do not use SDE for editing.  Start State: Within Branched Version (GISADMIN.T67_9c_Test200Anno4)  map session, Anno0200Scale feature class with Field (MapNumber) with value set to '6.3.8C').   Process: APRX is open, Tool in Tool Box runs script,  Select OBJECTID = 7695 and Calc the value for MapNumber to be "XXXX" .  I have tested this using arcpy.da.Editor using UpdateCursor with the Source being:  https://giscarts.co.polk.or.us/server/rest/services/PF/Parcel_Fabric_3/FeatureServer;VERSION=GISADMI...  which I calculate from the datasource of the Anno0200Scale feature class (after I removed the feature class name from the datasource text string).   I have tested this without using the arcpy.da.Editor with da.UpdateCursor.  I have also tested this with a simple CalculateField both using the arcpy.da.editor and not using it.   Problem:  I always get the same result.  NOTHING HAPPENS unless I close the ArcPro session and reopen it. Then I can see the change.  Using refresh screen / Change Version tool etc... None of it works.  Its like the edit did not happen until I close the session and then go back in.  My hope is that I am doing something wrong and somebody can help me out.  Below is the script (again this is not production just a test).  - it is also attached as a txt file.  Finally, within a simple edit session I can interactively select features and calculate attributes, see the results with no problem.   import arcpy, os # 1. Get parameter values AnnoLayer = 'Anno0200Scale' #2. Set Map Layers and default paths thisProject = arcpy.mp.ArcGISProject("CURRENT") Map = thisProject.activeMap AnnoLyr = Map.listLayers(AnnoLayer)[0] FolderPath = thisProject.homeFolder arcpy.AddMessage ("Map: " + Map.name) arcpy.AddMessage (AnnoLyr.dataSource) datasource = AnnoLyr.dataSource lastslash = datasource.rfind("/") workspace = datasource[:lastslash] arcpy.AddMessage(workspace) MapNumber = 'XXXX' # do edit session (Comment it out if you do not want to use it edit = arcpy.da.Editor(workspace) edit.startEditing(with_undo=False, multiuser_mode=True) edit.startOperation() with arcpy.da.UpdateCursor(AnnoLyr, ["MapNumber"],"OBJECTID = 7695") as cursor: for row in cursor: row[0] = MapNumber cursor.updateRow(row) edit.stopOperation() edit.stopEditing(save_changes=True)     ... View more

We use a lot of tools/scripts to calculate values within the ArcPro/Parcel Fabric Branched Version Environment (when it makes sense not to use tasks or calc attribute rules).   I am testing Version 3.0+ and have run into the following problem and am hoping that I may doing something wrong.  After a lot of testing I have created the following simple script that that illustrates the problem. (This all works fine in 2.94 and in a standard GeoDatabase). We do not use SDE for editing.  Start State: Within Branched Version (GISADMIN.T67_9c_Test200Anno4) , Anno0200Scale feature class with Field (MapNumber) with value set to '6.3.8C').   Proposed Process: Select OBJECTID = 7695 and Calc the value for MapNumber to be "XXXX" .  I have tested this using arcpy.da.Editor using UpdateCursor with the Source being:  https://giscarts.co.polk.or.us/server/rest/services/PF/Parcel_Fabric_3/FeatureServer;VERSION=GISADMIN.T67_9c_Test200Anno4;VERSIONGUID={6284F53F-3A4B-4FFF-994E-7606A6AA3783}  which I calculate from the datasource of the Anno0200Scale feature class (after I removed the feature class name from the datasource text string).   I have tested this without using the arcpy.da.Editor with da.UpdateCursor.  I have also tested this with a simple CalculateField both using the arcpy.da.editor and not using it.   Problem:  I always get the same result.  NOTHING HAPPENS unless I close the ArcPro session and reopen it. Then I can see the change.  Using refresh screen / Change Version tool etc... None of it works.  Its like the edit did not happen until I close the session and then go back in.  My hope is that I am doing something wrong and somebody can help me out.  Below is the script (again this is not production just a test).  - it is also attached as a txt file.  Finally, within a simple edit session I can interactively select features and calculate attributes, see the results with no problem.   import arcpy, os # 1. Get parameter values AnnoLayer = 'Anno0200Scale' #2. Set Map Layers and default paths thisProject = arcpy.mp.ArcGISProject("CURRENT") Map = thisProject.activeMap AnnoLyr = Map.listLayers(AnnoLayer)[0] FolderPath = thisProject.homeFolder arcpy.AddMessage ("Map: " + Map.name) arcpy.AddMessage (AnnoLyr.dataSource) datasource = AnnoLyr.dataSource lastslash = datasource.rfind("/") workspace = datasource[:lastslash] arcpy.AddMessage(workspace) MapNumber = 'XXXX' # do edit session (Comment it out if you do not want to use it edit = arcpy.da.Editor(workspace) edit.startEditing(with_undo=False, multiuser_mode=True) edit.startOperation() with arcpy.da.UpdateCursor(AnnoLyr, ["MapNumber"],"OBJECTID = 7695") as cursor: for row in cursor: row[0] = MapNumber cursor.updateRow(row) edit.stopOperation() edit.stopEditing(save_changes=True)       ... View more

We have recently begun using different "maps" to help organize edit workflows for parcel fabric. We have also been using Tasks.  Unfortunately, it appears that Task "map views" can ONLY be set at design time using the task design environment and there is no setting for "use current or activemap".  In the example below (very simplified) "Map1" is the active map for the task.  If I want to use "Map" I have to open the designer and select it as the active map or press the "CurrentView" button at the bottom of the screen and if "Map" is the active view it will set it.   But, again this only works at design time.   If so, tasks are tied to a specific view or map and whenever someone changes the map name all tasks associated with the map must also be changed.   I feel like I am missing something so any clarification would be greatly appreciated.  If this is how it works I will need to re-think some things.    ... View more