Latest Contributions by Brian_McLeer

‎12-23-2020

I have seen questions on GeoNet about this, but not on the idea board. Is there a plan to allow for the creation or updating of RBJ files in ArcGIS Pro?

‎08-31-2020

Thank you, Michael, that did work. This will be helpful as we will have parallel Python environments of 2.7.x and 3.x until we can fully migrate to ArcGIS Pro.

‎08-27-2020

In trying to migrate Python Scripts from ArcGIS Desktop Python 2.7.x to ArcGIS Pro 3.x, we email staff if there is a failure on a routine. Below I am running a sync replica routine using ArcGIS Pro, deliberately breaking it on the file path to the database connection string so it will email a failure. Somewhere in migration, it does not like the email code that has been working for years now. Has anyone else had to upgrade email failures from 2.7.x to 3.x in Python? With using the correct file path, the routine was successful. We use Windows Task Scheduler to run Python routines. I receive the error (server name omitted for security): try: arcpy.management.SynchronizeChanges(r"C:\Tech_Info\DB_CONX\SERVER\SERVER ParentDatabase user.sde", "ReplicaName", r"C:\Tech_Info\DB_CONX\Server\SERVER ChildDatabase user.sde", "FROM_GEODATABASE1_TO_2", "IN_FAVOR_OF_GDB1", "BY_OBJECT", "RECONCILE ") except Exception as e: arcpy.AddMessage("SynchronizeChanges_management ISGIS.ReplicaName Failed..." +'\n') txtFile.write("SynchronizeChanges_management ISGIS.ReplicaName Failed..." +'\n') txtFile.write (arcpy.GetMessages() + '\n') HOST = "host.server.com" SUBJECT = "Priority: CRITICAL Routine Failure" TO = "email@python.org" FROM = "Routine Failure<failure@python.org>" text = "Routine has failed. Please see log file for detailed information. \n Error Message: \n " + str(e.msg) BODY = string.join(( "From: %s" % FROM, "To: %s" % TO, "Subject: %s" % SUBJECT, "", text ), "\r\n") server = smtplib.SMTP(HOST) server.sendmail(FROM, [TO], BODY) server.quit()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎08-18-2020

Thank you, Johannes, that did the trick. Your help is appreciated.

‎08-17-2020

Thank you, Johannes, It has definitely made progress, I then receive an error: An invalid SQL statement was used. [SELECT MasterID, OBJECTID FROM COH_Address WHERE SHAPE@]

‎08-13-2020

Environment: ArcGIS Desktop 10.6.1 Below, I am attempting to snap a point feature class to the geometry of an address feature class based on a common 'Master ID' field using a join. The code originally comes from arcgis desktop - Snapping point to point based on attribute? - Geographic Information Systems Stack Exchange However, this is not moving my points, and the data is clean and does match up. arcpy.MakeFeatureLayer_management("D:\\WorkSpace\\POI\\Workspace.gdb\\COH_POI", "POI_Layer", "", "", "") arcpy.SelectLayerByAttribute_management("POI_Layer", "NEW_SELECTION", "MASTER_ID IS NOT NULL") pt_on_line = "D:\\WorkSpace\\POI\\Workspace.gdb\\COH_Address" pt_on_line_ID = 'MasterID' # common ID field pt_off_line = "POI_Layer" pt_off_line_ID = 'MASTER_ID' # common ID field pt_on_line_dict = {str(row[0]):row[1] for row in arcpy.da.SearchCursor(pt_on_line,[pt_on_line_ID,"SHAPE@"])} # make dictionary, like {ID:geometry} with arcpy.da.UpdateCursor(pt_off_line,[pt_off_line_ID,"SHAPE@"]) as cursor: for row in cursor: # loop through points row[1] = pt_on_line_dict[str(row[0])] # move point geometry to match point geometry from dictionary cursor.updateRow(row) # update the geometry del cursor, row‍‍‍‍‍‍‍‍‍‍‍‍

‎06-29-2020

When exporting a feature dataset from one DB to another, the schema, features, and domains transfer over. However, attribute rules do not transfer over. Enabling attribute rules to be exported to XML schema and imported would be beneficial when migrating a schema.

‎06-11-2020

I had this same issue. I was developing the schema in an FGDB, and I assumed you could simply copy and paste the feature class over to SDE and the domains would transfer over as this way would work with ArcMap. For a workaround, I did the following steps: - Export new schema to XML workspace document with data included - Import XML workspace document into SDE, this will also transfer over the domains - If you are trying to get a new schema into a feature dataset, you will need to copy and paste the source feature class as a standalone FC into SDE, then again copy and paste that FC into the feature dataset, it will have a name like _1 at the end. Delete the standalone feature class, then rename the feature class in the feature dataset by removing the _1.

‎05-11-2020

