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

learn more… | top users | synonyms

0
votes
1answer
107 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 ...
3
votes
3answers
3k 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
190 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
435 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
168 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
122 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
2k 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
964 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
107 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
554 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
302 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
53 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
67 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
821 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
86 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
96 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
105 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
503 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 ...
1
vote
0answers
240 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
343 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
91 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
221 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
207 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 ...
2
votes
1answer
669 views

Exporting climatic tabular data stored in TIF file into CSV

I have a TIF file containing tabular climatic data, described here, which I am trying to export to spreadsheet / CSV format: http://www.helioclim.org/linke/linke_helioserve.html In summary, it is a ...
0
votes
0answers
126 views

Convert shapes in CSV to shape file

I have a csv file in which one of the fields contains a "shape" polygon in ESRI format. The other fields are textual, numerical, ext. How do I go about creating a layer from only the polygons in the ...
1
vote
0answers
367 views

How to write vector layer to csv file with geometry by PYTHON?

I use Python try to write vector layer file to csv file with this code QgsVectorFileWriter.writeAsVectorFormat(mylayer, r'c:\temp\xyz.csv', "utf-8", None, "CSV") It can export to xyz.csv but only ...
2
votes
3answers
1k views

How to convert a txt file to shp?

I've got a txt/csv file with the utm coordinates and the hights. Now I want to upload this into qgis. This is not a problem so far. The problem is to create a shapefile out of the data with an ...
0
votes
0answers
125 views

Use QuantumGIS to bulk-import csv files

I have a large set of .csv-files containing geographic information. Every dataset consists out of 2 .csv-files! This is my folder-structure. All files in Tracks are formatted equally and all in Routes ...
2
votes
1answer
380 views

importing coordinates via a csv file does not work

I tried to manually add point data via a CSV file to an empty project in QGIS 1.8.0. The points do show up all right with the correct coordinates, but already the scale is not correct (using the ...
0
votes
1answer
258 views

CSV and GDAL 1.10 in QGIS

It seems the GDAL upgrade from 1.9 to 1.10 changed the way CSV files are handled so that I now have a non-functioning QGIS. App hangs trying to import csv data file when previously had no problems ...
3
votes
2answers
665 views

Csv to Shp conversion? [duplicate]

I am working on a really big script right now where I have a csv file that I have removed rows and columns from, and edited the headers. I need to create one big shapefile for the entire csv file then ...
4
votes
2answers
2k views

QGIS import polygons in CSV

QGIS 1.8 on Mac: I'm hoping to migrate several dozen local maps from my 30 year old Win3.1 plotting system to QGIS. Polygons are in X,Y (CSV), first point repeated at the end to close it, with ...
0
votes
2answers
297 views

Why is QGIS reading in my CSV numeric data as string data, and how do I change it? [duplicate]

QGIS keeps reading in my numeric data from .csv files as string data. This means I have to figure out how to read it in with the proper data type, or convert it back to numeric inside of QGIS, ...
1
vote
0answers
110 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
0
votes
1answer
153 views

Problem with encoding of CSV and SHP files in Linux

I am new to using QGIS. I came up against the encoding issue of shp files. This solution to solved my problem in Windows (for source I had to put windows-1253 instead of utf-8) My question is what ...
2
votes
2answers
281 views

How do I plot data stored in an attribute table (really in a database) in qgis

I have a csv of UK postcodes from Ordnance Survey that looks like SE1 0AA,10,531869,179427,E92000001,E19000003,E18000007,E09000028,E05000536 When I import to QGIS using 'Add Delimited Text Layer', ...
0
votes
1answer
250 views

Help with Python Update Cursor syntax

I'm having trouble running a loop to update the values in a particular field in attribute table by reading from a csv file. Any input is greatly appreciated. The following is the sample code: import ...
2
votes
0answers
247 views

Best method to convert CSV file of lat/lon and depth data to bathymetry polygon?

I'm trying to create bathymetry polygons based on lat/long and depth data. I have tried several methods and the resulting polygons are clunky. Make XY Event Layer-->Copy Features--> Project--> ...
1
vote
2answers
61 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 ...
3
votes
1answer
174 views

Failed attempt to relate a .csv file of 400 records to a single record in a point data layer

I have the Provincial Groundwater Monitoring Network as a point feature of 39 monitoring wells which includes an attribute for WELL ID. Each monitoring well then has a corresponding .csv file with 400 ...
0
votes
1answer
53 views

Display county for random points

I have a county level shape file for South Carolina. I generated random points using Vector->Research Tools-> Random Points. The Attribute tables for the random points layer has only the ID included. ...
2
votes
0answers
200 views

Plot csv data on a map

My boundaries shape file has the following attributes; CODE, PROVINCE, AREA, SHAPE_LENG and SHAPE_AREA (note that there are no geo- coordinates). My data on the csv file has the following fields; ...
1
vote
0answers
109 views

'File is too big' error when uploading QGIS Plugin

I have written a simple QGIS plugin which zooms the map canvas to a user specified UK postcode. I would like to share the plugin but the csv file, which contains stripped down OS Code-Point open data ...
2
votes
2answers
2k views

Importing Lat/Long coordinates as CSV file & only displaying single point in QGIS

I am using QGIS and trying to import Lat/Long coordinates as delimited text layer. All points show up in my attribute table, however, only one point is displayed on the map? Any ideas?
1
vote
2answers
719 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 ...
5
votes
1answer
2k views

How to convert coordinates in a .csv into another CRS in QGIS

How can I convert coordinates which are stored in a csv and in a certain format in a different CRS, i. e. I want to convert GK 3 (EPSG:31467) into WGS 84 (EPSG:4326). I am using QGIS and already ...
1
vote
3answers
601 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 ...
2
votes
1answer
181 views

How to add point coordinates to a non geo-referenced csv file?

I have a csv file with information but not georeferenced. I'd like to load it in QGIS and add points (with coordinates) in the same file and later save as a shapefile. Is there any way to doing that ...
0
votes
1answer
86 views

How to configure web map data layer that can accept csv data uploaded by user?

I made this map: http://tinyurl.com/a368268 on arcgis online. How do I get the same map but instead you can upload a new csv every time? Instead of having to first add it as data layer on arcgis ...