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 ...