We are using branch versioning for the first time in an SDE database (SQL Server 2016). For our existing traditional versioning DBs, we use the recommended compress, rebuild indexes, and analyze datasets in our nightly routines similar to ESRI documentation below. This methodology is not recommended with branch versioning, however. Is anyone using certain GP tools on a regular basis for database maintenance for an SDE database that uses branch versioning? If so, what methods are you using? Do branch versioned DBs require daily maintenance as traditional versioned DBs require? Enterprise geodatabase maintenance tasks—Manage geodatabases in SQL Server | Documentation

‎01-08-2020

Trying to start/stop specific services. Using the article at How To: Stop GIS services using ArcGIS API for Python, I tried using the code but keep receiving an error message below posted code. I am running this script in IDLE (ArcGIS Pro). Using just IDLE for ArcGIS Desktop did not have the necessary modules. from arcgis.gis import GIS import arcgis.gis.admin gis = GIS("https://url.to.com/portal", "Username", "Password", verify_cert=False) services = gis_servers.services.list() #To stop specific service(s) for service in services: for service in server.services.list(): if service.properties.serviceName == "SampleWorldCities": service.stop()‍‍‍‍‍‍‍‍‍ Error Message: Traceback (most recent call last): File "Z:\Temp\Brian\test.py", line 5, in <module> services = gis_servers.services.list() NameError: name 'gis_servers' is not defined

arcpy Disconnect Users randomly fails · ‎11-13-2019

We have a routine that uses the SDE admin connection to disconnect users from several databases nightly. Randomly, this python routine will occasionally fail with the error message below. Connection information provided was for a non-administrative user There is not any more information provided by the reports. My first guess was a permission issue like this post https://community.esri.com/thread/89448 . We are using a general SQL service account to run routines, but permissions should not explain why it fails randomly and is successful at other times.

‎08-28-2019

Thanks, Xander, For the exact feature class name, is that the entire connection string, or feature class name itself? Also, the tax lot feature class resides in a separate database than the address points.

‎08-28-2019

Being new to Arcade and Attribute rules, I am trying to put in place a rule that populates a tax lot ID number on an address point upon insert or update. The error I receive comes from line 6 at the bottom of the thread. ERROR 002717: Invalid Arcade expression, Arcade error: Table not found WC Tax Lots What I am having trouble connecting the dots is how to grab the TLNO from the tax lot polygon and assign it to the TLNO GIS field in the address point feature class. In my Contents, the tax lot layer is titled as WC Tax Lots as it is in the code below. I received the code sample from GitHub - Esri/arcade-expressions: ArcGIS Arcade expression templates for all supported profiles in the ArcGIS platform. // Value to copy from the intersected feature var intersecting_field = "TLNO GIS"; //Field rule is assigned to in the Attribute Rule var feature_field = "TLNO"; // Create feature set to the intersecting class using the GDB Name var intersecting_featset = FeatureSetByName($datastore, "WC Tax Lots", [intersecting_field], true); // Intersect the edited feature with the feature set and retrieve the first feature var intersected_feature = First(Intersects(intersecting_featset, $feature)); // Check to make sure there was an intersected feature, if not, return the original value if (intersected_feature == null) { return $feature[feature_field]; } // If the intersected feature is null, return the original value if (IsEmpty(intersected_feature.valueToCopy)) { return $feature[feature_field]; } // Return the intersected features value return intersected_feature[intersecting_field];‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎07-24-2019

Hi Rachel, The data frame coordinate system in both MXDs and coordinate system of the geometric network both match after looking at the properties.

‎07-24-2019

We are having an issue for one of our users editing in a geometric network. Several geometric network editing toolbar buttons are not available for use. This error does not occur when I open the same MXD. Both the user and I are on ArcGIS Desktop 10.6.1 Advanced License on Windows 10. When I open the MXD, all tools are available: When the user opens the MXD, all buttons besides connect and disconnect are greyed out: We have verified that the only 1 feature (the one intended to be edited) was selected on both computers.

Online Status	Online
Date Last Visited	16 hours ago

My Ideas

Latest Contributions by Brian_McLeer

Update RBJ Files in ArcGIS Pro

Re: Email from Python 2.7.x to 3.x

Email from Python 2.7.x to 3.x

Re: Move point geometry to other location based on common ID

Re: Move point geometry to other location based on common ID

Move point geometry to other location based on common ID

Allow Attribute Rules to transfer with export/import XML schema

Re: Copying domains from one GDB to another

Recommended SDE database maintenance in branch versioning environment

Stopping and Starting Services in Portal via Python

arcpy Disconnect Users randomly fails

Re: Calculate field based on common geometry using Attribute Rules

Calculate field based on common geometry using Attribute Rules

Re: Geometric Network Editing Buttons Greyed Out

Geometric Network Editing Buttons Greyed Out

Re: Right Click Widget

Re: Advanced Draw Widget Improvements: Import, Exp...

Re: Advanced Draw Widget Improvements: Import, Exp...

Re: Right Click Widget

Re: Right Click Widget

Experience Builder Custom Widgets

Experience Builder Tips and Tricks