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

learn more… | top users | synonyms

1
vote
2answers
58 views

Including js file in openlayer.js file

I have this code for showing markers on map: function addUserLayerCSV(){ layer1 = new OpenLayers.Layer.Vector("CSV", { projection: epsg6316, strategies: [new ...
1
vote
3answers
453 views

convert csv to kml or geojson, etc using ogr2ogr or equivalent command line tools (use “latitude” and “longitude” attributes for coordinates)

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csv The csv has "latitude" and "longitude" columns. The attributes are all loaded ...
1
vote
1answer
706 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 ...
1
vote
2answers
123 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
3answers
825 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 ...
1
vote
1answer
30 views

How to read GeoCSV with OGR?

I have a GeoCSV file which stores the geometry in a WKT formatted cell following this recommendation: "identifier","date","geom","value" "Dgf01","15.04.2013","POINT (52.404869 13.147457)","285" ...
1
vote
1answer
51 views

How to add neighborhood names from shp to csv data points QGIS

I'd like to add the neighborhoods listed in a shp file to the data points in a csv Link to shp Link to csv Here are the data points overlaid on the shapefile map of the neighborhoods. I'd like ...
1
vote
2answers
41 views

Adding Rasters as Columns in Shapefile using ArcGIS for Desktop? [closed]

I am currently working on a research project in a lab, and I am fairly familiar with ArcGIS (I'm only in high school and have done some previous work using ArcGIS). I was asked to add 3 columns onto a ...
1
vote
1answer
66 views

Why does QGIS add decimals when a csv is saved as a shapefile?

When I save a csv as shapefile the fields with decimals are saved adding decimals, then the new table in some case has new values. Old Table (CSV) ALTURA ELI ALTURA ORT 1.94 39.6 -11.19 ...
1
vote
1answer
45 views

Writing list of feature classes with fields to one csv file per feature class?

I have a database with multiple feature classes. Now I extracted a list of feature classes and a list of fields. I figured out how to write the list of feature classes and the corresponding fields to ...
1
vote
2answers
83 views

Which format to choose to convert to ShapeFiles?

Given the following format options: all.json, all.xml, all.xls, all.csv, all.kml, all.gjson Which one is the best/easiest to convert the data into standard ERSI Shapefiles which contains the ...
1
vote
1answer
125 views

How do make a CSV file visible in QGIS?

I am using QGIS. I have a .csv file containing 3 pieces of information on each row; name, longitude and latitude. I would like to turn each row of the .csv file into a vector point. The file will ...
1
vote
1answer
64 views

Spaces in postcodes preventing join

I have a shapefile British Columbia with postal codes. The attribute table gives the codes with no spaces, eg V6P2A8. I am trying to join a csv file by postal code (the key I am using). My csv file ...
1
vote
2answers
63 views

Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)

I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
1
vote
2answers
192 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
329 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
1answer
49 views

Is it possible to change data (attributes) in the .csv of a data vector layer and QGIS automatically adopt this?

I have a .csv with data for 300 points: Each column on the .csv is a particular object and the cells define the amount that is available in each point. If I need to change this amount, is it possible ...
1
vote
1answer
65 views

CSV to ArcGIS table, insufficient text field length

I currently use arcpy.TableToTable_conversion in order to convert a CSV file into an ArcGIS file geodatabase table. This works when string length is less than or equal to 255 characters. Whenever 255 ...
1
vote
1answer
62 views

Rewriting csv file for QGIS

So, I have a .csv file. Here an example how the a row from the original .csv looks like: "AREA",44.37,-00.83,"5","1","8","E","E",,,"KKI","KKO" Some lines have missing latitudes and longitudes, ...
1
vote
2answers
37 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
1
vote
1answer
162 views

Handling KML/CSV with geopandas - DriverError: unsupported driver: u'CSV'

I'm trying to import a dataset of UK postcode districts UK postcode districts from Google Fusion tables into geopandas with the aim of splicing it to a dataset of house prices. The problem is that ...
1
vote
2answers
143 views

Export long lat from polyline as csv file in QGIS

I want to draw a line in QGIS and then, export the long-lat of each point into a Comma Separated Value (csv) file. I tried doing this by creating a new shapefile layer and then using the Add Feature ...
1
vote
2answers
291 views

Error while importing CSV File using PyQGIS

Currently I am trying to import a CSV file using the python extension in QGIS and I have run into a problem that I can not seem to solve. I am trying to do a basic import of a CSV file from a python ...
1
vote
4answers
668 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
2answers
43 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
2answers
479 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
831 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
4answers
869 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
1answer
127 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
703 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
108 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
3k 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
15 views

How to read non-spatial data using PyQgis?

I'm generating maps with QGis. What I do is generate a bunch of non-spatial data on a set of cities (using VBA), and still using VBA, generate a python code that will automaticaly output general map ...
1
vote
1answer
26 views

Importing Edge List into QGIS?

I have a CSV edge list such as follows: Lat1,Lon1,Lat2,Lon2 93.41823,-104.324324,93.41828,-104.324320 93.40110,-104.310552,93.40108,-104.310557 ... Is there a way to import such a CSV file into ...
1
vote
1answer
62 views

Is it possible to use non-printable characters as delimiter for text file layer in QGIS?

I am trying to import a Delimited Text File Layer from a .csv file in QGIS. Because this caused a lot of errors, I posted a question here and got the hint towards using ASCII non-printable control ...
1
vote
1answer
35 views

why the values are NULL if I join the csv table to a point shp file [closed]

So my problem is all values are NULL if I join my csv-table to a point-shape-file. (QGIS) Why? I tried so much thing but I can not find and handle the problem. I have customer names in the csv, ...
1
vote
1answer
27 views

Alternatives to GeoRSS for time-sensitive point data

I'm looking for a suitable data format for various organisations to publish point data with a recent time component, like events, road closures, etc. GeoRSS is the obvious candidate but: It's XML, ...
1
vote
2answers
121 views

How to overlay a Lat/Long CSV and NAD83 Shapefile in QGIS?

For reference I am new (as in a few hours of messing around) to GIS. I have a shape file/accompany projection files ect: CURRENT.prj CURRENT.shx CURRENT.shp CURRENT.dbf CURRENT.sbx CURRENT.sbn I ...
1
vote
2answers
185 views

Leafletjs : combine location data in geoJSON/KML/GPX with other information in CSV through key field

I've been able to load CSV having lat-long co-ordinates into leaflet using this useful solution. Looking for ways to cross-link co-ordinates from a different source and data from another. Describing ...
1
vote
1answer
145 views

How can I geocode CSV by postcode, using existing point data, in QGIS?

I have a very simple MapInfo workflow for geocoding a CSV file which contains UK postcodes, based on an SQL select query referring to point data for postcodes. This is simple. Using Mapinfo open the ...
1
vote
1answer
114 views

Copy Features tool run after Make XY Event Layer on CSV file fails to complete?

Using the Make XY Event Layer tool I converted a table to a layer. I am trying to convert the newly created layer to a feature class in my file geodatabase. I have been able to do this in ...
1
vote
1answer
155 views

How to convert total station data (coordinates) to 3D model? [closed]

i have my coordinates in .csv format and i want to convert it to a usable 3D model. How do i go about this or what software can i use to achieve this?
1
vote
2answers
131 views

Extracting/Exporting coordinates from polygons (shape) to text?

Is there any well working way to extract the X and Y coordinates of a polygon from shapefile to some sort of text (preferably csv)? The whole process should be somehow done automated through a ...
1
vote
1answer
178 views

How to import geometry data from csv file to postgres?

I have geometry file in *.xls file, but when I save in *.csv it say "some feature in your workbook might be lost if you save it as CSV (Comma delimited)" however I keep that file anyway and when I ...
1
vote
1answer
80 views

How to import `numeric` fields from csv to dbf in ArcGIS?

I am trying to import a CSV into a DBF using ArcCatalog (10.1). In the field map, pictured below, I can only set an ID field to Long, Text, Double, etc. But there is no Numeric type as in DBF and ...
1
vote
1answer
41 views

Operations between shape layer and csv layer

I've got a question for you! I have a .shp layer containing point geometry with xy coordinates in the attributes (left) and a .csv layer containing a square Origin/Destination matrix(right): I ...
1
vote
2answers
646 views

Exporting lists of Feature classes and fields from SDE

I'm using matt wilkies' arcplus module http://gis.stackexchange.com/a/5943/16793 to export a list of feature classes within an SDE database to a text file. I've also written a tool to write field ...
1
vote
1answer
54 views

How to “lower the resolution” of a lat long csv

I have a csv with 12.5 million date/lat/long/value points, it's a point every 800 meters ( in a grid ) of the united states what's the best way to convert the points to every 1600 meters? or 3200? ...
1
vote
1answer
243 views

ArcMap 10.1 Crashing when using field calculator

I keep getting a serious error message when I try to use the field calculator. I've joined a .csv to my SDE feature class and am trying to set one of the columns equal to one of the columns from the ...
1
vote
1answer
310 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 ...