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

learn more… | top users | synonyms

1
vote
1answer
32 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
54 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
55 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
40 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
59 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
26 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
54 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
102 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
88 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
78 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
1answer
77 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
83 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 ...
4
votes
1answer
296 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
61 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 ...
7
votes
0answers
80 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
44 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 ...
0
votes
1answer
55 views

Leaflet geoCSV Popup Customisation

I am currently using the leaflet geoCSV plugin to bring through CSV data into the map frame. I am struggling to be able to customise the popup to only show certain attributes of the CSV and different ...
1
vote
1answer
48 views

Joining two datasets based on matching values in multiple fields

I am trying to find a way to join CSV data to a vector layer only when they both share matching values in multiple fields, rather than just one field. This is a problem I'm running into with multiple ...
0
votes
0answers
19 views

How to script downloading and cleaning CSV so that it is readable in ArcMap? [duplicate]

I am very new to GIS Programming and find myself having to download CSV files from the Internet and scrubbing them (ex: removing special characters or spaces from field names) so they are readable in ...
1
vote
0answers
11 views

Export coordinates from Windows Phone [closed]

I'm looking for an application for Windows Phone that would enable me to capture some GPS coordinates then export the list to a file (.CSV for example). I could not find app that supports export. Do ...
1
vote
0answers
32 views

Read latitude/longitude to create new point grid at higher resolution

New to SE, needed to reformat my other question. Basically I'm looking at reading a CSV with longitude and latitude points (in this case housing exposure, simplified below): HUC4,Longitude,Latitude ...
1
vote
1answer
33 views

QGIS doesn't recognize numeric cell content (xls)

I want to join Excel data (numeric) to a Shapefile in QGIS. Although the cells are defined as numbers in Excel, QGIS recognizes them as string. I tried also csv, csv (windows), txt, xls, xlsx, none of ...
1
vote
2answers
119 views

Speeding up Python code to convert multiple csv to shapefile?

I am trying to work with some crime data from https://data.police.uk/data/ The data is organised in several .csv files, one for each month and each crime is geocoded with Lat and Long. As the file ...
2
votes
1answer
34 views

Open CSV with native QGIS Widget

I am writing a plugin that offers to open a CSV. I know the local path to the CSV but I don't know if it contains spatial data nor which name the X and Y could have. The best way I can think of, is ...
2
votes
2answers
103 views

How to make a square out of two points?

I have a csv file with two x and y columns. (x,y,x,y). The coordinates represent tiles which I want to visualize in ArcMap. But I dont know how to do it. As you can see in the picture below, given ...
0
votes
0answers
119 views

CSV to Polygon.SHP with Python

I'm looking for a way to convert CSV file to polygons shapefile. I need to make polygons with defined size. In the CSV file, The first row is the length of each polygon and the first column is the ...
1
vote
0answers
54 views

ESRI/SRID mismatch: How to correct?

I'm currently working with PostgreSQL and CartoDB to display X and Y coordinates converted to a geom. My shp files have been created and are displayed through CartBD. When I try and run a map view, ...
1
vote
4answers
79 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 ...
0
votes
1answer
56 views

Trying to find Coordinate System for Dubai?

I have a CSV file to convert .shp. The X,Y values are like X -40219075 Y 200946341 This is somewhere in Dubai area. Can any one tell me what will be the coordinate system they used for this?
9
votes
4answers
520 views

How to reproject 500 CSV files efficiently and easily using QGIS?

I know, my question is similar to some old ones on this site. I've a lot of CSV files (geo coordinates) to import to qgis (and then to convert them), and the usual way is not the best way to do it ...
0
votes
0answers
6 views

Trouble with graduated symbols after joining shapefile with csv file Again [duplicate]

This question has already been asked: Trouble with graduated symbols after joining shapefile with csv file BUT I do not know how to create a csvt file? Having a lot of trouble with this. Is there ...
4
votes
1answer
51 views

QGIS - Import CSV column names as numbers

I want to import a CSV table (no geometry) to QGIS. The column names which are numbers (e.g. 2004) are not getting imported. This is my test CSV file: Name;Eigenschaft;2004;test derName;1;21;21 ...
2
votes
1answer
64 views

