Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
242
questions with no upvoted or accepted answers
6
votes
0
answers
3k
views
Is there an easier way to refresh a joined CSV?
I'm working with data that gets updated sporadically. Essentially, I have a CSV which defines which postal codes belong to certain sales reps, and these postal codes might shift around.
I made ...
5
votes
0
answers
718
views
Using csvt file to define column field types - Vector vs Delimited text layers?
I've discovered for myself and also read other post about an issue using csvt file to define the field types - String, Integer, Date, Real ect... The csvt file appears to work as described when ...
5
votes
0
answers
115
views
Avoid adding "_1" to field names when reading csv in QGIS?
When I read my csv file below
"Data Source","World Development Indicators",
"Last Updated Date","2017-02-01",
"Country Name","Country Code","Indicator Name","Indicator Code","1960","1961","1962","...
4
votes
0
answers
397
views
No geometry when importing points from CSV
I'm having problem importing a point layer from Excel. I've saved the Excel file as a CSV and added it to QGIS (2.18) through 'Add delimited text layer' I've checked in semicolon and choosen the right ...
4
votes
1
answer
1k
views
Convert .asc type to .csv or .json
I have an asc type file which describes measurements of a gas across an area at 1km square resolution. It looks like this:
NCols 1725
NRows 2175
xllcorner -224131.189661
yllcorner 4892726.61578
...
3
votes
0
answers
124
views
Can't load delimitedtext layer
I am on Linux Debian with Python
Python 3.9.2 (default, Feb 28 2021, 17:03:44)
[GCC 10.2.1 20210110] on linux
Here is my code :
# -*- coding: utf-8 -*-
import sys
import os
from qgis.core import ...
3
votes
0
answers
233
views
Using data in google sheets as input to add csv layer to QGIS
I have a google sheets spreadsheet that contains XCoord and YCoord columns and some other columns. I want to use this sheet as (preferably live) input to create a point layer in QGIS. My approach is ...
3
votes
0
answers
225
views
R raster / rasterize creating GeoTIFF with Null Value "grid lines"
I am attempting the seemingly simple task of converting a .csv with lat, lon and population values into a .tif (raster).
Here's my R code:
geoName <- read.csv("/pathToData/geoName.csv")
...
3
votes
0
answers
100
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 ...
3
votes
0
answers
235
views
Googlesheets CSV auto-update polylines to ArcGIS Online Maps?
I have been able to establish a ArcGIS Online map that auto-updates from a CSV spreadsheet within Google Sheets. The data that is auto-updating is point data with associated tabular data that will ...
3
votes
0
answers
895
views
Overpass API python wrapper to run requests on the endpoint of overpass-turbo
we have with Overpass API python wrapper a thin Python wrapper around the OpenStreetMap Overpass API https://github.com/mvexel/overpass-api-python-wrapper
we have some Simple example:
import ...
3
votes
0
answers
47
views
Can't access resources through JSAPI
Simply I want to upload a tiny csv file to a buffer Geoprocessing service published through ArcGIS Server 10.4.1. The problem ,however, is that I can't access any file in my server or an external ...
3
votes
0
answers
183
views
Join CSV to shapefile failing when in saved map document in QGIS
I am trying to join a CSV file to a shapefile by matching on attributes.
Here is the minimal workflow:
Import shapefile in blank document.
Save attributes of shapefile to CSV.
2.5 eventually, I ...
3
votes
0
answers
961
views
Converting KML coordinates to Leaflet
I am trying to convert a Google Map KML file to a csv, to map the longitude and latitude points on Leaflet. But the coordinates keep mis-projecting and some end up off the land mass.
The steps I have ...
3
votes
0
answers
335
views
Using Field Calculator to Convert Data Type In Field
I am trying to convert a field that is listed as "String" because it was imported into QGIS as a CSV (rural poverty population percentages by county in NC). I need to convert the percentages field ...