Questions tagged [attribute-table]
A tabular set of data linked one-to-one to a set of spatial features.
410
questions with no upvoted or accepted answers
6
votes
0
answers
277
views
QGIS N:M relations - possibility to edit multiple features?
I have a working QGIS project with multiple relations and all is well until I try the Toggle multi edit mode for N:M relations. I'm working with QGIS 3.10+ (3.14.16) and Windows and PostGIS.
Is it ...
6
votes
1
answer
726
views
QGIS 3 doesn't recognize Description from Value Map in attribute table
I have some .csv files that defines Value Maps. When I set them in the Attributes Form panel, it shows the right values and description names according to the .csv files.
But as can be seen on ...
6
votes
1
answer
240
views
Legend and Attribute Table change throughout map composer
I'm using QGIS 2.18.3 (Las Palmas)
For a project I have about 15 maps with the same extent, where each map displays a different attribute. I have followed Automating Atlas to create maps for all ...
5
votes
0
answers
354
views
Attribute table values randomly disappear or are changed
I'm using 3.10.14 version of QGIS and something very strange started happening. I performed several attraction distance and attraction reach analyses (using the Place Syntax Tool) that I saved in the ...
5
votes
0
answers
560
views
QGIS attribute table displaying wrong features?
In QGIS 2.18.1 I set up Attribute table to 'Show features Visible On Map' but in the form view in the list are definitely more features than visible in the map.
In the screenshot below two features ...
4
votes
0
answers
2k
views
QGIS - is it possible to select the columns shown with "Identify features"?
In QGIS, I have created a join to an attribute table with some 60 entries. I am only interested in seeing 3 of the columns, specifically address data.
I can see no way of excluding the unwanted ...
4
votes
0
answers
958
views
How to export data from sql server into shapefile in the decimal format in QGIS 2.4?
The last couple of days, I have been working on exporting data from SQL to a shapefile in QGIS 2.4. While converting into a shapefile, the data type changes automatically from Float to Integer in the ...
4
votes
0
answers
782
views
How to create raster attribute table to a raster data using gdal python?
I classified a remote sensing data and saved it as a raster using Gdal python. I want to create a raster attribute table for this classified result.. my classified raster has five classes with 1,2,3,4,...
3
votes
0
answers
46
views
QGIS: Multifeature layer symbology and layer legend based on two separate attributes?
I'm quite new to QGIS, and I'm battling with something that seems like it should be really easy to do.
I have a polygon layer with hundreds of features, and I want to define the layer's symbology ...
3
votes
0
answers
144
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 ...
3
votes
0
answers
68
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 ...
3
votes
0
answers
181
views
QGIS has started putting all features into one row in Attribute Table
This is a bit of an odd one. We host our data in an Microsoft SQL Server database, and until a couple of weeks ago this was working fine. We've got about 17000 rows in it, all with a geometry.
When I ...
3
votes
0
answers
66
views
Docked attribute table not displayed when reopening a QGIS project
I have created a project with multiple map views (canvases).
I have also opened vertically in the project an attribute table.
When I save and reopen the project, the layout is lost.
What can I do to ...
3
votes
1
answer
200
views
Why is the calculated area different in the layer that was clipped with a mask
I have a mask that I created. I used calculate geometry in the attribute table to calculate the acres of the polygon (1,214,784 acres). I then used the intersect tool with the mask and another layer ...
3
votes
0
answers
120
views
Adding attribute of polygon orientation depending on neighbors in QGIS
I have a shapefile with buildings as polygons. Is it possible to add attribute columns referring if the polygon boundary is "other polygon" or "outdoors" for a certain orientation (...
3
votes
0
answers
198
views
Populating row numbers with Field calculator using PyQGIS
I have the following code, which is creating a new column called "group" without issue, but not populating it with a row number 1-n, as I'm intending it to.
pv = layer.dataProvider()
pv....
3
votes
0
answers
83
views
How do I limit the features shown in attribute table to those in the current time range?
I loaded a vector layer with temporal information and set up the Temporal properties accordingly. The Temporal Controller lets me view temporally filtered subsets of my data according to its current ...
3
votes
0
answers
828
views
QGIS: Using Filter expression for Drop Down Lists in Value Relation Widget
I have a vector layer and want to enable the user to pick values from drop-down lists. The values of the drop-down list change depending on the chosen value of the previous field(s). It works ...
3
votes
0
answers
226
views
QGIS Export Vector Shapefile attribute table metadata
In QGIS, I am looking for a way to export shapefile "attribute table metadata" (data about the the data, i.e. Id, Name, Alias, Type, Type Name, Length, Precision, Comment) not the shapefile ...
3
votes
0
answers
2k
views
Select duplicates by attributes in QGIS
I selected my duplicates in my attribute table by Count(1,"ID")>1. Now I just only want to keep the duplicates with the highest areas. Is there a way to directly select them or a work ...
3
votes
1
answer
83
views
Columns order mixed up by style
I have a point layer for wich I've set the order of columns while using field calculator and Refactor fields instruments. But the order of colums is different when I'm choosing point by Identify ...
3
votes
0
answers
133
views
QGIS attribute form table of contents highlighting is missing
When in form view in the attribute table, QGIS displays a "table of contents" beside the form, which usually highlights the feature being displayed in the form. Example:
In two of my layers, somehow ...
3
votes
0
answers
276
views
How to make zoom to selected feature permanent in QGIS?
I was wondering if there is an option in QGIS so that I don't need to click on a feature in the attribute table and afterwards click on zoom to selected feature.
I am hoping to navigate through the ...
3
votes
0
answers
148
views
QGIS – Edits to shapefile attribute table won't save special characters
I'm working in QGIS with a Government of Canada shapefile of all 338 federal electoral districts.
The encoding is UTF-8.
In the attribute table, all of the em dashes ("—") that should appear in the ...
3
votes
0
answers
938
views
Export to SVG with Polygon IDs
So v.out.svg works perfectly fine for my purpose, except that it doesn't export polygon IDs, so I have no way to identify them in the output. I want to use one of the attributes (specifically the Name ...
3
votes
0
answers
268
views
Attribute Values not showing when running a query
The attribute values are not displayed for the 'Model Number' field when running a query yet the attributes are stored in the attribute table(When I say all unique, nothing comes up)!!
3
votes
0
answers
208
views
Reload attribute table does not work for attribute changed by dataProvider
In QGIS2.18, I'm changing feature attributes using the following two methods:
dataProvider:
attrs = { 0 : "hello", 1 : 123 }
layer.dataProvider().changeAttributeValues({ fid : attrs })
layer object:...
3
votes
0
answers
150
views
Update field based on selected attribute from dropdown list
Is it possible to assign an attribute from a list (table) based on a chosen attribute (code) from a dropdown list field?
For the selected code, field "Sifra", update field "Opis" with something from ...
3
votes
0
answers
185
views
Append dynamic stats on attribute table in QGIS Composer
I have an attribute table containing records like Town, inhabitants, N° male, N° Female like this:
When I compose a map in QGIS I use "Show only visible feature" command resulting in a view with only ...
3
votes
0
answers
603
views
QGIS QgsAttributeTableModel only loads when called without a function in Python
I tried to load QgsAttributeTableModel into QgsAttributeTableView or a plain Qt QTableView but it could run from inside a class method or function but it runs without any function or method. Below is ...
3
votes
0
answers
3k
views
Batch export to shapefile by attribute field in QGIS
I have a project in QGIS where I am creating a map of plants over a large area. I want to take the "Genus" field (of which there are 100 hundred values) and essentially create 100 shapefiles based on ...
3
votes
0
answers
723
views
QGIS Select Single Feature not correct in attribute table
For some reason, QGIS is not displaying the correct row of my data when I click on a feature with "Select Single Feature" or even the other select tools.
I have a point database linked from mysql. ...
2
votes
1
answer
45
views
Passing attribute of vector layer to algorithm in QGIS Model Designer
I am using QGIS 3.34.9 and I have point data with several properties in the attribute table of which one is called "test". I would like to use the "Rectangles, ovals, diamonds" - ...
2
votes
0
answers
74
views
Expression with length3D function returns strange result in QGIS
I am using QGIS 3.32. My project and data are in EPSG:4236-WGS84.
I used drape (set Z value from raster) the line layer onto an elevation grid, resulting in a Line (MultiLineStringZ). On this layer, I ...
2
votes
0
answers
118
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
votes
0
answers
81
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 ...
2
votes
0
answers
681
views
Exporting large attribute table from QGIS to Excel
I am working on a project with an attribute table of approx. 5,564,098 rows. I've tried exporting it to Excel using the "save as" CSV or XLS but the data keeps getting cut off. I would ...
2
votes
1
answer
225
views
Deleting all non-required fields in table using ModelBuilder in ArcGIS Pro
In ArcGIS Pro I want to delete all non-required fields from a table using ModelBuilder. The number of fields will be variable since it will the product of multiple Union functions.
Is there a way to ...
2
votes
0
answers
64
views
Create a condition between these two fields
I'm trying to create a condition where QGIS understands that if "connections = None" then "number of connections = 0". How can I do this?
2
votes
0
answers
114
views
Value relation widget, data is saved as Value Column instead of the Key column
I'm pretty shocked that I can't add a Key column apart of a Value column in my QGIS relation attribute table. I use as Value relation column field with the code follow by the latin name of plant ...
2
votes
0
answers
61
views
How to join a column from a line data layer attribute table and join it to a shapefile attribute table in QGIS?
Issue:
I have calculated the distance from shore from point data showing dolphin IDs to the coastline by using these commands:
Step 1: Digitise the country lines for administration country shapefiles ...
2
votes
0
answers
428
views
How to join attributes by field value on-the-fly?
I have two spatial (polygon) layers (table 1 and 2), and another non spatial table (table 3).
Table 1 & Table 2 have identical columns but different fields.
Table 1 is edited by user 1 only
Table ...
2
votes
0
answers
74
views
How to speed up the rendering speed of layers with multiple virtual fields?
I am inputting data for power lines and tried using the normal field and imported it in PostGIS.
But the some of the data inputs I needed must be refreshed constantly to obtain. So instead I used ...
2
votes
0
answers
127
views
Deleting large number of duplicates in attribute table in QGIS
In QGIS 3.22 I have a vector file with about 9000+ objects and for some reason, each of them has duplicates. Which way can I find on QGIS to remove duplicates which have the same object "ID" ...
2
votes
0
answers
44
views
Understanding QGIS 3 Print Composer Text Size in Attribute Tables
I'm trying to bottom align an attribute table in print composer. Therefore I want to calculate the height of the Table and adjust it's size accordingly.
From my understanding the height of a cell ...
2
votes
0
answers
612
views
Removing duplicate records in the Attribute table using QGIS
I need to remove the duplicate objects in my attribute table (see the image attached), but I can't find a way to do so.
I saw questions asked with python that it NOT relevant to my case
2
votes
0
answers
45
views
Can I build a QGIS query based on the boundaries of a clipping polygon?
Several times a year I download a very large shape file which contains details of the road network of my home state. That shapefile (I'll call it the master file) is regularly updated by the provider,...
2
votes
2
answers
339
views
Specifying color in ArcGIS Pro from the external text file for Attribute Table function
I am working with 16-bit signed raster image mosaic dataset in ArcGIS Pro 2.9.0. I use Attribute Table function to specify classes' names using external table:
While this function works and gives me ...
2
votes
0
answers
388
views
Adding data from CSV file to vector layer in QGIS
I am trying to add data from a CSV file to a Vector layer (shapefile). I already created a column with same numbers to have a reference column, so I could join my CSV data to that reference column.
I ...
2
votes
0
answers
204
views
Splitting shapefile with one layer to many layers for attribute table
Not quite sure how to ask this question, I created a shape file using the rasterToPolygon function in R. It works fine except when I open the shapefile I only have one layer and my I cannot do ...