# 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

’a’ returns 'A’

’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.