Questions tagged [attribute-table]
A tabular set of data linked one-to-one to a set of spatial features.
2,221
questions
0
votes
2
answers
66
views
How do you add information to a polygon from multiple polygons based on location in QGIS?
I have a couple of points and have made a buffer layer of 1km around each point, which contain information about which point it represents. I have another raster layer (containing information ...
1
vote
1
answer
73
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 ...
2
votes
0
answers
102
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 ...
1
vote
0
answers
62
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
vote
0
answers
175
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 ...
3
votes
2
answers
117
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 ...
0
votes
2
answers
57
views
Selecting Features Based on Expression on QGIS Attribute Table - Help with Code
I want to select features which contain the word 'workings' within the field called Sample_Comments within my CSV file.
I have opened the attribute table and clicked on select features using an ...
0
votes
1
answer
56
views
Copying data from one attribute to another with Python in QGIS
I'm trying to update an attribute in a layer in QGIS with data from a joined field in the same layer. I have looked at a few different instructions and tutorials, but for some reason I can't get all ...
-1
votes
1
answer
226
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 ...
3
votes
0
answers
137
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 ...
0
votes
1
answer
14
views
Some WFL can add fields but some WFL have no add option
I'm working on a web map and discovered after publishing there are additional fields I need to add to the attribute table for one of the layers. Unlike the many other web maps, I have as hosted ...
1
vote
1
answer
181
views
ArcPy Alter Field name on *field.name
I'm used to using open source, not ArcPy functionality.
I am using the arcpy.AlterField_management() function to change field names from upper to lower case. I first ran into what looks like a common ...
7
votes
3
answers
329
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 ...
4
votes
3
answers
198
views
Getting layer attributes along path between two points in QGIS
In QGIS I have a map of source [square] and receptor points [circles], see map. I also have a layer with ground-type data (Corine Land Type 2018). I want to know how the ground type changes along ...
0
votes
1
answer
106
views
Topology rules with attribute table exceptions in ArcMap/ArcGIS Pro
I have a set of geometries that represent different surveying polygons, for each set I have certain features that are exactly the same geometry wise, but have a different value in a unique identifier ...
4
votes
1
answer
889
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 ...
0
votes
0
answers
91
views
Choosing parcels listed from Excel sheet in QGIS
I was sent an Excel sheet by a different department with all the parcel numbers they want to be mapped. They are all over the county.
What is the best way to select the parcels that were given to me ...
1
vote
1
answer
89
views
Finding length and percent of line across polygon in QGIS
I have a layer with several line features and a polygon layer which has land ownership information (so thousands of parcels).
I want to append several columns to the line layer attribute table ("...
0
votes
0
answers
102
views
Export CAD Layer Descriptions as attribute data in SHP format?
When exporting vector data from a CAD file (using Map3D), is anyone aware of a way to include the layer description? There seems to be a way to get all the other fields - lineweight, colour etc - but ...
4
votes
2
answers
184
views
Calculating lengths and percentages of potholes with SQL query in QGIS
I have a shapefile in QGIS that holds information about the amount and severity of potholes on a road network across several cities:
The road network is split into segments of different lengths (...
1
vote
0
answers
129
views
PostgreSQL and ArcGIS Pro "invalid entity type" error while opening table
I can see and select some of polygons from SQL database in ArcGIS Pro but other ones I cannot select. Because of this I cannot see the attribute table of the table which comes from PostgreSQL database....
1
vote
1
answer
120
views
Summing length of lines of a specific category from another layer in QGIS
I have a polygon layer of ski resorts call skiResorts. I have a liner layer of pistes called pistes. The pistes layer has 2 several attributes and include aa_piste_length and aa_piste_difficulty. ...
4
votes
2
answers
1k
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?
...
4
votes
2
answers
131
views
Duplicating rows according to field values in QGIS
I have a table in a GeoPackage like this
field1 field2
a;b 1
a;b 2
c;d 3
a;d;e 4
a 5
...
What I need is to create a new table in which the records are ...
5
votes
2
answers
247
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 &...
4
votes
2
answers
305
views
Exporting attribute table to CSV via pure Python in QGIS
I would like to use pure Python to export the attribute table as csv. For the variable data, I need a list that will read the whole attribute table. Is that possible?
import csv
layer = iface....
0
votes
0
answers
51
views
Speed up removal of first two letters in attribute table in QGIS
I have a number of layers, each with around 325,000 rows of data. I wish to remove the first two letters within a column, leaving only the numbers (e.g. amend "SP99612" to "99612")....
5
votes
1
answer
749
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 '...
2
votes
1
answer
237
views
QGIS form: relation value
I'm building a form to collect observation data of species. I have a layer called "observation" (point) with a field called "observer", it is the name of who sees the species. ...
4
votes
1
answer
317
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....
0
votes
0
answers
33
views
PyQGIS set Null-values depending to the datatype
I am experimenting with the code snippet from BERA and trying to fill zero values in a table according to the data type. Unfortunately without success. The value -1 is always entered
#Ersetzt alle ...
2
votes
1
answer
131
views
Field name not working in QGIS Modeler expression?
Why does the Field Calculator expression using field name work in the Attribute table but not in the QGIS Modeler?
3
votes
0
answers
67
views
QGIS: concats wrong values
I need to create an ID-field in the attribute table for a survey. Since there is more than one person I wanted to create the field in the form "[initials]_[sequence_number]". I have created ...
0
votes
0
answers
57
views
Intersection of two layers, attribute-table stays empty QGIS
I am trying to intersect two layers to calculate proportional distances of the two layers.. However, the attribute table remains empty after the intersection. To tool runs fine and no error is shown.
3
votes
1
answer
83
views
QGIS attibute form with value relation avoiding table
Is it possible to use some expression or text containing a values list for the dropdown control to display them?
The goal is to use a short list of values and not have to create a related table for ...
1
vote
1
answer
265
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 ...
1
vote
1
answer
79
views
QGIS - Automatic filling of the attribute table with an expression - continued
In the previous question, this is the link:
QGIS automatic fill of the attribute table by expression
I got help from a colleague and solved the problem of automatic fill of attributes and the code
...
5
votes
2
answers
312
views
QGIS automatic fill of the attribute table by expression
I have a line layer and in the attribute list the "Name" column, which can be, for example, 'V1','V2',....'V1-2','V1-2-3',... in I'm trying to put an expression in the next column that is ...
1
vote
1
answer
251
views
Combining geometry Overlay Expressions in QGIS Field Calculator
I have 2 shapefiles that cover a similar region, a river catchment and a hex-grid of surface water bodies within the catchment. The catchment has subcatchments, and I'm trying to link the hex-grids ...
0
votes
1
answer
33
views
Interactive editing of feature class table
I would like to create an arcpy tool that would allow me to iterate through a given feature class, probably using a For: statement, but that would pause after each instance to allow me to make changes ...
0
votes
2
answers
165
views
Latitude and longitude columns in QGIS not autopopulating [duplicate]
So I created columns for latitude and longitude for a point layer in QGIS using the expressions $y and $x in the field calculator respectively. However whenever I add a new point feature the latitude ...
2
votes
2
answers
99
views
Separating fields in QGIS
I would like to separate fields in the attribute console in QGIS. I know it's possible through the field manager, but does anyone know which formula I should use the get the results I want?
The first ...
2
votes
3
answers
132
views
Replacing element of array with data from another table using QGIS Expression
How to do it in QGIS or QGIS Expression to replace the element of an array(cell value) of a table with a new value taken from another table (which contains the list of the element and its ...
3
votes
1
answer
169
views
Save vector layer features into separate layers, based on combination of two attribute values: correct QGIS expression
I am doing a lab worksheet and I am having a hard time figuring out what to put in in the expression box.
GENERAL STEP: You need to identify Aspen and Birch (Select by Expression) and export these ...
5
votes
1
answer
97
views
Converting coordinates from cartesian to geodetic in QGIS
I have a problem with my layer attributes in QGIS, every time I add $x and $y coordinates as attributes, they are always returned to me in meters, while I would need this data expressed in degrees.
I ...
0
votes
0
answers
22
views
How to fill automatically points touching line layer in the attribute table? [duplicate]
I am trying to build a basic road transport network using QGIS, at this stage: one layer for nodes (nodes are dots connecting lines, one node connects two lines) and one for links (a link is a road, ...
3
votes
1
answer
425
views
Filtering data containing numeric values in QGIS
My dataset contains numeric values, alphanumeric values, and non-numeric values. How can I filter data which contains numeric values? Below is an example showing a list of data and filtered data which ...
3
votes
1
answer
199
views
QT Designer pushButton link to QGIS
I want to build a custom Toolbar with Plugin Builder 3 for QGIS. I managed to create the necessary folders and files and I can load my UI into QGIS:
The UI looks very simple with only two buttons like ...
2
votes
0
answers
69
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 ...
0
votes
0
answers
71
views
Draw on map a feature already present with its information in the attribute tables
I know how to add a feature, whatever the geometry, to a layer, by drawing it on the map (e.g. with the Add Polygon Feature): once the geometry is completed, a window for inputting its attributes is ...