Ważne

Tłumaczenie jest wysiłkiem społeczności QGISa przyłącz się. Ta strona jest obecnie przetłumaczona w 50.66%.

24.1.26. Vector table

24.1.26.1. Add autoincremental field

Adds a new integer field to a vector layer, with a sequential value for each feature.

This field can be used as a unique ID for features in the layer. The new attribute is not added to the input layer but a new layer is generated instead.

The initial starting value for the incremental series can be specified. Optionally, the incremental series can be based on grouping fields and a sort order for features can also be specified.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input vector layer.
Field name	FIELD_NAME	[ciąg tekstowy] Domyślnie: «AUTO»	Name of the field with autoincremental values
Start values at Opcjonalne	START	[numeric: integer] Domyślnie: 0	Choose the initial number of the incremental count
Modulus value Opcjonalne	MODULUS	[numeric: integer] Domyślnie: 0	Specifying an optional modulus value will restart the count to START whenever the field value reaches the modulus value. 0 means no restart.
Group values by Opcjonalne	GROUP_FIELDS	[tablefield: any] [list]	Select grouping field(s): instead of a single count run for the whole layer, a separate count is processed for each value returned by the combination of these fields.
Sort expression Opcjonalne	SORT_EXPRESSION	[wyrażenie]	Use an expression to sort the features in the layer either globally or if set, based on group fields.
Sort ascending	SORT_ASCENDING	[wartość logiczna] Domyślnie: True	When a sort expression is set, use this option to control the order in which features are assigned values.
Sort nulls first	SORT_NULLS_FIRST	[wartość logiczna] Domyślnie: False	When a sort expression is set, use this option to set whether Null values are counted first or last.
Incremented	OUTPUT	[same as input] Default: [Create temporary layer]	Specify the output vector layer with the auto increment field. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Incremented	OUTPUT	[same as input]	Vector layer with auto incremental field

Kod pythona

ID algorytmu: native:addautoincrementalfield

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.2. Add field to attributes table

Adds a new field to a vector layer.

The name and characteristics of the attribute are defined as parameters.

The new attribute is not added to the input layer but a new layer is generated instead.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input layer
Field name	FIELD_NAME	[ciąg tekstowy]	Name of the new field
Field type	FIELD_TYPE	[wyliczenie] Domyślnie: 0	Type of the new field. You can choose between: 0 — Integer (32 bit) 1 — Decimal (double) 2 — Text (string) 3 — Boolean 4 — Date 5 — Time 6 — Date & Time 7 — Binary Object (BLOB) 8 — String List 9 — Integer List 10 — Decimal (double) List
Field length	FIELD_LENGTH	[numeric: integer] Domyślnie: 10	Length of the field
Field precision	FIELD_PRECISION	[numeric: integer] Domyślnie: 0	Precision of the field. Useful with Float field type.
Field alias Opcjonalne	FIELD_ALIAS	[ciąg tekstowy]	Set a name to use as alias for the field. Not supported by all format types.
Field comment Opcjonalne	FIELD_COMMENT	[ciąg tekstowy]	Store a comment describing the field. Not supported by all format types.
Added	OUTPUT	[same as input] Default: [Create temporary layer]	Specify the output vector layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Added	OUTPUT	[same as input]	Vector layer with new field added

Kod pythona

ID algorytmu: native:addfieldtoattributestable

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.3. Add unique value index field

Takes a vector layer and an attribute and adds a new numeric field.

Values in this field correspond to values in the specified attribute, so features with the same value for the attribute will have the same value in the new numeric field.

This creates a numeric equivalent of the specified attribute, which defines the same classes.

