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

learn more… | top users | synonyms

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
224 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
71 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
99 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
39 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
25 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
42 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
128 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
72 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
63 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
45 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 ...
1
vote
1answer
131 views

How can I download GISGraphy CSV Files for a particular country? [closed]

So, the files have been removed from the server due to some hacking issues and I need the CSV files urgently. How and from where can I download these CSVs? GISGraphy is setup on my system, only the ...
0
votes
1answer
96 views

ESRI Javascript CSVLayer onClick Event

I have a CSVLayer that I loaded into a web application. The data that I want to display within the infowindow of that CSVLayer is too large to display nicely in the existing map window. Therefore ...
3
votes
3answers
87 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 format,...
3
votes
1answer
200 views

Can QGIS plot coordinates in Degrees-Minutes format?

I have a .csv file of coordinates that looks like this: Is there a way for QGIS to plot coordinates formatted like this? I've tried Adding a Delimited Text Layer... in QGIS, but do not see any ...
2
votes
1answer
350 views

NMEA to CSV with timestamp using gpsbabel

I tried to convert a file in NMEA to csv using gpsbabel, $ gpsbabel -i nmea -f GPS_20160204_092027.log -o csv -F GPS_20160204_092027.csv I get a csv file with only latitude and longitude, but was ...
2
votes
1answer
87 views

How to create a shapefile from xy in .csv file?

I find many difficult to create a new shapefile in a new project following those steps. I think the .csv file is correct (there are only: ID, X coord, Y coord) but when I would create the shapefile ...
1
vote
1answer
48 views

CartoDB restricts uploading only up to 250 columns

I had developed an application using cartodb.js which transforms a csv file uploaded in cartodb database to geometries in map. The application works fine when there are 230 columns in csv file and the ...
2
votes
2answers
49 views

How can I handle NULL values in a color ramp? [duplicate]

I'm mapping areas in QGIS 2.12 based on average pricing, using area polygons (PostGIS) joined with a CSV data table that doesn't have values for areas that didn't have any sales. I'd like to color ...
5
votes
3answers
145 views

Modifying CSV file in QGIS before joining it to shapefile?

I've imported a Delimited Text File that I want to join to a shapefile. Unfortunately, the join field has a ' character before the actual string. I wanted to delete that character, but I can't ...
0
votes
1answer
119 views

Joining a csv table to the attribute table of a feature class in arc gis 10.3

I am new to arcpy. I was trying to join a csv table to the attribute table of a feature class. Here I would like to share what i was trying to do. import arcpy, csv from arcpy import env env....
1
vote
0answers
21 views

In QGIS add new attribute table features from updated csv [duplicate]

In QGIS I created a point layer from a csv using "add delimited text layer" (the comma icon). I set style and viewing scales the way I want for the layer. Since then the csv has been expanded with ...
1
vote
2answers
28 views

One CSV with field that delineates CRS for QGIS?

I have a CSV with points with X,y coordinates. One of the fields is "Horizontal Datum," which says what the projection is. Here is a sample of the sheet: QGIS lets me import this csv file, but when ...
0
votes
1answer
73 views

QGIS - what is the core database system? [closed]

What is the core database system used by QGIS? When you launch an existing project that has multiple .shp files (with associated .dbf tables), is the core db system used to convert that data to its ...
1
vote
1answer
32 views

How do I extract elevation data from a DEM using points I have in a CSV?

