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

learn more… | top users | synonyms

4
votes
1answer
230 views

Convertion of multiple csv automatically to shp

I have more than two hundreds similar csv files with columns (x, y, value1, value2, objectName). I need to convert them automatically to shp files with x and y columns as the coordinates. Could you ...
4
votes
2answers
2k views

Export dojo datagrid results to csv in javascript web application

I have created a web application using the esri javascript web api. I populate a dojo datagrid with results returned from a querytask. My question is, how do I export the results to a csv file? I ...
4
votes
2answers
5k views

How to convert a point grid to a raster?

If I load the original .csv file, I then have a map of the African continent represented by 14069 data points covering it at 40x40km resolution. Each data point shows solar radiation means across the ...
4
votes
1answer
45 views

QGIS - Import CSV column names as numbers

I want to import a CSV table (no geometry) to QGIS. The column names which are numbers (e.g. 2004) are not getting imported. This is my test CSV file: Name;Eigenschaft;2004;test derName;1;21;21 ...
4
votes
1answer
48 views

Convert Transcad Matrix to CSV

Is there a way to read a TransCad Matrix file (mtx) without access to Transcad. I am trying to convert a matrix file to a csv file.
4
votes
1answer
202 views

Pulling CSV file directly from website into QGIS?

I want to be able to automatically update my csv files in a QGIS project. My organization has an online database that can easily export csv files. These csv files are constantly updated with new ...
4
votes
1answer
298 views

Use csv file as raster file and stitch them together

I'm having an issue trying to stitch together 100 32bit Tiff files (coming from thermal imagery video and extracted as 32bit Tiff). I used Hugin to mosaic the pictures extracted from the video which ...
4
votes
0answers
25 views

Perform QGIS modeler multiple raster calculations with data from external CSV

I need to perform multiple calculations on a set of rasters based on values in a CSV metadata file. I'm using the QGIS graphical modeler and can call a specific field in a CSV with the Table and ...
4
votes
1answer
210 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 ...
3
votes
4answers
8k 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
234 views

Exporting .csv file as .shp in QGIS?

I am a newbie to QGIS. Here's what I'm trying to achieve: Step 1: Load the required GIS layer (*.shp file) Step 2: Load the .csv file in QGIS Step 3: Perform the join based on common attributes ...
3
votes
2answers
4k views

How to edit Shapefile Attributes?

