Latest Contributions by Bud

It sounds like item metadata (FC geoprocessing history) can significantly slow down geoprocessing and other operations in ArcGIS Pro. @NathanShaub in Geoprocessing History in Metadata We have several Python scripts that perform daily geoprocessing tasks.  Since geoprocessing history is automatically logged, the GDB_ITEMS table in our geodatabases bloats considerably and affects performance significantly.  I discovered the effect on performance by first taking the workaround code suggested by ESRI and modifying it so that I could run it at the geodatabase level to affect all objects in the geodatabase (the original workaround would take a VERY long time to actually perform if I had to go to each feature class individually).  Once I had cleaned up over two years of geoprocessing history from the GDB_ITEMS table of all of my geodatabases, I found that: 1) The reserved disk space for all of the SDE databases on my SQL Server dropped by nearly 11 Gb. 2) My automation scripts run MUCH faster.  For instance, one job that performs a DB compression and updates statistics went from taking 4 hours and 13 minutes to taking 8 minutes!  Another script that deletes several point feature classes and recreates them using X/Y coordinates downloaded from a business database went from taking 2 hours and 25 minutes to taking 15 minutes. There are also security concerns with sharing metadata with file paths externally. In Pro 3.3.0, we can disable item metadata tracking going forward and also delete metadata using the UI, one item at a time, or with custom Python code. This idea is to have an OOTB GP tool that will delete the item metadata from all items in a geodatabase. Or a list of checkboxes for each item; unselect the items where we want to keep the metadata. ... View more

ArcGIS Pro 3.3.0; File Geodatabase The Reorder Layers functionality in the Catalog context menu only seems to work for spatial layers, not for standalone tables. Bud_0-1715578750937.png Clicking Standalone Tables > Reorder Layers > By Name has no effect. Sort items in Contents Pane Python - Alphabetically sorting Tables in the Contents Pane Could standalone table sorting functionality be added? Side note: Could the options in that context menu be pared down to only show functionality that pertains to standalone tables? It seems like there's some stuff in there that's for spatial layers only. ... View more

It is my limited understanding that attribute rules can only use data from related database views if the view is registered with the geodatabase. @RPGIS in https://community.esri.com/t5/developers-questions/potential-bug-regarding-views-created-in-an-sde/m-p/1422294/highlight/true#M7033  It turns out that in order for attribute rules to identify any view(s) the view(s) need to be registered with the [geo]database. I have many database views that I want to keep as unregistered for ease of updating the SQL. Otherwise, every time I want to make a small change to the SQL, the view would need to be deleted, recreated, re-registered, and privileges redefined. That is an inefficient process and is error-prone. It would be a shame to move away from unregistered views, which are easy to manage, just to use them in attribute rules occasionally. Could attribute rules be enhanced so that they can use unregistered views? Especially for non-spatial database views, which are simpler than spatial views. Related idea: Unregister with Geodatabase GP Tool ... View more

It is my limited understanding that it's not possible to relate from a FC to a database view in a web map. Reason: relates can only be done via relationship classes, and a relationship class can't point to a database view. Could that functionality be added? This isn't my area of expertise. ... View more

ArcGIS Pro 3.3.0 As far as I can tell, the Item Description metadata style is the default style in ArcGIS Pro. That style doesn't show the item metadata (FC geoprocessing history), so many users are unaware that information exists in the metadata. I am wondering if a different style that shows the item metadata (FC geoprocessing history) would be better as the default. I don't know much about metadata, so I don't know what other style would be best for the widest audience. Maybe an ISO style. Bud_0-1715507357195.png There is a warning at the bottom of the Item Description style. But it's easy to overlook. Bud_0-1715507548118.png     ... View more