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

learn more… | top users | synonyms

3
votes
2answers
2k views

Python script to export .csv tables from GDB

I am very new to Python programming and have been tasked with writing a program to export a csv file from a file geodatabase feature class. The csv should contain only certain fields and the records ...
3
votes
1answer
141 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
1k 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
173 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
1answer
142 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
2answers
2k 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
3answers
216 views

QGIS won't read table columns in CSV import on Mac OS

I am trying to import a CSV file to QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can how QGIS won't read my data correctly). I can't ...
3
votes
1answer
154 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
118 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
901 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
191 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
105 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
624 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
123 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
263 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
2answers
85 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
38 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
60 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
58 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
1k 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
1answer
188 views

Failed attempt to relate a .csv file of 400 records to a single record in a point data layer

I have the Provincial Groundwater Monitoring Network as a point feature of 39 monitoring wells which includes an attribute for WELL ID. Each monitoring well then has a corresponding .csv file with 400 ...
3
votes
2answers
1k views

From text data create a FeatureClass with table with python

I'm searching how the output of one program (text file with some writings, but also with data as numbers, dates, times, coordinates, all separated with commas) can be transformed to a Feature Dataset. ...
3
votes
1answer
768 views

Converting ArcGIS topology rules file (*.rul) to *.txt, *.csv or *.xls for reviewing?

Has anyone converted ESRI's topology rules file (.rul) into another format? I built a complex topology rules set and would like to QC it in something easier to read and work with than ArcCatalog. ...
3
votes
1answer
37 views

Exporting BNG coordinates from MapInfo (27700) without rounding

I have a TAB file in ESPG 27700 projection and MapInfo is rounding Y coordinate values upon export. It also occurs when viewing the table (although selecting the value shows its 'true' form) Upon ...
3
votes
1answer
208 views

Getting StatPlanet to work with custom shapefile and data?

I'm assigned to get StatPlanet Plus working with some 3rd-party data to display a thematic map, on a Mac. I have the custom regions and attribute data in a map.shp/dbf. And I've configured the ...
3
votes
1answer
295 views

How to get default parameter value for script tool from csv file?

I am fairly new to python scripting. I have just figured out how to read and write input parameters for a python script from a csv file. Now I am being asked to pre-populate the script tool dialog in ...
3
votes
2answers
204 views

How can I create a portable script for coordinate conversions to run from USB?

I would like to be able to convert Lat long values in wgs84 to the swedish RT90, the values are in CSV files under headings X and Y. I would like to have this portable, an eg runned in a script in ...
3
votes
1answer
126 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
0answers
111 views

Joining csv file to vector layer in Processing modeler?

I am trying to join a simple csv file of values to a vector layer within Processing modeler. The match would be on an id held by both files. The csv file has no geometry. I can do this easily in ...
3
votes
0answers
198 views

Accessing existing instance of qgis from stand-alone python script

For my own data analysis pipeline, I am running a split screen setup with iPython notebooks on one side, generating variables from source data, pushing them to a csv file which qgis then reads/joins ...
2
votes
1answer
146 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 ...
2
votes
3answers
99 views

Can QGIS merge CSV files with different colums? [closed]

I am trying to merge a month's worth of daily CSV files without using ArcGIS. Each file has ~25,000 entries so this is a high data load project. Sample data can be found here. Note that we are using ...
2
votes
3answers
2k views

How to convert a txt file to shp?

I've got a txt/csv file with the utm coordinates and the hights. Now I want to upload this into qgis. This is not a problem so far. The problem is to create a shapefile out of the data with an ...
2
votes
2answers
327 views

How do I plot data stored in an attribute table (really in a database) in qgis

I have a csv of UK postcodes from Ordnance Survey that looks like SE1 0AA,10,531869,179427,E92000001,E19000003,E18000007,E09000028,E05000536 When I import to QGIS using 'Add Delimited Text Layer', ...
2
votes
2answers
972 views

Unable to create shapefile using shapefile.py

I am trying to create shapefile from csv data using shapefile.py but i am constantly getting this error, Traceback (most recent call last): File "createShp_Davis.py", line 31, in <module> ...
2
votes
1answer
52 views

Exporting coordinates of shapefile into CSV using FME?

I use FME to make a series of transformations from an autocad file to a shape file (with line geometry). What I am trying to do is to also export (together with the shape file) a CSV file containing ...
2
votes
2answers
928 views

Unable to get Mapbox leaflet-omnivore to load markers from .csv

I'm using the Mapbox.js API to build a really simple web map using a .csv file to place markers with tooltips. I'm trying to use the suggested leaflet-omnivore library to easily parse the csv and ...
2
votes
1answer
1k views

encoding problem with QGIS 1.8 and CSV import

I have following problem with QGIS 1.8. Lisboa (standalone installer, Win 7 Pro 64bit) - I import CSV - text in CP1250 separated with ";" and using "," as decimal separator. I correctly set the ...
2
votes
2answers
229 views

How to load a data table as a 'vector layer' using PyQGIS?

This might be a simple problem, but how does one load a simple two column CSV with no associated geometric data? I have given a couple go's via QgsVectorlayer[delimited text, spatialite] types - but ...
2
votes
1answer
157 views

From CSV file (latitude and longitude fields) to point .shp

How i create a new point shapefile from CSV table? If i have a CSV file with a latitude and longitude fields, is there a method for to have in output a puntal shapefile?
2
votes
1answer
76 views

Cannot import csv to dbase via Table_to_Table in ArcMap

I have a csv file with > 5 million records. When I imported it to dbase via Table_to_Table function in ArcMap, it raised ERROR(99999). As a result, only 2 million or so records were imported... How ...
2
votes
1answer
1k views

Exporting climatic tabular data stored in TIF file into CSV

I have a TIF file containing tabular climatic data, described here, which I am trying to export to spreadsheet / CSV format: http://www.helioclim.org/linke/linke_helioserve.html In summary, it is a ...
2
votes
1answer
898 views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
2
votes
1answer
125 views

spatial data filtering without GIS?

I have access to a database here (description of the columns are also available) containing spatial data in text format and with WGS84-EPSG:4326 coordinates. I would like to only select data in my ...
2
votes
2answers
220 views

How to convert Point coordinates into CSV format?

The GDAL documentation describes how to convert a ShapeFile into CSV data. The layer create options (-lco parameter) allows to prepend the coordinates of Point features to the actual attributes ...
2
votes
2answers
5k views

How to add csv file in QGIS 2.0 using Delimited Text Layer Plugin?

I used to import csv files in previous versions of QGIS using the format below, but when I upgraded to QGIS 2.0 the delimited text layer plugin was changed and I can't import the file anymore. The ...
2
votes
1answer
474 views

importing coordinates via a csv file does not work

I tried to manually add point data via a CSV file to an empty project in QGIS 1.8.0. The points do show up all right with the correct coordinates, but already the scale is not correct (using the ...
2
votes
2answers
3k 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?
2
votes
1answer
72 views

How to merge/combine several tables in geodatabase into one table using ModelBuilder?

I have over 50 csv files that have the same data structure and I need to merge them into one table. As I need to build a model I have successfully imported all the files into a File Geodatabase. ...
2
votes
1answer
131 views

QGIS 2.6 How to create a shapefile from an excel file?

I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shape-File). I have managed to convert it as CSV file and load it into QGIS (displays data fine) ...