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

learn more… | top users | synonyms

0
votes
2answers
26 views

CSV won't import correctly into Arcmap 10.3

I have a spread sheet with coordinates that once I bring in to Arcmap, the attributes disappear. The points are on the map, and when you Identify each point, the data shows up, but when the attribute ...
2
votes
0answers
25 views

Arcpy module to read csv files and create polyline shapefiles

I am creating a module in arcpy that will loop through a folder with csv files in it. I have both of them written, and they work fine on my computer. However when I send them to anyone else they won't ...
9
votes
3answers
21k 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 ...
0
votes
1answer
29 views

Exporting from Excel to csv and import in QGIS retaining encoding/special characters (with workaround)?

Problem: When exporting Turkish character encoding into a csv file from an Excel Table (Excel 2013) as a source file I can´t import the resulting csv into QGIS to still displaying the characters ...
0
votes
2answers
134 views

QGIS 2.10, csv points to vector grid

I have a series of point data from a .csv file that I would like to display as a heatmap raster, the .csv data have various attributes with them and I would like to adjust the color ramp based on ...
1
vote
0answers
24 views

Help with Modelbuilder workflow

I am new to ModelBuilder and am working on a project to teach myself how to use it for graduate research. A friend of mine recommended it to me since he was doing something similar in class. I am ...
0
votes
0answers
19 views

Folium circle marker missing from layer control

I am working in an Ipython/Jupyter notebook and attempting to utilize folium.LayerControl() to show several CSV files that I have loaded using Pandas, however the CSV files do not show up in my layer ...
1
vote
0answers
21 views

Postal codes of China

Where can I find geodata with postal codes of China with an open license (commercial use is allowed)?
1
vote
0answers
36 views

Import csv value to an empty field in a point feature class

I have a .csv with three colums and a point feature class with an empty field that i would like to fill with a value of the csv. In the .csv i have 15 rows with a code. In the feature class just one ...
7
votes
1answer
7k views

Is there a way to export a point layer from QGIS to a csv file?

I have saved waypoints from my Garmin as gpx and have successfully imported them into QGIS. Is there a way to now export the layers into a csv file with coordinates? I've tried the export to csv but ...
4
votes
0answers
36 views

How to get NIR values into a LAS file then a CSV?

We are trying to deliver a LAS file with NIR values added for each point. The NIR comes from a raster captured at the same moment as the LiDAR, and is stored as an 8bit number along with RGB in 8bit. ...
1
vote
2answers
40 views

QGISimported CSV points are not visble

I am trying to import CSV file and get no reported errors but there are no points visible. If I click on "zoom to extent" nothing happens (even if I move away from the location of the points before ...
4
votes
2answers
5k views

Converting point grid to raster using GRASS?

If I load the original .csv file, I then have a map of the African continent represented by 14069 data points covering it at 40x40km resolution. Each data point shows solar radiation means across the ...
3
votes
0answers
35 views

Exporting Raster Layer using “Export Raster Data” vs Copy Raster

Is it possible to access the "Export Raster Data" tool in arcpy? Some background on the steps I am trying to process: I have a raster loaded into an mxd. I have converted the raster to a temporary ...
3
votes
3answers
34 views

Convert .csv with polygon geometry to .shp QGIS

Working on a Mac in QGI 2.12, I have a csv file with polygon geometry coordinates that I would like to save to a shapefile. It displays fine as a csv. However, when I try to use "save as," I get the ...
0
votes
0answers
24 views

How do you line up a pre-existing public domain map with csv coordinate points on QGIS?

I have been struggling with this simple problem all day. I found a Florida map with the counties on Google for GIS. I uploaded the map to QGIS with no problem. However, whenever I try to upload points ...
0
votes
1answer
34 views

Convert this CSV to a qgis usable format

I have been given a CSV (which has been converted from a RDF). I want to convert the CSV file to a usable format so that I can display these polygons in QGIS. The original file and some other ...
1
vote
1answer
123 views

How to rewrite a csv for QGIS to avoid “Invalid record format”?

So, I have a .csv file. Here an example how the a row from the original .csv looks like: "AREA",44.37,-00.83,"5","1","8","E","E",,,"KKI","KKO" Some lines have missing latitudes and longitudes, ...
4
votes
3answers
4k views

Python script to export .csv tables from GDB

I am very new to Python programming and have been tasked with writing a program to export a csv file from a file geodatabase feature class. The csv should contain only certain fields and the records ...
4
votes
5answers
1k views

QGIS won't read table columns in CSV import on Mac OS

I am trying to import a CSV file into QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can see how QGIS won't read my data correctly). I ...
2
votes
1answer
23 views

Error message in QGIS using Timemanager

I am using QGIS version 2.14.0 (Essen) and have dowloaded the latest version of the Time Manager plugin in order to do some spatial-temporal analysis. I have imported a csv file into QGIS and made a ...
2
votes
1answer
37 views

csv - CRS undefined, QGIS

I wonder why some csv files when imported (with long and lat) can not set a proper CRS system and other do (CRS undefined). For example: 1) if I export my data in csv with Microsoft Excel it does not ...
1
vote
4answers
2k 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
1answer
23 views

Negative coordinates for WGS84 system are invisible - ArcGIS 10.2

I have a csv file with point coordinates in GCS_WGS_1984 geographic system. I've imported it to ArcMap as a XY file however negative values for West hemisphere are not visible (but ALL records are in ...
4
votes
1answer
235 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 ...
1
vote
2answers
2k views

How to spatially join polygon fields onto a point layer in QGIS?

