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

learn more… | top users | synonyms

2
votes
0answers
20 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 ...
4
votes
1answer
65 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 ...
2
votes
1answer
56 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
29 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
29 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 ...
4
votes
4answers
3k views

Bulk convert DBF to CSV in a folder ArcGIS 10.1 using Python

I would like to convert 1000 dbf files to CSV. All dbf files are in one folder and they have sequential names (S:\output_tables\tcb1.dbf, S:\output_tables\tcb2.dbf, S:\output_tables\tcb3.dbf, up to ...
2
votes
1answer
37 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 ...
1
vote
0answers
9 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 ...
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 ...
0
votes
0answers
161 views

Is there an easier way to refresh a joined CSV?

I'm working with data that gets updated sporadically. Essentially, I have a CSV which defines which postal codes belong to certain sales reps, and these postal codes might shift around. I made ...
1
vote
2answers
197 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. ...
4
votes
1answer
212 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
21 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
54 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 ...
4
votes
4answers
871 views

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

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

CartoDB data load from csv , geojson file error

I had installed CartoDB locally on my Ubuntu 12.04 and the installation was perfect. I can create dataset by CartoDB's GUI and able to visulaize data perfectly without any problem. But when i drag and ...
1
vote
1answer
18 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 ...
3
votes
2answers
236 views

Exporting .csv file as .shp in QGIS?

I am a newbie to QGIS. Here's what I'm trying to achieve: Step 1: Load the required GIS layer (*.shp file) Step 2: Load the .csv file in QGIS Step 3: Perform the join based on common attributes ...
1
vote
1answer
40 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 ...
3
votes
4answers
8k views

csv to kml converter

Does anyone know a workable and stable program which converts csv extension files to kml? There are many tools available online but none of them worked for me. I tried many including kmlcsv ...
2
votes
2answers
118 views

csv to shp missing file

I transform a csv file into a shape file using the following script import shapefile as shp import csv import tkinter.filedialog import urllib.request import os a = ...
3
votes
1answer
39 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 ...
4
votes
1answer
48 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
3answers
26 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 ...
-2
votes
0answers
58 views

Running geometry check on all feature classes in personal/file geodatabase?

Anybody can help me out and build a small Python script to do the following: browsing though all feature classes (also include those in the dataset) in an personal or file geodatabase Run the ...
1
vote
0answers
42 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 ...
10
votes
4answers
9k views

What ArcGIS geoprocessing tools support exporting tabular data to CSV?

I have found that most if not all geoprocessing tools that allow tabular output are limited to geodatabase tables and DBF files for supported output formats. Are there any that also support CSV ...
2
votes
0answers
33 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 ...
1
vote
1answer
22 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 ...
5
votes
2answers
46 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
2answers
7k views

Exporting county level data in *.shp file to text (csv) file in ArcMap?

I have a shape file created as per the answer to my previous question, which includes county level means for each county in the US. How can I now export this data in a .csv file, e.g. with just the ...
8
votes
2answers
6k views

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

I am trying to understand how I can use the csv module in python to open a csv file in the same folder as the python script, and then create a shapefile using the shapefile module pyshp. The csv file ...
2
votes
1answer
34 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 ...
1
vote
1answer
51 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
23 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
40 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
77 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 ...
3
votes
2answers
418 views

Changing precision on a column in the attribute table without losing data?

I have data in an Excel file that I want to join with a shapefile in my project. The Excel file contains values like volumes. The Excel file and the shapefile I want to join it with both contain the ...
1
vote
1answer
74 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. ...
3
votes
1answer
96 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(): ...
1
vote
1answer
54 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 ...
1
vote
1answer
47 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 ...
1
vote
2answers
1k 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?
5
votes
1answer
902 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 ...
1
vote
1answer
35 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 ...
1
vote
1answer
68 views

Geoserver CSV - changing the default comma separator

I would like to know if it is possible to change the default comma separator CSV exportation in Geoserver using semicolon i.e. as a separator. Some of the tables that I published have large text ...
0
votes
1answer
43 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 ...
1
vote
1answer
458 views

importing data into CartoDB [closed]

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 ...
1
vote
3answers
1k views

convert csv to kml or geojson, etc using ogr2ogr or equivalent command line tools (use “latitude” and “longitude” attributes for coordinates)

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csv The csv has "latitude" and "longitude" columns. The attributes are all loaded ...
4
votes
0answers
26 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 ...