Why can’t I add an index for a nullable Mysql POINT column?
November 2020
-
-
-
There are currently 285 proposals in this year’s Wishlist Survey: https://w.wiki/oB7 This is more than ever before! Which is great, but there’s lots to get through (I’m reading all of them). Some are terrific, some are huge, some are simple, and they’re all a fascinating insight into how people work with Wikimedia wikis and what difficulties they feel. I’m really happy to be working on this.
-
-
-
Taken from the train.
-
The eight log levels of RFC 5424 (https://tools.ietf.org/html/rfc5424#page-11 ):
- 0 Emergency: system is unusable
- 1 Alert: action must be taken immediately
- 2 Critical: critical conditions
- 3 Error: error conditions
- 4 Warning: warning conditions
- 5 Notice: normal but significant condition
- 6 Informational: informational messages
- 7 Debug: debug-level messages
-
Maps are wonderful - and I too learnt to read OS maps when at school and can spend hours looking at them and at my large atlas. Now, in Australia, there is nothing similar. But there is an alternative now, in particular to google maps in particular which of course are not designed for walkers - Open Street Maps. I’ve just attended a map making workshop/day out here in Perth, Western Australia and have learnt how to add landmarks of all kinds to the OSM map - where steps are, benches, names of buildings, ferry landings, even special trees - cafes and their opening hours, bus stops, and everything else that makes a walk interesting and manageable. It is a kind of citizen community service! Using OSM in other countries has been really useful too - for example it showed me a useful short cut that I could use in a small town in Bulgaria, a path leading up to the castle in Kars, Turkey that avoided a busy road, and so on. When i compare OSM maps with the google equivalent, there is a huge difference as the former do integrate up to date local knowledge. Like wikipedia, the maps are made by individuals but moderated and checked by editors. And constantly updated. You can download them, so there is no problem about being online to use them. It is great fun, being able to actually add things to a map for those of us who’ve always loved maps!
-
One of my strongest childhood memories is of sitting in the back of the car with a map. On long journeys it was my job to trace our route with my finger and call out directions (even though my parents knew exactly where we were going). I can remember that almost magical feeling of power and responsibility, as if somehow I was the one in control, that we would go where my finger took us. That’s where my love of maps began.
When I got older, I joined the Scouts and I remember proudly getting my navigation badge. With it came the realisation that everything you need to understand the landscape around you – mountains, forests, lakes and rivers – folds down into something you can fit into a rucksack.
Understanding a map creates a new sort of relationship with the outdoors – if you can learn to do that at an early enough age, it will carry through the rest of your life. Studies have shown that if you can get someone interested in outdoor activity before the age of 14, it will stay with them. If you don’t, there is a danger they will always think of the outdoors as something to be driven past and through. For me, a map is a passport to getting outside.
In my role at Ordnance Survey (OS), I want to help more people to get outside more often. The outdoors should be for everyone, and we know from our work with experts such as former Olympian and sports scientist Greg Whyte that outdoor physical activity during lockdown is more important than ever.
The good news is that people do seem to be getting outside. Since February, use of our OS Maps Get Outside adventure planning app has increased by 78%, with around 3.5 million people using it now. There’s a function that lets you see local green space, and usage of it is up 3,000%. November is normally a more quiet time for the app – it’s darker, the weather is more inclement – but it’s clear that with restrictions on other sorts of activity, people are turning to walking in nature. My hope is that, even when the full list of competing pastimes comes back, many will have discovered a love for the outdoors and keep going.
You don’t need a car, or to travel far, to find unexpected treasures – they can be right on your doorstep. In fact, my favourite map is for my local area in Bournemouth, which also covers the New Forest. Even the cover of this map is appealing – a Gruffalo-type woodland just waiting to be explored. You can be forgiven for thinking there’s nothing new to discover in your local area, but there will always be things you’ve never done before. For example, in the New Forest there’s something described as Portuguese Fireplace – I’ve often noticed it, but had no real idea what it could be. So we went on a walk to find it, and it really is a Portuguese fireplace – a war memorial to a Portuguese regiment who helped with timber production during the first world war.
Running your finger along the placenames on a map is a journey through history as well as geography. It’s those little things you can uncover that makes maps so special.
Map reading can also be a brilliant way to entertain children, and to build their confidence. When you can bring the landscape to life with a map – “We’re going to walk through an ancient woodland and over a Saxon burial mound” – all that rich history comes out and you start an adventure. Letting a child take on the navigation is also a great tool to give them. They are naturally fascinated by the relationship between the world and them. Advertisement
While map sales are soaring, the process of imaging and mapping has seen new challenges. Ordnance Survey’s flying unit has spoken of the eerie experience of flying over the UK during lockdown. The work of the flying team underpins the accuracy of OS mapping and is essential for users such as the emergency services, so as soon as it was safe to fly, they got back out in the sky.
During the first lockdown, OS pilots flew the only plane in the sky, documenting Britain’s changing landscape while the country below came to a halt. They witnessed a unique view from the cockpit: empty motorways, unpopulated beaches like desert islands, airport runways jammed with mothballed aircrafts, and skies reclaimed by birds and wildlife. Advertisement
Camera operator Roger Nock takes the aerial images that keep OS maps up to date, and he told me: “We were, on occasion, the only people in the sky. That hasn’t happened since the dawn of aviation.”
Cities like Nottingham and Birmingham were like ghost towns because of how many people obeyed the lockdown. There was no rush-hour traffic either, and a big difference from previous years was the lack of haze over cities because of less pollution.“
We’re living through unprecedented times, but I hope that when we leave them behind, many of us will be taking with us a newfound love of getting out and about in the British countryside.
-