Tag Archives: SQLite

Sum up values of neighbouring polygons – a GRASS GIS approach

Posted on January 4, 2013 by

How to sum up values of neighbouring polygons in QGIS? This question was asked on gis.stackexchange, with two interesting answers. One answer explains how to use Spatialite and SQL to achieve this. The other answer, explained in more detail here, presents … Continue reading →

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

Find and select duplicate values in your vector attribute table

Posted on May 4, 2012 by

Suppose you have a vector layer in your GRASS GIS database and you want to find all duplicate values in one of the columns of the attribute table of that layer? If you are using SQLite or PostgreSQL as the … Continue reading →

Posted in Data handling, GRASS GIS, SQLite | Tagged , , , , | Leave a 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

Concatenate in SQLite

Posted on September 14, 2011 by

I wrote before on using concatenate in OpenOffice / LibreOffice and how this alternatively can be done in R using the paste function. You can do the same in SQLite using a query too.

Posted in Data handling, 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

Finding and removing carriage returns in your SQLite table

Posted on January 13, 2011 by

The problem with copy data from e.g., an excel or calc sheet into an SQLite database (or any database I reckon) is that the data you copy might include an carriage return. I found this out the hard way after … Continue reading →

Posted in Data handling, GRASS GIS, SQLite | Tagged , , , | 2 Comments