Creating a CSV with Irish Grid references and opening the points in QGIS

I have a load of Irish grid references that I need to create a map of in Ireland - any advice? Tried to input a couple of refs and open in Biological record tool thinking this would be simple but hey ...
0
votes
0answers
88 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 ...
2
votes
1answer
60 views

CSV to Layer from a Delimited Text File in QGIS

enter image description hereI am importing a CSV file into QGIS using the official instructions on their page: http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html. For some reason, ...
1
vote
2answers
61 views

Adding a csv layer in PyQGIS

I am trying to load a series of csv files as vectors in PyQGIS. I run this code to try to get the first one: uri='file://D:/Saved Stuff/gulags/1.40.csv?delimiter=;&yField=y&xField=x' layer = ...
1
vote
0answers
33 views

Adding multiple icons to a single csv layer

I am loading the NumberIcon1 image for every point added through the csv file, is it possible to loop through the images so that way they go in order like NumberIcon 2 for the second point in the csv ...
1
vote
0answers
236 views

Using Python to compute the distance, speed, and time between coordinates (lat/long) using haversine formula and print results within .csv

I have a .csv file with 10 columns. The first column is titled Distance_Between_Points, the second column is titled Time_Between_Points, and the third column is titled Speed_Between_Points and all ...
1
vote
0answers
287 views

MMQGIS Geocoding Error [closed]

I have a file with over 27,000 addresses, and I'm trying to geocode it using the OpenStreetMap/Nominatim web service via the MMQGIS plugin on QGIS 2.10. I keep getting an error after about 30 minutes ...
3
votes
1answer
112 views

Qgis: Export only some columns of the selected objects to CSV

I have a layer with a table containing several columns. If I right click on the layer --> Save as.. --> CSV and chose to only include my selection I get a nice CSV file with all columns for the ...
1
vote
0answers
136 views

PyQGIS export return blank .tif

I'm new to pyqgis and trying to bring up from the previous post with a little progress from the last (implemented debugging tool pdb) but now trying to export into a .tif file so that I can check on ...
1
vote
1answer
95 views

Importing CSV data with Coordinates in one column

I'm trying to import the Lat/Long coordinates from the "Location" field of a CSV from here :https://data.colorado.gov/Water/DWR-Water-Right-Net-Amounts/acsg-f33s Unfortunately the coordinates are in ...
1
vote
1answer
64 views

Export shapefile with “non standard” characters to csv and read in excel

Macbook air mid 2011 running OSX 10.10.5 QGIS 2.8.2 - Wien Excel 15.13.1 (O365) When I export a shapefile containing non-ascii characters to a csv file using QGIS (setting encoding to utf-8) and ...
0
votes
1answer
107 views

Importing updated CSV values to feature class fields?

Some time back I had a requirement to develop an automated method (Python) to update field values for a spatial points dataset in an Oracle 11g SDE database (exported to GDB for testing). Im Using Win ...
6
votes
3answers
354 views

How can I get ArcMap 10.2 to recognize a csv column as float and not int?

I am trying to show a .csv file (2 columns, 291 rows) in ArcMap 10.2 using Catalog window to drag the .csv file into ArcMap. The second column of the .csv is a floating point number (range is [0-1]), ...
1
vote
0answers
52 views

Populate empty attribute table from constantly growing CSV in QGIS

I have a Python script running that will generate a line feature from a point depending on a degree of rotation around that point. I have a non-spatial CSV setup to get fed this rotation data from ...
1
vote
3answers
94 views

QGIS, a simple way to enable colleagues access to tabular data?

This question may sound like it's a bit vague, but I think that lots of people seem to face similar issues, and on this occasion a general answer seems better than a specific focused one: I use ...
1
vote
1answer
72 views

QGIS delimited text import CRS not being defined

I've recently updated to both the long term release and 2.10 versions of QGIS and the delimited text plugin has stopped working. Everytime I try to add a CSV file and say ok on the plugin it no ...
1
vote
1answer
88 views

Add date field to imported csv file

I am using a script written by John to import a csv file and make a point feature class. My table looks like this: "timestamp_pretty","mmsi","imo","shipType","lat","long","month","week" "31/12/1969 ...
0
votes
2answers
130 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 ...