Latest Contributions by JoshuaBixby

Does your field name have a period in it?  For example, it looks like the field name is "inspection.date", which will definitely cause issues since that would make for 010085: <value> is an invalid field name.—ArcGIS Pro | Documentation Field names should only contain characters a–z, 0–9, and underscores. Do not use spaces, hyphens, parentheses, brackets, and other special characters, such as $, %, and #. Avoid using field names that contain words that are typically considered reserved keywords. These are typically data, day, month, table, text, user, when, where, year, and zone. Note that each underlying DBMS can have its own set of reserved keywords.   ... View more

With Calculate Field, there is no way to ensure row order, truly ensure it.  So, doing order-dependent row operations is kludgy at best and generally error prone.  With cursors, you can specify an ORDER BY statement to ensure row order, or you can loop through a cursor twice using a dictionary to store and update values.  If someone else doesn't offer up some code, I will take a look in a day or so. ... View more

Why does it have to be Calculate Field?  This is much more straight-forward with cursors. ... View more

Instead of manually checking it and cleaning it up, just create a scheduled task on each ArcGIS Server machine that will delete all the temp files on some regular basis.  If a temp file is actively in use and has a lock, the file won't be deleted, but everything else will be. ... View more

There are no structural changes in the URLs of GIS services between ArcGIS 10.8.x and ArcGIS 11.3, that is an existing image service that is upgraded will have the same URL as before, and a republished image service with the same name will also have the same URL as before.  Is that what you are asking? ... View more

If it is the datetime field causing the issue, then share an example or two of the datetimes from the web service and save community members the effort of having to go retrieve it themselves to help you. Retrieving the JSON, it looks like the web service is returning datetime as a string in the following format:  "2024-08-21T13:08:33.583Z".  That looks to be an ISO8601 compliant time format string, but currently the Data Access cursors cannot parse it (I have logged a defect already).  So, you are going to have to manipulate the time string into a simpler format that can be parsed. ... View more

As Chris is trying to help you tease out, there are a variety of issues that may be occurring.  Instead of trying to troubleshoot what has happened over the past 18 months, why not clear out the temp folder and then start watching it more regularly.  That way, you will have a much better idea of what is happening on ArcGIS Server around the time a bunch of temp files are created and not cleaned up. ... View more

Are they using an Esri tool or software program to query?  I am guessing not since you mention having "to provide multiple solutions for them," so how exactly are these users interacting with the REST API? ... View more

You are mixing the two patterns of use for Editor—ArcGIS Pro | Documentation.  In addition to the Esri documentation, there are lots of good primers online about the Python with statement and context managers. ... View more

If you ignore the error and hit Apply/OK, does it work correctly?  It might be a validation defect for the expression rather than an actual error in the expression. ... View more

For Arcade, use When | Logical functions | ArcGIS Arcade | Esri Developer: var regular_hours_1 = 0.18; return when( regular_hours_1 < 0.13, 0.0, regular_hours_1 < 0.38, 0.25, regular_hours_1 < 0.63, 0.5, regular_hours_1 < 0.88, 0.75, 1.0 ) ... View more

Unfortunately, the OP is using ArcMap 10.8.2, which is Python 2.x. ... View more

A few potential issues.  Firstly, why all the curly brackets?  If you are trying to use Python string formatting, you are missing calling the format function itself.   Assuming the unique_id is a number and not a string, try query = '"{}" = {}'.format(unique_id_field, unique_id) ... View more