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

learn more… | top users | synonyms

-1
votes
1answer
277 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
155 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
409 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
517 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 ...
4
votes
1answer
3k 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 ...
4
votes
4answers
1k 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 ...
9
votes
4answers
7k 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
1answer
333 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
4answers
6k 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
633 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
741 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
367 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
839 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
3k 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
1k 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
204 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
4k 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
269 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 ...
3
votes
9answers
8k views

Creating shape file from file with coordinates

How can I make a shape file of an csv file with coordinates?
1
vote
1answer
213 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
722 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 ...
6
votes
2answers
7k 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 ...
0
votes
1answer
330 views

Trying to make xml data readable for Arcgis

I am trying to convert xml data into tabular form for the process of geocoding. We have the xml file with info that we are going to run through an address locator. Do I need a script for this? Can ...
5
votes
3answers
933 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
2answers
1k 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, ...
9
votes
3answers
11k 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 ...
1
vote
1answer
2k views

How to generate shape file from Excel or CSV files? [duplicate]

Possible Duplicate: How can I convert an excel file with x, y columns to a shapefile? Probably this could be an easy question for most of the people. But I would like to know the way to ...
0
votes
1answer
63 views

Error running geotools tutorial for CSV2SHP?

Although I run this tutorial I always get following error message: Nov 22, 2011 5:10:50 PM org.geotools.referencing.factory.epsg.ThreadedPostgreSQLEpsgFactory isAvailable WARNING: ...
0
votes
1answer
192 views

GeoTool CSV to Shape Conversion Error

In the Feature Tutorial Example GeometryFactory geometryFactory = JTSFactoryFinder.getGeometryFactory(); generates error: method getGeometryFactory in class ...
7
votes
1answer
613 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 ...
2
votes
2answers
461 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 ...
8
votes
7answers
14k 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 ...