How might I go about exporting a polygon shapefile (e.g. CSV) so that attributes (not geometry) are editable by others, and importing it with the changed attributes (of which there are several columns ...
3
votes
2answers
3k views

Python script to export .csv tables from GDB

I am very new to Python programming and have been tasked with writing a program to export a csv file from a file geodatabase feature class. The csv should contain only certain fields and the records ...
3
votes
1answer
213 views

Ideal file format for QGIS that allows mixed geometry types?

I have a spreadsheet for an archaeological project that is hosted on Google docs. This allows multiple contributors to edit and update the table as revisions and field data comes in. The table is not ...
3
votes
1answer
150 views

Tornado Data Points: Linking 2 Points in QGIS on the Same Row

So I've got these tornado .csv files that have two latitude & longitude entries with the left-most in the table being the beginning point and the right-most being the ending point of the tornado, ...
3
votes
2answers
2k views

How to read csv with WKT geometry in Arcmap?

I have found several parcels I need on a county map viewer. However, the only option to download any of the data is found on a click context menu to "Copy selection as csv" which gives me this: ...
3
votes
2answers
241 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 ...
3
votes
2answers
4k views

Importing Lat/Long coordinates as CSV file & only displaying single point in QGIS

I am using QGIS and trying to import Lat/Long coordinates as delimited text layer. All points show up in my attribute table, however, only one point is displayed on the map? Any ideas?
3
votes
1answer
148 views

Import CSV: Is there a cap for number of row

I am trying to import several CSV files which contain more than 1,000 rows respectively. However, but only 129 records were only imported each file. Can't see any options that deal with this? I am ...
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 ...
3
votes
1answer
392 views

make a raster from dataset (csv)

I was trying to make a raster from an dataset (https://www.dropbox.com/s/jsm1x06lnzfbqty/data.csv?dl=0) code: inter1= read.table("c:/data.csv", header=TRUE) #convert to spatial points ...
3
votes
2answers
165 views

What is the best plain text format for georeferenced raster data?

I have to translate satellite images in a file in .txt format or another, such as Excel or .csv, in which there are pixel values corresponding to (longitude,latitude) couples. What is the best file ...
3
votes
2answers
1k views

Csv to Shp conversion? [duplicate]

I am working on a really big script right now where I have a csv file that I have removed rows and columns from, and edited the headers. I need to create one big shapefile for the entire csv file then ...
3
votes
1answer
93 views

Convert a pandas DataFrame to a GeoDataFrame

This seems like a simple enough question, but I can't figure out how to convert a pandas DataFrame to a GeoDataFrame for a spatial join. Here is an example of what my data looks like using df.head(): ...
3
votes
1answer
68 views

Qgis: Export only some columns of the selected objects to CSV

I have a layer with a table containing several columns. If I right click on the layer --> Save as.. --> CSV and chose to only include my selection I get a nice CSV file with all columns for the ...
3
votes
2answers
409 views

Changing precision on a column in the attribute table without losing data?

I have data in an Excel file that I want to join with a shapefile in my project. The Excel file contains values like volumes. The Excel file and the shapefile I want to join it with both contain the ...
3
votes
1answer
280 views

Join CSV using gdal/ogr

I'm trying to use gdal/ogr to join a shapefile called myshape.shp with a csv called mycsv.csv. The join field in the shape in joinshp and the join field in the csv is joincsv. I've found this command ...
3
votes
1answer
149 views

ogr2gui geojson to csv do not export coordinates

I tried to convert ogr2gui to convert geojson files to csv. The geojson file contains point data only. The resulting csv only contains attribute data, no coordinates. Is there a way to get the ...
3
votes
2answers
1k views

How to produce a CSV file from .tif file with elevation data? [duplicate]

just want to ask, I have a .tif file that contains all the elevation of a country. How can I convert that to a CSV file that contains x,y,z values where x and y are the latitude longitude respectively ...
3
votes
2answers
189 views

Deleting the “cached” field names for a large CSV file

Using ArcGIS Desktop Advanced 10.1 I have a large CSV file (36MB with about 600,000 records) that contains single addresses that I want to geocode. The file is called "SingleAddresses.csv" The file ...
3
votes
1answer
323 views

QGIS: Colour GPS track by speed

sorry íf I might ask this question the 101 time, but I didn't found anything with google or SE. I have a CSV file with WGS84 trackpoints and visualizing them with QGIS textplugin works fine. The log ...
3
votes
1answer
39 views

Raster Layer Statistics CSV Output using QGIS Graphic Modeller

I am currently working on a project where I am using historical cloud coverage from MODIS Cloud Fraction data to try and estimate future cloud coverage of any particular month. I currently have ...
3
votes
2answers
207 views

Understand QGIS errors when importing .csv file

I am trying to import a .csv file as a layer in QGIS and keep getting a number of errors that I don't understand. Is there any documentation of QGIS errors available? Or can you point me towards a ...
3
votes
2answers
54 views

Coordinate formatting for swath data - to polygon

I've got a CSV of Lidar coverage swaths in the below format. Each run or strip is tied together via run_id. I'm assuming L is for left, R is for right and M is for middle. EDIT: These are coordinates ...
3
votes
1answer
101 views

ogr2ogr postgres import: check if dataset exists

I have a PostGIS database which I update daily with ogr2ogr using CSV files. This works great. Is there a way to check whether the actual value of a column already exists in the table (e.g. ...
3
votes
1answer
62 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
3k 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
2k 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
166 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
195 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
833 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
1answer
58 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
303 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
1answer
409 views

How to get default parameter value for script tool from csv file?

I am fairly new to python scripting. I have just figured out how to read and write input parameters for a python script from a csv file. Now I am being asked to pre-populate the script tool dialog in ...
3
votes
2answers
222 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
1answer
91 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
94 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
128 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
239 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 ...