Articles by mikerspencer
Spatial data and maps conference – FOSS4G
I’m helping organise a conference on (geo)spatial open source software – FOSS4G. We’re hosting it in the great city of Edinburgh, Scotland in September 2019. Abstract submissions: https://uk.osgeo.org/foss4guk2019/talks_workshops.html We’re very interested in hearing… Continue reading →
Plotting Scottish census data with some tidyverse magic
I’ve been working with the Scottish census recently, to investigate employment in land-based (agriculture, forestry and fishing) industry. A friend of mine has recently moved to Dumfries and Galloway – a rural, farming… Continue reading →
I fell out with tapply and in love with dplyr
Monitoring electricity use
Many reports from 1 RMarkdown file
I was at the EdinbR talk this week by the RStudio community lead – Curtis Kephart. It was really interesting, but I disagree with his suggestion to point and click different parameters when… Continue reading →
[Read more...]
Presenting survey data
Ordnance Survey Terrain 50: merging in R
I’ve written previously about Ordnance Survey’s Terrain 50 data and how you can merge it together. You can download the dataset from the OS’s opendata repo. I’d like to update that post with… Continue reading → [Read more...]
GB postcode polygons – open data
dplyr, (mc)lapply, for-loop and speed
Want to know whether lapply is quicker than a for-loop? Is there a faster solution? This is the place!
DfT traffic count data in R
I read this tweet thread yesterday, and one of the great things in it was discovering that the Department for Transport release traffic count data for Great Britain. When you download individual observation… Continue reading →
Getting started with spatial data in R – EdinbR talk
Slides from January 2018 EdinbR session on spatial data in R. [Read more...]
Network analysis video – 7th Scottish QGIS user group
Network analysis presentation from the 7th Scottish QGIS user group. Featuring Ordnance Survey open data, QGIS, GRASS and R.
[Read more...]
Spatial networks – case study St James centre, Edinburgh (2/3)
This is part two in a series I'm writing on network analysis. The first part is here. In this section I'm going to cover allocating resources, again using the St James' development in Edinburgh as an example. Most excitingly (for me) the end of this post covers the impact of ...
Celebrating 20 years of CRAN
In April I spoke for the Royal Statistical Society (Glasgow branch) at their event celebrating 20 years of CRAN. The other speakers were Charis Chanialidis and Colin Gillespie. Like most people I find… Continue reading →
[Read more...]
Spatial networks – case study St James centre, Edinburgh (1/3)
Last year I spent a bit of time learning about routing and network analysis. I created a map of distance from each GB postcode to the nearest railway station. At the time my… Continue reading →
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 → [Read more...]
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 → [Read more...]
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 → [Read more...]
Copyright © 2022 | MH Corporate basic by MH Themes