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

learn more… | top users | synonyms

4
votes
2answers
62 views

Bulk convert DBF to CSV in a folder ArcGIS 10.1 using Python

I would like to convert 1000 dbf files to CSV. All dbf files are in one folder and they have sequential names (S:\output_tables\tcb1.dbf, S:\output_tables\tcb2.dbf, S:\output_tables\tcb3.dbf, up to ...
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 ...
0
votes
1answer
22 views

Save as .csv with coordinates in both QGIS 2.2 and PyqGIS

These questions have been asked before, but since they are not answered I will try to pick up the ends here. 1) First, as stated here: QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working ...
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
41 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 ...
0
votes
0answers
8 views

Import non spatial data into SQL Server using ogr2ogr

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using ...
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
0answers
56 views

Converting a CSV to shapefile

I am attempting to load a CSV file into Qgis and ultimately convert it into a shapefile. I used Layer->Delimited Text Layer but the only options are for points, WKT and no-geometry. Neither of ...
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
0answers
19 views

drag and drop csv file and display map using leaflet js

I am new in php and leaflet js. I want to drag and drop .csv file in php and using the values of csv file, I want to display map using leaflet js. Can any one help me.
0
votes
1answer
52 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
25 views

Problems converting csv to shp in QGIS 2.01 on a Mac

When converting a csv to shp, I have been using the 'Add delimited text layer', and get one of two errors. With 'First record has field names' clicked, I am told that there is 'no data found in file'. ...
1
vote
1answer
26 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
28 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
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 ...
0
votes
1answer
64 views

importing data into CartoDB

I've tried several ways of bringing my spreadsheet into CartoDB (.csv, .xls, .xlsx). However I keep getting a message like: An error ocurred when importing your data Error 99999 Unknown What ...
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 ...
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 ...
0
votes
0answers
20 views

String to Integer in QGIS [duplicate]

I have a csv (below) of values I would like to represent in a choropleth map. I've managed to join them to a shapefie via fips code successfully in this format, but the last four columns do not show ...
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 ...
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 ...
0
votes
1answer
17 views

QGis polygon to points different CRS problems

I'm trying to join the values from polygons onto a grid of points. I had this problem solved here by @Underdark , however a few layers weren't working. It seemed they were all British National Grid ...
1
vote
2answers
18 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 ...
2
votes
2answers
81 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 ...
1
vote
1answer
163 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 ...
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 ...
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 ...
2
votes
1answer
54 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 ...
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 ...
2
votes
2answers
46 views

Import CSV file into Postgis DB with Location-field formatting?

I am working to import CSV into table in my Postgis Database. First, I created the table Create Table test ( name varchar, created_date Date, location double precision ); When I excuted the ...
1
vote
2answers
53 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 ...
0
votes
0answers
20 views

How do I set the column type for a CSV file in ArcView? [duplicate]

I have a CSV file that I'm using to create a layer in ArcView 10. The first column contains a mix of numbers in the first few records, with strings further down. On import, ArcView casts the entire ...
2
votes
0answers
63 views

ArcGIS 10.0 - problem with exporting a huge geodatabase table to CSV or DBF

ArcGIS 10.0 SP5 @ Windows XP Intel® Core™2 Quad Processor Q9650 (12M Cache, 3.00 GHz, 1333 MHz FSB) 3 GB RAM In a file geodatabase I have a point feature class with a huge amount of records (over ...
1
vote
2answers
116 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 ...
3
votes
0answers
48 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 ...
0
votes
2answers
59 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
124 views

How to extract geo data out of a polygon shape file into csv kwt [duplicate]

I have a polygon shape file that contains all the neighborhoods in the Netherlands. My aim is to export the neighborhoods and coordinates to csv file (KWT). Without success I tried (with QGIS) these ...
1
vote
2answers
119 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 ...
0
votes
2answers
67 views

Python Error in QGIS Ubuntu 13.10 while trying to join .csv tables

Using the mqgis plugging in QGIS I cant join my csv file... This is what QGIS returns me: An error has occured while executing Python code: Traceback (most recent call last): File ...
3
votes
1answer
111 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, ...
1
vote
2answers
98 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 ...
5
votes
1answer
120 views

ogr2ogr csv conversion with latlon in one column

I have a csv with "lat\,lon" in a single column. I am trying to convert it with ogr2ogr to another format, and cannot figure out how to format the VRT file to accept this format. I cannot do ...
1
vote
1answer
69 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
134 views

QGIS, making a topo map from an excel file

I will appreciate your help. I am new to QGIS, this question might be common but trough me search I did not find the answer I needed hence my question here. How do I make a topo map ( raster) from ...
0
votes
0answers
49 views

By converting into a shp file points are reduced

I am new here, so sorry if I missed something, but when I try to converta data from an xls file into a shp file by export data, all the points I had before get reduced to only one?! I also want to ...
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 ...
2
votes
1answer
73 views

Is there no editmode for CSV files? [duplicate]

I load a delimited text layer and it get's visuialized. Unfortunatly I don't know why I can't switch to edit mode. I already worked with similar .CSV files in edit mode before, under the same setup :( ...
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 ...