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

learn more… | top users | synonyms

0
votes
1answer
212 views

Help with Python Update Cursor syntax

I'm having trouble running a loop to update the values in a particular field in attribute table by reading from a csv file. Any input is greatly appreciated. The following is the sample code: import ...
0
votes
1answer
199 views

GeoTool CSV to Shape Conversion Error

In the Feature Tutorial Example GeometryFactory geometryFactory = JTSFactoryFinder.getGeometryFactory(); generates error: method getGeometryFactory in class ...
0
votes
1answer
30 views

Problems Joining CSV to Shpfile arcgis 9.3

So I have been trying to get this to work all day and have had no success. I am attempting to join a CSV file with a Shapefile. The CSV is from the Hud's location affordability portal ...
0
votes
1answer
56 views

How Do I Snap a CSV to a SHP Using ArcPy?

I'm a veteran Python programmer very new to ArcGIS. I'm trying to do what seems like it would be a simple operation in arcpy, but I don't think I know enough about the ArcGIS terminology to do more ...
0
votes
2answers
128 views

Date fails in String -> Date in CartoDB

I'm trying to convert a column in CartoDB from String to Date. My dates are the following format: 2014-01-02T00:02:00 2014-01-02T08:05:00 ... I've tried to append +00:00, so they looks like: ...
0
votes
1answer
94 views

PostGIS import csv encoding problem

I want to import csv into PostGIS database, I receive error massage: alpha=# COPY project FROM '/home/alpha/database/project.csv' DELIMITERS ',' CSV; ERROR: invalid byte sequence for encoding ...
0
votes
1answer
107 views

With QGIS, how can I create a layer from a .csv file?

I have a .csv file with ~16k points with lat and long to plot onto a map. I'm completely new to both QGIS and GIS in general and have got to a point where I have downloaded the OpenLayers and ...
0
votes
1answer
52 views

Display county for random points

I have a county level shape file for South Carolina. I generated random points using Vector->Research Tools-> Random Points. The Attribute tables for the random points layer has only the ID included. ...
0
votes
1answer
362 views

Trying to make xml data readable for Arcgis

I am trying to convert xml data into tabular form for the process of geocoding. We have the xml file with info that we are going to run through an address locator. Do I need a script for this? Can ...
0
votes
1answer
25 views

How to define which columns in a Spatialite database are the latitude and longitude?

I have imported a CSV containing points with coordinates specified in columns named Latitude and Longitude. How do tell spatialite that these columns are the coordinates of of my points?
0
votes
1answer
30 views

How to convert excel csv file to filled contour Google Earth Map?

I have a csv file http://www.geocities.ws/radar/data2.csv. The first column is latitude. The second column is lonitude. The third column is precipitation type. 5 represents freezing rain. 15 ...
0
votes
1answer
52 views

Import non spatial data into SQL Server using ogr2ogr

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using ...
0
votes
1answer
38 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
0
votes
1answer
44 views

why can't i export geometry data from a shapefile?

I saved the layer using "vector save as" box but even when adding GEOMETRY=AS_XY in the layer box, the csv only showed the id and no gemetry data.
0
votes
1answer
160 views

What is the format expected by QGis for Latitude/Longitude in DMS?

I have been struggling with a csv file I need to import into QGis 2.2.0 (on Windows 7). The coordinates are in this format: LATITUDE LONGITUDE 424605 861204 395222 861206 303051 861219 ...
0
votes
2answers
55 views

How to create path based on waypoints?

I am trying to map flight paths and compare historic paths with current ones (so I later need to perform some calculations as distances between them). For this task I am using QGIS on OSX 10.9.1 As ...
0
votes
1answer
227 views

Object-ID field in CSV file

I am displaying a CSV file in ArcGIS 10. After adding the data table, I right-click it, and select "Display XY Data". I am able to complete the required information and display the data, however, I ...
0
votes
1answer
284 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 ...
0
votes
1answer
300 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 ...
0
votes
1answer
127 views

How to map and color localities (provinces) with an external CSV using Quantum GIS

I use a Swiss shape file map (called PLZO_PLZ) available on http://www.cadastre.ch/internet/cadastre/fr/home/products/plz/data.html (ZIP file Shape LV03) PLZO_PLZ contains a column called PLZ which ...
0
votes
3answers
587 views

How to plot coordinates from *.csv file on Google Maps?

I want to highlight a mobile trace on Google Maps and GIS data from my network must also be visible. I am able to plot hard coded coordinates on Google Maps but not from a *.csv file. Note: *.csv ...
0
votes
1answer
80 views

