Posts

RStudio - A good first tutorial using a simple spreadsheet

As a complete newbie of 'R' I asked the community for a nice gentle introduction. Below are the suggestions they sent me:- http://zevross.com/blog/2016/04/19/r-powered-web-applications-with-shiny-a-tutorial-and-cheat-sheet-with-40-example-apps/ https://github.com/rstudio/shiny-examples http://www.open-meta.org/technology/a-totally-different-read-me-first-shiny-tutorial/ My choice for interrogating a CSV/txt file:- http://web.cs.ucla.edu/~gulzar/rstudio/basic-tutorial.html

Joplin - An Open Source alternative to Evernote

I never thought I would need a 'to-do' list or a 'note taking' application before. I turn up at meetings with my trusty black pocket book and a pen. How 'old school' I hear you say but I am always late to the party. I signed up to Evernote some years ago but that is as far as I got. Now I cannot stop adding stuff to remember in 'Joplin'. So what is so different about this syncing 'to-do' app (compared to the Evernote free version)? Evernote has no 'markdown' support. Evernote has no 'end to end' encryption. Evernote has a two device limit. Evernote cannot work offline. Evernote isn't open source. The name 'Joplin' comes from composer Scott Joplin "Joplin is a free, open source note taking and to-do application, which can handle a large number of notes organised into notebooks. The notes are searchable, can be copied, tagged and modified either from the applications directly or from your own text editor...

Proud to be a sponsor of UBports

Image
I'm extremely proud that I can play a very small part in this amazing project to get Ubuntu Touch on Mobile devices. https://ubuntu-touch.io/get-ut

How to install Postgresql-10 and PostGIS-2.4 on Ubuntu 18.04 LTS (Bionic Beaver) in six easy steps (updated 26-11-2018).

Install Ubuntu 18.04 LTS (Bionic Beaver) 1. check your Ubuntu version:- lsb_release -a Install Postgresql 2. On the server or your PC (Terminal):- sudo apt-get update sudo apt-get install -y postgresql postgresql-contrib Create a database and a user for access Replace  DATABASE_NAME_HERE  and  USER_NAME_HERE  with the values you want to use. # this will prompt you for a database password...also note the capital letter 'O' not number '0' (zero) below:- 3. sudo -u postgres createuser -P USER_NAME_HERE sudo -u postgres createdb -O USER_NAME_HERE DATABASE_NAME_HERE Test Connection to Postgresql 4. psql -h localhost -U USER_NAME_HERE DATABASE_NAME_HERE Postgresql will ask you for your password. Then you should see the following: DATABASE_NAME_HERE => To exit type:- \q To add PostGIS-2.4 support to the database 5. sudo apt-get install -y postgis postgresql-10-postgis-2.4 sudo -u postgres psql -c "CREATE EXTENS...

Selecting and extracting subtle landscape changes to a shapefile using Grass GIS and QGIS

Image

vrt2GeoPackage Rasters

Image
My previous post didn't mention how to setup the Ordnance Survey layers (or any other raster and vector combination) in a single GeoPackage from virtual rasters, so I thought i would elaborate on the 'gdal_translate' part. It's quite easy...you can simply cut and paste this command in Linux or Windows. Remember to substitute with your own paths with your virtual raster layers. The advantages of the GeoPackage format in QGIS3 are not only speed of map scrolling and zooming but the ability to store (in a database table) your map 'styles' and zoom levels (for vector layers) within when needing to work offline or with Qfield. Also remember that you do not need to include the .vrt extension. Before you start install and open QGIS 3.0 and then open the 'Browser' and select 'GeoPackage' then right click 'Create database'. You will then see the panel below. Enter a database name for your new GeoPackage and leave everything else as ...

GeoPackage Ordnance Survey Data for QGIS 3

Image