Questions tagged [attribute-table]
A tabular set of data linked one-to-one to a set of spatial features.
2,095
questions
4
votes
2
answers
86
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?
...
- 28.8k
3
votes
1
answer
743
views
Automatically updating feature area in the attribute table using QGIS
How can I write an expression to update the area of polygons and lengths of features automatically as well as the sum of the areas and lengths? I am using QGIS 3.16.7 and the data format is OGR ...
- 28.8k
1
vote
1
answer
40
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. ...
- 60.2k
1
vote
2
answers
154
views
Merging Attribute Table Field Values for Same File in QGIS
If multiple people populate different attributes of the same shapefile on separate computers, is there a way to merge the attribute table without creating copies of the polygons or fields?
Each file ...
- 60.2k
3
votes
1
answer
65
views
Copy/paste the JOIN settings in the layer properties from a layer to another like you do with styles using QGIS
I have a project with many layers that have the same columns, I need to copy paste a join with a table to each of those layers, but the copy/paste style with "JOIN" settings doesn't work.
Is ...
- 11
4
votes
2
answers
43
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 ...
- 27.9k
10
votes
5
answers
2k
views
Getting dictionary for each feature with their attribute values using PyQGIS
I need to obtain, for each feature of a layer, a dictionary with the attribute names and their values using PyQGIS.
I can get all the attributes of the layer using:
from qgis.core import QgsProject
...
- 28.8k
3
votes
1
answer
924
views
Getting feature attribute description with PyQGIS
I have a vector layer in which attributes have value maps and I need to get the description of the value. I am able to get the values with feature.attributes(), but I haven't found a way to get the ...
- 28.8k
1
vote
3
answers
796
views
Search for values in an attribute field based on a value relation in QGIS
I have a main postgresql table called "site" and another non geometrical local table called "values".
I used the value relation widget on a text[] column named "choices" ...
CommunityBot
- 1
2
votes
1
answer
1k
views
Setting permanent minimum height and width of all cells in attribute table with PyQGIS
Let's assume there is an attribute table of a vector layer which was opened with F6, see image below
With the code below I could set the minimum height and width of all cells in the attribute table.
...
- 28.8k
3
votes
2
answers
121
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 &...
- 28.8k
6
votes
1
answer
773
views
Renaming field names after joining two tables in QGIS
When joining two files (A.csv and B.shp with a common unique "ID") in QGIS the new fields in B.shp (from A.txt) include the name of the field + the name of the file where it comes from (A).
...
- 28.8k
4
votes
2
answers
142
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....
- 28.8k
2
votes
1
answer
165
views
I import a KMZ into QGIS but I would like to display the path name next to path in QGIS
I have a KMZ/KML file I import into QGIS. The file in Google Earth has track names but after importing to QGIS, only the tracks/paths are visible. How do I get the individual path names (which I can ...
CommunityBot
- 1
3
votes
0
answers
63
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 ...
- 101
2
votes
1
answer
81
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. ...
- 60.2k
0
votes
1
answer
475
views
Modifying the TIFF's attribute table value with R
I use raster::raster("test.tiff", RAT = T) to read the file with the format of TIFF.
The TIFF is derived from ArcGIS pro generating using Feature to Raster -> raster -> tiff.
ArcGIS ...
CommunityBot
- 1
4
votes
1
answer
66
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 '...
- 28.8k
4
votes
2
answers
67
views
Populating attribute table with the ID of the nearest point in QGIS
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 want to populate it ...
- 28.8k
1
vote
1
answer
355
views
qgis2web search attributes
Is it possible to query features based on attributes from the client side of qgis2web? How can this be achieved? I have a single data set that I want to serve over the web, while allowing users to ...
CommunityBot
- 1
5
votes
3
answers
10k
views
Joined tables and now field calculator is greyed out using ArcMap
In ArcMap 10.2, I accidentally calculated the wrong field outside of an edit session, so there was no way to reverse my action. I restored a previous version (shadow copy) and joined the tables ...
- 64.6k
0
votes
0
answers
43
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")....
- 43
2
votes
2
answers
606
views
Use previous entry as default in attribute table
I have a vector layer that I add observations to by identifying features in georeferenced rasters (images). One of the attributes I want to assign to the feature is the image name (which I currently ...
- 21
2
votes
3
answers
57
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 ...
- 60.2k
1
vote
1
answer
152
views
Changing font size of all labels in annotated attribute table in ArcGIS Pro to be one size
I am using ArcGIS Pro.
I converted a large group of labels to annotation (every road of a city) but when annotated, the size of the labels are a little too large for the map size I want. I can change ...
CommunityBot
- 1
4
votes
1
answer
119
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....
- 60.2k
0
votes
0
answers
29
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 ...
- 28.8k
9
votes
3
answers
4k
views
Renaming field in attribute table via PyQGIS
How can I rename a field in PyQGIS?
I tried:
for field in layer.pendingFields():
if field.name() == 'old':
layer.startEditing()
oldname = field.name()
field.setName('new')...
- 28.8k
2
votes
1
answer
50
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?
- 64.6k
0
votes
1
answer
282
views
How to create 'select by attributes' feature layer when greyed out? File is a feature class (not a feature layer) and I cannot convert it
I have a subset of attributes selected from a query in 'Select by Attributes' in the Attribute Table. I want to export these selected attributes into a new layer, and am unable to do so in ArcGIS Pro (...
- 1
0
votes
0
answers
25
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.
- 1
3
votes
1
answer
31
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,556
0
votes
1
answer
34
views
Joining attribute tables
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 ...
- 31.1k
5
votes
2
answers
176
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 ...
- 3,074
1
vote
0
answers
33
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
...
- 3,074
5
votes
1
answer
72
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 ...
- 28.8k
2
votes
2
answers
190
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 ...
CommunityBot
- 1
1
vote
1
answer
47
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 ...
- 114
0
votes
1
answer
24
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 ...
- 64.6k
0
votes
1
answer
319
views
st_combine and st_union produce empty attribute table for shapefile (how to edit before st_write?)
I am starting with R programming and I am having a hard time figuring out how to edit the attribute table of a shapefile after using st_combine and st_union.
My shapefile has multiple polygons and I ...
CommunityBot
- 1
2
votes
2
answers
79
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 ...
- 14.3k
0
votes
2
answers
53
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 ...
- 19.2k
3
votes
0
answers
205
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)!!
6
votes
2
answers
1k
views
QGIS List Unique Values tool only exports to .html format
Using QGIS 2.16.2 I would like to export the unique values in a shapefile string attribute field to a new database table (which would contain a single field listing the unique values). The Vector > ...
- 1,582
48
votes
4
answers
46k
views
Selecting features with NULL attributes in QGIS
How do I identify which features have NULL attributes in the attribute table of a shapefile?
When i try [field]= 'NULL' it selects the features with value = 0 (see picture)
- 64.6k
3
votes
1
answer
243
views
QGIS Refactor Fields unwanted behavior
QGIS Refactor Fields tool for altering attribute tables states:
This algorithm allows editing the structure of the attributes table of
a vector layer. Fields can be modified in their type and name, ...
CommunityBot
- 1
3
votes
1
answer
153
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 ...
- 60.2k
4
votes
2
answers
941
views
Display "values" or "description" of Value Map in Attribute Table
I am using a geopackage with a number of tables, some of which I have added in a Value Map to the fields. The value map is to ensure consistent entry of codes to the data to comply with a specified ...
- 1,556
5
votes
2
answers
118
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 ...
- 28.8k
4
votes
1
answer
78
views
Filtering contents of attribute table in report using QGIS
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 ...
- 28.8k