Latest Contributions by JoshuaBixby

Features classes in mobile geodatabases have additional triggers to update spatial indexes after edits are made.  The triggers execute anytime updates are made to the feature classes, regardless of whether the spatial data is modified.  So, editing non-spatial data in a feature class will cause the trigger to execute, which will throw an error if the DLL containing the function the trigger is using isn't registered. ... View more

Josh, thanks for the update and continued work on My Esri.  Looking at the new ArcGIS Pro page under licensing, a couple of items jumped out at me.  First, why is the page titled "ArcGIS Pro Add-on Licenses and Extensions" instead of "ArcGIS Pro Licenses and Extensions"?  Second, why is the versioning showing up using ArcGIS Desktop/ArcMap instead or Pro versions? ... View more

Given the question, I assume you are running ArcGIS Server on Windows.  Historically, the path component of a URI has been case-insensitive on Windows-based web servers (IIS, Apache, etc...) because Windows itself is case-insensitive by default with file-system paths.  NTFS does support the concept of case sensitivity, but it involves some customization (see Per-directory case sensitivity and WSL | Windows Command Line (microsoft.com)).   ... View more

Regarding: Web browsers interpret URLs as all lower-case, regardless of what is typed in. What references or documentation are you using to come to this conclusion? Although rfc3986 (ietf.org) states that "scheme and host are case-insensitive and therefore should be normalized to lowercase," the scheme and host are just parts of a URI and other parts may or may not be case-sensitive.     ... View more

You provided a screenshot of a Jupyter notebook, is that the Jupyter that gets installed with Pro or do you possibly have other Python distributions on your machine that have Jupyter included too? ... View more

Most publication workflows don't involve an admin connection, although they can be done with an admin connection.  If you cannot change the connection type, it is likely your credentials don't have the level of access you are seeking. ... View more

If you only need to read file geodatabases, I recommend using https://gdal.org/drivers/vector/openfilegdb.html , it is built into GDAL. ... View more

Is this publicly-accessible data I could look at myself?  (Send me an GeoNet e-mail if yes but you don't want to post it here). ... View more

I see you have an "FID" field, I am assuming you are working with shape files.  If you consult the documentation, UpdateCursor—ArcMap | Documentation (arcgis.com) DISTINCT, ORDER BY, and ALL are only supported when working with databases. They are not supported by other data sources (such as dBASE or INFO tables). In short, my approach won't work for you because you are working with shape files. ... View more

I am not sure what is going on because the "Pro" cross-post is not redirecting to this one.  Maybe someone merged the two already. ... View more

Question cross posted:  https://community.esri.com/t5/arcmap-questions/selecting-maximum-value-based-on-other-field-using-arcpy/m-p/1072990.  @badrinathkar , I suggest deleting this one since people have started responding to the other one.  In the future, Python-related questions that are not specific to ArcMap or Pro can be asked https://community.esri.com/t5/python/ct-p/python ... View more

Questions along these lines get asked fairly regularly on the Esri Community, probably every 4-6 months.  Although it is possible to answer your question using Field Calculator, it is quite a clunky approach in my mind.  This kind of question is best suited for ArcPy cursors:   lyr = # name of layer or path to data set flds = ["ID", "AdjRiverLe", "River"] sql = "ORDER BY ID, AdjRiverLe DESC" with arcpy.da.UpdateCursor(lyr, flds, sql_clause=(None, sql)) as cur: rid, adj_river, river = next(cur) river = "YES" cur.updateRow([rid, adj_river, river]) prev_rid = rid for rid, adj_river, _ in cur: if rid == prev_rid: river = "NO" else: river = "YES" cur.updateRow([rid, adj_river, river]) prev_rid = rid   ... View more

Questions along these lines get asked fairly regularly on the Esri Community, probably every 4-6 months.  There is no singular way to solve the question, but some ways are much more efficient than others.  In your case, the approach is one of the less efficient ones, so I won't discuss your invalid SQL statement but suggest a different approach using SQL sorting.   lyr = # name of layer or path to data set flds = ["Id", "Elevation", "MaxElv"] sql = "ORDER BY Id, Elevation DESC" with arcpy.da.UpdateCursor(lyr, flds, sql_clause=(None, sql)) as cur: eid, elev, max_elev = next(cur) max_elev = elev cur.updateRow([eid, elev, max_elev]) prev_eid = eid for eid, elev, _ in cur: if eid != prev_eid: max_elev = elev cur.updateRow([eid, elev, max_elev]) prev_eid = eid   ... View more

Not surprising, the ArcPy DA module was originally written before pathlib came around.  I am guessing Esri will view this as an Enhancement Request to support pathlib. ... View more