Tag Archive: R

RPostgreSQL and schemas

The database PostgreSQL can have different schemas. These work like a window for users, where they get to see specific things within a database, e.g. tables. In this post we’ll look at how… Continue reading

R with GRASS GIS – easiest Munros

I’ve been having a more sustained play with R and GRASS together. I’ve previously used them, in tandem, for processing satellite images, but haven’t been much further. In this post I’ll look at… Continue reading

R – iteratively changing column classes

When you write an ESRI Shapefile from R, writeOGR assumes your numeric fields are real numbers and so you get a lot of redundant zeros appended. This is misleading and distracting when you… Continue reading

R – Change columns names in a spatial dataframe

Ordnance Survey have a great OpenRoads dataset, but unfortunately it contains a column called ‘primary’, which is a keyword in SQL. This makes it challenging/impossible to import the OpenRoads dataset into a SQL… Continue reading

Converting (British) National Grid references

I was supplied spatial point data this summer where the locations were detailed in Ordnance Survey’s National Grid (NGR) format. If you’re not familiar with it, rather than using eastings and northings (in… Continue reading

EARL 2016 talk

I spoke on 14th September at the EARL (Effective Applications of the R Language) conference in London. This is event is concerned exclusively with the R programming language and it was the first… Continue reading

Hydrological uncertainty – Manning’s equation

John Yagecic put out a great little blog post with accompanying app this week. He looked at the uncertainty from using vague parameters in Manning’s equation to estimate river flow. He made the… Continue reading

Monthly patterns in Scottish snow (1946-2006)

There’s been a bit of a flurry on Twitter recently about April snow in the UK (see tweet below). My opinion is there’s often UK snow during April, but it happens to be… Continue reading

Colouring a plot using a continuous variable in R

I often find myself coming back to this answer I gave on Stack Overflow in 2014. It shows how to colour a plot based on an independent continuous variable using the base graphics… Continue reading

Getting started with NetCDF – reading CEH GEAR

Last year CEH released an interpolated precipitation dataset for the UK call GEAR. You can read about this dataset here, or view slides presented at the 2014 BHS Symposium here. In short; these… Continue reading