Latest Contributions by JoshuaBixby

‎05-26-2025

To be fair , adding SQL support in Calculate Field to file and mobile geodatabases is new in Pro 3.5. There is a big difference between an issue with new functionality versus functionality that is mature and been around for a while. I don't agree with how Esri is handling the update service issue, especially if it is only because of this issue.

‎05-25-2025

Stripping the test down to the most basic steps and removing IPython, I see equality checking costing quite a bit more than identity checking. C:\>python -m timeit -n 1000000 -v "value = None; value != None" raw times: 34.2 msec, 34.1 msec, 33.6 msec, 33.7 msec, 33.4 msec 1000000 loops, best of 5: 33.4 nsec per loop C:\>python -m timeit -n 1000000 -v "value = None; value is not None" raw times: 21.9 msec, 21.9 msec, 21.9 msec, 21.9 msec, 22.3 msec 1000000 loops, best of 5: 21.9 nsec per loop Granted, both equality checks and identity checks are extremely fast for Python built-in constants, so on a practical level the choice would not make a difference in the overall performance of a Python function or code block. I only mentioned performance to point out there is no performance benefit to go against best practice. I agree that PEP008 should not be followed dogmatically, but I cannot imagine a Python core developer advocating for an equality check over an identity check when it comes to a singleton. This might just be an-agree-to-disagree situation, but the discussion is good to have regardless.

‎05-24-2025

Although SQL NULL gets mapped to Python None, they are not logically identical because Python by default does not implement three-value logic. Whereas SQL logical operators in most systems support TRUE/FALSE/NULL, Python logical operators only support True/False. From 6. Expressions - Python 3.y.z documentation: In the context of Boolean operations, and also when expressions are used by control flow statements, the following values are interpreted as false: False, None, numeric zero of all types, and empty strings and containers (including strings, tuples, lists, dictionaries, sets and frozensets). The issue isn't that your logic is incorrect, or that the code is incorrect (although it may be), it is that you are trying to interpret results for Python logical expressions as if they were SQL logical expressions.

‎05-24-2025

From both a practice ( https://peps.python.org/pep-0008/ ) and performance perspective, checking for None should be done using "is" or "is not".

‎05-22-2025

For someone who has designed, configured, and managed many ArcGIS Enterprise deployments supporting upwards of tens of thousands of GIS services, using multiprocessing in a geoprocessing service comes with enormous risks to the stability of the service and the application as a whole. Depending on how the multiprocessing jobs are setup, and how the GP service is configured, it would be very easy for a single GP service to overwhelm all of the resources on an ArcGIS Enterprise deployment. Maybe this has already been thought through and discussed with the OS admins, but I mention it here as a general warning to others who might come across this thread.

‎05-22-2025

What Message Level do you have the GP service set to? If it is set to Info, the client should get all of the messages and errors back from the job.

‎05-20-2025

Although I am not a fan of the Python Requests library, I will second @EricEagle 's comment that support for PKCS#12 in general is very important. It doesn't matter how good software is today in the enterprise if it doesn't have robust support for a range of authentication and access mechanisms.

‎05-18-2025

The CIMVectorLayers are undocumented, at least from the ArcPy perspective. One can consult the ArcGIS Pro SDK documentation to read about that part of the CIM model, so I don't consider CIMVectorLayers completed undocumented. And, I have definitely used completely undocumented portions of ArcPy and other Esri APIs, so I support people sharing such solutions as long as they note the undocumented aspect of the solution. I initially marked this response as a solution; however, I found using CIMVectorLayers quite buggy when testing the approach. The behaviors were inconsistent enough that I unmark it.

‎05-16-2025

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.

‎05-16-2025

I would argue the final comment is misleading. Although the new layer is based on the data source of the original layer, and the new layer inherits symbology from the existing layer, there is no relationship between the two layers after that point. For example, if the symbology of the original layer is changed, the previously inherited symbology of the new layer does not. Also, if different records are selected from the original layer, it does not change the records that make up the new layer.

‎05-16-2025

ArcObjects? I understand what is meant, but I do think it is important to point out for readers that ArcObjects has nothing to do with ArcGIS Pro. From ArcObjects Help for .NET developers (ArcObjects .NET 10.8 SDK): ArcObjects is a library of Component Object Model (COM) components that make up the foundation of ArcGIS.... ... ArcGIS Desktop is a suite of integrated applications including ArcMap, ArcGlobe, ArcScene, and ArcCatalog. The original ArcGIS Desktop applications, i.e. ArcMap, ArcCatalog, etc..., were built on top of Microsoft Component Object Model (COM) while ArcGIS Pro is built on top of Microsoft .NET platform. Although there is an ArcObjects .NET SDK, that SDK is a effectively just a wrapper to help .NET developers interact with COM objects. What term should be used instead of "ArcObjects?" Should we say ".NET", or go with something more generic like "native code" or "compiled code?" I don't know if there is a clear winner, but I think it best to avoid using "ArcObjects."

‎05-16-2025

The spatial component of a definition query cannot be easily copied, or maybe copied at all, to the clipboard because it is stored as binary data. Also, depending on what kinds of geometries are used, the size of that binary data could be quite large.

‎05-15-2025

Although having insufficient paging space can cause memory issues, so too can having too little physical RAM. The page file and physical RAM work together, and neither one can be a complete substitute for the other. (I am dismissing the old "I have so much RAM I disabled my page file" argument because that is a terrible idea for many reasons, especially in production server environments.) There is a limit to how much of a process address space can be paged, i.e., some portion of the process address space always has to remain in physical memory. Therefore, someone can have a 10 TB page file and still crash an application or system due to too little physical memory.

‎05-14-2025

Thanks for sharing what you found. It used to just be antivirus software that could cause issues, but the breadth and depth of security software has exploded over the past decade, especially in corporate environments. Often times the big-brother software impacts performance, but occasionally it can break functionality as well.

‎05-14-2025

Although those URLs can be called externally by end-users, they are used extensively by various ArcGIS Enterprise components in any deployment. ArcGIS Enterprise isn't a piece of software, it is a system made up of many pieces of software, and those pieces are constantly communicating with each other. I doubt what you are seeing is abnormal, but if you have concerns then open an Esri Support case.

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by JoshuaBixby

Re: ArcGIS Pro 3.5: Bugs found

Re: "If not Null and not empty string" paradox - help me figure it out?

Re: "If not Null and not empty string" paradox - help me figure it out?

Re: "If not Null and not empty string" paradox - help me figure it out?

Re: Using multiprocessing in gp service

Re: Using multiprocessing in gp service

Re: Please add requests_pkcs12 to arcpy

Re: how to use displayfilter in arcpy

Re: Do spatial definition queries use SQL or ArcObjects?

Re: Display only the selected features on the map using ArcPro

Re: Do spatial definition queries use SQL or ArcObjects?

Re: Spatial Definition Query — Copy parameters as text to clipboard

Re: ArcGIS Server 11.4 CPU Usage

Re: Python - arcpy - multiprocessing

Re: get /server/rest/info/healthcheck loop

Re: What is the fastest way to add a new machine t...

Re: ArcGIS Enterprise Kubernetes / GIS Functionali...

Re: What is the fastest way to add a new machine t...

Re: What is the fastest way to add a new machine t...

Re: Is there a way to add fonts to Portal?

Python Snippets

Esri Forestry Group (EFG)