All Questions
Tagged with fields-attributes attribute-table
322 questions
11
votes
1
answer
914
views
Setting all the values in attribute field to the same value with PyQGIS
When I use "Update existing fields" in the Field Calculator in QGIS 3.16.0-Hannover, it takes only a second to change all the values in a attribute field to the same value. However when I ...
- 375
3
votes
1
answer
457
views
Workflow automation for populating QGIS Attribute table
Is there a tool in QGIS which populates fields within the attribute table?
I know I can edit it manually but what I want is to include that tool in the workflow automation process.
I want to label the ...
- 355
4
votes
1
answer
1k
views
Adding column with area values in attributes table with standalone PyQGIS
I would like to add an area column to the Attributes table using Python. I prefer not to use QGIS Python console. I would like to do that using cmd. How should I change my code?
My code and error ...
0
votes
0
answers
19
views
Why are there multiple symbol icons for the same feature type for raster field in ArcGIS?
Using ArcGIS 10.7 desktop. I manually entered general landuse types for a field I created. For some reason only some of the feature types are consolidating in the symbology while others are creating ...
- 101
0
votes
1
answer
56
views
Extract some attributes in field to a new field in attribute table [closed]
I want to transfer in the TESTE field(img) only cities(strings) to a new field but but with the same numeral representation. Ex: |1| |Guimarães|; |2| |Porto|.
@BERA and @Aaron I want that the final ...
- 11
2
votes
1
answer
616
views
Showing values in attribute table in scientific (exponential) notation in QGIS3
One of my virtual field contains too big numbers like "5994865699857.456". I need to show those values in scientific/exponential mode like 5.99E+12. I didn't find proper function in Field ...
0
votes
0
answers
17
views
Turning attribute table in ArcMap
I want to show the attributes of the column "PHK_text" as a row on top of the table. "PHK_text" has ten different terms and all of them should be shown on top of the table as a new ...
- 1
2
votes
1
answer
718
views
Query to select attributes except specific fields [closed]
What is the expression in ArcGIS to select values except for specific attributes?
- 327
11
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
...
- 1,079
3
votes
3
answers
2k
views
Replace the attribute value of all shapes with specific value in QGIS
I'm pretty green when it comes to QGIS. I have a shapefile with a bunch of fields and farm codes of whats growing in them. However there are like 600 of them, so I want to go through and simplify. So ...
- 133
7
votes
3
answers
988
views
Calculating new attribute based on condition using Field Calculator in QGIS
I have a shape with different city areas that contains the average building heights ("HHO-mean") in meters. Now I want to categorize the average building heights in a new column in five ...
- 315
1
vote
2
answers
756
views
Extracting rows from attribute table and save as new shapefile using ArcPy
I have a shapefile made up of polylines. Polylines have a contour attribute. I want create new shapefiles based on these contour attributes. Something like this:
depth = [-10, -20, -30, -40]
map = ...
- 25
2
votes
1
answer
446
views
Subtracting number of days from todays date using value in another field in QGIS
I have an integer field named "Priority" with values ranging from 5 to 30 days. I want to use the now() function to subtract the integer to give a new date. The formula I tried is below but ...
- 325
1
vote
1
answer
211
views
Deleting attribute fields through SQL Server Management Studio
I have a problem. After appending annotations into the feature class on the SQL Server database I need to delete extra attribute fields that where made in the process. Usually I would just simply use ...
- 13
1
vote
0
answers
28
views
Saving attributes information (features) in QGIS layer
I have a road network (lines) and points (Address). I am using PyQGIS to join points to the nearest lines using the closestSegmentWithContext functionin QGIS. However, the attribute table of ...
- 865
4
votes
1
answer
2k
views
QGIS keeps cutting off attribute table column names after 10 characters, can I stop this?
How do I get QGIS to stop chopping off parts of my attribute table column names past 10 characters? Or is this unavoidable
- 335
0
votes
0
answers
236
views
How to add data to attribute table in ArcGIS 10.4?
I have a question about how to add data manually to the attribute table of a shapefile. Whenever I add data to the file or need to change data in the file, I right-click on the layer and select "...
1
vote
0
answers
29
views
Join the fields (column) into headers after geoprocessing
I am new on QGIS, I will try to be as specific as possible, but it seems quite hard to explain...
I am working with a first polygon vector: species' territories [In the attributes table: 50 lines, for ...
- 11
7
votes
1
answer
1k
views
Picking a value from another table in QGIS
I have two tables:
'TableA' has an auto incrementing "id"
'TableB' has a field that needs the "id" from 'TableA'
How do I default on update when a user updates 'TableB'? I need the ...
- 2,350
1
vote
1
answer
3k
views
How do you prevent the data type in a CSV file from changing when you import the table from Excel into ArcGIS Pro?
I'm an ArcGIS newbie and I'm struggling to keep the data type from changing from numeric to text for my fields in a CSV table.
I've found that copying the table, pasting it into a new Excel document ...
3
votes
1
answer
84
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 ...
- 535
1
vote
1
answer
75
views
Categorizing most often attributes in column
I have a shp point layer with a "USER_ID" column. There is about 19 thousands features. Some of "ID"'s enters the list only ones or twice, but some of them enters 50 or more than 100 times.
I need to ...
- 535
3
votes
2
answers
77
views
Updating a field with something like "if feature_1 is in field_1 then write category_1 to field_2" in QGIS Field Calculator?
I'm grouping different geological time scales into more general time scales.
An example of what I would want is
"if Oligocene-miocene is in descript_title, write Oligocene-Miocene in ...
- 1,217
2
votes
0
answers
517
views
How to assign values for one column of the attribute table on QGIS
The table is below.
Then I want to assign 3 values:
[43.8,
39.0,
25.9]
to the X field by row.
If there are thousands of rows in the table, can I just paste them just like in Excel?
The version of my ...
- 121
0
votes
0
answers
54
views
Combine 8 different shapefiles into 1 with combined attribute fields
I am working on a project where I want to add the attribute fields of 7 different shapefiles into 1 base shapefile. Specifically, I have a parcel map of a city, and I want to append attribute fields ...
- 1
5
votes
2
answers
7k
views
Adding unique ID automatically in Field calculator as counter in QGIS 3
I tried a lot by Field Calculator but it gives me NULL as you show in table and another try it gives me value 1 in all rows.
Most of examples, on internet they are explaining old version and I have ...
- 111
4
votes
1
answer
333
views
Copying attributes from many columns to one in QGIS
I have many columns, about 30 and each of those has some attributes. I want to merge those columns into one and collect all attributes in a row of columns. I tried with this post Combining Columns ...
- 2,425
2
votes
0
answers
43
views
One polygon layer for an area with different projects in the same layer?
I was wondering if it is possible (maybe not ?) to make a structure so that I can have diffrient information (projekts) over the same area/point in the same layer. This would be for an overview of the ...
- 373
1
vote
2
answers
904
views
Numerical fields decimals limited by default
I'm using ArcMap 10.5.1 and working from a geodatabase.
I just want to limit the number of decimal numbers shown to 1. Currently 6 decimals are shown, and I know I can reduce them manually by opening ...
- 67
1
vote
1
answer
769
views
Graduated symbol for percentage attribute in QGIS
I want to use the Graduated Symbol style for a field which contains values in percentages. When I select the Graduated Symbol this field does not appear in the drop down box. Is there a way to make ...
- 355
4
votes
1
answer
3k
views
Auto populate fields with different values from another field in QGIS?
Is it possible to populate a number of fields in a shapefile in QGIS with different values based on the values of one other field?
Essentially what I want to be able to do is to populate fields to ...
- 263
7
votes
2
answers
8k
views
Adding field with geometry in WKT format in QGIS
I have a shapefile with polygons and want to add an attribute field with the WKT in QGIS 3.4.
The function geom_to_wkt() in the Field Calculator isn't working and I don't know how to do it. Any ideas?
- 71
2
votes
2
answers
591
views
Copying feature from one layer while mapping fields in QGIS?
I am trying to copy features from one layer to another. What I would like to do is for QGIS to ask me which field should each field copy to.
For example, layer A has 4 features that I am trying to ...
- 1,830
2
votes
1
answer
81
views
Calculating field index based on feature attribute value using PyQGIS [closed]
Is there a way of finding to which field/column a feature attribute belongs?
For example, let's say I know feature[x] has an attribute of 0.17, I also know this must be between fields [12:17].
Can I ...
- 61
1
vote
1
answer
279
views
Add Field disabled on Excel file in ArcMap?
I am a new user to ArcGIS Desktop 10.7. I imported data table from Excel 97-2003 format in the Table of Content. Then with XY recognition the layer was created with the defined coordinate system. The ...
2
votes
1
answer
311
views
Getting all attributes and features in view using QGIS
In QGIS 3, I use attribute tables to store information about an object/feature on a layer. I have multiple Layers => multiple attribute tables.
Now I want to have a report about all displayed ...
- 141
8
votes
2
answers
2k
views
Finding the minimum value of different columns in QGIS
I'll try to calculate the minimum value of four different columns in my QGIS table like:
The min. value would be 1,50286 in the first row.
Is there any expression or tool to find the minimum value ...
- 183
3
votes
1
answer
349
views
Is it possible to view all the attribute data in QGIS
I use QGIS to map and store local history data. Because of this my point attribute data contains a lot of text. Since the textbox are so small it's hard to use and present the information. Is it ...
15
votes
2
answers
10k
views
Changing column order with Table Manager Plugin in QGIS 3
There was a Table Manager Plugin in earlier QGIS versions I can't see it for QGIS 3 anymore.
Is there a way to achieve this in QGIS 3.6?
- 303
5
votes
2
answers
972
views
Selecting features with equal values in different fields in QGIS
I don't know how to filter the attribute table in QGIS. I have two columns, "DN" and "DN_2", both with values from Corine Land Cover (111, 112, 223, etc).
I try to select the rows ...
- 319
2
votes
1
answer
1k
views
Dissolve (merge) polygons QGIS based on (non exact) attribute values
I am a fairly new user of QGIS having a question regarding dissolve functionality.
I am working with the NUTS-2 shapefiles provided by EU, which I have imported in QGIS. To ease the discussion, I ...
- 71
5
votes
2
answers
6k
views
Updating the attribute table of feature using PyQGIS
The following code updates the value of the field ("name") in the console and shows the result but the actual attribute table does not get updated. Can anybody suggest the error in the code?
...
12
votes
2
answers
6k
views
Renaming attribute/field names for GeoPackage layer in QGIS
I need to rename several attributes/fields in a GeoPackage layer. How to do this?
There are numerous pages on how to rename the attributes/fields of a shapefile. However, there do not seem to be any ...
- 419
4
votes
2
answers
3k
views
Applying attribute constraints in QGIS
Is there, with QGIS 3, any way to restrict the data added to a specific field of a GeoPackage layer?
I want to restrict the data in a field of an attribute table with something like that:
2letters(a-z)...
- 1,079
5
votes
3
answers
3k
views
Deleting features with identical table attributes in QGIS
How do I delete features with identical table attributes in QGIS? Otherwise, is there a tool like the 'Delete Identical Tool' in ArcGIS?
For example, if I had 4 rows, and 3 columns, where I wanted to ...
- 465
16
votes
3
answers
39k
views
Summing data from column in QGIS Attribute table
I'm working with population data, and I have an issue when it comes to knowing the sum of a population inside the attribute table.
In my attribute table, I'd like to add all the numbers in the red ...
- 1,042
4
votes
1
answer
172
views
Filling field with automatic numbering specific by unique value of another field using QGIS expression
I have a table with two fields: "NUMBER" (integer) and "TOWN" (text).
I would like to find an expression that fills the "NUMBER" field with an automatic number specific ...
- 597
0
votes
1
answer
48
views
Repeated labeling of random points within polygon? [duplicate]
I have created 3 random points within each of 27k polygons. I now want to label each of those 3 points as "A", "B", "C" within each polygon.
Is there a quick/automated way to do this?
- 1
4
votes
1
answer
2k
views
Inserting tags (multi-values) in field of attribute table with QGIS?
I am setting up a QGIS project using a Geopackage (or shapefile) concerning the areas named with some historical toponyms and writing a brief description of them.
In the attribute table I would like ...
- 71
5
votes
2
answers
1k
views
Dividing two or more rows in single attribute table?
I want to divide rows in my attribute table. I need to divide the lengths of rows having specific IDs. For instance the length of ID 21 divided by the length of ID 11. An this calculation execute for ...
- 187