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

learn more… | top users | synonyms

6
votes
1answer
278 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
126 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
594 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
72 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
218 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
105 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 :( ...
3
votes
0answers
214 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
79 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
647 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". ...
1
vote
3answers
893 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
874 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
2k 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
211 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
154 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
131 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
426 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
224 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
2answers
5k 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
26k 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 ...
1
vote
0answers
169 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
183 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
102 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
239 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' ...
1
vote
1answer
544 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
198 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 ...
0
votes
1answer
139 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 ...
4
votes
3answers
4k views

Using PyShp to convert polygons in *.csv to *.shp files?

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 ...
3
votes
1answer
279 views

QGIS: Colour GPS track by speed

sorry íf I might ask this question the 101 time, but I didn't found anything with google or SE. I have a CSV file with WGS84 trackpoints and visualizing them with QGIS textplugin works fine. The log ...
1
vote
5answers
987 views

Batch convert xy to shapefile

I have about 300,000 CSV files which I want to convert to shapefiles, but ArcGIS and QGIS can only convert one CSV at a time. Are there any ways to batch convert my CSVfiles? x y z1 z2 z3 z4 1 2 3 ...
1
vote
1answer
250 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 ...
0
votes
1answer
139 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 ...
4
votes
2answers
2k views

Export dojo datagrid results to csv in javascript web application

I have created a web application using the esri javascript web api. I populate a dojo datagrid with results returned from a querytask. My question is, how do I export the results to a csv file? I ...
0
votes
3answers
4k views

How to plot coordinates from *.csv file on Google Maps?

I want to highlight a mobile trace on Google Maps and GIS data from my network must also be visible. I am able to plot hard coded coordinates on Google Maps but not from a *.csv file. Note: *.csv ...
3
votes
2answers
2k views

How to read csv with WKT geometry in Arcmap?

I have found several parcels I need on a county map viewer. However, the only option to download any of the data is found on a click context menu to "Copy selection as csv" which gives me this: ...
2
votes
0answers
120 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
1
vote
2answers
1k views

Tool for exporting las data

Is there any tool available for extracting the X, Y and Z channels from a .las file and exporting them to a .csv or similar file?
1
vote
1answer
503 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
66 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 ...
2
votes
1answer
80 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
4
votes
1answer
1k views

How to add CSV data with no coordinates to a polygon layer in QGIS?

I would like to add attributes from an spss database (around 300 cases) to a polygon layer in QGIS. Both datasets have a column with unique IDs. I exported the spss data to a CSV file which does not ...
0
votes
1answer
100 views

Can this compilation and display of species frequency data be improved? QGIS 1.8.0

As a newbie on QGIS, I would like to find out if the way I put a species frequency map together could be improved upon. I had to map the presence or absence of 7 plant species surveyed in 30 2m x 2m ...
1
vote
2answers
107 views

Why can't I save csv as a shapefile

I am trying to follow the instructions given here, Tutorial: Making Heatmaps using QGIS and GRASS , to build a heat map with my own data. I taken the first step and imported a csv data table into the ...
0
votes
1answer
130 views

Why is the CSVT file changing my real values to null?

I made a CSVT file to change desired real data to string data. After importing the original CSV file, that was linked by file name to the CSVT file, the string data appears as normal however all the ...
5
votes
2answers
979 views

How to draw lines from two points in a CSV?

I have a CSV file where one line looks like this: Duration, user, lat-start, long-start, lat-end, long-end 298, Casual,38.9101,-77.0444,38.91554,-77.03818 Each row in the CSV has two points and I ...
2
votes
2answers
144 views

gdal_grid unable to get nodata outside of original data area

I have a vector based csv file that I want to convert into a grid using gdal_grid, but I want to force null data values strictly around the area where there is data. I can get gdal_grid to work but ...
1
vote
0answers
317 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
474 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 ...
0
votes
1answer
134 views

Values in attribute table not showing up

I have values in an attribute table I want to label my layer with. But when I label it, a totally different set of values show up. In the attribute table, my values are between 0 and 200. But the ...
1
vote
1answer
310 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. ...
3
votes
1answer
326 views

How to get default parameter value for script tool from csv file?

I am fairly new to python scripting. I have just figured out how to read and write input parameters for a python script from a csv file. Now I am being asked to pre-populate the script tool dialog in ...