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

learn more… | top users | synonyms

1
vote
1answer
550 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 ...
1
vote
2answers
151 views

How to queue FME output on the same workspace?

I have an .csv coordinate file with the following header num xc yc xmin ymin xmax ymax I want to tranform the x/y coordinates on each line of this file to lat / long ...
1
vote
1answer
216 views

Exporting data from a WFS service to csv file using qgis

I have a service that contains a list of points with some meta data and I would like to export this to a csv file. I remember doing this some months ago and it worked well, but now I can't find the ...
1
vote
2answers
69 views

csv to shp python and formating a row

I´m doing a script to convert csv to shp, but I want to format one of the columns. It´s a string then I´d like to format like this a[8:10]+' / '+a[11:16]+' UTC' being a the value in the column. ...
1
vote
2answers
25 views

attach point grid data non-grid points

Possibly a strange one: I have a dataset with loads of fields of environmental (explanatory) data, as a regular grid of points (black dots in image), and another dataset of sampled (response) values ...
1
vote
1answer
392 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 ...
1
vote
2answers
183 views

how to georeference my png using gdal

Hello I have created my own fantasy map, I have the map in a full size png and the map broken down into tiles ( with no geo data ) I installed MS4W and tried to use it to get the georeference data ...
1
vote
2answers
133 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 ...
1
vote
2answers
639 views

Error adding a delimited text layer in QGIS [closed]

I'm a GIS beginner here. I'm trying to add a delimited text layer in QGIS. The plug-in is okay. I have created a table in Excel, saved as CSV file, imported the file with QGIS, selected the delimiters ...
1
vote
1answer
109 views

QGIS CSV file sorts low numbers as high

So I have numbers that range from 5 to above 50, and when I sort these from least to greatest, the numbers less than 10 are treated as higher than anything else. It also does the same when I try to ...
1
vote
2answers
487 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
1answer
101 views

Transform csv-coordinates into area

I'm working with an inventory of a species in Southern Sweden. I have recorded my findings (together with coordinates, name of the species and year of finding) and created a CSV-file with i have ...
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
32 views

gdal_grid with CSV file and VRT “No point geometry found on layer”

Given the following .vrt file which I manually created: <OGRVRTDataSource> <OGRVRTLayer name="DGM5_BE"> <SrcDataSource>DGM5_BE.txt</SrcDataSource> ...
1
vote
1answer
36 views

How to upload a csv file into esri map with coordinates and plot in an esri map

I have got a sample code to plot the points on an esri map using a csv file. But the csv file is maintained in a server, i'm unable to upload it from my local system.Please let me know how i can refer ...
1
vote
2answers
45 views

Min/Max values from a feature class

I am very rusty/inexperienced in python and I was hoping someone might be able to give me some pointers on this script. I would like to create a more compact script that prints min and max values of ...
1
vote
1answer
64 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
180 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
102 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
103 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
138 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
4answers
158 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
122 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
186 views

QSpatialite : import multiple TXT/CSV

I'm using QSpatialite only. I don't have spatialite-gui neither the shell. I want to import multiple TXT/CSV at one time. How is it possible to do that ? I found nothing on the internet. Thanks
1
vote
1answer
123 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
440 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
3answers
290 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
333 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
1answer
97 views

How to import .csv file to CartoDB using SQL?

How to import .csv file to CartoDB using SQL, the data given below : POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD 35AP7600 | 4418 | 4368 | 262053 | 467223 35AP7601 | ...
1
vote
2answers
68 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 ...
1
vote
1answer
39 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
1
vote
0answers
87 views

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

Converting from a GPX track to CSV is easy, but I'm looking to go the other way. I have a table of point locations logged with a handheld GPS, with timestamps. I need to convert them to a GPX file ...
1
vote
0answers
55 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
13 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
70 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
0answers
164 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
98 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
95 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
1k 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
183 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
240 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
230 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
94 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
105 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
391 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
583 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
288 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
230 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
2answers
74 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
3answers
2k 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 ...