Analysis tools - SQL

Network services
Modules

General tools

Measurement tools
Drawing tools

Geometry tools

Functions common to different types of geometry

Functions for the polygon layer

Functions for the line layer

Functions for a point layer

Analytical tools

Operations on columns

Operations on objects

Operations on one record

Attribute table

Layer and group properties

Project properties

Tutorials

Operations on column values

Convert a column value to text

This function allows you to select columns with integers, floating point numbers and columns with a date format and convert them to a text column.

Change a column value to an integer

The function allows you to select text columns and convert them to a column of integers. If the record value cannot be converted, it will be deleted

Change a column value to a decimal number

This function allows you to select text columns and convert them to a column of floating point numbers. If the record value cannot be converted, it will be deleted

Operations on columns

Capital letters

’a’ returns 'A’

Convert letters to lowercase

’A’ returns 'a’

Return the length of the text

The function allows you to select text columns and count the number of characters in a cell

Round a floating point number up

The function rounds numbers up so 10.9876 is 11

Round a floating point number down

The function rounds numbers down so 10.9876 is 10

Round to the specified number of decimal places

If the value is positive, the number is rounded to the specified number of decimal places, (10.9934,2) – returns 10.99, (10.9964,2) – returns 11.00. If the number is negative, the entered value is rounded to the left of the decimal point, (111.0, -2) returns 100.00

Position

Returns the position of the first occurrence of the specified substring in the specified string. If the specified substring is not found, the result is 0. (’boat’, 'Sailboat’) – the result is 5. (’motor’, 'Sailboat’) – the result is 0.

Search for text string - Returns part of a string value

Search for a text string – returns part of a string value Returns part of a string value is an integer index specifying where the returned characters begin and <length> is the number of characters returned (Sailboat, 5,4) -> boat

Trim

This function allows you to cut a given word from the columns

This function allows you to cut a given word from the columns

Changes the selected string of characters, e.g. „w” to another selected string, e.g. „s”

Return a piece of text containing n characters from the left

(5) this will return the first 5 characters from the left

Return a piece of text containing n characters from the right

(5) this will return the last 5 characters from the right

Mathematical operators on columns

Math functions, addition, subtraction, multiplication, division on columns

Mathematical operators on numbers

Math functions – add an integer, multiply by an integer, expose to an integer, divide by an integer

Operations on objects

Calculate the area

The function allows you to calculate the area

Calculate the perimeter

The function allows you to calculate the circumference

Return the X coordinate of the current object

The function allows you to return the value of the X coordinate

Return the y coordinate of the current object

The function allows you to return the value of the Y coordinate

Return the smallest value of the X coordinate

The function allows you to return the smallest value of the X coordinate

Return the largest value of the X coordinate

The function allows you to return the largest value of the X coordinate

Return the smallest value of the Y coordinate

The function allows you to return the smallest value of the Y coordinate

Return the largest value of the Y coordinate

The function allows you to return the largest value of the Y coordinate

Calculate the vertices

Create an integer column with the number of vertices of the selected objects

4. Operations on one record

Minimum distance to the subject

For geometry types, returns the minimum 2D Cartesian (planar) distance between two geometries

Greatest distance between geometries

For geometry types, returns the maximum 2D (planar) Cartesian distance between two geometries

Distance between geometry centroids

Distance between geometry centroids

Distance between geometry bounding boxes (smallest)

The distance between the minimum geometry bounding box

The distance between the bounding-box centroids of the geometry

Distance between the centroids of the minimum geometry bounding box.