Questions tagged [attribute-table]
A tabular set of data linked one-to-one to a set of spatial features.
2,069
questions
0
votes
1
answer
17
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 ...
1
vote
1
answer
25
views
Combine features into new category
Within a vector layer I have dissolved 25k polygons into 43 different categories of land ownership (Ld_Use_Des). But now I want to further ''group'' them. For example I want to select Mineral Rights ...
- 433
0
votes
0
answers
27
views
QGIS - Is there a way to filter contents of attribute table in report to features that have a matching attribute field value with report feature?
I am running a report in QGIS 3.28.3 to map features within square mile sections. The report is running off the sectcode field of that layer. There are attribute tables in the report layout that ...
- 1
0
votes
0
answers
35
views
Merging attributes
I have added attribute information from the Overlay Layer to a set of features in the Input
Layer. However, both of the tools that I used, 'Join by Attributes' & 'Intersection' created the (...
- 41
3
votes
2
answers
98
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 ...
- 51
0
votes
1
answer
40
views
QGIS - Countif function on columns
In this question I asked for a substitute of the 'Countif' function in Excel to be used to populate a field depending on how many values different from 0 were present in the several attributes for ...
- 492
1
vote
0
answers
27
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
2
answers
58
views
Expression to delete specific rows from the attribute table in QGIS
I have a shapefile with one column. From that column I want to keep only the records (rows) with value 50 and delete the other rows. So far, I am doing this manually, by selecting the rows with the ...
- 705
4
votes
1
answer
57
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",
...
- 75
1
vote
1
answer
32
views
Error while inserting attribute table to Layout using PyQGIS
I am trying to insert a qgis attribute table to a layout using Visual Studio Code, how would I do it?
layout = project.layoutManager().layoutByName('nombre_layout')
table = ...
4
votes
1
answer
54
views
Autogenerate consecutive job numbers per group using QGIS expressions
I am looking to autogenerate consecutive numbers per group by an attribute form default expression whilst completing a survey using QField for QGIS.
Requirements:
A job number will only be created ...
- 41
0
votes
0
answers
12
views
Using 2D float arrays in attribute table fields in QGIS
I am currently using QGIS 3.28.0-Firenze for developing custom plugins, using PyQGIS.
I am interested in assigning a table of values to each of the point features of a Vector Point Layer. So then, ...
- 1
0
votes
2
answers
69
views
How to select repeated terms in attribute table? (QGIS) [closed]
I'm working with an attribute table whose one of the fields (Id) has several repeated numbers, is there a formula in which I can order these repeated numbers, or something like that, so I can delete ...
0
votes
2
answers
59
views
How to determine first and last dates?
Background:
I have snowpack records (expressed as Snow Water Equivalent) for the past 40+ years for numerous sites in the Pacific Northwest, USA. I need to determine the first and last dates that snow ...
- 7,475
1
vote
1
answer
45
views
Show final two digits in attribute using dynamic text in ArcGIS Pro
I am making a map of a project. for the dynamic labels it has the township and range values as separate attributes in the table, but the only spot where it identifies the section number is here. The ...
- 25
1
vote
0
answers
26
views
Reorder attribute table fields using PyQGIS
I'm trying to re-order my shapefile to another order that I want.
I want to keep all my data and overwrite this existent shapefile, so the shapefile would always be the way I Want.
What I'm doing is ...
- 123
2
votes
1
answer
79
views
Rename and delete fields in the attribute table
I am using QGIS V3.22.6
I have an attribute table with unnecessary fields that I wish to delete. I also wish to rename some of the fields.
I cannot see how to do this using the Attribute Table Editor.
- 41
0
votes
1
answer
57
views
Select Features by polygon colour
I am using QGIS V3.22.6.
I have imported a set of polygons digitised in Google Earth. They all have the same name but have different polygon colours.
I would like to rename these according to their ...
- 41
0
votes
0
answers
16
views
Change map from Atlas at the same time it select line of attribute table
I would like to select row of attribute table that correspond the same line of of atlas map.
I need that in attribute table, the only line that appear is the same of atlas (identificador is id of ...
- 1,911
1
vote
0
answers
38
views
Using many-to-one relationship in QGIS
I am not very experienced with QGIS.
My goal is to visualize the changing "geography of death" of the Roman emperors over time. The essential available data is the year of death (AD) and the ...
- 11
2
votes
0
answers
46
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 ...
- 21
1
vote
1
answer
43
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. ...
5
votes
1
answer
129
views
QGIS - Countif function
I have a simple attribute table structured in this way:
Features
Attribute1
Attribute2
Attribute3
Attribute4
Count
F1
5
0
1
3
3
F2
0
0
0
4
1
F3
1
2
0
0
2
F4
12
4
6
9
4
And I need to populate the ...
- 492
1
vote
0
answers
25
views
NULL value will be pasted on a non-spatial table
I have a non-spatial table (PostGIS) in QGIS with one column only. Whenever I paste value on that table from data on Google Sheet or from Notepad, it will paste null value even it has an actual text ...
7
votes
3
answers
106
views
Creating lines between points with certain attributes using QGIS
I have a layer with the coordinates of animals from a field experiment. Apart from other attributes the layer also contains the animals' unique ID and a timestamp. I want to know the travelled ...
- 73
0
votes
0
answers
36
views
Retrieving range of values in feature class in ArcGIS Pro using ArcPy [duplicate]
I wanted to access the range of values in an attribute of my feature class data in ArcGIS Pro using Python code. I used below syntax but I got the error message:
'int' object is not iterable
The ...
- 136
0
votes
2
answers
142
views
Identify and split data in other languages using QGIS
I have a dataset containing names in both English and other languages and mixed too. Is their any way to remove data containing other than English language?
Eg:
- 613
0
votes
1
answer
37
views
QGIS attribute table doesn't show all items
I have a situation, where the Show All Items is clicked, but the filter appears despite of this option.
Is it some bug?
https://issues.qgis.org/issues/12318
How can I make all of them visible?
- 3,773
0
votes
0
answers
25
views
"No root node! Parsing failed?" when editing attribute table on QGIS
I have added a delimited text layer to a map. It includes city names, latitude and longitude. Special characters appear as � and I want to edit them to have the correct names. I did not manage to do ...
0
votes
0
answers
23
views
Inherit feature color from another feature automatically with ArcMap
I'm working on a "Ftth" project and there are many repetitive tasks. So, I have to connect the house to the closure through a wire. Whenever I give a color to each closure, the link and the ...
0
votes
0
answers
15
views
Attribute fields exporting as org_name, I want it to stay as the original field name
I am exporting a QGIS map as a gpx file, and some of the attribute table fields I have added are turning into ogr_name or ogr_length etc. I need it to stay as the regular field name as I have to ...
- 1
4
votes
1
answer
65
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 ...
- 435
2
votes
2
answers
48
views
QGIS: Populate attribute table with the ID of the nearest point
I have two point layers, let's say one is "endpoints" and another layer is "nodes".
The "endpoints" layer attribute table has a field called "nearest_node", I ...
- 33
1
vote
2
answers
50
views
Connecting the boundaries of two polygons
I have a number of polygons with a section of 'empty space' between them, like this:
They are set up on the same layer, with different entries in the attribute table.
I'm looking for a way to join ...
- 23
1
vote
0
answers
40
views
Displaying derived attributes of gpx track in QGIS
When adding a GPS track, I see the "output" attributes (as in the attached picture). At the same time, I do not see this data in the attribute table. How can I enable visibility of this data ...
- 11
0
votes
0
answers
29
views
QGIS - Working in the attribut formular with Widgets
I want to transform my attribut formular for biotopes to add automatically their value depending on two former columns.
I have an excel table like this:
Code
rating1
rating 2
value
A
dry
species-...
- 121
1
vote
0
answers
34
views
Show attributes in the layer panel
I've got an layer with different type of streets (feature class in attribute table). Now I want to all the different types to show up in the layer panel, like it is in the picture (sorry for the bad ...
- 11
0
votes
1
answer
46
views
Partial and Total Sum in one table (QGIS print composer)
In QGIS 3.22.14, I'd like to present in the print composer a sub- and total sum in one table. The values in the attribute table can be anything (area, count, etc.), the key is to present them in one ...
- 31
-3
votes
1
answer
55
views
Add automatically one letter to different numbers in attribute table in QGIS
I have different numbers in attribute table to which I would like to automatically assign the same letter "E". I am using QGIS and I have tried using the field calculator but it did not work....
- 11
4
votes
3
answers
306
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 ...
1
vote
0
answers
30
views
Autofilling based of value map in QField
Is it possible to prepare a Value Map with autofilling? I have a list of almost 500 plant names and it is difficult to find correct name on my device (phone with Qfield) while scrolling. Is it ...
- 11
3
votes
2
answers
59
views
Removing question marks in front of records in QGIS
I am using QGIS 3.10.3 and noticed some question marks in one column of the attribute table. These marks are just before the numbers and represent the currency symbol.
I want to get rid of them. I ...
- 161
5
votes
3
answers
138
views
Hiding duplicates from dropdown when using value relation in QGIS Form
I've got a vector layer with a QGIS Form and the column "test" in the attribute table. I have values for the columns e.g: abc, abc, abcd.
I defined a form for this Layer. The type for the ...
- 502
2
votes
2
answers
85
views
Reformatting multiple Nearest Neighbor Join results into columns using QGIS
When using nearest neighbor joins in QGIS, a geometry is generated for each matched pair.
I am joining Layer1 geometries with up to 8 features from Layer2 using the Processing Toolbox in QGIS.
How can ...
5
votes
1
answer
194
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 ...
- 492
0
votes
2
answers
72
views
Adding new fields with conditions and calculating the sum of lengths and numbers using PyQGIS
I am developing a new plugin using Python in QGIS. I want to get an output with the result of a specific attribute table from another layer already existing in my project => layer "SUPPORT&...
2
votes
1
answer
117
views
Live synchronisation Excel to QGIS
I am looking for a solution to synchronize a vector layer to an Excel-file in both directions. So if I add a geometry within the vector layer, it shall also be written in the Excel-file and if I ...
- 275
3
votes
2
answers
121
views
Exporting layer features in existing Excel file with given column order in QGIS
When Exporting Layer attributes to Excel, file columns are arranged as per their back-end database.
I want to export layer attributes to excel and I want the columns to be arranged in specific order ...
- 41
6
votes
3
answers
157
views
Is it possible to join the same table twice in QGIS?
Basically, I have the layers above:
As shown in the image, I'm trying to join the layer lines with the layer points two times in a row so the labels of origin_id and extremity_id appear in the ...
- 604
0
votes
0
answers
99
views
Visualizing Vector Tiles map in 3D
As I am using QGIS not for a long time I am asking myself whether there is a possibility to visualize a Vector Tiles map resource in 3D in QGIS. In comparison to common shape files there isn't an ...
- 1