Latest Contributions by AmyRoust

Posting here as a last-ditch attempt to find a creative solution to my issue. I created a query layer that joins point geometry to a related table. (The relationship class is 1:M, but there is only one related record of this type associated with the point.) Symbology and labeling in the map depend on the data in the related table. I published this query layer as a view-only feature service to Portal version 11.5. No problem. Now, I need it to participate in our distributed collaboration to ArcGIS Online (as a copy, not a reference). When I Enable sync and try to publish from Pro, I get the error message "Dataset ... is not configured for or cannot be used with the Sync capability: Publishing a non-versioned dataset without archiving enabled by reference." This is logical: the system has no way to check for changes in the data without either versioning or archiving. Both the point feature class and the table have archiving enabled, but that doesn't come through in a query layer. So then I thought I'd try to use Arcade to get the information from the related table, but FeatureSet functions don't work in labeling or symbology profiles. Again, this is logical: first, the data would have to be queried, then it would have to be rendered. Translation: s-l-o-w performance. Can anyone think of another workaround that I am missing? The labeling is what really gets me - I'd really like to have a label so that the user doesn't have to click on the point to find out what is there.

‎06-25-2026

@Joshua-Young - thank you. I had to add that long WHERE clause twice - once to get the "parent" table for the point feature class and once to get the "parent" table for the table I was joining to the point feature class. But it worked and the count FINALLY matches what I expected. @tmichael_wpjwa - Thank you for that link.

‎06-25-2026

I know I'm missing something obvious. I created a query layer with a subquery to show poles that have associated records in my sign table. Because the pole feature class is branch versioned, the SQL query is returning as many as five records for a single pole because there is historical data sitting in the table. AI suggested adding the where clause GDB_IS_DELETE = 0, but still returns multiple records for the same pole. I remember a while back needing to write these queries against the _EVW table, but maybe that was traditional versioning?

‎06-11-2026

Let's take your scenario one step further: Pam Pipefixer has completed her edits in her version. She is a new employee, so her supervisor wants to review her work before it is posted to DEFAULT. Does Pam's supervisor have to be an Administrator to view her version? Or is there a way to give the supervisor access to the edits without elevating to Administrator?

‎06-11-2026

I'm searching for a user group for people who manage ArcGIS Enterprise and Cityworks integrations. I'd like to compare notes to see where other organization's pain points are and if they have found workarounds or solutions to our various issues.

‎06-11-2026

Are there any user groups or forums for people who have ArcGIS Enterprise and Cityworks? I'm looking to connect with people who are integrating these two products to discuss challenges and solutions.

‎05-26-2026

Thank you, Robert. That was exactly what I needed.

‎05-20-2026

If I need to make a change to the schema of a feature class that participates in a utility network (or trace network): 1. Do I need to disable topology first? 2. Are there any schema changes that would require recreating the utility network? Examples of what I mean by schema changes: I want to add a field to a line feature class that participates in the utility network. The field doesn't factor into any of the rules of the UN - it's just a field to track a URL to a video of the CCTV video for the asset. I want to remove a field from a line feature class that participates in the utility network. The field doesn't factor into any of the rules of the UN. It's a Notes field that we no longer need.

‎04-23-2026

The catch to this is that I have group layers in maps where the sublayers are all turned on, but the group itself is turned off. As an example, I do this with our historic registry properties, which are split into local, state, and national registries. Typically, users don't want to see them on the map, but if they activate the group, I want all of the layers to display. I like this suggestion, though. I wonder if there is a way to enable the action if the sub layer is turned off by default but not auto turn on the group if the sublayers are visible?

‎04-23-2026

On a web map's item page, if you go to Settings > Web Map, there are two checkboxes at the bottom: Use in ArcGIS Collector and Use in ArcGIS Field Maps. (The Collector option has been removed in ArcGIS Online but still exists in Enterprise 11.5) By default, every map created has Use in ArcGIS Field Maps toggled on / checked. I would like a way to change the global setting so that this is toggled off / unchecked by default. Most of the maps we create do not need to be available in Field Maps, and adding them by default creates clutter for users that have limited screen real estate. I can imagine that not everyone would want this to be off by default, so I'd like to see it as an option in Organization > Settings.

‎04-10-2026

Thanks, Ken! Worked perfectly.

‎04-10-2026

I used the code block from this Esri article to pull records from a related table: https://support.esri.com/en-us/knowledge-base/display-fields-from-a-related-table-in-the-pop-up-windo-000035545 My problem is that one of the fields in the related table has a domain assigned to it, and the Arcade code block is returning the code from the domain table instead of the description. How can I tell it to pull the description? Looking at line 10, related_data_row.field1_table of this: var related_table = FeatureSetByName($datastore, "table"); var filter_query = "field_table= '" + $feature["field_class"] + "'"; var related_data_filtered = Filter(related_table, filter_query); var related_data_filtered_count = Count(related_data_filtered); var output = ""; if (related_data_filtered_count > 0) { output = "Total of " + related_data_filtered_count + " records : "; for (var related_data_row in related_data_filtered) { output += '<br>' + related_data_row.field1_table+ " - " + related_data_row.field2_table; } } else { output = "No Related Records..."; } return { type : 'text', text : output }

‎01-09-2026

As an alternative / complement to Allow attachments table to be included in branch v... - Esri Community, I need the Delete Attachments tool to work on branch versioned data. My goal is to download attachments to a central directory, add a hyperlink to that directory so that the photos can be viewed, and then delete the attachments to dramatically reduce the size of our database and make it possible to share feature classes with significant photo collections via the distributed collaboration. At the moment, we've had to remove all photos of utility assets (e.g. hydrants, manholes, etc) as attachments because the datasets are too large to pass through the distributed collaboration. Beyond that, we strongly prefer to follow SQL Server best practices to not store files inside a database.

‎12-14-2025

For internal workflows, we have gigabytes of utility asset photos in our enterprise data. When we publish user-managed services, we do not explicitly include attachments - they come automatically. That means that if we have more than 1GB of attachments in a service, we are unable to share that service as a copy through the distributed collaboration. We do not need or want the photos to go through the collaboration because our ArcGIS Online organization is for public-facing maps and apps. My idea is to either: Create a way to publish a user-managed service with a registered enterprise geodatabase and explicitly exclude attachments from the service, or Provide a setting in the distributed collaboration that allows us to exclude attachments from copies. Ideally, this option would give the user the option to include/exclude attachments at the service level, but having that setting at the workspace level would be an acceptable alternative as long as a Portal-AGO collaboration can have more than one workspace.

‎12-11-2025

@AndrewTurner - Yes! https://geoportal-lawrenceks.hub.arcgis.com/

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by AmyRoust

Wanted: Creative Solution to Working with Related Data

Re: Query Layer is returning branch version history

Query Layer is returning branch version history

Re: Set up Connected Editing of Branch Versions in ArcGIS Field Maps

Re: GIS for Asset Management

Cityworks / ArcGIS Enterprise user groups?

Re: Utility networks, topology, and schema changes

Utility networks, topology, and schema changes

Re: Auto-enable group layer visibility when a sublayer is turned on

Provide an option to turn off "Use In Field Maps" by default

Re: Display fields with domain from another table in pop-up window

Display fields with domain from another table in pop-up window

Make Delete Attachments tool compatible with branch versioning

Allow sharing via distributed collaboration without attachments

Re: Filters - what controls display text?

Re: GIS for Asset Management

Cityworks / ArcGIS Enterprise user groups?

Re: Color Blind Color Palette - Pro

Re: Map pop-ups run off the edge of the map; Featu...

Provide an option to turn off "Use In Field Maps" ...