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

learn more… | top users | synonyms

0
votes
1answer
17 views

Lat/Long not projecting with shape file in qgis

For reference I am new (as in a few hours of messing around) to GIS. I have a shape file/accompany projection files ect: CURRENT.prj CURRENT.shx CURRENT.shp CURRENT.dbf CURRENT.sbx CURRENT.sbn I ...
0
votes
0answers
44 views

Not matching schema problems when appending a list of CSV's into an existing FGDB table

So far I have the following code for creating the FGDB table and defining fields which works just fine. But when I try to append a list of csv's to this table I always get a matching schema error. Do ...
1
vote
0answers
16 views

Black map after attempt to style by column in QGIS

I'm very new to QGIS and I'd really appreciate some guidance. I have a shapefile of NYC census tracts and 2 csv info files with tract info joined with it. I'm trying to style the individual tracts to ...
1
vote
1answer
33 views

Exporting shapefile to csv with cursor

I'm trying to export a shapefile to a csv file using a cursor. I found this quesion asked and answered here: Exporting table to XYZ ASCII file via ArcPy? However I only want to export several ...
0
votes
1answer
14 views

Leafletjs : combine location data in geoJSON/KML/GPX with other information in CSV through key field

I've been able to load CSV having lat-long co-ordinates into leaflet using this useful solution. Looking for ways to cross-link co-ordinates from a different source and data from another. Describing ...
3
votes
2answers
645 views

Join a CSV file to shapefile using gdal/ogr?

I have a shapefile with several attributes, for example YEAR, COUNTY, and AREA. I also have a CSV file with more fields that I want in the shapefile, such as POPULATION. Both the shapefile and the CSV ...
2
votes
2answers
54 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
48 views

How can I geocode CSV by postcode, using existing point data, in QGIS?

I have a very simple MapInfo workflow for geocoding a CSV file which contains UK postcodes, based on an SQL select query referring to point data for postcodes. This is simple. Using Mapinfo open 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, ...
0
votes
0answers
25 views

Extracting single area with multiple layers from two different data sources

I'm very new to GIS, but I have a relatively simple project that seems almost too easy for this forum but I have been searching for an answer and no luck. I am using ArcMap. I have a state map of ...
0
votes
0answers
113 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
1answer
700 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 ...
0
votes
2answers
656 views

QGIS 2.0 text delimited layer importing data as single row

I'm trying to import a text delimited layer using lat/lon, but the tool interprets the data as a single line. I've tried saving my csv using several different programs (Stata, python editor, text ...
0
votes
0answers
24 views

Help how to return values from multiple columns to dictionary [migrated]

can anyone help with how to call additional columns to my dict below please? The example works fine for the return of one set of values (column) but I need to return values for 2 columns that are not ...
1
vote
1answer
313 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
3answers
201 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
1answer
29 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
810 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
48 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
73 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
36 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
707 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
61 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
25 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
97 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
29 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
107 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
17 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
69 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
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 ...
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
60 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
51 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
472 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
84 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
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
47 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
152 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
431 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
428 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
195 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
109 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
83 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
43 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
38 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
96 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 ...