Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,224
questions
0
votes
0
answers
9
views
How to Export/Print Version differences between child version and default version from ArcGIS Pro to an Excel spreadsheet or .csv file
How to Export/Print Version differences between child version and default version from ArcGIS pro to an Excel spreadsheet?
When I have a version other than the default, and click on version changes in ...
1
vote
1
answer
26
views
Problems with uploading point coordinate British National Grid data into QGIS as .csv file
I'm very much hoping someone can help me with this, please. I have uploaded raster data from Digimap to use for maps for field sites for my research in the UK. The issue is that this map data use ...
- 11
-2
votes
0
answers
25
views
Unable to add delimited text file using PyQGIS and CSV [closed]
I am using the following code
uri = "C:\\Users\\Tejas\\Downloads\\sample\\sample\\AWS-FINAL-USE.csv?delimiter={}&xField={}&yField={}".format(";", "LON", "LAT&...
2
votes
0
answers
31
views
Loading CSV File as Vector Layer from URL,Remote,Server (QGIS)
QGIS 3.24
I want to load a CSV file as a Vector Layer from my Server. The CSV file is regularly updated with new coordinates from a GPS tracker.
My code:
uri = "/vsicurl/http://mydomain.at/iot/...
- 21
0
votes
0
answers
28
views
Python way of finding CRS of CSV file
I have a CSV like below:
X Y Z
626066.43 234058.2 6.69
626066.43 234059.2 6.89
626066.43 234060.2 7.06
626067.43 234057.2 6.69
626067.43 234058.2 6.89
...
- 41
3
votes
2
answers
116
views
Imported CSV data points showing in wrong location
I have vector points I have uploaded in a CSV file. The coordinates from the surveyor were in Map Grid of Australia (MGA2020).
The base map I use is Google Maps which I also change the CRS to MGA2020 ...
- 33
0
votes
1
answer
38
views
How to generate ov2 poi programmatically from csv source
I'm looking at how to generate an ov2 file programmatically. Mainly I use python and I found something like this. But that kinda vague. I can't find documentation on how the file is build up. Also it ...
- 115
4
votes
1
answer
32
views
Using values from table in QGIS Modeler for filtering
I have a list of values (species names) in a .csv file and a vector layer of sightings of many species.
Is there a way to load the list in the QGIS Modeler and use it to filter my vector layer so that ...
6
votes
1
answer
146
views
Generating x, y, coordinates within polygon/polyline with certain interval in QGIS
I need all the x- and y-coordinates with a interval of 500 meters that fit inside a polygon/polyline.
For example I want to generate a CSV file that looks like this:
x, y,
10000, 30000
10500, 30000
...
- 73
2
votes
1
answer
44
views
Select records by area and update value of CSV
In my little project I have a CSV with more rows than I can count, and I am trying to find a tool that can do the following:
Plot each record on a map using their lat lon coordinates, interactively ...
- 51
3
votes
2
answers
90
views
Creating CSV with lat/long from point shapefile using Python [duplicate]
Does anyone know how to create a CSV containing lat and long fields from a point shapefile in Python? I can only find info on how to make a shapefile from CSV with lat/long and not the other way ...
- 85
3
votes
1
answer
94
views
Creating separate layers from single CSV file in QGIS
I would like to add a single CSV file, which can then be separated within QGIS into separate layers.
With the aim of being able to turn off all layers except for 1 area that I am working on.
I ...
- 39
4
votes
2
answers
196
views
Geopackage in QGIS: Search and replace in all attribute fields at once
The context
I have a Geopackage file opened in QGIS. It was created by importing a CSV file. However, when importing, something regarding encoding went wrong: I have several special characters like ...
- 40k
0
votes
0
answers
43
views
Displaying a CSV layer and a .shp layer in the same project
I'm a newbie to GIS and particularly to QGIS. I am using QGIS 3.22.5 on MacOS 12.3.1 Monterey.
I want my project to display two layers. One layer is sourced from a CSV delimited text file. The other ...
- 1
2
votes
1
answer
121
views
Problem joining multiple matching rows from non-geometry CSV file
I am using QGIS 3.24.0. I have a shapefile, called "Map_CorrectionDEF, in which one of the fields is "unitcode". On the other hand, I have a CSV file, called crop_main (no geometry), in ...
- 445
6
votes
2
answers
119
views
Adding points with coordinates delimited by commas from CSV file in QGIS Python Console
I can't figure out how to add point from a CSV file with the Python Console.
This is my CSV file:
UTM32_E;UTM32_N
562834,932;8762874,054
560758,523;8762624,904
562483,074;8762760,832
562131,643;...
- 115
0
votes
0
answers
62
views
Issue with Python Script: Overwriting Hosted Feature Layer on ArcGIS Online: Error Code: 406
I need assistance with my script. Can anyone point me in the right direction?
I'm attempting to overwrite a feature layer with data from a CSV file, both of which are hosted on my portal on ArcGIS ...
3
votes
1
answer
52
views
Exporting feature attributes to CSV with PyQGIS
I've retrieved some attributes and coordinates from a point layer in QGIS:
path_file = myfile
layer = QgsVectorLayer(path_file, "name", "ogr")
QgsProject.instance().addMapLayer(...
- 83
1
vote
1
answer
48
views
Coordinates in delimited text interpreted as attributes instead of as point geometry
Delimited text fields with coordinates, although present in the attribute table, are not displayed on the map. And in general, only displayed as data in the file. See pictures.
Can you tell me where ...
- 51
3
votes
1
answer
67
views
The layer does not appear
My task was to upload a CSV file to QGIS. The CSV contains location data. When I load a layer, what happens is that a layer appears that contains the correct attribute table, but the points don't ...
- 51
0
votes
0
answers
16
views
Selecting an FID column from a CSV file and assigning it to variable to query
I'm trying to create a wordle game and I'm running into issues trying to query the list of countries that I have in a separate CSV file. I keep running into errors and I'm not really sure what method ...
- 1
1
vote
2
answers
30
views
QGIS regular expression while importing delimited text
I have a CSV file with following format :
UTC,Callsign,Position,Altitude
2021-05-11T11:44:38Z,FABCD,"28.084,7.452",500
...
So I can't import with personalized delimiters. I tried to use ...
- 829
0
votes
1
answer
63
views
OSM and imported points do not match in QGIS
I am trying to insert new coordinate system to the QGIS ( ferom excel comma delimited file), but unfortunately the coordinates do not overlap the correct point in OSM inside.
Below there are ...
3
votes
1
answer
82
views
How to create a polygon from a CSV file with coordinates using PyQGIS?
I like a write a script which:
Imports a CSV file that contains a series of points (latitude and longitude) into QGIS
Lat
Long
56.99181358
-111.4801108
56.98924901
-111.4764563
56.98591437
-111....
- 93
2
votes
2
answers
144
views
Adding points with coordinates from CSV in QGIS
I want to add to my vector file layers with some points to show animals occurrences in Germany for different years.
I have all the coordinates in a CSV file (see image attached) but when I want to ...
- 399
1
vote
0
answers
39
views
Field formatting issue (importing XY Data from CSV - Python)
I'm using ArcGIS Pro 2.7.0. I'm working on a python script that brings in X,Y data from a CSV using the arcpy.MakeXYEventLayer_management tool provided by the ArcPy module. The ultimate goal is to use ...
1
vote
0
answers
42
views
QGIS. Combining points data on a map with attributes in polygons
I have a project where I'm trying to combine flood risk data to a list of postcode (/zipcode) data. The postcode data is a csv that contains each postcode's easting, northing, longitude, and latitude ...
- 11
1
vote
1
answer
64
views
Joining a CSV file to a shapefile based on string fields with different length values [closed]
I am trying to join a CSV file to a shapefile based on string fields with different length values. The values on the CSV file contain up to 16 digits where as the values on the shapefile contain 9 or ...
- 347
1
vote
0
answers
35
views
I have imported CSV files as new layers, saved them as shapefiles, but the points are not rendering onscreen: they are at the top of the stack [closed]
M1 Mac, OS Monterey 12.2.1; QGIS v 3.16. If I select one of these layers and choose 'zoom to layer', it zooms to where the points should be but they are not visible, so clearly, their positions are ...
- 21
0
votes
1
answer
53
views
Performing near point-to-point merge with ArcPy?
I have a series of .csv datasets with points in Lat/Long mapped to Town Names:
In addition, I have a shapefile containing similar data (town names with their corresponding x/y):
I also have ...
- 13
6
votes
3
answers
463
views
Import unknown text polygon format to QGIS
I'm trying to visualize this park in the DRC.
Thinking it was a WKT polygon, I isolated one shape as a test and saved it as a CSV.
Here
{"attributes":{"OBJECTID":27,"NOM":...
- 81
0
votes
1
answer
27
views
Longitude not appearing when selecting Display XY data from table using ArcGIS Pro
I am attempting to add the Latitude and Longitude from a large (6000 row) .csv file into an ArcGIS Pro map. Only the "Latitude" field is appearing, and Longitude is no where to be found. I ...
- 1
3
votes
3
answers
182
views
Reprojecting list of latitude/longitude values in .csv to points using ArcPy
I am creating a tool using Python to convert .csv files into points. However, the points were collected in EPSG: 2274 and not WGS84 (EPSG:4326), so in order to create the points I have to convert the ...
- 357
1
vote
1
answer
27
views
Set title on QGIS map from variable in csv data layer
How can I set the title of a QGIS map based on a name I pass in a .csv file?
I create a separate file 'tombstone_data.csv' that contains two fields like this:
source,update_rate
FlightRadar24,1 x per ...
- 11
1
vote
1
answer
27
views
Making ogr2ogr convert from CSV to SpatiaLite while keeping capital letters on the header
Let's say I have the following input.csv file:
Column1,Column2,latitude,longitude
testData,TestData,-23.547384,-46.643363
testData,TestData,-23.555297,-46.635642
I know I can convert it from CSV to ...
- 1,021
4
votes
2
answers
180
views
Batch exporting GeoPackage attribute table to CSV in QGIS
I have a large quantity (200+) of GeoPackage files, and I want to export the attributes table of all of them to CSV's. Is there a way I can do that in the GUI or with a Plugin for QGIS 3.16.15?
...
- 65
1
vote
1
answer
99
views
Exporting frequency histogram result for *image collection* as CSV in GEE
I am trying to export a feature collection of histogram data for an image collection as a table in GEE. The image collection has three bands, NDSI_Snow_Cover, NDVI, and "remapped," which ...
- 33
0
votes
1
answer
46
views
Google Earth Engine: moving points in a feature collection?
I have a .csv that contains 200 points, with several properties. I've imported this asset as a feature collection. All of these points should be over water, but there is a margin of error (a known ...
- 75
1
vote
2
answers
91
views
How to add GPS points from a CSV/Excel file to a QGIS project? [duplicate]
I thought I knew QGIS quite a bit by now, but a straight forward simple task recently brought me close to frustration. I had collected the GPS coordinates of points using my cellphone in an Excel ...
- 63
1
vote
1
answer
38
views
Projection of CSV file is not aligning with shapefile
I am new to QGIS and am exploring some open data sets from NYC as a self-guided project.
I am trying to map the branches of Brooklyn Public Library with a simple base map file of NYC streets, zip ...
- 31
2
votes
1
answer
70
views
Colouring various symbol layers, colour data from another CSV
I'm using QGIS 3.22.
The problem: I have various layers with coloured symbols based based on CSV-layers. Here you find an exemplary point data CSV (but there are also CSVs with polygons), named "...
- 111
0
votes
0
answers
103
views
Exporting monthly average NDVI for number of addresses from MODIS data to CSV using Google Earth Engine
I am trying to calculate the monthly average NDVI for a number of addresses with buffer (300m) for the 2018-2019 period using MODIS data and then save the results to a CSV file with each address ...
- 93
0
votes
0
answers
77
views
Adding delimited text layer
I have QGIS version 3.16 long term release.
Today I was trying to add a delimited text layer (.csv format), as I have done many times, but when I went to make the points graduated (size) based on an ...
- 1
0
votes
1
answer
34
views
Importing CSV table with coordinates to Google Earth Engine
Exactly the same problem as this: Adding a CSV with GPS coordinates points to Google Earth Engine
I have tried the solution to redownload the .csv file as mentioned here but that did not work.
I have ...
- 21
2
votes
2
answers
161
views
QGIS loads CSV file, recognizes coordinates but doesn't display data
I do understand that this question (in some form or another) has already been aksed and answered on various forums, but i still cannot find a working solution.
I'm trying to import a .CSV file to QGIS ...
- 29
4
votes
2
answers
108
views
How to combine raster data into CSV attributes in QGIS
Recently I am working on some raster data transfer in to .csv. I am doing this manually. First I upload my coordinate points in to raster then I click the information button then I click on every ...
- 91
3
votes
1
answer
87
views
Divergence in the number of observations between "Show Feature Count" and Attribute Table using QGIS
I have a CSV file with 187.533 observations. They are points, violence events with their latitude and longitude. I import the CSV to QGIS (version 3.20.1). When I clicked to "Show the Feature ...
- 445
4
votes
1
answer
178
views
Missing points when I import from CSV to QGIS
I am trying to import a file from CSV to QGIS (version 3.20.1). However, when I import the data, some values (points) are missing.
I know that this question have been already asked but I have tried ...
- 445
0
votes
1
answer
244
views
Loading and writing CSV file in QTableView with Python 3.10 for QGIS Plugin
I know there are a lot of similar questions... but I can't implement them.
How can I load a CSV file and write that into a QTableView?
My first step was to browse it.
def select_input_file(self):
...
- 1
0
votes
0
answers
29
views
Import format in kepler.gl from QGIS
I try to export layer from QGIS to CSV, JSON or GeoJSON to add data in kepler.gl.
I think I tried all options : geometrycollection or not, GeoJSON newline limited or not, comma, semicolon, CSV with ...
- 412