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

learn more… | top users | synonyms

4
votes
1answer
228 views

Use csv file as raster file and stitch them together

I'm having an issue trying to stitch together 100 32bit Tiff files (coming from thermal imagery video and extracted as 32bit Tiff). I used Hugin to mosaic the pictures extracted from the video which ...
1
vote
1answer
113 views

QGIS CSV file sorts low numbers as high

So I have numbers that range from 5 to above 50, and when I sort these from least to greatest, the numbers less than 10 are treated as higher than anything else. It also does the same when I try to ...
6
votes
3answers
2k views

What is XYZ format in QGIS?

Basic question, but I have been asked to export data to an XYZ format. Is this the same as CSV files. I am using QGIS 1.8.0. So i am presuming i select the data I want to export, right click its ...
9
votes
3answers
3k views

Preparing CSV files for use in ArcGIS for Desktop?

I wonder if there are any recomendations how to properly prepare CSV files for use in ArcGIS for Desktop. I ask because I have some troubles using CSV files because ArcGIS attributes wrong field types ...
9
votes
1answer
363 views

Why are some columns not recognized as numeric even though I have a CSVT?

I have problems importing a .csv file. Some Values of the file are not supposed to be formated in text style, but in number style, thus i created an additional .csvt file like explained here. Both ...
1
vote
2answers
589 views

What's the correct csv format for MMQGIS Join by attribute?

When trying to join attributes from CSV-file with MMQGIS, I currently get the error message: File inaccessible or in unrecognized CSV format /Netzplanung/Truck_park/trkbuspk15_2.csv Tried with ...
8
votes
1answer
5k views

Create a csv with geometry as WKT in QGIS (and choosing the field delimiter)

Is there a way to choose the field delimiter when exporting to CSV with geometry as wkt in QGIS? I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB ...
3
votes
1answer
136 views

Import CSV: Is there a cap for number of row

I am trying to import several CSV files which contain more than 1,000 rows respectively. However, but only 129 records were only imported each file. Can't see any options that deal with this? I am ...
2
votes
1answer
718 views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
10
votes
2answers
5k views

How to export only certain columns to a CSV file in ArcGIS?

I've written a python script using arcpy which outputs a polygon feature class into a File Geodatabase. I have added a function to export the attributes to a separate CSV file. I am using the code ...
1
vote
3answers
330 views

Can one edit xls, and convert xls to csv - with a portable python or Perl module? [closed]

I am on a network and computer where nothing can be installed. On this computer i run portable apps through a USB, however I need also to to edit xls, and save as csv. Since i cannot install anything ...
1
vote
1answer
102 views

Transform csv-coordinates into area

I'm working with an inventory of a species in Southern Sweden. I have recorded my findings (together with coordinates, name of the species and year of finding) and created a CSV-file with i have ...
5
votes
2answers
565 views

OGR to read from oracle, and then write a CSV

I need to read an Oracle (not spatial) table with OGR. I have no problem with ogrinfo. I use this command: ogrinfo -ro OCI:user/password -sql "select * from HR.EMPLOYEES" I have this kind of ...
1
vote
0answers
487 views

Why is my .csvt not recognized? [closed]

I am trying to associate a .csvt file with a .csv file, so QGIS doesn't insist on calling all the fields text strings (thereby preventing the use of graduated symbols). I used the syntax described by ...
3
votes
2answers
179 views

How can I create a portable script for coordinate conversions to run from USB?

I would like to be able to convert Lat long values in wgs84 to the swedish RT90, the values are in CSV files under headings X and Y. I would like to have this portable, an eg runned in a script in ...
4
votes
2answers
346 views

How do you create a CSVT on a Mac?

I am working with QGIS on a Mac, and understand the process for importing a CSV file. But I do not know how to create the CSVT file to define the CSV file's data types. Can someone please instruct me ...
2
votes
1answer
782 views

Is there a source for free CSV files with geo data and other desired fields? [closed]

I'm writing some software components that process geospatial data. The input data is a CSV with general columns (e.g. name) and geo columns (e.g. city, lat or zip). I would like to test these ...
5
votes
1answer
1k views

OGR Shapefile to CSV: Using Python to get WKT for multipart Polys.

Using ogr2ogr and python, I'm running into a wall with trying to create a csv with WKTs for a shapefile that contains multipart polygons. Currently this is this code I'm using (found it on interweb): ...
3
votes
2answers
1k views

From text data create a FeatureClass with table with python

I'm searching how the output of one program (text file with some writings, but also with data as numbers, dates, times, coordinates, all separated with commas) can be transformed to a Feature Dataset. ...
7
votes
1answer
4k views

Using the python shape library: pyshp - how to convert .csv file to .shp

I am trying to understand how I can use the csv module in python to open a csv file in the same folder as the python script, and then create a shapefile using the shapefile module pyshp. The csv file ...
3
votes
2answers
2k views

How to edit Shapefile Attributes?

How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...
4
votes
1answer
306 views

How can I reload a csv-file within qgis

I use Qgis to illustrate the results from my Matlab simulation. Matlab produces a csv-file which is connected to a shapefile within Qgis. At the moment I have to close and reopen Qgis to show the new ...
1
vote
2answers
171 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 ...
2
votes
1answer
120 views

spatial data filtering without GIS?

I have access to a database here (description of the columns are also available) containing spatial data in text format and with WGS84-EPSG:4326 coordinates. I would like to only select data in my ...
1
vote
1answer
356 views

Adding CSV upload browse button to Ext.Action

