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

learn more… | top users | synonyms

1
vote
2answers
16 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 ...
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
105 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 ...
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
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
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. ...
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?
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 ...
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 ...
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 ...
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
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
142 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 ...
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; ...
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 ...
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 ...
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
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
107 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
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 ...
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 = ...
1
vote
0answers
24 views

Joined field not recognized as number in QGIS 2.4 [duplicate]

I have a weird problem. I've loaded in QGIS a point shapefile and a CSV table. Then I performed a join between the 2 layers and all works fine. But then the joined columns (made of integers or real ...
2
votes
2answers
66 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 ...
4
votes
2answers
173 views

How to save .shp to .csv so that the Name is in the first “column” of the .csv?

I am trying to convert a point shapefile to .csv with locations in QGIS. The problem I am having with the conversion is mainly that, in the resulting .csv file I would like to have the Name and then ...
1
vote
0answers
63 views

Vector points from csv file wrong location in QGIS

I am using QGIS 1.8 (I know old version), and uploaded a csv file with coordinates. The underlying basemap is from Google, using the Open layers plugin. This basemap uses WGS84-epsg3857, and my vector ...
1
vote
1answer
41 views

Handling KML/CSV with geopandas - DriverError: unsupported driver: u'CSV'

I'm trying to import a dataset of UK postcode districts UK postcode districts from Google Fusion tables into geopandas with the aim of splicing it to a dataset of house prices. The problem is that ...
1
vote
0answers
53 views

Error on 'Extract raster values to CSV' in batch process in QGIS

The Extract values (csv) contained a bug in the script. The below link shows how to correct the bug. Error on 'Extract raster values (CSV)' - Error executing algorithm 1 'Dataset' ...
1
vote
1answer
70 views

Error on 'Extract raster values (CSV)' - Error executing algorithm 1 'Dataset' object has no attribute 'mapToPixel' See log for more details

I would like to extract raster values at some locations (point shapefile) in 'csv' format. I use 'Point Sampling Tool' and it works well for a raster file. However, I have hundred of raster files ...
1
vote
2answers
75 views

Export long lat from polyline as csv file in QGIS

I want to draw a line in QGIS and then, export the long-lat of each point into a Comma Separated Value (csv) file. I tried doing this by creating a new shapefile layer and then using the Add Feature ...
0
votes
1answer
61 views

OpenStreetView or points from CSV but not both showing?

I'm using QGIS on Mac (most recent version) and am trying to map coordinates from a csv file. When I import the file normally without having any base map, the coordinates how up distributed like I ...
3
votes
1answer
118 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 ...
2
votes
1answer
65 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 ...
2
votes
1answer
67 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
0answers
198 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 ...
0
votes
0answers
21 views

What is the workflow to add more records from CSV files to a point feature in Oracle Spatial?

We have some GPS data in CSVs to export to existing features in database schema. The CSVs have the same attributes columns, as that of the tables in ORACLE (missing objectIDs, geometry and globalID). ...
1
vote
0answers
49 views

Categorized style hiding map

I am having an issue with the style properties of my map. I imported the US Zip Code Tabulation Area map from a government website, and in a separate excel file I have a list of people connected to ...
2
votes
2answers
82 views

How to change 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 ...
0
votes
0answers
94 views

Keep leading zeros when importing .csv into QGIS?

I'm having issues getting QGIS to retain leading zeros when I import a .csv file. I have zip codes I am trying to read in and I need the leading zeros. I am not super familiar with GIS, so please ...
1
vote
1answer
78 views

Replacing text string on layout text element by reading lookup value from table via SearchCursor?

I'm not sure what the best way is to go about this, but here's my situation: In short, I exported a domain to a table (and I exported the table as a CSV, too, just in case it might be easier to work ...