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

learn more… | top users | synonyms

2
votes
1answer
56 views

Cannot import csv to dbase via Table_to_Table in ArcMap

I have a csv file with > 5 million records. When I imported it to dbase via Table_to_Table function in ArcMap, it raised ERROR(99999). As a result, only 2 million or so records were imported... How ...
2
votes
2answers
89 views

How to keep initial zeros when importing csv to dbase in ArcMap

I have a CSV table with millions of records. When I imported in into dbase via ArcMap, those inital zeros in a certain field just went away. E.g. one field show be "01001", but it displayed as "1001". ...
0
votes
0answers
16 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 ...
0
votes
1answer
179 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 ...
1
vote
4answers
115 views

Joining shapefile table with csv

So I am having a shapefile with all the world countries. And the table for this shapefile has a column named "Country Name". Each of this entry is unique, meaning, each country takes only 1 row, and ...
0
votes
0answers
70 views

CSV filename in field names

QGIS 2.0.1 When joins are done from CSV the "new" field names are starting with CSV-files name. How the joins are done without CSV-filenames in fields names?
1
vote
1answer
551 views

How to add X/Y data from Excel file (saved as CSV) on shapefile? [duplicate]

I need to add my X/Y coordinate data as points from my Excel I need help with adding points (using X/Y coordinates). Can anyone help? import arcpy from arcpy import env env.workspace = ...
4
votes
1answer
146 views

Convertion of multiple csv automatically to shp

I have more than two hundreds similar csv files with columns (x, y, value1, value2, objectName). I need to convert them automatically to shp files with x and y columns as the coordinates. Could you ...
3
votes
2answers
64 views

Deleting the “cached” field names for a large CSV file

Using ArcGIS Desktop Advanced 10.1 I have a large CSV file (36MB with about 600,000 records) that contains single addresses that I want to geocode. The file is called "SingleAddresses.csv" The file ...
3
votes
2answers
79 views

What is the best plain text format for georeferenced raster data?

I have to translate satellite images in a file in .txt format or another, such as Excel or .csv, in which there are pixel values corresponding to (longitude,latitude) couples. What is the best file ...
2
votes
0answers
184 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 ...
5
votes
1answer
77 views

Is there a free dataset of historical geocoordinates of ancient cities and places?

Is there a freely available dataset (csv, geojson, topojson, etc.) with geocoordinates of ancient cities, for example of the Roman Empire? Ideally with additional information like population size? ...
2
votes
1answer
1k 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
2answers
3k views

Export list of values into csv or txt file

I would like to know how to export in Arcgis a list of values calculated in python script into one of the following data formats: csv, txt, xls, dbase or other. I would also like to know how to create ...
0
votes
0answers
58 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
106 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 ...
1
vote
2answers
63 views

Error adding a delimited text layer

Im working with QGIS 1.8.0 and I have been trying to upload a delimited text layer but keep getting the following error : The layer ...
2
votes
1answer
90 views

Accented characters in csv file appear as '?' when importing to QGIS

The tabular data (.csv file) and the data in the attributes table of the vector (.shp file) I am trying to join includes accented characters - they are place names in Pamana. For example 'Río Abajo' ...
0
votes
1answer
237 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
110 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
1answer
83 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
3answers
1k views

Using the python shape library: pyshp - how to convert polygons in .csv file to .shp

I'm converting csv data to shapefiles using the pyshp python library. What I want to do is very similar to Using the python shape library: pyshp - how to convert .csv file to .shp, except that I ...
0
votes
0answers
185 views

GRIB Files as Point Data or Raster in Postgres/PostGis Database and display with Geoserver

This is a conceptual question, trying to establish the best approach to the problem! I have read this post already! I want to be able to update weather data on a 2 or 3 times daily from Grib2 files ...
2
votes
1answer
117 views

QGIS: Colour GPS track by speed

sorry íf I might ask this question the 101 time, but I didn't found anything with google or SE. I have a CSV file with WGS84 trackpoints and visualizing them with QGIS textplugin works fine. The log ...
1
vote
2answers
194 views

Batch convert xy to shapefile

I have about 300,000 CSV files which I want to convert to shapefiles, but ArcGIS and QGIS can only convert one CSV at a time. Are there any ways to batch convert my CSVfiles? x y z1 z2 z3 z4 1 2 3 ...
1
vote
1answer
94 views

