Most Remote Building in Ireland

Introduction

I read a few excellent blog posts over the last number of years regarding how to calculate remoteness of buildings from each other.

The two that stand out for me are Topi Tjukanov’s Searching for Isolation with GIS and Simon Wrigley’s Finding the most remote buildings in Britain which offer excellent methodologies on how to find the most remote building in Flanders and Britain respectively . I have always been curious as to the most remote building* in Ireland (as measured from another building).  I have been waiting (almost with bated breath) for Microsoft to release a building footprints dataset for Ireland, which they did earlier last year

*Note – I thought long and hard and for this purpose, I am only interested in the most remote building from another building. For the purposes of this analysis, the building cannot be a ruin and must be weathertight. 

Data Download and Processing

I downloaded the data for Ireland (using the provided scripts). As GeoJSONs aren’t an appropriate format to work with, I used GDAL’s ogrmerge.py command to merge all them into one, reproject to the Irish Transverse Mercator (EPSG: 2157) and output it as one GeoPackage file. I then uploaded the GeoPackage to a PostGIS database (using GDAL) in order to be better able to work with it.

Below is an overview of the building footprints — it is obvious that there are two substantial areas missing around Dublin and Limerick. The dataset contains 2,270,112 buildings and the quality in places is dubious due to how it was created. I found a number of instances of silage pits and rocks etc. being mistaken for buildings. It’s a great effort by Microsoft to compile and, frankly, it’s the only dataset available as Tailte Éireann (the newly created public body with responsibility for mapping, property registration and valuation) has not released anything akin to the UK Ordnance Survey’s OpenMap Local Buildings product.

Building Footprints of Ireland from Microsoft

Building Footprints of Ireland from Microsoft

Missing Data

There are two large areas clearly missing from the above dataset, Greater Dublin and Greater Limerick. To get a sense of the problem, I downloaded population data from WorldPop, digitised the missing areas and used Zonal Statistics to calculate that the missing areas contain approximately 206,335 people in Greater Limerick and 2,117,635 for Greater Dublin (as shown below).

Missing Building Footprints - Greater Limerick

Missing Building Footprints – Greater Limerick

Missing Building Footprints - Greater Dublin

Missing Building Footprints – Greater Dublin

The two polygons shown above contain approximately 46% of the population of the country. Ordinarily, missing buildings over an area of the country that includes nearly half of its population would be a terrible outcome. The inverse held true for this analysis though;  the more populated an area is, the more buildings it contains and the less likely it is to contain the most remote building in the country from another building. That’s not to say that the most remote building in the country isn’t located in these are, just that it’s unlikely.

There are two obvious areas within both these polygons that could contain the most remote building, the islands in the Shannon Estuary and the Wicklow Mountains National Park. To give me some idea that the most remote building wouldn’t be in these areas, I manually (rather quickly) used the MapGenie basemap on Geohive to look for buildings. In the missing Limerick polygon, there were only two candidate areas that might contain the most remote building, one on Feenish and one on Inishtubbrid (neither of which was a greater distance to another building than the building identified at the end of this analysis).  For this area I also looked at the Slieve Bearnagh range which didn’t produce any building greater than 500 metres from another building.

For the Wicklow Mountains, I examined the MapGenie basemap in detail but no immediate contenders were apparent.

Shannon Estuary Islands

Shannon Estuary Islands – Contenders for Most Remote Building

Analysis

I am indebted to Topi and Simon, and it’s Simon’s methodology I’m following here (almost to the letter). In order to reduce the computing power and time required, I did two things; I converted the building footprints in PostGIS to points (using ST_Centroid), and I used MMQGIS to create a 3km hex grid in QGIS that I imported into PostGIS using the below command. I then clipped the hex grid to the outline of Ireland and created spatial indexes for all tables.

 ogr2ogr \
-f "PostgreSQL" PG:"dbname='Ireland_Buildings' host=localhost port=xxxx user= 'postgres'" \
-nlt PROMOTE_TO_MULTI \
"Ireland_Admin_Outline.shp"

I adapted Simon’s very helpful building count SQL query and mapped it the buildings per hexagon (shown below).

Building Count - Ireland

Building Count – Ireland

To reduce processing time, Simon counted the building footprints for each hexagon and only focused on the hexagons that had ≤1 building per grid cell. Because of the nature of the geography of both countries (essentially, the remoteness afforded by the Scottish Highlands), this exact approach wouldn’t work for Ireland. After some careful experimentation, I chose ≤5 as the number to use.

 

