A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
10
votes
3answers
313 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 ...
8
votes
3answers
6k views
How to convert .shp to .csv including attributes AND geometry?
I have a .shp file with 60k+ entries, all of which are polygons with corresponding attributes (acreage totals, landowner names, tax ID #s, etc.). What I ultimately need is a .csv file with all of ...
8
votes
3answers
349 views
How to best prepare CSV files for use in ArcGIS?
I wonder if there are any recomendations how to properly prepare CSV files for use in ArcGIS. I ask because I have some troubles using CSV files because ArcGIS attributes wrong field types to my ...
8
votes
1answer
133 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 ...
7
votes
8answers
10k views
In arcgis 10 how can I turn a csv file into a point shape file using lat/long data within the csv?
Greetings everyone! I have a csv file that is 133mb in size and has over 1.3 million lines of data. Each line of data has its own lat/long and I was wondering what would be the best way to display ...
7
votes
1answer
840 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 ...
7
votes
3answers
2k 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 ...
7
votes
1answer
456 views
Updating Fusion Table layers from csv files using python
I'm trying to use Python to take csv files and use them to update (or replace) tables in Fusion Tables. I found the "Python client library for Fusion Tables" on googles' site and downloaded them as ...
5
votes
3answers
3k views
How to change a CSV layer attribute value from text to number?
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
3answers
601 views
How to read Alphanumeric value when importing csv location file to ArcGIS?
So I am importing a csv file to ArcGIS and it has a bunch of alphanumeric values..
e.g. Attribute ID contains values such as 101, 101A, 101B etc ...the problem is when i am importing the csv to ...
5
votes
1answer
141 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 ...
5
votes
2answers
232 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 ...
5
votes
2answers
3k views
How to export Polygons to CSV with coordinates?
I am very new to QGIS, so please bear with me.
I have a ".shp" file, which is contains a set of boundaries for suburbs of Australia. I opened it to QGIS and I would like to export it into a CSV file ...
5
votes
2answers
289 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 ...
5
votes
2answers
832 views
Using SearchCursor to access & export values in a raster table
I am desperately trying to export the values in a raster table to a .txt file. I've seen some other folk post about this, but for some reason can't get the code to work in my case.
I have a raster, ...
5
votes
1answer
462 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 ...
5
votes
1answer
207 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 ...
5
votes
1answer
492 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):
...
4
votes
3answers
477 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 ...
4
votes
3answers
2k 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 ...
4
votes
4answers
892 views
Export list of Feature classes to CSV
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 ...
4
votes
2answers
136 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 ...
4
votes
2answers
254 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 ...
4
votes
1answer
899 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 ...
4
votes
2answers
607 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 ...
4
votes
1answer
120 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 ...
3
votes
2answers
623 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 ...
3
votes
2answers
2k 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
sourceforge
...
3
votes
1answer
86 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 ...
3
votes
2answers
697 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 ...
3
votes
1answer
71 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 ...
3
votes
2answers
110 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 ...
3
votes
1answer
1k 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 ...
3
votes
2answers
109 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 ...
3
votes
1answer
103 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 ...
2
votes
9answers
4k views
Creating shape file from file with coordinates
How can I make a shape file of an csv file with coordinates?
2
votes
2answers
84 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', ...
2
votes
2answers
419 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>
...
2
votes
1answer
630 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 ...
2
votes
1answer
88 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 ...
2
votes
1answer
59 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 ...
2
votes
2answers
216 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?
2
votes
1answer
80 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
2answers
971 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 ...
2
votes
2answers
331 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
62 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 ...
2
votes
2answers
470 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.
...
2
votes
1answer
195 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
0answers
86 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
92 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; ...
