QGIS Attribute Table – How to Automatically Fill Columns with Preset Values when Creating Polygon, Line, or Point Layers

attribute-tablecolumnpolygon-creationqgis

I have to draw several features like polygons, points and lines by hand in my QGIS project on to defined layers and those layers contain an attribute table with several columns.

Is there any way to set a preset (values/words) of some sort for specific columns which means I don'`t have to fill out the columns by hand when I create an entity?

Below there is an example:

In this picture I created the polygon and now I have to fill out the attribut table. The layer is categorized and by adding "Colored" in the "Feature" column I get the defined style for this polygon like in the picture below.

Is it possible to set some sort of preset in the "attribute-formula" or anywhere else?

How can I set this preset exactly?

I´ve found other Q&As but in my case I don't have any relationship to other layers with any information for the attribute table.

Best Answer

'Colored' would be the correct syntax.

Within Qgis expressions single quotation marks ('yourtexthere') are used to designate input of characters, while double quotation marks ("yourfieldnamehere") are used to reference column/field names.

Related Solutions

QGIS – How to Automatically Fill Gaps and Merge Polygons Using Longest Adjacent Polygon

First of all many thanks for your answers.

@Cyril I indeed do this to fill the gaps

@RGfromRWBJV I also use this tool to clean the layer

@markusN I also used this solution to clean the layer

There is no simple solution on this. Despite these functions, none of them are perfect.

Therefore the simplest way to do this is : - the snapping option from the cleaning/generalizing tool, - drawing a polygons covering the entire surface, using the symmetrical differences to generates the polygons and fulfill the "holes" in using the function "Eliminate Selected Polygons with the option "sharing the largest common boundary with the adjacent polygon"

QGIS – Concatenate Attribute Data from Point, Line, and Polygon Layers

You can use a virtual layer to aggregate the attributes.

For the geometry it, kind of work a bit, as you can pan/zoom to the geometry but it won't be shown on the map, i.e. you would still have to display the initial layers.

Go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the query

select * from (
    select * from myPointLayer
    union all
    select * from myLineLayer
    union all
    select * from myPolygonLayer)
order by map_no;

If the fields are not the same, or not in the same order, you would have to replace each * by the field name list.

Best Answer

Related Solutions

QGIS – How to Automatically Fill Gaps and Merge Polygons Using Longest Adjacent Polygon

QGIS – Concatenate Attribute Data from Point, Line, and Polygon Layers

Related Question