Latest Contributions by Joshua-Young

With SQL Server the account hierarchy is the SQL Administrator account (can create databases), then the database owner account (can manage the database), and then user accounts (create, edit, or just view tables depending on permissions). Those can all be the same account but that is not the best practice. This is what I usually do in our environment using SDE schema. My admin Windows account is in the SQL admin group so it can create an enterprise geodatabase (EGDB). For simplicity, I use the Create Enterprise Geodatabase tool to create the EGDB and we use SDE owned schema instead of DBO. Create a database connection to the new EGDB using my admin Windows account (if the accounts already exists in SQL Server, I think this can just be the SDE account instead) Use the database connection in Step 2 to run the Create Database User to create an account to load the data into the EGDB. I use SQL Server Management Studio to create the "regular" user accounts and add them to the EGDB. These accounts can view or edit data but cannot modify or add feature classes or tables. You cannot use the Create Database User tool for this because it gives too many privileges. Create another database connection for the new EGDB using the data loading account Use the database connection in Step 5 to load data into the EGDB After the data is loaded into the EGDB, use the database connection in Step 5 to run the Change Privileges tool. The Change Privileges tool can process multiple feature classes and tables by default. If any of the users have the exact same privileges, you can run Change Privileges in batch mode with the User parameter as the batch parameter. You will have to run the Change Privileges tools each time different privileges are required for different users. Here is an example: John and Jane both view table 1 (Input Dataset: table 1; Users: John, Jane; View: Grant) John only views table 2 (Input Dataset: table 2; Users: John; View: Grant) Jane edits table 2 (Input Dataset: table 2; Users: Jane; View: Grant; Edit: Grant) Now your users can create database connections to the new EGDB and see what has been shared to them. This is probably a bit excessive, but I like having the separation of account duties for security and quality control. I am the only one that has access to the data loading account, and I only use that account to load and manage feature classes and tables. I do not use it for regular access or editing.

The only way that I have gotten that to work is to setup the distributed collaboration workspace as a two-way sync with the copy only turned on. Setting it up that way creates a copy in ArcGIS Enterprise and you no longer get the prompt to sign into AGOL. Then any changes you make in ArcGIS Enterprise should sync back to AGOL. That approach has its own problems unfortunately. Often the sync will start to fail with replication package errors. You will have to delete the version in ArcGIS Enterprise, remove the service from the AGOL workspace group, manually run a workspace sync, add the service back to the AGOL workspace group, and finally run one more manual workspace sync. You will lose any edits that did not sync before the errors start. The good news is the ArcGIS Enterprise copy should keep the same item name and service name, so you do not have to fix any maps or apps referencing the service. Esri does not say it anywhere in their documentation that I can find but, in my experience, distributed collaboration sync by reference is only functional with publicly shared items.

I agree with what has been said except un-sharing the archived user's content. ArcGIS Online and ArcGIS Enterprise need a separate way to archive items (Add the ability to archive items, AGO - Archive content). Archiving a user does not necessarily mean their content needs to be archived as well. Items that are not going to change could stay associated with the archived account and items that will need changes made could be transferred to a new owner with some kind of lineage of who the previous owner was. Really all that has been mentioned so far could be applied to the existing "Disabled" account classification.

We recently finished migrating from geometric networks to utility networks for water, wastewater, and storm water. We are on ArcGIS Pro 3.5 and ArcGIS Enterprise 11.5. In ArcGIS Enterprise I published view-only feature services of the utility networks that do not have editing or tracing. Those services do use subtype groups for the symbology. In Map Viewer and Experience Builder the utility network feature services render without issues, but in ArcGIS Field Maps none of those feature services will render. Field Maps is reporting ArcGIS.MappingError Invalid arcade expression: The Arcade expression requires a later version of Runtime for some of the subtype groups and other subtype groups report ArcGIS.GeodatabaseError Item already exists. I updated Field Maps to 26.2.1 and the issues remain. If I change the map to use the map services of those view-only services instead, the errors go away and the utility network data shows up in Field Maps. I am not seeing errors in the Field Maps logs even when I turn on verbose logging.

