SAGA.table_calculus.2: Field Calculator [Shapes]

The table calculator calculates a new attribute from existing attributes based on a mathematical formula. Attributes are addressed by the character 'f' (for 'field') followed by the field number (i.e.: f1, f2, ..., fn) or by the field name in square brackets (e.g.: [Field Name]).<br/>Examples:<br/>- sin(f1) * f2 + f3<br/>- [Population] / [Area]<br/><br/>If the use no-data flag is unchecked and a no-data value appears in a record's input, no calculation is performed for it and the result is set to no-data.<br/><br/>Following operators are available for the formula definition:<br/><table border="0"><tr><td><b>+</b></td><td>Addition</td></tr><tr><td><b>-</b></td><td>Subtraction</td></tr><tr><td><b>*</b></td><td>Multiplication</td></tr><tr><td><b>/</b></td><td>Division</td></tr><tr><td><b>abs(x)</b></td><td>Absolute Value</td></tr><tr><td><b>mod(x, y)</b></td><td>Returns the floating point remainder of x/y</td></tr><tr><td><b>int(x)</b></td><td>Returns the integer part of floating point value x</td></tr><tr><td><b>sqr(x)</b></td><td>Square</td></tr><tr><td><b>sqrt(x)</b></td><td>Square Root</td></tr><tr><td><b>exp(x)</b></td><td>Exponential</td></tr><tr><td><b>pow(x, y)</b></td><td>Returns x raised to the power of y</td></tr><tr><td><b>x ^ y</b></td><td>Returns x raised to the power of y</td></tr><tr><td><b>ln(x)</b></td><td>Natural Logarithm</td></tr><tr><td><b>log(x)</b></td><td>Base 10 Logarithm</td></tr><tr><td><b>pi()</b></td><td>Returns the value of Pi</td></tr><tr><td><b>sin(x)</b></td><td>Sine</td></tr><tr><td><b>cos(x)</b></td><td>Cosine</td></tr><tr><td><b>tan(x)</b></td><td>Tangent</td></tr><tr><td><b>asin(x)</b></td><td>Arcsine</td></tr><tr><td><b>acos(x)</b></td><td>Arccosine</td></tr><tr><td><b>atan(x)</b></td><td>Arctangent</td></tr><tr><td><b>atan2(x, y)</b></td><td>Arctangent of x/y</td></tr><tr><td><b>min(x, y)</b></td><td>Returns the minimum of values x and y</td></tr><tr><td><b>max(x, y)</b></td><td>Returns the maximum of values x and y</td></tr><tr><td><b>gt(x, y)</b></td><td>Returns true (1), if x is greater than y, else false (0)</td></tr><tr><td><b>x > y</b></td><td>Returns true (1), if x is greater than y, else false (0)</td></tr><tr><td><b>lt(x, y)</b></td><td>Returns true (1), if x is less than y, else false (0)</td></tr><tr><td><b>x < y</b></td><td>Returns true (1), if x is less than y, else false (0)</td></tr><tr><td><b>eq(x, y)</b></td><td>Returns true (1), if x equals y, else false (0)</td></tr><tr><td><b>x = y</b></td><td>Returns true (1), if x equals y, else false (0)</td></tr><tr><td><b>and(x, y)</b></td><td>Returns true (1), if both x and y are true (i.e. not 0)</td></tr><tr><td><b>or(x, y)</b></td><td>Returns true (1), if at least one of both x and y is true (i.e. not 0)</td></tr><tr><td><b>ifelse(c, x, y)</b></td><td>Returns x, if condition c is true (i.e. not 0), else y</td></tr><tr><td><b>rand_u(x, y)</b></td><td>Random number, uniform distribution with minimum x and maximum y</td></tr><tr><td><b>rand_g(x, y)</b></td><td>Random number, Gaussian distribution with mean x and standard deviation y</td></tr><tr><td><b>nodata()</b></td><td>Returns tables's no-data value</td></tr><tr><td><b>isnodata(x)</b></td><td>Returns true (1), if x is a no-data value, else false (0)</td></tr></table>

Inputs

Shapes

format
href
Please set a value for TABLE.

Field

format
href
Please set a value for FIELD.

Field Name

string

Formula

string

Selection

boolean

Use No-Data

boolean

Outputs

Result

format
transmission

Execution options

successUri
inProgressUri
failedUri

format

mode

Execute End Point

View the execution endpoint of a process.

View the alternative version in HTML.

