Latest Contributions by JoshuaBixby

I did a quick test using nested dicts instead of tuples in a dict, and it ran about 3x faster than my code.  But, then I refactored my tuple-in-dict code to cut out the max() function and use an if to compare the first value only, and it ran a bit faster than nested dicts.  I have some ideas why the max() function is noticeably slower, but regardless the cursor will be the slowest part of the code by an order of magnitude or more. ... View more

Are the values exactly the same between the dictionary key and the field in the table?  If there is extra text with the value in the field in the table, including any spaces, the match won't happen.  Also, does capitalization match?  It would help to provide sample data. ... View more

David, some Python-related thoughts on your code: Python defaultdict removes the need to check for a keys existence before comparing a key's value to a new value. Python min and max functions are purpose-built for comparing values and selecting the lowest or highest Tuple/list unpacking can be done in the for loop, a separate line isn't needed. Generator expressions were partially introduced to reduce the need to use filter() and map(), whose functional-programming style/nature somewhat contrasts with many other aspects of the Python language. import arcpy import datetime from collections import defaultdict # input feature class in_fc = r'C:\path to your FC' # default dictionary to store objectid of newest sighting date for each species date_dict = defaultdict(lambda: (datetime.datetime.min, -1)) # cursor to iterate through each row in fc # store the maximum (most recent) date for each species and its ObjectID with arcpy.da.SearchCursor(in_fc, ['OBJECTID', 'your species field', 'your date field']) as cursor: for oid, species, date in cursor: date_dict[species] = max(date_dict[species], (date, oid)) # create sql statement for selecting ObjectIDs sql = f"OBJECTID IN ({','.join(str(oid) for date,oid in date_dict.values())})" # turn into feature layer for selection feature_layer = arcpy.MakeFeatureLayer_management(in_fc, "feature_layer") # select by attributes using oid list/string selection = arcpy.management.SelectLayerByAttribute(feature_layer, "NEW_SELECTION", f'OBJECTID IN {selection_string}') # save your new fc out_fc = r'C:\path to new fc output' arcpy.CopyFeatures_management(selection, out_fc)   ... View more

Another approach would be to use regular expressions.  Although regular expressions might be a bit overkill for this specific situation, they are much more flexible to handle more complex situations: with arcpy.da.UpdateCursor(table1,'STREET') as cursor: for row in cursor: row[0] = re.sub(r"^((?:N|S|E|W|North|South|East|West) )+", "", row[0]) cursor.updateRow(row) del cursor The above will result in "N South 5th Street" becoming "5th Street".  If you don't want double prefixes to be removed, just take the "+" out of the regular expression pattern. ... View more

As fun as code golf can be, list comprehensions were proposed and accepted "to create lists" (PEP 202 – List Comprehensions | peps.python.org).  I think many would argue that using a list comprehension to perform a mapping function isn't very Pythonic. ... View more

This won't really be possible because a layer knows what ObjectIDs are selected, but it doesn't know how they were selected.  There are numerous ways to select records, and what is exported in the LYRX or MAPX files are binary references to those ObjectIDs and not references to the tools or methods used to select the records. ... View more

I submitted feedback either last week or earlier this week about it already.  My experience with submitting feedback on documentation through the web pages is that I get better resolution than submitting a documentation defect with Esri Support.  Neither approach results in 100% resolution, not to mention timeliness, but somewhere between 2/3 and 3/4 of my comments get addressed eventually. ... View more

That documentation has an error, one way or the other.  If you copy and paste a bit more of that section:   File-based data, including file geodatabases, shapefiles, in-memory table views, text files such as .dbf, .csv, .txt, .xlsx tables, and feature services that use standardized queries use the ArcGIS SQL dialect that supports a subset of SQL capabilities. Mobile geodatabases, ST_geometry SQLite, GeoPackage, and Excel use SQLite SQL dialect.   The first bullet point says "xlsx tables" use standardized queries, while the second bullet says "Excel use SQLite SQL dialect."  Which one is right?  ... View more

ArcGIS Enterprise on Kubernetes is a completely different product that was introduced at ArcGIS 10.9.  The functionality of ArcGIS Server and ArcGIS Enterprise is being completely reimplemented to run natively in containers, so "ArcGIS Enterprise" and "ArcGIS Enterprise on Kubernetes" are not the same product.  There has never been an "ArcGIS Server" product for Kubernetes, so this really isn't a licensing issue. ... View more

If you are having to regularly restart all ArcGIS Enterprise components in your deployment, then something is definitely not right with the deployment.  If one component is acting up or has to be restarted, that does not mean all components should be restarted. ... View more

Domain logins to ArcGIS Server have to be "mydomain\user" format and not "user/mydomain" format.  What documentation is saying to structure your login that way? ... View more

This is better addressed with Esri Support since community members aren't able to do a call/meeting with you and possibly a screenshare to see what is going on.  I use to run ArcGIS 10.9.1 on Windows Server 2019, and I regularly had several ArcGIS Web Adaptors on the same machine; so I suspect it is something workflow related or environment specific on your end, both of which more information is needed. ... View more