I have gridded depth points in CSV format that I'm trying to add other map data to, in additional columns. I've tried joining fields, hoping that I could link the Shapefile data to the csv, but when I ...
1
vote
2answers
17 views

Geoserver - Layer creation via data import

We have about 400 sites (materialized by coordinates in the spreadsheet file to be imported) and several fields of information attached to these sites (coordinates, site ID, name, comments, category, ...
0
votes
1answer
26 views

CSVLayer as a source for Search widget in ArcGIS Javascript

I am trying to add my CSVLayer as a source for the Search widget, however, I've been unsuccessful. My Search widget searches addresses and I was able to add one of the sources from this example ...
0
votes
0answers
34 views

Updating attribute table by CSV in ArcGIS for Desktop?

I have a File Geodatabase in ArcGis that contains shapefiles and tables. The tables must be updated using CSV or Excel files. The structure of the existing tables and the update csv will be exactly ...
1
vote
1answer
87 views

Getting around current database field limitations?

I have a need to store over 350 fields in a table and have this information readily available to display spatially. The problem is that access only allows for 255 fields. So the feature class that I ...
7
votes
0answers
81 views

Perform QGIS modeler multiple raster calculations with data from external CSV

I need to perform multiple calculations on a set of rasters based on values in a CSV metadata file. I'm using the QGIS graphical modeler and can call a specific field in a CSV with the Table and ...
2
votes
4answers
105 views

CSV points not showing up when importing them in QGIS [duplicate]

I know this question has been asked before in one form or another, but those answers didn't solve my issue. I'm using QGIS 2.14.0 and trying to upload lat/lon coordinates from a csv file. When I ...
0
votes
1answer
48 views

Writing attributes and associated feature class name from file geodatabase to CSV?

I need to write a csv file that lists every record from an ID field across all feature classes in a gdb. The code I have written below does that fine, but I also need to write in the second column of ...
1
vote
1answer
16 views

Graphing attributes if they fulfill a condition

I have a dataset with schools, school coordenates, if the school is private or public and a variable containing the decile of attainment of the school in a test. I am trying to map schools in a city ...
0
votes
2answers
51 views

Importing/Plotting Lat/Long points from single column of *.csv using Python?

I have data in a .csv that looks something like this: Entry A Xa0,Ya0 Xa1,Ya1 Xa2,Ya2 Entry B Xb0,Yb0 Xb1,Yb1 Xb2,Yb2 Entry C Xc0,Yc0 Xc1,Yc1 Xc2,Yc2 The ultimate goal is to plot ...
1
vote
0answers
27 views

Looping through CSV files to write Lists [closed]

I am very new to Python and am attempting to use it for some relative humidity data. I am looking at 60 months of data. The files include a Lat and Long file (CSV in a Matrix) and Relative Humidity ...
1
vote
1answer
93 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 ...
1
vote
0answers
21 views

Getting CSV file of Wikipedia geolocations?

Where do I get a CSV file containing (a reference to) all Wikipedia articles with lon/lat coordinates? I am aware of Retrieving Wikipedia's coordinate information? which refers to this page: ...
1
vote
1answer
28 views

PTV_Mercator correctly recalculated to WGS84 EPGS:4326 but not correct on map

I have recalculated PTV_Mercator (PTV Spherical Mercator EPSG:505456) coordinates to WGS84 EPGS:4326 coordinates in Excel. And when checking them on Google Maps they show up correct. But after ...
3
votes
1answer
324 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 ...
1
vote
4answers
80 views

Error when trying to save an Excel file from attribute table using QGIS

I keep getting this error (see below) when trying to save the attribute table to an Excel file using XY Tools. Can anyone help? I have deleted and re-installed xytools but this hasn't helped. An ...
3
votes
3answers
82 views

Editing CSV tables in QGIS

I am trying to join a CSV table to a shapefile in QGIS 2.12.0. I have exported a table from Excel to CSV format, but when opening the table I noticed that my unique ID field in Excel is in text ...
3
votes
1answer
79 views

How to do operation after using over() for a shapefile in R?

I am copying the answer of Counts the number of points in a polygon in R library("raster") x <- getData('GADM', country='ITA', level=1) class(x) # [1] "SpatialPolygonsDataFrame" # attr(,"package") ...
2
votes
2answers
84 views

How to convert the CSV to point shape file using python

import csv,sys import osgeo.ogr, osgeo.osr #we will need some packages from osgeo import ogr from osgeo import * import osgeo.osr as osr def test(): boolValue = True canvas = ...
1
vote
2answers
238 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
1answer
430 views

Copy Features tool run after Make XY Event Layer on CSV file fails to complete?

Using the Make XY Event Layer tool I converted a table to a layer. I am trying to convert the newly created layer to a feature class in my file geodatabase. I have been able to do this in ...
6
votes
2answers
68 views

Import unknown CSV file format in QGIS

I have a CSV data sheet that I would like to import in QGIS as a set of polygons. The CSV file contains a column of geometries with long lines of data (see example below). Can somebody tell me how I ...
1
vote
2answers
44k 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 ...
3
votes
1answer
42 views

How can i simply merge csv files together with fme

I have some csv files which have varying contents. I want to simply disregard the schema and write the lines of text into one file. Which transformers or technique could I use to achieve this?
1
vote
0answers
37 views

ESRI Javascript KMLLayer and CSVLayer

I have a map where I have a KMLLayer that defines a geographic boundary and a CSVLayer that defines points within that boundary. I do not want any infoWindow information popping up for the KMLLayer ...