Latest Contributions by AmyRoust

I've already got an Esri support ticket in on this, but thought I'd touch base with the hive mind... I've got a branch versioned line feature class that I regularly update with information about inspections (I'm oversimplifying here, but stick with me.) Every night, a Python script accesses the published editing service, selects the affected lines, and updates a field with the new data from the most recent inspection. Very simple, right? Select by attributes and field calc. Over time, these scripts have gotten slower and slower, to the point where what once took a few minutes now takes hours to complete. So I did a little digging. Last night, I decided to open the line feature class attribute table in SQL Server Management Studio so that I could see the hidden fields that are used by branch versioning. If you look at the feature class in Pro, there are 23,099 lines. In SSMS, there are 1,891,728 rows in the table! My theory is that using Python to batch update on Default is somehow failing to trigger the "trim" functionality built into branch versioning and that all of those edits are building up over time even though I don't see them in Pro. Has anyone else seen similar behavior?   ... View more

I'm struggling to interpret Esri's instructions for generating a pick list from a feature service for a select_one question in Survey123 Connect. I'm referencing the Search function. Here's what I'm getting from the documentation: In the choices tab, enter the list name (doesn't matter what I call it), the name (must be the field name in the feature service that I want to pull values from), and the label field (doesn't matter what I call it). Here's my config:   Then, in the survey tab, I populate the type as select_one buildingname (with the part after the select_one statement matching the list_name value in the choices tab), the name (with the name of the field in the feature service), the label (does not matter what I put here). Here's my config: Then, in the same tab, same row, I have to populate the appearance column with the search() function and the correct parameters, which are supposed to be search(tableName, searchType, searchColumn, searchText, filterColumn, filterText). I can tell that tableName is the URL of the service (including the number of the sublayer), but after that, I get hazy. Here's what I have so far: That syntax does not actually generate a drop-down menu on the survey. If I add the autocomplete parameter, I get a blank drop-down. Help?     ... View more

I have created a dashboard using data from a hosted table that is published from a Microsoft Excel spreadsheet. The user wants to be able to update the dashboard directly from the Excel spreadsheet that they maintain, which is why I went this route instead of migrating the data management into a geodatabase. Since I had to upload the Excel spreadsheet as an item before it could be published as a hosted table, that copy is still in ArcGIS Online even though I don't need it anymore. I tested updating the Excel spreadsheet's data, and it has no impact on the hosted table. But, when you look at the item page for the hosted table, it tells you clearly that it was created from the Excel file, so I'm unclear on whether that Excel file is necessary or not. What's the best practice for the Excel spreadsheet item? Do I: A. Keep the original Excel file in ArcGIS Online and do nothing with it. B. Keep the original Excel file in ArcGIS Online, and have my user update both the Excel file and the hosted table? C. Delete the original Excel file in ArcGIS Online and only update the hosted table. ... View more