Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,362
questions
1
vote
1
answer
26
views
Image too large to export as table from GEE
I have multiple images that I am processing and would like to then export their values as a CSV table.
All the following code is available and should be easily reproducible:
var age = ee.Image('users/...
2
votes
3
answers
168
views
Integer field of CSV file always output as String when processed with ogr2ogr
I have a file places.csv with the following contents:
name,lat,lon,type,population
Aalfang,48.8393882,15.0675236,village,410
Abern,48.0556773,13.1533381,village,203
Abersee,47.7266536,13.4169871,...
0
votes
0
answers
47
views
File format option does not show up when adding delimited text layer [closed]
I am teaching QGIS for students and on many computers (mostly running iOS) the 'file format' option (see attached picture with red) does not show up when trying to add a delimited text layer. I am ...
-1
votes
1
answer
61
views
Converting GeoTIFF to CSV using QGIS [closed]
I'd like to covert GeoTIFF to CSV by using QGIS.
How can I do it?
- 9
2
votes
1
answer
50
views
"Incorrect parameter value for LAYERS" error when saving CSV to GeoPackage with PyQGIS
I am using QGIS 3.32.3 and am trying to save a CSV file to a GeoPackage with PyQGIS using the current directory as part of the string. When trying to do this it shows:
'Incorrect parameter value for ...
- 23
3
votes
1
answer
132
views
Importing CSV results in NULL values for decimal column in QGIS
I am importing a .csv file and one of the "integer" columns ("ZVH Density") is all NULL values when imported as a Delimited Text file. Whole numbers import (known through trial and ...
- 31
3
votes
2
answers
123
views
Joining vector layer with CSV-file that contain duplicates in QGIS
I'm currently working on a project, and I received a CSV file which has additional information about each feature. I intend to join the CSV file with an existing layer. Picture it like this:
However, ...
- 51
0
votes
1
answer
39
views
What is meaning of extra bytes in .shp file or how to calculate content length
I'm trying to read a .shp file. That .shp file contains polygon type. So I read all the records perfectly, after the reading the points, end of the file that have some 28 bytes are there what is ...
5
votes
1
answer
69
views
Setting QgsVectorLayer created from CSV in editing mode with PyQGIS
I'm working on QGIS 3.28.10 and I want to create a QgsVectorLayer from a CSV file with PyQGIS script, but the resulting layer is not editable. Does anyone know how to set this layer as editable?
My ...
- 53
1
vote
1
answer
36
views
Join non-spatial CSV layer with spatial shape layer, using multiple input fields
I have two separate layers i want to join in my QGIS-project based on multiple matching input fields.
One layer consists of a non-spatial CSV table, but with the matching fields: Streetname, House ...
- 13
1
vote
1
answer
42
views
QGIS - Export layer with one polygon subdivided as multiple rows to CSV
I have a GeoJSON file with quite precise boundaries of world's countries. I had to simplify it because Snowflake, where I want to keep the data, has 16MB limit and Canadian polygon is always too large....
- 291
0
votes
0
answers
32
views
Join a raster file with grid data and a CSV file
I am a relatively new user of QGIS and encoutered a first major problem.
I am working with this dataset that converts the available geocoordinates into the European standard ETRS89-LAEA.This is a grid ...
0
votes
0
answers
55
views
How to download a joined image as a CSV file on my local computer?
I used a Landsat tile to extract information (images) from different satellites. Then, I add each image to a band like below. So, How can I download it (img_joined) as a CSV file to my local computer?
...
- 1
1
vote
2
answers
107
views
Creating map of visited airports in QGIS
I looked at the information given regarding airports and have downloaded that data into a CSV file for import.
I have created a shapefile for my base map using OSM.
How do I import the airport data (a ...
- 13
0
votes
1
answer
65
views
Data arrangement in CSV file [closed]
I am getting whole data in a row while exporting CSV file . I need data in separate columns in CSV file. Soil variable value in a separate column and pixel counts against each soil variable in next ...
- 5
2
votes
1
answer
41
views
Allowing null outputs when mapping over FeatureCollection in Google Earth Engine
I have code working that extracts the area of forest loss from the Hansen Global Forest Change dataset for each available year and attaches it to the properties of a mapped FeatureCollection. This ...
- 1,549
1
vote
1
answer
50
views
Transposing the output of a CSV from rows to columns in Google Earth Engine
var aoi = ee.FeatureCollection("users/jrobertsonpanthera/surveyed_grid_3test")
// Hansen Data
var gfc = ee.Image('UMD/hansen/global_forest_change_2022_v1_10')
var lossImage = gfc.select(['...
- 1,549
4
votes
1
answer
76
views
All fields recognised as String when importing CSV with CSVT in QGIS
I am trying to import data contained in a CSV file Chomage 1975.csv, with a CSVT file Chomage 1975.csvt in the same folder.
My CSV file content is:
Code;City Name;Unemployment rate 15 years and over ...
- 95
0
votes
1
answer
136
views
Read GeoJSON object in a CSV file column and transform it to geometry
I have a column ('geo_shape') that contains GeoJSON object type of linestring geometry and, so far, I didn't manage to read and transform it to a GeoPandas/shapefile type of geometry.
Here is a way ...
- 1
3
votes
1
answer
360
views
Points not showing on map on QGIS
I uploaded my coordinates as a CSV file and they show on the blank page on QGIS but when I try to make them show on the map they don't, either if I use OpenStreetMap or Esri Satellite, it's like they ...
- 31
4
votes
1
answer
52
views
Importing several CSV files without losing leading zeros from OS NGR into QGIS
I have ten CSVs that I need to import, in order to turn them into geopackages/shapefiles so I can edit the attribute tables etc etc. The ten files have a combined total of about 15000 entries. Each ...
1
vote
1
answer
41
views
Finding mean NDVI value for sub-districts within feature of shapefile between 1994 and 2011
I want to export as a CSV the mean NDVI values for the sub-districts contained within the NAME_3 feature of my shapefile. Currently I have the following code, but I am not being able to export it with ...
- 23
0
votes
0
answers
27
views
Set elevation profile to CSV on ArcGIS Pro 3.x
I want to export my elevation profile analysis from ArcGIS Pro to CSV.
I am able to export it, but it seems that I cannot edit the interval of elevation values exported to CSV.
I want to have an ...
- 1
0
votes
0
answers
29
views
Inaccurate attribute values using joins attribute in QGIS
I have a shapefile data that represent the location (polygons) and a tabular data represent its detail information. I want to merge the tabular data to the shapefile. I use QGIS 3.22.12
Here are the ...
1
vote
2
answers
98
views
Transforming QgsPoint from one CRS to another using PyQGIS
I would like to change the coordinates of QgsPoints imported from a csv file before saving it in shapefile.
I succeed to do all the step except the crs transformation, the output is keeping EPSG: 4326 ...
- 265
0
votes
1
answer
52
views
Points on map very uniform
I'm having some issues adding in some foodplant data from BSBI. I've added it in as a CSV but it's showing on the map as the below. I'm unsure if this is correct as it all looks very uniform and some ...
- 11
1
vote
1
answer
52
views
Importing WGS84 points into project CRS OSGB36 broken, showing black screen
I am relatively new to all things GIS.
I am trying to import CSV points collected in WGS84 format eg. LAT 55.93887932 LONG -4.50803484, into a project with CRS set to OSGB36 (EPSG: 27700).
This is ...
- 13
0
votes
0
answers
12
views
db.out.ogr duplicates items and adds an empty one
I export an attribute table of streams_order layer to CSV.
My attribute table in GRASS is ok:
But my CSV file has all features duplicated and an odd 0 feature with no information:
What's wrong and ...
0
votes
1
answer
33
views
How do I map points from a CSV file against bands in a raster?
I have a series of biome maps in QGIS 3.32 as multiband (RGB) raster layers. In a separate layer I have a series of points imported from a CSV file. How do I go about mapping the points (or rather a ...
- 3
1
vote
1
answer
63
views
How do I turn dictionary object values into columns for .csv export?
I've trained a random forest classifier, and classifier.explain() gives a dictionary containing the following keys:
0: classes
1: importance
2: numberOfTrees
3: outOfBagErrorEstimate
4: trees
I store ...
- 129
1
vote
0
answers
50
views
Unreadable text when converting .SHP to .CSV
I am trying to convert .SHP file to .CSV using ogr2ogr in QGIS and I also have all the associated files related to the .SHP files. The text in the .SHP file is in Ukrainian and after the conversion, ...
- 11
1
vote
0
answers
69
views
Generating a CSV table with daily SPM data in Google Earth Engine
I'm trying to generate a CSV table in Google Earth Engine to obtain daily data of Suspended Particulate Matter (SPM) concentration in different locations over a defined period. However, when I run my ...
1
vote
0
answers
32
views
How to use QgsVectorFileWriter::ActionOnExistingFile
I am slightly new to QGIS and the python side of how everything works. I am currently trying to find a way to overwrite a CSV file save in my QGIS project as a component in my larger project to save ...
0
votes
0
answers
22
views
Conversion problems: CSV and adding FSC Grid Refernces to a project
I am trying to add a CSV layer to a base map that I have set to EPSG: 29903. The CSV file contains latitude and longitude data with no known projection. When I import this data through the add layer ...
- 1
2
votes
1
answer
67
views
Encoding that works for German letters in QField
In my project I work with the German letters ü, ö, ß, ä, etc.
I joined my shapefile with tables (Excel, CSV).
For showing the German letters above I need an encoding that displays these. I chose ISO-...
0
votes
0
answers
33
views
QField packages my project but I cant see some files on my tablet
I am packaging a QField project and the packaging shows no errors. When I copy it to my tablet and open the file, it says two of my files are unable to load. One of the files is a CSV and the other is ...
- 1
5
votes
4
answers
317
views
Importing points from CSV file with NaN as vertical separator in QGIS
I am importing a CSV file with the coordinates of several points forming some kind of circle structure. The different circles are separated in the file table with one line of NaN, NaN.
When I import ...
- 61
1
vote
1
answer
132
views
QGIS: Importing Data points from the same CSV-file puts them into different locations
I tried to import this CSV file into QGIS and generally it seems to work. However about half of the data points end up correct in German state of Brandenburg, the other half of the points ends up ...
- 13
2
votes
0
answers
52
views
ArcGIS Export attribute table from imported GeoJSON to CSV w/Geometry
I'm trying to use GeoJSON files to generate CSV that I can then upload to my data warehouse and use the geography fields to create a connection between the lat/lng in the database and the GeoJSON map ...
- 291
1
vote
1
answer
141
views
ArcPy - overwrite feature service with CSV
I am trying to download a CSV from our project database, and then append this to a feature service in AGOL.
import os
import requests
import csv
import arcpy
from requests.auth import HTTPBasicAuth
...
- 11
0
votes
1
answer
45
views
Is it possible to add attributes to a vector layer from csv table based on class name?
I have a vector for the region of interest, where each polygon has a class value. Also I have a classification table there each row contains a class name and class parameters in other columns. I want ...
0
votes
0
answers
183
views
Export shapefile into CSV file in order to extract coordinate only
I have a shapefile which I can view in Mapwindow5,
But I need the co-ordinates only for my analysis. I've never used shapefile or geodata before. Is there any way to convert the shapefile into a CSV ...
- 101
1
vote
2
answers
64
views
Export List of lists as a FeatureCollection (CSV) in GEE
I need to export CSV but my input is a list of lists so I have an error "FeatureCollection (Error)
List.get: Parameter 'list' is required." How can I change my input data? Or the export mode?...
- 29
2
votes
1
answer
210
views
Import CSV data containing WKT with GEOMETRYCOLLECTION() to QGIS
I have a CSV file containing geodata in WKT in one column. The geometry type is GEOMETRYCOLLECTION. How do I import this to QGIS with one layer per geometry type (POINT and LINESTRING in this case)?
...
- 1,185
1
vote
0
answers
21
views
Error when running loop to section out data in R
I am attempting to run a loop in R that looks at home ranges of 27 individual animals by individual and by year.
I tried running this code:
df <- read_csv('animaltelemetry.csv')
df<-data.frame(...
- 11
2
votes
1
answer
149
views
Failed to export from shapefile to CSV in QGIS
I have a shapefile that I want to export the attributes to CSV. However, I get the following message. I have not done anything to the shapefile following the creation of the layer.
Export to vector ...
- 21
-1
votes
1
answer
150
views
Get "geometry column" error when importing my csv file on Google Earth Engine through asset tab
I want to localize my plant specimens on Google Earth Engine map by importing a CSV file with two columns, including longitude and latitude, which belong to Quebec province, Canada. After I select my ...
- 7
4
votes
2
answers
223
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....
- 329
0
votes
0
answers
33
views
Have to extract data in CSV from TIFF file a/c to my shapefile, have the data of entire coordinates but I only want the data as per my shapeile
I have the meteorological data of entire globe. I have uploaded the .tiff file into the raster layer in QGIS. I have also uploaded a layer of my desired country in .shp file. Now, I want to have the ...
- 1
0
votes
1
answer
85
views
How can I change the Data format in xProperties of GEE Chart?
My goal is export CSV table with 2 columns: system:time_start in format YYYYMMddHHmmss and LST_median. For this I try to create Chart first but xProperty wants just a string like system:time_start and ...
- 29