Showing posts from 2019

rollApp rollApp...

Ever get fed up with installing software then upgrading every so often? 'rollApp' is another example of 'SaaS' but larger government departments and companies may find the cost of doing this work often more than the cost of the pricing polices of running the software in the 'cloud'. In the UK this amounts to £71.88 or £5.32 a month (at time of writing) for individual accounts. There is a discount if your on the 'premium for groups' level which is £471.59 a month for 100 users. A quick search on the apps reveals that there appear to be all of the FOSS applications you would need including spatial and mapping ( 'RStudio'). I've tried the 'free' tier and the performance is very good and usable as long you don't 'save' anything to local disk or cloud. Worth a try even just for the convenience of being able to use your applications on any device!

Business Intelligence: Using R Dataframes in Power BI Desktop Reports


FOSS4G 2019 Bucharest Presentations

As usual some exciting stuff going on around Open Source Geospatial. Education Materials

CERN moving away from Microsoft?

How to set up a leaflet map which connects to your Postgres/PostGIS layers using 'RStudio-Server' and 'Shiny-Server'

For those potential GI users who are too busy to learn GIS skills but need to know where those boundaries are, this could be the answer for you. Through a simple leaflet map we can connect directly into our spatial data in PostgreSQL/PostGIS data with 'R' and 'Shiny'. For more information click the link. In the example below we are going to install 'RStudio-Server' on an Ubuntu 18.04 LTS server in order  to run an 'R' script although I could just as easily have created this script using any other IDE or text editor if preferred. 'RStudio' is a complete environment for prototyping web apps (known as 'Shiny' apps) which allow the user to interact with the data imported from various sources for example to look into changes over a ten year timescale interactively from an excel spreadsheet. 'RStudio-Server' is a free and open-source integrated development environment (IDE) for R, a programming language

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:- My choice for interrogating a CSV/txt file:-

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