Skip to main content

Questions tagged [csv]

A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.

Filter by
Sorted by
Tagged with
0 votes
0 answers
22 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(...
KimO's user avatar
  • 345
2 votes
1 answer
35 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 "...
AlexandreBAZ's user avatar
1 vote
1 answer
42 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 ...
John_nz's user avatar
  • 31
0 votes
0 answers
14 views

Conversion of NDVI time series to CSV and exporting issue [closed]

I am trying to run NDVI time series code and export the maximum annual NDVI to CSV. Facing error every time I am running the code to convert it to CSV and exporting. I am manually able to create chart ...
SHREYA PANDEY's user avatar
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 ...
Carlos Guzman's user avatar
0 votes
1 answer
48 views

Loading comma separated value into QGIS 3.36.3 is problematic [closed]

I have a West Virgina oil and gas well CSV file. I tried to load it to a layer using the 'Add delimited text layer' option. It did load but utterly mangled the layer attributes upon conversion. I ...
Carl Huxohl's user avatar
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 ...
Asma's user avatar
  • 1
1 vote
1 answer
56 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 ...
Dan Jacobson's user avatar
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], ...
clovis cechim's user avatar
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 ...
Amikiri's user avatar
  • 21
0 votes
1 answer
31 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 ...
timmer's user avatar
  • 11
0 votes
0 answers
75 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 ...
Gopalakrishnan B's user avatar
1 vote
2 answers
67 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); ) -> ....
gotwo's user avatar
  • 213
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 ...
Cresolus Climate Responsive De's user avatar
0 votes
0 answers
46 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 ...
watershedtech's user avatar
2 votes
1 answer
50 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,...
Jochen Schwarze's user avatar
2 votes
3 answers
83 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 ...
errenmike1806's user avatar
4 votes
1 answer
200 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 ...
zabop's user avatar
  • 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?
Vivien Müller's user avatar
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 ...
BAE_23's user avatar
  • 677
0 votes
1 answer
69 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 ...
Fred Mitchell's user avatar
0 votes
0 answers
32 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 ...
That Rock Guy's user avatar
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 ...
Angela Russell's user avatar
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 ...
finchys's user avatar
-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 &...
Scott Weinstein's user avatar
1 vote
1 answer
136 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/...
Hilmi Emre's user avatar
0 votes
1 answer
68 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'...
Paul DiGirolamo's user avatar
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 ...
Paul DiGirolamo's user avatar
0 votes
1 answer
91 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. ...
Emily's user avatar
  • 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 ...
Klara H's user avatar
0 votes
1 answer
48 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 ...
Ark Lomas's user avatar
  • 127
0 votes
0 answers
61 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 ...
Jennifer Lorden's user avatar
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.
Hemproski's user avatar
-1 votes
1 answer
94 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 ...
JeffF's user avatar
  • 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 ...
user237914's user avatar
3 votes
2 answers
156 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 ...
Artem Sh's user avatar
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?
YuvalM's user avatar
  • 399
0 votes
2 answers
214 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 ...
Spark 99's user avatar
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,...
Giscap's user avatar
  • 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 ...
CarloseNew's user avatar
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.
IDHA's user avatar
  • 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 ...
banjo martins's user avatar
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 ...
CarloseNew's user avatar
-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 ...
Kumar Navulur's user avatar
2 votes
0 answers
72 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 ...
Kelson Willms's user avatar
1 vote
1 answer
80 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/...
Ana Catarina Vitorino's user avatar
2 votes
3 answers
258 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,...
Florian Ledermann's user avatar
-1 votes
1 answer
76 views

Converting GeoTIFF to CSV using QGIS [closed]

I'd like to covert GeoTIFF to CSV by using QGIS. How can I do it?
SSS's user avatar
  • 9
2 votes
1 answer
66 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 ...
user233372's user avatar
3 votes
1 answer
244 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 ...
Dia's user avatar
  • 31

1
2 3 4 5
28