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
2
votes
1answer
60 views

QGIS table join issue

I got CSV data on analysed buildings containing object ID, materials etc. And I have vector file with spatial location of all buildings in the city containing as well object ID and some other ...
0
votes
0answers
25 views

Pyqgis import non-spatial CSV to Qgs project

I'm trying to upload a .csv file to my QGIS project via Pyqgis. According to the following thread Using non-spatial CSV with PyQGIS it should work that way: uri = 'file///C:/Users/denni/Desktop/test....
0
votes
0answers
20 views

Create a grid in QGIS [duplicate]

I have GIS points (x, y data) for every minute over a landscape. If I load them up as a CSV into QGIS they all show up as points, which you would expect. However, what I would like to do is use these ...
2
votes
1answer
34 views

Joining CSV to shapefile with same Name field results in NULL fields (sample files included)

I am having some issues with using the join feature between my shapefile polygons and my CSV data (originally a xlsx file), when I join the layers together using the common field between them (name) ...
1
vote
2answers
26 views

Highlight, count and delete overlapping point locations from different CSV layers in QGIS?

I have many CSV file layers in my project in QGIS, and quite a few layers have points which share the same location. Is there a way I can compare, count and highlight those "duplicates" and then ...
1
vote
0answers
32 views

Writing .csv frequency tables of raster value counts per polygon?

Starting data: 1 raster file and 1 multi-feature polygon shapefile, say with 26 unique features named "a" through "z". In case it helps we can call them raster.tif and provinces.shp. If we clipped ...
1
vote
1answer
31 views

Mapping multiple historical routes from lists of points

I'm working with a spreadsheet of data culled from historical archives, in which I've got a list of travelers, each with a start location and an end location (lat/long). Some also have known ...
2
votes
0answers
37 views

Saga GIS Snap Points to Lines tool doesn't produce required results

I have two sets of data that I'm using. Points extracted from a .csv file and a road network from an ESRI .shp file (both of which I've included here: https://send.firefox.com/download/...
1
vote
1answer
25 views

ArcGIS JavaScript API set size of CSV Marker by attribute

Using ArcGIS Javascript API 3.29 is it possible to set the size of a CSV Layer marker using a field value through the renderer? Using this EXAMPLE in their samples, they add a CSV layer to the map ...
0
votes
0answers
76 views

Exporting XY-data to a new shapefile

I've got a CSV file with 29 rows and 2146 columns including coordinates and a number of reflectance for each wavelength starting from 350 up to 2500. I imported the CSV file in QGIS without any ...
0
votes
1answer
84 views

Getting latitudes and longitudes in between start and end coordinates and spaced at equal distance

I have a csv file which has the latitude and longitudes values , I need to find the coordinates in between the start and the end latitude and longitude which must be equally spaced at the interval of ...
3
votes
2answers
115 views

Loading CSV with X&Y and Save as Shapefile using PyQGIS?

I am attempting to transform a CSV file with joined fields of Eastings and Northings into a shapefile with PyQGIS (QGIS V3). Here is where I've got to: 1: Loaded the postcode shapefile which ...
1
vote
1answer
64 views

Find in between coordinates for the given latitude and longitude from a CSV file

I have a CSV file which has the latitude and longitude values for the start and the end coordinates as follows. In these the first lon and lat values are the start point then the second coordinates ...
5
votes
2answers
100 views

Export CSV from QGIS without thousands separator

I need to export a GeoPackage file from QGIS 3.2 as CSV file. The GeoPackage contains two fields: UID as Integer and S_SCH as String (yes, it really is a string). It looks like: UID S_SCH 654321 ...
0
votes
0answers
51 views

Read contents of KML file into CSV format using Python (BeautifulSoup)

I have a KML file called Layers.KML which has multiple sub folders - Tree_Heights_Elevations, 20190516 - Chain Link Fence, 20190516 - Clearing Limits, 2016-0516 - Solar Array . ...
1
vote
1answer
19 views

Why is the CSV Layer converting a Date-Time field to Unix Timestamps?

I am using the ArcGIS JavaScript API to add a dynamic map in my application. I am loading data through a csvLayer. The data looks something like this: Here's a snippet of me initiating the csvLayer: ...
1
vote
0answers
22 views

Add spatial csv-layer in QGIS3 using Python3 code

I need to add a spatial csv-file with a specific path (folder and file name) in QGIS3x using a python script. I have tried: PyQGIS import csv- QGIS 3.4 uri = "file:///C:/users/heubacha/Test.csv?type=...
0
votes
1answer
30 views

QGIS3 - how to define/change field type for non-spatial data table?

I am playing with joining data in QGIS. I previously did it only with two spatial layers and now I am trying to connect one spatial layer (polygons) and "non-spatial" data in a CSV table using a text ...
0
votes
0answers
24 views

Locations mapping looks off in ArcMap? [duplicate]

I want to upload a csv file with co-ordinates. The locations belong to USA. So I Upload a csv file to ArcMap and add XY data. The Projected Coordinate System is WGS_1984_World_Mercator. As soon as I ...
0
votes
0answers
49 views

Issue with Exporting Time-Series of Mean Region Statistics in Google Earth Engine

I am trying to export a time-series of multiple polygons' region stats from Google Earth Engine to CSV using the mean region reducer but am having issues with certain polygon IDs being dropped from ...
1
vote
0answers
29 views

Imported CSV point data layer invisible over the raster map layer, though each layer shows good separately “zoom to content” [closed]

I am trying to import CSV file (comma delimited text) and get no reported errors but there are no points data visible overlays over raster data map 1. QGIS 3.6 2. the point data layer over raster ...
4
votes
2answers
108 views

CSV file not joining to Shapefile using QGIS?

I am trying to join a .csv onto shapefile data. This csv file is a non-geometric file. When I go to join the two, the shapefile reads that the columns are null. Both files have matching columns. I ...
2
votes
1answer
102 views

Iterating over column from CSV using pandas? [closed]

The problem that I am experiencing is as following: I have a csv with the following columns: 'time' (with date and time), 'id', 'lat', and 'long'. The data shows movements and id represents a mobile ...
2
votes
1answer
27 views

Defining coordinates cells as “Real” using a .csvt file renders them “NULL”

My .csv file was only adding as a 'legend file' in QGIS, and using the 'Properties' tab I saw QGIS regarding all the entries as text. In order to resolve this, I made the following .csvt file. "...
1
vote
0answers
32 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
1answer
32 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
17 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
24 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
64 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
94 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
1answer
56 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
79 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
50 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
47 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
57 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
51 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
57 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
45 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
49 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
36 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
103 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
45 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
16 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
22 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
71 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
28 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
257 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 ...