I am trying to create a CSV File upload on GeoExt Map App. I need to place the upload function within the Ext.Action, so that I can add it to the toolbar of the GeoExt Panel. I am trying to implement ...
2
votes
1answer
1k views

encoding problem with QGIS 1.8 and CSV import

I have following problem with QGIS 1.8. Lisboa (standalone installer, Win 7 Pro 64bit) - I import CSV - text in CP1250 separated with ";" and using "," as decimal separator. I correctly set the ...
0
votes
0answers
23 views

Desktop tool to batch convert Shapefils to CSV with polygon outline coordinates [duplicate]

Possible Duplicate: How to convert .shp to .csv including attributes AND geometry? Is there a desktop tool that would allow me to take dozens of large (300MB) shapefiles and convert them ...
2
votes
1answer
402 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 ...
3
votes
2answers
3k views

How to convert a point grid to a raster?

If I load the original .csv file, I then have a map of the African continent represented by 14069 data points covering it at 40x40km resolution. Each data point shows solar radiation means across the ...
-1
votes
1answer
378 views

how to make grid cells by point data

I have a csv data. the X, and Y columns show bottom left corner of each grid. It is supposed to show as grid square, but it shows points. what is the problem? and is there any way I can make cell ...
2
votes
0answers
184 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 ...
10
votes
3answers
460 views

How can I handle tables with 256+ variables?

I'm working with census data and downloaded several CSV files, each with with 600ish columns/variables. I'd like to store them all in a query-able database, but everything I've tried so far (MS ...
1
vote
0answers
635 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 ...
5
votes
1answer
4k views

Import polylines and polygons into QGIS from CSV

I'm assuming this is a simple question, though my efforts have not yet found the answer! I want to import a large number of polylines and/ or polygons into one one or more QGIS layers in order to ...
5
votes
4answers
2k views

Exporting list of Feature Classes to CSV using ArcPy and Python?

I am successfully using the follow script import arcpy from arcpy import env import os env.workspace = ("WORKSPACE") fcList = arcpy.ListFeatureClasses() print fcList to export feature class names ...
10
votes
5answers
11k views

Changing CSV layer attribute value from text to number in QGIS?

I read in a CSV file for linking to a .shp file. All the variables that are just numbers came in as text. How do I change the text variables to numeric in QGIS?
5
votes
1answer
396 views

How do I avoid text field truncation when saving a table join?

Using QGIS I've joined tabular text data (all in fields of less than 255 characters) to a shapefile via a CSV file. All looks good in the joined table but when I save to a new shapefile to make the ...
6
votes
4answers
10k views

How to export highlighted features from attribute table to an excel file?

When i selected some portion of the map in QGIS, in the attribute table the selected features gets highlighted... How to export the highlighted features from attribute table to an excel file ...
2
votes
2answers
837 views

Unable to create shapefile using shapefile.py

I am trying to create shapefile from csv data using shapefile.py but i am constantly getting this error, Traceback (most recent call last): File "createShp_Davis.py", line 31, in <module> ...
-4
votes
1answer
1k views

How to script a csv to file geodatabase tool?

I have many separate field data files in CSV format and I wish to automatically convert these CSV files into a geodatabase to be able to load them into a schema I created for them in my new ArcSDE ...
4
votes
2answers
422 views

Where can I find GeoJSON resources files?

I'm looking for demographic information and various things, and most of the time data are available as CSV (my application use geoJSON format). Shall I encode the CSV to geoJSON or is there a ...
5
votes
3answers
1k views

How to identify feature vertices that are part of a donut hole in ArcGIS 10?

I´m exporting the coordinates of polygon vertices to a CSV-File using the "Feature Vertices to Points" and then the "Export feature attributes to ASCII"-tools. Some of these polygons have holes ...
3
votes
3answers
5k views

csv to kml converter

Does anyone know a workable and stable program which converts csv extension files to kml? There are many tools available online but none of them worked for me. I tried many including kmlcsv ...
3
votes
2answers
2k views

How to convert GRIB-1 to GRIB-2?

I need to get data for my database from some GRIB files (binary), I downloaded wgrib2, which can export GRIB-2 files to .csv and csv is very suitable for me, but some GRIB files are GRIB-1, so I used ...
1
vote
1answer
250 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 ...
7
votes
3answers
6k views

What ArcGIS 10 geoprocessing tools support exporting tabular data to CSV?

I have found that most if not all geoprocessing tools that allow tabular output are limited to geodatabase tables and DBF files for supported output formats. Are there any that also support CSV ...
1
vote
0answers
339 views

Placemark that pulls information off an excel sheet row and display's the data in the description part of the Placemark

I am trying to find out if a certain function is available to link an excel sheet with a kmz. What i need to happen is have a Placemark that pulls information off an excel sheet row and display's the ...
4
votes
9answers
11k views

Creating shape file from file with coordinates

How can I make a shape file of an csv file with coordinates?
1
vote
1answer
252 views

Error 000204 using “Export Feature Attribute to ASCII” Tool on ArcGIS Server 10

I´m trying to export feature attributes to a CSV-File (on ArcGIS Server) to use them in other applications (using the "Export Feature Attribute to ASCII" Tool). While the tool is working ok in a ...
5
votes
2answers
905 views

Loading data onto PostGIS using KML files with attibute data

So, I have a kml file which contains 317 data points (317 polygons and the respective 317 names). The kml file also contains attribute data which pops up in a bubble on Google earth with about 12 ...