I hope that is not the case, but it is what it is. This is what I get when I try to view the bug on Esri Support. I know I will not be trying another upgrade off of 11.5 until at least a workaround, if not a patch, is posted.

Another example that comes to mind is the Special Event Operations solution from ArcGIS Solutions. We recently deployed this solution and in the solution there is one service, one map, and one app for people to edit what is happening with an event. After showing the solution to Fire, Parks, Police, and Public Works they pointed out that are different aspects that each department is responsible for and they were concerned with accidentally modifying some other departments edits. Currently, I will have to recreate the solution by making copies of the service, map, and app for each department so that each department can edit what they need to but still see what the other departments are doing for overall operational context. It would save so much time to be able to even at just the service level control edits and views for different groups and that propagates up through the map and app. Then I have just one service, map, and app to manage special event operations but different controls for the different groups accessing it.

Based on what I am seeing on Esri Community, I expect it is more of an issue with the ArcGIS Online update than the deployment of the solution. If you have not already done so, I would recommend opening a case with Esri Support for the issue so they can start working on a fix.

Did you deploy the solution to ArcGIS Online or ArcGIS Enterprise? I believe ArcGIS Online was updated just yesterday. Either way, I would try signing out and then delete the site cookie for ArcGIS Online or Enterprise and your browser cache. I have not seen those specific errors before, but it looks like something is either unavailable or is being looked for in the wrong location which old cookies or cache could cause.

@CordulaGöke in ArcGIS Pro 3.5.7 I just used model builder to select some points in a geopackage and ran the Calculate Field tool on that selection putting the results in a new field. The process was: Make Feature Layer - input was the point feature class in the geopackage Select Layer by Attribute Calculate Field - typed in a new field name to store the results I tried the Multi Values to Points tool but it would not let me use point feature class in a geopackage as the input. Doing so generated an error that the file was not supported. I tried to get around that by using Make Feature Layer first. The Multi Values to Points did run after that but failed with an error and the point feature class was deleted from the geopackage. I also tried Extract Values to Points but if I try to put the output in a geopackage it keeps appending ".shp" to the end of the output name and there is no way to remove it. Running the tool obviously generates an error. Running the Extract Values to Points tool with the input points coming from a geopackage and the results being stored in a file geodatabase works. I would recommend opening a support ticket for the Multi Values to Points and Extract Values to Points tools failing to output data to a geopackage. The Multi Values to Points tool overwrites the input points file, so if it is trying to save the new points as a shapefile inside a geopackage that would explain the table being deleted.

I think it would be helpful for group owners and managers to have a button they can click on to send an email to all members of a group. The button could be on the Members tab of the group. Clicking the button could prompt to select members to email or use the existing controls on the Members tab to select recipients. Confirming the selection then opens a blank email with the selected email addresses in the user's default email client. If I have a group with 50+ users in it and I want to let them know about an upcoming change or new resources available to the group, it would be a lot easier to do that if I could somehow extract the emails of the group members through the ArcGIS for Portal UI.

I think it would be helpful for group owners and managers to have a button they can click on to send an email to all members of a group. The button could be on the Members tab of the group. Clicking the button could prompt to select members to email or use the existing controls on the Members tab to select recipients. Confirming the selection then opens a blank email with the selected email addresses in the user's default email client. If I have a group with 50+ users in it and I want to let them know about an upcoming change or new resources available to the group, it would be a lot easier to do that if I could somehow extract the emails of the group members through the ArcGIS for Portal UI.

