Latest Contributions by JoshuaBixby

‎08-29-2022

Honestly, I am not even sure if the Find or Find & Replace dialogs rely on indexes. Indexes are used by database engine software to determine optimal execution plans. In the case of the Find tool, it might just be using a cursor to iterate through records and checking field values that match.

‎08-23-2022

Although you state the system specifications when you think it last worked, you haven't told us which products and versions you are trying to work with now. Also, providing the exact error traceback is helpful too, even if the line numbers don't line up quite perfectly to sample code. Or better yet, run the sample code on your system and provide the traceback.

‎08-23-2022

Before you get too deep into trying to install it, is ArcGIS Server or ArcGIS Desktop installed on each/every machine in the HPC cluster? The ArcPy package requires an installed and licensed Esri product to work.

‎08-22-2022

Why do you want to store empty strings instead of NULL? If there is no data present for a given field and row, NULL is the common marker. I say marker instead of value because NULL indicates a value is unknown and is not a value in and of itself (this is also why checks for NULL use IS instead of equals). I think the better approach would be converting fields with either an empty string or only whitespace characters to NULL: None if !field!.strip() == '' else !field!

‎08-22-2022

Don't do what you are planning on doing! If you want the field to be NULL for records, then use Python None which is the Python mapping to SQL NULL. Writing out a text field with the same character representation that ArcGIS shows for SQL NULL will create massive confusion.

‎08-10-2022

Nice work troubleshooting so far. I can't think of an explanation Esri could offer that would not make this a defect given that you have tried several approaches and the expected results are not working for many or all. I would contact Esri Support to log a defect, although you will still need to find a workaround in the meantime.

‎08-04-2022

The situation is more nuanced because immutable and mutable Python objects are handled differently. For strings, which are immutable, var and var2 don't reference the same memory once either variable is updated while that isn't the case for lists that are mutable. Python 3.7.11 [MSC v.1927 64 bit (AMD64)] :: Anaconda, Inc. on win32 Type "help", "copyright", "credits" or "license" for more information. >>> var = "test" >>> id(var) 1966892852656 >>> var2 = var >>> id(var2) 1966892852656 >>> var2 = "hello" >>> id(var2) 1966901122480 >>> >>> var 'test' >>> var2 'hello' >>> >>> list1 = ["v1", "v2", "v3"] >>> id(list1) 1966862258632 >>> list2 = list1 >>> id(list2) 1966862258632 >>> list2.insert(0, "id") >>> id(list2) 1966862258632 >>> >>> list1 ['id', 'v1', 'v2', 'v3'] >>> list2 ['id', 'v1', 'v2', 'v3'] >>>

‎08-03-2022

Nice catch, I forgot that lists had a copy method because I never use it. list.copy() is a shallow copy like when using copy.copy(), but it is definitely cleaner.

‎08-03-2022

I understand what you mean about the different convention with field names having to be in brackets, but I re-tested using str.find() and it works as expected in a label expression.

‎08-03-2022

UPDATE: I misread the original question, so the OP is seeing the expected behavior. If you want to make a copy of a list, there are numerous ways. One common way is to use a list comprehension: Type "help", "copyright", "credits" or "license" for more information. >>> list1=["v1", "v2"," v3"] >>> list2 = [i for i in list1] >>> list2.insert(0, "id") >>> list1 ['v1', 'v2', ' v3'] >>> list2 ['id', 'v1', 'v2', ' v3'] >>> Another way is to use copy — Shallow and deep copy operations — Python 3.10.6 documentation Python 3.7.11 [MSC v.1927 64 bit (AMD64)] :: Anaconda, Inc. on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import copy >>> list1=["v1", "v2"," v3"] >>> list2 = copy.copy(list1) >>> list2.insert(0, "id") >>> list1 ['v1', 'v2', ' v3'] >>> list2 ['id', 'v1', 'v2', ' v3'] >>>

‎08-03-2022

For starters, you have some invalid code so I am not sure how you are testing. For example, >>> list2.insert[0, "id"] Traceback (most recent call last): File "<stdin>", line 1, in <module> TypeError: 'builtin_function_or_method' object is not subscriptable Changing the code to proper syntax, I get the expected results in Python 3.7.11 bundled with ArcGIS Pro 2.9.x Python 3.7.11 [MSC v.1927 64 bit (AMD64)] :: Anaconda, Inc. on win32 Type "help", "copyright", "credits" or "license" for more information. >>> list1=["v1", "v2"," v3"] >>> list2=list1 >>> list2.insert(0, "id") >>> list1 ['id', 'v1', 'v2', ' v3'] >>> list2 ['id', 'v1', 'v2', ' v3'] >>>

‎08-02-2022

Although Esri doesn't appear to state there are any limits to how many maps can be included in an ArcGIS Pro project, there are always practical limits to such functionality in any software application. So, I wanted to start a post to have folks discuss what they have found for the practical limits of maps within ArcGIS Pro projects. For example, I recently had a project where importing MXDs for map service republication from Pro resulted in 150+ maps. Most of the maps are fairly simple in terms of number of layers and symbology. The APRX file is 7MB, which I consider fairly small and manageable. There are some downsides I have run into with this number of maps. One is it does take noticeably longer than usual to open, but not having all of the maps open in the project can make the time-to-open manageable. There are also certain ArcPy functions that seem to take longer (like updateConnectionProperties) because they want to touch every map. I am interested in hearing other people's thoughts. I know there is a similar discussion to be had for layouts, but please keep your shared experiences limited to maps. Thanks.

‎08-02-2022

There is a Python str.find() method.

‎08-01-2022

I think you do understand the different ways of getting information out of them because you have provided sample code demonstrating how to extract connection properties from both. If your confusion is why these are different, I think the answer is because they were developed at different times, using different parts of Pro's underlying code, and there is no requirement that connection property information has to be returned in a single format.

‎08-01-2022

Have you read the Query (Feature Service/Layer)—ArcGIS REST APIs | ArcGIS Developers documentation? Specifically, the parts about resultType and max record count?

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by JoshuaBixby

Re: ArcGIS Pro 3.0.1: What is the benefit of indexing a feature class for a particular field?

Re: UpdateCursor not working on feature class anymore

Re: How to install Arcpy on HPC cluster?

Re: Does having "Null" spelled out serve a function?

Re: Does having "Null" spelled out serve a function?

Re: arcpy.Exists doesn't show files that do exist

Re: Python question -- List

Re: Python question -- List

Re: Python Label Expression for Arc Map

Re: Python question -- List

Re: Python question -- List

Practical Limits on Number of Maps in ArcGIS Pro Project

Re: Python Label Expression for Arc Map

Re: Workspace describe.connectionProperties vs Layer.connectionProperties

Re: 2000 rows limitation with api export json data

Re: azure, arcgis enterprise 11.5 and poor browser...

Re: New ParameterArray container

Re: New ParameterArray container

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

Re: ArcGIS Enterprise Kubernetes / GIS Functionali...

Esri Forestry Group (EFG)

Python Snippets