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

learn more… | top users | synonyms

1
vote
2answers
53 views

Extract height values from vector to CSV

I have generated a CSV file (using the MMQGIS plugin) expecting to obtain all the coordinates of a vector layer that I have created. But the output file only contains the latitude and longitude ...
0
votes
0answers
9 views

Raster to CSV with x y cell center coordinates, the original raster cell value, and values from another raster avoiding shapefile

I am looking for FOSS (maybe GDAL/OGR) solutions to a problem. I need to go from raster (200 million records) to CSV. It is easy enough to do via point but the point file breaks the allowable 2GB “...
0
votes
1answer
24 views

Create ShapeFile from CSV Using OGR and Python

I want to convert a CSV file of point coordinates to a ShapeFile using OGR and Python. The example.csv file looks like this: ID,X,Y 1,240007.000,647756.000 2,240008.000,647756.000 3,240009.000,647756....
-1
votes
1answer
32 views

Joining CSV with shape file in QGIS

I am aware that this questions has been asked but I haven't really seen a satisfactory answer. I have loaded a csv file into QGIS. It has been imported properly, with the first column as a string ...
0
votes
2answers
57 views

How do I convert XYZ coordinates to another projection system

I am trying to convert between coordinate systems in QGIS. I have a point file in NZGD49 coordinates (EPSG:27200) (referenced to the geoid) which I am trying to convert to NZGD2000 coordinates (EPSG:...
3
votes
2answers
428 views

Join and export .csv file as .shp in QGIS?

Here's what I'm trying to achieve: Load the required GIS layer (*.shp file) Load the .csv file in QGIS Perform the join based on common attributes in the two files Export the mapped .csv file as a ....
0
votes
1answer
29 views

Exporting CSV to shapefile in QGIS? [duplicate]

I have a simple CSV of {lat,lon,text} and I want to export it as a WGS84 Shapefile. How can I achieve this?
1
vote
3answers
61 views

QGIS CSV import of percentage values

I have a CSV file with four columns. The first column is text, and the succeeding columns are percentages. I have set up a csvt file with "String", "Integer", "Integer", "Integer" When I import the ...
1
vote
2answers
536 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 ...
4
votes
1answer
273 views

CartoDB data load from csv file error

I’m having some troubles importing data from a cvs file with street addresses and the logs are not providing any meaningful information. I installed CartoDB locally on Mac OSX 10.10. Following are ...
2
votes
1answer
2k views

Creating shapefile from Excel file in QGIS?

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) ...
0
votes
0answers
30 views

CSV is off only on QGIS maps? [duplicate]

I'm trying to add a CSV to QGIS but it puts the coordinates off the east African coast. I've tried switching the latitude and longitude coordinates but this is not helping at all In addition, whenever ...
2
votes
2answers
252 views

From CSV file (latitude and longitude fields) to point .shp

How i create a new point shapefile from CSV table? If i have a CSV file with a latitude and longitude fields, is there a method for to have in output a puntal shapefile?
4
votes
2answers
2k 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 ...
-3
votes
1answer
34 views

Updating CSV file in CartoDB?

How can I update a csv-file in cartoDB? When a csv-file is loaded into cartodb, it might contain errors in the data. E.g. some fields partially contain a wrong formtted date. After having cleaned ...
3
votes
2answers
45 views

Why do certain fields import as strings in QGIS?

I have imported a CSV to QGIS with lat/lon values representing points. The other fields, at least in the original CSV file, contain numeric values. > sapply(pune_hotspots, class) id ...
2
votes
3answers
55 views

QGIS add virtual field to csv layer

In QGIS 2.14.3 added a csv file as a layer. Attempt to add a virtual field like shown in the screenshot below (same result with "field_14" || ' ' || "field_10" || "field_11"): The field is created ...
1
vote
1answer
196 views

Export attribute table values to CSV

I am getting false parsing and un-necessary quotes for 3 numeric fields when exporting table to ascii (CSV). Items are all DOUBLE. "675,654","5,567,000" is the resulting export format which should be ....
1
vote
1answer
25 views

Generating Contours from csv Concentrations

I have a shp file showing locations of various wells on a site. I have linked (joined) a csv file of analytical results to this file. I am now looking for a method to generate contours based upon ...
-2
votes
1answer
52 views

Export field list to excel or csv

I've got the below script and found very useful. But I need the list of fields to be exported to excel or csv. import arcpy #Set workspace environment to geodatabase arcpy.env.workspace = "e:/temp/...
1
vote
2answers
98 views

Adding a csv layer in PyQGIS

I am trying to load a series of csv files as vectors in PyQGIS. I run this code to try to get the first one: uri='file://D:/Saved Stuff/gulags/1.40.csv?delimiter=;&yField=y&xField=x' layer = ...
0
votes
1answer
23 views

Export csv-coordinates to JSON - square brackets [closed]

