Ardnamurchan has excellent birdwatching. In a relatively small area it has a variety of habitats – mountain, moorland, all types of woodland, raised bog, coast, sea and freshwater lochs, machair and just about everything in between.
Bird Watching magazine published are article on birdwatching on Ardnamurchan in 2013 calling it Scotland’s Hidden Gem.
I’m an amateur, but enthusiastic, birdwatcher. Like many birdwatchers I try and keep a running list 1 of what I see locally (my patch) and on my travels.
I’m not a twitcher. I don’t chase rarities, I don’t keep monthly, annual or geographic records. I’m hopeless at discriminating between most of the Phylloscopus (leaf) warblers (and gulls 2). I do however have a vague idea of the – very extensive – list of UK birds I have never seen and enjoy reducing the number when I have the chance.
It’s always good to know what might be seen in a particular area i.e. what has been seen before and is therefore likely to turn up again.
Or that’s there all the time if I was only a bit more observant 😉
The BTO open mapping bird atlas data
Fortunately, thanks to thousands of volunteers and the British Trust for Ornithology, there are outstanding records of overwintering and breeding birds for the entire country. This dataset now contains ~1.4 million records covering ~450 species between 1968 and 2011. It is updated every couple of decades.
This data is at 10 km resolution (i.e. was a bird present / breeding in a particular 10 km square?). More recent surveys have been conducted at much higher resolution (based upon 2 km tetrads) and now include ~20 million records covering 99.9% of the country.
Until recently this data was only available in book form, but the 10km resolution data is now freely available online. For any species you can view a map of the UK showing if and where it is present in the winter, and whether it possibly, probably or definitely breeds here in the summer.
Inevitably, the maps are rather low resolution. You can just about see Ardnamurchan, but it’s not obvious. The BTO also offer a variety of other ways to view the data, such as providing lists of birds by searchable map reference or postcode.
Local lists of local birds
Not only can you query the dataset interactively, you can also download the bird distribution data as compressed ZIP format comma-separated variable (CSV) text files. Uncompressed the files total about 125Mb. The largest is the geographic and temporal distribution data which runs to ~1.5 million lines. Don’t try opening it in Excel (which is probably the default for this file type on your computer) as it can’t cope with more than ~1 million rows 3.
A wet spring weekend seemed like the ideal opportunity to generate an Ardnamurchan-specific bird list. CSV files are trivial to manipulate using a simple scripting language such as perl or python. What could possibly go wrong?
10 km resolution
Of those 1.5 million records, only a subset are relevant to Ardnamurchan. The rest of the country we can safely ignore.
The first challenge is to determine which 10 km squares overlay the ~30 km x ~10 km Ardnamurchan peninsula. The BTO uses the same grid overlay used by the Ordnance Survey and the latter provide a very useful tile locator map. If you select the relevant 100 km square (NM) you are taken to a more detailed view showing the individual labelled 10 km squares.
The numbering of these squares represent the first digits of the Eastings and Northings coordinates of the grid reference. For example, Acharacle primary school is at NM 674 681 and is in the top right hand (north west) corner of NM66.
NM47, 57, 67, 46, 56, 66 covers Ardnamurchan in its entirety 4, together with bits of Muck, Moidart and a small wedge of Morvern. That’ll do.
For the moment the only two data files that are of relevance are the lookup table of species (species_lookup.csv) and their distribution (distributions.csv).
distributions.csv has eight fields including the survey period, season, species (the id number only), 10 km reference square and whether breeding was possible, probable or confirmed. I’ve ignored the additional fields for the moment. With ~1.5 million lines in the file there are multiple records for each 10 km square and for each species.
For example, there are 2082 records for the six 10 km squares covering Ardnamurchan and 9290 records for the Barn Owl (Tyto alba) covering the entire country.
Of these, only seven intersect. The Barn Owl is present in five squares during the winter, but breeding is only suspected or known in NM67 and NM56.
This doesn’t really qualify as ‘big data’ but untangling it is too much to handle with just a pen and paper 7. Instead, it’s a trivial exercise to spend a wet afternoon (when I couldn’t do any beekeeping) writing some perl scripts to extract the relevant records for presentation.
Data mangling and untangling
The historical information in the BTO Bird Atlas data is of less interest to me (at the moment at least 8). I’m interested in the most recent reports from the winter and breeding season records … these are the birds I (and visitors to Ardnamurchan) are most likely to see now.
Following the usual cycle of code, debug, coffee, code, debug,
coffee pizza I had something that just about worked.
A total of 143 species overwinter, breed or both on Ardnamurchan. Of these, 26 (mostly overseas migrants like the cuckoo and willow warbler) are absent in winter. In contrast, 34 species are either absent in the summer or do not breed on Ardnamurchan.
Unsurprisingly considering the limited land area present in NM47 and NM57, these 10 km squares have the smallest number of summer or winter species:
- NM47 – winter 59, breeding 56
- NM57 – winter 49, breeding 48
- NM67 – winter 83, breeding 89
- NM46 – winter 66, breeding 89
- NM56 – winter 77, breeding 81
- NM66 – winter 103, breeding 90
It’s worth noting here that presence alone in the summer is not recorded for any species on Ardnamurchan. Just because a particular species does not breed does not mean there is no chance of seeing it 9. For example, I’ve regularly seen gannets in Loch Sunart though they don’t breed on the peninsula.
Having sliced and diced the BTO data it now needed to be presented in a readable format.
Rather than just present a ‘flat’ list of birds it seemed logical to include links to relevant information online. For example, to the BTO Bird Atlas maps of the entire UK for the winter and breeding season distributions and to the BTO Bird Facts data.
This turned out to be a little bit more complicated than it should have been. The BTO appear to use two different numbering schemes.
Species in the BTO Bird Atlas use a taxonomically-organised sequentially-numbered list of UK species. I’ve mentioned the red throated diver (#1) and Blue-crowned Parakeet (#1663) previously. In contrast, the Bird Facts pages are referenced using the 5 digit EURING code used by bird ringers. The EURING code for the Red throated diver is 00020 10.
Initial attempts to find the Blue-crowned Parakeet on the EURING list failed which highlighted a second problem 11. The scientific names (the only sort of names used) on the EURNG lists are sometimes different from the BTO lists. This happens when birds are reclassified. On the BTO the Blue-crowned Parakeet is Thectocercus acuticaudatus whereas EURING lists it as Aratinga acuticaudata. D’oh!
I cross-referenced the two lists automagically using a short perl script and then manually corrected the dozen or so species from Ardnamurchan that disagreed between BTO and EURING systems 12.
Inevitably this manual bodge will break things in the future …
A picture is worth a thousand words
One of the problems with the BTO Bird Atlas maps is that the Ardnamurchan peninsula is rather difficult to see. I therefore created a series of small 3×2 gridded icons representing the six NM-prefixed squares that cover the peninsula. I used one icon for the winter distribution and one for the breeding distribution (with probability indicated by different sized ‘blobs’, just as they are on the BTO Bird Atlas maps). For example:
This icon represents a species that is recorded in all but NM57 in winter.
This icon indicates a species which possibly breeds in NM46, probably breeds in NM66 and NM67 and that breeding has been confirmed in NM56 and NM57.
There are ~132 different distributions of birds in the winter and breeding seasons. Rather than draw any of the icons by hand I used ImageMagick to create them automagically, called from a perl script that read the underlying data directly from the distributions.csv file.
I also added a notes column, but this has yet to be populated.
The finished list of Ardnamurchan birds in the most recent BTO census is linked from the menu above, or directly from here (and is also available in PDF format). It will be updated as and when new BTO census data is released.
- It should be noted that for security reasons the breeding distribution of some rare birds is deliberately listed (by the BTO) at lower resolution.
- There’s a second minor problem with the BTO Bird Atlas maps. They are displayed via a server which separates the delivery of the map from the menus that control the data displayed or its appearance. This means I could either link directly to the maps (and have no menus) or to link to the default map for a species and subsequently select the desired map (which has to be done interactively). The default map is the most recent breeding distribution, so this is linked from the ‘summer’ icons. Until I find a way to access the winter distributions and menus I’ve left the ‘winter’ icons linked directly to the relevant map alone.
- The Blue-crowned Parakeet (Thectocercus acuticaudatus) is a small green South American parrot with a blue head. They inhabit Neotropical savanna-like habitats, woodland and forest margins from eastern Columbia to northern Argentina. Not Ardnamurchan 😉
- In my head … I’m not organised enough to write it down.
- Though I can tell the difference between a Chiffchaff and a Greater Black backed Gull … it’s the call isn’t it?
- Anyway, it doesn’t make particularly interesting reading …
- Defined at its eastern limit by the A861 Salen to Acharacle road.
- Which includes 465 species from #1 (Red throated Diver – a resident breeding bird on Ardnamurchan) to #1663 (Blue-crowned Parakeet – unaccountably absent as I would think the habitat was perfect). Clearly the numbers are not sequential, presumably explained by the list containing a number of rarities, vagrants and escapees at the end derived from a much bigger list covering a larger geographic area.
- For example, #475, the Common/Lesser Redpoll, Acanthis flammea/cabaret is a species aggregate.
- You want big data? The recent imaging of a black hole involved recording 5 petabytes of data by the Event Horizon Telescope. That’s equivalent to about 5000 years of MP3 music. So much data in fact that it was stored on half a ton of hard drives and transported by plane, rather than being transmitted over the network. That’s big data!
- And it is available on the BTO website if needed.
- Within reason … the Blue-crowned Parakeet is likely to be a no-show I’m afraid.
- With leading zeros usually dropped when using the number.
- Please note that I wasn’t really worried I’d somehow overlook this species in preparing the lists, or that if I did it would matter. The Blue-crowned Parakeet is the last record on the BTO UK species list in the species_lookup.csv file. Therefore, running the cross-referencing scripts returns it as the last line of the output. It’s therefore easy to see. There are a others missing which do occur on Ardnamurchan.
- These were a couple of ducks, black-headed gulls and a few finches like siskin, linnet, greenfinch.