Skip to main content

Questions tagged [column]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7 votes
2 answers
189 views

Making Autosize All Columns the default view every time attribute tables are opened in QGIS

At QGIS 3.34.6, attribute table column widths can be manually adjusted so that all values can be seen, using the Autosize dropdown: Question: How can I set QGIS so that Autosize All Columns is the ...
Stu Smith's user avatar
  • 8,202
0 votes
1 answer
39 views

How to get the row and column of US PLSS sections?

How to get the row and column of US Public Land Survey System (PLSS) township sections? Sure, looking at a diagram I can quickly fill in a lookup table by hand, section,column,row 1,6,6 2,5,6... 36,6,...
Dan Jacobson's user avatar
1 vote
1 answer
49 views

Where to find the comment of column in QGIS?

I created a column with a comment but where do I find this comment later on?
eva's user avatar
  • 59
0 votes
1 answer
286 views

Change datatype of range of columns while importing a CSV file

Let's say I have a CSV file that has a bunch of columns, starting from Field1 to Field141. Now all these columns have a text datatype. And I would like to import this CSV in such a way that the ...
Arthur_Morgan's user avatar
1 vote
0 answers
21 views

Identify and Seperate Special charcters in to other column [duplicate]

My dataset contains special characters. I want to identify the data which contains only special characters and separate it into a new column. List of special characters : `~!@#$%^&*_{}[]<>?/ ...
Bruno B's user avatar
  • 849
-1 votes
2 answers
90 views

Comparing similar words in two different columns [closed]

i have list of different categories in same dataset in two different coulumns There are some similar words in the two columns. So by comparing the two columns the maximum matched wordings should be ...
Bruno B's user avatar
  • 849
3 votes
3 answers
275 views

Separating columns of layer and exporting set of columns in a new QGIS layer

I use QGIS 3.16. I need to find a way to separate the columns of a layer and export each column in a new layer named like the column. For example: I have a file.csv that I import with the geometry wkt....
Fanny Chagnet's user avatar
1 vote
1 answer
131 views

How to update column values starting with zero in MapInfo Pro

When I choose the Update Column function in MapInfo Pro 12.5, if I type in rowid*50 it will make intervals of 50 which is all fine, but how do I get the first column to be zero and then update the ...
Nikki's user avatar
  • 11
1 vote
1 answer
2k views

Object name not found in R

I have created following map for disaster by district as shown below. The code I used is:- install.packages("cartography") install.packages("sf") install.packages("tidyverse&...
Walker's user avatar
  • 301
0 votes
1 answer
6k views

Invalid argument to unary operator in R

I want to calculate the rate of change in Maximum Temperature (of 2 yrs) for a spatial data. The rate of change of maximum temperature for the 2 years data (say 2021 & 2019) is calculated as:- [{(...
Walker's user avatar
  • 301
1 vote
0 answers
419 views

How to sum-up values of a column A, with same ID in column B in QGIS field calculator

In my QGIS, I have a shape file that already contains a column stating the size of each urban green space and a column that holds the area ID (equal to a zip code). Via the field calculator, I would ...
green's user avatar
  • 41
1 vote
1 answer
359 views

Change the headlines of a attribute table in QGIS

I would like to change the heading of a column in the attribute table of QGIS. Originally I had a vector layer linked to an Excel table and so now I have old and new forest locations. But both columns ...
Mel's user avatar
  • 11
0 votes
1 answer
474 views

Why reduceColumns is not working at all in Google Earth Engine?

I have tried to extract the data in a specific column of my featureCollection using .reduceColumns, but got nothing. Other columns work, but the column "Image_ID" is not working. I thought ...
Luis Lizcano's user avatar
3 votes
1 answer
129 views

Polygon/Line/Point-Layer - fill out columns automatically with preset (word/value) when creating entity in QGIS

I have to draw several features like polygons, points and lines by hand in my QGIS project on to defined layers and those layers contain an attribute table with several columns. Is there any way to ...
awilum's user avatar
  • 53
2 votes
1 answer
361 views

QGIS - auto fill values in one column which share the same value in a different column

There are three columns in the attribute table. part, forest with both unique IDs and factor with three possible values (yes, no, check). One forest contains many different part. If the factor is ...
wbio's user avatar
  • 23
4 votes
2 answers
203 views

Mean coordinates from several columns

I have a delimited text layer created from table with a few hundred coordinates (lat/long) in columns A and B and several hundred values associated with these coordinates in columns C to XXX. Now, I ...
Alrik's user avatar
  • 121
3 votes
1 answer
45 views

number the soil_unit_code in a soil_id column

I believe its pretty easy to be done, but I just don't seem to see the solution in Qgis. Is it possible in the field calculator? I've an attributetable with 200 features with like 20 different ...
ThomasHaarlem's user avatar
4 votes
0 answers
72 views

QGIS-modeler: How to name a column of a point layer from a raster

I have several rasters named after the date and time (e.g. YYMMDDHHMM: 2107152050I) and a points layer. I want to extract the values from each raster to each of the points and therefore I created a ...
rugg01's user avatar
  • 41
7 votes
1 answer
1k views

Permanently changing table column order without creating a new layer in QGIS

In QGIS 3.18. The order of columns in a shapefile's attribute table can be changed by the following methods: using the Organize Columns tool in the attribute table; using the Refactor Fields tool; ...
pete's user avatar
  • 1,101
6 votes
2 answers
3k views

Splitting column with delimiter into multiple columns in QGIS

In Excel we have option called 'Text to columns' to split the data in a column. Is there any option available in QGIS? There is an option which splits data from left or right in QGIS but I want entire ...
Bruno B's user avatar
  • 849
2 votes
1 answer
2k views

Adding data to new field in attribute table in QGIS

I have created a new field column in the attribute table for my shapefile as shown below. I now need to add data to these rows from another datafile. Is there a way to do it other than manual editing ...
T.P.'s user avatar
  • 53
0 votes
0 answers
456 views

Error on creating a geometric column in SQLite

Many post has been written on this problem but I can't figure out what is my problem here. I want to create a geometric column in a SQLite database to store polygons (geojson format or WKT). I use ...
GIStrees's user avatar
  • 119
1 vote
0 answers
82 views

Filling new columns in shapefile attribute table

I am faced with a challenge. I have shapefile from the government of Canada and I need to add extra 4 columns to the attribute table from other databases released by the government. How do I fill them ...
Tareq Salim's user avatar
3 votes
2 answers
221 views

Combining columns in attribute table

How can I merge columns in attribute table with / as delimeters?
Nnn's user avatar
  • 49
3 votes
1 answer
2k views

Splitting legend in QGIS in to 2 columns

I am new to QGIS and I am making a map of India showing some quantity. I added the legend to my map layout, I have 10 symbols in my legend and it is very long , so I wish to split it into 2 columns. I ...
Letitbe's user avatar
  • 81
5 votes
1 answer
2k views

Copying columns from one layer to another in QGIS

In QGIS 3 I couldn't find any suitable answer for my struggle. I have two layers with different objects (buildings from different areas). I want them to have same columns, but creating one by one is ...
Julia Strzyż's user avatar
3 votes
1 answer
1k views

Properties and columns difference in GEE feature collections

What the difference between columns and properties in Google Earth Engine feature collections? When I build a new feature collection with a property directly in the code editor, when I print it I do ...
Teuz's user avatar
  • 65
2 votes
1 answer
1k views

How do I batch edit field values in my attribute table?

I'm using QGIS. I have an attribute table that has some very long attribute names because of a join I did, and it seems to be causing errors when I try and select values using an expression and ...
DanG's user avatar
  • 617
3 votes
1 answer
324 views

Getting the first point's coordinates of column with type path

I have the table above CREATE TABLE public.geometry ( id serial not null primary key, distance float not null, height float not null, coordinates path not null, ...
chatzich's user avatar
  • 251
4 votes
1 answer
835 views

Hiding column using PyQGIS

How can I hide a column in QGIS 3 using PyQGIS: In QGIS 2 it was quite simple: editFormConf = layer.editFormConfig() idx = layer.fields().indexFromName(columnName) editFormConf.setWidgetType(idx, &...
Alfredo Garcia's user avatar
5 votes
2 answers
5k views

Displaying row/column of point in raster using QGIS

Is it possible in QGIS to display the column and row index of pixel in raster? I mean something similar to the value tool.
Palo Krajci's user avatar