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

learn more… | top users | synonyms

2
votes
3answers
44 views

QGIS add virtual field to csv layer

In QGIS 2.14.3 added a csv file as a layer. Attempt to add a virtual field like shown in the screenshot below (same result with "field_14" || ' ' || "field_10" || "field_11"): The field is created ...
1
vote
1answer
18 views

Generating Contours from csv Concentrations

I have a shp file showing locations of various wells on a site. I have linked (joined) a csv file of analytical results to this file. I am now looking for a method to generate contours based upon ...
-1
votes
1answer
44 views

Export field list to excel or csv

I've got the below script and found very useful. But I need the list of fields to be exported to excel or csv. import arcpy #Set workspace environment to geodatabase arcpy.env.workspace = "e:/temp/...
0
votes
1answer
20 views

Export csv-coordinates to JSON - square brackets [closed]

I´ve got multiple point-layers that I want to join in a single JSON-file used for webmapping. The layers is to be listed in column by column like this: [55.778659,12.151137 ], [55.77272358,12....
3
votes
1answer
95 views

How to convert multiple csv files to shp using python and no arcpy?

At my internship, I have been asked to learn Python on the job. Its been a rough road never having coded before so please forgive me if my problem is elementary. The Lightning CSV files I am ...
0
votes
1answer
10 views

Selection Tool selects random multiple points around the one aimed for

I have a problem selecting points in ArcGis - the selection feature seems to be misbehaving, not allowing me to select point features precisely. I've imported the XY data of households as a csv file, ...
0
votes
1answer
17 views

Republic of Ireland .csv to mark out points on site. Which map/co-ordinate system to use?

I need to be able to create points in Arcmap 10.1 (or 10.4) in a geo-referenced map layer which I can then export as a .csv file and then use in my gps (GeoExplorer 6000) to mark out those points on ...
1
vote
3answers
54 views

Importing CSV file to QGIS from Excel columns with formulas

I import a CSV file on Qgis. In excel I see an incription like that ¨54235¨ and in the attribute table in qgis as well as in notepad it looks like that ¨ 54 235¨ *not space but tab. The column when ...
2
votes
1answer
58 views

Converting a CSV to DXF using ogr2ogr from the command line

I am trying to convert a .csv file to .dxf using ogr2org from the command line using the following command: ogr2ogr -f DXF control.dxf opua.vrt This is the .vrt file I am using: <...
0
votes
1answer
27 views

Assigning/joining tabulated data to features in MapInfo?

I am not a MapInfo user, but I have been asked whether that software can assign/join tabulated data to GIS features like buildings, roads and watercourses?
2
votes
1answer
39 views

Attribute field name is not case-sensitive anymore after creating new layer

I joined a sqlite layer with a csv table (each attribute field name starts with a capital letter). When I create a new layer out of them ("save as", e.g. as a new sqlite layer with all data combined), ...
3
votes
1answer
63 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom geometry(...
1
vote
0answers
19 views

Looking for Polygon data on NUTS2 (2013 system) in CSV or Excel?

Looking for Polygon data on NUTS2 (2013 system). Can somebody supply this in CSV or Excel? I have been searching on NUTS2 Polygon data, but unlucky so far. I have found the data but this is in ...
1
vote
1answer
62 views

Importing Data with CSV

I am wondering what I would need to do in order to import a CSV file and then combined that with an existing layer. I would like to know which boxes I need to check in order to make this combine with ...
1
vote
1answer
38 views

QGIS automatic fill columns from referenced csv

I have what is probably quite an easy problem, however I'm not able to figure it out by myself. I work as a field researcher doing bird inventory. I collect the data via QGIS on an android-tablet, ...
3
votes
0answers
57 views

Optimize CSV to QGIS workflow?

I am using statistical analysis software to pick out specific city lots within a database of around 500,000 lots. This is exploratory work and I'm mapping each test out in QGIS through an imported CSV ...
1
vote
1answer
65 views

Arcpy update cursor: stop iteration error

I have 1 csv with municipalities and their corresponding zip codes and a GDB of houses which contain address, municipality but no zip codes Objective: add the zip codes to the GDB table import csv ...
2
votes
0answers
66 views

Converting KML coordinates to Leaflet

I am trying to convert a Google Map KML file to a csv, to map the longitude and latitude points on Leaflet. But the coordinates keep mis-projecting and some end up off the land mass. The steps I have ...
1
vote
3answers
56 views

How do I separate .txt data into multiple columns when exporting to .CSV?

I have .txt data that is described as Lat Lon Elevation (meters) and when I export to .CSV in Excel it puts all data into 1 column. So when I import the data into QGIS it all dumps into 1 column, and ...
0
votes
0answers
15 views

Loading Data into Vector Layer Polygon

My first layer is a map. My second layer consists of points: bars with GPS coordinates (.cvs file). My third layer consists polygons, creating different area's for the bars. So, the points of the ...
2
votes
1answer
72 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 ...
0
votes
2answers
32 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 ...
0
votes
0answers
71 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
29 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
39 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 ...
4
votes
0answers
46 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
42 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 ...
0
votes
0answers
25 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 ...
3
votes
0answers
67 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 ...
4
votes
3answers
68 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
1answer
58 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
1answer
40 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 ...
2
votes
1answer
29 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
52 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 ...
0
votes
1answer
39 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 ...
1
vote
2answers
43 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
39 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 (...
1
vote
1answer
90 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 ...
0
votes
0answers
40 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 ...
2
votes
4answers
180 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
69 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
19 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
77 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
36 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
0answers
23 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
38 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
84 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
114 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 = qgis.utils.iface....
6
votes
2answers
70 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 ...
3
votes
1answer
58 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?