Latest Contributions by DaveSivertsen

Using the attachment viewer as part of a StoryMap webapp. Getting lots of "doesn't load" feedback from the public. On a mobile device, it is poorly integrated - you have to click an additional link to launch the separate app. But a bigger problem is the attachment viewer code is loaded from a link, rather than being part of the webapp. This makes it look like malicious code, and which results in adblockers not allowing it to load. ... View more

Just getting started with AGOL Notebooks. Working through the example for detecting broken links. It works great for resources on our AGOL site, but request() fails when attempting to access feature services provided by ArcServer 10.7.1 on an AWS platform. requests.get('https://arc.g****r.net:6443/arcgis/rest/services/OperationalLayers/PCII/FeatureServer/0', verify=False) The AWS Server is a one-off, not running webadaptor - HTTPS GIS traffic goes to port 6443. The security certificate is current and valid for the host name. Entering the URL directly in a browser loads the ArcGIS REST Services Directory page and shows it as secure.  Running python2.7 directly on a PC, this request succeeds, although it warns of an insecure request. In the AGOL Notebook setting, the request eventually fails with a timeout error. ConnectionError: HTTPSConnectionPool(host='arc.g****r.net', port=6443): Max retries exceeded with url: /arcgis/rest/services/OperationalLayers/PCII/FeatureServer/0 (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x7f3c1b51e630>: Failed to establish a new connection: [Errno 110] Connection timed out',)) Suggestions? ... View more

We would like our webapp to display 100 or so of the 20,000 items on in the feature class. At present, there are two choices. 1) Edit the filter widget, and manually checkoff the 100 features in the list of 20,000 (no!) 2) Select a few items, save the app, edit the JSON data (AGO-Assistant) and do a search and replace in 5 places to replace the selected few with the list of 100, complicated by the fact that sometimes the list members in the JSON are in single quotes and sometimes in double quotes. Simpler would be a filter widget that has an option to use an existing CSV file. Note - the list changes weekly. This could apply for an inspection of selected parcels, or many other use cases. JSON DATA example:                           "filter": {                                 "logicalOperator": "AND",                                 "parts": [                                     {                                         "fieldObj": {                                             "name": "AccessionNumber",                                             "label": "AccessionNumber",                                             "dateFormat": "",                                             "shortType": "string",                                             "type": "esriFieldTypeString"                                         },                                         "operator": "stringOperatorIsAnyOf",                                         "valueObj": {                                             "isValid": true,                                             "type": "multiple",                                             "value": [                                                 "108847",                                                 "108845",                                                 "108844",                                                 "108840"                                             ]                                         },                                         "interactiveObj": "",                                         "caseSensitive": false,                                         "displaySQL": "AccessionNumber IN ('108847','108845','108844','108840')",                                         "expr": "AccessionNumber IN ('108847','108845','108844','108840')"                                     }                                 ],                                 "expr": "AccessionNumber IN ('108847','108845','108844','108840')",                                 "displaySQL": "AccessionNumber IN ('108847','108845','108844','108840')"                             }, ... View more

AGO-Assistant has proved invaluable to my organization for updating service URLs. Unfortunately, although admin, I can only update my own services and maps. This means the workflow for service URL updates within the organization  requires taking ownership, modifying, and returning each item in the organization, or explaining to each publisher how to use AGO-Assistant on their own maps to update and which services are affected. It would be ideal if AGO-Assistant could recognize admin status within an organization, and allow display, search and update functions throughout the organization. ... View more

Removal of attachments - python. The typical suggestion for scripted attachment removal is to use  arcpy.RemoveAttachments_management(), and operate on the base feature class, generate a match table (.csv), etc. to remove attachments from the table Is there any reason (underlying database issues) that you can't simply remove rows directly from the attachment table using arcpy.da.UpdateCursor? This would seem more direct and faster, and might also bypass the versioned data attachment removal issues discussed 2012-2017 for python and GP tools - am I missing something? Thanks ref: Remove Attachments not working on data in SDE, gives warning "Cannot remove attachments for OID = &lt;oid here&gt;"  ref: Cannot add/remove attachments in python when table/featureclass is versioned  ... View more

Need ability for realtime python script to perform field calculations on multiple fields in a record when that record is new or updated. Looking for equivalence to SQL triggers or form departure actions - Example - a feature field for a utility pole such as "Serial number" is added/updated in the field from a asset tag. This would trigger a script to fill in other fields for that record. Currently I do this with a nightly script. Realtime updates would allow the field worker to enter a tag number and submit the record, and view results to help confirm accurate entry of "Serial number".  Field data entry  (Collector with a touch screen in the sunlight) is prone to error. If the realtime "serial number" field calc returned a "material type" =Steel, and it was a wooden pole, it would let the field worker see that the "Serial number" was incorrectly entered.  Using a prepopulated related table does not work, since entries may be deleted or keys nulled by edits of the feature class.  ... View more

Field entry of data can be problematic - touch screen, sunlight, incomplete data, typos. In many cases it may consist of entering a serial number from an equipment tag, and equipment mfg, type, size, etc..  Ideally, one would enter a serial number, and the other fields would autofill, allowing immediate verification that the tag number was entered correctly, avoiding the need to type the rest of the information, and ensuring consistent values. In a database, a trigger can be set to do this on departure from the entry field; ArcGIS manages database operations, so this method is not available. It can be scripted as a scheduled task, using a "lookup table" and the serial number. "Lookup" is quoted - I am using it in the general software sense - a non-changing prepopulated dictionary - and not the specific ESRI raster usage. This results in two problems - since a trigger is not available, field personnel don't get the immediate autofill that would allow them to verify the entry. The second problem is that the closest approximation to this technique is using a related table to store the "lookup" data. This is problematic, as deletion of a serial number (primary key) will result in a null key or record deletion in the related table. I would like to either have access to database triggers to run a script on changing a particular field, or the ability to have a "related" table that does not delete the key values or records - essentially a write-protected related table. ... View more