{"id": "SAGA.table_calculus.2", "title": "Field Calculator [Shapes]", "description": "The table calculator calculates a new attribute from existing attributes based on a mathematical formula. Attributes are addressed by the character 'f' (for 'field') followed by the field number (i.e.: f1, f2, ..., fn) or by the field name in square brackets (e.g.: [Field Name]).<br/>Examples:<br/>- sin(f1) * f2 + f3<br/>- [Population] / [Area]<br/><br/>If the use no-data flag is unchecked and a no-data value appears in a record's input, no calculation is performed for it and the result is set to no-data.<br/><br/>Following operators are available for the formula definition:<br/><table border=\"0\"><tr><td><b>+</b></td><td>Addition</td></tr><tr><td><b>-</b></td><td>Subtraction</td></tr><tr><td><b>*</b></td><td>Multiplication</td></tr><tr><td><b>/</b></td><td>Division</td></tr><tr><td><b>abs(x)</b></td><td>Absolute Value</td></tr><tr><td><b>mod(x, y)</b></td><td>Returns the floating point remainder of x/y</td></tr><tr><td><b>int(x)</b></td><td>Returns the integer part of floating point value x</td></tr><tr><td><b>sqr(x)</b></td><td>Square</td></tr><tr><td><b>sqrt(x)</b></td><td>Square Root</td></tr><tr><td><b>exp(x)</b></td><td>Exponential</td></tr><tr><td><b>pow(x, y)</b></td><td>Returns x raised to the power of y</td></tr><tr><td><b>x ^ y</b></td><td>Returns x raised to the power of y</td></tr><tr><td><b>ln(x)</b></td><td>Natural Logarithm</td></tr><tr><td><b>log(x)</b></td><td>Base 10 Logarithm</td></tr><tr><td><b>pi()</b></td><td>Returns the value of Pi</td></tr><tr><td><b>sin(x)</b></td><td>Sine</td></tr><tr><td><b>cos(x)</b></td><td>Cosine</td></tr><tr><td><b>tan(x)</b></td><td>Tangent</td></tr><tr><td><b>asin(x)</b></td><td>Arcsine</td></tr><tr><td><b>acos(x)</b></td><td>Arccosine</td></tr><tr><td><b>atan(x)</b></td><td>Arctangent</td></tr><tr><td><b>atan2(x, y)</b></td><td>Arctangent of x/y</td></tr><tr><td><b>min(x, y)</b></td><td>Returns the minimum of values x and y</td></tr><tr><td><b>max(x, y)</b></td><td>Returns the maximum of values x and y</td></tr><tr><td><b>gt(x, y)</b></td><td>Returns true (1), if x is greater than y, else false (0)</td></tr><tr><td><b>x > y</b></td><td>Returns true (1), if x is greater than y, else false (0)</td></tr><tr><td><b>lt(x, y)</b></td><td>Returns true (1), if x is less than y, else false (0)</td></tr><tr><td><b>x < y</b></td><td>Returns true (1), if x is less than y, else false (0)</td></tr><tr><td><b>eq(x, y)</b></td><td>Returns true (1), if x equals y, else false (0)</td></tr><tr><td><b>x = y</b></td><td>Returns true (1), if x equals y, else false (0)</td></tr><tr><td><b>and(x, y)</b></td><td>Returns true (1), if both x and y are true (i.e. not 0)</td></tr><tr><td><b>or(x, y)</b></td><td>Returns true (1), if at least one of both x and y is true (i.e. not 0)</td></tr><tr><td><b>ifelse(c, x, y)</b></td><td>Returns x, if condition c is true (i.e. not 0), else y</td></tr><tr><td><b>rand_u(x, y)</b></td><td>Random number, uniform distribution with minimum x and maximum y</td></tr><tr><td><b>rand_g(x, y)</b></td><td>Random number, Gaussian distribution with mean x and standard deviation y</td></tr><tr><td><b>nodata()</b></td><td>Returns tables's no-data value</td></tr><tr><td><b>isnodata(x)</b></td><td>Returns true (1), if x is a no-data value, else false (0)</td></tr></table>", "version": "1.0.0", "jobControlOptions": ["sync-execute", "async-execute", "dismiss"], "outputTransmission": ["value", "reference"], "links": [{"rel": "http://www.opengis.net/def/rel/ogc/1.0/execute", "type": "application/json", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_calculus.2/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_calculus.2/execution.html"}], "inputs": {"TABLE": {"title": "Shapes", "description": "Shapes", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/xml", "application/vnd.google-earth.kml+xml", "application/json"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/xml"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "application/vnd.google-earth.kml+xml"}, {"type": "object"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/xml"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "application/vnd.google-earth.kml+xml"}, {"type": "object"}]}, "id": "TABLE"}, "FIELD": {"title": "Field", "description": "Field", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}], "nullable": true}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "FIELD"}, "NAME": {"title": "Field Name", "description": "Field Name", "schema": {"type": "string", "default": "Calculation", "nullable": true}, "id": "NAME"}, "FORMULA": {"title": "Formula", "description": "Formula", "schema": {"type": "string", "default": "f1 + f2", "nullable": true}, "id": "FORMULA"}, "SELECTION": {"title": "Selection", "description": "Selection", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "SELECTION"}, "USE_NODATA": {"title": "Use No-Data", "description": "Use No-Data", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "USE_NODATA"}}, "outputs": {"RESULT": {"title": "Result", "description": "Result", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/xml", "application/vnd.google-earth.kml+xml", "application/json"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/xml"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "application/vnd.google-earth.kml+xml"}, {"type": "object"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/xml"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "application/vnd.google-earth.kml+xml"}, {"type": "object"}]}, "id": "RESULT"}}}

http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_calculus.2.html
Last modified: Sat Feb 19 15:43:34 CET 2022