GRASS GIS 7.6.0 released

After almost 1 year of development the GRASS Development team has released the new stable release GRASS GIS 7.6.0. A big thanks to all developers for their work and dedication!

There is a lot to like, including further improvements to the user experience and new useful additional functionalities to modules. I, for example am curious to try out the new raster map type, the GRASS virtual raster (VRT). This is a virtual mosaic of a list of input raster maps.

But I would say, head over to the overview page where you can read more about the new features in the 7.6 release series: new features in GRASS GIS 7.6. Or update GRASS and check out yourself.


Draw a histogram of vector attribute column in GRASS GIS

GRASS GIS has convenient tools to draw histograms of raster values. As similar tool to draw a histogram of values in a vector attribute table lacks. But you can easily add this functionality by installing the d.vect.colhist addon by Moritz Lennert. Read this short post on tutorials.


Check out this article ‘Let the four freedoms paradigm apply to ecology’ (but don’t get it from ScienceDirect)

There is an interesting letter (Let the four freedoms paradigm apply to ecology) in Trends in Ecology and Evolution by Duccio Rocchini and Markus Neteler arguing that science should use open source software. Basically, using open source software will help researchers to test, reproduce and build upon work of others, while being (more) sure that the code / algorithms they are using are robust and reliable. Continue reading “Check out this article ‘Let the four freedoms paradigm apply to ecology’ (but don’t get it from ScienceDirect)”

Split strings in SQLite

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 as it plays nicely together with QGIS as well as R. For example, importing the waypoint data (gpx format) into a spatialite database is a breeze with the QSpatialite plugin for QGIS.

One problem is that data and time in the gpx file are given in one field, in the form ‘2011/11/01 5:49:41+00‘. There are various ways I could split this before importing in the SQLite database, e.g., using R or a spreadsheet. But how to do this after importing the data in the Spatialite database? The date + time are imported in the field ‘time‘. Continue reading “Split strings in SQLite”