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

learn more… | top users | synonyms

2
votes
1answer
126 views

How to use a csv file to add values to a value map?

I'm trying to populate a value map in the edit widget with some values from a csv file. Could anyone let me know what format the csv file has to be in? At the moment I have just a list of ...
2
votes
2answers
1k views

Line Layer from Point to Point CSV file using QGIS?

My question is probably a basic QGIS question but I could not find something that would work for me. I have a file of the following format: where each from/to is a point that is already inserted ...
2
votes
2answers
93 views

What is the recommended format to import tables from Excel to arc map with more than 65 536 rows? CSV?

What is the recommended format to import tables from Excel to Arc map with more than 65 536 rows? CSV?Txt?
2
votes
1answer
110 views

How do I rename rasters in an mxd by using my csv?

I have the following data in a csv: RasterName First name Raster 1 Aaron Raster 1 Paul Raster 2 Bryan Raster 3 Cranston Raster 3 Vince I have added these ...
2
votes
1answer
547 views

How to convert shp to csv

I am trying to convert my shape files to csv through a batch processing in Java using Geotools. The problem is I have more than 500 shape files (point features). The code is working fine for a small ...
2
votes
2answers
244 views

How to draw a square from 2 coordinates?

I have a CSV file with the following output id, x min, y min, x max, y max, value 1 , 0 , 0 , 100 , 100 , 5 2 , 0, , 100 , 100 , 200 , 10 3 , 100 , 100 , 200 , 200 , 15 4 , 100 , 0 ...
2
votes
2answers
1k views

How to keep initial zeros when importing csv to dbase in ArcMap

I have a CSV table with millions of records. When I imported in into dbase via ArcMap, those inital zeros in a certain field just went away. E.g. one field show be "01001", but it displayed as "1001". ...
2
votes
1answer
356 views

Accented characters in csv file appear as '?' when importing to QGIS

The tabular data (.csv file) and the data in the attributes table of the vector (.shp file) I am trying to join includes accented characters - they are place names in Pamana. For example 'Río Abajo' ...
2
votes
1answer
699 views

QGIS: CSV point grid to polygon - not raster

I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to ...
2
votes
1answer
89 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
2
votes
4answers
1k 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 ...
2
votes
1answer
222 views

How to add point coordinates to a non geo-referenced csv file?

I have a csv file with information but not georeferenced. I'd like to load it in QGIS and add points (with coordinates) in the same file and later save as a shapefile. Is there any way to doing that ...
2
votes
1answer
666 views

How to create a point table from a remote csv file?

The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
2
votes
2answers
809 views

Convert CSV files into OSM with FME

I have a database which i've exported as individual csv files for each table. Below are some of the attributes which exist from two of the csv files: wayPointID linkID order x y z length ...
2
votes
1answer
60 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 ...
2
votes
1answer
25 views

Error message in QGIS using Timemanager

I am using QGIS version 2.14.0 (Essen) and have dowloaded the latest version of the Time Manager plugin in order to do some spatial-temporal analysis. I have imported a csv file into QGIS and made a ...
2
votes
1answer
201 views

NMEA to CSV with timestamp using gpsbabel

I tried to convert a file in NMEA to csv using gpsbabel, $ gpsbabel -i nmea -f GPS_20160204_092027.log -o csv -F GPS_20160204_092027.csv I get a csv file with only latitude and longitude, but was ...
2
votes
1answer
66 views

ArcPy Python Script To Update Shapefile Records From CSVs

I am fairly new to python scripting. Most of the basics I have down however still learning. I am trying to create a python script to update a shapefile with information from two separate CSV files. ...
2
votes
1answer
85 views

How to create polygon from bounding box coordinates (PostGIS/cartoDB)

I have data to import to cartoDB in CSV format in which there is a bounding box column holding two lat/long coordinates representing the corners of a bounding box, like ...
2
votes
1answer
65 views

CSV to Layer from a Delimited Text File in QGIS

enter image description hereI am importing a CSV file into QGIS using the official instructions on their page: http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html. For some reason, ...
2
votes
1answer
729 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 ...
2
votes
1answer
101 views

Conversion of CSV file in MyGeoData Converter - XY columns not recognized

Recently I have tried to import various CSV files with XY coordinates to MyGeoData Converter. In some cases I got a message: Selected data does not have a spatial part! For example, this file ...
2
votes
1answer
299 views

Plotting Postal Codes from .csv Files in QGIS

I have Canadian postal code data that I would like to plot. This data is currently stored in a simple .csv file. At the moment the only other data I have is FSA data from Statistics Canada. Is ...
2
votes
2answers
132 views

csv to shp missing file

I transform a csv file into a shape file using the following script import shapefile as shp import csv import tkinter.filedialog import urllib.request import os a = ...
2
votes
2answers
136 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
2
votes
1answer
383 views

gdal_grid with CSV file and VRT “No point geometry found on layer”

Given the following .vrt file which I manually created: <OGRVRTDataSource> <OGRVRTLayer name="DGM5_BE"> <SrcDataSource>DGM5_BE.txt</SrcDataSource> ...
2
votes
2answers
241 views

