Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,041
questions
0
votes
0answers
9 views
Export rain data to CSV file from GEE
I would like to get the CSV file of rain daily data from GSMAP for a specified polygon (mean in geometry).
I succeed in getting into it on a chart, but now I want to download the data and I'm having ...
2
votes
1answer
68 views
Problem exporting shp as CSV
I imported a shapefile into QGIS, made a copy of it, and edited that copy. My edits consisted in changes in the coordinates of a few points. I then exported this edited shapefile as a .csv. For peace ...
1
vote
1answer
28 views
Create a List of All Webmaps within a Portal
I'm trying to do some spring cleaning and in the plans of organizing and archiving older webmaps.
We have several hundred maps, so I'm looking for a way to create a simple CSV that will list all ...
0
votes
0answers
15 views
Export Image in .CSV on Google Earth Engine
This is what I'm dealing with:
I have three filtered image collections concatenated in one (Sentinel-1, Sentinel-2 and SRTM), and I would like to export this in CSV for external analysis.
The SRTM ...
2
votes
1answer
36 views
Importing special/custom csv files to QGIS
I'm trying to import a csv file. Most similar cases are trivial but the csv file contains only the data (sunshine hours) and a header specifying the coordinate of the first cell, the number of columns ...
3
votes
1answer
106 views
Imported CSV data is not displayed in QGIS
I watched a simple video tutorial on how to accomplish it, but nothing shows up on my project when I add the layer. Even if I try zoom to layer, the screen just shows blue. I'm not sure if it has ...
9
votes
1answer
90 views
Categorising point layer twice by size and form in QGIS
I have data points from a CSV-file that I opened in QGIS.
The points illustrate different power plants of solar, wind, geothermal, coal, oil, etc with different capacities within each class.
I already ...
0
votes
0answers
52 views
Plotting time series in QGIS
I have a shapefile with points, like this:
x, y, id, data
-1.3345,-0.4760, 1, data.csv
The data.csv contains:
date, data
2020-01-01, 1
2020-01-02, 2
2020-01-03, 3
2020-01-04, 4
How can I plot the ...
0
votes
1answer
29 views
5
votes
2answers
319 views
Accessing CSV data directly from website
I want to do what this person has asked here. I am using QGIS 3.16
I have copied what was suggested and what seemed to work for the OP, however I am not getting any information displayed. The data ...
0
votes
1answer
25 views
Display points from CSV table (feature collection) in Google Earth Engine
Unfortunately, I cannot display the point data I uploaded as csv file. I specified latitude and longitude, the rest is unknown so I kept it at default. Can somebody help?
Link to asset
3
votes
1answer
35 views
Import CSV forcing datatype with CSVT
I'm trying to add a table in QGIS but I cannot define the datatype of my fields, as when imported they get automatically "read" as string.
I have tried to add a csvt file, by filling a .txt ...
1
vote
0answers
45 views
OGR error: file location not a directory [closed]
I have an Excel file that I converted to CSV. Then I used MMQGIS to geocode CSV with web service. Then I use the OpenStreetMap as the type of web service. I make sure the to be converted file is going ...
4
votes
2answers
137 views
Reading GeoJSON-String from CSV as Geometry in QGIS
I have a CSV which contains the geometry information as a GeoJSON string, e.g.
{ "type": "MultiLineString",
"coordinates": [
[[10, 10], [20, 20], [10, 40]],
...
2
votes
1answer
59 views
Plotting data with centroids only
I am fairly new to spatial analysis and I am trying to create a map of the spatial distribution of pollution in the UK using publicly available data retrieved from https://uk-air.defra.gov.uk/data/pcm-...
0
votes
0answers
14 views
Export table with monthly total precipitation data for each year with GsMaP in GEE
I'm trying to download a CSV table with total precipitation for a series of years expressed in monthly total. I would like this information for a specified polygon (geometry)
¿Can anyone please help ...
3
votes
1answer
42 views
Encoding issue in QGIS while exporting a layer with Cyrillic characters from gpkg to CSV
I need to export gpkg layer contained Cyrillic characters to a spreadsheet, e.g. csv file. I do that using Export -> Save Features As and pick UTF-8 encoding. I tried encodings: Cyrillic, different ...
1
vote
1answer
35 views
CRS for Lat/Long points and QuickMapServices
I have data from Google maps with latitudes and longitude recorded like this:
lat
long
location
35.05
135.76
Kyoto
44.24
-123.72
Corvallis
The coordinates are from Google maps. The only CRS which ...
2
votes
1answer
52 views
Merging CSV layers (XYZ files with point coordinates)
I have list of many XYZ files with points without header an space delimited.
Example:
-877500 -1014000 471.95
-877500 -1013995 472.28
-877500 -1013990 472.61
-877500 -1013985 473.04
-877500 -1013980 ...
0
votes
1answer
78 views
.gdbtable file type, how GIS reads it, and how to batch-convert it to a CSV?
TL;DR: How do I convert .gdbtable to .csv in Python? Where is the location data in the attribute table?
Using QGIS 3.14. I have a data type which I'm unfamiliar with, a GDB table it appears. The exact ...
5
votes
2answers
165 views
NameError: name 'QMessageBox' is not defined
When I'm loading a CSV into QGIS, I get this error code, see below.
Does anyone know what this means?
This also is an issue when I attempt to run NNJoin Plugin too.
An error has occurred while ...
3
votes
1answer
77 views
Import CSV into polygon shapefile
I have commune level map in shapefile and CSV.
Originally, I have shapefile, exported it to CSV, then to STATA for data manipulation. Then I have exported it as CSV to import to QGIS as polygon.
I ...
0
votes
1answer
30 views
Keeping symbology properties when converting from CSV layer to shapefile in QGIS
Is it possible to keep specific symbology settings when converting from a CSV file to a shapefile in QGIS?
I've added categorised renderer settings within my CSV file layer and don't want to loose ...
1
vote
1answer
60 views
CSV to Vector Tiles: Encoding polygons in Tippecanoe (or some other software)
I want to generate .pdf vector tiles from polygon features. From what I've found out, tippecanoe seems to be the way to go. Like so (found here):
tippecanoe --no-feature-limit --no-tile-size-limit --...
0
votes
0answers
13 views
CSV to NetCDF Python HDF error
I'm basically cribbing code from Esri and other online sources to convert a CSV to a NetCDF. I get an HDF error on writing values to the variables. X and Y values are UTM coordinates if that matters. ...
3
votes
2answers
69 views
Why is the following CSV file not being loaded as a points layer in QGIS?
I've been trying to add a certain CSV file as a points layer to QGIS for a while now, without much success. It can be viewed over here. (It was adapted from this .xls data file). In the online ...
4
votes
2answers
224 views
Combining CSV and shapefile to find area name where stations are located
I have one shapefile with marine areas. The other is a CSV file with some station names and coordinates. I would like to get table with stations names and corresponding marine area names, where the ...
1
vote
1answer
41 views
QGIS point label expression - using a value from another layer
I have a point data with depth values in CSV format as well as a polygon layer with a 'Critical_Depth' attribute. I'm trying to use the label rule expression to change the colour of the text depending ...
1
vote
2answers
53 views
Comma delimited Text failed to read my imported CSV file columns
As you can see after saving my Excel file as CSV (comma delimited) and importing it to the Add delimited layer tool in QGIS, it failed to read the 4 columns and instead read it as 1 single column.
Any ...
1
vote
0answers
35 views
Acquiring pixel data from TIFF-file into CSV-file in QGIS
I have a TIFF-file which gives me a value of forest age per pixel in the whole Amazon basin.
I am trying to do a spatial-statistical analysis between forest age and climatic variables.
For this my ...
0
votes
1answer
86 views
Uploading large CSV-file in QGIS
I'm trying to upload a CSV-file with coordinates of about 80,000 lines, when ever I uploading the file to QGIS, for some reason, the coordinates don't display right and spreading equally. But when I ...
2
votes
1answer
66 views
Exporting only certain features from Attribute Table into CSV
I followed this tutorial to build a plugin and finished all without any problems.
(the plugin's function is exporting attribute table to csv file)
https://www.qgistutorials.com/en/docs/3/...
1
vote
1answer
66 views
Adding a CSV with GPS coordinates points to Google Earth Engine
I'm trying to add a CSV with Lat/Lon to Google Earth Engine.
I looked at the answer below, however, I seem to be making an error somewhere.
Adding x,y coordinates from table in Google Earth Engine
My ...
3
votes
2answers
123 views
Can't read coordinates from CSV file
I'm trying to import a CSV file with geolocated attributes, but the format is not recognized:
Is there a way to automatically recognized it?
EDIT: I think what I need is a batch converter to replace (...
6
votes
2answers
208 views
Import CSV as polygon in QGIS
I have a CSV file with the coordinates of the vertices of my polygons (in the picture they correspond to "left", "right", "top", "bottom"). Actually is a grid ...
1
vote
1answer
36 views
Edit CSV not-spatial table in PyQGIS
I am trying to edit a not-spatial CSV table in PyQGIS 2.18 (i.e. deleting existing fields and adding new one ) for the first time (I can do it with polygonal vector layers but I guess something is ...
0
votes
0answers
24 views
Layer fields refactoring does not work for CSV export file
In my graphical model does not working refactoring layer fields. Entry layer has two fields, which first is string and second is integer.
My Refactoring functions change first column to int and second ...
0
votes
0answers
11 views
Mapping multiple routes from the same csv data file
I'm plotting a set of marches (each span 2-4 locations), and I've got all the latitude/longitude for each march within the same csv file. For marches with more than 2 locations, I've added an order ID ...
1
vote
0answers
34 views
Importing CSV (downloaded from Google Drive) with polygonal geometry data, into QGIS
I formerly used Google Fusion Tables but due to the product downturn I had to bulk-download a backup copy of my data. Right now I have them all saved in CSV format.
I have attribute columns in these ...
2
votes
0answers
29 views
Iterating over layers to export data as a CSV
I'm trying to export particular columns of data from the attribute table to a CSV, I've added in a functionality to remove the excess commas to make this easier so that I end up with two neat columns ...
0
votes
0answers
33 views
Export CSV in Google Earth Engine from multiple point
I want to export the csv file which will contain the data associated with multiple points from the following code. Here I am trying to export one csv file which will contain the datewise data of the ...
1
vote
2answers
38 views
Layer Join and Styling Trouble because of Field Types
I am trying to join a .csv-file with als rates and zip3 values to a shapefile with zip3 values and then color the map based on the als rates.
This seems very simple and I have done similar maps before ...
0
votes
0answers
103 views
Append new data to existing feature class using Load Data in ArcGIS Pro
I am trying to append new rows of data for a feature class that shares the exact same fields (column headers and types) but wasn't able to using Load Data in ArcGIS Pro. In ArcMap, you could easily ...
1
vote
1answer
36 views
Polygons with WKT extension load extremely slow
I am quite new to QGIS. I have temporal data per month for the period of 8 years for all Indian districts (+/- 650 districts). This means I have approx. 65.000 objects in my attributes table. Once I ...
1
vote
0answers
34 views
Converting multicolumns CSV to Raster Format
I need to convert multicolumn CSV file in a raster.
I read some similar question, but my problem is that I have different columns in addition to "longitude" and "latitude" (I would ...
2
votes
1answer
49 views
Creating lines from raw survey data in CSV-file
I work for a survey company and we convert our raw survey data into a GIS format our clients can use and have used MapInfo in the past to achieve basic shapes our clients can use.
I start with 2 CSV ...
0
votes
0answers
20 views
Joining and Editing CSV files in QGIS 3.14
Three questions, I think are very closely related, if not symptoms of the same issue.
I have added a csv file (no geometry) to my project that already contains shp files.
On import of the csv file, ...
0
votes
0answers
24 views
Print Composer: How to use Print Composer Atlas to swap between columns of linked data
I have a map with an openstreetmap layer and a point-layer, in which linked data (rows of a csv-file) is classified in 5 classes (the values are between 1 and 100).
The linked data (csv-file) looks ...
0
votes
0answers
33 views
Is it possible to download the raw data (in .csv form) for EO-1 Hyperion via the Descartes Labs Platform?
I'd like to import it into a Python file to work with it. Also, for EO-1 Hyperion, since I believe its relatively newly uploaded data, will I need to "clean" the data myself?
1
vote
0answers
30 views
ogr2ogr: casting field to string
I am attempting a simple data extraction from an Oracle database to a CSV file using ogr2ogr.exe
(the version packaged with QGIS 3.8 i.e. ..QGIS_3.8\bin\ogr2ogr.exe )
I have a field ("Mapsheet&...
