Latest Contributions by Brian_McLeer

In ArcGIS Desktop under Data Reviewer Tools, there was a tool that performed a GDB schema comparison. This appears to have been deprecated with no viable replacement in ArcGIS Pro. Being able to compare GDB schemas between a parent/child or production/development database is very beneficial.  Are there any plans to bring this back into Pro? The Pro version I am on is 2.6.2.    ... View more

In ArcMap, on the table of contents window, you can list data by source. From there, you can remove data from the TOC at the source level and remove all of the data from that data source. This functionality is not available in Pro (at least at version 2.6.2). Being able to remove data from a TOC in batch via the same source without having to highlight all the layers would be a good addition to bring over from ArcMap.  ... View more

In creating database sequences, there is not a streamlined way to view database sequences that have been created. I have seen other posts of using Python to list database sequences, but that seems to only be applicable to file geodatabase and not enterprise databases.  List Database Sequences for Enterprise Geodatabase  Being able to view database sequences in a database would be beneficial, especially as these can interact with attribute rules to auto-generate values. Viewing along the same lines as you can for attribute rules, domains, subtypes, etc.  ... View more

In trying to upgrade code from Python 2 to 3, the below code broke for a calculate field that functioned in 2.x.  I tried putting double quotes around the (' & ') based on some searching, but did not do the trick.      !FullName!.split(' & ')[1].split('/')[0]     The error is: ERROR 000539: Traceback (most recent call last): File "<expression>", line 1, in <module> IndexError: list index out of range Failed to execute (Calculate Field (4)). ... View more

Our organization is migrating SDE Python routines from Python 2.x to Python 3.x that run nightly on a SQL Server machine. In this migration process, we discovered that database replication from  ArcGIS Pro (Python 3.x) does not support replicating geometric networks. We had to create a workaround of deleting the GN into the child database, then copy features from parent to child database.  While we are aware that ArcGIS Pro can only view and not edit geometric networks and that utility networks are the next step, many organizations will be using geometric networks for a while as it will take years to migrate over to the utility network. It would be nice if Python 3.x can function with replicating geometric networks. My understanding it was not until ArcGIS Pro 2.5 or 2.6 that database replication was even available in ArcGIS Pro.  ... View more

In trying to migrate from 2.x to 3.x, I am trying to update a segment of code and my troubleshoot has ran its limits with Google. I am trying to remove domains from fields in various feature classes below. My error, in particular, comes from the image below where the error I get is the 'NoneType' object is not callable.  Full Code: # Comments arcpy.AddMessage("Removing All Domains..." +'\n') txtFile.write("Removing All Domains..." +'\n') #Set workspace environment to geodatabase arcpy.env.workspace = "D:\\WorkSpace\\WebReporter\\Workspace.gdb" myGDB = "D:\\WorkSpace\\WebReporter\\Workspace.gdb" #Get list of feature classes in geodatabase FCs = arcpy.ListFeatureClasses() #Loop through feature classes in list for FC in FCs: #List fields in feature class fields = arcpy.ListFields(FC) #Loop through fields for field in fields: #Check if field has domain if (field.domain != "" and field.domain != 'EnabledDomain' and field.domain != 'AnnotationStatus'): #Print feature class, field, domain name print (FC, field.name, field.domain) arcpy.RemoveDomainFromField_management(FC, field.name) # Get domains that are assigned to a field domains_used = [] for dirpath, dirnames, filenames in arcpy.da.Walk(myGDB, datatype=["FeatureClass", "Table"]): for filename in filenames: print ("Checking {}".format(os.path.join(dirpath, filename))) ## Check for normal field domains for field in arcpy.ListFields(os.path.join(dirpath, filename)): if field.domain: domains_used.append(field.domain) ## Check for domains used in a subtype field # Comments arcpy.AddMessage("I got to here..." +'\n') txtFile.write("I got to here..." +'\n') subtypes = arcpy.da.ListSubtypes(os.path.join(dirpath, filename)) for stcode, stdict in subtypes.items(): if stdict.get('keys')()()("SubtypeField") != u'': for field, fieldvals in stdict.get('keys')("FieldValues").items(): if not fieldvals[1] is None: domains_used.append(fieldvals[1].name) # Get domains that exist in the geodatabase domains_existing = [dom.name for dom in arcpy.da.ListDomains(myGDB)] # Find existing domains that are not assigned to a field domains_unused = set(domains_existing) ^ set(domains_used) print ("{} unused domains in {}".format(len(domains_unused), myGDB)) for domain in domains_unused: arcpy.DeleteDomain_management(myGDB, domain) print ("{} deleted".format(domain) ) # Comments arcpy.AddMessage("Removing All Domains Complete..." +'\n') txtFile.write("Removing All Domains Complete..." +'\n')   ... View more