Import CSV file into Postgis DB with Location-field formatting?

I am working to import CSV into table in my Postgis Database. First, I created the table Create Table test ( name varchar, created_date Date, location double precision ); When I excuted the ...
2
votes
0answers
56 views

Why does QGIS Browser 2.12.1 keep freezing/crashing when I try to view a csv data table?

I've just downloaded QGIS Lyon 2.12.1. The desktop application works great but the browser crashes whenever I try to view a csv data table. I've gotten it to work once out of ten tries. I click on ...
2
votes
1answer
149 views

FME Proccess to merge two CSV files not working

I am trying to merge two datasets of golfcourse data with almost similar information. my end goal is to have all the data into one csv file that have merged information from both csv files. I have ...
2
votes
0answers
88 views

How to show csv data point in Arcgis

I have sought and tried many tutorials and documents without success. I have arcgis desktop 10.2.2 installed. I have added a US map as a layer. Then I do the following hoping to display all (2000+) ...
2
votes
1answer
75 views

QGIS TimeManager with multiple features at one time?

Since the data I have to deal with is really large, it is not practical to separate every feature into one line in the CSV file. Is there any way to animate them as a whole layer? I have ...
2
votes
1answer
443 views

Importing CSV file with csvt data in QGIS (2.8) will not assign type “date” to fields

I have a dataset (in CSV) and am trying to add several fields with date information, so I can filter points based on this data and generate maps (in QGIS 2.8) which will form a chronological series. ...
2
votes
0answers
49 views

Standard for geospatial CSV with either lat/lon or region encoding

I'm tasked with finding a standard for data providers to publish data that is linked to either points (lat/lons), postcodes, or local government areas (Australian term for councils). The data will be ...
2
votes
0answers
26 views

Black map after attempt to style by column in QGIS [closed]

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 ...
2
votes
0answers
71 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 ...
2
votes
1answer
38 views

Polygon from CSV ∂x-∂y values

I am trying to make a map of a property fenceline based on a survey which gives precise bearings and distances between landmarks. Following recommendations in this thread, I used a CSV file to turn ...
2
votes
0answers
373 views

QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working

Just upgraded to QGIS 2.2 and it looks like saving a layer as CSV doesn't support GEOMETRY=AS_WKT anymore. The new Layer Options portion of the save dialog is cool but it looks like GEOMETRY and ...
2
votes
0answers
249 views

ArcGIS 10.0 - problem with exporting a huge geodatabase table to CSV or DBF

ArcGIS 10.0 SP5 @ Windows XP Intel® Core™2 Quad Processor Q9650 (12M Cache, 3.00 GHz, 1333 MHz FSB) 3 GB RAM In a file geodatabase I have a point feature class with a huge amount of records (over ...
2
votes
1answer
120 views

Is there no editmode for CSV files? [duplicate]

I load a delimited text layer and it get's visuialized. Unfortunatly I don't know why I can't switch to edit mode. I already worked with similar .CSV files in edit mode before, under the same setup :( ...
2
votes
0answers
583 views

QGIS 2.0: Automating tasks, text files and shapefiles

Wondering if it's possible to automate some repetitive tasks in QGIS (2.0). This is my general workflow for importing some xyz type text files from another software package which export (not overly ...
2
votes
0answers
125 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
2
votes
0answers
378 views

Best method to convert CSV file of lat/lon and depth data to bathymetry polygon?

I'm trying to create bathymetry polygons based on lat/long and depth data. I have tried several methods and the resulting polygons are clunky. Make XY Event Layer-->Copy Features--> Project--> ...
2
votes
0answers
248 views

Plot csv data on a map

My boundaries shape file has the following attributes; CODE, PROVINCE, AREA, SHAPE_LENG and SHAPE_AREA (note that there are no geo- coordinates). My data on the csv file has the following fields; ...
2
votes
0answers
216 views

CSV rows to Polyline with OGR

I'm not sure if I can complete this operation in one step - but someone might be able to help me. My input file is a csv file with PointID, x, y, z and LineID columns. I'm looking to combine all ...
1
vote
2answers
46k views

Export list of values into csv or txt file

I would like to know how to export in Arcgis a list of values calculated in python script into one of the following data formats: csv, txt, xls, dbase or other. I would also like to know how to create ...
1
vote
5answers
2k 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
3answers
1k 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 ...
1
vote
1answer
88 views

Getting around current database field limitations?

I have a need to store over 350 fields in a table and have this information readily available to display spatially. The problem is that access only allows for 255 fields. So the feature class that I ...
1
vote
2answers
120 views

Why can't I save csv as a shapefile

I am trying to follow the instructions given here, Tutorial: Making Heatmaps using QGIS and GRASS , to build a heat map with my own data. I taken the first step and imported a csv data table into the ...
1
vote
3answers
109 views

Windows software to convert GeoJSON (> 6Mb) to Excel/CSV?

I am trying to convert OpenStreetmap data GeoJSON to Excel (or .csv files). Few online converters are there. However, when the file is big (example: 6Mb Geojson), the browser is becoming ...