All Questions
Tagged with fields-attributes attribute-table
322 questions
1
vote
0
answers
27
views
First field gets cleared (if time field) in QGIS Attribute Table
I recently noticed a strange bahavior in QGIS (currently working with version 3.34-7):
When the first field of a shapefile is named "time" (I regularly work with GPX files exported to ...
- 53
5
votes
2
answers
316
views
Deleting special characters from QGIS Attribute table
Is there a way to delete special characters such as *?
I've tried using replace and regexp_replace, but my version at least doesn't recognise special characters.
There are hundreds of fields, and I'm ...
- 157
4
votes
2
answers
228
views
Creating new field from another field in QGIS Field Calculator
I am trying to create a new field in QGIS where:
if the number in the field "DN"=2, then the new field (a text string) will say "veg"
and if the number in the field "DN"...
2
votes
1
answer
150
views
When deleting attribute from GDB file all the fields in the remaining attributes get deleted as well in QGIS
In QGIS 3.38.2 I have a gdb shapefile with many attributes, let's say A100, A200, A300 and with many fields. When I go to the edit through the "Open attribute table" and delete A200, all the ...
- 191
0
votes
1
answer
40
views
Expression for closest to zero value
I want to display the closest value to zero from a field in an attribute table from a QGIS layout without having to create a new field. Is it possible?
- 71
0
votes
1
answer
60
views
Photos in QField and name of each photo to be inserted in a field of the attribute table
I have to detect point elements with QField and for each point take photos whose name is to be inserted in a specific field of the attribute table. How can I get that for each point the "photo&...
2
votes
1
answer
87
views
Setting field alias in GeoPackage file outside of QGIS
In QGIS it's easy to set field aliases for GPKG, or any file that supports it.
Can this be done externally to QGIS (specifically for GPKG) so that when opened in QGIS, it will show said alias ...
- 8,718
0
votes
1
answer
59
views
Fields that fill in automatically
I want to create a point layer with an ID field that fills in automatically as I digitize a geometry. It's possible? How can I do?
3
votes
3
answers
147
views
Deselecting duplicate records in QGIS Attribute table
Several SE-GIS posts describe how to identify duplicate records, such as Identifying duplicate attributes in field using QGIS.
I would like to extend this concept by unselecting any duplicate records ...
- 8,356
2
votes
2
answers
269
views
Assigning unique ID to new points in QGIS
I want to add a new field to my feature attribute table. In this field, I want to generate a random ID (just a number, like 1, 2, 3, etc.) for every new and existing point I create on the map.
This is ...
- 101
0
votes
1
answer
42
views
Graduated symbology
I have opened a delimited text file with coordinates XY defined in two columns on the file plus two other columns with data and they are represented in QGIS as a point layer.
I want to symbolize the ...
- 71
0
votes
0
answers
60
views
How to keep attributes after a clipping operation in PyQGIS?
I'm trying to do a spatial clipping operation between 2 point layers, representing buildings and earthquakes, and a buffer area created by the user. The problem is that after operation, all attributes ...
0
votes
0
answers
45
views
Changed project from QGIS 3.16 to 3.24, now 'NULL' fields turn into '-9223372036854775808'
Been working on a digitizing project on QGIS 3.16.15-Hannover, as I like to use LTR versions for the stability.
But, 3.34 introduced an automatically incrementing UUID field, which I find useful.
My ...
- 175
3
votes
2
answers
191
views
A suggestion on how to create a cemetery shapefile to include multiple entries in an attribute table?
I want to do a small volunteer project of a war cemetery in my hometown and to make it available to public.
However, I never did this so maybe you can have some suggestions to me. The hard part I ...
- 319
0
votes
1
answer
297
views
Undo Delete Field in QGIS
I am working on a very large point file and had deleted some field that I thought were not necessary from my attribute table. It turns out that I jumped the gun and should not have deleted the fields. ...
0
votes
0
answers
43
views
Display information from a different layer in an attribute table in QGIS
I have two different polygon layers we'll call them A and B. I would like to create an attribute table with fields that list areas of A and B (calculated using the $area function in field calculator). ...
1
vote
1
answer
104
views
Setting a Boolean field to be empty
I have a layer with a Boolean field called bool.
I can set the field value to NULL, e.g. using the Field Calculator.
When printed via Python, the values are correctly shown as None:
>>> layer ...
- 11.3k
9
votes
1
answer
355
views
Using attributes tables as variables in QGIS
I work for a company where we use the same file when starting a project, with all the print layouts already configured, including the names/themes of the maps, since we usually need the same themes. ...
- 217
1
vote
0
answers
81
views
QGIS crashes when running Action to create new field
I made a layer style with a python action with following code :
def add_field(field_name, layer, field_type=QVariant.Invalid, field_length=0, field_precision=0, value=None, from_field=False):
if ...
- 1,313
0
votes
0
answers
26
views
All values entered using fields with a list of values are transformed into (0)
All values entered using fields with a list of values are transformed into (0) how can we find back the selected values, we lost a lot of work and can't find backups.
- 1
2
votes
1
answer
99
views
Matching specific word character in QGIS Graphical Modeller
With the graphical modeller, I try to decode a set of codes:
Since the code '_zie' is also contained in the code '_p_zie', I get two matches for '_p_zie'.
How can I get two specific Word characters ...
- 185
0
votes
1
answer
39
views
Creating line feature with multiple record
I am trying to create line feature with multiple record in ArcGIS 10.8. Actually I am working on FTTH project there I need to draw 12 f fiber which single cable contains 12 separate threads in it and ...
1
vote
1
answer
363
views
Assigning new values based on the field calculator and "case when then" in QGIS
I would like to do conditioning in the attribute table consisting of the following action:
CASE WHEN "network" = icn_ref THEN '001|' ELSE '' END
|| CASE WHEN "network" = ncn THEN ...
- 11
4
votes
1
answer
726
views
Using get_feature function with attribute in QGIS
I am trying to wrap a get_feature with an attribute expression to perform the equivalent of a VLOOKUP in Excel. Using the form below I get a NULL result.
attribute(get_feature('pointst', 'when', ...
- 2,002
1
vote
0
answers
72
views
Separating data in name field so it can be filtered in QGIS
I have some information that I want to filter by some of the fields under the primary name field for ex: "gs_substation" or "gs_feeder_number". But they are unable to be filtered ...
- 11
0
votes
0
answers
55
views
Trying to save a raster with only field information
I'm fairly new to all GIS.
I am using the Wise30secfin.ovr file which has prepopulated fields in an attribute table. I want to make a raster with the values from only one field, but every time I try ...
- 1
1
vote
1
answer
102
views
Duplicating certain features based on symbol in QGIS Attribute table
In QGIS 3.28.8 I have downloaded the data for power lines in different parts of Germany from OSM. Some of these lines and cables have different voltages (see below). I can filter those with several ...
- 51
2
votes
0
answers
137
views
Returning field value based on expression on another field using QGIS expression
I want to return the value from one field ("Number") for the feature with the most recent timestamp ("Time") from within the current layer ('mylayer'). Or what's the number of the ...
- 2,002
1
vote
0
answers
70
views
Changing number to bigger than 999 in QGIS
In QGIS 3.28 on Windows, there is a shapefile originally created in QGIS that was imported and worked on in ArcGIS.
Now, when I reopen the file in QGIS, the real numbers have a width of 18 instead of ...
- 1,853
1
vote
0
answers
261
views
Get checkbox for Boolean field in attribute table
I have a dataset with a lot of Boolean fields.
In the attribute table, they are represented with text (either true oder false). If I click into the cell, I get the checkbox I also get in the attribute ...
- 727
4
votes
2
answers
224
views
Deleting contents of all entries in field in QGIS Attribute table
In QGIS, how can you delete all of the entries in a field in an attribute table? If you go to a particular entry in a field, you can delete that entry, but how can you delete all of the entries in the ...
- 569
-1
votes
1
answer
585
views
Converting string variable to number format without creating new variable using Field Calculator in QGIS
I have many variables which are of type string but contain in fact numbers.
In QGIS you can convert those strings to numbers by creating a new variable with the wanted numeric type (e.g. integer or ...
- 1,853
3
votes
0
answers
145
views
Saving attribute field comments when making memory layer permanent in QGIS Plugin
My QGIS plugin creates a vector layer (memory) with attribute fields that include comments. Comments are not saved when I "Make Permanent" the layer.
I have been able to build a QGIS Python ...
7
votes
3
answers
437
views
Using all columns to find the minimum with QGIS expression
I want to use aggregating functions (min, max, mean, ...) on all the attributes (= columns) within a row. In this topic Finding the minimum value of different columns in QGIS, this is done by calling ...
- 2,554
4
votes
1
answer
1k
views
"AttributeError: 'dict' object has no attribute 'fields'" error when creating and deleting fields in the attribute table using PyQGIS
I am currently making a code that will buffer the points then extract vertices and add new coordinates. but I also want to change the "max depth" column to "Height Theo" and then ...
- 171
4
votes
2
answers
3k
views
Creating hyperlink in the attribute table using QGIS
My dataset contains a list of URLs. There is no hyperlink for the URLs to take me to Google Maps. Is there anything we can create to open the locations in Google Maps directly by clinking on the URL?
...
- 849
5
votes
2
answers
420
views
Converting column with category names to numeric codes in QGIS Field Calculator
I use the Field Calculator in QGIS to transform an attribute column with category names to numeric codes. I use the following expression:
CASE
WHEN "category" = 'Foo' THEN 1
WHEN &...
- 1,599
5
votes
1
answer
2k
views
Adding automatic numbering of the "id" field in QGIS
I'm working on QGIS 3.22.6 and I would like to find a way for my "id" column to be automatically numbered as geometry is added.
I am currently using maximum("id") + 1 within the '...
- 97
4
votes
1
answer
496
views
Creating a hyperlink in QGIS doesn't work
I have a text in an attribute table that contains a file path. I want a hyperlink to be displayed in the information about the object - in blue, underlined - as I saw in this tutorial: https://www....
- 317
1
vote
1
answer
442
views
Joining attribute tables without columns with the same name in QGIS
I would like to link the two attribute tables (see image). However, as far as I know, I need two columns with the same name for the link. Is there an alternative so that I can link the two attribute ...
- 11
2
votes
0
answers
91
views
Copying attribute table for each layer in QGIS
In QGIS I'm trying to edit attribute tables for a corn planting prescription. I have 50 layers (fields) that all need to have the same attribute table layout. Is there any way to create a template ...
- 29
5
votes
2
answers
216
views
Converting multiple fields with abbreviations to one field with full names in QGIS
I have a field with singular abbreviations ("BB", "BC", and "BG") that corresponds to a table with full names (catfish, rainbow trout). It ranges from 1-10 abbreviations ...
- 61
0
votes
1
answer
305
views
Alias in QGIS disappearing
Does anyone know why the 'alias' not saved when I export a layer to a shp file? So, I made alias in the file when I exported. After I opened exported shp file and properties->attribute form/fields ...
4
votes
2
answers
298
views
Filling several columns based on conditions from column in QGIS
I've got two additional columns that need to be filled with attributes that are based on values created in the field.
For example, if column "reproduction" = A2 then the value in the value ...
- 71
1
vote
0
answers
41
views
Locating a specific field in an attribute table using SQL with ArcGIS
I am a beginner at GIS/ArcGIS and have a quick question about locating a field in an attribute table of a feature using SQL. Attached is an image of a (crude) example of the kind of attribute table I ...
- 11
4
votes
1
answer
314
views
Deleting specific attributes of layer using PyQGIS
I want to delete specific columns in the attribute table of my layer:
except for the "LAYER" Column.
This is my code:
clip = processing.runAndLoadResults("native:clip",
...
- 163
1
vote
1
answer
157
views
Finding missing or skipped FIDs in a large list of features
I have a shapefile containing 2454 features each with their own unique ID (FID), however the highest FID is 2578. Some features were merged during processing, causing their original FID to disappear. ...
4
votes
1
answer
119
views
Filling attribute column with numbers 1-50 on repeat in QGIS
I have a large file of several hundred thousand polygons. It's too many to have an individual colour, so I want to create a column of numbers to which I can assign a random colour. So how do I create ...
- 531
5
votes
3
answers
734
views
Define a unique ID (serial number) based on values in a field
I'm trying to generate a unique serial number for a dataset I have, for example, something like this:
As shown, I would like to have a serial field, called SERIAL in this case, that increments based ...
5
votes
1
answer
755
views
QGIS Symbology - Display more symbols for each point depending on attribute numeric value
I have a point feature layer with some attributes. The numeric value of each attribute stands for the number of items of that attribute related to each point.
Is it possible in QGIS to display a ...
- 518