A commission from the Welsh Government has resulted in new functionality for Mapumental, which now has the capability to display multiple points and to produce RAW data compatible with GIS applications. Here’s how it happened.
How accessible is your nearest school, post office, or GP’s surgery? In Wales, that’s not always a simple question: the country’s mountainous landscapes, rural populations, and sometimes infrequent bus services can mean that those without cars are rather cut off from public service provision.
But of course, like any other authority, the Welsh Government has an obligation to quantify just how accessible their services are.
For many years, they have done so using a number of different methods. Some of these involve literally millions of point to point calculations – so, naturally, when Bill Oates, Head of Geography & Technology, Knowledge Services at the Welsh Government, approached Mapumental, he was keen to discover whether we could simplify things.
We were keen to try it, too – plotting multiple points would add a whole new slew of possibilities to Mapumental. Previously, Mapumental has been all about travel from a single point, and this functionality would bring new applications across all kinds of industries and users.
There’s only one way to find out
The sensible way forward was to pick a single service and see what we could do. One of the government’s open data sets showed positioning of all the secondary schools in the country, and would give us a very good indication of how manageable the task would be across all other provisions.
So we set ourselves this aim: to display the shortest transit time to get to any secondary school in Wales, from any point in that country.
This project was not like the map we made for the Fire Protection Association last year, with its postcode input and interactive sliders. It bore more relation to our static maps, but with the additional dimension that the single map would have multiple points plotted on it. Each point would display its own associated journey times, and where travel to one school was quicker than to another, it would have to override the data of the school that was further away.
And here’s the (very pretty) result
Transit times by public transport to secondary schools in Wales, with an arrival time of 9:00am.
Time bands are in 15-minute increments, with red areas being those where schools are accessible within a 15-minute journey (the centres of the red dots therefore also represent the positions of the schools).
Purple areas are those where journey time is between 1.75 and 2 hours, and the colours in between run in the order you see bottom right of the map. White areas (much of which are mountainous and sparsely-populated) are outside the two-hour transit time.
But there’s more – data for GIS
Plotting all the schools on a single map required quite a bit of modification to Mapumental, but there was another important part of the project that also had to be worked on, if the output was to meet all the needs of the Welsh Government.
They needed to be able to export the raw transit time data to their own GIS tools – the tools that they use to feed into official statistics. This allows the transit time data to be combined with other datasets, such as population density, for in-depth analysis.
We added a feature which allows Mapumental to produce what is known as a ‘raster grid’ output – basically, an enormous matrix that gives every pixel on the map a travel time value. To do this, we used the open source GRASS format.
Bill Oates is keen to see where this project can go:
“I’m really excited at the prospect of combining the power of Mapumental with our open data, and fully understanding how accessible Welsh public services are by public transport.”
To him, the benefits are clear:
“Mapumental’s approach is significantly quicker than our current methods, so this work will help save us time as well as providing a more engaging output.
“We hope that future work with mySociety will give us a sustainable approach to calculating the accessibility of local shops, hospitals, post offices and other services on an ongoing basis to help ensure that we’re meeting the needs of our citizens.”
We’re looking to build on our success, and offer this service to others – initially on request but via our API as soon as we can. We’ll keep you posted as to our progress.
You can see multiple-point mapping in action, on our Mapumental Property project – now the tool allows house-hunters to take more than one person’s commute into consideration when choosing where to live.
Who might use Mapumental?
Now that Mapumental can plot transit times from multiple points, and provide RAW data for GIS applications, we have great potential for use by anyone interested in travel and accessibility. That could be in central and local government strategy, town planning, architectural consultancy, transport provision, large enterprises looking to save on parking, or start-ups in the green transport space…to name but a few.
Could Mapumental help you with your mapping needs? If so, please do drop us a line at email@example.com.
Photo of Welsh school bus (bws ysgol) by Aqwis (CC)
In this series of talks, we’re exploring how organisations can present data meaningfully and accessibly – and how to maximise the benefits, both for themselves and for their stakeholders.
If you are interested in attending a mySociety Data For Breakfast briefing, drop us a line and we’ll add you to our mailing list.
It was great to see so many people at our latest Data For Breakfast event, where our Senior Consultant Mike Thompson explored how you can match a data presentation method to your organisation’s aims.
Mike’s uploaded his presentation, along with others in the series, on our Slideshare page, but I’m also going to summarise it here, as Mike said a lot more than you’ll glean from the slides alone – and there was some really useful conversation from our attendees.
Click to read more
If you are interested in attending a mySociety Data Briefing for Breakfast event, drop us a line and we’ll add you to our mailing list.
28th June: Tristan Carlyon from Shelter
mySociety’s Data Briefings are all about how to present complex data online, simply. Shelter’s Databank tool is one of the better solutions we’ve seen to this exact problem, so we invited Tristan Carlyon, a key player in its creation, to tell us about it.
The Shelter Databank pulls together government data on housing issues from a number of sources, and makes it accessible online.
Although the underlying data is all freely available in various places, it wasn’t previously easy for the casual user to find or to use. Conversely, and crucially, you don’t need to be an expert to use Databank – it has a very simple interface and it outputs the data you need, in the format you need.
”I created my ideal resource”.
As with so much great software, the Databank was born when Tristan identified something that would make his own job easier. But it soon became clear that there would be a wider appreciative audience.
A quick internal assessment helped Tristan calculate that the Shelter media team were spending a total of one day a week answering queries from the press. This fact alone justified the project – it’d make a large efficiency saving.
The benefits wouldn’t just be internal: it was also an opportunity to drive traffic to the Shelter website and increase brand awareness for the charity.
At a previous Breakfast, the question had arisen of how you can get buy-in from higher management for this kind of project, when it may seem not to precisely align with your organisation’s main remit.
As it happens, the Databank tool does fit pretty solidly within Shelter’s charitable mission – one of their aims is: “to educate the public concerning the nature, causes and effects of homelessness [..] and to conduct and procure research concerning the same and to make available the useful results thereafter to the public.”
But there are other benefits too, even if your organisation doesn’t have a similar remit. Tristan confirmed that having an effective, useful tool builds the brand, cementing it more firmly in people’s minds.
Plus, publishing this kind of data enables Shelter to engage with many of their target and actual stakeholders – press, elected representatives at all levels, academics, grassroots campaigners, and developers.
Looks simple… works hard
Tristan took us through the tool’s interface: it may appear basic, but a lot of thought has gone into every element. Some of the points he pulled out were:
- The input form is all on one page – and if you go back to amend your search, your previous input is saved.
- The big red ‘get data’ button is unambiguous and unmissable – and happens to be Tristan’s favourite feature of the whole tool.
- Search queries generate a URL that incorporates the search parameters, and can be easily shared or modified.
- Glossary tags ensure that any technical terms can be understood by the general public just as well as industry insiders.
- The tool is free of any spin. Despite its placement on a charity website, it does not exhort you to donate. Its only aim is to present the data without comment or editorial, which helps retain its integrity.
OK, it’s built. Now you have to run the thing.
The Databank was built within eight weeks, alongside other development projects. Like almost any such project – and as we at mySociety see with our own data-related sites – it couldn’t just be built and then left to do its work. As its underlying external data sources are refreshed, it must also be updated, and this is rarely a job that can be automated.
In fact, Tristan currently does the updates manually, taking about a day’s work each quarter. He reckons that it’s still well worth it. The tool still offers massive efficiency savings, for him and for many others. Hundreds of subscribers are signed up to receive an alert whenever the data is refreshed.
Shelter’s internal systems ensure that projects are always retrospectively assessed to see whether they met the objectives in the initial project plan.
The Databank stands up well to scrutiny, being one of Shelter’s most consistently visited pages, and continuing to save time for the whole team. Reputation, perhaps, cannot be measured, but it is not a great leap to see that a useful tool like this can only enhance the charity’s image.
We’ll be continuing our Data for Breakfast briefings, so if you’d like to hear about the next one, please drop us a line with your name and the organisation you work for.
Mapumental can turn vast datasets into visual tools that everyone understands. Faced with highly complex, yet crucial data from the Fire Protection Association, we had a chance to really put our technology through its paces.
Just how quickly could fire engines reach a given postcode in case of a fire? It’s a question that’s pivotal to decisions made by both the emergency services and the insurance industry.
But previously, it has been a challenge to present the data simply, because it involves so many variables.
Every region has its own factors, each of which will impact on fire engine response time. The number of vehicles at each station, the hours during which the station is manned, and the response policy of each individual fire authority will all play a part – and that’s before you even consider how geography might affect things.
Dr. Jim Glockling is Technical Director at the Fire Protection Association and Head of the Risk Insight, Strategy and Control Authority (RISCAuthority), an organisation for the advancement of risk management within the fire and security sectors. Jim approached mySociety with this question: how could we map this crucial, yet complicated data in a way that could be understood by RISCAuthority members at a glance?
It was clearly a job for Mapumental. Our transit-time mapping software was originally built to visualise public transport journey times, but its beauty is that ‘layers’ of data can be swapped out, allowing it to be used for all kinds of purposes.
Read more about mySociety’s data visualisation services here.
Assessing a property or postcode
And here’s the result of our pilot project. The maps on the right answer the following questions (click each image to see it at full size):
How quickly could 4 fire engines get to AL10 0XR ?
How does that change if the severity of the fire just requires one fire engine?
A user inputs a postcode, and can assess exactly how quickly a fire could be tackled in that area. The different levels of severity are measured by how many response vehicles are required, and changes in this number are immediately reflected on the map.
Assessing the general area
Which areas can four fire engines get to within 9 minutes 30 seconds at midday on a Saturday?
It’s also possible to assess the region’s overall response capability, without inputting a postcode. The user sets severity levels (number of fire engines, or High Volume Pumping or Aerial Appliance (ladder) is needed), the time and day of the week.
Where can an aerial appliance get to within 15 minutes at 2am on a weekday?
The FPA tool immediately highlights the areas that are accessible within the chosen parameters, drawing on the underlying data of journey times and information such as vehicle numbers and hours of operation for each individual fire station in the region.
With RISCAuthority, we tested the concept using data from one fire authority – Hertfordshire. mySociety’s task was to create a usable, elegant web interface that was as simple as possible to use, while still giving insurers the key data they needed.
The project called on everything we knew about clean design, usability and data structures. A key part of what makes Mapumental’s data visualisation so intuitive are its sliders: this enables the user to quickly explore variables on a map.
A tool with purpose
Dr Glockling explains: “Whilst not necessarily used as a component of insurance pricing, this information helps insurers administer risk control and fire protection advice to their customers in the context of what the Fire and Rescue Services will be able to achieve on their behalf.”
The response time is just one factor that insurance surveyors will take into account when they are assessing a building. “Where response and arrival times are not coherent with protecting the viability of the business in the event of fire, additional forms of in-built protection and control might be recommended, such as the installation of sprinkler systems.”
“In the longer term it is hoped such information will impact beneficially on the annual cost of fire in the UK.”
The pilot tool was well received by the FPA community, and the plan is now to work with RISCAuthority to roll it out to more fire authorities shortly, and then nationwide.
Dr Glockling explains the pilot study helped them to understand two factors:
Would they get buy-in from both insurers and Fire and Rescue services on the viability and usefulness of the project?
Was it possible to present such a massive amount of data in a format that was readily palatable to the intended audience?
He says, “Mapumental’s team displayed an immediate understanding of our requirement. Delivery was to time and the result has perfectly satisfied the de-risking ambition. The working relationships were very good throughout and we intend now to extend the pilot to full UK rollout.”
During this phase, we will be inputting still more detail to the data, including information on the types of fire engine available to each region, and the plotting of fire stations on the map.
The tool will be a valuable resource for the FPA and the insurance industry, and we really look forward to the roll-out later this year.
Mapumental specialises in visualising complex geographic data sets on intuitive, easy to use map tools. If you have a data visualisation project that will benefit from Mapumental, just get in touch. Or read more about mySociety’s data visualisation services here.
Photo by William Murphy (CC)