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

learn more… | top users | synonyms

1
vote
2answers
15 views

convert csv to kml or geojson, etc using ogr2ogr (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 ...
2
votes
1answer
640 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 ...
1
vote
4answers
613 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 ...
0
votes
1answer
19 views

csv data into an .xml Workspace Document to import into my geodatabase?

I'm looking to import data into my geodatabase from an .xml file using the import XML workspace document utility that comes from right clicking the geodatabase in ArcCatalog . Only problem is my ...
1
vote
0answers
35 views

Importing csv file in QGIS including names and description [closed]

I'm just getting to learn QGIS. I want to make a map (Google maps) where I can map all our customers from our database. Including names and even better: description, address, telephone, etc. All this ...
3
votes
2answers
103 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 ...
1
vote
1answer
251 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 | ...
0
votes
2answers
129 views

Error while importing CSV File using PyQGIS

Currently I am trying to import a CSV file using the python extension in QGIS and I have run into a problem that I can not seem to solve. I am trying to do a basic import of a CSV file from a python ...
2
votes
1answer
784 views

Is there a source for free CSV files with geo data and other desired fields? [closed]

I'm writing some software components that process geospatial data. The input data is a CSV with general columns (e.g. name) and geo columns (e.g. city, lat or zip). I would like to test these ...
4
votes
2answers
350 views

How do you create a CSVT on a Mac?

I am working with QGIS on a Mac, and understand the process for importing a CSV file. But I do not know how to create the CSVT file to define the CSV file's data types. Can someone please instruct me ...
2
votes
1answer
50 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 ...
1
vote
0answers
17 views

Can't get pyshp to work when converting csv to point file [closed]

I've been hammering at it for ages, but I just can't get pyshp to work. The csv file looks like this: lon,lat -122.5163113, 45.55324148 -95.1719409, 29.97979461 153.0072888, -27.45988559 etc, ...
1
vote
2answers
646 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 ...
1
vote
0answers
21 views

Columns decimalLatitude and decimalLongitud not recognized while creating a layer from a csv file in QGIS

I'm using QGIS 2.0.1 Dufour to create a layer from a csv file. When I try to define the geometry and assign the x y coordinates sources, I'd expect QGIS to recognize the decimalLongitud and ...
0
votes
0answers
46 views

convert csv file into grib2 format using wgrib2

I have used wgrib2 in terminal.And convert grib2 file into csv file to view content of grib2 file.my command is, wgrib2 CMC_naefs-geps-raw_ARAIN_SFC_0_latlon1p0x1p0_2014022012_P012_allmbrs.grb2 ...
5
votes
4answers
2k views

Exporting list of Feature Classes to CSV using ArcPy and Python?

I am successfully using the follow script import arcpy from arcpy import env import os env.workspace = ("WORKSPACE") fcList = arcpy.ListFeatureClasses() print fcList to export feature class names ...
0
votes
2answers
29 views

send csv with polygon or line in gps data

I want to send a csv with a polygon or line to show it in cartoDB map but when I try to send data to the server I don´t know the exact way to send the info. for polygon some think like this. ...
1
vote
2answers
23 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
2
votes
1answer
90 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?
0
votes
0answers
17 views

AutoCad Line generation from csv script

I have the coordinates of a start point, from that start point I captured the angles from a traverse boundary and distances to multiple other points. How can I set up a csv file that when I run in ...
2
votes
2answers
3k 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 ...
1
vote
0answers
22 views

Region partitions (shapefiles) comparison in ArcMap 10

I have 2 shapefiles, in each file the region is divided into zones. Each zone from 1st ("large") file is "almost" a union of a few zones from 2nd ("small") file. Specifically, for each union in ...
0
votes
0answers
39 views

Is there an easier way to refresh a joined CSV?

I'm working with data that gets updated sporadically. Essentially, I have a CSV which defines which postal codes belong to certain sales reps, and these postal codes might shift around. I made ...
1
vote
1answer
228 views

importing data into CartoDB

I've tried several ways of bringing my spreadsheet into CartoDB (.csv, .xls, .xlsx). However I keep getting a message like: An error ocurred when importing your data Error 99999 Unknown What ...
7
votes
3answers
11k views

How to export Polygons to CSV with coordinates?

I am very new to QGIS, so please bear with me. I have a ".shp" file, which is contains a set of boundaries for suburbs of Australia. I opened it to QGIS and I would like to export it into a CSV file ...
1
vote
3answers
218 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 ...
2
votes
2answers
56 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 ...
1
vote
1answer
45 views

How to import geometry data from csv file to postgres?

I have geometry file in *.xls file, but when I save in *.csv it say "some feature in your workbook might be lost if you save it as CSV (Comma delimited)" however I keep that file anyway and when I ...
1
vote
1answer
25 views

How to import `numeric` fields from csv to dbf in ArcGIS?

I am trying to import a CSV into a DBF using ArcCatalog (10.1). In the field map, pictured below, I can only set an ID field to Long, Text, Double, etc. But there is no Numeric type as in DBF and ...
0
votes
1answer
49 views

Reading .csv file in QGIS [duplicate]

I am trying to join a .csv file with a .shp file in QGIS but QGIS is unable to read the data in my .csv file as it indicated that the variables are string of length and precision 0. As a result, I am ...
3
votes
1answer
50 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 ...
0
votes
0answers
11 views

ArcGis Join Data CSV Problem [duplicate]

I have been trying to use ArcGis Desktop and ran into some problems while joining the data from a csv file with the shp file. I can see the attributes that have been added in the attribute table but ...
2
votes
2answers
132 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
1answer
35 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 ...
3
votes
1answer
141 views

ArcGIS 10. Convert dbf to csv or similar in ArcPy without cursors

I have many dbf's created by the Spatial Analyst Sample tool. I would like to convert those dbf's into csv's or space delimited (or any text for that matter). I can't seem to find the ArcPy equivalent ...
1
vote
1answer
34 views

Operations between shape layer and csv layer

I've got a question for you! I have a .shp layer containing point geometry with xy coordinates in the attributes (left) and a .csv layer containing a square Origin/Destination matrix(right): I ...
2
votes
1answer
73 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 ...
0
votes
1answer
15 views

What is a purpose of parameter 'separater' in mapnik csv plugin datasource?

What is the purpose of the parameter 'separater' in the Mapnik CSV plugin DataSource Example of the code: parameters p; p["type"]="csv"; p["inline"]=quotedStr; ...
3
votes
1answer
49 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 ...
0
votes
0answers
14 views

Pass Data as a String Using Mapnik CVS Plugin

I am new in mapnik and c++ I need Help. I have a code written in C++ that read a data using postGis .The Sample Code is given Below: parameters p; p["type"]="postgis"; ...
2
votes
1answer
79 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 ...
8
votes
6answers
17k views

ERROR 000212: Cannot create XY event source Failed to execute (MakeXYEventLayer)?

I have a csv file that is 133mb in size and has over 1.3 million lines of data. Each line of data has its own lat/long and I was wondering what would be the best way to display those points based off ...
3
votes
1answer
82 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 ...
2
votes
1answer
719 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 ...
5
votes
2answers
123 views

Efficient way to use a CSV to Define a Feature Class

I was provided an Excel Spreadsheet which had the definitions of fields for a feature class. There were several worksheets in the file, each containing field definitions for different feature ...
2
votes
2answers
66 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?
0
votes
1answer
105 views

Converting JSON to GeoJSON or CSV?

How do you convert a JSON file to a GeoJSON file or csv. I have a JSON file with lat lon information, but how can I can convert this file to GeoJSON or csv. I have found some online tools to convert ...
2
votes
2answers
57 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
1answer
27 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 ...
10
votes
5answers
11k views

Changing CSV layer attribute value from text to number in QGIS?

I read in a CSV file for linking to a .shp file. All the variables that are just numbers came in as text. How do I change the text variables to numeric in QGIS?