Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,398
questions
0
votes
0
answers
26
views
Loading null geometry using vector datasource
I have downloaded a very large file of polygon multiparcels as a CSV with supporting csvt and vrt metadata using QGIS and the Vector loader dialog. It loads into a layer beautifully including varchar(...
- 370
2
votes
1
answer
36
views
Missing points datasets global monitor energy
I want to use the GEM data from Global Monitor Energy and incorporate it into QGIS.
I downloaded the Excel data which I converted to CSV.
Then, I wanted to add the layer thus created with the "...
- 35
1
vote
1
answer
44
views
Layers corrupted after saving, closing and opening of QGIS project with PyQGIS
Using a Python script, I create a layer from a CSV file and then write it out to a gpkg file.
I then create a group in the layer tree, load it in the gpkg file and add it as a child of the group. This ...
- 41
0
votes
1
answer
32
views
Aligning separate datasets with different CRS in QGIS for the purposes of terrain modelling
I would like to develop a 3D model of a site located in Vermont, USA. I will be using the state's LiDAR dataset which I am pretty comfortable with. However, I need to coordinate this topographical ...
0
votes
0
answers
62
views
Convert CSV file to shapefile
I've been trying to save my CSV file as a shapefile, but every time I attempt to do so, I encounter an error that says Storing metadata for the specified URI is not supported. I've double-checked the ...
- 1
1
vote
1
answer
60
views
How to use ogr2ogr -segmentize on a CSV file?
Here each line only has two nodes.
$ cat file.csv
WKT,ID,Name
"LINESTRING (-900 -1450,-900 100)",0,900W
"LINESTRING (-800 -1450,-800 100)",1,800W
How can I use ogr2ogr -segmentize ...
- 418
0
votes
1
answer
37
views
Extracting CSV only of coordinate and date of image with lowest NDVI value for points [closed]
I need to extract a CSV only the coordinate and date of the image with the lowest NDVI value, for each point.
var Alertas = ee.Geometry.MultiPoint(
[[-52.97779569036378,-26.131082827324835],
...
2
votes
1
answer
208
views
Newly added CSV file is unavailable in QGIS
In QGIS I am trying to add a CSV file to my project that only has a location and coordinates. Whenever I tried to load the file into QGIS the layer was unavailable. How can I fix that?
Here is my ...
- 21
0
votes
1
answer
33
views
How to export multiband GeoTIFF data to CSV?
I have a GeoTIFF with daily average discharge data over 10 years (3652 bands per grid cell, each band representing one day). I would like to export this discharge data to a CSV file to work with it in ...
- 11
0
votes
0
answers
80
views
Converting CSV to MultiPolygon shapefile in QGIS
I have a MultiPolygon shapefile and the attribute table looks like this.
The district names and state names are jumbled with special characters. I know I can use the replace function in the Field ...
1
vote
2
answers
73
views
Getting all node coordinates of ways of one relation with Overpass
With overpass, I use CSV to create individual formatted output.
All ways of a relation are determined. Here is the code:
[out:csv("print1";false)];
(
relation(id:15596842);
way(r);
) -> ....
- 211
1
vote
0
answers
51
views
Importing Lon/Lat points from CSV file into QGIS
I am working on locating sites in Guinea for a National Parks Infrastructure Project. I have a chart with Long/Lat and I thought I might import them by adding a Delimited Text Layer using a CSV file ...
0
votes
0
answers
48
views
Importing CSV in QGIS results in inverted Y coordinates
I recently did a surveying job using 2 Emlid Reach M2 receivers (a base and a rover). All points were taken using the NAD83 MTM 7 projection. When I try to import a CSV file in QGIS, the Y coordinates ...
2
votes
1
answer
53
views
Adding CSV layer without headers with PyQGIS
I have a CSV file with no headers like this
FOO:ObjList(EPSG:25832)
640410.2620,5493340.3749,23/2024#566.520,00##
640406.4920,5493342.0019,23/2024#566.520,00##
640391.6548,5493327.6581,23/2024#566.520,...
- 14.6k
2
votes
3
answers
84
views
Convert Raster to CSV and plot as points on the grid using Python
I'm trying to convert raster to CSV file with coordinates and plot them and encounter a problem.
I have a raster .tif file with some buildings in Denmark projected in EPSG:7416 CRS.
I read .tif file ...
4
votes
1
answer
204
views
How can I use ogr2ogr to left join a CSV to a GPKG file and produce a GeoJSON output in a scalable way?
I have a large GPKG and a CSV file, and I'd like to (left) join the CSV to the GPKG on one of the columns. A visualisation of what I'm trying to achieve:
Reproducible example
We can create an example ...
- 2,224
0
votes
1
answer
82
views
CSV with Coordinates in QGIS [closed]
I want to upload a CSV in QGIS (add layer "Data source manager", "delimiter text"). Every time when I'm uploading the file it won't show me as a point layer.
What am I doing wrong?
0
votes
0
answers
28
views
QGIS calculated area output as CSV
I have used the graphical modeler to extract polygons. I calculate the areas of each polygon in the attribut table.
Since I have multiple layers, I do not want to use the function Field Statistic for ...
- 677
0
votes
1
answer
77
views
Overwriting hosted table in ArcGIS Online with CSV file from Pandas dataframe in Python
I have a script that I'm using to sort through a very large feature layer with thousands of records and create a summary table of them by type. It also calculates the count of records of the last 5 ...
0
votes
0
answers
33
views
Imported CSV files from Fieldmove and QGIS only displayed as lists
Downloaded some .csv data for an assignment I need to do (from fieldmove specifically), and am trying to display a single point for which i downloaded said data as a csv. file. However, when i try to ...
3
votes
1
answer
154
views
QGIS changes column headers and date time data after export
I have a csv that looks like this:
After I convert the csv to a shape file in QGIS, edit it in QGIS (clip), then export it as a csv, the output looks like this:
What do I need to do to reduce the ...
0
votes
0
answers
36
views
QGIS vector layer attribute table update using CSV - JOIN not working
I have an existing vector layer which I have added features to and updated the geometry existing features. The associated attribute table has 34 FIELDS (with 25 features). I'm trying to undertake a ...
- 1
-1
votes
1
answer
49
views
What is the convention when exporting point locations in a CSV? [closed]
When creating a CVS export which includes a point location, what is the most popular convention to export the data?
I can imagine a few ways
GEOJSON LON,LAT as string
"Lat,Lon"
Lat
Lon
&...
1
vote
1
answer
140
views
Cannot plot geometry on a CSV file (Python)
I'm trying to plot a data about Istanbul's metro lines. The actual data is in CSV format and all of the data is in string. The data is from Istanbul Metropolitan Municipality (https://data.ibb.gov.tr/...
- 25
0
votes
1
answer
69
views
Schema.ini file not being honored by ArcMap, string fields still being converted to numbers when importing CSV to GDB
I am trying to import a CSV to GDB using an ArcMap script tool and preserve some string fields that look like numbers as strings. I added some code to create and populate a schema.ini file in the CSV'...
0
votes
0
answers
37
views
Preserve string field type and leading zeros when using arcpy.conversion.TableToTable to go from CSV to GDB table? [duplicate]
I'm building an ArcMap script tool that will be run on many different input table schemas for geocoding purposes. When importing from CSV to GDB table using the arcpy.conversion.TableToTable function ...
0
votes
1
answer
92
views
Uploading CSV file without coordinates in QGIS
I am very much a QGIS beginner and want a vector layer of food deserts in England, but the only data I can find is in CSV format with no shapefile https://data.cdrc.ac.uk/dataset/e-food-desert-index.
...
- 9
-2
votes
4
answers
267
views
Merging features with same value in table (CSV) [closed]
I have a table (CSV) with statistical data for different neighbourhoods in a city (population according to different age categories).
My problem is that the neighbourhood doesn't have one field per ...
- 7
0
votes
1
answer
50
views
How to generate multi band raster map from CSV
I'm trying to generate a map from a CSV with percent land usages.
The CSV data looks something like the following:
Index x y l1 l2 l3 l4 l5 l6 l7 l8 l9 l10 l11 l12 l13 l14 l15 l16 l17 ...
- 127
0
votes
0
answers
62
views
Adding multiple CSV files to ArcGIS Pro all at same time
I have a folder of CSV files and I was told to add all of the CSV files at once into ArcGIS Pro. The CSV files are all formatted the same way, they include latitude, longitude, depth and time.
Is ...
0
votes
0
answers
30
views
How to generate CSV file for polygons to show in QGIS
My table looks like this:
but adding this as a text defined layer hasn't got me anywhere as X and Y are not clearly defined.
I am new to QGIS.
- 11
-1
votes
1
answer
96
views
PyQGIS: Transform Lat-Long CSV into a UTM project
I have a UTM project in QGIS and need to import some CSV files that are in Latitude Longitude format. When I import it using the GUI, it knows that it is in CRS: 4326 and does a ballpark reprojection ...
- 1
0
votes
0
answers
38
views
Values coming NULL after importing table from Excel
I'm importing a CSV file into ArcGIS Pro, I've used geoprocessing tool XY Table to Point but values have come in null. Column type is double in ArcGIS Pro. Highlighted is the column which imports null ...
3
votes
2
answers
159
views
Create layer from CSV with a bunch of KML polygons
I have a CSV with 3 fields Id,Name,KML polygon. I want to create layers from this polygons in QGIS. I've tried to add delimeter text layer with geometry definition as WKT or without any geometry ...
- 33
1
vote
1
answer
67
views
Converting WGS84 UTM to WGS84 ESPG:2039 in CSV file format
Is there a simple free app or a site that you can just load a CSV file with coordinates in UTM and get a CSV file with coordinates in ESPG:2039?
- 399
0
votes
2
answers
218
views
Create a program that merges attributes from a CSV file with a shapefile
I need to create a program that merges attributes from a CSV file with a shapefile, resulting in a new shapefile named after the CSV file.
How can I do this?
import geopandas as gpd
import os
import ...
- 1
4
votes
1
answer
254
views
What format is this CSV written in?
I would like to work with this set of data and transfrom it into an shapefile, but I have no clue which language it is written in, nor how to convert it. Any hints?:
id,geo_point_2d,geo_shape,muerdago,...
- 51
0
votes
0
answers
23
views
Exporting QGIS layer to Gephi
When trying to export a QGIS multistring line layer to Gephi through a CSV file it gives the error that the CSV is lacking Source and Target attributes in the layer. Since there is already a similar ...
- 27
1
vote
0
answers
33
views
Accented characters in CSV file appear as '?' when importing to QGIS 3.34.2 [duplicate]
I am trying to import a CSV set of data to join to a shapefile in QGIS but the accented characters and ñ character are displayed as missing in the attribute table and performing a join is impossible.
- 11
3
votes
1
answer
89
views
This code is giving me empty line layer
This code run well but produces an empty line layer with no attribute
from qgis.core import QgsPointXY, QgsFeature, QgsGeometry, QgsProject, QgsVectorLayer
from qgis.utils import iface
# Path to your ...
0
votes
0
answers
37
views
Adding source and target fields to attribute table
I am trying to find a way to add source and target to a CSV file which is being exported to Gephi (network analysis software) for a edges (line) layer. However, when importing into Gephi I am missing ...
- 27
-1
votes
1
answer
77
views
Loading CSV files using PyQGIS [closed]
This script works with older version of QGIS but not the latest one.
What is wrong with this script?
I do not think the space in the directory name is the cause.
import os.path, glob
from qgis.core ...
2
votes
0
answers
74
views
Appending/translating CSV data to GeoPackage with drop drown attribute Fields
I will preface this with some context. I've created a data collection Project that I use in QField, comprised of multiple Geopackage layers that have been heavily modified in the Attribute Forms ...
1
vote
1
answer
82
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
259
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,...
-2
votes
1
answer
78
views
Converting GeoTIFF to CSV using QGIS [closed]
I'd like to covert GeoTIFF to CSV by using QGIS.
How can I do it?
- 7
2
votes
1
answer
70
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
252
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
195
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
50
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 ...
