Category Archives: Spatialite

Spatialite 4.0 is out

Posted on November 30, 2012 by

The release of Spatialite 4.0 was just announced on the Spatialite user group. You can download it from the Spatialite website. And while you are on the website, check out the page about switching to 4.0. Version 4.0 introduces several … Continue reading →

Posted in GIS, Software release, Spatialite, SQLite | Tagged , | Leave a comment

From xy table to spatial table in spatialite

Posted on July 30, 2012 by

A short note on how to create a spatial table from a table with latitude and longitude coordinates in your SQLite / Spatialite database. In the example below, the table I am working with is ‘labels’.

Posted in Data handling, Spatialite | Tagged , | Leave a comment

Reprojecting your layer in Spatialite

Posted on July 4, 2012 by

I have a vector layer ‘nursery data’ in a Spatialite database. The coordinate reference system of the layer is WGS84 geodetic (EPSG 4326). What if I need to reproject the layer in WGS84/UTM37N (EPSG 32637)?

Posted in GIS, QGIS, Spatialite, SQLite | Tagged , , , , , , | 1 Comment

Extract X and Y coordinates from a spatial table in Spatialite

Posted on February 21, 2012 by

A quick note on adding two columns with X and Y values in a vector layer in spatialite. Spatialite stores the information about the geometry in binary format in the ‘Geometry’ field. You can use the Spatialite function AsText() to … Continue reading →

Posted in Data handling, Spatialite, SQLite | Tagged , , , , , | 1 Comment

Split strings in SQLite

Posted on February 14, 2012 by

I am just back from vegetation survey in Kenya and Uganda. Before starting with the analysis, I will have to go through the more boring data entry and organization. I will use a Spatialite database to store all the data … Continue reading →

Posted in Data handling, QGIS, Spatialite, SQLite | Tagged , , , , , , , , | Leave a comment

SQLiteMap

Posted on May 2, 2011 by

Looks interesting, a R package that provides bindings to Spatialite functionalities. Through this bindings one can carry out the spatial functions available in Spatialite from within R using simple SQL statements.

Posted in GIS software, R computing environment, Spatialite, SQLite | Tagged , , , | Leave a comment

Select random sample from SQLite table

Posted on April 16, 2011 by

I came across this post by underdark about how to select a random sample from a table in PostgreSQL. You can achieve the same (selecting 1000 random features from a table) in SQLite using something like below:

Posted in Data handling, GIS, Spatialite, SQLite | Tagged , , , , | Leave a comment

New spatialite plugin for QGIS

Posted on March 30, 2011 by

For some time now it is possible to load SpatiaLite data layers in QGIS. It is read only though, any changes will need to be saved as shapefile. There is a Spatialite manager plugin, which offers an interface to the … Continue reading →

Posted in GIS, GIS software, Spatialite, SQLite | Tagged , , , , | 1 Comment