Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
0
votes
0answers
15 views
Joining .csv with duplicate values to .shp layer with points and getting all points visible using QGIS?
My problem with QGIS (version 3.4.8)
I have a .shp map layer containing point data of buildings. I want to join .csv spreadsheet to this layer so I can look into it and visualize different variables ...
0
votes
0answers
23 views
QGIS-Distance Matrix. Is it possible to do in python?
I have a hundred pairs of CSV data such as passenger and bus stop data. The passenger and bus stop data structure are ID passenger, bus stop name, and XY coord (UTM). I want to analyze the nearest ...
0
votes
0answers
10 views
Getting changed data in csv to show up in Google Earth Pro
I have a CSV file that I imported into Google Earth Pro. G.E.P. took the long/lat and placed markers where they should be, and when I select the marker the rest of the data displays in a box. Is there ...
1
vote
0answers
15 views
QGIS - How to add joined values table data to shapefile
For some reason I lost my previous question here but I proceeded a little bit after upgrading to the newer version of QGIS.
My problem was combining spreadsheet .csv data to the .shp map layer, where ...
0
votes
0answers
23 views
Getting duplicate values when joining .csv spreadsheet to .shp map layer using QGIS?
I need to join .csv/spreadsheet data to the .shp map layer. The join itself isn't a problem with same join & target values (building) but some data goes missing because of duplicate values.
For ...
2
votes
1answer
39 views
Convert point layer to raster QGIS 3
I have a .csv-file containing x and y-coordinates as well as different variables with attributes (var1 to var3). The csv looks like that:
Loading the data into QGIS with Add Layer → Add ...
2
votes
1answer
62 views
Visualisation: probabilistic rainfall forecast from CSV
Note: I have a basic idea of how shapefiles work & how to save maps as images.
I'm a super noob on QGIS. I have this CSV which provides me details such as
State
Average rainfall (mm)
Probability ...
0
votes
0answers
16 views
Using schema.ini to define multiple CSV files for import in ArcGIS [closed]
I am attempting to use a single schema.ini file to define field types for multiple CSV files for importing/use in ArcGIS (I'm using ArcMap 10.2). My MWE schema.ini is this:
[11_wa_2017_30_1200-1200....
0
votes
1answer
54 views
Generating new ID for column if ROW - PREVIOUS_ROW >= 45 seconds? [closed]
I don't want this code to be distributed
1
vote
2answers
59 views
Converting shapefile to CSV file to shapefile with Add Delimited Text layer?
I'm using QGIS 3.4.6, working with a big biological dataset in several shapefiles.
I want to convert the working shapefiles to CSV files, add a column with new data, then convert the CSV files back ...
2
votes
2answers
47 views
Opening different XLS spreadsheets as table with ArcPy?
I am trying to write a Python script that uses a xls file with different spreadsheets as input to build features and domains in a geodatabase.
This is the data in Sheet1:
and this the data in ...
1
vote
3answers
39 views
Use a .shp file to map multiple entries in a .csv in QGIS
I have a .csv file with several entries with data for events which happened in places, and a corresponding .shp file which shows the locations where the events took place. How would I go about mapping ...
1
vote
1answer
26 views
Join a CSV file to GeoJSON using ogr2ogr in a Python script?
I have a CSV which I would like to join to a GeoJSON.
I found this answer which I tried to implement but I can't get it to work just yet.
Here's an extract of my python:
join_command = ['ogr2ogr', '...
1
vote
1answer
18 views
What is a compatible data type for 'specific' date and time? [closed]
I need to import CSV file into PostgreSQL, but I got an error on time column which has data like this:
11/1/2016 12:00:00 AM
I tried to make column and assign 'timestamp' data type, but it's just ...
3
votes
0answers
50 views
Adding source and target fields in attribute table
My issue is I want to export a CSV-file from QGIS 3.6.2 to Gephi (network analysis software) the layer I want to export is the edges layer for Gephi. However, when importing into Gephi I am missing ...
1
vote
0answers
32 views
Extracting values From several raster .tif files to a .csv file using python
I have multiple raster .tif files. I am using Python, and I want to extract cell's attribute values from all rasters based on the latitude and longitude similarity, and saved in a .csv file, the ...
0
votes
0answers
39 views
Is there maximum number of points you can import from CSV to QGIS 2.18
I tried to import a CSV file which contains 4,783 rows. However, only 20 records appeared. Any one has solutions to solve this situation? How can I add all rows in QGIS delimited layer?
PS: I use Mac ...
1
vote
0answers
38 views
Filtering image collection using date and lat long from feature collection in Google Earth Engine?
I'm trying to use the JSON data that i have turned in a feature collection using this code:
var dict = ee.Dictionary(JSONRAWDATA)
// inspect the dictionary
print(dict)
// make some months
var months ...
1
vote
1answer
54 views
Map based on highest percentage from different variables
I've the 8 social classes (see under) for +- 900 polygons. I would like to create a new column that keep only name of the main social class for each row (based on the percentage). After that I would ...
0
votes
0answers
23 views
QGIS Identify export
Is it possible to make and export (to csv) from the result in the identify? I tried the attributtabel, but I would like the info of more layers at once.
0
votes
1answer
43 views
PostgreSQL COPY command shifting CSV values into wrong column [closed]
I am running the following query in PostgreSQL 10.1:
COPY addressbase FROM 'C:/Temp/ab_postgres/addressbase.csv' DELIMITER ',' CSV HEADER
It is returning the error:
ERROR: invalid input syntax for ...
1
vote
0answers
37 views
Read a .csv file from a URL with an API call in QGIS 3?
How do I read a .csv file from a URL with an API call, including key, in QGIS 3?
I've tried creating a .vrt file as outlined here
I've tried the solutions presented here
If I'm doing everything ...
0
votes
0answers
14 views
Load CSV in SQLite and then create layer in Tilemill
I have a big CSV file with addresses and their lon/lat. I am not able to load that in Tilemill directly. I thought to load that CSV in SQLite Db and then create a layer with SQLite DB.
I am not able ...
0
votes
1answer
41 views
Trying to use a SelectByAttribute_mangement after I made the XY Event layer
I imported a CSV file using the MakeXYEventLayer_management and trying to use the SelectlayerByAttribute_management function, but I am getting error message saying on "Object ID(OID)" is present..
Is ...
0
votes
1answer
18 views
Graduated Style Renderer not displaying for joined csv to shp
I have joined a csv file (via the add spreadsheet layer plugin) and the field types have saved correctly (i.e. they are "real" types, see attached image), and yet the graduated style renderer option ...
0
votes
1answer
67 views
Parsing CSV data and updating a dictionary and creating a polyline
I am a little stuck on my code. I am new to Python and am learning as I go, but have usually been able to figure it out till now. The code was working up till I put the dictionary part in and now ...
1
vote
0answers
25 views
Data type for mixed representation
The following is a JSON representation of an large array of planar spatial surfaces.
{"type":"Feature",
"geometry":{
"type":"MultiPolygon",
"coordinates":
[[[[17.7529,-31.146],[17....
1
vote
1answer
120 views
Why is QGIS not recognising latitude and longitude correctly?
I am importing a simple 5 column csv file into QGIS using Add Delimited Text Layer.
Each row of the table contains a name, a street address, a postcode, a decimal latitude and a decimal longitude, for ...
0
votes
0answers
103 views
Editing and saving CSV file to use in plugin for QGIS?
For using in a plugin (PS Time Series Viewer), I want to edit a CSV file in the way plugin wants. Somehow I think there's a problem with the CSV file. I would like to tell you all my steps because I ...
1
vote
1answer
87 views
exporting table to drive from Google Earth Engine returns some NAs where valid data
My question is similar to exporting table in to a drive from Google earth engine returns blank rows, but instead of getting entirely no data, only a few records come back NA where I have confirmed ...
4
votes
1answer
101 views
Import CSV from online resource
With QGIS it´s easy to load non-spatial CSV Data (and use it for joins).
This works fine as long the CSV resides on the local file system as this answer suggests. Is there some way to import a CSV ...
1
vote
2answers
128 views
Load LINESTRING in WKT-format from CSV to pgAdmin?
I've got a CSV file with a column containing LINESTRINGs that looks something like this:
1,"LINESTRING(20.331 54.33, 21.67 44.89, 12.67 13.5679)",2014-03-09 13:30:33,2014-03-09 13:31:33
2,"LINESTRING(...
0
votes
3answers
57 views
ogr2ogr CSV conversion with two points into column names
I have a CSV with ":" in all column names. I am trying to convert it with ogr2ogr to another format. I don't need all fields
example for formating:
#0:imgID,1:camSN,2:lat,3:lon,...,57:fields
...
0
votes
2answers
38 views
Can't import stratigraphy data
I am having trouble importing stratigraphy data from a CSV file.
The CSV files can be found at the following link:
https://www.dropbox.com/sh/txrrcpbf6cpzh52/AAC8jk4DGP7dZYfBBpj2s1B7a?dl=0
When ...
3
votes
1answer
47 views
Issue converting CSV files to point shapefiles using pyqgis - QGIS 3
I have hit a snag using pyqgis in QGIS 3. I want to convert a set of CSVs (20 total) into point shapefiles but I am struggling with just the single CSV case. My code is based on this blogpost (https://...
1
vote
2answers
40 views
Reading CSV in loop stops at row that does not match?
I am trying to read a CSV then iterate through an sde to find matching features, their fields, and then print them.
There is a table in the list and I'm not able to skip over it and continue reading ...
1
vote
3answers
96 views
Is it possible for ArcMap to treat data types (numbers as text) correctly when importing from a text file?
I am creating a text/csv file (using a python script). The file contains data to import into ArcMap. I have several fields that look like numbers but have leading zeros ("0012") etc. that I want to ...
2
votes
1answer
47 views
Add virtual layer to aggregate feature
newbie here of QGIS here, I was trying to aggregate a feature from a CSV with no geometries. The query is very basic:
SELECT
"PROV",
SUM("POP_2012") AS POP_2012
FROM "municipalities-tuscany"
...
1
vote
1answer
74 views
QGIS-Export Raster Values to a .csv file
I use a Raster, based on .png and .pgw file. (plans from a town)
The plans include information about where buildings are allowed to be built and maximum building height, ground elevation etc.
Now i ...
1
vote
0answers
31 views
Using non-spatial csv with PyQGIS?
I have some csv lookup tables which are too heterogeneous for ordinary join so I want to process them in PyQgis. However the csv files have no geometry column whatsoever. If used as QgsVectorLayer the ...
1
vote
1answer
32 views
In QGIS, how can I use a delimited text layer to keep only those polygons and records of a shapefile which match a column in the delimited text layer?
What I want to do is trim the shapefile so that only those records and associated shapes that match the same values in a column in the delimited text layer (which in my case is a CSV) are kept in a ...
1
vote
0answers
27 views
Plotting with QGIS, blank positions result in errors
I tried to use the delimited text layers, then I found something wrong. Several plots are out of bound. Then I checked the original data and decoded data. It seems when one part of a single data is ...
2
votes
2answers
39 views
Automatically (re)classify data from layer using QGIS?
Is it possible to automatically (re)classify the data of a layer? (properties-symbology-delete all-classify) Because now I have to do this manually each time my data source changes.
2
votes
0answers
59 views
Updating set of attributes on vector layer from .csv table?
I have over 1,000 records in a .shp file, all with a unique ID field (LINKID), along with many other fields containing data (TXTFLD1, TXTFLD2, INTFLD1, INTFLD2, etc).
These records have been copied ...
1
vote
0answers
46 views
Importing CSV to Carto from R?
I would like to import a csv file to my Carto account using R. I know the csv has been generated, and I'm able to save it in other locations.
Running the code to upload this file to Carto appears to ...
1
vote
1answer
53 views
Exporting attributes table to csv from shp using PyQGIS 2.18?
I'm approaching now for the first time to Python console and I wanted to know step by step how to export in .csv two fields from the attribute table of a vector shapefile(.shp) using just PyQgis.
Let'...
1
vote
0answers
56 views
QGIS Join is returning Null values
I am trying to join this data to this data (UTM32 Ebenen file = VG250_GEM.shp) using columns Column2 and SDV_RS, respectively. I am using QGIS 3.4
I am following the instructions found here . ...
1
vote
1answer
552 views
Extract data from NetCDF file based on station
I have read other solutions for NetCDF data but my data are a little different and I do not know how to extract data from NetCDF and save them in CSV files based on stations. Data include the maximum ...
1
vote
1answer
133 views
Converting GPX data stored in CSV into geography data type (WKB or WKT)?
I have a CSV that contains some data relating to hikes undertaken by various people. For each hike, there is an ID, max_elevation, length, start_time, end_time, and GPX field (along with some other ...
2
votes
3answers
113 views
Can I reorder the coordinates of a line when importing into QGIS a WKT linestring?
I managed to import a csv file containing lines in QGIS but unfortunately the x y aren't in the correct order. that is, the csv has a field where there is a sequence of lat (y), lon (x), while qgis ...