The new attribute is not added to the input layer but a new layer is generated instead.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input layer.
Class field	FIELD	[tablefield: any]	Features that have the same value for this field will get the same index.
Output field name	FIELD_NAME	[ciąg tekstowy] Domyślnie: «NUM_FIELD»	Name of the new field containing the indexes.
Layer with index field	OUTPUT	[same as input] Default: [Create temporary layer]	Vector layer with the numeric field containing indexes. One of: Pomiń wyjście Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… The file encoding can also be changed here.
Class summary	SUMMARY_OUTPUT	[vector: table] Default: [Skip output]	Specify the table to contain the summary of the class field mapped to the corresponding unique value. One of: Pomiń wyjście Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Layer with index field	OUTPUT	[same as input]	Vector layer with the numeric field containing indexes.
Class summary	SUMMARY_OUTPUT	[vector: table]	Table with summary of the class field mapped to the corresponding unique value.

Kod pythona

ID algorytmu: native:adduniquevalueindexfield

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.4. Add X/Y fields to layer

Adds X and Y (or latitude/longitude) fields to a point layer. The X/Y fields can be calculated in a different CRS to the layer (e.g. creating latitude/longitude fields for a layer in a projected CRS).

Allows features in-place modification of point features

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: point]	The input layer.
Coordinate system	CRS	[układ współrzędnych] Domyślnie: „EPSG:4326”	Coordinate reference system to use for the generated x and y fields.
Field prefix Opcjonalne	PREFIX	[ciąg tekstowy]	Prefix to add to the new field names to avoid name collisions with fields in the input layer.
Added fields	OUTPUT	[vector: point] Default: [Create temporary layer]	Specify the output layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Added fields	OUTPUT	[vector: point]	The output layer - identical to the input layer but with two new double fields, x and y.

Kod pythona

ID algorytmu: native:addxyfields

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.5. Advanced Python field calculator

Adds a new attribute to a vector layer, with values resulting from applying an expression to each feature.

The expression is defined as a Python function.

Ostrzeżenie

This algorithm is a potential security risk if executed with unchecked inputs, and may result in system damage or data leaks.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	Input vector layer
Result field name	FIELD_NAME	[ciąg tekstowy] Default: «NewField»	Name of the new field
Field type	FIELD_TYPE	[wyliczenie] Domyślnie: 0	Type of the new field. One of: 0 — Integer (32 bit) 1 — Decimal (double) 2 — Text (string) 3 — Boolean 4 — Date 5 — Time 6 — Date & Time 7 — Binary Object (BLOB) 8 — String List 9 — Integer List 10 — Decimal (double) List
Field length	FIELD_LENGTH	[numeric: integer] Domyślnie: 10	Length of the field
Field precision	FIELD_PRECISION	[numeric: integer] Domyślnie: 3	Precision of the field. Useful with Float field type.
Global expression Opcjonalne	GLOBAL	[ciąg tekstowy]	The code in the global expression section will be executed only once before the calculator starts iterating through all the features of the input layer. Therefore, this is the correct place to import necessary modules or to calculate variables that will be used in subsequent calculations.
Formuła	FORMULA	[ciąg tekstowy]	The Python formula to evaluate. Example: To calculate the area of an input polygon layer you can add: value = $geom.area()
Obliczone	OUTPUT	[same as input] Default: [Create temporary layer]	Specify the vector layer with the new calculated field. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Obliczone	OUTPUT	[same as input]	Vector layer with the new calculated field

Kod pythona

ID algorytmu: qgis:advancedpythonfieldcalculator

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.6. Drop field(s)

Takes a vector layer and generates a new one that has the same features but without the selected columns.

Zobacz także

Retain fields

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	Input vector layer to drop field(s) from
Fields to drop	COLUMN	[tablefield: any] [list]	The field(s) to drop
Remaining fields	OUTPUT	[same as input] Default: [Create temporary layer]	Specify the output vector layer with the remaining fields. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Remaining fields	OUTPUT	[same as input]	Vector layer with the remaining fields

Kod pythona

ID algorytmu: native:deletecolumn

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.7. Explode HStore Field

Creates a copy of the input layer and adds a new field for every unique key in the HStore field.

The expected field list is an optional comma separated list. If this list is specified, only these fields are added and the HStore field is updated. By default, all unique keys are added.

