Transform Templates (All field types) Expression  allows specifying an expression of the type compatible with the field and filling the field with the result. (Binary fields) Copy  copies binary data / number of bytes. (Boolean fields) Copy  copies boolean value. (Boolean fields) Logic  performs a logical operation: not / and / or / xor. (Date fields) Copy  copies date and time / date without time / year / year day / month / week / week day / day / hour / minute / second / millisecond. For week numbers and week days, there is an option to select the week start. (Geometry fields) Buffer  computes a buffer with the specified distance (positive = outer buffer, negative = inner buffer). The distance is specified in units compatible with the coordinate system of the field. (If the field has no coordinate system attached, the default pseudoMercator coordinate system is assumed, as always.) (Geometry fields) Center  computes a center: circle / inner (area) / weight (area). (Geometry fields) Clean  performs maintenance operations on the metric: normalize metric / remove curves / convert curves to lines / remove z / fill z / fill missing z. Fill missing Z has no effect on geometry values which already have Z. Convert curves to lines allows specifying the maximum number of coordinates generated per curve (curve limit, the default is 50) and the tolerance value (the default is 0 = auto). Normalize metric allows specifying the tolerance value. The tolerance value is specified in units compatible with the coordinate system of the field. (Geometry fields) Clip  clips geometry with areas from a secondary drawing. If there is no secondary drawing available (eg, we are working from a table window or from a map that contains only one drawing layer), the clip with parameter is empty and the transform will fail. There is an option to limit the clip drawing to only the selected records. There is an option to keep either the inner (checked, the default) or the outer part of the clip. (Geometry fields) Convert  converts geometry to a different type: area / line / point. (Geometry fields) Copy  copies geometry / branch / coordinate x or y or z or xy or xyz / type / number of branches / number of coordinates / number of curves / area / bearing / length / minimum or maximum x or y or z. There is an option to control computations of area / bearing / length (Measure, see the description of the Search select template for geometry values). Area / length allow specifying a metric unit, bearing allows specifying an angular unit. Branch allows specifying the branch number, zerobased. Coordinate allows specifying the coordinate number, zerobased, and the counting direction (count from start or end). (Geometry fields) Enclose  computes enclosing geometry: rectangle / rectangle with rotation / circle / convex hull. (Geometry fields) Interpolate  interpolates geometry values into an image. Available interpolation options: triangulation / triangulation with segments / gravity / Kriging / Kriging with medial polish / Kriging with regression. Z values can be taken from a numeric field or directly from geometry values (the default). There is an option to specify resolution of the produced image, in units compatible with the coordinate system of the geometry field. For triangulation with segments, there is an option to remove flat areas using DEST (on by default). For gravity and Kriging, there are options to specify margins (the default is 0), radius (the default is 0 = auto), number of neighbors (the default is 0 = use Voronoi neighbors), step (the default is 0 = auto), model (the default is auto) and regression (the default is auto). The result is always a new table and a new image. (Geometry fields) Merge  merges geometry values together into: area (dissolve) / center / center inner (area) / center weight (area) / circle / convex hull / line / points / rectangle / rectangle with rotation. There is an option to specify a group field (none by default = group all geometry into a single value). The result is always a new table and a new drawing. Values in numeric fields are aggregated using Sum, values in nonnumeric fields are aggregated using FirstNonNull (see the descriptions of added query functions). It is always possible to use different or more aggregates by using a Join dialog after the transform. (Geometry fields) Rehsape  applies a simple transform to geometry values: shift / scale / unscale / rotate / reverse / flip horizontal / flip vertical / smooth / snap to grid. Rotation angle is specified in angular units. Shift amounts and grid steps are specified in units compatible with the coordinate system of the field. Smooth uses a tolerance value specified in units compatible with the coordinate system of the field. (Geometry fields) Split  splits geometry values into: shapes / shapes (ESRI nonOGC) / branches / convex parts / coordinates / coordinates with step / segments / triangles. The two shapes options differ in normalization rules for areas: the 'shapes' option uses OGC rules and the 'shapes (ESRI nonOGC)' option uses rules required by some ESRI products that are different from those mandated by OGC. The coordinates with step option is used to put equally spaced coordinates onto lines, and allows specifying the starting, ending and step distances in units compatible with the coordinate system of the drawing. To cover whole lines, set the end distance to an unreachable value, eg, 1000000 meters, computations handle this efficiently. The result is always a new table and a new drawing. (Geometry fields) Topology  perform maintenance operations on topology. The only available option is currently: clean (generalize). We will likely add more options in the future for correcting specific types of issues. The result is always a new table and a new drawing. (The number of returned records currently coincides with the number of original records so the current transform could technically be made to update an existing table. We don't offer that option because we will likely adjust the transform to split records as necessary which would make putting the result into the new table mandatory.) (Geometry fields) Trace  traces bounded areas from existing geometry values. (This was previously called Bounded Areas. We changed the name because we will likely add other options in the future.) The result is always a new table and a new drawing. (Geometry fields) Triangulate  triangulates points and produces: areas / lines. The result is always a new table and a new drawing. (Geometry fields) Voronoi  computes Voronoi diagram and produces: areas / lines / points. There is an option to specify margin in units compatible with the coordinate system of the drawing. (Numeric fields) Arithmetic  performs an arithmetic operation: add / subtract / subtract from / multiply / divide / divide integral / divide remainder / square / square root / cube / cube root / power / reciprocal / absolute value / sign / sign invert / exponent / exponent binary / exponent decimal / logarithm / logarithm binary / logarithm decimal / error / error complement / gamma / gamma logarithm. (Numeric fields) Bit Logic  performs a bit logic operation: not / and / or / xor. Bit logic operations are 32bit, all bits higher than that are lost. (Numeric fields) Copy  copies numeric values. (Numeric fields) Hyperbolic  computes a hyperbolic function: hyperbolic sine / cosine / tangent / arc sine / arc cosine / arc tangent. There is an option to specify an angular unit. (Numeric fields) Round  rounds numeric values: to nearest / to zero / down / up. There is an option to round to values other than 1: 10 / 100 / etc, or 0.1 / 0.01 / etc. (Numeric fields) Special  computes a special function: Bessel, 1st or 2nd kind, with the specified order. (Numeric fields) Trigonometric  computes a trigonometric function: sine / cosine / tangent / arc sine / arc cosine / arc tangent. There is an option to specify an angular unit. (Numeric vector fields) Copy  copies vector value / value N (0 to 3 depending on the type). (Text fields) Case  converts text values to: lower / title / upper case. There is an option to specify the collation, the default is 'neutral, nocase'. (Text fields) Concatenate  concatenates text values adding a new value either at end or start. There is an option to specify the separator (an empty string by default), which is used if both concatenated values are not empty. (Example: add a value to a list of values, adding a ',' if the list is not empty.) (Text fields) Copy  copies text / number of characters. (Text fields) Encrypt  encrypts or decrypts text values using specified password. (Text fields) Pad  pads text values adding characters at end or start until the text value has the specified length. There is an option to specify the repeat pattern (eg, '.' or ' '). (Text fields) Reduce  reduces text values to: start / end / cut / cut to end / regular expression occurrence. For start / end, specify the number of characters to keep. For cut to end, specify the starting character. For cut, specify the starting character as well as the number of characters to keep. For regular expression occurrence, specify the regular expression and the occurrence to take, zerobased. For regular expression there is also an option to ignore case. (Text fields) Replace  replaces: text / text occurrence / regular expression / regular expression occurrence. For text replaces, there is an option to specify the collation, the default is 'neutral, nocase'. For regular expression replaces, there is an option to ignore case. (Text fields) Reverse  reverses text values. (Text fields) Trim  trims text values at: start and end / start / end. The trimmed characters can be: whitespace / whitespace and custom / custom, with custom characters to trim specified in the transform. (Tile fields) Arithmetic  performs an arithmetic operation on the specified channel: add / subtract / subtract from / multiply / divide / divide integral / divide remainder / square / square root / cube / cube root / power / reciprocal / absolute value / sign / sign invert / exponent / exponent binary / exponent decimal / logarithm / logarithm binary / logarithm decimal / error / error complement / gamma / gamma logarithm. (If the tile field contains multiple channels, the result has to be written into a different field.) (Tile fields) Contour  computes contours on the specified channel and outputs: area / line. The Full Range button sets the start and end values for the height range to the approximate range computed for the image. There is an option to round start and end values to the step (on by default). For start = 112, end = 390, step = 100, without rounding the contours will be produced for 112, 212, 312. With rounding, the contours will be produced for 200 and 300. There is an option to split produced geometry into shapes (on by default). The result is always a new table and a new drawing. (Tile fields) Copy  copies pixels / channel / number of pixels / number of missing pixels / number of channels / x or y size / channel statistic (average, minimum, maximum, etc). When copying a single channel, the transform can put the result into a specific channel of any tile field of the same size. (Tile fields) Filter  filters the specified channel using: average / blur / blur direction / blur gaussian / count / diversity / diversity index / edges / edges direction / major / maximum / median / minimum / sharpen / std deviation / std deviation pop / sum / variance / variance pop. All filters allow specifying the radius (the default is 1). Many filters also allow specifying shape: square / circle / diamond / cross. Some filters also allow specifying the center value, direction filters allow specifying the direction angle. (The result of the transform does not have to be put into a new table or even into a new field. If the tile field contains a single channel, the result can be put back into it. This applies to several other transforms which previously could only put the result into new components.) (Tile fields) Hyperbolic  computes a hyperbolic function on the specified channel: hyperbolic sine / cosine / tangent / arc sine / arc cosine / arc tangent. There is an option to specify an angular unit. (Tile fields) Path  computes paths on the specified channel from or to specified points using: Euclidean / cost / cost for slope. Euclidean paths allow using barriers (off by default). Cost paths allow forcing each pixel to have the same cost (otherwise the cost is taken from the channel value). Cost for slope paths compute costs based on slopes: the only allowed slopes are those between low slope and high slope, there are costs specified for the low slope / flat slope / high slope, costs for intermediate slopes are interpolated linearly. Since costs for slopes depend on which direction the path is traversed, there is an option to reverse path = trace paths not from the specified points, but rather towards them. The points to compute paths from are specified as a drawing, there is an option to use only the selected points. The output of the transform can be: value / direction / distance. For value, the pixels in the produced image contain a numeric identifier of the closest point. This identifier can be taken from a field or be assigned sequentially (the default). (Tile fields) Round  rounds values in the specified channel: to nearest / to zero / down / up. There is an option to round to values other than 1: 10 / 100 / etc, or 0.1 / 0.01 / etc. (Tile fields) Slope  computes a slope or a similar function on the specified channel: slope / aspect / gaussian curvature / mean curvature / plan curvature / profile curvature. All functions allow specifying the radius (the default is 1). Slope and aspect allow specifying the unit: angular for aspect, angular + grade for slope. (Tile fields) Special  computes a special function on the specified channel: Bessel, 1st or 2nd kind, with the specified order. (Tile fields) Trace  traces areas on all channels of the tile field. There is an option for the similarity level (the default is 10, the value heavily depends on the data used). There is an option to split the output into shapes (on by default). The result is always a new table and a new drawing. (Tile fields) Trigonometric  computes a trigonometric function on the specified channel: sine / cosine / tangent / arc sine / arc cosine / arc tangent. There is an option to specify an angular unit. (Tile fields) Watershed  computes watersheds on the specified channel: lines / downstream lines / upstream lines / areas / areas for sinks / upstream areas. There is an option to specify the channel with the precipitation amounts (the default is none = all pixels are assumed to have equal precipitation). Downstream and upstream objects require specifying starting points as a drawing. There is an option to use only the selected points. There is an option to keep overlaps for downstream and upstream objects. Some options allow specifying the value for the minimum flow to limit the number of created objects (the default is 100). The result is always a new table and a new drawing. (Tile fields) Watershed Prepare  prepares the specified channel for computing watersheds by filling sinks. There are options to specify fill height (the default is 0 = no limit) and fill flow (the default is 0 = no limit). (Uuid fields) Copy  copies uuid values.
