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

learn more… | top users | synonyms

1
vote
3answers
126 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 ...
0
votes
0answers
39 views

Help with python, import update csv values to feature class fields

I am trying to update a bunch of field values from a csv file where there are existing (incorrect) values in my featureclass. After searching I came across a similar post (Help with Python Update ...
-2
votes
0answers
21 views

calculating distance between successive csv gps points using java [on hold]

here is part of code that i tried to execute but it dosent work ... the problem is in latitude2 and longitude i didnt figure out calculate distance between row and row+1 nay help please !!!! ...
0
votes
1answer
18 views

ogr2ogr Spatialite to csv very slow

I am using ogr2ogr to extract point data from a Spatialite db to a csv file:- ogr2ogr -f "CSV" commandtmp.csv dtm2.sqlite -lco GEOMETRY=AS_XYZ -progress -explodecollections the Spatialite db is 7GB ...
3
votes
1answer
641 views

How do I convert a set of latitude/longitude coordinates with timestamps to a GPX tracklog?

Converting tracks from a GPX track to a CSV table or some other format is relatively easy, but I'm looking to go the other way. I have a table of point locations logged with a handheld GPS, with ...
2
votes
0answers
39 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 ...
-1
votes
2answers
57 views

Displaying XY coordinates from csv file

I have a csv file which I created from a SQLite3 database. I want to display the points from the csv in QGis - which does not work. My coordinates are Lat/Long. They get displayed completely wrong. ...
0
votes
1answer
33 views

Import CSV to QGIS with z-values in column 4

I would like to import CSV into QGIS, but the z-values are listed in column 4. I didn't find out how I could specify that the values are not in column 3 but in column 4. Edit: Added a screenshot
5
votes
1answer
700 views

How to Convert a Line Shapefile into a CSV with Nodes and Links?

Is there a way to convert a linear shape file into a csv file of the following format: Node_1, Node_2, attribute_1, ...., attribute_x 1 2 "hello" 567845.334 I have looked at ...
1
vote
1answer
51 views

Copy Features tool run after Make XY Event Layer on CSV file fails to complete?

Using the Make XY Event Layer tool I converted a table to a layer. I am trying to convert the newly created layer to a feature class in my file geodatabase. I have been able to do this in ...
0
votes
1answer
20 views

CartoDB import defaults to string

When uploading CSV files to CartoDB through their web interface, all columns default to string as their data type, despite the CSV file containing a number of number-only columns. An example row is ...
0
votes
1answer
90 views

Cannot convert csv file into point shapefile using ArcGIS for Desktop?

I can import my large csv file into ArcGis Desktop and I can view it in Catalog and everything looks fine. When I go to 'create feature class' it does not recognize the column that I need to use for ...
0
votes
1answer
25 views

Plotting a list of towns in google maps or CartoDB

is there a way to plot a big (700) list of towns on google maps. I don't have any geographic reference, just their names in a .csv file. I've tried uploading using their help pages but it just seems ...
3
votes
3answers
85 views

QGIS won't read table columns in CSV import on Mac OS

I am trying to import a CSV file to QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can how QGIS won't read my data correctly). I can't ...
0
votes
0answers
16 views

QGIS Import WKB csv file

I have a csv with a unique field that are the coordinates of thousands of points but in WKB format. How can I import all the features into QGIS? CSV file is like this: ...
2
votes
1answer
682 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 ...
2
votes
1answer
55 views

QGIS 2.6 How to create a shapefile from an excel file?

I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shape-File). I have managed to convert it as CSV file and load it into QGIS (displays data fine) ...
2
votes
0answers
43 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 ...
7
votes
4answers
7k views

What ArcGIS 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
2answers
52 views

Load multi CSV files from local disc to Postgres

I want to load a lot of CSV files from a local disc in an already created postgres database. Which is the easiest way to do that? By using SQL or Java? I suppose that I need a loop for doing that, but ...
0
votes
0answers
50 views

Getting coordinates from random directions

This is an odd question, but was wanting to know if there was a way to get coordinates from random directions. I have about 2000 directions in a spreadsheet column. There is name and a few other ...
1
vote
4answers
401 views

How to change a CSV layer attribute value from text to number - once again?