Importation of .csv on grass gis converts numeric data to string data

When importing a csv file on grass7, the numeric data is converted into a data of type string. My csv looks like this : id_core value 1 F1 83.0611472396 2 F2 98.8584345936 3 F3 ...
0
votes
1answer
102 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 ...
4
votes
2answers
625 views

Export dojo datagrid results to csv in javascript web application

I have created a web application using the esri javascript web api. I populate a dojo datagrid with results returned from a querytask. My question is, how do I export the results to a csv file? I ...
0
votes
3answers
150 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 ...
2
votes
2answers
423 views

How to read csv with WKT geometry in Arcmap?

I have found several parcels I need on a county map viewer. However, the only option to download any of the data is found on a click context menu to "Copy selection as csv" which gives me this: ...
2
votes
0answers
81 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 ...
1
vote
2answers
262 views

Tool for exporting las data

Is there any tool available for extracting the X, Y and Z channels from a .las file and exporting them to a .csv or similar file?
0
votes
1answer
124 views

QSpatialite : import multiple TXT/CSV

I'm using QSpatialite only. I don't have spatialite-gui neither the shell. I want to import multiple TXT/CSV at one time. How is it possible to do that ? I found nothing on the internet. Thanks
1
vote
1answer
47 views

Spaces in postcodes preventing join

I have a shapefile British Columbia with postal codes. The attribute table gives the codes with no spaces, eg V6P2A8. I am trying to join a csv file by postal code (the key I am using). My csv file ...
2
votes
1answer
53 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
3
votes
1answer
409 views

How to add CSV data with no coordinates to a polygon layer in QGIS?

I would like to add attributes from an spss database (around 300 cases) to a polygon layer in QGIS. Both datasets have a column with unique IDs. I exported the spss data to a CSV file which does not ...
0
votes
1answer
70 views

Can this compilation and display of species frequency data be improved? QGIS 1.8.0

As a newbie on QGIS, I would like to find out if the way I put a species frequency map together could be improved upon. I had to map the presence or absence of 7 plant species surveyed in 30 2m x 2m ...
1
vote
2answers
90 views

Why can't I save csv as a shapefile

I am trying to follow the instructions given here, Tutorial: Making Heatmaps using QGIS and GRASS , to build a heat map with my own data. I taken the first step and imported a csv data table into the ...
0
votes
1answer
78 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 ...
4
votes
2answers
255 views

How to draw lines from two points in a CSV?

I have a CSV file where one line looks like this: Duration, user, lat-start, long-start, lat-end, long-end 298, Casual,38.9101,-77.0444,38.91554,-77.03818 Each row in the CSV has two points and I ...
1
vote
0answers
141 views

QGIS Points to Path Plugin Date/time error [closed]

I would like to use the Points to Paths plugin to plot the tracks of collared animals, exactly as specified on this page http://spatialgalaxy.net/2011/12/30/qgis-plugin-of-the-week-points-to-paths/ ...
1
vote
0answers
194 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 ...
0
votes
1answer
66 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 ...
1
vote
1answer
99 views

Export ArcGIS Model to Python - Iterate Rasters, Collect Values, Calculate Values

I want to batch process a large number of raster files, calculate some values and properties and export these to a .csv or .xls. I managed to get a good working model that does this perfectly. ...
3
votes
1answer
142 views

How to get default parameter value for script tool from csv file?

I am fairly new to python scripting. I have just figured out how to read and write input parameters for a python script from a csv file. Now I am being asked to pre-populate the script tool dialog in ...
2
votes
1answer
333 views

Exporting climatic tabular data stored in TIF file into CSV

I have a TIF file containing tabular climatic data, described here, which I am trying to export to spreadsheet / CSV format: http://www.helioclim.org/linke/linke_helioserve.html In summary, it is a ...
0
votes
0answers
98 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 ...
1
vote
0answers
177 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 ...
2
votes
3answers
654 views

How to convert a txt file to shp?

I've got a txt/csv file with the utm coordinates and the hights. Now I want to upload this into qgis. This is not a problem so far. The problem is to create a shapefile out of the data with an ...
0
votes
0answers
85 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 ...