This is what I had to use to create a database view in SQL Server for one of my branch version feature classes to return the "parent" record. It just worked in a query layer for me. SELECT OBJECTID, SHAPE, FIELD1, FIELD2, FIELD3 FROM SCHEMA.TABLENAME WHERE FIELD1 = 'INSERTFIELDTEXTHERE' AND SCHEMA.TABLENAME.GDB_ARCHIVE_OID IN (Select MB_.GDB_ARCHIVE_OID From (SELECT GDB_ARCHIVE_OID, ROW_NUMBER() OVER (PARTITION BY OBJECTID ORDER BY gdb_from_date DESC) rn, gdb_is_delete FROM SCHEMA.TABLENAME WHERE (gdb_branch_id = 0 AND gdb_from_date <= '12.31.9999 23:59:59.000')) MB_ WHERE rn = 1 AND gdb_is_delete = '0' ) I wish I could remember who originally posted this SQL because I definitely did not figure this out on my own.

I have noticed in ArcGIS Pro 3.5.7, you can add fields and use tools that add fields when interacting with feature classes in a geopackage in the Catalog Pane or Catalog View. Interacting with a feature class in a geopackage through a Map treats the feature class as read-only (a warning is visible when trying to add a field through the Contents Pane). Currently, file geodatabases support things like datasets, attribute rules, topology, utility networks, parcel fabrics, domains, and other Esri specific functionality. I think the another difference is file geodatabases are able to compress the geometries stored and geopackages cannot. I am not sure what you mean by "full functionality", but I do not expect geopackages will support any of those Esri capabilities because the purpose of the geopackage format is interoperability between software. There are also Esri mobile geodatabases which is kind of a hybrid between file geodatabases and geopackages. They do not support everything that a file geodatabase does, but they do support most of Esri's database functionality. Mobile geodatabases are also built on SQLite but use ST_Geometry to store the spatial data. My recommendation would be to use either file geodatabases or mobile geodatabases and then export to a geopackage when you need to share the data with someone that does not have access to Esri software.

I have noticed this in ArcGIS Pro 3.5.7, you can add fields and use tools that add fields when interacting with feature classes in a Geopackage in the Catalog Pane or Catalog View. Interacting with a feature class in a Geopackage through a Map treats the feature class as read-only (a warning is visible when trying to add a field through the Contents Pane).

For SQL Server you need to use a database account in the database connection that has the CREATE SEQUENCE and ALTER OR CONTROL permissions in the database you are trying to create the sequence in. The database owner should be able to grant those permissions, but they have to be granted through something like SQL Server Management Studio. The "Create Sequence" checkbox you highlighted will create a new database sequence when the Generate ID attribute rule template is run. That sequence will have a random name, start at 1, and increment by 1. If you already have a database sequence you want to use, then you can uncheck that box. The Generate ID template is great for creating custom IDs. You can pick the prefix, suffix, padding, separators between those things, and vary things based on an attribute field.

My Ideas

Latest Contributions by Joshua-Young

Re: Migrating from 10.9.1 to 11.5 and Updating Permissions/Roles to Best Practices

Re: Distributed Collaboration Access to both Organizations

Re: When accounts are disabled, either have the ability to remove the Professional Plus license or it does not count towards your license count

The Arcade expression requires a later version of Runtime

Re: ArcGIS Data Store upgrade 11.5 to 12.1 fails

Re: Simplify AGE security model in terms of data governance

Re: Road Closure Solution Issue

Re: Road Closure Solution Issue

Re: make it possible to add fields to gpkg and use tools that add fields with gpkg

Add a way to email group members in ArcGIS Online

Add a way to email group members in ArcGIS for Portal

Re: Query Layer is returning branch version history

Re: GeoPackage (GPKG) versus File Geodatabase (GDB)

Re: make it possible to add fields to gpkg and use tools that add fields with gpkg

Re: Attribute Rule Generate ID - Create Sequence Error

Re: Distributed Collaboration Access to both Organ...

Re: Attribute Rule Generate ID - Create Sequence E...

Re: GeoPackage (GPKG) versus File Geodatabase (GDB...

Re: Road Closure Solution Issue

Add a way to email group members in ArcGIS Online

Online Status	Online
Date Last Visited	yesterday