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
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 ...
user avatar
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 ...
user avatar
-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&...
user avatar
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/...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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;...
user avatar
  • 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 ...
user avatar
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(...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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....
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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":...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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? ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 "...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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): ...
user avatar
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 ...
user avatar
  • 412

1
2 3 4 5
25