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

learn more… | top users | synonyms

2
votes
2answers
7k views

Exporting county level data in *.shp file to text (csv) file in ArcMap?

I have a shape file created as per the answer to my previous question, which includes county level means for each county in the US. How can I now export this data in a .csv file, e.g. with just the ...
2
votes
3answers
3k 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
1answer
2k 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 ...
2
votes
3answers
103 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
2answers
1k views

Date fails in String -> Date in CartoDB

I'm trying to convert a column in CartoDB from String to Date. My dates are the following format: 2014-01-02T00:02:00 2014-01-02T08:05:00 ... I've tried to append +00:00, so they looks like: ...
2
votes
2answers
374 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
1k 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
2answers
75 views

How to make a square out of two points?

I have a csv file with two x and y columns. (x,y,x,y). The coordinates represent tiles which I want to visualize in ArcMap. But I dont know how to do it. As you can see in the picture below, given ...
2
votes
1answer
168 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
1k 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
1answer
105 views

QGIS Reprojecting csv point file to projected CRS

This is a problem I have been struggling with quite a bit and so far have not found a good solution, so I hope to find some help here or an eyeopener where I have gone wrong so far. Using QGIS 2.10.1 ...
2
votes
2answers
468 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
209 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
88 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
2k 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
1k 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
129 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
3answers
971 views

Join CSV file to shapefile

I wanted to join a CSV file to a shapefile. When I identified a field to facilitate the join, e.g., map <- spChFIDs(map, as.character(map$ID)) it returned Error in spChFIDs(SP, x) : ...
2
votes
1answer
172 views

CSV handling in QGIS?

I am using QGIS 2.4.0 and sadly it seems that QGIS imported csv files are somewhat bugged. I cannot use imported csv files the same way as shapefiles. It seems that sometimes it is easier to import ...
2
votes
1answer
679 views

Reproject CSV file to different projecton using ogr2ogr

I have a CSV file "visivisi.csv" with two columns "x,y" which is in my country local projection. The proj4 line is +proj=tmerc +lat_0=0 +lon_0=24 +k=0.9996 +x_0=500000 +y_0=0 +ellps=GRS80 ...
2
votes
1answer
419 views

Null values coerced to zero (0) when exporting to csv or txt

I extracted values from several rasters, and in some cases, the value is null. However, when I export the attribute table to a csv or a txt file (from ArcMap), the null values are converted to 0. Is ...
2
votes
2answers
284 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
6k 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
578 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
566 views

ArcObjects table views or SQLite3 in Python?

Given a larger csv (1000+ points) with attributes, I need to do both attribute and spatial queries on the data. Would it be faster to read the points into an xy feature class, and do the spatial and ...
2
votes
1answer
34 views

How to control field properties when importing csv to Arc gdb [closed]

I am writing Python code to import csv files with UK postcodes to ArcGIS file gdb. The import works fine, however, text fields in newly created table in gdb have length of 8000 characters. Is there a ...
2
votes
1answer
34 views

Open CSV with native QGIS Widget

I am writing a plugin that offers to open a CSV. I know the local path to the CSV but I don't know if it contains spatial data nor which name the X and Y could have. The best way I can think of, is ...
2
votes
1answer
50 views

Creating a CSV with Irish Grid references and opening the points in QGIS

I have a load of Irish grid references that I need to create a map of in Ireland - any advice? Tried to input a couple of refs and open in Biological record tool thinking this would be simple but hey ...
2
votes
1answer
223 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
690 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) ...
2
votes
2answers
103 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
2
votes
1answer
112 views

How to use a csv file to add values to a value map?

I'm trying to populate a value map in the edit widget with some values from a csv file. Could anyone let me know what format the csv file has to be in? At the moment I have just a list of ...
2
votes
2answers
923 views

Line Layer from Point to Point CSV file using QGIS?

My question is probably a basic QGIS question but I could not find something that would work for me. I have a file of the following format: where each from/to is a point that is already inserted ...
2
votes
2answers
90 views

What is the recommended format to import tables from Excel to arc map with more than 65 536 rows? CSV?

What is the recommended format to import tables from Excel to Arc map with more than 65 536 rows? CSV?Txt?
2
votes
1answer
97 views

How do I rename rasters in an mxd by using my csv?

I have the following data in a csv: RasterName First name Raster 1 Aaron Raster 1 Paul Raster 2 Bryan Raster 3 Cranston Raster 3 Vince I have added these ...
2
votes
1answer
477 views

How to convert shp to csv

I am trying to convert my shape files to csv through a batch processing in Java using Geotools. The problem is I have more than 500 shape files (point features). The code is working fine for a small ...
2
votes
2answers
214 views

How to draw a square from 2 coordinates?

I have a CSV file with the following output id, x min, y min, x max, y max, value 1 , 0 , 0 , 100 , 100 , 5 2 , 0, , 100 , 100 , 200 , 10 3 , 100 , 100 , 200 , 200 , 15 4 , 100 , 0 ...
2
votes
2answers
849 views

How to keep initial zeros when importing csv to dbase in ArcMap

I have a CSV table with millions of records. When I imported in into dbase via ArcMap, those inital zeros in a certain field just went away. E.g. one field show be "01001", but it displayed as "1001". ...
2
votes
1answer
303 views

Accented characters in csv file appear as '?' when importing to QGIS

The tabular data (.csv file) and the data in the attributes table of the vector (.shp file) I am trying to join includes accented characters - they are place names in Pamana. For example 'Río Abajo' ...
2
votes
1answer
84 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
2
votes
4answers
1k views

Why does QGIS not detect the CSV/DBF column headers?

I am trying to import a csv or dbf into qGIS so I can perform a join on a shapefile. However, qGIS is not detecting the first row as header names. I know I've done similar joins before and there's ...
2
votes
1answer
217 views

How to add point coordinates to a non geo-referenced csv file?

I have a csv file with information but not georeferenced. I'd like to load it in QGIS and add points (with coordinates) in the same file and later save as a shapefile. Is there any way to doing that ...
2
votes
1answer
594 views

How to create a point table from a remote csv file?

The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
2
votes
2answers
772 views

Convert CSV files into OSM with FME

I have a database which i've exported as individual csv files for each table. Below are some of the attributes which exist from two of the csv files: wayPointID linkID order x y z length ...
2
votes
1answer
52 views

CSV to Layer from a Delimited Text File in QGIS

enter image description hereI am importing a CSV file into QGIS using the official instructions on their page: http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html. For some reason, ...
2
votes
1answer
551 views

Showing csv file on map

Does OpenLayers support the uploading and rendering of CSV files? If it does, how? I used this code and it didn't help. var curLayer = new OpenLayers.Layer.Vector("layer", { protocol: new ...
2
votes
1answer
91 views

Conversion of CSV file in MyGeoData Converter - XY columns not recognized

Recently I have tried to import various CSV files with XY coordinates to MyGeoData Converter. In some cases I got a message: Selected data does not have a spatial part! For example, this file ...
2
votes
1answer
240 views

Plotting Postal Codes from .csv Files in QGIS

I have Canadian postal code data that I would like to plot. This data is currently stored in a simple .csv file. At the moment the only other data I have is FSA data from Statistics Canada. Is ...
2
votes
2answers
114 views

csv to shp missing file

I transform a csv file into a shape file using the following script import shapefile as shp import csv import tkinter.filedialog import urllib.request import os a = ...