The PostgreSQL HStore is a simple key-value store used in PostgreSQL and GDAL (when reading an OSM file with the other_tags field.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: geometry]	Input vector layer
HStore field	FIELD	[tablefield: any]	The field(s) to drop
Expected list of fields separated by a comma Opcjonalne	EXPECTED_FIELDS	[ciąg tekstowy] Domyślnie: «»	Comma-separated list of fields to extract. The HStore field will be updated by removing these keys.
Exploded	OUTPUT	[same as input] Default: [Create temporary layer]	Specify the output vector layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Exploded	OUTPUT	[same as input]	Output vector layer

Kod pythona

ID algorytmu: native:explodehstorefield

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.8. Extract binary field

Extracts contents from a binary field, saving them to individual files. Filenames can be generated using values taken from an attribute in the source table or based on a more complex expression.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	Input vector layer containing the binary data
Binary field	FIELD	[tablefield: any]	Field containing the binary data
File name	FILENAME	[wyrażenie]	Field or expression-based text to name each output file
Destination folder	FOLDER	[folder] Domyślnie: [Zapisz do katalogu tymczasowego]	Folder in which to store the output files. One of: Zapisz do katalogu tymczasowego Zapisz w katalogu

Wyniki

Etykieta	Nazwa	Typ	Opis
Folder	FOLDER	[folder]	The folder that contains the output files.

Kod pythona

ID algorytmu: native:extractbinary

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.9. Field calculator

Opens the field calculator (see Expressions). You can use all the supported expressions and functions.

A new layer is created with the result of the expression.

The field calculator is very useful when used in The model designer.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The layer to calculate on
Output field name	FIELD_NAME	[ciąg tekstowy]	The name of the field for the results
Output field type	FIELD_TYPE	[wyliczenie] Domyślnie: 0	The type of the field. One of: 0 — Decimal (double) 1 — Integer (32 bit) 2 — Text (string) 3 — Date 4 — Time 5 — Date & Time 6 — Boolean 7 — Binary Object (BLOB) 8 — String List 9 — Integer List 10 — Decimal (double) List
Output field width	FIELD_LENGTH	[numeric: integer] Domyślnie: 0	The length of the result field (minimum 0)
Field precision	FIELD_PRECISION	[numeric: integer] Domyślnie: 0	The precision of the result field (minimum 0, maximum 15)
Create new field	NEW_FIELD	[wartość logiczna] Domyślnie: True	Should the result field be a new field
Formuła	FORMULA	[wyrażenie]	The formula to use to calculate the result
Obliczone	OUTPUT	[same as input] Default: [Create temporary layer]	Specification of the output layer. Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Obliczone	OUTPUT	[same as input]	Output layer with the calculated field values

Kod pythona

ID algorytmu: native:fieldcalculator

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.10. Refactor fields

Allows editing the structure of the attribute table of a vector layer.

Fields can be modified in their type and name, using a fields mapping.

The original layer is not modified. A new layer is generated, which contains a modified attribute table, according to the provided fields mapping.

Informacja

When using a template layer with constraints on fields, the information is displayed in the widget with a coloured background and tooltip. Treat this information as a hint during configuration. No constraints will be added on an output layer nor will they be checked or enforced by the algorithm.

The Refactor fields algorithm allows to:

• Change field names and types

• Add and remove fields

• Reorder fields

• Calculate new fields based on expressions

• Load field list from another layer