Less than or equal to 5 buildings per hexagon

Less than or equal to 5 buildings per hexagon

The results accord well with areas of the country that one would consider remote as they don’t have the best quality agricultural land (such as West Connaught). It is important to state here that I ran several iterations of the above with various numbers of buildings and then followed Simon’s step of merging the resultant grid cells and buffering the cluster by 1km in order to find the most remote buildings. This took a considerable amount of time and I think I deleted about 50 contenders through this process.

Method: K-Nearest Neighbours

Simon did some excellent work creating Voronoi polygons to give a visual indication of the most remote building. If I’m being honest, I skipped this step and went straight to a nearest neighbour analysis. I’m not going to reinvent the wheel here so please have a read of Simon’s excellent methodology for the detailed SQL code.

I ran the nearest neighbour analysis (limiting the results to the top 10) and methodically went through all of them to see whether the first entry (being the most remote building listed was correct) and—🥁—it was.

Bearing in mind that Ireland isn’t a particularly large country with vast remote areas etc. I wasn’t expecting the result to be a huge distance. I had discounted a lot of buildings along the way that were clearly not weathertight (such as the below) and, through that process, I knew the final result wouldn’t be numerically impressive.

False Positive - Cleary not weathertight

False Positive – Cleary not weathertight

Most Remote Building

I think it’s crucial here to reiterate the main caveats to this answer, those are:

  1. The dataset was created using machine learning (limitations being a large number of false positives and potentially missing buildings); and
  2. There are areas around Dublin and Limerick missing that may contain a more remote building.

All that being said, the most remote building is:

Blackhead Lighthouse, Burren Co. Clare - 2,270 metres to Nearest Building
Black Head Lighthouse, Co. Clare

Black Head Lighthouse, Co. Clare

It’s quite interesting that the lighthouse is in the Burren, Co. Clare, which is a karst landscape that is >500km² in area. I’ve inspected it on StreetView and it appears to meet the main criteria (i.e. weathertight). To ensure that there wasn’t any nasty surprises I again examined the MapGenie basemap on Geohive and, thankfully, there were no missing buildings in the vicinity. A very interesting structure to be the most remote (you can read more about it, including a detailed history, on the Commissioners of Irish Lights website).

Black Head Lighthouse by Yair Haklai is licence under a under the Creative Commons Attribution-Share Alike 4.0 International license.

Black Head Lighthouse by Yair Haklai is licence under a under the Creative Commons Attribution-Share Alike 4.0 International license.

CAVEAT

This was the most remote building based on the data available and the methodology used. I will rerun the analysis if and when the entire country becomes available. If you’ve gotten this far, thanks for reading.

Driving from Perth to Sydney

I’ve driven from Perth to Sydney and back so I was curious as to what the route would look like overlaid on Europe so here it is. If you went the same distance west from Dublin you’d get to a small town in Labrador and Newfoundland called North River (population 579 in 2021).

Driving Route from Perth to Sydney overlaid on Europe

The driving Route from Perth to Sydney overlaid on Europe

 

Ireland’s Population by Altitude

I read Alasdair Rae’s very interesting post where he created a graph of Great Britain’s population by altitude. Using WorldPop data and the EU DEM I used QGIS, Seaborn and Inkscape to create the following graph for Ireland. I must do a bit of digging to see whether the 400 – 500 metre slight bump can be explained by a discrete area…

 

Horizontal bar plot showing Ireland's population by altitude

Horizontal bar plot showing Ireland’s population by altitude

Knockanore Hill

I was home recently and drove up to the top of Knockanore, a hill just outside Ballybunion, Co. Kerry. Its elevation is 267m and is by far the highest hill in this part of North- Kerry. This got me curious — how much of Kerry is greater or less than this elevation? Below is a quick map I put together from the EU-DEM courtesy of the European Environmental Agency. It turns out 267m is higher than 82.7% of the county, interesting. There’s a story that does the rounds colloquially in North Kerry that, on a clear day, it’s possible to see five counties from this elevation. If I’ve time in the next few weeks I’d like to create a viewshed to test this.

 

Knockanore, Co. Kerry, Ireland

Knockanore, Co. Kerry, Ireland

 

Knockanore, Co. Kerry, Ireland

Knockanore, Co. Kerry, Ireland

Birthplaces of Irish Taoisigh

