Attribute Assistant methods

The Value Method field in the DynamicValue table defines the actions that occur when the Attribute Assistant is enabled and features are modified or created in ArcMap. Four fields in the DynamicValue table (Value Method, Table Name, Field Name, and Value Info) must be configured to use an Attribute Assistant method. The remaining fields define when the Attribute Assistant method should be applied.

The following 71 Attribute Assistant methods can be configured in your DynamicValue table:

Method Description
Angle Calculates the geographic or arithmetic angle of a line feature.
Autonumber Finds the largest value in a field and calculates the next sequential value.
Cascade Attributes Updates all occurrences of a value when the corresponding value in another table is changed.
Copy Features Copies a feature when an attribute is updated to a specified value.
Copy Linked Record Updates an attribute of a feature with a value from a related table.
Create Linked Record Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.
Create Perpendicular Line Constructs a perpendicular line from the input point and an intersecting line. The line's length is specified by the Length parameter.
Create Perpendicular Line to Line Constructs a perpendicular line from the input point to the nearest line.
Current Username Populates the current user name.
Edge Statistics Provides statistics on a specified field for all connected edges in a geometric network.
Expression Executes a VBScript evaluated by the MSScriptControl. Can be used to access built-in functions and conditional logic (if statements).
Feature Statistics Summarizes the attribute values of the affected feature as a series of statistics or a single calculated value.
Field Copies the value from from one field to another within the same feature class.
Field Trigger Updates a field to a specified value when the value of another field is updated.
From Edge Field Copies a field value from a connected From Edge feature to a connected junction feature.
From Edge Multiple Field Intersection Copies values for all From Edges connected to a junction to a series of fields in the source layer.
From Edge Statistics Calculates statistics on a specified field for all features connected to From Edges in a geometric network.
From Junction Field Copies a field value from a connected From Junction feature to a connected edge feature. Can also copy the name of the feature class at the start of the currently edited line.
Generate ID Increments a row in an unversioned table and stores that newly incremented value.
Generate ID By Intersect Generates unique identifiers for features based on the identifiers of intersecting grid features.
Get Address From Centerline Extracts address information from the closest point on a road. It is similar to a reverse geocode, but a locator service is not used.
Get Address Using ArcGIS Service Performs a reverse geocode using a specified ArcGIS service.
Get Address Using Geocoder Performs a reverse geocode using a geocoder.
GUID Creates a globally unique identifier (GUID).
Intersecting Boolean Stores a value if the triggering feature intersects a feature in the specified layer.
Intersecting Count Calculates the number of intersecting features and stores the count in the specified field.
Intersecting Edge Copies a field value from the first intersecting edge feature.
Intersecting Feature Copies a value from an intersecting feature in the specified layer.
Intersecting Feature Distance Calculates the distance along a line feature where a line is intersected by another feature.
Intersecting Layer Details Extracts the name or file path of an intersecting layer.
Intersecting Raster Extracts a raster cell value at a feature location. If the feature is a line or polygon, the raster value at the feature centroid is used.
Intersecting Statistics Calculates statistics on a specified field for intersecting features.
Junction Rotation Stores the rotation angle of a junction feature based on connected edge features.
Last Value Repeats the last value used in a field.
Latitude Stores the y-coordinate value projected to WGS84 decimal degrees.
Length Calculates the length of line features and the area of polygon features.
Link Table Asset Updates a field in the table or layer with a value from a selected feature.
Longitude Stores the x-coordinate value projected to WGS84 decimal degrees.
Map Info Stores information from the current map document metadata or the version info of the layer being edited.
Minimum Length Rejects a newly created line feature if the length of the line is less than the specified distance.
Multiple Field Intersecting Values Copies values from new intersecting features into a target layer.
Nearest Feature Copies a value from the nearest feature in a specified layer.
Nearest Feature Attributes Copies a series of values from the nearest feature in a specified layer.
Offset Populates the location of a point a specified distance from the nearest line feature.
Previous Value Monitors a field, and when it is changed, stores the previous value in another field.
Prompt Identifies records containing null values. If the field uses a subtype or domain, those options are presented in the dialog box for the user to select.
Set Measures Populates the m-coordinates of line features. M-values can be used to add route events to point and line events dynamically along line features.
Side Determines if a point feature is to the left or right of a corresponding line feature.
Split Intersecting Feature Splits features that intersect with features in a source layer.
Timestamp Populates the current date and time.
To Edge Field Copies a field value from a connected To Edge feature to a connected junction feature.
To Edge Multiple Field Intersect Copies values for all To Edges connected to a junction to a series of fields in the source layer.
To Edge Statistics Calculates statistics on a specified field for all features connected to To Edges in a geometric network.
To Junction Field Copies a value from a connected To Junction feature to a connected edge feature. Can also copy the name of the feature class at the end of the currently edited line.
Trigger Attribute Assistant Event From Edge Triggers the Attribute Assistant for the From Edge feature.
Trigger Attribute Assistant Event From Junction Triggers the Attribute Assistant for the From Junction feature.
Trigger Attribute Assistant Event Intersecting Feature Triggers the Attribute Assistant for the intersecting features.
Trigger Attribute Assistant Event To Edge Triggers the Attribute Assistant for the To Edge feature.
Trigger Attribute Assistant Event To Junction Triggers the Attribute Assistant for the To Junction feature.
Update From Edge Field Copies a field value from a junction to a connected From Edge feature.
Update From Junction Field Copies a field value from a connected edge to a connected From Junction feature.
Update Intersecting Feature Updates a field in an intersecting feature with a value or a field value from the modified or created feature.
Update Linked Record Finds the related records in another table or layer and updates a field in those records.
Update To Edge Field Copies a field value from a junction to a connected To Edge feature.
Update To Junction Field Copies a field value from a connected edge to a connected To Junction feature.
Validate Attribute Lookup Verifies field values against entries in a lookup table.
Validate Attributes Compares values in the input fields to all feature templates for the feature class.
Validate Connectivity Validates the number of connections on a feature and rejects the edits if the criteria are not met.
Validate Domain Validates data entry on field with domains against the domain. If the value is outside the range or not in the coded value list, the edit is aborted.
X Coordinate Calculates the x-coordinate of a feature in database units.
Y Coordinate Calculates the y-coordinate of a feature in database units.

Angle

Calculates the geographic or arithmetic angle of a line feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class name Field used to store the calculated angle ANGLE {Angle Type}

This rule can only be configured on linear features, and the angle value must be populated in Float or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Angle Type (Optional) A Populates arithmetic angle (counter-clockwise from positive X axis).
G (Default) Populates geographic angle (clockwise from positive Y axis).

Examples

Populates the BREAK field in the wMain layer with the angle between the line and due north:

  • Table Name: wMain
  • Field Name: BREAK
  • Value Info: <Null>

Populates with the angle between the line and due east:

  • Table Name: wMain
  • Field Name: BREAK
  • Value Info: A


Autonumber

Finds the largest value in a field and calculates the next sequential value.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or Feature class Field to autonumber AUTONUMBER Null or Blank

This rule can only be configured on an Integer field.

Parameters

There are no parameters for this method.

Examples

Populates the ASSETNUM field in wMain with the largest value incremented by one:

  • Table Name: wMain
  • Field Name: ASSETNUM
  • Value Info: <Null>


Cascade Attributes

Updates all occurrences of a value when the corresponding value in another table is changed.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class containing the field to monitor for changes Field triggering the cascading attributes CASCADE_ATTRIBUTE Input|Trigger|{Prompt}

Parameters

The method parameters are as follows:

Parameter Value Description
Input Table, layer, or feature class Table or feature layer containing the field affected by the cascading updates.
Trigger Field name Field affected by the cascading updates.
Prompt (Optional) Blank (Default) Display prompt to confirm the cascading update.
False Prompt will not display.

Examples

Monitors the FULLNAME field in the MasterStreetName table for changes; when this value is changed, copy this value to all features in the RoadCenterline layer whose STNAME field value is equal to the original FULLNAME field value. A dialog box will be displayed before the values are copied:

  • Table Name: MasterStreetName
  • Field Name: FULLNAME
  • Value Info: RoadCenterline|STNAME

Copies the field value without asking for confirmation:

  • Table Name: MasterStreetName
  • Field Name: FULLNAME
  • Value Info: RoadCenterline|STNAME|False


Copy Features

Copies a feature when an attribute is updated to a specified value.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class from which features will be copied Field to monitor for changes COPY_FEATURE Value|Target|{Template}|{Method}|{Field Pairs}

Parameters

The method parameters are as follows:

Parameter Value Description
Value String or numeric value Rule is triggered when this value is entered into the field of interest.
Target Feature layer or feature class Affected features are copied or moved to this feature layer.
Template (Optional) Editing template Editing template used to symbolize and attribute the copied or moved feature. The feature symbology will be updated when the edits are saved.
Method (Optional) Copy Copies features from original location to the target location, but does not delete original feature. Deleting or moving the feature is not supported.
Field Pairs (Optional) String Field map for transferring attribute values between the source and target features. Format: Source field-target field.

Examples

Copies the current feature from the MasterStreets layer into the PropStreets layer when the STATUS field value is changed to Proposed:

  • Table Name: MasterStreets
  • Field Name: STATUS
  • Value Info: Proposed|PropStreets

Copies the current feature from the wMain layer into the wAbandonedLine layer when the STATUS field value is changed to 0 (retired). When copying, the Abandoned Water Mains editing template is used for attributes and symbology. Map the source fields DIAMETER and MAT to DIAM and MATERIAL, respectively:

  • Table Name: wMain
  • Field Name: STATUS
  • Value Info: 0|wAbandonedLine|Abandoned Water Mains|COPY|DIAMETER-DIAM,MAT-MATERIAL


Copy Linked Record

Updates an attribute of a feature with a value from a related table.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class to which value will be copied to from the source or related table Field to store the copied value COPY_LINKED_RECORD Source|Source Field|Primary Key|Foreign Key

Parameters

The method parameters are as follows:

Parameter Value Description
Source Table Related table that a value will be copied from and placed in the triggering layer
Source Field Field name Source table field containing the values to copy and place in the triggering field
Primary Key Field name Field in the Triggering layer that is used to identify a feature in the source or related table
Foreign Key Field name Field in the source table with a matching ID to the triggering layers ID in the Primary Key field
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Populates the ADDRESS field in the Parcels layer with the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:

  • Table Name: Parcels
  • Field Name: ADDRESS
  • Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID


Create Linked Record

Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to monitor for changes (Optional) CREATE_LINKED_RECORD Target|Target Fields|Source Fields|Primary Key|Foreign Key|{Commit}

Parameters

The method parameters are as follows:

Parameter Value Description
Target Table or feature layer Related table
Target Fields Field names List of fields the related record layer/table to which values will be copied. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Source Fields.
Source Fields Field name List of fields in the source record to copy to the target related record. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Target Fields.
Primary Key Field name Source features identifier used in the related table
Foreign Key Field name Related table field with values corresponding to the source feature identifiers
Commit (Optional) Field name, Number of records to create or a Boolean for Commit In the current release of this rule, the parameter is being used for two options. If you want to generate a number of related records, specify the field name that has a value with the number of records to create or specify the number of records to create. For the Commit option, by default, the new record is not stored in the geodatabase until all the rules for the edited feature are processed. If [TRUE], the data is stored so that any following rules can be processed.

Examples

Generates a single record in the Related layer by storing the FACILITYID field of the Parent feature in the FACILITYKEY field of the Related layer. The OWNER field in the Parent layer will be copied to the RELOWNER field in the Related layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY

Generates ten records in the Related layer. The OWNER and COLOR fields in the Parent layer will be copied to the RELOWNER and COLOR fields, respectively, in the Related layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER,COLOR|RELOWNER,COLOR|FACILITYID|FACILITYKEY|10

Generates a dynamic number of records in the Related layer. The number of records is defined by the RELCOUNT field in the Parent layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|RELCOUNT

Generates a single record in the Related layer. This record is stored immediately so that it can be accessed by other Attribute Assistant rules:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|TRUE


Create Perpendicular Line

Constructs a perpendicular line from the input point and an intersecting line. The line's length is specified by the Length parameter.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Blank or null CREATE_PERP_LINE Source|Length|Neighborhood|Snapping|Target|{Template}

This rule can only be configured on point features.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Line feature layer or feature class Feature layer containing the existing line features.
Length Field name or value Field containing the length value for the line, or a single value to use for all features.
Neighborhood Value Maximum distance to search for nearest feature.
Snapping True Snap the new line to the existing line feature.
False Do not snap the new line to the existing line feature.
Target Line feature layer or feature class Feature layer to contain the new perpendicular lines.
Template (Optional) Editing template Editing template used to symbolize and attribute the new line feature.

Examples

Creates a perpendicular line 100 units long starting at snapped point on the sewPipes layer within 5 units to the Tap feature. The new line is stored in the comPipes layer:

  • Table Name: Taps
  • Field Name: <Null>
  • Value Info: sewPipes|100|5|True|comPipes

Creates a perpendicular line 100 units long starting at Tap feature. The new line is perpendicular to the closest feature in the sewPipes layer within 5 units, but does not start on the snapped point, but the actual Tap feature. The new line is stored in the comPipes layer using the PerpLine edit template:

  • Table Name: Taps
  • Field Name: <Null>
  • Value Info: sewPipes|LINELENGTH|5|False|comPipes|PerpLine


Create Perpendicular Line to Line

Constructs a perpendicular line from the input point to the nearest line.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Blank or null CREATE_PERP_LINE_TO_LINE Source|Neighborhood|Target|{Template}

This rule can only be configured on point features.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Line feature layer or feature class Feature layer containing the existing line features.
Neighborhood Value Maximum distance to search for nearest feature.
Target Line feature layer or feature class Feature layer to contain the new perpendicular lines.
Template (Optional) Editing template Editing template used to symbolize and attribute the new line feature.

Examples

Creates a perpendicular line from the wServiceConnection feature to the nearest line in the wMain layer within 100 units. The new line is stored in the wLateralLine layer:

  • Table Name: wServiceConnection
  • Field Name: <Null>
  • Value Info: wMain|100|wLateralLine

The new line is stored in the wLateralLine layer using the 2" Copper Commercial edit template:

  • Table Name: wServiceConnection
  • Field Name: <Null>
  • Value Info: wMain|100|wLateralLine|2" Copper Commercial


Current Username

Populates the current user name.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to store the user name CURRENT_USER {Format}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Format (Optional) W Full Windows login name as domain\user name
U Windows user name
D Connected database user for the edit session
Null (Default) Connected database user name if available; otherwise, full Windows login name as your domain\user name

Examples

Stores the windows user including the domain in the LASTEDITOR field in the wLateralLine layer:

  • Table Name: wLateralLine
  • Field Name: LASTEDITOR
  • Value Info: W

Stores the user information used to connect to an enterprise database in all layers:

  • Table Name: *
  • Field Name: LASTEDITOR
  • Value Info: D


Edge Statistics

Provides statistics on a specified field for all connected edges in a geometric network.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Geometric network junction feature class Field to store the statistics EDGE_STATS Source|Statistic|{Delimiter}|{SortOrder}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Stores the maximum value of the DIAMETER field in all connected edges into the MAXEDGES field in the junctions feature class:

  • Table Name: junctions
  • Field Name: MAXEDGES
  • Value Info: DIAMETER|Max

Stores a comma-delimited string of all DIAMETER values:

  • Table Name: junctions
  • Field Name: MAXEDGES
  • Value Info: DIAMETER|Concat

Stores a semicolon-delimited string, sorted in descending order:

  • Table Name: junctions
  • Field Name: MAXEDGES
  • Value Info: DIAMETER|Concat|;|DESC


Expression

Executes a VBScript evaluated by the MSScriptControl. Can be used to access built-in functions and conditional logic (if statements).

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field on which the expression should be executed EXPRESSION VBScript Expression

This rule can be configured on any field type.

Parameters

