A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.

learn more… | top users | synonyms

4
votes
3answers
5k views

Using PyShp to convert polygons in *.csv to *.shp files?

I'm converting csv data to shapefiles using the pyshp python library. What I want to do is very similar to Using the python shape library: pyshp - how to convert .csv file to .shp, except that I ...
4
votes
2answers
4k views

QGIS import polygons in CSV

QGIS 1.8 on Mac: I'm hoping to migrate several dozen local maps from my 30 year old Win3.1 plotting system to QGIS. Polygons are in X,Y (CSV), first point repeated at the end to close it, with ...
4
votes
2answers
861 views

How do you create a CSVT on a Mac?

I am working with QGIS on a Mac, and understand the process for importing a CSV file. But I do not know how to create the CSVT file to define the CSV file's data types. Can someone please instruct me ...
4
votes
2answers
583 views

Where can I find GeoJSON resources files?

I'm looking for demographic information and various things, and most of the time data are available as CSV (my application use geoJSON format). Shall I encode the CSV to geoJSON or is there a ...
4
votes
2answers
194 views

How to save .shp to .csv so that the Name is in the first “column” of the .csv?

I am trying to convert a point shapefile to .csv with locations in QGIS. The problem I am having with the conversion is mainly that, in the resulting .csv file I would like to have the Name and then ...
4
votes
3answers
52 views

Convert .csv with polygon geometry to .shp QGIS

Working on a Mac in QGI 2.12, I have a csv file with polygon geometry coordinates that I would like to save to a shapefile. It displays fine as a csv. However, when I try to use "save as," I get the ...
4
votes
1answer
347 views

Convert a pandas DataFrame to a GeoDataFrame

This seems like a simple enough question, but I can't figure out how to convert a pandas DataFrame to a GeoDataFrame for a spatial join. Here is an example of what my data looks like using df.head(): ...
4
votes
1answer
263 views

Convertion of multiple csv automatically to shp

I have more than two hundreds similar csv files with columns (x, y, value1, value2, objectName). I need to convert them automatically to shp files with x and y columns as the coordinates. Could you ...
4
votes
2answers
2k views

Export dojo datagrid results to csv in javascript web application

I have created a web application using the esri javascript web api. I populate a dojo datagrid with results returned from a querytask. My question is, how do I export the results to a csv file? I ...
4
votes
2answers
5k views

Converting point grid to raster using GRASS?

If I load the original .csv file, I then have a map of the African continent represented by 14069 data points covering it at 40x40km resolution. Each data point shows solar radiation means across the ...
4
votes
1answer
52 views

QGIS - Import CSV column names as numbers

I want to import a CSV table (no geometry) to QGIS. The column names which are numbers (e.g. 2004) are not getting imported. This is my test CSV file: Name;Eigenschaft;2004;test derName;1;21;21 ...
4
votes
1answer
99 views

Convert Transcad Matrix to CSV

Is there a way to read a TransCad Matrix file (mtx) without access to Transcad. I am trying to convert a matrix file to a csv file.
4
votes
1answer
216 views

Pulling CSV file directly from website into QGIS?

I want to be able to automatically update my csv files in a QGIS project. My organization has an online database that can easily export csv files. These csv files are constantly updated with new ...
4
votes
1answer
309 views

Use csv file as raster file and stitch them together

I'm having an issue trying to stitch together 100 32bit Tiff files (coming from thermal imagery video and extracted as 32bit Tiff). I used Hugin to mosaic the pictures extracted from the video which ...
4
votes
0answers
42 views

How to get NIR values into a LAS file then a CSV?

We are trying to deliver a LAS file with NIR values added for each point. The NIR comes from a raster captured at the same moment as the LiDAR, and is stored as an 8bit number along with RGB in 8bit. ...
4
votes
1answer
247 views

CartoDB data load from csv file error

I’m having some troubles importing data from a cvs file with street addresses and the logs are not providing any meaningful information. I installed CartoDB locally on Mac OSX 10.10. Following are ...
3
votes
4answers
9k views

csv to kml converter