I made a quick map during the week of the birthplaces of Irish Taoisigh. The below gives a quick overview however I thought putting a cartogram together also might below. No surprise to see Dublin has the most. I know we’re a young country but I found it interesting the number of counties that haven’t had a Taoiseach.

 

Birthplaces of Irish Taoisigh

Birthplaces of Irish Taoisigh

Cartogram - Birthplaces of Irish Taoisigh

Cartogram – Birthplaces of Irish Taoisigh

 

Halloween Map – Castles of Europe

For Halloween this year I wanted to create a spooky, atmospheric map. I settled on mapping the castles of Europe including Bran Castle. I know that Bran Castle doesn’t actually have any historical links to Bram Stoker but I thought it would be nice to include given it’s reputation. I came across a great website called https://download.osmdata.xyz/. It allowed me to easily download a geopackage of all the historic tags from OSM.

Now the the elephant in the room — the actual castle data. I filtered the data by historic=castle. I has tried filtering it by categories such as castle_type but there just wasn’t enough tagged to make a nice map. People commenting on Reddit have been at pains to point out how inaccurate the map is and by and large they are correct. It’s the best that could be make with the data available and I usually wouldn’t publish something where I know the data wasn’t up to scratch however as this was only meant to be a fun Halloween map I thought an exception could be made!

Anyway, I hope you enjoy it (above data caveat aside) as much as I enjoyed making it. Happy Halloween!

Castles of Europe

Castles of Europe

Australia – Place Names Ending in ‘UP’

I was having a chat at work recently about the place names in Australia that end in ‘up’. It comes from a dialect of the Noongar Aboriginal language of Australia and means ‘place of’. Below are two quick maps I put together. You can clearly see the concentration in the Noongar region of South-West Western Australia.

Place Names Ending in 'Up'

Place Names Ending in ‘Up’ – Australia

Place Names Ending in 'UP'

Place Names Ending in ‘UP’ – South West, Western Australia

Ireland – Densest 1km² per County

I’ve been writing a lot about population density at the moment and it got me thinking about density in Ireland. We all know we’re pitiful in terms of other European countries and we know from census 2016 that we’re sitting at 70 persons per km². What I’m curious about is what’s the densest square kilometre in each county?

It is import to note that the densest square kilometre in each county below is the densest square kilometre from a predefined 1km² grid for the entire country which is manifestly different from the true densest square kilometre in each county but it’s the best data I have access to as a member of the public. If you want to read more about this issue it’s called the modifiable areal unit problem. A simple image to explain this is show below. From a predefined grid that’s draped over the country we can see that cell 3 would be the most dense 1km² however if a cell was placed where cell 5 is we can see that it would be densest 1km² by a large amount, that in a nutshell is the MAUP problem.

Grid Shortcomings

Grid Shortcomings

 

I used the ’16 census data to generate the below maps to answer the question for each county. What clearly stands out for me is that for a lot of counties it’s housing estates that make up the densest square kilometre. Hopefully with Project Ireland 2040 now in place we can start to do better and go towards sustainable densities throughout the country.

Carlow

1. Carlow

Hyperlinks to maps for each of the other counties:

  1. Carlow
  2. Cavan
  3. Clare
  4. Cork
  5. Donegal
  6. Dublin
  7. Galway
  8. Kerry
  9. Kildare
  10. Kilkenny
  11. Laois
  12. Leitrim
  13. Limerick
  14. Longford
  15. Louth
  16. Mayo
  17. Meath
  18. Monaghan
  19. Offaly
  20. Roscommon
  21. Sligo
  22. Tipperary
  23. Waterford
  24. Westmeath
  25. Wexford
  26. Wicklow

I realised with the above images that I forgot to include part of the label that showed where in each county the location was. Below are the same maps as above but they now include the location and the lat, long for each square kilometre. Maybe both versions can be used for a very nerdy quiz??

  1. Carlow
  2. Cavan
  3. Clare
  4. Cork
  5. Donegal
  6. Dublin
  7. Galway
  8. Kerry
  9. Kildare
  10. Kilkenny
  11. Laois
  12. Leitrim
  13. Limerick
  14. Longford
  15. Louth
  16. Mayo
  17. Meath
  18. Monaghan
  19. Offaly
  20. Roscommon
  21. Sligo
  22. Tipperary
  23. Waterford
  24. Westmeath
  25. Wexford
  26. Wicklow