nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automate attribution update?

RobRees

Hi guys,

I have a project I am working on which involves me snapping one set of nodes to another set, one by one.

Once this is done I need to update 2 blank fields in one node. One involves copying the item number from one node to the other. And the other update involves inserting a number into a blank field to indicate the node has been paired.

I wondered if there is a way to automate this? i presume this would involve some Python scripting which I am fairly new to, so any simplified advice would be appreciated.

Thanks

Ray

Trouver plus de publications taguées avec

Accepted answers

All comments

RichardFairhurst

Unfortunately VB Script cannot be used to get a map document title or anything else from the map document. That used to be possible when ArcMap supported VBA, which could use ArcObjects to access those properties, but all ArcObjects code was dropped once VB Script became the basis of the field calculator. Now only Python can be used to do anything related to mapping or Add Ins/Extensions built using Visual Studio and .Net/ArcObjects.

You could try building a Python Add In Editor Extension which could listen for edit events and attempt to trigger the update with your calculation code, but the Python Editor Extension Add In does not really work well and is very limited and frustrating to work with, and the .Net Editor Extension is much better. The Python Add In Editor Extension is essentially unusable if you edit in SDE, it is really only somewhat OK if you edit shapefiles/fgdb/personal gdb data. Edits triggered by the Python Editor Extension cannot be undone by the user and the user either has to save all edits or stop the Edit session and lose all edits.

Anyway, you have to give up on Attribute Assistant for the functionality you want. It is simply incapable of doing this.

PriscillaCole

Richard - I love all of your good advice on this thread. It's been helpful to think of VB expressions in the dynamic value table like those in the field calculator.

I've got a problem that I'm hoping you could help me with. I'd like to use attribute assistant to populate fields according to the properties of the map document. The arcpy mapping module opens these properties up nicely, but I have no idea how to accomplish the same with visual basic. Ideally, I'd like to access the map title, but I'd also settle for the mxd name or version name. Below, I used a python function in the field calculator to accomplish what I want by pulling the map title.

How can I get this same logic into the dynamic value table?

RobRees

Hi Richard,

Hope you are well.

