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

learn more… | top users | synonyms

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. ...
3
votes
1answer
51 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 ...
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
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
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 | ...
1
vote
1answer
60 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
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 ...
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 ...
0
votes
1answer
41 views

Raw State Data on Health and Social Outcomes

I am looking for raw health and social outcome data (poverty, obesity, education levels, etc.) by state. I would like to download it as a csv or excel file. It needs to have the state fips listed in ...
2
votes
0answers
202 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
0answers
150 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
0answers
94 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 ...
2
votes
0answers
291 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
107 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
247 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
201 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
184 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
0answers
22 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 ...
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 ...
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
0answers
54 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
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 ...
1
vote
0answers
359 views

How do I convert a CSV of latitude/longitude coordinates with timestamps to a GPX tracklog?

Converting from a GPX track to CSV is easy, but I'm looking to go the other way. I have a table of point locations logged with a handheld GPS, with timestamps. I need to convert them to a GPX file ...
1
vote
0answers
83 views

Why does GeoServer's GetFeature round my numbers, but only for outputFormat=CSV?

When I make a GetFeature request with outputFormat=CSV to my GeoServer v2.4.5 I'm finding that the floating point numbers in my returned data have been rounded. When I make the same request with ...
1
vote
0answers
18 views

Can QGIS2 refresh layers without the need to reclassify each layer individually?

I have a set of layers which I'd like to have refreshed each time I open QGIS2.2.0 (Windows 7). Each of 14 layers (polygons) is linked via a join to a csv file with no geometry. The layer displays a ...
1
vote
0answers
235 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 ...
1
vote
0answers
137 views

problem in using schema.ini to force ArcMap recognize field types

I have a folder of csv files (500+), and created a very long schema.ini file to force ArcMap recognize field types as I want. However, for some reason, ArcMap can read some CSV files properly; but ...
1
vote
0answers
130 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 ...
1
vote
0answers
347 views

Why does XYToLine_management give ExecuteError ERROR 999999 The table was not found?

I've written this script to import a csv file using ArcGIS' flavor of python.. ArcPy.. It seems to run fine up until the XYtoLine tool runs and then it fails.. This is the error message... Traceback ...
1
vote
0answers
369 views

How to write vector layer to csv file with geometry by PYTHON?

I use Python try to write vector layer file to csv file with this code QgsVectorFileWriter.writeAsVectorFormat(mylayer, r'c:\temp\xyz.csv', "utf-8", None, "CSV") It can export to xyz.csv but only ...
1
vote
0answers
110 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
1
vote
0answers
109 views

'File is too big' error when uploading QGIS Plugin

I have written a simple QGIS plugin which zooms the map canvas to a user specified UK postcode. I would like to share the plugin but the csv file, which contains stripped down OS Code-Point open data ...
1
vote
0answers
339 views

Placemark that pulls information off an excel sheet row and display's the data in the description part of the Placemark

I am trying to find out if a certain function is available to link an excel sheet with a kmz. What i need to happen is have a Placemark that pulls information off an excel sheet row and display's the ...
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 ...
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 ...
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"; ...
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). ...
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 ...
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 ...
0
votes
0answers
39 views

Broken links after joining an .accdb with a .csv in ArcGIS 10.1

I have two sets of data: A "master" file of coordinates that has one row for each location, saved as a .csv file A table with information for each location but no coordinates, saved in an Access ...
0
votes
0answers
38 views

csv to INSPIRE gml problem in FME Desktop 2014

I have .csv file with id, name, lat, long and other. I just cannot make gml writer to write geometry tags. I mean something like . How can I read this things from my .cvs? What am I missing? fme is ...
0
votes
0answers
51 views

Producing latitude longitute coordinates in csv file based on place names on existing csv file

I have a code that takes the HTML code and extracts the table to put it in CSV file. I want to further take the place names inside csv file and add two columns that show lat and longitude. Here is ...
0
votes
0answers
74 views

Batch join non-spatial csv to shape files

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...
0
votes
0answers
108 views

overpass-api: data export into csv-formate

update; perhaps we can do this like so: to use Perl for text-mangling - so we can use the XML::Simple module. here's an example of a little script to parse your XML: see the Code: #!/usr/bin/perl ...
0
votes
0answers
117 views

drag and drop csv file and display map using leaflet js

I am new in php and leaflet js. I want to drag and drop .csv file in php and using the values of csv file, I want to display map using leaflet js. Can any one help me.
0
votes
0answers
63 views

By converting into a shp file points are reduced

I am new here, so sorry if I missed something, but when I try to converta data from an xls file into a shp file by export data, all the points I had before get reduced to only one?! I also want to ...
0
votes
0answers
102 views

Import csv file and use “toggle editing” and “field calculator” without Saving it as a Shapefile.

I am importing a .csv file in QGIS and I have also made the *.csvt file where I have specified my data types. I still cannot use "Toggle editing" and "field calculator".Whether I must save it as a ...
0
votes
0answers
135 views

Why are some values missing from the imported CSV?

Bit of a strange one: i'm importing a CSV where the rows are the WKT data for regularly progressing rectangles from a grid, then the rectangle name, then values (ranging between 2 & 254). When I ...
0
votes
0answers
126 views

Convert shapes in CSV to shape file

I have a csv file in which one of the fields contains a "shape" polygon in ESRI format. The other fields are textual, numerical, ext. How do I go about creating a layer from only the polygons in the ...
0
votes
0answers
125 views

Use QuantumGIS to bulk-import csv files

I have a large set of .csv-files containing geographic information. Every dataset consists out of 2 .csv-files! This is my folder-structure. All files in Tracks are formatted equally and all in Routes ...