Hi allThis isn't directly a Tessitura question - but I know that you all wear so many different reporting and analytics hats, so I'm hoping you can help!
Our Learning team are looking for a way to show where they are running projects across the UK. They have a list of great ideas for visualisations to help them show the exec team what they are doing and to plan their future activity. Requirements include multiple layers to bring in open source data (eg deprivation index / population etc) by region, as well as plotting the location of high schools, galleries and other partners. There's also the desire to be able to see how activity changes year on year, and to filter by a number of different data points (eg type of school).Do you have any experience of programmes or websites offering this kind of functionality? We don't need the full 'sort out your delivery drivers' optimal routes' software that pops up when we search!Many thanks in advance for your help and recommendations of where we could start.best wishesAlison AtkinsonSenior Commercial Systems ManagerThe National Gallery
Hi Alison,
A program that I've used in the past for big mapping visualization projects is ArcGIS from a company called ESRI. It's a pretty robust tool and does take some time to learn, but there are a lot of shapefiles you can pull in from the web for those layers you're interested in including. For instance, I can add in layers of US Census Data or from other open-source files from other researchers or local government departments that might have details on things like school districts.
They have an online version, or a desktop application. I was able to apply for their nonprofit software license and it was only $100 a year.
I don't know the international reach of the tool, but maybe a search for GIS (geographic information system) shapefiles for some of the data layers you're looking to include might also help you find out whether this or other software tools are available.
This sounds like an exciting project and if you learn of other mapping tools please share!
- Christine
The covid map Tom shared here uses arcGIS I believe.
https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/24640/mapping-coronavirus-responsibly