Latest Contributions by JoshuaBixby

Regarding the first question of this post, i.e., are spatial definition queries SQL based, I think comments in this post and Spatial Definition Query — Copy parameters as text to clipboard correctly infer the answer is "no, spatial definition queries are not implemented using SQL." Often times when diving into the weeds with questions like this, it is helpful to research the ArcGIS Pro SDK | Documentation.  Looking at the DefinitionQuery Class - ArcGIS Pro, there is a GeometryUri Property (DefinitionQuery) - ArcGIS Pro: Gets the geometry uri to filter rows in the dataset. What one doesn't see when looking at the DefinitionQuery Class documentation is any property or method that would indicate the type of spatial operation to apply to the geometry obtained from the GeometryUri.  Those missing properties or methods strongly indicate there is only one way the geometry is handled, and that is intersection at this point. What one also doesn't see in the documentation is what format is used for storing the information at the GeometryUri.  Usually the property or methods for interacting with stored geometry will be include part of the format name, like "FromWKT."  It turns out the geometry at the GeometryUri is binary, which was unexpected for me.  Looking at the binary format, I am fairly certain it is Esri shape formatted binary byte buffer, essentially the same format used for shape files. ... View more