Computed Fields

More Documentation

Computed Numeric Fields

Counts attached elements: For each record, the expression gets associated elements and counts the number of records attached to the same elements in the specified table. num_attached.qry
Gets another field in the same record: Returns number based on contents of another field in the same table. buffer1.qry
Gets another field in the same record: Returns a number based on contents of another field in the same table. variablebufferzones.qry
Gets attached records in another table: If used in Implied one-to-one table, expression is computed for every element: it gets all records in the MUYLD table that are attached to that element and adds the yield value (in nirryld field). MultiRecord_Soil_Yield.qry
Returns sum of area of attached polygons: For every record in the table, the expression gets attached polygons, finds all records in the POLYSTATS table attached to the them, and computes the sum of the area for them. MultiRecord_soilsum.qry

CBSOILS_Lite    Sample Data:  CBSOILS_Lite.zip

Counts attached elements: Returns the number of polygons associated with the current record in the table you added the computed field to. This works because the POLYSTATS table has one record for every polygon. So for every record (in the computed field table) it looks for elements associated with it. Then it counts all the records in the POLYSTATS table that are associated with those same element(s). CBSOILS_Count.qry
Counts attached elements: Returns the number of polygons attached to each record. The CLASS table has some records attached to more than one polygon. The script assumes every value in CLASS.Class field is unique. countAttachedPolygons.qry
Counts attached elements: Returns the number of polygons associated with the current record in the table you added the computed field to. Multi_CompFields_Count.qry
Returns area of largest attached polygon: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the area of the largest polygon. CBSOILS_Max_Area.qry
Returns area of smallest attached polygon: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the area of the smallest polygon. CBSOILS_Min_Area.qry
Returns average area of attached polygons: Add this as a new computed field to the CLASS table. For every record in the CLASS table, it gets associated elements, finds records in the POLYSTATS table associated with the same elements, and returns the average area. Multi_CompFields_Average.qry
Returns mean area of attached polygons: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the mean area. CBSOILS_Mean_Area.qry
Returns standard deviation of area of attached polygons: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the standard deviation of the area. CBSOILS_StdDev_Area.qry
Returns sum of area for all attached elements: Add as new computed field to CLASS table. For every record in the CLASS table, look at all attached elements, and return the sum of the areas. CBSOILS_Area.qry
Returns sum of area of attached polygons: Add this as a new computed field to the CLASS table. For every record in the CLASS table, it gets associated elements, finds records in the POLYSTATS table associated with the same elements, and returns the sum of the area. Multi_CompFields_AreaSum.qry

Computed Text Fields

Multi–line datatip for each element: Add computed field to a new Implied one-to-one table so the expression is run for every element. Gets all attached records, finds field with highest value along with other fields to create a string. This field can be used as a mult-line data tip, which is set in Vector Layer Controls. MultiRecord_DataTipMultiAttRecord.qry