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

learn more… | top users | synonyms

3
votes
1answer
64 views

matching shape file to csv within QGIS - all strings

I am trying to link a csv to a shape file using the method as described in this tutorial: http://maps.cga.harvard.edu/qgis/wkshop/join_csv.php It seems to work fine but the problem is that the csv ...
3
votes
1answer
346 views

Cannot read CSV-file from ArcMap

when trying to import a CSV from my hardtrive to my map-document using "add Data"-dialog I get the error "Selected element could not be added to map. Generic error" (or something similar, I am using ...
3
votes
1answer
5k 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 ...
3
votes
2answers
3k views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
3
votes
2answers
185 views

gdal_grid unable to get nodata outside of original data area

I have a vector based csv file that I want to convert into a grid using gdal_grid, but I want to force null data values strictly around the area where there is data. I can get gdal_grid to work but ...
3
votes
1answer
197 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 ...
3
votes
2answers
2k 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. ...
3
votes
1answer
895 views

Converting ArcGIS topology rules file (*.rul) to *.txt, *.csv or *.xls for reviewing?

Has anyone converted ESRI's topology rules file (.rul) into another format? I built a complex topology rules set and would like to QC it in something easier to read and work with than ArcCatalog. ...
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 ...
3
votes
1answer
74 views

Exporting BNG coordinates from MapInfo (27700) without rounding

I have a TAB file in ESPG 27700 projection and MapInfo is rounding Y coordinate values upon export. It also occurs when viewing the table (although selecting the value shows its 'true' form) Upon ...
3
votes
1answer
344 views

Getting StatPlanet to work with custom shapefile and data?

I'm assigned to get StatPlanet Plus working with some 3rd-party data to display a thematic map, on a Mac. I have the custom regions and attribute data in a map.shp/dbf. And I've configured the ...
3
votes
2answers
242 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
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 ...
3
votes
0answers
84 views

Exporting Raster Layer using “Export Raster Data” vs Copy Raster

Is it possible to access the "Export Raster Data" tool in arcpy? Some background on the steps I am trying to process: I have a raster loaded into an mxd. I have converted the raster to a temporary ...
3
votes
1answer
130 views

Importing analytical data (CSV) with different data types into ArcGIS Desktop to generate concentration heat maps?

After reviewing all the possible related solutions to my problem, I could not piece together a solution to process and import multiple sets of groundwater analytical data that contains different data ...
3
votes
0answers
139 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 ...
3
votes
0answers
141 views

Joining csv file to vector layer in Processing modeler?

I am trying to join a simple csv file of values to a vector layer within Processing modeler. The match would be on an id held by both files. The csv file has no geometry. I can do this easily in ...
3
votes
0answers
265 views

Accessing existing instance of qgis from stand-alone python script

For my own data analysis pipeline, I am running a split screen setup with iPython notebooks on one side, generating variables from source data, pushing them to a csv file which qgis then reads/joins ...
2
votes
2answers
7k views

Exporting county level data in *.shp file to text (csv) file in ArcMap?

I have a shape file created as per the answer to my previous question, which includes county level means for each county in the US. How can I now export this data in a .csv file, e.g. with just the ...
2
votes
4answers
219 views

CSV points not showing up when importing them in QGIS [duplicate]

I know this question has been asked before in one form or another, but those answers didn't solve my issue. I'm using QGIS 2.14.0 and trying to upload lat/lon coordinates from a csv file. When I ...
2
votes
3answers
4k views

How to convert a txt file to shp?

I've got a txt/csv file with the utm coordinates and the hights. Now I want to upload this into qgis. This is not a problem so far. The problem is to create a shapefile out of the data with an ...
2
votes
3answers
108 views

Can QGIS merge CSV files with different colums? [closed]

I am trying to merge a month's worth of daily CSV files without using ArcGIS. Each file has ~25,000 entries so this is a high data load project. Sample data can be found here. Note that we are using ...
2
votes
2answers
1k views

Date fails in String -> Date in CartoDB

I'm trying to convert a column in CartoDB from String to Date. My dates are the following format: 2014-01-02T00:02:00 2014-01-02T08:05:00 ... I've tried to append +00:00, so they looks like: 2014-...
2
votes
2answers
434 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
1k 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
2answers
125 views

How to make a square out of two points?

I have a csv file with two x and y columns. (x,y,x,y). The coordinates represent tiles which I want to visualize in ArcMap. But I dont know how to do it. As you can see in the picture below, given ...
2
votes
2answers
2k views

Unable to get Mapbox leaflet-omnivore to load markers from .csv

I'm using the Mapbox.js API to build a really simple web map using a .csv file to place markers with tooltips. I'm trying to use the suggested leaflet-omnivore library to easily parse the csv and ...
2
votes
1answer
278 views

Exporting coordinates of shapefile into CSV using FME?

I use FME to make a series of transformations from an autocad file to a shape file (with line geometry). What I am trying to do is to also export (together with the shape file) a CSV file containing ...
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?
2
votes
1answer
1k 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
2answers
128 views

How to convert the CSV to point shape file using python

import csv,sys import osgeo.ogr, osgeo.osr #we will need some packages from osgeo import ogr from osgeo import * import osgeo.osr as osr def test(): boolValue = True canvas = qgis.utils.iface....
2
votes
1answer
209 views

QGIS Reprojecting csv point file to projected CRS

This is a problem I have been struggling with quite a bit and so far have not found a good solution, so I hope to find some help here or an eyeopener where I have gone wrong so far. Using QGIS 2.10.1 ...
2
votes
2answers
661 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 ...
2
votes
1answer
852 views

Reproject CSV file to different projecton using ogr2ogr

I have a CSV file "visivisi.csv" with two columns "x,y" which is in my country local projection. The proj4 line is +proj=tmerc +lat_0=0 +lon_0=24 +k=0.9996 +x_0=500000 +y_0=0 +ellps=GRS80 +towgs84=0,...
2
votes
1answer
97 views

Cannot import csv to dbase via Table_to_Table in ArcMap

I have a csv file with > 5 million records. When I imported it to dbase via Table_to_Table function in ArcMap, it raised ERROR(99999). As a result, only 2 million or so records were imported... How ...
2
votes
1answer
2k views

Exporting climatic tabular data stored in TIF file into CSV

I have a TIF file containing tabular climatic data, described here, which I am trying to export to spreadsheet / CSV format: http://www.helioclim.org/linke/linke_helioserve.html In summary, it is a ...
2
votes
1answer
2k views

How to auto-create a schema.ini file for a .csv?

I have been given some data in a csv file, which I need to import into my ArcSDE geodatabase. ArcGIS is having problems recognizing the field types, and is not importing some data. It is recognizing ...
2
votes
1answer
131 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
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 ...
2
votes
1answer
86 views

How to create a shapefile from xy in .csv file?

I find many difficult to create a new shapefile in a new project following those steps. I think the .csv file is correct (there are only: ID, X coord, Y coord) but when I would create the shapefile ...
2
votes
1answer
178 views

CSV handling in QGIS?

I am using QGIS 2.4.0 and sadly it seems that QGIS imported csv files are somewhat bugged. I cannot use imported csv files the same way as shapefiles. It seems that sometimes it is easier to import ...
2
votes
1answer
550 views

Null values coerced to zero (0) when exporting to csv or txt

I extracted values from several rasters, and in some cases, the value is null. However, when I export the attribute table to a csv or a txt file (from ArcMap), the null values are converted to 0. Is ...
2
votes
2answers
317 views

How to convert Point coordinates into CSV format?

The GDAL documentation describes how to convert a ShapeFile into CSV data. The layer create options (-lco parameter) allows to prepend the coordinates of Point features to the actual attributes values....
2
votes
2answers
6k views

How to add csv file in QGIS 2.0 using Delimited Text Layer Plugin?

I used to import csv files in previous versions of QGIS using the format below, but when I upgraded to QGIS 2.0 the delimited text layer plugin was changed and I can't import the file anymore. The ...
2
votes
1answer
649 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
571 views

ArcObjects table views or SQLite3 in Python?

Given a larger csv (1000+ points) with attributes, I need to do both attribute and spatial queries on the data. Would it be faster to read the points into an xy feature class, and do the spatial and ...
2
votes
1answer
63 views

csv - CRS undefined, QGIS

I wonder why some csv files when imported (with long and lat) can not set a proper CRS system and other do (CRS undefined). For example: 1) if I export my data in csv with Microsoft Excel it does not ...
2
votes
2answers
49 views

How can I handle NULL values in a color ramp? [duplicate]

I'm mapping areas in QGIS 2.12 based on average pricing, using area polygons (PostGIS) joined with a CSV data table that doesn't have values for areas that didn't have any sales. I'd like to color ...
2
votes
1answer
47 views

How to control field properties when importing csv to Arc gdb [closed]

I am writing Python code to import csv files with UK postcodes to ArcGIS file gdb. The import works fine, however, text fields in newly created table in gdb have length of 8000 characters. Is there a ...
2
votes
1answer
34 views

Open CSV with native QGIS Widget

I am writing a plugin that offers to open a CSV. I know the local path to the CSV but I don't know if it contains spatial data nor which name the X and Y could have. The best way I can think of, is ...