Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,140
questions
4
votes
2answers
81 views
Drawing line between two points from another CSV in QGIS
I have two large CSV files, one that defines the location of each point as:
point
lat
lon
attribute 1
And another that has data on what lines exist between them
point A
point B
attribute 2
...
1
vote
1answer
32 views
How to filter WFS on basis of values in a (csv) list in QGIS?
I have made a map in Qgis (3.20) and added a layer of OGC WFS polygon from an online service. This layer displays coloured surfaces where buildings are, for the whole country.
I also have a list of ...
2
votes
0answers
41 views
Layer writing / exporting time in QGIS takes far too long
I am finding that QGIS takes quite some time when writing or exporting large datasets (approx 5 million records). A task I'm currently doing requires me to export 5 million points to a CSV, and this ...
1
vote
2answers
39 views
QGIS - Visualize GML with CSV metadata
I have a file with 3D building information (GML file with building id and coordinates).
Also, I have a CSV file with the same building IDs, coordinates (X-Y and Longitude Latitude), and additional ...
0
votes
0answers
14 views
ArcGIS Pro CSV to point eliminating points
I am looking to explore the air quality in Ireland.
I have downloaded the Ireland, PM2.5 CSV data from https://discomap.eea.europa.eu/map/fme/AirQualityUTDExport.htm
I opened the CSV and found there ...
0
votes
0answers
12 views
Using CSV file to populate entries in *new* ArcGIS Online Story Maps
On the old ArcGIS Online Story Maps, you could upload a csv with a list of URLs linking to photos/videos, plus coordinates and other details for each entry. This would automatically populate the map, ...
1
vote
1answer
31 views
Converting CSV file with polygons in dictionary format into GeoDataFrame [closed]
I have a CSV file with data in below format. I want to read this using Python into a GeoPandas' DataFrame where boundary becomes geometry. I'm not even sure where to begin with.
pincode city ...
5
votes
2answers
220 views
Counting fire occurences per county per year using QGIS
I wish to loop through this shapefile, and for each "COUNTY_NM", count the number of values corresponding to each "layer" value.
I want to output a CSV or equivalent which would be ...
0
votes
1answer
36 views
CSV file with longitude and latitude coordinates of continents borders
As the title says I need .csv with coordinates of the world's continents. All I can find on the Internet are coordinates of world cities, which is not exactly what I am searching for. I want to make a ...
-1
votes
2answers
75 views
How to export large data from ArcMap to use in Python/R
The number of rows in my shapefile attributes greater than 65535. I can't export the table to Excel.
Is there any way to generate the file to CSV to any other format which will be convenient to use in ...
2
votes
2answers
68 views
Loading multiple CSV files in QGIS and declaring encoding
By the following code from the other post, I was able to load multiple CSV files into QGIS.
import glob, os
# Define path to directory of your csv files
path_to_csv = "C:/Users/You/Desktop/csv ...
0
votes
1answer
40 views
Animating time series with points in polygon in QGIS
This was probably asked before but I am not very good with the terminology so cannot seem to find what I am looking for.
I have a large set of data that has the parameters; date, longitude, and ...
4
votes
1answer
62 views
Efficient analysis of large amount of CSV files in QGIS
I have hundreds of CSV files with geometry values in the same folder, and I'm trying to import all into QGIS, and use 'count point in grid' function to see how many of each data on each grid.
I've ...
3
votes
3answers
68 views
Creating line layer from point layer with start and end attributes
I have a CSV file that contains attributes for a start node and end node of a pipe in a single record. This is data collected in the field, so the inspector captures the lat/long at each end of the ...
2
votes
0answers
39 views
Why QGIS using different coordinate order depending on import type GML / CSV
I am using QGIS 3.20 (Odense)
I am importing same polygons from GML3 and also from a CSV file.
In GML, all geometries are assigned a single coordinate system EPSG:2180 (srsName="urn:ogc:def:crs:...
0
votes
0answers
25 views
ogr2ogr to CSV with quotes breaks with NULL values
I have some data stored in a Postgres 13 Postgis 3.1 table that looks like
id(integer),valid_to(timestamp),language(varchar),name(varchar)
1,2021/08/16 11:19:06.493,eng,London
2,2021/08/16 11:19:06....
3
votes
2answers
109 views
Converting CRS from EPSG:4326 to EPSG:32635 using PyQGIS
How in QGIS 3.16 to convert from CRS EPSG:4326 to CRS EPSG:32635 using Python?
I got this error:
exec(open('C:/Users/aaa/AppData/Local/Temp/tmpovpzt0d0.py'.encode('utf-8')).read())
Traceback (most ...
3
votes
1answer
100 views
Converting CSV and reprojecting shapefile to match location of points
I have a .csv file with coordinates which should be converted into .shp file. The CSV file is built by analysing simple .tif raster without metadata.
As far as no CRS is saved in .csv file, the ...
0
votes
1answer
56 views
Import CSV with longitude and latitude coordinates in QGIS
I have a CSV file with the first two columns containing longitude and latitude values.
Now I want to create a point layer via the "add delimited text-layer" in QGIS. I have a problem with my ...
0
votes
0answers
21 views
Stamps PSI export for QGIS Smart-Map plugin
I have successfully processed PSI analysis with SNAP/StaMPS for the very first time.
I exported a KML as well as a CSV file.
Now, I want to try out the Smart-Map plugin in QGIS, yet I have not much ...
1
vote
1answer
95 views
Why points were not imported from Excel file into QGIS? [closed]
I have a data of multiple x and y coordinates in UTM format saved in an Excel CSV file format then added it as a delimited text layer in QGIS. I set the geometry definition as "point coordinates&...
-2
votes
1answer
36 views
Creating shapefile from CSV file with geometry in WKT [closed]
I would like to get some help creating a polygon shapefile using a CSV (geometry). I have copied the first few rows. I use ArcGIS and a little bit of QGIS. Step by step give will be very helpful, I ...
2
votes
4answers
105 views
Imported CSV file with x/y coordinates shown on Null Island in QGIS
Basically, I have a CSV table with lat/long coordinates that I am trying to upload onto a map. However, when I "add text delimited layer" it puts the spots in the completely wrong location. ...
1
vote
1answer
31 views
Using .CSV file as an external dictionary, but can't find a way to reference/make a key for Null in order to assign it a value using ArcPy
I am using ArcGIS Desktop: ArcMap 10.8.1 and using Python 2.7.18. I have a script that uses a .CSV file as an external dictionary (opposed to creating a dictionary within the script) but I cannot find ...
1
vote
0answers
15 views
How do I access the metadata or the transform information for the output of GDAL function?
I georeferenced some images using the GDAL module in python and some images using the QGIS function. The output of GDAL was good, but then it did not have any metadata information. For example, if I ...
3
votes
1answer
59 views
Printing geographical centroid coordinates of georeferenced image in CSV file
I am trying to print the centroids of the circular contours from the image.
The image is already georeferenced using GDAL with ESRI 102025 and I tried to extract the points in terms of the ...
2
votes
1answer
58 views
Find and delete duplicate rows in matrix in QGIS 3.6
I used the OD Matrix to produce a list of the distances between all sites to all other sites via a network. This process produces duplicates, since it makes calculations in both directions, i.e., from ...
1
vote
1answer
40 views
Creating grid cell and associating to each row (point) by the cell id
I have the following data in CSV: latitude and longitude of the geolocation of violent events, where they occurred, which actors where implied, etc. Each row is a different event with a different ...
2
votes
1answer
28 views
How to increase shapefile creation speed from CSV file in GeoTools
I want create shapefile from CSV. Here is my code
File file = JFileDataStoreChooser.showOpenFile("csv", null);
if (file == null) {
return;
}
final SimpleFeatureType ...
0
votes
0answers
42 views
Why do images in Open CV template matching get matched to the templates more than once?
The following code reads the set of input tiff files under tiffile and template tiff files under files and performs template matching on them. After the image gets matched, opencv contour extracts the ...
2
votes
1answer
66 views
Importing multiple CSV files in QGIS 3.18 with PyQGIS
I have a folder C:/Users/MyPC/Desktop/Test, where there's multiple CSVs in it. I'm trying to import all CSVs into QGIS at once. I've tried to modify (the encoding part) the method from
Loading ...
-1
votes
1answer
64 views
How to process list of gcp points in gdal in python?
I have gcp points that I am exporting from QGIS and I would like to georeference several maps using the gdal module in python by using these points.
The following is the code to read the gcp points ...
4
votes
1answer
80 views
Populating QTableWidget with CSV file using PyQGIS [closed]
I've managed to populate a QTableWidget with data stored in a database with the code below:
self.cur.execute("""SELECT column1, column2, column3, column4 from schema.table WHERE ...
4
votes
1answer
84 views
Issue importing CSV file to QGIS and use it as shapefile
I'm trying to import a CSV file to work on a point shapefile in QGIS 3.14
In Excel, my CSV is as follow : ID, X&Y coordinates, and another field (H)
I then go to Layer - Add a Layer - Add a text-...
0
votes
0answers
17 views
Python code to recognise and convert from CRS [duplicate]
I have a Python function which converts Eastings and Northings to Latitude and Longitude
These Eastings and Northings are given in CSV format like so:
Name
Easting
Northing
The python code is then ...
1
vote
1answer
38 views
Adding data from CSV file to new attribute fields in QGIS
I'm very new to QGIS and have started by downloading a shapefile and importing it. The attribute table had only 1 attribute field ("name"). We needed more attribute fields so I manually ...
1
vote
1answer
63 views
Exporting table without .geo and system:index in Google Earth Engine
How do I export a table (CSV) without .geo and system:index in Google Earth Engine?
These two parameters are automatically added when I make a feature.
What I'm trying to do is extract some properties ...
0
votes
1answer
59 views
Rendering CSV file as annotation on QgsMapCanvas
I am trying to render a CSV file as an annotation layer on QgsmapCanvas using QGIS3 C++ API.
but when I make a vector layer using "delimitedtext" as data provider and test layer->isvalid()...
1
vote
1answer
31 views
Imported .csv file plotting incorrectly
I have imported a csv into ArcGIS, then displayed xy data. For some unknown reason to me, the point are plotting incorrectly. I am using an ESRI base map in WGS 84 web mercator aux sphere and the ...
0
votes
0answers
76 views
Batch geocode addresses using a REST API (ArcPy, CSV, Server)
My stand-alone Python script tries to geocode a CSV file of addresses.
The script successfully geocodes this CSV file when using the *.loc file for this locator but not the published REST API.
ArcGIS ...
2
votes
1answer
46 views
Load .csv as point vector on QGIS
Good morning,
I have a .csv file with more than 2000 rows that I would like to upload to qgis as point vector. When I add the text layer it loads only 1 value.
I have selected as X field the X ...
2
votes
2answers
41 views
How should I organize multiple X and Y coordinates in my data file?
I want to keep an Excel sheet containing flight records. Then I want to use QGIS to plot the coordinates. I would like to keep all data for each flight on one line. Is this possible?
When I add a CSV ...
0
votes
0answers
78 views
Issue importing CSV with CSVT (fields format not applied - QGIS 3.18)
I'm trying to import a CSV file with some data and hoping that QGIS will properly format the fields type but so far no luck.
I have my data in a file called coords.csv and I made a single line text ...
6
votes
3answers
163 views
Empty result when geocoding address in Sweden using MMQGIS
I am trying to geocode an address in QGIS. I am aware of the MMQGIS Plugin and I have been trying to use that.
The dialogue window appears as though it is catered to US addresses as it contains a ...
5
votes
3answers
120 views
Populating attributes while creating polygons in for-loop from CSV using PyQGIS
I have a working script that builds rectangles from a CSV using @Kadir Sahbaz's answer and @Ben W's answer
I'm wanting to pass non-geometry attributes as well. This runs and creates the fields but ...
1
vote
2answers
67 views
Creating rectangles from CSV coordinates via Python console in QGIS
As of v3.10, there is an asPolygon method for qgis.core.QgsRectangle.
This runs:
QgsRectangle(1804512.8556, 5453390.58088, 1813512.8556, 5461390.58088).asPolygon()
However, no vector data (i.e. an ...
0
votes
1answer
187 views
Python script to import CSV data to a geodatabase
I am trying to import CSV data into an existing geodatabase in ArcMap. I want to import to the existing geodatabase fields to ensure my CSV data satisfies whatever rules are set up in the geodatabase.
...
4
votes
1answer
135 views
Exporting CSV of time-series for every polygon from table of polygons
My question has a similar intention as in this link: Exporting time series of multiple polygons to .csv. format table
However, in my case, following this code, the table output runs for hours and then ...
4
votes
3answers
116 views
Creating multiple separate vector lines from list of coordinate pairs in QGIS
I'm a QGIS user with 2 years of experience but I don't know how to do this task easily. I'm on QGIS 3.10.6 A Coruna.
I know how to import CSV coordinate points and then convert them to a vector using &...
2
votes
2answers
70 views
Getting CSV export to have different delimiter using ArcGIS Pro
ArcGIS Pro, using Table to Table tool, I want to export to CSV. But one of my fields is a description field that often has commas in the content. When that is exported to CSV that uses commas as ...
