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

learn more… | top users | synonyms

1
vote
1answer
2k views

How to generate shape file from Excel or CSV files? [duplicate]

Possible Duplicate: How can I convert an excel file with x, y columns to a shapefile? Probably this could be an easy question for most of the people. But I would like to know the way to ...
1
vote
1answer
29 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 ...
1
vote
1answer
112 views

ArcGIS 10.2.1 is not recognising my CSV file headings

I can't get my maps to work because of an issue I'm having with my CSV files. I'm trying to import coordinates and heights of wind turbines, and radius for a viewshed analysis and it works on the ...
1
vote
2answers
57 views

How to change a CSV layer attribute value from text to number - once again?

i have read most of the related postings and answers allready ... (e.g. http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/ and How to change a CSV layer ...
1
vote
1answer
77 views

Problem with import CSV files to QGIS 2.0.1

I have a problem with import CSV files to QGIS 2.0.1. I have a file with WGS84 coordinates it looks that: Nr;Longitude;Latitude 1;18,06,23.66;54,83,12.50 2;18,08,81.30;54,73,09.30 ...
1
vote
1answer
76 views

How to spatially join polygon fields onto a point layer in QGIS?

I have gridded depth points in CSV format that I'm trying to add other map data to, in additional columns. I've tried joining fields, hoping that I could link the Shapefile data to the csv, but when I ...
1
vote
2answers
122 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 ...
1
vote
4answers
115 views

Joining shapefile table with csv

So I am having a shapefile with all the world countries. And the table for this shapefile has a column named "Country Name". Each of this entry is unique, meaning, each country takes only 1 row, and ...
1
vote
1answer
94 views

Importation of .csv on grass gis converts numeric data to string data

When importing a csv file on grass7, the numeric data is converted into a data of type string. My csv looks like this : id_core value 1 F1 83.0611472396 2 F2 98.8584345936 3 F3 ...
1
vote
1answer
99 views

Export ArcGIS Model to Python - Iterate Rasters, Collect Values, Calculate Values

I want to batch process a large number of raster files, calculate some values and properties and export these to a .csv or .xls. I managed to get a good working model that does this perfectly. ...
1
vote
3answers
358 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 ...
1
vote
2answers
383 views

What's the correct csv format for MMQGIS Join by attribute?

When trying to join attributes from CSV-file with MMQGIS, I currently get the error message: File inaccessible or in unrecognized CSV format /Netzplanung/Truck_park/trkbuspk15_2.csv Tried with ...
1
vote
3answers
261 views

Can one edit xls, and convert xls to csv - with a portable python or Perl module? [closed]

I am on a network and computer where nothing can be installed. On this computer i run portable apps through a USB, however I need also to to edit xls, and save as csv. Since i cannot install anything ...
1
vote
1answer
307 views

Adding CSV upload browse button to Ext.Action

I am trying to create a CSV File upload on GeoExt Map App. I need to place the upload function within the Ext.Action, so that I can add it to the toolbar of the GeoExt Panel. I am trying to implement ...
1
vote
0answers
9 views

Why does GeoServer's GetFeature round my numbers, but only for outputFormat=CSV?

When I make a GetFeature request with outputFormat=CSV to my GeoServer v2.4.5 I'm finding that the floating point numbers in my returned data have been rounded. When I make the same request with ...
1
vote
0answers
10 views

Can QGIS2 refresh layers without the need to reclassify each layer individually?

I have a set of layers which I'd like to have refreshed each time I open QGIS2.2.0 (Windows 7). Each of 14 layers (polygons) is linked via a join to a csv file with no geometry. The layer displays a ...
1
vote
2answers
42 views

Change field map properties in ArcMap

I am trying to import csv files in ArcGIS to do a join. However, some of the fields are identified as double, some as long and some as long. Therefore the join results in bunch of columns with NULL ...
1
vote
1answer
29 views

How to prevent QGis (MMQGIS plugin) from interpreting numbers as strings [duplicate]

I'm using the MMQGis plugin to "Join Attributes From CSV" into a shape file and am having trouble getting QGis to interpret some numbers as numbers (rather than strings which is what its doing). This ...
1
vote
0answers
75 views

QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working

Just upgraded to QGIS 2.2 and it looks like saving a layer as CSV doesn't support GEOMETRY=AS_WKT anymore. The new Layer Options portion of the save dialog is cool but it looks like GEOMETRY and ...
1
vote
0answers
74 views

problem in using schema.ini to force ArcMap recognize field types

I have a folder of csv files (500+), and created a very long schema.ini file to force ArcMap recognize field types as I want. However, for some reason, ArcMap can read some CSV files properly; but ...
1
vote
0answers
72 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 ...
1
vote
1answer
542 views

How to add X/Y data from Excel file (saved as CSV) on shapefile? [duplicate]

I need to add my X/Y coordinate data as points from my Excel I need help with adding points (using X/Y coordinates). Can anyone help? import arcpy from arcpy import env env.workspace = ...
1
vote
0answers
140 views

QGIS Points to Path Plugin Date/time error [closed]

I would like to use the Points to Paths plugin to plot the tracks of collared animals, exactly as specified on this page http://spatialgalaxy.net/2011/12/30/qgis-plugin-of-the-week-points-to-paths/ ...
1
vote
0answers
194 views

Why does XYToLine_management give ExecuteError ERROR 999999 The table was not found?

I've written this script to import a csv file using ArcGIS' flavor of python.. ArcPy.. It seems to run fine up until the XYtoLine tool runs and then it fails.. This is the error message... Traceback ...
1
vote
0answers
177 views

How to write vector layer to csv file with geometry by PYTHON?

I use Python try to write vector layer file to csv file with this code QgsVectorFileWriter.writeAsVectorFormat(mylayer, r'c:\temp\xyz.csv', "utf-8", None, "CSV") It can export to xyz.csv but only ...
1
vote
0answers
82 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
1
vote
0answers
100 views

'File is too big' error when uploading QGIS Plugin

I have written a simple QGIS plugin which zooms the map canvas to a user specified UK postcode. I would like to share the plugin but the csv file, which contains stripped down OS Code-Point open data ...
1
vote
0answers
343 views

Why is my .csvt not recognized? [closed]

I am trying to associate a .csvt file with a .csv file, so QGIS doesn't insist on calling all the fields text strings (thereby preventing the use of graduated symbols). I used the syntax described by ...
1
vote
0answers
517 views

How do you format an OGR VRT file to best convert a CSV to KML?

I am attempting to get a nice KML for simple review of POI/geocoding from a CSV. I a using ogr2ogr and a vrt. You can see the vet file below, with two attempts to get this right. Basically, the issue ...
1
vote
0answers
269 views

Placemark that pulls information off an excel sheet row and display's the data in the description part of the Placemark

I am trying to find out if a certain function is available to link an excel sheet with a kmz. What i need to happen is have a Placemark that pulls information off an excel sheet row and display's the ...
1
vote
1answer
213 views

Error 000204 using “Export Feature Attribute to ASCII” Tool on ArcGIS Server 10

I´m trying to export feature attributes to a CSV-File (on ArcGIS Server) to use them in other applications (using the "Export Feature Attribute to ASCII" Tool). While the tool is working ok in a ...
0
votes
3answers
1k views

Using the python shape library: pyshp - how to convert polygons in .csv file to .shp

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 ...
0
votes
1answer
190 views

Help with Python Update Cursor syntax

I'm having trouble running a loop to update the values in a particular field in attribute table by reading from a csv file. Any input is greatly appreciated. The following is the sample code: import ...
0
votes
1answer
192 views

GeoTool CSV to Shape Conversion Error

In the Feature Tutorial Example GeometryFactory geometryFactory = JTSFactoryFinder.getGeometryFactory(); generates error: method getGeometryFactory in class ...
0
votes
1answer
46 views

Error adding coordinates in CSV files

I'm wondering if anyone can help me. I added a CSV file on ArcGIS 10.2.1, I displayed the coordinates and everything worked fine. However, when I duplicated and edited the new CSV file to change the ...
0
votes
2answers
60 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: ...
0
votes
1answer
83 views

PostGIS import csv encoding problem

I want to import csv into PostGIS database, I receive error massage: alpha=# COPY project FROM '/home/alpha/database/project.csv' DELIMITERS ',' CSV; ERROR: invalid byte sequence for encoding ...
0
votes
1answer
102 views

With QGIS, how can I create a layer from a .csv file?

I have a .csv file with ~16k points with lat and long to plot onto a map. I'm completely new to both QGIS and GIS in general and have got to a point where I have downloaded the OpenLayers and ...
0
votes
1answer
51 views

Display county for random points

I have a county level shape file for South Carolina. I generated random points using Vector->Research Tools-> Random Points. The Attribute tables for the random points layer has only the ID included. ...
0
votes
1answer
330 views

Trying to make xml data readable for Arcgis

I am trying to convert xml data into tabular form for the process of geocoding. We have the xml file with info that we are going to run through an address locator. Do I need a script for this? Can ...
0
votes
1answer
29 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
0
votes
1answer
33 views

why can't i export geometry data from a shapefile?

I saved the layer using "vector save as" box but even when adding GEOMETRY=AS_XY in the layer box, the csv only showed the id and no gemetry data.
0
votes
1answer
55 views

What is the format expected by QGis for Latitude/Longitude in DMS?

I have been struggling with a csv file I need to import into QGis 2.2.0 (on Windows 7). The coordinates are in this format: LATITUDE LONGITUDE 424605 861204 395222 861206 303051 861219 ...
0
votes
1answer
26 views

Raw State Data on Health and Social Outcomes

I am looking for raw health and social outcome data (poverty, obesity, education levels, etc.) by state. I would like to download it as a csv or excel file. It needs to have the state fips listed in ...
0
votes
2answers
43 views

How to create path based on waypoints?

I am trying to map flight paths and compare historic paths with current ones (so I later need to perform some calculations as distances between them). For this task I am using QGIS on OSX 10.9.1 As ...
0
votes
2answers
61 views

How to join CSV data to SHP without ArcGIS?

I'd like to create a chloropleth map displaying quantitative data for an upcoming event. Using TileMill, MapBox. I am having trouble joining my data to a .shp because the #'s correspond to COUNTY ...
0
votes
1answer
74 views

Object-ID field in CSV file

I am displaying a CSV file in ArcGIS 10. After adding the data table, I right-click it, and select "Display XY Data". I am able to complete the required information and display the data, however, I ...
0
votes
1answer
179 views

QGIS 2.0 text delimited layer importing data as single row

I'm trying to import a text delimited layer using lat/lon, but the tool interprets the data as a single line. I've tried saving my csv using several different programs (Stata, python editor, text ...
0
votes
1answer
237 views

QGIS: CSV point grid to polygon - not raster

I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to ...
0
votes
1answer
110 views

How to map and color localities (provinces) with an external CSV using Quantum GIS

I use a Swiss shape file map (called PLZO_PLZ) available on http://www.cadastre.ch/internet/cadastre/fr/home/products/plz/data.html (ZIP file Shape LV03) PLZO_PLZ contains a column called PLZ which ...