Why is the CSVT file changing my real values to null?

I made a CSVT file to change desired real data to string data. After importing the original CSV file, that was linked by file name to the CSVT file, the string data appears as normal however all the ...
0
votes
1answer
74 views

Values in attribute table not showing up

I have values in an attribute table I want to label my layer with. But when I label it, a totally different set of values show up. In the attribute table, my values are between 0 and 200. But the ...
0
votes
1answer
254 views

CSV and GDAL 1.10 in QGIS

It seems the GDAL upgrade from 1.9 to 1.10 changed the way CSV files are handled so that I now have a non-functioning QGIS. App hangs trying to import csv data file when previously had no problems ...
0
votes
1answer
135 views

Problem with encoding of CSV and SHP files in Linux

I am new to using QGIS. I came up against the encoding issue of shp files. This solution to solved my problem in Windows (for source I had to put windows-1253 instead of utf-8) My question is what ...
0
votes
1answer
68 views

How to configure web map data layer that can accept csv data uploaded by user?

I made this map: http://tinyurl.com/a368268 on arcgis online. How do I get the same map but instead you can upload a new csv every time? Instead of having to first add it as data layer on arcgis ...
0
votes
1answer
69 views

Error running geotools tutorial for CSV2SHP?

Although I run this tutorial I always get following error message: Nov 22, 2011 5:10:50 PM org.geotools.referencing.factory.epsg.ThreadedPostgreSQLEpsgFactory isAvailable WARNING: ...
0
votes
2answers
33 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
9 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
19 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
22 views

Import CSV limited to 20 records [duplicate]

I want to import data that I have on a csv file into QGis. Its basic data; point name, latitude, longitude. I have around 1200 records on the csv file. Surprisingly, when I import the data into QGis ...
0
votes
0answers
28 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
29 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
50 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
53 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
1answer
95 views

Save as .csv with coordinates in both QGIS 2.2 and PyqGIS

These questions have been asked before, but since they are not answered I will try to pick up the ends here. 1) First, as stated here: QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working ...
0
votes
0answers
67 views

Converting a CSV to shapefile [duplicate]

I am attempting to load a CSV file into Qgis and ultimately convert it into a shapefile. I used Layer->Delimited Text Layer but the only options are for points, WKT and no-geometry. Neither of ...
0
votes
0answers
62 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
1answer
65 views

Problems converting csv to shp in QGIS 2.01 on a Mac

When converting a csv to shp, I have been using the 'Add delimited text layer', and get one of two errors. With 'First record has field names' clicked, I am told that there is 'no data found in file'. ...
0
votes
1answer
59 views

How to prevent QGis (MMQGIS plugin) from interpreting numbers as strings [duplicate]

I'm using the MMQGis plugin to "Join Attributes From CSV" into a shape file and am having trouble getting QGis to interpret some numbers as numbers (rather than strings which is what its doing). This ...
0
votes
1answer
128 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
0answers
21 views

String to Integer in QGIS [duplicate]

I have a csv (below) of values I would like to represent in a choropleth map. I've managed to join them to a shapefie via fips code successfully in this format, but the last four columns do not show ...
0
votes
1answer
28 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 ...
0
votes
1answer
29 views

QGis polygon to points different CRS problems

I'm trying to join the values from polygons onto a grid of points. I had this problem solved here by @Underdark , however a few layers weren't working. It seemed they were all British National Grid ...
0
votes
2answers
77 views

How to join CSV data to SHP without ArcGIS?

I'd like to create a chloropleth map displaying quantitative data for an upcoming event. Using TileMill, MapBox. I am having trouble joining my data to a .shp because the #'s correspond to COUNTY ...
0
votes
0answers
20 views

How do I set the column type for a CSV file in ArcView? [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 entire ...
0
votes
1answer
248 views

How to extract geo data out of a polygon shape file into csv kwt [duplicate]

I have a polygon shape file that contains all the neighborhoods in the Netherlands. My aim is to export the neighborhoods and coordinates to csv file (KWT). Without success I tried (with QGIS) these ...
0
votes
2answers
80 views

Python Error in QGIS Ubuntu 13.10 while trying to join .csv tables

Using the mqgis plugging in QGIS I cant join my csv file... This is what QGIS returns me: An error has occured while executing Python code: Traceback (most recent call last): File ...
0
votes
0answers
55 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
17 views

Is it possible to omit the headings of the CSV output of a GetFeature request?

I am making a web service which will consume the result of a WFS GetFeature request made against Geoserver. It would tidy up the code on my side if I was able to specify that the CSV output from ...