In the expression, the edited field (field name listed in the Field column) can be indicated using [#] or the field name enclosed by [].

Additional functions

  • IIF(expression, truepart, falsepart): used to create complex If-Else statements; returns one of two objects, depending on the evaluation of an expression. Both the True and False portions of IIF statements must be able to be evaluated; functions cannot be used on Null values. For example, IIF(1=1, left(Null), "false") cannot evaluate.
  • TCase(string): returns a copy of the string converted to title case.
  • Ceil(number): returns the smallest integer greater than or equal to the specified number.
  • Floor(number): returns the largest integer less than or equal to the specified number.

Function notes

  • If specifying a decimal number in the equation, the decimal separator (radix point) must be a period:
    • Invalid: IIF([height]>12,5, "yes", "no")
    • Valid: IIF([height]>12.5, "yes", "no")
  • To perform string operations on GUID fields, the field name must be treated as a string:
    • Invalid: replace([GlobalID], "{", "")
    • Valid: replace("[GlobalID]", "{", "")
  • To set values as null, use "<NULL>" string:
    • Invalid: IIF([LOCDESC]=0, "", [LOCDESC])
    • Valid: IIF([LOCDESC]=0, "<NULL>", [LOCDESC])

Examples

Joins the FROMMH and TOMH fields in the gravityMains layer with a dash and removes all instances of "MH-", storing this value in the MHID field. In this example, if the FROMMH and TOMH fields have a value of "MH-001" and "MH-123", respectively, then the value "001-123" will be stored:

  • Table Name: gravityMains
  • Field Name: MHID
  • Value Info: replace(([FROMMH] & "-" & [TOMH]), "MH-", "")

Uses a lookup value in the DIAM field to store textual color representations in the COLORSYM field in the gravityMains layer. In this example, a value ≤6 is RED, >6 AND ≤10 is ORANGE, >10 AND ≤15 is GREEN, and >15 is BLUE:

  • Table Name: gravityMains
  • Field Name: COLORSYM
  • Value Info: IIF([DIAM]<=6, "RED", IIF([DIAM]<=10, "ORANGE", IIF([DIAM]<=15, "GREEN", "BLUE")))

Stores the ADDRESS field in the ADDRPROPER field, converting to title case if the UNIT field is not null. In this example, if the ADDRESS field is "forest grove ct" and the UNIT field is "101", then the value "Forest Grove Ct" will be stored; if UNIT is empty (null), then the value will remain the same:

  • Table Name: gravityMains
  • Field Name: ADDRPROPER
  • Value Info: IIF(isNull([UNIT]), [ADDRESS], TCase([ADDRESS]))


Feature Statistics

Summarizes the attribute values of the affected feature as a series of statistics or a single calculated value.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to store the statistics FEATURE_STATS Source|Statistic|{Delimiter}|{SortOrder}

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Stores the maximum value of the POPMALE and POPFEMALE fields into the MAXPOP field in the serviceArea layer:

  • Table Name: serviceArea
  • Field Name: MAXPOP
  • Value Info: POPMALE,POPFEMALE|Sum

Stores a comma-delimited string of POPMALE and POPFEMALE values:

  • Table Name: serviceArea
  • Field Name: MAXPOP
  • Value Info: POPMALE,POPFEMALE|Concat

Stores a semicolon-delimited string, sorted in descending order:

  • Table Name: serviceArea
  • Field Name: MAXPOP
  • Value Info: POPMALE,POPFEMALE|Concat|;|DESC


Field

Copies the value from from one field to another within the same feature class.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class from which fields will be copied Field to populate FIELD Source|{Value}

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Field from which the values will be copied from.
Value (Optional) CODE The code value will be copied for fields with subtypes and/or domains.
DISPLAY (Default) The display value will be copied for fields with subtypes and/or domains.

Examples

Copies the value from the CREATED field to the ASSIGNED field in all layers:

  • Table Name: *
  • Field Name: ASSIGNED
  • Value Info: CREATED

Copies the domain display value from the MATERIAL field to the TYPE field in the wGravityMains layer:

  • Table Name: wGravityMains
  • Field Name: TYPE
  • Value Info: MATERIAL|DISPLAY


Field Trigger

Updates a field to a specified value when the value of another field is updated.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to monitor for changes FIELD_TRIGGER Trigger|Target|Value

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Trigger String or number This value causes the target field to update.
Target Field name Field to update.
Value String or number The target field is updated to this value.

Examples

Monitors the STATUS field in the wGravityMains layer; whenever the value is changed to ABANDONED, store NONE in the PRESSUREZONE field:

  • Table Name: wGravityMains
  • Field Name: STATUS
  • Value Info: ABANDONED|PRESSUREZONE|NONE


From Edge Field

Copies a field value from a connected From Edge feature to a connected junction feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Point feature class participating in a geometric network Field in the junction feature layer FROM_EDGE_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to copy in the From Edge layer.
Source (Optional) Layer or feature class If specified, only copy values from features in this layer; otherwise, copy values from all connected From Edge features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only copy features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FACILITYID field in the From Edge layers into the FID field in the wServiceConnection layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID

Copies the value from the FACILITYID field in the wMain layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain

Copies the value from the FACILITYID field in the wMain layer where the SVCTYPE field value is Domestic:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain|SVCTYPE|Domestic


From Edge Multiple Field Intersection

Copies values for all From Edges connected to a junction to a series of fields in the source layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Geometric network junction feature class Null or blank FROM_EDGE_MULTI_FIELD_INTERSECT Source|Target

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Field to copy
Target String Array of fields to populate in the form field1,field2,etc.

Examples

Copies the value from the DIAMETER field from the From Edges features to the DIAM1, DIAM2, and DIAM3 fields in the Connections layer:

  • Table Name: Connections
  • Field Name: <Null>
  • Value Info: DIAMETER|DIAM1,DIAM2,DIAM3


From Edge Statistics

Calculates statistics on a specified field for all features connected to From Edges in a geometric network.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to store the statistics FROM_EDGE_STATS Source|Statistic|{Delimiter}|{SortOrder}

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Stores the maximum value of the DIAMETER field for all connected From Edges features into the MAXDIAM field in the wHydrants layer:

  • Table Name: wHydrants
  • Field Name: MAXDIAM
  • Value Info: DIAMETER|Max

Stores a comma-delimited string of all DIAMETER values:

  • Table Name: wHydrants
  • Field Name: MAXDIAM
  • Value Info: DIAMETER|Concat

Stores a semicolon-delimited string, sorted in descending order:

  • Table Name: wHydrants
  • Field Name: DIAMETER
  • Value Info: DIAMETER|Concat|;|DESC


From Junction Field

Copies a field value from a connected From Junction feature to a connected edge feature. Can also copy the name of the feature class at the start of the currently edited line.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Line feature class participating in a geometric network Field in the line feature layer FROM_JUNCTION_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type except when Field is specified as (NAME); in this case, the field type must be String.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field Name The field to copy in the From Junction layer.
(NAME) If specified as (NAME), the feature class name will be used instead of a feature value.
Source (Optional) Layer or feature class If specified, only copy values from features in this layer; otherwise, copy values from all connected From Junction features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only copy features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the name of the feature class that is snapped to the start point of the current line into the STARTPT field of the wMain layer. In this example, the value "Water_Net_Junctions" might be copied to the STARTPT field:

  • Table Name: wMain
  • Field Name: STARTPT
  • Value Info: (NAME)

Copies the value from the FID field in the From Junction layers into the FACILITYID field in the wMain layer:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID

Copies the value from the FID field in the wServiceConnection feature class:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection

Copies the value from the FID field in the wServiceConnection feature class where the SVCTYPE field value is Domestic:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection|SVCTYPE|Domestic


Generate ID

Increments a row in an unversioned table and stores that newly incremented value.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class The field to contain the identifier GENERATE_ID Name|{Width}|{Format}[SEQ]|{Keep Existing}

This rule can be configured on any field type, but the format of the field should be coordinated with the format of your identifier.

Parameters

The method parameters are as follows:

Parameter Value Description
Name String The name of the sequence.
Width (Optional) Integer The minimum length of the identifier. If the current value of [SEQ] is shorter than this value, zeros will be added to the left of [SEQ] to create the specified width. This is only valid for string fields.
Format (Optional) String Static portion of the identifier.
[SEQ] Placeholder for the iterated value; [SEQ] may appear anywhere in the format string.
Keep Existing (Optional) True Limit the rule to only be triggered when the field is null. This will prohibit overwriting existing IDs.
False (Default) Trigger the rule to generate a new ID or overwrite the current ID, if it exists.

Examples

Increments the HYDSEQ value in the GenerateID table and stores this new value in the HYDID field in the hydrants layer:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: HYDSEQ

Left-pads the HYDSEQ value. In this example, if the HYDSEQ is 7, 39, or 1234 then the HYDID will be 0007, 0039, or 1234, respectively:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: HYDSEQ|4

Appends the HYDSEQ value to the text "Hydrant-". In this example, if the HYDSEQ is 7, 39, or 1234 then the HYDID will be Hydrant-7, Hydrant-39, or Hydrant-1234, respectively:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: HYDSEQ||Hydrant-[SEQ]

Do not overwrite existing HYDID values when this rule is executed:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: HYDSEQ||Hydrant-[SEQ]|True


Generate ID By Intersect

Generates unique identifiers for features based on the identifiers of intersecting grid features.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class The field to contain the identifier GENERATE_ID_BY_INTERSECT Source|Source Field|Name|{Width}|{Format}[ID][SEQ]|{Keep existing}

This rule can be configured on any field type, but the format of the field should be coordinated with the format of your identifier.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Polygon feature class or feature layer Grid features.
Source Field Field name Field containing grid identifiers.
Name String The name of the sequence.
Width (Optional) Integer The minimum length of the identifier. If the current value of [SEQ] is shorter than this value, zeros will be added to the left of [SEQ] to create the specified width. This is only valid for string fields.
Format (Optional) String Static portion of the identifier.
[ID] Placeholder for the grid identifier in the generated ID; [ID] may appear anywhere in the formatted string.
[SEQ] Placeholder for the iterated value; [SEQ] may appear anywhere in the format string.
Keep existing (Optional) True Limit the rule to only be triggered when the field is null. This will prohibit overwriting existing IDs.
False (Default) Trigger the rule to generate a new ID or overwrite the current ID, if it exists.

Examples

Increments the GRIDSEQ value in the GenerateID table and concatenates it with the GRIDID field value of the intersecting feature in the fireDistrict layer; this new value is stored the HYDID field in the hydrants layer. In this example, if the GRIDID of fireDistrict feature is 1 and the GRIDSEQ is 27, then the HYDID will be 127:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: fireDistrict|GRIDID|GRIDSEQ

Left-pads the GRIDSEQ value before concatenating with the intersecting GRIDID value. In this example, if the GRIDID of fireDistrict feature is 1 and the GRIDSEQ is 27, then the HYDID will be 10027:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: fireDistrict|GRIDID|GRIDSEQ|4

Concatenates the GRIDID and GRIDSEQ values and appends to the text "Hydrant ". In this example, if the GRIDID of fireDistrict feature is 1 and the GRIDSEQ is 27, then the HYDID will be "Hydrant 1-27":

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: fireDistrict|GRIDID|GRIDSEQ||Hydrant [ID]-[SEQ]

Do not overwrite existing HYDID values when this rule is executed:

  • Table Name: hydrants
  • Field Name: HYDID
  • Value Info: fireDistrict|GRIDID|GRIDSEQ||Hydrant [ID]-[SEQ]|True


Get Address From Centerline

Extracts address information from the closest point on a road. It is similar to a reverse geocode, but a locator service is not used.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to which the address will be written GET_ADDRESS_FROM_CENTERLINE Roads|Source|{Neighborhood}

This rule always searches the feature class, not the feature layer.

Parameters

The method parameters are as follows:

Parameter Value Description
Roads Feature class Road centerlines feature class.
Source String Addressing information fields in the format: Road Name, To Left, To Right, From Left, From Right.
Neighborhood (Optional) Value Maximum distance to search for nearest feature. If not specified, only intersecting features are used.

Examples

Stores the address from a five foot search of the RoadCenterline layer:

  • Table Name: ProposedSites
  • Field Name: ADDRESS
  • Value Info: RoadCenterline|ROADNAME,TOLEFT,TORIGHT,FROMLEFT,FROMRIGHT|5


Get Address Using ArcGIS Service

Performs a reverse geocode using a specified ArcGIS service.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to which the address will be written GET_ADDRESS_USING_ARCGIS_SERVICE {URL to Locator}|{WKID}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter Value Description
URL to Locator (Optional) <Null> (Default) ArcGIS Online geocoding service.
String The URL of the locator service to use for geocoding.
WKID (Optional) <Null> (Default) Use the projection of the geocoding service.
Integer Project the results to the coordinate system specified by this well-known ID.

Examples

Stores the address provided by ArcGIS Online in the ADDRESS field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: ADDRESS
  • Value Info: <Null>

Stores the address provided by a locator hosted by your organization's Portal:

  • Table Name: ProposedSites
  • Field Name: ADDRESS
  • Value Info: http://www.ags.yourorganization.com/arcgis/rest/services/Address_with_Zone

Your Portal's locator is in WGS 1984 Web Mercator (WKID 3857). The ProposedSites layer is in NAD 1983 StatePlane Illinois East FIPS 1201 Feet (WKID 3435):

  • Table Name: ProposedSites
  • Field Name: ADDRESS
  • Value Info: http://www.ags.yourorganization.com/arcgis/rest/services/Address_with_Zone|3435


Get Address Using Geocoder

Performs a reverse geocode using a geocoder.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to which the address will be written GET_ADDRESS_USING_GEOCODER Locator Path|Locator Name

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Locator Path String The directory containing the locator.
Locator Name String The file name of the locator, with or without the file extension.

Examples

Finds the nearest address and stores this value in the ADDRESS field in the sites layer:

  • Table Name: sites
  • Field Name: ADDRESS
  • Value Info: D:/gis/data/locators|CountyLoc.loc


GUID

Creates a globally unique identifier (GUID).

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class String field long enough to store the specified GUID format. GUID {Format}

Parameters

The method parameters are as follows:

Parameter Value Description
Format (Optional) N GUID with no special characters and length of 32 00000000000000000000000000000000
D GUID with dashes and length of 36 00000000-0000-0000-0000-000000000000
B (Default) GUID with dashes, braces, and length of 38 {00000000-0000-0000-0000-000000000000}
P GUID with dashes, parentheses, and length of 38 (00000000-0000-0000-0000-000000000000)

Examples

Stores a 38 character GUID in the PRIMARYKEY field in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: PRIMARYKEY
  • Value Info: <Null>

Stores a 32 character GUID in the PRIMARYKEY field in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: PRIMARYKEY
  • Value Info: N


Intersecting Boolean

Stores a value if the triggering feature intersects a feature in the specified layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field into which value will be stored INTERSECTING_BOOLEAN Layer|{True Value}|{False Value}

This rule can be configured on all features.

Parameters

The method parameters are as follows:

Parameter Value Description
Layer Feature class or feature layer List of features which may intersect the lines in the format layer1,layer2,etc.
True Value (Optional) <Null> (Default) Store the value 1 when an intersecting feature is found.
Value Store this value when an intersecting feature is found.
False Value (Optional) <Null> (Default) Store the value 0 when an intersecting feature is not found.
Value Store this value when an intersecting feature is not found.

Examples

If the current feature in the proposedSites layer intersects a feature in the serviceTerritory layer, store 1 in the LOCATION field; otherwise, store 0:

  • Table Name: proposedSites
  • Field Name: LOCATION
  • Value Info: serviceTerritory

If the current feature in the proposedSites layer intersects a feature in the serviceTerritory layer, store 1.25 in the MODIFIER field; otherwise, store 1.75:

  • Table Name: proposedSites
  • Field Name: MODIFIER
  • Value Info: serviceTerritory|1.25|1.75


Intersecting Count

Calculates the number of intersecting features and stores the count in the specified field.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field into which the count will be copied INTERSECTING_COUNT Source

This rule can be configured on polygon features, and the count value must be populated in Floating or Short fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Feature class or feature layer Intersecting features from which a count will be calculated.

Examples

Stores the number of intersecting features between the current feature in the proposedSites layer and the serviceTerritory layer in the INTER field:

  • Table Name: proposedSites
  • Field Name: INTER
  • Value Info: serviceTerritory


Intersecting Edge

Copies a field value from the first intersecting edge feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field into which the values will be copied INTERSECTING_EDGE Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name Field to copy from the intersecting edge.

Examples

Copies the value from the DIAM field in the first intersecting edge feature and stores the value in the DIAMETER field in the wPipes layer:

  • Table Name: wPipes
  • Field Name: DIAMETER
  • Value Info: DIAM


Intersecting Feature

Copies a value from an intersecting feature in the specified layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field for the intersecting values INTERSECTING_FEATURE Input|Source|{Method}|{Not Found}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Input String List of layers to search for intersecting features in the format layer1,layer2,etc.
Source Field name Field from the intersecting feature to copy.
Method (Optional) F (Default) Return the first result found.
P Present dialog box of intersecting features.
C Use the centroid as the intersection point, choosing the feature with the lowest object id.
CP Use the centroid as the intersection point, presenting a dialog box of intersecting features.
S Use the start point of the line as the intersection point, choosing the feature with the lowest object id.
SP Use the start point of the line as the intersection point, presenting a dialog box of intersecting features.
E Use the end point of the line as the intersection point, choosing the feature with the lowest object id.
EP Use the end point of the line as the intersection point, presenting a dialog box of intersecting features.
H Use the feature with the highest object id.
Not Found (Optional) True If no intersecting feature is found, existing values will be set to null.
False (Default) If no intersecting feature is found, value will remain.

Examples

Copies the value from the DIAM field in the first intersecting feature and stores the value in the DIAMETER field in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: DIAMETER
  • Value Info: wMain|DIAM

Finds all intersecting features in the ssPressurizedMain and ssGravityMain layers and presents the user with a dialog box of intersecting features from which to choose. If there are no intersecting features, the DIAMETER field in the ssManhole layer will not be overwritten:

  • Table Name: ssManhole
  • Field Name: DIAMETER
  • Value Info: ssPressurizedMain,ssGravityMain|DIAM|P|False

Copies the value from the DIAM field in the intersecting feature with the highest Object ID value and stores the value in the DIAMETER field in the ssFitting layer. If there are no intersecting features, the DIAMETER field in the ssManhole layer will be set to Null::

  • Table Name: ssFitting
  • Field Name: DIAMETER
  • Value Info: ssGravityMain|DIAM|H|True


Intersecting Feature Distance

Calculates the distance along a line feature where a line is intersected by another feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to hold the distance measurement INTERSECTING_FEATURE_DISTANCE Source|Identifier

This rule can only be configured on numeric or text fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Feature class or feature layer List of features which may intersect in the format layer1,layer2,etc.
Identifier Field name Field identifying the intersecting feature

Examples

Finds the intersecting feature in the ssPressurizedMain or ssGravityMain layer and calculates the distance from the start point to the current feature. The distance will be copied to the DISTALONG field in the ssManhole layer:

  • Table Name: ssManhole
  • Field Name: DISTALONG
  • Value Info: ssPressurizedMain,ssGravityMain|FACILITYID

Populates the DISTDESC field with a string similar to "123.45 Feet along Pressurized Mains with Facility Identifier PM-0025":

  • Table Name: ssManhole
  • Field Name: DISTDESC
  • Value Info: ssPressurizedMain,ssGravityMain|FACILITYID


Intersecting Layer Details

Extracts the name or file path of an intersecting layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to hold the details of the intersecting feature INTERSECTING_LAYER_DETAILS Source|Result|Method|{Filter}

This rule can only be configured on String fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Source RASTER Extract details for intersecting rasters only.
VECTOR Extract details for intersecting vector features only.
BOTH Extract details for intersecting rasters and vectors.
List of feature classes or feature layers Extract details for intersecting features from a defined list of feature classes or feature layers in the format layer1,layer2,etc.
Result P Extract the full path of the intersecting feature class.
N Name of the intersecting layer.
F The name of the feature class.
Method C Search using centroids.
P Prompt for search method.
F Return the first result found.
Filter (Optional) String Restrict the intersecting features to those matching a wildcard filter.

Examples

Copies the source name of the first intersecting raster and stores this value in the ZONE field in the sites layer:

  • Table Name: sites
  • Field Name: ZONE
  • Value Info: RASTER|F|F

Copies the full path of the first intersecting feature in the ssPressurizedMain or ssGravityMain layers and stores this value in the PIPE field in the ssManhole layer:

  • Table Name: ssManhole
  • Field Name: PIPE
  • Value Info: ssPressurizedMain,ssGravityMain|P|F

Presents the user with a dialog box of all intersecting vector layers containing the text "Main"; the selected layer name is copied:

  • Table Name: ssManhole
  • Field Name: PIPE
  • Value Info: VECTOR|N|P|Main


Intersecting Raster

Extracts a raster cell value at a feature location. If the feature is a line or polygon, the raster value at the feature centroid is used.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to hold the extracted value INTERSECTING_RASTER Source|{Label}

If a label is specified and the target field is not a text field, the label will be omitted.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Raster Raster from which the value will be extracted. A list of rasters may be entered in the format raster1,raster2,etc.
Label (Optional) String Prepend text; omitted if left blank.

Examples

Copies the current cell value from the FiveMeterSurface raster in the ELEV field in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: ELEV
  • Value Info: FiveMeterSurface

Concatenates "Elevation: " with the current raster cell value:

  • Table Name: wHydrant
  • Field Name: ELEV
  • Value Info: FiveMeterSurface|Elevation:


Intersecting Statistics

Calculates statistics on a specified field for intersecting features.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to store the statistics INTERSECT_STATS Source|Source Field|Statistic|Neighborhood|{Delimiter}|{SortOrder}

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layer or feature class Intersecting features
Source Field Field name Numeric field to analyze
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Neighborhood Value Maximum distance to search for nearest feature.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Stores the maximum value of the DIAMETER field from all features in the ssGravityMain layer within 25 units of the current feature into the MAXDIAM field in the junctions feature class:

  • Table Name: junctions
  • Field Name: MAXDIAM
  • Value Info: ssGravityMain|DIAMETER|Max|25

Stores a comma-delimited string of all DIAMETER values:

  • Table Name: junctions
  • Field Name: MAXDIAM
  • Value Info: ssGravityMain|DIAMETER|Concat|25

Stores a semicolon-delimited string, sorted in descending order:

  • Table Name: junctions
  • Field Name: MAXDIAM
  • Value Info: ssGravityMain|DIAMETER|Concat|25|;|DESC


Junction Rotation

Stores the rotation angle of a junction feature based on connected edge features.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Point feature class Field to store the rotation angle JUNCTION_ROTATION {Type}|{Additional}|{Special}|{Source}

This rule can only be configured on Floating, Integer, or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Type (Optional) A Arithmetic rotation (counter-clockwise from positive X axis).
G (Default) Geographic rotation (clockwise from positive Y axis).
Additional (Optional) Value Additional degrees to rotate the features.
Special (Optional) Numeric field name Features will be spun from the smaller to the larger value. For example, you can use this for reducer fittings and the diameter field of the mains so the reducer is properly oriented.
Source (Optional) Feature class

Rotation will be calculated based on angle of features only in this layer.

Note: The database name of the feature class must be used.

Examples

Stores the geographic rotation of the junction in the ROT field in the junctions layer:

  • Table Name: junctions
  • Field Name: ROT
  • Value Info: <Null>

Stores the geographic rotation of the junction plus an additional 90-degree rotation in the ROT field in the junctions layer. Only the ssLateralLines edge layer will be used to determine rotation and the rotation value will be oriented from smaller to larger:

  • Table Name: junctions
  • Field Name: ROT
  • Value Info: |90|DIAMETER|ssLateralLines


Last Value

Repeats the last value used in a field.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class The field in which the value will be repeated LAST_VALUE Null Values|Default|On Create

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Null Values True Only affects null values.
False Overwrites all field values.
Default Value The value to enter in the field if there is no last value.
On Create (Optional) True The value of created features overwrites the last value array. This is the default behavior if no parameter is set.
False The value of created features does not overwrite the last value array.

Examples

Copies the value last entered in the TYPE field in the wMain layer, overwriting existing field values; if there isn't a previous value, use PVC:

  • Table Name: wMain
  • Field Name: TYPE
  • Value Info: False|PVC


Latitude

Stores the y-coordinate value projected to WGS84 decimal degrees.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class The field in which the value will be stored LATITUDE {Location}

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Location (Optional) <Null> (Default) Y-coordinate of the centroid of line and polygon features. For point features, this is the point itself.
S Y-coordinate of the start point of line and polygon features.
E Y-coordinate of the end point of line and polygon features.

Examples

Stores the latitude of the polygon's centroid in the LATLOC field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: LATLOC
  • Value Info: <Null>

Stores the latitude of polyline's start point:

  • Table Name: ProposedSites
  • Field Name: LATLOC
  • Value Info: S


Length

Calculates the length of line features and the area of polygon features.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class The field to store the measurement LENGTH {Geodesic}

This rule can only be configured on line and polygon feature classes, and the length value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Geodesic (Optional) <Null> (Default) Calculates the length/area in database units, using planar measurements.
False Calculates the length/area in database units, using planar measurements.
True Calculates the length/area in database units, using geodesic measurements (true shape).

Examples

Calculates the length of a line in the wLateralLine layer and stores in the LENGTH field:

  • Table Name: wLateralLine
  • Field Name: LENGTH
  • Value Info: <Null>

Calculates the geodesic or true length of a line:

  • Table Name: wLateralLine
  • Field Name: LENGTH
  • Value Info: True

Calculates the geodesic or true area of a polygon in the AreaOfInterest layer and stores in the AREA field:

  • Table Name: AreaOfInterest
  • Field Name: AREA
  • Value Info: True


Updates a field in the table or layer with a value from a selected feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class The field to update. List multiple fields in the format field1,field2,etc. LINK_TABLE_ASSET Source|Source Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layer or feature class The feature layer or feature class from which the values will be copied.
Source Field Field name The field to copy; if there are multiple fields, list them in the format field1,field2,etc. The number of fields here must match the number of fields listed in Field Name.

Examples

Copies the value of the FACILITYID field of the selected feature in the wMain layer to the FID field of the current feature in the in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: FID
  • Value Info: wMain|FACILITYID

Copies the values from the ADDRESS and OWNER fields into the HOUSEADDRESS and HOUSEOWNER fields, respectively:

  • Table Name: proposedSites
  • Field Name: HOUSEADDRESS,HOUSEOWNER
  • Value Info: parcels|ADDRESS,OWNER


Longitude

Stores the x-coordinate value projected to WGS84 decimal degrees.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class The field in which the value will be stored LONGITUDE {Location}

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Location (Optional) <Null> (Default) X-coordinate of the centroid of line and polygon features. For point features, this is the point itself.
S X-coordinate of the start point of line and polygon features.
E X-coordinate of the end point of line and polygon features.

Examples

Stores the longitude of the polygon's centroid in the LONLOC field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: LONLOC
  • Value Info: <Null>

Stores the longitude of polyline's start point:

  • Table Name: ProposedSites
  • Field Name: LONLOC
  • Value Info: S


Map Info

Stores information from the current map document metadata or the version info of the layer being edited.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or Feature Class The field in which the value will be stored MAP_INFO Property Type|{Field to Monitor}

This rule can only be configured on text fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Property Type AUTHOR The map document author.
NAME The map document name (filename without extension).
PATH The map document path (folder containing the map document).
TITLE The map document title.
VERSION The version name of the layer being edited. When editing a non-versioned dataset, FGDB will be stored.
Field to Monitor (Optional) Field name The field to monitor for changes.

Examples

Stores the author from the map document properties in the AUTH field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: AUTH
  • Value Info: AUTHOR

Stores the workspace version of the ProposedSites layer whenever a value in the LASTEDITOR field is changed:

  • Table Name: ProposedSites
  • Field Name: AUTH
  • Value Info: VERSION|LASTEDITOR


Minimum Length

Rejects a newly created line feature if the length of the line is less than the specified distance.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Blank or null MINIMUM_LENGTH Length

This rule can only be configured on linear features and the length value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Length Numeric Minimum length of line

Examples

Rejects new features in the streets layer that are less than 5 units long:

  • Table Name: streets
  • Field Name: <Null>
  • Value Info: 5


Multiple Field Intersecting Values

Copies values from new intersecting features into a target layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class with which features will intersect Null or blank MULTI_FIELD_INTERSECT Source|Source Field|Target Fields|Neighborhood

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layers or feature classes Intersecting layer from which values will be copied; multiple layers can be specified in the format layer1,layer2,etc.
Source Field Field name Field from which values will be copied.
Target Fields Field name List of fields to which values will be copied in the format field1,field2,etc.
Neighborhood Value Maximum distance to search for nearest feature.

Examples

Finds all features from the ssGravityMain layer that intersect the current feature in the manhole layer. For each feature in ssGravityMain that intersects, copy the DIAMETER field value into the D1, D2, and D3 fields in the manhole layer. In this example, if there are three features in ssGravityMain - with diameters of 6, 7, and 8 - that intersect the current manhole feature, then these values will be copied to D1, D2, and D3, respectively.

  • Table Name: manhole
  • Field Name: <Null>
  • Value Info: ssGravityMain|DIAMETER|D1,D2,D3|0

Finds all features in the ssGravityMain and ssSewerMain layers that are within 25 units:

  • Table Name: manhole
  • Field Name: <Null>
  • Value Info: ssGravityMain,ssSewerMain|DIAMETER|D1,D2,D3|25


Nearest Feature

Copies a value from the nearest feature in a specified layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to which the values will be copied NEAREST_FEATURE Source|Source Field|Neighborhood|{Source Filter}|{Target Filter}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Feature layer or feature class List of datasets that may contain the nearest feature in the format layer1,layer2,etc.
Source Field Field name Field from which values will be copied.
Neighborhood Value Maximum distance to search for nearest feature.
Source Filter (Optional) Field name Filter by restricting results to source features with a value in this field matching the value in the Target Filter field.
Target Filter (Optional) Field name Filter by restricting results to source features with a value in this field matching the value in the Source Filter field.

Examples

Searches the wMeter layer for the nearest feature. Store the value from the ACC field into the ACCOUNT field of the wLateralLine layer:

  • Table Name: wServiceConnection
  • Field Name: ACCOUNT
  • Value Info: wMeter|ACC

Searches the wMeter and wLateralPoint layers for the nearest feature within 100 units:

  • Table Name: wLateralLine
  • Field Name: ACCOUNT
  • Value Info: wMeter,wLateralPoint|ACC|100

Searches the wMeter and wLateralPoint layers for the nearest feature whose DIAM is the same as current feature's DIAMETER:

  • Table Name: wLateralLine
  • Field Name: ACCOUNT
  • Value Info: wMeter,wLateralPoint|ACC||DIAM|DIAMETER


Nearest Feature Attributes

Copies a series of values from the nearest feature in a specified layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Null or blank NEAREST_FEATURE_ATTRIBUTES Source|Source Fields|Target Fields|{Neighborhood}|{Reset to Default}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Line feature layer or feature class Dataset near the target dataset.
Source Fields Field name List of fields from which values will be copied in the format field1,field2,etc. List must have the same number of values as Target Fields.
Target Fields Field name List of fields to which values will be copied in the format field1,field2,etc. List must have the same number of values as Source Fields.
Neighborhood (Optional) <Null> (Default) Only intersecting features are considered.
Number Maximum distance to search for nearest feature.
Reset to Default (Optional) True If no feature is found within the specified neighborhood distance, field values will be overwritten with the field's default value.
False (Default) Field values will not change.

Examples

Stores the value from the ACC and ASSIGN fields in the nearest wMeter layer into the ACCOUNT and ASSIGNEDTO fields, respectively, of the wLateralLine layer:

  • Table Name: wLateralLine
  • Field Name: <Null>
  • Value Info: wMeter|ACC,ASSIGN|ACCOUNT,ASSIGNEDTO

Searches the wMeter layer for the nearest feature within 100 units. If a feature cannot be found, populate with the default field value:

  • Table Name: wLateralLine
  • Field Name: <Null>
  • Value Info: wMeter|ACC,ASSIGN|ACCOUNT,ASSIGNEDTO|100|True


Offset

Populates the location of a point a specified distance from the nearest line feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Two field names in the format field1,field2 to store the x and y values OFFSET Source|Offset|Neighborhood

This rule can only be configured on point features, and the offset value must be populated in Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layer or feature class Line feature class or feature layer.
Offset Field name or value Field containing the offset values, or a single value to use for all features. A positive value will offset to the right side of the line, whereas a negative value will offset to the left.
Neighborhood Value Maximum distance to search for nearest feature.

Examples

Searches the roadCenterline layer for the nearest line to the current feature in the addresses layer within 500 units. Calculates the X and Y coordinates of a point offset 75 perpendicular units to the right of the line, storing the values in the OFFX and OFFY fields, respectively, in the addresses layer:

  • Table Name: addresses
  • Field Name: OFFX,OFFY
  • Value Info: roadCenterline|75|500

Calculates the perpendicular offset of 50 units to the left of the line where the current feature in the addresses layer intersects a feature in the roadCenterline layer:

  • Table Name: addresses
  • Field Name: OFFX,OFFY
  • Value Info: roadCenterline|-50|0


Previous Value

Monitors a field, and when it is changed, stores the previous value in another field.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to monitor for changes PREVIOUS_VALUE Field

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name Field to store the previous value

Examples

Monitors the ADDRESS field in the streets layer for changes and copies the original value to the LASTADDR field:

  • Table Name: streets
  • Field Name: ADDRESS
  • Value Info: LASTADDR


Prompt

Identifies records containing null values. If the field uses a subtype or domain, those options are presented in the dialog box for the user to select.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class List of fields to search in the format field1,field2,etc. PROMPT Null or blank

This rule can be configured on any field type.

Parameters

There are no parameters for this method.

Examples

Identify records with null values in the FACILITYID, DIAMETER, and/or TYPE fields in the wLateralLine layer:

  • Table Name: wLateralLine
  • Field Name: FACILITYID,DIAMETER,TYPE
  • Value Info: <Null>


Set Measures

Populates the m-coordinates of line features. M-values can be used to add route events to point and line events dynamically along line features.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class with m-values enabled SET_MEASURES {Type}

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Type (Optional) Blank (Default) Calculates m-values from zero to the length of the line in map units.
P Calculates m-values as a percentage of the length of the line (0–100%).

Examples

Calculates the m-values in the wLateralLine layer in map units:

  • Table Name: wLateralLine
  • Field Name: M_VALUE
  • Value Info: <Null>

Calculates the m-values as a percentage:

  • Table Name: wLateralLine
  • Field Name: M_VALUE
  • Value Info: P


Side

Determines if a point feature is to the left or right of a corresponding line feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to contain side value SIDE Source|Primary Key|Foreign Key

This rule can only be configured on point features, and the value must be populated in a String field.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layer or feature class Line features
Primary Key Field name Identifying field for line features in the line feature class
Foreign Key Field name Field in the point feature class containing the identifiers of the corresponding line features

Examples

Copies the value "Right" or "Left" into the SIDE field in the address layer. The STNAME field in the address layer is used to find the line feature with the same value in the STREET field in the masterStreets layer:

  • Table Name: address
  • Field Name: SIDE
  • Value Info: masterStreets|STREET|STNAME


Split Intersecting Feature

Splits features that intersect with features in a source layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Null or blank SPLIT_INTERSECTING_FEATURE Feature Class

This rule can only be configured on point features. It does not work for geometric network features.

Parameters

The method parameters are as follows:

Parameter Value Description
Feature Class feature classes List of feature classes that will be split by the input features in the format layer1|layer2|etc.

Examples

Splits the wMain layer where it intersects with features in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: <Null>
  • Value Info: wMain

Splits the wMain and wLateral layers:

  • Table Name: wHydrant
  • Field Name: <Null>
  • Value Info: wMain|wLateral


Timestamp

Populates the current date and time.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Date or string field TIMESTAMP {Format}

This rule can only be configured on String fields if you select the YEAR, DAY, or MONTH parameters.

Parameters

The method parameters are as follows:

Parameter Value Description
Format (Optional) <Null> (Default) Use the current date and time.
DATE Date only.
TIME Time only in 12-hour format.
TIME24 Time only in 24-hour format.
DAY Day only.
MONTH Month only.
YEAR Year only.
CUSTOM Specify format; for example, hh:mm:ss tt = 09:30:00 AM, MMMM = Month in text, such as March, and HH = Hour of the day, such as 23.

Examples

Stores the current date and time in the EDITDATE field in the wLateralLine layer:

  • Table Name: wLateralLine
  • Field Name: EDITDATE
  • Value Info: <Null>

Stores the current date in all layers:

  • Table Name: *
  • Field Name: EDITDATE
  • Value Info: DATE

Stores the current date in long time (for example, Monday, June 15, 2009):

  • Table Name: wLateralLine
  • Field Name: EDITDATE
  • Value Info: dddd, MMMM dd, yyyy


To Edge Field

Copies a field value from a connected To Edge feature to a connected junction feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Point feature class participating in a geometric network Field in the junction feature layer TO_EDGE_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to copy in the To Edge layer.
Source (Optional) Layer or feature class If specified, only copy values from features in this layer; otherwise, copy values from all connected To Edge features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only copy features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FACILITYID field in the To Edge layers into the FID field in the wServiceConnection layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID

Copies the value from the FACILITYID field in the wMain layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain

Copies the value from the FACILITYID field in the wMain layer where the SVCTYPE field value is Domestic:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain|SVCTYPE|Domestic


To Edge Multiple Field Intersect

Copies values for all To Edges connected to a junction to a series of fields in the source layer.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Geometric network junction feature class Null or blank TO_EDGE_MULTI_FIELD_INTERSECT Source|Target

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Field to copy
Target String Array of fields to populate in the form field1,field2,etc.

Examples

Copies the value from the DIAMETER field from the To Edges features to the DIAM1, DIAM2, and DIAM3 fields in the Connections layer:

  • Table Name: Connections
  • Field Name: <Null>
  • Value Info: DIAMETER|DIAM1,DIAM2,DIAM3


To Edge Statistics

Calculates statistics on a specified field for all features connected to To Edges in a geometric network.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to store the statistics TO_EDGE_STATS Source|Statistic|{Delimiter}|{SortOrder}

This rule can be configured on any field type, but a String field must be used if the Concat parameter is selected.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Stores the maximum value of the DIAMETER field for all connected To Edges features into the MAXDIAM field in the wHydrants layer:

  • Table Name: wHydrants
  • Field Name: MAXDIAM
  • Value Info: DIAMETER|Max

Stores a comma-delimited string of all DIAMETER values:

  • Table Name: wHydrants
  • Field Name: MAXDIAM
  • Value Info: DIAMETER|Concat

Stores a semicolon-delimited string, sorted in descending order:

  • Table Name: wHydrants
  • Field Name: DIAMETER
  • Value Info: DIAMETER|Concat|;|DESC


To Junction Field

Copies a value from a connected To Junction feature to a connected edge feature. Can also copy the name of the feature class at the end of the currently edited line.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Line feature class participating in a geometric network Field in the line feature layer TO_JUNCTION_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type except when Field is specified as (NAME); in this case, the field type must be String.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field Name The field to copy in the To Junction layer.
(NAME) If specified as (NAME), the feature class name will be used instead of a feature value.
Source (Optional) Layer or feature class If specified, only copy values from features in this layer; otherwise, copy values from all connected To Junction features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only copy features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the name of the feature class that is snapped to the end point of the current line into the ENDPT field of the wMain layer. In this example, the value "Water_Net_Junctions" might be copied to the ENDPT field:

  • Table Name: wMain
  • Field Name: ENDPT
  • Value Info: (NAME)

Copies the value from the FID field in the To Junction layers into the FACILITYID field in the wMain layer:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID

Copies the value from the FID field in the wServiceConnection feature class:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection

Copies the value from the FID field in the wServiceConnection feature class where the SVCTYPE field value is Domestic:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection|SVCTYPE|Domestic


Trigger Attribute Assistant Event From Edge

Triggers the Attribute Assistant for the From Edge feature. Event is triggered after all rules are processed on the triggering feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to monitor for changes TRIGGER_AAEVENT_FROM_EDGE Event Type

Parameters

The method parameters are as follows:

Parameter Value Description
Event Type CREATE Triggers the Attribute Assistant Create event on the From Edge.
CHANGEGEO Triggers the Attribute Assistant Geometry Change event on the From Edge.
CHANGE Triggers the Attribute Assistant Change event on the From Edge.

Examples

Monitors the OFFSET field in the wMain layer for changes and triggers create rules on all From Edges:

  • Table Name: wMain
  • Field Name: OFFSET
  • Value Info: CREATE


Trigger Attribute Assistant Event From Junction

Triggers the Attribute Assistant for the From Junction feature. Event is triggered after all rules are processed on the triggering feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to monitor for changes TRIGGER_AAEVENT_FROM_JUNCTION Event Type

Parameters

The method parameters are as follows:

Parameter Value Description
Event Type CREATE Triggers the Attribute Assistant Create event on the From Junction.
CHANGEGEO Triggers the Attribute Assistant Geometry Change event on the From Junction.
CHANGE Triggers the Attribute Assistant Change event on the From Junction.

Examples

Monitors the OFFSET field in the wMain layer for changes and triggers create rules on all From Junctions:

  • Table Name: wMain
  • Field Name: OFFSET
  • Value Info: CREATE


Trigger Attribute Assistant Event Intersecting Feature

Triggers the Attribute Assistant for the intersecting features. Event is triggered after all rules are processed on the triggering feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to monitor for changes TRIGGER_AAEVENT_INTERSECTING_FEATURE Input|Event Type

Parameters

The method parameters are as follows:

Parameter Value Description
Input String List of layers to search for intersecting features in the format layer1,layer2,etc.
Event Type CREATE Triggers the Attribute Assistant Create event on the intersecting features.
CHANGEGEO Triggers the Attribute Assistant Geometry Change event on the intersecting features.
CHANGE Triggers the Attribute Assistant Change event on the intersecting features.

Examples

Monitors the DIAMETER field in the wMain layer for changes and triggers create rules on all intersecting features:

  • Table Name: wMain
  • Field Name: DIAMETER
  • Value Info: CREATE


Trigger Attribute Assistant Event To Edge

Triggers the Attribute Assistant for the To Edge feature. Event is triggered after all rules are processed on the triggering feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to monitor for changes TRIGGER_AAEVENT_TO_EDGE Event Type

Parameters

The method parameters are as follows:

Parameter Value Description
Event Type CREATE Triggers the Attribute Assistant Create event on the To Edge.
CHANGEGEO Triggers the Attribute Assistant Geometry Change event on the To Edge.
CHANGE Triggers the Attribute Assistant Change event on the To Edge.

Examples

Monitors the OFFSET field in the wMain layer for changes and triggers create rules on all To Edges:

  • Table Name: wMain
  • Field Name: OFFSET
  • Value Info: CREATE


Trigger Attribute Assistant Event To Junction

Triggers the Attribute Assistant for the To Junction feature. Event is triggered after all rules are processed on the triggering feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field to monitor for changes TRIGGER_AAEVENT_TO_JUNCTION Event Type

Parameters

The method parameters are as follows:

Parameter Value Description
Event Type CREATE Triggers the Attribute Assistant Create event on the To Junction.
CHANGEGEO Triggers the Attribute Assistant Geometry Change event on the To Junction.
CHANGE Triggers the Attribute Assistant Change event on the To Junction.

Examples

Monitors the OFFSET field in the wMain layer for changes and triggers create rules on all To Junctions:

  • Table Name: wMain
  • Field Name: OFFSET
  • Value Info: CREATE


Update From Edge Field

Copies a field value from a junction to a connected From Edge feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Point feature class participating in a geometric network Field in the junction feature layer UPDATE_FROM_EDGE_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to update in the From Edge layer.
Source (Optional) Layer or feature class If specified, only update values from features in this layer; otherwise, update values from all connected From Edge features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only update features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FID field in the wServiceConnection layer into the FACILITYID field in the From Edge layers:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID

Copies the value into the FACILITYID field in the wMain layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain

Copies the value into the FACILITYID field in the wMain layer where the SVCTYPE field value is Domestic:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain|SVCTYPE|Domestic


Update From Junction Field

Copies a field value from a connected edge to a connected From Junction feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Line feature class participating in a geometric network Field in the line feature layer UPDATE_FROM_JUNCTION_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to update in the From Junction layer.
Source (Optional) Layer or feature class If specified, only update values from features in this layer; otherwise, update values from all connected From Junction features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only update features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FACILITYID field in the wMain layer into the FID field in the From Junction layers:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID

Copies the value into the FID field in the wServiceConnection layer:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection

Copies the value into the FID field in the wServiceConnection feature class where the SVCTYPE field value is Domestic:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection|SVCTYPE|Domestic

FACILITYID


Update Intersecting Feature

Updates a field in an intersecting feature with a value or a field value from the modified or created feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class to monitor for changes Blank or null UPDATE_INTERSECTING_FEATURE Target|Target Field|Source Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Target Layer or feature class Layer or layers containing features that intersect the original updated feature. List multiple layers in the format layer1,layer2,etc.
Target Field Field name Field in the Target layers into which a value will be copied. Only one Target Field may be defined, so a common field name is required for multiple Target layers.
Source Field Value or field name Value or field in Table Name that will be copied into the Target Field.

Examples

Monitors the project layer for changes; when the feature's geometry or attribute values are changed, copy the value of the STATUS field in the project layer to the PROJSTATUS field in all intersecting features in the sites layer:

  • Table Name: project
  • Field Name: <Null>
  • Value Info: sites|PROJSTATUS|STATUS

Copies 0 to the STATUS field in all intersecting features in the sites, structures, and boundaries layers:

  • Table Name: project
  • Field Name: <Null>
  • Value Info: sites,structures,boundaries|PROJSTATUS|0


Update Linked Record

Finds the related records in another table or layer and updates a field in those records.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class to monitor for changes The field to monitor and copy UPDATE_LINKED_RECORD Target|Target Field|Primary Key|Foreign Key

This rule can be configured on any field type. This method cannot be triggered from the Attribute Assistant toolbar.

Parameters

The method parameters are as follows:

Parameter Value Description
Target Layer or feature class Related table into which the values will be copied.
Target Field Field name The field to populate with the copied record.
Primary Key Field name Source features identifier used in the related table.
Foreign Key Field name Related table field corresponding to the source features.

Examples

Monitors the ADDRESS field in the Parcels layer for changes; when this value is changed, copy it to the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:

  • Table Name: Parcels
  • Field Name: ADDRESS
  • Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID


Update To Edge Field

Copies a field value from a junction to a connected To Edge feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Point feature class participating in a geometric network Field in the junction feature layer UPDATE_TO_EDGE_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to update in the To Edge layer.
Source (Optional) Layer or feature class If specified, only update values from features in this layer; otherwise, update values from all connected To Edge features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only update features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FID field in the wServiceConnection layer into the FACILITYID field in the To Edge layers:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID

Copies the value into the FACILITYID field in the wMain layer:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain

Copies the value into the FACILITYID field in the wMain layer where the SVCTYPE field value is Domestic:

  • Table Name: wServiceConnection
  • Field Name: FID
  • Value Info: FACILITYID|wMain|SVCTYPE|Domestic


Update To Junction Field

Copies a field value from a connected edge to a connected To Junction feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Line feature class participating in a geometric network Field in the line feature layer UPDATE_TO_JUNCTION_FIELD Field|{Source}|{Filter Field}|{Filter Value}

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field Field name The field to update in the To Junction layer.
Source (Optional) Layer or feature class If specified, only update values from features in this layer; otherwise, update values from all connected To Junction features.
Filter Field (Optional) Field name Must be specified in conjunction with Feature Class and Filter Value. If specified, this value filters the Feature Class fields.
Filter Value (Optional) Value Must be specified in conjunction with Feature Class and Filter Field. If specified, only update features having this value in the Filter Field.
Include Feature Class Name (Reserved for future use) Value Option to include the name of the layer in the results dialog box.
Field Index (Optional) Value Option to use the flow direction to determine from and to, and not digitized direction.

Examples

Copies the value from the FACILITYID field in the wMain layer into the FID field in the To Junction layers:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID

Copies the value into the FID field in the wServiceConnection layer:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection

Copies the value into the FID field in the wServiceConnection feature class where the SVCTYPE field value is Domestic:

  • Table Name: wMain
  • Field Name: FACILITYID
  • Value Info: FID|wServiceConnection|SVCTYPE|Domestic


Validate Attribute Lookup

Verifies field values against entries in a lookup table.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field or fields to monitor VALIDATE_ATTRIBUTE_LOOKUP Source|Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Table, layer, or feature class Lookup table.
Field Field name Field name in the lookup table. List multiple fields in the format field1,field2,etc.

Examples

Monitors the NAME and MUNIC fields in the streets layer for changes and verifies that the new values exist in the FULLNAME and MUNICIPALITY fields, respectively, in the MasterStreetName table:

  • Table Name: streets
  • Field Name: NAME,MUNIC
  • Value Info: MasterStreetName|FULLNAME,MUNICIPALITY


Validate Attributes

Compares values in the input fields to all feature templates for the feature class.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Blank or Leave Null VALIDATE_ATTRIBUTES Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Field or fields List of field names List of fields to monitor in the format field1,field2,etc.

Examples

Monitors the DIAMETER, MATERIAL, and LINETYPE fields for changes and verifies that the new values are valid feature template values for the wLateralLines layer:

  • Table Name: wLateralLines
  • Field Name: <Null>
  • Value Info: DIAMETER,MATERIAL,LINETYPE


Validate Connectivity

Validates the number of connections on a feature and rejects the edits if the criteria are not met.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class Field name to provide different valid connection values for each value within this field VALIDATE_CONNECTIVITY Connections

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Connections List number of connections List the number of valid connections separated by |.

Examples

Validates the current feature in the junctions layer to only allow one, two, or four connections:

  • Table Name: junctions
  • Field Name: <Null>
  • Value Info: 1|2|4

Validates the current feature to only allow one or three connections if the value in the TYPE field is Bend. If the TYPE field value is Tap, one or four connections are valid:

  • Table Name: junctions
  • Field Name: TYPE
  • Value Info: Bend,1|Bend,3|Tap,1,4


Validate Domain

Validates data entry on field with domains against the domain. If the value is outside the range or not in the coded value list, the edit is aborted.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field or fields to monitor VALIDATE_DOMAIN Null or Blank

Parameters

There are no parameters for this method.

Examples

Monitors the DIAMETER, MATERIAL, and LINETYPE fields in the wLateralLines layer for changes. If the new value would violate the current domain, the edit does not occur:

  • Table Name: wLateralLines
  • Field Name: DIAMETER,MATERIAL,LINETYPE
  • Value Info: <Null>


X Coordinate

Calculates the x-coordinate of a feature in database units.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class The field in which the value will be stored X_COORDINATE {Location}

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Location (Optional) <Null> (Default) X-coordinate of the centroid of line and polygon features. For point features, this is the point itself.
S X-coordinate of the start point of line and polygon features.
E X-coordinate of the end point of line and polygon features.

Examples

Stores the x-coordinate of the polygon's centroid in the XLOC field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: XLOC
  • Value Info: <Null>

Stores the x-coordinate of polyline's start point:

  • Table Name: ProposedSites
  • Field Name: XLOC
  • Value Info: S


Y Coordinate

Calculates the y-coordinate of a feature in database units.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class The field in which the value will be stored Y_COORDINATE {Location}

This rule can only be configured on Floating or Double fields.

Parameters

The method parameters are as follows:

Parameter Value Description
Location (Optional) <Null> (Default) Y-coordinate of the centroid of line and polygon features. For point features, this is the point itself.
S Y-coordinate of the start point of line and polygon features.
E Y-coordinate of the end point of line and polygon features.

Examples

Stores the y-coordinate of the polygon's centroid in the YLOC field in the ProposedSites layer:

  • Table Name: ProposedSites
  • Field Name: YLOC
  • Value Info: <Null>

Stores the y-coordinate of polyline's start point:

  • Table Name: ProposedSites
  • Field Name: YLOC
  • Value Info: S

Top