Does anyone know a workable and stable program which converts csv extension files to kml? There are many tools available online but none of them worked for me. I tried many including kmlcsv ...
3
votes
2answers
341 views

Exporting .csv file as .shp in QGIS?

I am a newbie to QGIS. Here's what I'm trying to achieve: Step 1: Load the required GIS layer (*.shp file) Step 2: Load the .csv file in QGIS Step 3: Perform the join based on common attributes ...
3
votes
2answers
4k views

How to edit Shapefile Attributes?

How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...
3
votes
1answer
241 views

Ideal file format for QGIS that allows mixed geometry types?

I have a spreadsheet for an archaeological project that is hosted on Google docs. This allows multiple contributors to edit and update the table as revisions and field data comes in. The table is not ...
3
votes
1answer
3k views

Converting JSON to GeoJSON or CSV?

How do you convert a JSON file to a GeoJSON file or csv. I have a JSON file with lat lon information, but how can I can convert this file to GeoJSON or csv. I have found some online tools to convert ...
3
votes
1answer
156 views

Tornado Data Points: Linking 2 Points in QGIS on the Same Row

So I've got these tornado .csv files that have two latitude & longitude entries with the left-most in the table being the beginning point and the right-most being the ending point of the tornado, ...
3
votes
2answers
2k views

How to read csv with WKT geometry in Arcmap?

I have found several parcels I need on a county map viewer. However, the only option to download any of the data is found on a click context menu to "Copy selection as csv" which gives me this: ...
3
votes
2answers
293 views

How to output coordinates from a shapefile to a GMT or CSV file in QGIS?

I want to get the coordinates for a line shapefile as csv or gmt files. I click create "new layer" - "new shapefile layer" - I check the "line" box and then "OK". Then I make my shapefile. When I ...
3
votes
3answers
84 views

Editing CSV tables in QGIS

I am trying to join a CSV table to a shapefile in QGIS 2.12.0. I have exported a table from Excel to CSV format, but when opening the table I noticed that my unique ID field in Excel is in text ...
3
votes
1answer
121 views

Can QGIS plot coordinates in Degrees-Minutes format?

I have a .csv file of coordinates that looks like this: Is there a way for QGIS to plot coordinates formatted like this? I've tried Adding a Delimited Text Layer... in QGIS, but do not see any ...
3
votes
2answers
5k views

Importing Lat/Long coordinates as CSV file & only displaying single point in QGIS

I am using QGIS and trying to import Lat/Long coordinates as delimited text layer. All points show up in my attribute table, however, only one point is displayed on the map? Any ideas?
3
votes
1answer
150 views

Import CSV: Is there a cap for number of row

I am trying to import several CSV files which contain more than 1,000 rows respectively. However, but only 129 records were only imported each file. Can't see any options that deal with this? I am ...
3
votes
3answers
3k views

How to convert GRIB-1 to GRIB-2?

I need to get data for my database from some GRIB files (binary), I downloaded wgrib2, which can export GRIB-2 files to .csv and csv is very suitable for me, but some GRIB files are GRIB-1, so I used ...
3
votes
1answer
517 views

make a raster from dataset (csv)

