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

learn more… | top users | synonyms

2
votes
2answers
443 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
89 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
128 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, ...
2
votes
2answers
161 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
193 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
89 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
260 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
60 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
117 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
87 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
121 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
63 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
286 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
390 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
231 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
73 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
176 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
78 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
94 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
271 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
114 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
3k 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
9k 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
91 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
127 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
80 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
120 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' ...
0
votes
1answer
352 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
150 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
101 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 ...
1
vote
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 ...
2
votes
1answer
178 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
2answers
359 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
148 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
113 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
1k 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
1k 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 ...
2
votes
2answers
840 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
105 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
486 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
265 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
52 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
65 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 ...
3
votes
1answer
716 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
83 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
93 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
91 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 ...
4
votes
2answers
432 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 ...