i have read most of the related postings and answers allready ... (e.g. http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/ and How to change a CSV layer ...
1
vote
2answers
73 views

Extracting/Exporting coordinates from polygons (shape) to text?

Is there any well working way to extract the X and Y coordinates of a polygon from shapefile to some sort of text (preferably csv)? The whole process should be somehow done automated through a ...
1
vote
1answer
302 views

How to import .csv file to CartoDB using SQL?

How to import .csv file to CartoDB using SQL, the data given below : POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD 35AP7600 | 4418 | 4368 | 262053 | 467223 35AP7601 | ...
1
vote
0answers
25 views

In QGIS, how do I limit decimal places in data I imported as .CSV and joined to a shapefile? [duplicate]

I am importing a csv into QGIS 2.4 with a csvt file that specifies for percent columns Real(2.1) to limit it to 1 decimal place. It imports fine. When I join it to a shapefile, it looks fine. But when ...
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 ...
1
vote
1answer
42 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
1
vote
1answer
43 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 ...
2
votes
2answers
117 views

How to load a data table as a 'vector layer' using PyQGIS?

This might be a simple problem, but how does one load a simple two column CSV with no associated geometric data? I have given a couple go's via QgsVectorlayer[delimited text, spatialite] types - but ...
1
vote
2answers
366 views

Exporting lists of Feature classes and fields from SDE

I'm using matt wilkies' arcplus module http://gis.stackexchange.com/a/5943/16793 to export a list of feature classes within an SDE database to a text file. I've also written a tool to write field ...
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 ...
-2
votes
1answer
412 views

how to make grid cells by point data [closed]

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 ...
0
votes
1answer
134 views

Loading Multiple CSV Files into PostgreSQL Table

I am having multiple CSV files. Those CSV files are the log files created as a result of running a windows batch file. The location of these CSV files lies on the server and i want all these CSV files ...
1
vote
1answer
90 views

Displaying real-time CSV data in OpenLayers 3?

is there a good way to display real-time csv data with OpenLayers 3? ...
1
vote
1answer
59 views

How to convert total station data (coordinates) to 3D model? [closed]

i have my coordinates in .csv format and i want to convert it to a usable 3D model. How do i go about this or what software can i use to achieve this?
1
vote
0answers
35 views

Geoserver WFS 2.0 CSV Output Multiple Features/typeNames

I'm setting up an export function so that users may download data from a Geoserver WFS 2.0 service in a variety of the supported formats. The service has multiple FeatureTypes which should be ...
1
vote
2answers
35 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 ...
6
votes
3answers
3k 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 ...
1
vote
2answers
78 views

Showing csv file on map

Does OpenLayers support the uploading and rendering of CSV files? If it does, how? I used this code and it didn't help. var curLayer = new OpenLayers.Layer.Vector("layer", { protocol: new ...
1
vote
2answers
37 views

attach point grid data non-grid points

Possibly a strange one: I have a dataset with loads of fields of environmental (explanatory) data, as a regular grid of points (black dots in image), and another dataset of sampled (response) values ...
0
votes
2answers
28 views

Why won't my csv file imported as a vector layer have attribute table headers?

I have a .csv file that has unique identifiers that I'd like to join with some legislative district shapefiles in QGIS. I've done this before, and the joins all worked fine -- and technically it still ...
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 ...
1
vote
2answers
197 views

Error while importing CSV File using PyQGIS

Currently I am trying to import a CSV file using the python extension in QGIS and I have run into a problem that I can not seem to solve. I am trying to do a basic import of a CSV file from a python ...
1
vote
0answers
409 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 ...
1
vote
2answers
582 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
289 views

importing data into CartoDB [closed]

I've tried several ways of bringing my spreadsheet into CartoDB (.csv, .xls, .xlsx). However I keep getting a message like: An error ocurred when importing your data Error 99999 Unknown What ...
1
vote
4answers
712 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 ...
0
votes
1answer
45 views

csv data into an .xml Workspace Document to import into my geodatabase?

I'm looking to import data into my geodatabase from an .xml file using the import XML workspace document utility that comes from right clicking the geodatabase in ArcCatalog . Only problem is my ...
1
vote
0answers
60 views

Importing csv file in QGIS including names and description [closed]

I'm just getting to learn QGIS. I want to make a map (Google maps) where I can map all our customers from our database. Including names and even better: description, address, telephone, etc. All this ...
3
votes
2answers
143 views

How to output coordinates from a shapefile to a GMT or CSV file in QGIS?

I want to get the coordinates for a line shapefile as csv or gmt files. I click create "new layer" - "new shapefile layer" - I check the "line" box and then "OK". Then I make my shapefile. When I ...