topic Re: Address Data Management - Only Owner Can Update RoadNameIndex domain in State & Local Government Questions

Address Data Management - Only Owner Can Update RoadNameIndex domain

JoshSaad1 — Mon, 27 Apr 2020 13:55:00 GMT

Using the new Address Data Management solution, the process for adding streets involves running a python script that imports the Full Road Names from the Master Road Name table into the RoadNameIndex domain. In an enterprise geodatabase, it seems that only the owner of the domain can update it. We've got a multi-user editing environment where multiple users will need to update the domain when adding streets.

Is there a way that each of our editors can update the RoadNameIndex domain using their own accounts?

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

JoeBorgione — Mon, 27 Apr 2020 14:04:02 GMT

That is a very good question; domains in an enterprise gdb (SDE) have always had that restriction. I haven't yet moved my address data management proof of concept out of the fdgd environment so haven't yet encountered this yet.

Perhaps Chris Fox‌ can chime in.

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

JoshSaad1 — Mon, 27 Apr 2020 14:47:58 GMT

I tried updating my map to have the Master Road Names table connect to the database using the account that owns the RoadNameIndex domain, but now I'm getting schema locks when trying to update the domain.

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

ChrisFox — Mon, 27 Apr 2020 15:19:37 GMT

Unfortunately this looks to be an oversight on our part in this Solution. I have logged an issue in our backlog to re-evaluate this aspect of the solution. This functionality isn't a requirement to make everything else work, so as a workaround for now you could just remove the domain on the roads and site addresses. You will just have to type in the road name when you create a new road, creating new site addresses should still pull the road name from the intersecting road.

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

JoshSaad1 — Tue, 28 Apr 2020 18:24:40 GMT

Thanks, I'll try that out.

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

JoeBorgione — Fri, 05 Jun 2020 14:28:11 GMT

Josh Saad‌ Take a look at : https://community.esri.com/message/933162-re-arcade-create-an-array-of-field-values?commentID=933162#comment-933162 . Xander Bakker provides me with a great Arcade Primer and Chris Fox provides what appears to be a solution for the domains issue.

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

ChrisFox — Mon, 22 Nov 2021 14:52:27 GMT

@JoshSaad1, We just released version 2.0 of the Address Data Management solution which includes several new features. We also addressed this issue by moving from a domain to a constraint rule on the roads and site addresses. As a result, updating the Master Road Names table no longer requires a schema change to update the domain. The constraint rule configured on the roads and addresses enforces that a road name entered must be defined in the Master Road Names table.

https://doc.arcgis.com/en/arcgis-solutions/latest/reference/introduction-to-address-data-management.htm

Re: Address Data Management - Only Owner Can Update RoadNameIndex domain

JoshSaad1 — Mon, 22 Nov 2021 20:48:43 GMT

Thanks so much. I look forward to testing this out.