Just wanted to ask you another question as you were so helpful before. I know this is not the right place to ask (tried to pm you but this is restricted unless we're connected).

In the office I keep hearing about data being event loaded into arcgis. I presume this is simply plotting geospatial data in arcmap? Similar to loading an excel table and plotting xy data?

Is there an event loading tool?

I wanted to look into it as it seems a lot of data that is event loaded is failing to display within arcmap and they are not sure why...

So I wondered if you could explain to me about event loading and how I would go about event loading data myself?

Thanks,

Ray

RobRees

Hi Richard,

Thought I'd let you know that I managed to get th attribute assistant to work in arcgis10.0.

I found if you omit the third option from value option and just use table and field it worked.

Also if you try to run it manually on selected features it didn't seem to work but worked with 'on change'.

Thanks for amending the expression. I used a similar expression and worked perfectly.

Thanks again for the clearly explained info, it has helped a great

RichardFairhurst

Yes there was a missing parenthesis at the end of the Value Info expression. I have corrected the error in my post.

RobRees

Hi Richard, trying to get the expression to work.. is there a parentheses missing in the code?

Thanks,

Rob

RichardFairhurst

I wonder if somehow the geodatabases have been upgraded to 10.1 version and that is affecting Attribute Assistant, although I would have thought that would cause them to fail to draw in a 10.0 map. To test if Attribute Assistant is the problem I would create a new 10.0 geodatabase and two FCs with the same schema and names and run the rule on them to see if the error still occurs.

It looks like Attribute Assistant was very new with 10.0, since it is not mentioned in the help and a blog was written by the Esri developers asking for user feedback on how it was being used. The link in that blog to the Attribute Assistant site now says only versions 10.1 and up are supported.

RobRees

Hello Richard,

Thanks for the link. That does work and I have installed it with my version of arcgis 10.0.

For some reason though attribute assistant posts an error message saying 'no editable layers from selected features' when trying to run the attribution update on selected nodes.

Not sure why this is as it worked fine with the current version of attribute assistant and arcgis 10.4.

Maybe INTERSECTING_FEATURE is not supported on the earlier version of attribute assistant.

I will try and investigate more today.

Thanks Richard.

RichardFairhurst

It looks like you can get a download of the 10.0 version here: http://www.arcgis.com/home/item.html?id=e35580f27bce4782b95ea8296ac60927

Let me know if that link has what you need.

RobRees

Hi Richard,

Thanks again for a detailed reply. I am going to try and implement this tonight.

I had one other question for you..

Is there a way to get attribute assistant to work on version 10.0 ArcGIS? I have been using it successfully on higher versions(on a different laptop) but now I am stuck with version 10.0 and not able to upgrade.

Thanks,

Ray.

RichardFairhurst

I would use the EXPRESSION method, which can verify that the Node_ID field is not NULL before changing the other field to 1.

The Expression record in the Dynamic Table must have been inserted after the record that intersects the node for this to work and the Rule Weight must be Equal To or Greater Than the value for the Rule Weight of the Node Intersect rule.

OBJECTID *	Table Name	Field Name	Value Method	Value Info	On Create	On Change (Attribute)	On Change (Geometry)	Manual Only	Rule Weight	Comments
193	CENTERLINE	CITY_LEFT	EXPRESSION	IIF(IsNull([NODE_ID]),[CITY_LEFT],1)	False	False	False	True	1	<Null>

In the rule above, the expression determines if a field named NODE_ID is Null. If NODE_ID is Null it does not change the CITY_LEFT value (it sets the value of CITY_LEFT to itself so that it retains is current value), otherwise it sets CITY_LEFT to 1

Edit 3/24/2016 - Added missing end parenthesis to Value Info expression.

RobRees

Hi Richard, Intersecting_feature works perfectly, thank you.

I was trying to do the second part which involves updating another field to the value of 1 to indicate the nodes have been paired.

I entered another record into the dynamic value table to do this and tried using Field_Trigger but the field did not seem to get updated.

Is there a different method I should be using?

I have been running the attribute assistant manually, so once I have selected several nodes I run the attribute assistant, which now copies the field from the snapped node into this node, but now I need another filed to be updated to 1.

Any advice would be appreciated.

Thanks,

Ray.

RobRees

Hi Darren,

Yes I may look into spatial join after i have managed to get attribute assistant working.

The reason i didnt use spatial join is that the table ares amended in microsoft access after I have moved the nodes to the correct position and updated attribution.

Creating a spatial join would create a new merged table, so now we would have three tables? I do not currently have control over the data after I have edited it so it maybe something i could pursue in the future.

Thanks.

RobRees

Hi Richard,

Thank you for the detailed reply, it was very helpful. I actually spent some more time on it after my previous post and was heading in this direction, thankyou for confirming. I will hopefully get this set up soon and will let you know how I get on.

Thanks again.

DarrenWiens2

Once this is done I need to update 2 blank fields in one node. One involves copying the item number from one node to the other. And the other update involves inserting a number into a blank field to indicate the node has been paired.

Since you're doing this after you've completed your editing, I'm not sure why Spatial Join, which will transfer all the attributes from the old nodes to the intersecting/nearest (?) new nodes, wouldn't take care of this for you.

RichardFairhurst

Here is an example of an INTERSECTING_FEATURE record in the DynamicValue table:

OBJECTID *	Table Name	Field Name	Value Method	Value Info	On Create	On Change (Attribute)	On Change (Geometry)	Manual Only	Rule Weight	Comments
193	CENTERLINE	CITY_LEFT	INTERSECTING_FEATURE	ZIP_CODES_WITH_CITIES\|CITY\|C	True	False	True	False	1	<Null>

Table Name is the target layer with the field that needs to be completed by another intersecting layer

Field Name is the field name in the target layer

Value Method is INTERSECTING_FEATURE (any one of the Attribute Assistant methods)

Value Info is made up of 3 components separated by a | character. The components are: Intersecting source Feature Class Name|Field Name in the source Feature Class|C(Centroid match) (alternatively I could have used P for Prompt for an option or F for using the first feature intersected)

On Create is set to True so that the moment the feature creation is finished the attribute will be updated.

On Change (Attribute) is set to False, since it doesn't need to refresh due to an attribute change.

On Change (Geometry) is set to True so that any change in geometry refreshes the attribute (the intersecting feature should have been fixed first before the target feature geometry changes).

Manual Only is false, but it could be true if I want to use the Attribute Assistant toolbar to force a refresh

Rule Wieght is optional but I ususally set it to 1

Comments provides any explanation of the purpose or use of the rule.

An Expression update does needs to have its Value Info written the same way you would write a VB Script field calculation. Use the field calculator to test your expressions and ask for help here if you have problems with a specific equation.

RobRees

Hi Richard,

I have added the attribute assistant to my mxd and was about to setup the dynamic table... But Im unsure how to create the Value Method to copy one field from another layer to the field in this layer? This requires knowledge of visual basic syntax?

I cant seem to find much on this when googling so any help would be appreciated.

Thanks,

Ray.

RobRees

OK thanks for your help Richard, I'll try and download it tonight. Once I have tried it out I'll let you know how I get on.

Thanks again.

RichardFairhurst

I downloaded the Address Data Management templates for the Local Government Information Model, since my main dataset deals with roads. However, it doesn't really matter which one you pick as far as the Attribute Assistant toolbar, since that will come with any of the templates and you would be customizing it for your specific needs anyway. So just download any of the LGIM templates to start.

RobRees

Thanks Richard,

Do you know which download I require? It is not a standalone download, there are several options.. I'm not sure which I should be using.

Thanks,

Ray.

RichardFairhurst

It will work. One of the bug fixes mentions that it was specifically done to make one of the Attribute Assistant dialogs work correctly for a personal geodatabase.

RobRees

Thanks for the reply, will this work with data from a personal geodatabase?

RichardFairhurst

Using Attribute Assistant is the only automation that happens as soon as you edit a feature. It has an an Intersecting_Feature method (or a few other options) for filling in the first field and an Equation or GenerateID method to fill in the second field.

WesMiller

You could use model builder to do it. The tools you'll need are listed below.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.