Latest Contributions by AmyRoust

I'm looking for an easy workflow that will allow an end user to maintain their data in a CSV, then upload the revisions into ArcGIS Online AND have those updates be automatically reflected in a hosted polygon feature layer. It seems to me that the following workflow should work, but it doesn't: - User creates a CSV and uploads it to ArcGIS Online as a hosted table (no spatial information beyond a county name). - User also owns a hosted polygon feature layer with county polygons and a field with the county names. - User creates a hosted feature layer join between the static county polygons and the hosted table created from the CSV. - Later, the user has changes to the data in the CSV, so they go to the hosted table, click Update and select overwrite layer, and overwrite the original data with the updated data. - After uploading the new data, the hosted feature layer's symbology automatically changes based on the newly updated values. Everything works in this workflow EXCEPT the last step. When I go back to the hosted join, no data displays on the map and I cannot open the attribute table. I have an alternative method for updating the data that involves a Python script. However, it would be a real game changer for my "not tech savvy" colleagues if they can just maintain a spreadsheet and upload the data directly into ArcGIS Online to update their maps. ... View more

I've had several use cases while using a when() or iif() function in Arcade where it would have been really nice to have the ability to match text using LIKE in the same way that it's used in SQL. My most recent use case is that I have several point locations on a map with a field holding website URLs. My client wants all URLs with a specific domain name (let's say www.esri.com as an example) to have different text for the hyperlink than all of the other URLs. So, I'd want to write a statement like this: when($feature.URL LIKE "https://www.esri.com%", "Go to Esri sponsored site", "Vendor Website") Any website that starts with https://www.esri.com would return the text "Go to Esri sponsored site" and all other sites would return Vendor Website. I can use that custom expression for the text: And use the {URL} parameter for the actual link. ... View more

This is more of a discussion question than a "help me find the right answer" question. I'm looking for others with experience using query layers in Pro. I don't use them a lot, but it's the right solution for a project currently under development. For context, I have Pro 2.8.1 installed on a Windows 10 64-bit machine. The query layers are pulling from SQL Server (currently using version 18) and I'm writing the queries on the ArcGIS Pro side rather than in SQL Server Management Studio. With regard to "buggy" issues, I've noticed several undesirable, yet inconsistent behaviors when updating a query.  - When I click the edit button to modify the query, the option to name the Query is not available. Most of the time that's not a problem. Occasionally, it will prevent me from saving my updates because I get an error message that says that the name is empty (it's not, but Pro seems to think it is). **EDITED TO ADD screenshot: - When I validate a query, it is generally quick to resolve. Sometimes, it hangs for several minutes. I've had to wait for at least 15 minutes on more than one occasion. - When I advance to the screen to set unique identifiers, I am occasionally blocked from selecting a geometry type and/or a coordinate system. Again, I've waited 15+ minutes on this screen for the "hang" to resolve itself. - After updating a query and clicking OK, the OK button on the Properties window also hangs on occasion. Again, wait times can be anywhere from seconds to 15+ minutes. The biggest problem is that I cannot replicate the behavior consistently, so calling tech support isn't going to do any good. So, I thought it might be useful to post here and see if there are others experiencing this issue and/or have identified possible causes. ... View more

When you publish a CSV as a hosted feature layer, you get a button on the item page called "Update Data" where you can load in a new CSV to overwrite the data as long as the schema matches. This option should be available for anyone with editing privileges, or at least some role below administrator. There are plenty of workflows where I might create a hosted feature layer the first time and then turn over maintenance of the data to other people. Not being able to maintain data in a CSV and then batch upload it is a big drawback. If you trust your users to edit your data, you should give them all of the tools they need to do the job. ... View more

In a hosted feature service, Editor Tracking uses the ArcGIS User Account's login name to populate the created by and edited by fields. However, if you are editing a feature service created from an Enterprise database, it uses the login name for the database. It would be preferable for Field Maps to use the AGOL account user name because the connection file used to publish services is rarely associated with a unique person.  ... View more