Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
974
questions
1
vote
1answer
23 views
Display XY data not displaying for some rows in a CSV, but displaying for the rest
I am using ArcMap 10.7 to map data points (decimal degrees) across eight countries. I have an Excel .csv file that contains the data points (548 rows), but when I import the data (as a .csv) and try ...
0
votes
1answer
17 views
Calculating area of water pixels, and plotting them in Google Earth Engine
I am trying to create a time series of the total area of water pixels in a particular region using the ee.Image.pixelArea() method. I understand that this method creates a raster whereby the value of ...
0
votes
0answers
22 views
Creating Thiessen polygons using ArcMap
When creating the Thiessen polygon for a X,Y co-ordinates. It is showing like this. When I set the extent manually I'm not getting the polygon properly.
0
votes
1answer
29 views
Google Earth Engine: join featureCollections
I have two feature collections, produced using the reduceRegions function, from different image collections. I can export both as CSV, but I've been trying to join or merge them so I can export them ...
0
votes
0answers
7 views
Generating a distribution map without x and y from given raster-grid into given polygons
I am working on an archaeological map for an excavation. I have given polygons which represent my archaeological layers (SE). Over that I have an grid with 1mx1m from which I have my findings. Each of ...
0
votes
0answers
16 views
Filesize CSV to PostgreSQL - PostGIS [closed]
I have a set of different XYZ files. A total of 40GB.
Every set has points in XYZ to a CRS (hydrographic surveys).
I would like to upload the files in a PostgreSQL database with 2 columns:
GEOM
"...
1
vote
0answers
12 views
QGIS 3.10 drop-drown list (value relation)
I am using QGIS 3.10. I created a field with a drop-drown list of 10 country names (using an imported csv file) . Is there an option to add a country that does not inculded in the list manually ...
0
votes
1answer
37 views
QGIS points disappear after changing CSV file location, changing data source doesn't help
I moved my database and shape files, and wanted to relink them to my QGIS project. The shape file worked fine, but the CSV file wasn't reloading properly no matter what I tried. I could see the fields ...
1
vote
0answers
35 views
Importing multiple CSV-files without coordinates into schema in QGIS 2.18 [closed]
I have multiple CSV-files that I need to import into a database in QGIS 2.18.
The data contains Australian Postal Code information hence does not have x,y (lat/long) coordinates in it.
How can I load ...
1
vote
0answers
12 views
Exporting NDVI CSV data of a rectangular region
I am using the MODIS MOD13Q1 NDVI in the Google Earth Engine for my thesis project. I created a rectangular region to export CSV data. But I am having trouble exporting the NDVI data associated with ...
0
votes
2answers
87 views
Concatenate/combine specific data from multiple HDF5 files into a single CSV file in Python(with code for converting single hdf file to csv file) [closed]
Suppose I have multiple HDF5 files in my E:\NASA directory and want to compile/concatenate the lat (path in HDF5: xxx.HDF5/XS/FLG/latitude), long (path in HDF5: xxx.HDF5/XS/FLG/longitude) and ...
3
votes
2answers
69 views
Changing data in QGIS using a CSV
I have a table with id and date
Users are not really IT-literate so anything involving a join might be too complicated for them, but they love Excel. They can easily change their spreadsheets but ...
0
votes
1answer
35 views
Converting a FLIR image CSV to TIFF using Python
I have a geolocated CSV file containing one lat, long coordinate for the entire thermal image. I would like to convert this CSV to a TIFF using Python so that each pixel contains a temperature. All ...
-1
votes
0answers
35 views
Concatenate/combine specific data from multiple HDF5 files into a single CSV file in Python
Suppose I have a multiple HDF5 files in my E:\Rain directory and want to compile/concatenate the lat (path in HDF5: xxx.HDF5/MS/latitude), long (path in HDF5: xxx.HDF5/MS/longitude) and precipitation (...
1
vote
1answer
32 views
Point dataset from CSV showing up outside of known region [duplicate]
I'm using QGIS and trying to display point data from a CSV file. I've added a vector layer with a shapefile of Canada. Both the project CRS and the shapefile CRS are set to NAD83 / Statistics Canada ...
1
vote
0answers
17 views
Importing a Tracked Line Geometry (from LineString) in a CSV into QGIS (3.4)
I'm very new to GIS work and I hope this is the right place to post this. I haven't been able to find/understand an explanation on how to deal with my issue so I hope that I'm not asking an already ...
1
vote
0answers
27 views
Modify columns data type when importing from CSV to GeoPackage with PyQGIS
I'm trying to import several CSV files into a GeoPackage using PyQGIS when opening a project as described in this question using this code:
from qgis.core import *
from qgis.utils import iface
import ...
2
votes
1answer
56 views
QGIS3: Import csv_file with DateTime Values
Has anyone managed to read in a "DateTime" value yet? I do not succeed, I always get text values.
Test1
point_id,X,Y,ele,time,Ds,len
"371",676239.6644,212505.7907,486,2020/04/07 09:58:07,0,0
"372"...
1
vote
1answer
59 views
Importing CSV table to geopackage with PyQgis using CSV file name
I'm trying to import some CSV with the same name of the file in a geopackage using PyQGIS before opening a project, but what I'm using doesn't work
I'm using this code:
from qgis.core import *
...
0
votes
1answer
22 views
Create a Line (MultiLineString) layer out of a CSV file
I need to replicate a *.qgs file that has 4 different layers as shown in the picture below:
The layer that I am currently trying to replicate is the "links" layer. The information of the layer ...
0
votes
2answers
45 views
Is there a way to build an URI without specific programs?
My purpose: to be able to load a text to CSV directly with Python console in QGIS.
When I read the QGIS guide (https://docs.qgis.org/3.10/it/docs/pyqgis_developer_cookbook/loadlayer.html) for Python ...
0
votes
0answers
36 views
Add delimited text layer is no longer an option in Data Source Manager for QGIS 3.10.6
I have a CSV with lat/long coordinates that I wish to turn into a shapefile. The process involves going to Layer > Add Layer > Add Delimited Text Layer. In QGIS 3.4.6, this would open up the Data ...
0
votes
2answers
47 views
How to join shapefile to CSV (not other way around)?
I have a CSV with multiple rows per county (it contains data on number of coronavirus cases per week). I want to make a choropleth map showing the change over time, but when I join this data to a ...
1
vote
1answer
45 views
Uploading CSV data to color a map on QGIS
I'm using QGIS, and I've put KML files in as seen in the photo. Each polygon is a distinct feature with a name. I'm trying to upload a CSV file which has a list of the same exact names as the features ...
0
votes
1answer
51 views
Import CSV into existing layer in QGIS [duplicate]
I have been provided with a number of blank shapefile to use as a schema for Work As Executed data. I have a survey in DWG format, from which I export data as a CSV file.
Is it possible to import ...
3
votes
1answer
39 views
Enrich a featurecollection with more data
I have generated a vector feature collection which is great but I would like to add to this data before saving it out as a CSV. So the data is areas of forest loss in the county of Gwent and I want to ...
2
votes
1answer
58 views
Georeference a LAS file with txt2las using a Geomedia coordinate system file (.csf)
I need to transform a file in a .csv file into a LAS file. I have a LiDAR data folder, in this folder I have these files:
A .csv file that contains the the point data
Some metadata files (schema, ...
4
votes
1answer
89 views
Plotting a CSV with coordinates one row at a time via GeoPandas
I have a CSV of all earthquakes in my country for the last 10 years arranged by date and time. My goal is to plot each line chronologically one by one, so that I can compile these maps and produce a "...
0
votes
0answers
29 views
Plotting via GeoPandas but only one point shows. What's wrong with my code? Map and points are in same projection
I've been stuck at this for two weeks and have tried already solutions online. I am using Python 3.8.
from shapely.geometry import Point
import geopandas as gpd
from geopandas import GeoDataFrame
...
1
vote
1answer
21 views
Export latitude/longitude coordinates of a R map plot into an external file
I have a simple map and like to export the used coordinates of latitude/longitude
into an external CSV file. Is this possible?
library('maps')
map(database='world',regions='germany')
1
vote
2answers
39 views
Using arcpy search cursor to relate a .csv and a .shp?
I'm trying to write a script that relates data from a .csv file to a utility pole shape file. Basically, we want the script to iterate through the pole # fields in each table and determine which pole ...
1
vote
0answers
46 views
Error while reprojecting CSV-file with pyproj
I am trying to reproject a csv-file and here's the error i get.
File "C:\Users\jonat\Anaconda3\lib\csv.py", line 98, in fieldnames
self._fieldnames = next(self.reader)
Error: iterator ...
0
votes
1answer
41 views
Starting out in QGIS with CSV containing country names and attributes
I would appreciate a pointer on how to start learning QGIS in order to satisfy this particular use case. I've looked through some tutorials, but I haven't found anything yet that describes what I'm ...
0
votes
1answer
38 views
Displaying feature points from an imported csv file (GEE)
I have imported the following CSV file into GEE (https://docs.google.com/spreadsheets/d/14XYsKQYylJ77uhNVhiLqUYwyGgBhE0N1h4F5QTn2Cvk/edit#gid=832877374).
However, even though I can print the data, I ...
0
votes
0answers
21 views
Summarizing Continental Biome Data in R
I have written code the produces a mean threshold value for the amount of satellite imagery needed in a single year to produce the 95th percentile of NDVI. I assume that this threshold of satellite ...
1
vote
1answer
56 views
Extract time-series rainfall from multiple point with date information
I would like to have a CSV file which contain a time-series of 30 minutes rainfall from last 10-days before Landslide occurs from certain (landslide) location. I used NASA GPM IMERG data for the ...
1
vote
1answer
23 views
Publishing multiple CSVS as uniquely names feature services
I'm supposed to publish each file as a uniquely names feature service, but despite my approach I keep having issues where my csv files aren't found... a friend advised me to add my initials to each ...
2
votes
1answer
57 views
How to display together a shapefile (country basemap) and points (from CSV) via geopandas?
So, I wrote this code that tries to do it but I end up with the map and points being displayed separately
import pandas as pd
import geopandas as gpd
from geopandas import GeoDataFrame
from shapely....
0
votes
1answer
55 views
Why are values coming in as <Null> when importing table from Excel?
I'm importing a CSV file into ArcGIS Pro, I've used geoprocessing tool XY Table to Point but values have come in null. Column type is double in ArcGIS Pro. Highlighted is the column which imports null ...
1
vote
1answer
35 views
GEE doesn't export my featurecollection as table with all the features
I have script in GEE which calculates for given geometry (reduceregions) the mean NDVI value for given period of time ans then suppose to export the table as CSV file when the polygon name is the ...
1
vote
2answers
64 views
Live link .CSV in QGIS
I have a .CSV that is updated each time I make any changes to my input sheet in .XLSM.
When I add/display the .CSV by "Add Delimited Text Layer" I cannot then update the .CSV as QGIS is then using it....
2
votes
1answer
43 views
Applying Rule-Based Style taken from another layer to layer with no geometry
I have two layers
"Suburb_Type", that has more than 1000 suburbs in shapes and is styled with categorisation rule. (columns: 'suburb_code', 'geometry', 'category_variable')
"Suburbs_in_Study", with ...
0
votes
2answers
48 views
Creating points in QGIS from DMS coordinate CSV - partial loss of data
I am inserting a csv with a list of coordinates (tab separated below)
y x
8 47 7.000 -82 57 32.000
8 47 7.000 -82 57 32.000
8 47 7.000 -82 57 32.000
51 28 0.000 7 32 60.000
-35 7 0.000 138 ...
1
vote
0answers
16 views
Plugin eVis false sorting
I have a csv-file and want to load it in the eVis plugin. The csv-file has a column cid and is sorted ascending.
sorting in csv-file:
I have pictures of a road and this pictures should be shown in ...
0
votes
0answers
47 views
“IndexError: list index out of range” when trying to add coordinates to an array
I am trying to reconstruct a car's path from some GPS coordinates given in a CSV file. I created an empty array to add the X and Y values (lat, long) and create the lines using it but I am getting an ...
1
vote
2answers
100 views
QGIS importing CSV files only as attribute tables, although they contain coordinates in the right format
I've got an issue importing CSV files to QGIS 3.12 Bucuresti and/or 3.4 Madeira.
Months ago I created a point distribution map for several species with several CSV files containing geographical data. ...
0
votes
1answer
194 views
Skipping rows with a csv reader
I have a CSV file which contains lat long coordinates which represent a car doing laps around a racetrack. At the end of each lap, there is a row in the CSV file which marks the end of the lap and ...
0
votes
0answers
43 views
Extract soil and slope data using coordinates
I have no experience at all in GIS and I'm trying to extract soil type and slope data.
All I have is a CSV file with latitude and longitude coordinates.
Is it possible to use this to extract the ...
1
vote
0answers
40 views
Creating a for loop to publish multiple CSVs as feature services? [closed]
I have multiple CSVs that I want to publish them each as unique feature services. Instead of publishing them one at a time, I'm trying to find the correct syntax to create a for loop.
This is the ...
1
vote
1answer
22 views
How to associate a point with a file on Google Earth Engine
Trying to plot CTD data from an oceanography cruise on Google Earth Engine so that it can be compared to MODIS ocean color.
The trouble is, each measurement is a separate CSV, and I would like to ...
