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

learn more… | top users | synonyms

2
votes
1answer
223 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 ...
2
votes
1answer
72 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 ...
2
votes
1answer
194 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 ...
2
votes
1answer
441 views

How to create a point table from a remote csv file?

The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
2
votes
2answers
643 views

Convert CSV files into OSM with FME

I have a database which i've exported as individual csv files for each table. Below are some of the attributes which exist from two of the csv files: wayPointID linkID order x y z length ...
2
votes
1answer
59 views

Conversion of CSV file in MyGeoData Converter - XY columns not recognized

Recently I have tried to import various CSV files with XY coordinates to MyGeoData Converter. In some cases I got a message: Selected data does not have a spatial part! For example, this file ...
2
votes
1answer
129 views

Plotting Postal Codes from .csv Files in QGIS

I have Canadian postal code data that I would like to plot. This data is currently stored in a simple .csv file. At the moment the only other data I have is FSA data from Statistics Canada. Is ...
2
votes
2answers
76 views

csv to shp missing file

I transform a csv file into a shape file using the following script import shapefile as shp import csv import tkinter.filedialog import urllib.request import os a = ...
2
votes
2answers
86 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
2
votes
1answer
114 views

Cannot read CSV-file from ArcMap

when trying to import a CSV from my hardtrive to my map-document using "add Data"-dialog I get the error "Selected element could not be added to map. Generic error" (or something similar, I am using ...
2
votes
1answer
212 views

gdal_grid with CSV file and VRT “No point geometry found on layer”

Given the following .vrt file which I manually created: <OGRVRTDataSource> <OGRVRTLayer name="DGM5_BE"> <SrcDataSource>DGM5_BE.txt</SrcDataSource> ...
2
votes
2answers
169 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 ...
2
votes
2answers
895 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 ...
2
votes
0answers
47 views

Converting csv that it can be displayed

I have this Excel sheet here (far to right side there is a box where the file can be downloaded, the very first one). http://www.bafg.de/GRDC/EN/02_srvcs/21_tmsrs/211_ctlgs/catalogues_node.html Im ...
2
votes
0answers
45 views

Is there a QGIS alternative for ArcMap's Append (to Shapefile) Data management tool?

Is there something out there for QGIS that is similar to the Append Tool in ArcMap? Reason I am looking: I am currently working on a storm drainage project that involves GPSing Storm drain lids. My ...
2
votes
0answers
63 views

Via PyQgis how to refresh a modified CSV layer without having to reopen the file? [duplicate]

UPDATED: With an CSV layer Qgis workspace [loaded as a delimited text layer], an external algorithm is ran; outputting (writing) new values to certain rows in the layers source CSV file. The writing ...
2
votes
1answer
28 views

Polygon from CSV ∂x-∂y values

I am trying to make a map of a property fenceline based on a survey which gives precise bearings and distances between landmarks. Following recommendations in this thread, I used a CSV file to turn ...
2
votes
0answers
292 views

How to convert shp to csv

I am trying to convert my shape files to csv through a batch processing in Java using Geotools. The problem is I have more than 500 shape files (point features). The code is working fine for a small ...
2
votes
0answers
169 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 ...
2
votes
0answers
100 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 ...
2
votes
1answer
99 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 :( ...
2
votes
0answers
350 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 ...
2
votes
0answers
109 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 ...
2
votes
0answers
537 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
0answers
277 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--> ...
2
votes
0answers
211 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; ...
2
votes
0answers
193 views

CSV rows to Polyline with OGR

I'm not sure if I can complete this operation in one step - but someone might be able to help me. My input file is a csv file with PointID, x, y, z and LineID columns. I'm looking to combine all ...
2
votes
1answer
696 views

How do you format an OGR VRT file to best convert a CSV to KML?

I am attempting to get a nice KML for simple review of POI/geocoding from a CSV. I a using ogr2ogr and a vrt. You can see the vet file below, with two attempts to get this right. Basically, the issue ...
1
vote
2answers
17k 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
2answers
632 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
2answers
98 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 ...
1
vote
1answer
476 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 ...
1
vote
2answers
88 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 ...
1
vote
2answers
728 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
2answers
37 views

Including js file in openlayer.js file

I have this code for showing markers on map: function addUserLayerCSV(){ layer1 = new OpenLayers.Layer.Vector("CSV", { projection: epsg6316, strategies: [new ...
1
vote
3answers
187 views

convert csv to kml or geojson, etc using ogr2ogr or equivalent command line tools (use “latitude” and “longitude” attributes for coordinates)

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csv The csv has "latitude" and "longitude" columns. The attributes are all loaded ...
1
vote
2answers
111 views

csv to shp python and formating a row

I´m doing a script to convert csv to shp, but I want to format one of the columns. It´s a string then I´d like to format like this a[8:10]+' / '+a[11:16]+' UTC' being a the value in the column. ...
1
vote
1answer
46 views

How to add neighborhood names from shp to csv data points QGIS

I'd like to add the neighborhoods listed in a shp file to the data points in a csv Link to shp Link to csv Here are the data points overlaid on the shapefile map of the neighborhoods. I'd like ...
1
vote
2answers
40 views

Adding Rasters as Columns in Shapefile using ArcGIS for Desktop? [closed]

I am currently working on a research project in a lab, and I am fairly familiar with ArcGIS (I'm only in high school and have done some previous work using ArcGIS). I was asked to add 3 columns onto a ...
1
vote
1answer
63 views

Why does QGIS add decimals when a csv is saved as a shapefile?

When I save a csv as shapefile the fields with decimals are saved adding decimals, then the new table in some case has new values. Old Table (CSV) ALTURA ELI ALTURA ORT 1.94 39.6 -11.19 ...
1
vote
1answer
41 views

Writing list of feature classes with fields to one csv file per feature class?

I have a database with multiple feature classes. Now I extracted a list of feature classes and a list of fields. I figured out how to write the list of feature classes and the corresponding fields to ...
1
vote
2answers
787 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 ...
1
vote
2answers
79 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 ...
1
vote
1answer
107 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
57 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 ...
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 ...
1
vote
2answers
182 views

How to queue FME output on the same workspace?

I have an .csv coordinate file with the following header num xc yc xmin ymin xmax ymax I want to tranform the x/y coordinates on each line of this file to lat / long ...
1
vote
1answer
285 views

Exporting data from a WFS service to csv file using qgis

I have a service that contains a list of points with some meta data and I would like to export this to a csv file. I remember doing this some months ago and it worked well, but now I can't find the ...
1
vote
1answer
36 views

Rewriting csv file for QGIS

So, I have a .csv file. Here an example how the a row from the original .csv looks like: "AREA",44.37,-00.83,"5","1","8","E","E",,,"KKI","KKO" Some lines have missing latitudes and longitudes, ...
1
vote
2answers
34 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...