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

learn more… | top users | synonyms

0
votes
0answers
21 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
29 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
169 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
29 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
26 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
126 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
403 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
56 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
105 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
144 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
101 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
78 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
238 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
126 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
65 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
111 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
190 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
75 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
133 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
258 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 ...
2
votes
2answers
283 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
81 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
120 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
134 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
157 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
83 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
202 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
55 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
99 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
77 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
98 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 ...
2
votes
1answer
60 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
2answers
171 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". ...
0
votes
0answers
17 views

Is it possible to omit the headings of the CSV output of a GetFeature request?

I am making a web service which will consume the result of a WFS GetFeature request made against Geoserver. It would tidy up the code on my side if I was able to specify that the CSV output from ...
0
votes
1answer
293 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
4answers
162 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 ...
0
votes
0answers
70 views

CSV filename in field names

QGIS 2.0.1 When joins are done from CSV the "new" field names are starting with CSV-files name. How the joins are done without CSV-filenames in fields names?
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 = ...
4
votes
1answer
165 views

Convertion of multiple csv automatically to shp

I have more than two hundreds similar csv files with columns (x, y, value1, value2, objectName). I need to convert them automatically to shp files with x and y columns as the coordinates. Could you ...
3
votes
2answers
73 views

Deleting the “cached” field names for a large CSV file

Using ArcGIS Desktop Advanced 10.1 I have a large CSV file (36MB with about 600,000 records) that contains single addresses that I want to geocode. The file is called "SingleAddresses.csv" The file ...
3
votes
2answers
90 views

What is the best plain text format for georeferenced raster data?

I have to translate satellite images in a file in .txt format or another, such as Excel or .csv, in which there are pixel values corresponding to (longitude,latitude) couples. What is the best file ...
2
votes
0answers
232 views

QGIS 2.0: Automating tasks, text files and shapefiles

Wondering if it's possible to automate some repetitive tasks in QGIS (2.0). This is my general workflow for importing some xyz type text files from another software package which export (not overly ...
5
votes
1answer
92 views

Is there a free dataset of historical geocoordinates of ancient cities and places?

Is there a freely available dataset (csv, geojson, topojson, etc.) with geocoordinates of ancient cities, for example of the Roman Empire? Ideally with additional information like population size? ...
2
votes
1answer
2k 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 ...
1
vote
2answers
6k views

Export list of values into csv or txt file

I would like to know how to export in Arcgis a list of values calculated in python script into one of the following data formats: csv, txt, xls, dbase or other. I would also like to know how to create ...
0
votes
0answers
78 views

Import csv file and use “toggle editing” and “field calculator” without Saving it as a Shapefile.

I am importing a .csv file in QGIS and I have also made the *.csvt file where I have specified my data types. I still cannot use "Toggle editing" and "field calculator".Whether I must save it as a ...
0
votes
0answers
119 views

Why are some values missing from the imported CSV?

Bit of a strange one: i'm importing a CSV where the rows are the WKT data for regularly progressing rectangles from a grid, then the rectangle name, then values (ranging between 2 & 254). When I ...
1
vote
2answers
72 views

Error adding a delimited text layer

Im working with QGIS 1.8.0 and I have been trying to upload a delimited text layer but keep getting the following error : The layer ...
2
votes
1answer
109 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' ...