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