Latest Contributions by AJR

There is a build on github for VS2019, but that seems to be the latest.  Is there a plan for when the VS2022 build will be released? https://github.com/Esri/file-geodatabase-api/tree/master/FileGDB_API_1.5.2 ... View more

As @MarceloMarques mentioned, both geometry types are supported within ArcGIS and should function equivalently within ArcGIS.  The pros/cons really come down to if you need to access the data outside of ArcGIS.  Many third party tools can read/write SDO, but generally only the esri tools can read/write ST_Geometry.  So if you have external systems that will be pushing data in to your oracle database and don't want to have to have additional libraries registered on your server and/or modifying client code to read/write st_geometries, then SDO geometry is the way to go.  For almost all other use cases (i.e. ones where you aren't pushing data into or pulling data out of the database using sql tools) you'll probably want to use st_geometry.  The grid indexing scheme (wrapped up as the domain index on your spatial column) is generally faster than the relational indexing scheme from oracle (based on my experience) especially for line and polygon data. ... View more

What dashboard are you referring to?  ArcGIS Monitor? An Oracle tool? Something else? ... View more

There isn't an arcade function to count the number of vertices in a shape - https://developers.arcgis.com/arcade/function-reference/geometry_functions/ using Count(Text(Geometry($feature))) returns a result when used in the field calculator (null shapes are returned as empty strings), but trying to use Count(Text(Geometry($feature))) > 0 as a null shape filter fails when used as part of an attribute rule (i.e. null shapes pass the check) ... View more

This bug also manifests itself if you try to use an arcade expression to operate on the shape and some of the shapes are null.  There doesn't seem to be any way in arcade to detect if the shape is null before attempting to use it (i.e. intersect it with another feature class).  I'm curious when/if this bug is on the timeline for getting fixed. ... View more

You could build a db view using the select statement by just putting it into a create view statement, something like create view your_new_view_name as select .....   However, the view is then a static pointer to the domain and subtype values as they existed at the time of creation of the view.  If you ever change any of the domain values or modify the subtypes, you'll need to drop and re-create the view using an updated sql statement.   You could also use the returned select statement to pass into the Create Database View GP tool and that would achieve the same result as doing it via. sql. ... View more

I'm glad to see that this idea is now under consideration.  Slightly less glad that it is 10 YEARS after I posted it, but better late than never I suppose. ... View more

They return mostly the same information.  For example, arcpy.da.describe doesn't return the connection properties (i.e. server, database, etc.) for an sde workspace object.  They may be brought into parity at some point in the future. ... View more

@MErikReedAugusta- there are many use cases where null shapes are needed (i.e. integration with non-GIS systems where the spatial portion of the record is updated after initial insert by a non-spatial system).  Better display/handling in the ArcGIS Pro UI along the lines of what @Bud mentions would be very helpful. ... View more

At the 2019 developer conference (maybe the first one after attribute rules were announced/rolled out????) I was in a session that covered using an attribute rule to populate an attribute using a spatial query against another feature class in the same geodatabase (which it should be noted is super useful and way better than the home-baked options we were limited to in the past).  At that time the presenter mentioned that only queries within the same geodatabase were currently supported, but accessing other geodatabases (on your LAN) and accessing web services were things that they were working on.  I guess it takes more folks upvoting threads like this one to make that happen since that functionality hasn't been released yet. ... View more

This also applies to reading data from an enterprise geodatabase table that's being updated by some other user.  In ArcMap you could see those changes by clicking the reload cache menu, but in ArcGIS Pro you have to completely close the table and re-open it (way more clicks/hassle than it was in ArcMap).  Note, as of AGP 3.2 this is still a problem. ... View more

The attached python toolbox might help.  It contains tools to decode domain values using SQL.  The tool is currently SQL Server specific, but could be modified for other db platforms.  Basically, it just builds a big SQL statement with a bunch of case statements in it which translate the domain values to human readable text for use in a view.  There are two tools which use the same backend code.  The first just returns the sql select statement as a string (useful if you are building this into a larger model or tool) and the second uses the select statement to return a query layer.  You can always go back and examine the sql via. the source for the feature layer if needed.  The code works with layers that are subtyped as well as those that aren't. ... View more