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

1
2 3 4 5
23