Rys. 24.135 Refactor fields dialog

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The layer to modify
Fields mapping	FIELDS_MAPPING	[lista]	List of output fields with their definitions. The embedded table lists all the fields of the source layer and allows you to edit them: Click to create a new field. Click to remove a field. Use and to change the selected field order. Click to reset to the default view. Click to invert the selection in the fields list. For each of the fields you’d like to reuse, you need to fill the following options: Source expression (expression) [expression] Field or expression from the input layer. Name (name) [string] Name of the field in the output layer. By default input field name is kept. Type (type) [enumeration] Data type of the output field. Available types may not be compatible with the output layer provider. One of: Uwaga For certain field types, e.g. lists, an extra sub_type parameter helps refine the specific type of the data. It is automatically set in the GUI but may be needed if you’re running the algorithm in Python or from the command line. 1 — Boolean 2 — Integer (32bit) 4 — Integer (64bit) 6 — Decimal (double) 9 — Integer list 9 — Integer (64bit) list 9 — Decimal (double) list 10 — Text (string) 11 — String list 12 — Binary Object (BLOB) 14 — Date 15 — Time 16 — Date & Time Sub-type (sub_type) [enumeration] For certain field types, e.g. lists, this parameter helps refine the specific type of the data. It is automatically set in the GUI but may be needed if you’re running the algorithm in Python or from the command line. One of: 2 — Integer list 4 — Integer (64bit) list 6 — Decimal (double) list 10 — String list 0 — Any other types Length (length) [numeric: integer] Length of the output field. Precision (precision) [numeric: integer] Precision of the output field. Constraints (constraints) [string] When using a template layer, indicates whether there are constraints applied to the template field. Hover over the cell to display the constraints. Alias (field_alias) [string] Set a name to use as alias for the field. Not supported by all format types. Existing aliases are displayed and will be copied to the destination layer if supported. Comment (field_comment) [string] Store a comment describing the field. Not supported by all format types. Existing comments are displayed and will be copied to the destination layer if supported. Load fields from template layer Allows to select a layer from the current project as a template and (with Load fields) fill the above „Fields mapping” options with its fields and their definitions.
Refactored	OUTPUT	[same as input] Default: [Create temporary layer]	Specification of the output layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Refactored	OUTPUT	[same as input]	Output layer with refactored fields

Kod pythona

ID algorytmu: native:refactorfields

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.11. Rename field

Renames an existing field from a vector layer.

The original layer is not modified. A new layer is generated where the attribute table contains the renamed field.

Zobacz także

Refactor fields

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input vector layer
Field to rename	FIELD	[tablefield: any]	The field to be altered
New field name	NEW_NAME	[ciąg tekstowy]	The new field name
Renamed	OUTPUT	[same as input] Default: [Create temporary layer]	Specification of the output layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Renamed	OUTPUT	[same as input]	Output layer with the renamed field

Kod pythona

ID algorytmu: qgis:renametablefield

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.12. Retain fields

Takes a vector layer and generates a new one that retains only the selected fields. All other fields will be dropped.

Zobacz także

Drop field(s)

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input vector layer
Fields to retain	FIELDS	[tablefield: any] [list]	List of fields to keep in the layer
Retained fields	OUTPUT	[same as input] Default: [Create temporary layer]	Specification of the output layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Retained fields	OUTPUT	[same as input]	Output layer with the retained fields

Kod pythona

ID algorytmu: native:retainfields

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.26.13. Text to float

Modifies the type of a given attribute in a vector layer, converting a text attribute containing numeric strings into a numeric attribute (e.g. «1» to 1.0).

The algorithm creates a new vector layer so the source one is not modified.

If the conversion is not possible the selected column will have NULL values.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwa wejściowa	INPUT	[vector: any]	The input vector layer.
Text attribute to convert to float	FIELD	[tablefield: string]	The string field for the input layer that is to be converted to a float field.
Float from text	OUTPUT	[same as input] Default: [Create Temporary Layer]	Specify the output layer. One of: Create Temporary Layer (TEMPORARY_OUTPUT) Zapisz do pliku… Zapisz do GeoPackage… Zapisz do tabeli bazy danych… Append to Layer… The file encoding can also be changed here.

Wyniki

Etykieta	Nazwa	Typ	Opis
Float from text	OUTPUT	[same as input]	Output vector layer with the string field converted into a float field

Kod pythona

ID algorytmu: qgis:texttofloat

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.