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
1
vote
1answer
23 views

Combining ListDatasets and ListFields to return geodatabase contents to CSV--one script prints attributes and another returns feature class counts

New to Python. I'm trying to combine two scripts I found online that use the ListDatasets and ListFields tools. One loops through all the features of a geodatabase and writes the name of the feature ...
0
votes
0answers
21 views

How to convert multilinestring to linestring in WKT field of a CSV? [on hold]

I previously developed a workflow in which I would digitize line segments in a shapefile that would ultimately be converted to a CSV, and the geometry stored in a WKT field. When this workflow was ...
0
votes
0answers
24 views

CSV file loading at wrong coordinates [closed]

I am using Q-GIS 3.8.2. Working with CRS: EPSG 3857-WGS84/Pseudo-Mercator. When loading a CSV file in Qgis the coordinates are not where they should be. When zoom to layer the dots appear, but off the ...
3
votes
0answers
21 views

Specify open options in datasource

I am using the GDAL csv driver and I can open a csv and specify geometry columns with ogrinfo using the -oo flags. However, when I want to specify these as part of another command-line tool, for ...
5
votes
1answer
236 views

Exporting result of QGIS model to CSV

I am trying to output the result of a QGIS 3 model as a CSV file. At first I came across How to export csv/excel in QGIS3.0 model processor? but the accepted answer is not satisfying to me. Further ...
2
votes
3answers
64 views

Plotting map locations contained in .csv file

I have a map of a city and a .csv file containing 700 geographic coordinates pointing to locations within that city. How can I plot these 700 locations on the map?
0
votes
0answers
19 views

Export Muliple Layer Selection to Single CSV File in ArcGIS WebApp

I'm trying to set up a web app that has multiple layers that all have the same fields (each layer is a separate year of data but same data type). I need to be able to select data points from multiple ...
0
votes
1answer
26 views

Adding rasters to mosaic dataset from CSV list using ArcPy?

I have a CSV list containing paths to 800 TIFF files that I want to add to a mosaic dataset. So using the Add Rasters to Mosaic Dataset tool, I need to create a loop which changes the input_path ...
1
vote
0answers
26 views

Truncated time series table output over multiple polygons using Google Earth Engine

I'm facing issue to export a CSV table of a time series from multiple polygons in GEE. Using few polygons it works well, but when I'm adding more polygons, the output is truncated. My CSV has Polygon'...
1
vote
1answer
43 views

Finding matching field values between two layers in QGIS?

I have two attribute tables, 1 from a shapefile layer (left) and 1 from a csv layer (right). I would like to find values in the first column ("KEY" column in shapefile layer) that appears in the ...
2
votes
2answers
35 views

CSV Files -How to Handle Bad Layers

I have moved my QGIS Project to a new Directory. On opening the project in new folder, Handle Bad Layer window pops up with a list of shp and csv files. I am able to correct the shp files using browse ...
1
vote
0answers
45 views

Converting KML to CSV with QGIS

I'm currently attempting to to convert a KML database and export in CSV for a research project. I'm able to load the KML into QGIS but an issue has arisen. The points appear perfectly in the mapping ...
2
votes
0answers
27 views

Extracting joined image collection data from Earth Engine as a CSV

Setting the context Prepare region of interest as multiple sites together as a FeatureCollection var roi_list = [ee.Feature(ee.Geometry.Point(146.007,-17.653), {name: 'S1'}), ee....
0
votes
0answers
18 views

R gdal_grid interpolation results in null values for elevation

I am trying to grid point cloud data. I created a csv with coordinates x,y and elevation z-values. The first lines of the .csv file look like this: "X", "Y", "Z" 666578.24179169,5747856.3361029,-0....
1
vote
0answers
34 views

Leaflet load CSV file [closed]

I want my CSV file load on the map, and catch my current location at the same time. Now, I can't load CSV successfully. This is my code: <html lang="en-US" xmlns="http://www.w3.org/1999/xhtml">...
0
votes
0answers
29 views

Plotting arrays of coordinates that are all under one column in CSV table?

I am trying to project specific route paths that all have coordinate points under a single column. Each row represents a different route path. Some of them go on for more than 100 coordinate points so ...
2
votes
0answers
54 views

Loading multiple CSV in QGIS? [closed]

I tried to use the same coding from Loading Multiple CSV Files into QGIS 2.10 to load multiples CSV in QGIS but in QGIS 3.6 and it does not work. The code provided in the above link was used and the ...
1
vote
1answer
46 views

ArcPy from points to lines keeping points attributes?

I have a script in ArcPy that read a CSV file like this: FID,LonDD,LatDD,Length,Depth,Type,Label,Date/Time 1,-1.090261,59.887594,,5,A,Text,041100ZAUG19 1,-1.090261,59.854044,,5,A,Text,041100ZAUG19 1,-...
2
votes
1answer
35 views

Add column in QGIS

Is it possible to add a column in the attribute table in QGIS that is a concatenation of two other columns? For example I have a column "Genus" and a column "Species" and I would like to create a ...
2
votes
1answer
65 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
35 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
22 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
2answers
48 views

Joining CSV to shapefile with same Name field results in NULL fields

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
29 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
37 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
34 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
44 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
30 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
87 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
151 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
145 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
131 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
109 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
135 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
22 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
23 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
35 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
88 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
31 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
118 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
189 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
35 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
35 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
65 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
21 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
26 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
102 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
106 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