Page Comparison

ADD

Adds the values of 2 fields together. If one or both fields are text then fields are concatenated.

ADD(Inventory_Year+Measurement_Frequency) - This example will add the values of Inventory_Year and Measurement_Frequency to calculate the year for the next inventory.

AUTOINCREMENT

Auto-numbers output rows

AUTOINCREMENT - No parameters or parenthesis needed

BASALAREA

Calculates the Basal Area of a tree (in square feet) using the equation (DBH)^2 * 0.005454154;

BASALAREA(DBH) - could calculate the Basal Area of a tree. Assumes that DBH is in inches and BA is desired in square feet.

DIVIDE

Divide the value of one field by the value of another field

DIVIDE(Total_Height,DBH) - this example could calculate the height to diameter ratio for each tree to be used to detect outliers.

EXCLUDE

Exclude records based on some attribute value. Note, this has only been implemented for Trees so far.

EXCLUDE(Cut_Leave:Cut) - this example will exclude any trees for which the ‘Cut_Leave’ field contains a value of ‘Cut’

FVSGROUPS

Calculate the ‘Groups’ field in the ‘FVS_StandInit' table of the FVS SQLite database export. The groups value will always contain the phrase 'All_Stands’. Adding this function can include additional groups based on hard-coded values or the values of any field(s)

FVSGROUPS(variant=SN;Cover_Type={Cover_Type};) - this example would include the following groups:

• All_Stands

• variant

• Cover_Type

LOOKUP

Lookup values from list - if the export value should come from a list of allowed values, but that list does not match the Coded Value Domain list for that field, a custom lookup table can be provided in the config file.

LOOKUP(Cruise_Type:S=0;C=1) - This example will transform the values of the field ‘Cruise_Type’ in the Trees table (with domain values of S for standard cruise and C for check cruise) needs to match the values needed in the RECTYP field used by TCruise. It will replace all instances of ‘S' with the value 0, and all instances of 'C' with the value 1.

LOOKUP(Length:0.5=8;1=16;1.5=24;) - This example could be used to translate between log lengths recorded in 1/2 logs (e.g., 0.5, 1, 1.5,…) to feet (e.g., 8, 16, 24,…).

MAX

Return the maximum value of the selected attribute values

MAX(Defect_1;Defect_2;Defect_3) - this example could calculate the maximum amount of defect when tree defect is recorded per third of each tree.

MIN

Return the minimum value of the selected attribute values

MIN(Reference_Tree_Distance_1;Reference_Tree_Distance_2) - this example could calculate the distance to the closest reference tree for a plot.

MULTIPLY

Multiply the values of two fields together

MULTIPLY(Plot_Length,Plot_Width) - this example could calculate the area of a rectangular plot in square feet when the Plot_Length field and the Plot_Width fields are entered by a cruiser in feet.

PLOTS.

Lookup value from an existing or new field in the Plots layer

PLOT.Plot_Size - this example could populate a Strata field in an output Plots table with the Strata value of that Plot’s parent Stand.

POWER

Calculate the power (exponent) of an attribute value

POWER(Plot_Width;2) - this example could calculate the area of a square plot when the plot width is stored in an attribute field. Note that this would not convert units, so this would only be appropriate if the width was in Feet and you want the area in Square Feet.

SQRT

Calculate the square root of of an attribute value

SQRT(Area) - this example could calculate the width of a square plot when the plot area is stored in an attribute field. Note that this would not convert units, so this would only be appropriate if the area was in Square Feet and you want the width in Feet.

STANDS.

Lookup value from an existing or new field in the Stands layer

STANDS.Strata - this example could populate a Strata field in an output Plots table with the Strata value of that Plot’s parent Stand.

SUBTRACT

Subtract the values of 1 field from the value of another field.

SUBTRACT(Inventory_Year-Origin_Year) - this example could calculate a stand ‘Age’ field as the origin subtracted from the cruise year.

TREES.

Lookup value from an existing or new field in the Trees layer

TREES.Species- this example could populate a Species field in an output Trees table with the Species value of that Log’s parent Tree.

YEAR

Return the 4 character year value for a date that is stored using an Esri Date field (unix timestamp)

YEAR(Cruise_Date) - this example would return the inventory year when Cruise_Date field stores an Esri Date value for the date of the cruise (typically at Stand or Plot level)

Note this is just the calendar year, not a tree growth year.