I was trying to make a raster from an dataset (https://www.dropbox.com/s/jsm1x06lnzfbqty/data.csv?dl=0) code: inter1= read.table("c:/data.csv", header=TRUE) #convert to spatial points ...
3
votes
2answers
178 views

What is the best plain text format for georeferenced raster data?

I have to translate satellite images in a file in .txt format or another, such as Excel or .csv, in which there are pixel values corresponding to (longitude,latitude) couples. What is the best file ...
3
votes
2answers
1k views

Csv to Shp conversion? [duplicate]

I am working on a really big script right now where I have a csv file that I have removed rows and columns from, and edited the headers. I need to create one big shapefile for the entire csv file then ...
3
votes
1answer
82 views

How to do operation after using over() for a shapefile in R?

I am copying the answer of Counts the number of points in a polygon in R library("raster") x <- getData('GADM', country='ITA', level=1) class(x) # [1] "SpatialPolygonsDataFrame" # attr(,"package") ...
3
votes
1answer
46 views

How can i simply merge csv files together with fme

I have some csv files which have varying contents. I want to simply disregard the schema and write the lines of text into one file. Which transformers or technique could I use to achieve this?
3
votes
1answer
139 views

Qgis: Export only some columns of the selected objects to CSV

I have a layer with a table containing several columns. If I right click on the layer --> Save as.. --> CSV and chose to only include my selection I get a nice CSV file with all columns for the ...
3
votes
2answers
592 views

Changing precision on a column in the attribute table without losing data?

I have data in an Excel file that I want to join with a shapefile in my project. The Excel file contains values like volumes. The Excel file and the shapefile I want to join it with both contain the ...
3
votes
1answer
340 views

Join CSV using gdal/ogr

I'm trying to use gdal/ogr to join a shapefile called myshape.shp with a csv called mycsv.csv. The join field in the shape in joinshp and the join field in the csv is joincsv. I've found this command ...
3
votes
1answer
172 views

ogr2gui geojson to csv do not export coordinates

I tried to convert ogr2gui to convert geojson files to csv. The geojson file contains point data only. The resulting csv only contains attribute data, no coordinates. Is there a way to get the ...
3
votes
2answers
2k views

How to produce a CSV file from .tif file with elevation data? [duplicate]

just want to ask, I have a .tif file that contains all the elevation of a country. How can I convert that to a CSV file that contains x,y,z values where x and y are the latitude longitude respectively ...
3
votes
2answers
214 views

Deleting the “cached” field names for a large CSV file

Using ArcGIS Desktop Advanced 10.1 I have a large CSV file (36MB with about 600,000 records) that contains single addresses that I want to geocode. The file is called "SingleAddresses.csv" The file ...
3
votes
1answer
361 views

QGIS: Colour GPS track by speed

sorry íf I might ask this question the 101 time, but I didn't found anything with google or SE. I have a CSV file with WGS84 trackpoints and visualizing them with QGIS textplugin works fine. The log ...
3
votes
1answer
69 views

Raster Layer Statistics CSV Output using QGIS Graphic Modeller

I am currently working on a project where I am using historical cloud coverage from MODIS Cloud Fraction data to try and estimate future cloud coverage of any particular month. I currently have ...
3
votes
2answers
274 views

Understand QGIS errors when importing .csv file

I am trying to import a .csv file as a layer in QGIS and keep getting a number of errors that I don't understand. Is there any documentation of QGIS errors available? Or can you point me towards a ...
3
votes
2answers
68 views

Coordinate formatting for swath data - to polygon

I've got a CSV of Lidar coverage swaths in the below format. Each run or strip is tied together via run_id. I'm assuming L is for left, R is for right and M is for middle. EDIT: These are coordinates ...
3
votes
1answer
123 views

ogr2ogr postgres import: check if dataset exists

I have a PostGIS database which I update daily with ogr2ogr using CSV files. This works great. Is there a way to check whether the actual value of a column already exists in the table (e.g. ...
3
votes
1answer
62 views

matching shape file to csv within QGIS - all strings

I am trying to link a csv to a shape file using the method as described in this tutorial: http://maps.cga.harvard.edu/qgis/wkshop/join_csv.php It seems to work fine but the problem is that the csv ...
3
votes
1answer
333 views

Cannot read CSV-file from ArcMap

when trying to import a CSV from my hardtrive to my map-document using "add Data"-dialog I get the error "Selected element could not be added to map. Generic error" (or something similar, I am using ...
3
votes
1answer
5k views

How do I convert a set of latitude/longitude coordinates with timestamps to a GPX tracklog?

Converting tracks from a GPX track to a CSV table or some other format is relatively easy, but I'm looking to go the other way. I have a table of point locations logged with a handheld GPS, with ...
3
votes
2answers
2k views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
3
votes
2answers
182 views

gdal_grid unable to get nodata outside of original data area

I have a vector based csv file that I want to convert into a grid using gdal_grid, but I want to force null data values strictly around the area where there is data. I can get gdal_grid to work but ...