So I have a CSV with a lot of fields. The first 3 fields are the ID, longitude, and latitude. I have already converted to decimal degrees, and said to display XY data. (Is there something else I need ...
1
vote
1answer
106 views

Conversion of .csv file to MapInfo generates very large .dat file

I am converting an .xls file (500kb) to a .csv (150KB) then using this to generate a MapInfo .tab file format using both QGis and ArcGIS. I can use an intermediate file ie. mif/mid format which gives ...
1
vote
1answer
10 views

Not able to progress past loading CSV in New Dataset dialog

We're getting some strange behavior in the connect dataset dialog, where, once we've selected a CSV file for upload, we get no button or feedback to continue the process. screenshot Anyone else ...
3
votes
1answer
80 views

Raster Layer Statistics CSV Output using QGIS Graphic Modeller

I am currently working on a project where I am using historical cloud coverage from MODIS Cloud Fraction data to try and estimate future cloud coverage of any particular month. I currently have 10-...
1
vote
3answers
33 views

Linking numerical data to county geometric data using CartoDB?

I have a CSV spreadsheet that contains some county names in Michigan and numerical data. It looks like this: Allegan, 5, 4.51 Alpena, 1, 3.44 Antrim 2, 8.64 Barry 1, 1.69 Etc. I ...
1
vote
0answers
123 views

How to convert csv file into geo database file?

I have a csv file that i want to export to a file geodatabase (*.gdb) in C#. I am currently looking into GDAL ogr2ogr commands. They have a way to convert gdb file into csv file but not the ...
4
votes
1answer
135 views

Convert Transcad Matrix to CSV

Is there a way to read a TransCad Matrix file (mtx) without access to Transcad. I am trying to convert a matrix file to a csv file.
1
vote
1answer
43 views

What Causes the error “FeatureType XX does not have lat lng fields named 'Lat' and 'Lon'”

I am using the Geoserver Importer REST API to import some CSV data to an Oracle database(datastore). This is what I do: create an export task: curl -XPOST -H "Content-type: application/json" -d @...
2
votes
0answers
64 views

Why does QGIS Browser 2.12.1 keep freezing/crashing when I try to view a csv data table?

I've just downloaded QGIS Lyon 2.12.1. The desktop application works great but the browser crashes whenever I try to view a csv data table. I've gotten it to work once out of ten tries. I click on ...
5
votes
2answers
59 views

QGIS Import CSV variable conversion

I tried to import CSV files to QGIS using the "Add delimited text layer" feature. For some reason, some of the numeric variables became QString. I need them to become integer so I could perform ...
2
votes
1answer
47 views

How to control field properties when importing csv to Arc gdb [closed]

I am writing Python code to import csv files with UK postcodes to ArcGIS file gdb. The import works fine, however, text fields in newly created table in gdb have length of 8000 characters. Is there a ...
2
votes
1answer
68 views

ArcPy Python Script To Update Shapefile Records From CSVs

I am fairly new to python scripting. Most of the basics I have down however still learning. I am trying to create a python script to update a shapefile with information from two separate CSV files. ...
1
vote
1answer
31 views

Using csv data in print composer

I want to present data from a csv-file in a fact box next to a map. The map is created using QGIS (2.12.2) print composer. The data in the csv-file is updated regularly and I want to be able to link ...
1
vote
1answer
67 views

How to load my csv file with wkt to QGIS

Hello all this is my first project regarding QGIS. My problem is I have a csv file ` shapeId, gpsPoint=lat, gpsPoint=lon, length, segments, lengthJson, segmentsJson, name, gpsAltitude, isBoundary, ...
1
vote
3answers
143 views

Windows software to convert GeoJSON (> 6Mb) to Excel/CSV?

I am trying to convert OpenStreetmap data GeoJSON to Excel (or .csv files). Few online converters are there. However, when the file is big (example: 6Mb Geojson), the browser is becoming ...
1
vote
1answer
111 views

Keeping OID field when exporting to CSV?

I imported a csv file and converted it to gdb format, and now I want to export it back to csv. The file will be the exact same as before I imported it, except I want to keep the ArcMap generated OID. ...
2
votes
1answer
107 views

How to create polygon from bounding box coordinates (PostGIS/cartoDB)

I have data to import to cartoDB in CSV format in which there is a bounding box column holding two lat/long coordinates representing the corners of a bounding box, like 53.113206182344,-9.15629032156;...
1
vote
1answer
97 views

Gdal ogrinfo CSV unable to open datasource

When I try to import a csv file into a PostgreSQL table with the Gdal ogr2ogr tool I get the "Unable to open datasource" Failure. So I tried to open it with the tool ogrinfo and I get the same Failure....
1
vote
1answer
199 views

Leaflet fitBounds Starting Position

I am creating a Leaflet application that uses the code from the Simple CSV template to set the bounds of the map to the selected markers. The issue I have is that I want to set a start position that ...
5
votes
1answer
671 views

Convert a pandas DataFrame to a GeoDataFrame

This seems like a simple enough question, but I can't figure out how to convert a pandas DataFrame to a GeoDataFrame for a spatial join. Here is an example of what my data looks like using df.head(): ...
0
votes
1answer
92 views

Connecting two coordinates with Polyline? Cartodb?

I have some trip data and I want to draw a line between the start and end coordinates. I have two layers in CartoDB - one contains the start coordinates (with trip_id & cartodb_id). The other ...
6
votes
0answers
91 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 ...
1
vote
0answers
54 views

create polygons using 2 coordinates

I have a script that creates a text file containing the upper left and lower right coordinates of my geotiff files in the following format. TileName UpperLeftX UpperLeftY LowerLeftx LowerLeftY I ...