I´ve got multiple point-layers that I want to join in a single JSON-file used for webmapping. The layers is to be listed in column by column like this: [55.778659,12.151137 ], [55.77272358,12....
1
vote
1answer
125 views

Add date field to imported csv file

I am using a script written by John to import a csv file and make a point feature class. My table looks like this: "timestamp_pretty","mmsi","imo","shipType","lat","long","month","week" "31/12/1969 ...
2
votes
1answer
827 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 ...
4
votes
9answers
22k views

Creating shape file from file with coordinates

How can I make a shape file of an csv file with coordinates?
3
votes
1answer
107 views

How to convert multiple csv files to shp using python and no arcpy?

At my internship, I have been asked to learn Python on the job. Its been a rough road never having coded before so please forgive me if my problem is elementary. The Lightning CSV files I am ...
0
votes
1answer
10 views

Selection Tool selects random multiple points around the one aimed for

I have a problem selecting points in ArcGis - the selection feature seems to be misbehaving, not allowing me to select point features precisely. I've imported the XY data of households as a csv file, ...
0
votes
1answer
18 views

Republic of Ireland .csv to mark out points on site. Which map/co-ordinate system to use?

I need to be able to create points in Arcmap 10.1 (or 10.4) in a geo-referenced map layer which I can then export as a .csv file and then use in my gps (GeoExplorer 6000) to mark out those points on ...
2
votes
1answer
72 views

Converting a CSV to DXF using ogr2ogr from the command line

I am trying to convert a .csv file to .dxf using ogr2org from the command line using the following command: ogr2ogr -f DXF control.dxf opua.vrt This is the .vrt file I am using: <...
1
vote
3answers
60 views

Importing CSV file to QGIS from Excel columns with formulas

I import a CSV file on Qgis. In excel I see an incription like that ¨54235¨ and in the attribute table in qgis as well as in notepad it looks like that ¨ 54 235¨ *not space but tab. The column when ...
2
votes
1answer
44 views

Attribute field name is not case-sensitive anymore after creating new layer

I joined a sqlite layer with a csv table (each attribute field name starts with a capital letter). When I create a new layer out of them ("save as", e.g. as a new sqlite layer with all data combined), ...
0
votes
1answer
30 views

Assigning/joining tabulated data to features in MapInfo?

I am not a MapInfo user, but I have been asked whether that software can assign/join tabulated data to GIS features like buildings, roads and watercourses?
3
votes
1answer
71 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom geometry(...
1
vote
2answers
2k views

Tools for exporting coordinates from LAS files to CSV?

Is there any tool available for extracting the X, Y and Z coordinates from a .las file and exporting them to a .csv or similar file?
1
vote
1answer
62 views

Importing Data with CSV

I am wondering what I would need to do in order to import a CSV file and then combined that with an existing layer. I would like to know which boxes I need to check in order to make this combine with ...
0
votes
0answers
19 views

Looking for Polygon data on NUTS2 (2013 system) in CSV or Excel?

Looking for Polygon data on NUTS2 (2013 system). Can somebody supply this in CSV or Excel? I have been searching on NUTS2 Polygon data, but unlucky so far. I have found the data but this is in ...
3
votes
3answers
3k 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
43 views

QGIS automatic fill columns from referenced csv

I have what is probably quite an easy problem, however I'm not able to figure it out by myself. I work as a field researcher doing bird inventory. I collect the data via QGIS on an android-tablet, ...
1
vote
1answer
10 views

Not able to progress past loading CSV in New Dataset dialog

We're getting some strange behavior in the connect dataset dialog, where, once we've selected a CSV file for upload, we get no button or feedback to continue the process. screenshot Anyone else ...
5
votes
2answers
2k views

How to draw lines from two points in a CSV?

I have a CSV file where one line looks like this: Duration, user, lat-start, long-start, lat-end, long-end 298, Casual,38.9101,-77.0444,38.91554,-77.03818 Each row in the CSV has two points and I ...
6
votes
6answers
1k views

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

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

Optimize CSV to QGIS workflow?

I am using statistical analysis software to pick out specific city lots within a database of around 500,000 lots. This is exploratory work and I'm mapping each test out in QGIS through an imported CSV ...
2
votes
3answers
134 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
68 views

Arcpy update cursor: stop iteration error

I have 1 csv with municipalities and their corresponding zip codes and a GDB of houses which contain address, municipality but no zip codes Objective: add the zip codes to the GDB table import csv ...
2
votes
0answers
74 views

Converting KML coordinates to Leaflet

I am trying to convert a Google Map KML file to a csv, to map the longitude and latitude points on Leaflet. But the coordinates keep mis-projecting and some end up off the land mass. The steps I have ...
2
votes
1answer
91 views

Arcpy module to read csv files and create polyline shapefiles

I am creating a module in arcpy that will loop through a folder with csv files in it. I have both of them written, and they work fine on my computer. However when I send them to anyone else they won't ...
1
vote
3answers
61 views

How do I separate .txt data into multiple columns when exporting to .CSV?

I have .txt data that is described as Lat Lon Elevation (meters) and when I export to .CSV in Excel it puts all data into 1 column. So when I import the data into QGIS it all dumps into 1 column, and ...
4
votes
3answers
74 views

Convert .csv with polygon geometry to .shp QGIS

Working on a Mac in QGI 2.12, I have a csv file with polygon geometry coordinates that I would like to save to a shapefile. It displays fine as a csv. However, when I try to use "save as," I get the ...
0
votes
0answers
16 views

Loading Data into Vector Layer Polygon

My first layer is a map. My second layer consists of points: bars with GPS coordinates (.cvs file). My third layer consists polygons, creating different area's for the bars. So, the points of the ...
0
votes
2answers
36 views

CSV won't import correctly into Arcmap 10.3

I have a spread sheet with coordinates that once I bring in to Arcmap, the attributes disappear. The points are on the map, and when you Identify each point, the data shows up, but when the attribute ...