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

learn more… | top users | synonyms

0
votes
1answer
15 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
19 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 ...
1
vote
1answer
63 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
9 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
21 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
36 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
210 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
182 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
45 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
26 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
22 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
48 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
33 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
2answers
106 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 ...
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
131 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
29 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
122 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
32 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
68 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
46 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
10 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
60 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
74 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
674 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
113 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 ...
1
vote
1answer
232 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 | ...
2
votes
2answers
63 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
70 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
52 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?
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
60 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 ...
17
votes
4answers
8k views

Joining non-spatial CSV file to spatial data (shapefile) using QGIS?

I have a CSV file which has postcode data in a field, but it is non-spatial e.g. no Easting and Northing. I have a shapefile with postcode in a field and some additional data. I want to join the ...
4
votes
2answers
169 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
52 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 ...
0
votes
0answers
22 views

Setting column type for CSV file using ArcGIS for Desktop? [duplicate]

I have a CSV file that I'm using to create a layer in ArcView 10. The first column contains a mix of numbers in the first few records, with strings further down. On import, ArcView casts the ...
1
vote
0answers
44 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' ...
0
votes
1answer
36 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 ...
3
votes
1answer
110 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 ...
1
vote
1answer
62 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
69 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
58 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 ...
2
votes
1answer
54 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
65 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 ...