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
0
votes
0answers
16 views

Importing GPS coordintates in Decimal Degrees with N and S at the end instead of + or -

I have a CSV file with GPS coordinates formated in decimal degrees. Instead of using negative symbols for south hemisphere and east of the prime meridian coordinates some of the coordinates shows a N ...
0
votes
1answer
16 views

Transfering GPX files from Basecamp to CSV files for use in ArcMap

How do I transfer GPX files from Garmin Basecamp to CSV files for use in ArcMap? I have saved all my points and tracks in Basecamp and now need to plot them on ArcMap.
2
votes
0answers
42 views

Import CSV of UTM points to QGIS

I am having an extremely difficult time importing my CSV file, with UTM points, to QGIS. I am a very basic QGIS user, and the online information so far hasn't helped me figure out this problem. ...
0
votes
1answer
38 views

CSV attribute table to polyline shapefile

I have a .csv file that is an exported attribute table that I would like to reconstruct as a polyline shapefile (for reasons beyond my control I cannot access the original shapefile from which the ....
0
votes
0answers
21 views

How to export CSV data of area from Google Earth

I want to export CSV data of some area in Google Earth. I will then import this data into python and run a 3d map. I will be able to rotate and scale it then. I can do the last 2 steps, but how can I ...
0
votes
0answers
13 views

Export results of MPRI and NDVI to CSV file? [duplicate]

How can I export the result of MPRI or NDVI (which are rasters) to a CSV file? I want to interpret and compare MRPI and NDVI.
4
votes
1answer
131 views

Importing Data from CSV without longitude and latitude but a location code

I am new to QGIS. Above is the image of data I have. The .shp file in QGIS have that geographical department codes as well. I want to read the data from CSV and plot in map but don't know what to put ...
1
vote
1answer
25 views

Select ArcMap attributes that are in CSV

Is there an ArcMap 10.1 method for selecting only attribute rows that have an identifier in common with those in a CSV sheet? I exported an attribute table (5000 rows) and eliminated all but the ...
2
votes
0answers
29 views

Loading CSV file without geometry in graphical modeler

I'm trying to use the graphical modeler to make a join between a vector point layer and a CSV file which doesn't have geometry data. I tried to use 'Vector layer' as an input for the CSV-file but the ...
2
votes
1answer
45 views

Export image in CSV

I created a small image on Google Earth Engine and now would like to export all its bands in a csv file. With a format like | pixel id | lat | lng | band1 | ....| |----------|-----|-----|-------|-...
0
votes
0answers
62 views

'Layer is not valid' error in QGIS for delimited text layer

I am trying to add a CSV that contains lat/long coordinates as a layer to a project in QGIS but I keep getting a 'layer is not valid' error. Here is a picture of the data preview before I click Add: ...
1
vote
2answers
32 views

Merging a .csv file with a .shp file in R

I am trying to merge a .csv file with a .shp file. The shapefile has more information that I need so I also want to limit it by only adding information for the counties in my csv file. I tried my code ...
1
vote
1answer
35 views

Exporting Geopackage table to directory as CSV with PyQGIS

I have the following extract from a PyQGIS script showing the final function. This script actually form part of a plugin tool for QGIS. I create three geopackage layers and save them into the chosen ...
5
votes
3answers
142 views

QGIS 3.10 Creating a DEM from CSV

I have been fighting with this for a week or so. I believe I have viewed the related questions on stack exchange, tried some of the suggested solutions that seemed appropriate and have found none ...
1
vote
1answer
31 views

Qgis TimeManager: InvalidTimeLayerError: invalid value 'cannot switch from manual field specification to automatic field numbering'

I´m trying my first steps with Qgis and TimeManager - and getting an error right away. I have a csv file with lat/lon coordinates and a time field: tour_id;action;lon;lat;time 1;move;6....
0
votes
1answer
34 views

Return all results from join of non-spatial CSV to spatial data using ogr2ogr and SQLite dialect

I am attempting to carry out a simple join of a non-spatial CSV to a GeoJSON data source using ogr2ogr an its built-in SQL capabilities. I would like to use the SQLite dialect to carry out the join. ...
4
votes
1answer
64 views

Join non-spatial CSV to GeoJSON data source using ogr2ogr and SQLite dialect

I am attempting to do a simple join of a non-spatial CSV file to a GeoJSON data source using the built-in SQL capabilities in ogr2ogr. I have successfully managed to do this using the OGR SQL dialect ...
1
vote
0answers
14 views

Finding all points from a csvLayer within a circle with ArcGIS JavaScript

I am new to GIS and I am trying to develop a webpage using the ArcGIS JavaScript API. I am currently trying to figure out how to select all of the points from a CSV that are within a circle. I have ...
1
vote
2answers
45 views

Edit and/or filter CSV files [closed]

I'm pretty new to QGIS I have a couple of questions regarding .CSV files. 1) Whenever I download and import .CSV data into QGIS, it works perfectly. I get the points and everything is peachy, but, ...
1
vote
2answers
108 views

Copying features from one attribute table to another using QGIS

I am struggling with copying the data from one attribute data table to another. I have a few columns in my data attribute table, which I want to update. I can do it one by one, but its a long process, ...
2
votes
1answer
42 views

Values disappear after joining .csv file to shp layer in QGIS

I am joining a .csv file to shp layer and it goes well except all the values from the .csv file disappear (there's NULL in the attribute after the join)? I don't have X & Y coordinates, but I'm ...
2
votes
0answers
29 views

How to export attributes from more than one layer in QGIS3 to csv?

I have two vector layers, one has geographical points and the other has polygons representing suburb boundaries. I want to export a list of all the points in a table with a column listing the suburb ...
1
vote
1answer
44 views

Append column of .csv file to attribute table of a feature class?

I am quite new to ArcMap. I want to add a column of a .csv file to the end of the attribute table of a feature class. The column and the attribute table are of the same length. I tried to use the "...
0
votes
1answer
41 views

Exporting data using sketch tool in ArcGIS API for JavaScript

I am looking to see if it possible to extract data from a feature when we use sketch tool. After I draw a polygon it is selected as a feature what can I write to get the data behind that select ...
3
votes
0answers
58 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
1answer
65 views

CSV file projection not aligned with Basemap

I uploaded a CSV file with DMS coordinate systems in it into QGIS. The points appeared on the white background. When I add a GoogleImage background in the projected coordinate system WGSPsudoMercator, ...
1
vote
0answers
32 views

QGIS Pie chart labels from column names

I am trying to get the proper labels for pie charts on my map. I want to use the column names of the table (.csv file) that is used for the pie chart as labels for the pie chart on the map. The column ...
1
vote
1answer
34 views

QGIS - plot points on a map proportionally to column values

I have a .csv file like as follow: latitude | longitude | norm_imp -22.13 | -43.18 | 0.017 -22.19 | -43.29 | 0.038 -22.33 | -43.08 | 0.117 -22.19 | -43.29 | 0.2038 I plot the ...
0
votes
0answers
53 views

Importing cvs file with coordinates into QGIS [duplicate]

I got a problem. I got some coordinates in Excel. They are written with comma 14459091,1010 ex. When I try to import them as csv-file into QGIS, it will only create a table and no points. When I look ...
1
vote
0answers
35 views

Export CSV file in GEE with random points in polygons as rows

I'm working with Sentinel 2 data. Currently we have a polygon set with 1000 polygons. I want to choose 100 random points in the polygon set in Google Earth Engine using: ee.FeatureCollection....
0
votes
0answers
35 views

Using gdal_translate with a high number of gcp

I've a CSV file witch describes the coordinates of each pixels in a image, it is structured like this: xcoord,ycoord,row,col 716657.6518375501,4784215.095395751,0,0 716657.6915582813,4784215....
1
vote
1answer
25 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 ...
5
votes
0answers
46 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
276 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
97 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
22 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
54 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
32 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
69 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
46 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
196 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
44 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
36 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
159 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
87 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
47 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
36 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
76 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
42 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....