If you’re using the Attribute Assistant, we need your help!

67025
239
02-23-2016 07:37 AM
MikeMillerGIS
Esri Frequent Contributor

We’re doing some research into how the Attribute Assistant is being used. We’d like to see what rules you are using and how you configured your dynamic value table. 

This information will help us plan for the future. We want to know what are the most common rules.  We also want to see your gnarly and complicated rules to see how far the Attribute Assistant is being pushed.

So please share your dynamic value table along with any comments you have in this thread. We appreciate your help on this effort!

Thanks,

Mike

ArcGIS Solutions

PS: If you don’t know what the Attribute Assistant is (or aren’t sure if you are using it already) no worries.  You can learn more about Attribute Assistant on the ArcGIS Solution site here

Tags (1)
239 Replies
GIS-Cambria
Occasional Contributor II

We've been using AA for a little while now. As a supervisor, nothing can make me happier than having a staff person successfully add new rules and tell me how much better AA has made things. For now we've focused on using AA to help with managing address points, road centerlines, site address points, fire boundaries, Master Street Names table, spatial relationships (attributes) between site address points, and parcels, Census Blocks/Tracts, USNG, zip codes, municipalities, ground elevation values from DEM, LAT/LONG values, GeneratIDs for multiple features/tables, etc... We've also recently dug into sign inventory management.

Mike has built a fantastic tool that is very under advertised and has so much potential to really help with the local government stack. I really hope the powers that be at ESRI listen to that last comment because the LG solution is great for local govt. customers. The AA, with a few more example rules, can really help set up a turn key solution for the LG stack. I'd like to see more backing from ESRI with publicizing this AND I would like to see this port over to ArcGIS Pro.

Mike, one AA rule we're working on for signs is copying linked record between the sign point and sign__attach table to fill in the sign ID (FacilityID) so we can recognize IDs that we're familiar with. We've tried the method with GLOBALID|REL_GLOBALID but that fails, however; substituting a different ID for the PK/FK relate works. Any chance you can check into this?

MikeMillerGIS
Esri Frequent Contributor

Steve,

Thanks for the kind words. I can definitely look into it, best thing is to log an issue in the local government tools github repo or log a support request. That way I have an assigned task.

0 Kudos
MikeMillerGIS
Esri Frequent Contributor
0 Kudos
GIS-Cambria
Occasional Contributor II

Awesome! Thanks. I had a fleeting thought that I was to remember to do this. So, here's the set up using the LGIM:

  • FacilitiesStreets/Sign feature with the FACILITYID column (text 20)
  • in the Sign_ATTACH table we added a column: FACILITYID (text 20)
  • We wanted copy linked record to drive the FACILITYID from Sign to Sign_ATTACH using the PK/FK of Sign.GlobalID and Attach.REL_GLOBALID

This doesn't work. But if we changed the method to fill in a different field and PK/FK on FACILITYID that we manually entered, it works. Makes me suspicious that it doesn't like to use the GlobalID.

Also, with the attachments enabled there is the relationship class in the LGIM--don't know if that affects the AA method.

DynamicValue example:

Sign__ATTACH|FACILITYID|COPY_LINKED_RECORD|Sign|FACILITYID|GlobalID|REL_GLOBALID

UPDATE:

also tried

Sign|FACILITYID|COPY_LINKED_RECORD|Sign__ATTACH|FACILITYID|REL_GLOBALID|GlobalID

0 Kudos
MikeMillerGIS
Esri Frequent Contributor

Did you try this with the 2/25/2016 version of the tools?  I did fix some globalid related issues.

0 Kudos
GIS-Cambria
Occasional Contributor II

Confirmed. AddIn was from one of the latest solution downloads, r/click on it and details properties say created 2/19/2016, just double checked; downloaded the UtilityNetworkEditing solution and checked the AddIn, same details. Opened Add-In-Manager and confirmed there too. Version 2.25.2016

0 Kudos
MikeMillerGIS
Esri Frequent Contributor

Steve,

  Are you trying to update the layer or the attachment table?  Are you trying to make the attachment table pull the ID from the layer? 

If you are trying to update the attachment table when the layer is changed, then you need to use update-linked-record

If you are trying to add the layer ID when a new attachment is attached, it looks like it will not work, as the REL_ field is empty or not set when the attachment is created.  Is does work when you trigger it manually.  I did find a bug with Copy Linked Record and global IDs that I will fix for next release.  Thanks!

0 Kudos
GIS-Cambria
Occasional Contributor II

Yes. We would like to use AA to copy a feature ID from a layer to the Attachment table when an attachment is created. Glad you found a bug to squash.

0 Kudos
MikeMillerGIS
Esri Frequent Contributor

Even with this bug I fixed, you will not be able to do that at the time the attachment is created as the related IDs are not assigned when the AA picks up the feature.

0 Kudos
Jande_Wit
Esri Contributor

Esri Netherlands uses the attribute assistant frequently. It is a core solution in one of our products, The methods we use the most are:

  • angle, for calculating the angle of a point object based on the underlining line object - for rotating the symbol
  • expression, for calculating things
  • generate id, for generating id's with a predefined prefix
  • multifield intersect, for calculating one or more values

keep up the good work, awaiting this solution throughout the whole platform, starting with ArcGIS Pro

0 Kudos