Building local open data about the community is crucial to success
Local efforts to build and share Open Data about the tech community in Scotland help everyone connect. The Scottish-run website Open Tech Calendar has been at the heart of that, and they recently celebrated their 5th birthday by helping an ODI Leeds study on UK tech clusters that declared Edinburgh and Glasgow 2nd and 4th most active respectively.
Open Tech Calendar lists tech events around the UK in a wiki-style website where anyone can add or edit events. I started this after a similar project run by a local event ran into problems. I set out to do things in a different way that could make the project more robust and also make more of the resulting data.
Its Open Data was used by the ODI study to identify tech clusters. It is also imported directly by many people into their personal calendars, used on other websites and regularly posted to email lists and Slack groups.
The tech behind it
Like a wiki, every edit is versioned to ensure safety. And the first version, launched in a long weekend, was run on MediaWiki – the Open Source software behind Wikipedia – and a quickly edited plugin to support exporting calendar feeds.
A few months in, it was clear this was something the community was interested in. But it also became clear that this text wiki format would not support the simple-to-use UI/UX format that I wanted to build, and after a few months I started work on a custom PHP application.
After one year, this was replaced by a new app written in the Micro Framework Silex using Symfony components and storing its data in Postgresql. This was Open Sourced and remains the base for the website today.
This software has also been used for other projects. At the 2015 General election it listed over 1,000 hustings (public debates between the candidates) and again the resulting Open Data set was used by many charities and other election sites.
Tech in Scotland
Seeking to apply this crowd-sourced open community data philosophy to other areas, last year I launched Tech In Scotland. This lists details of online communities and tech companies in Scotland. We are working with local events like PHP and C++ to help build up the data for everyone.
In both cases, a key thing is making sure the data set is kept up to date and correct. While there is no silver bullet solution, lots of tricks are used to try and help. For instance, on other web sites someone could set up a recurring event which goes on for ever, but in real life the event then ends shortly afterwards. To prevent this kind of inaccurate data, Open Tech Calendar only lets people recur an event forwards for 6 months and then later it will prompt them to come back and add more if it’s still going.
Open Data aspect
The Open Data aspect is something we are very keen to push. When people hear about the project, they often think it would be easy to do as there is lots of existing Open Data out there we can re-use.
While there is some, there is nowhere near as much as people think and this has caused problems for us. We found one event that didn’t even update their own website, let alone provide any Open Data! So we are also keen to push others to make Open Data available that we and others can re-use.
Open Tech Calendar and Tech In Scotland are supported by our sponsors – thanks to everyone who has helped over the years! While this has brought in a small amount of money, this has always been a labour of love for me and so it’s great to hear from people who find them useful.
This approach has developed a bedrock of Open Data that has served the community well, and we look forwards to seeing where the Scottish Tech scene goes in the future!
About the author
The pandemic has taught me how to share more – and I feel a better leader for it
As a young professional starting out in the tech sector 30 years ago, I thrived on the fast pace,constant change and demanding workload. I lived in London, Singapore and Australia…
We need to shout about our successes. Liz Fletcher on celebrating women in biotech
Throughout my career in biotechnology and life sciences, I have seen many women leading ground-breaking research studies in their fields of expertise. Yet, and I include myself in this, we…
Getting the best out of patient data is key to unlocking future health benefits in Scotland
It is important that clinicians’ voices are heard in the consultation around Scotland’s new health and care data strategy, which closes this week (12 August). Busy GPs like myself are the trusted…
How motherhood helped me be a better leader
Consider this an open letter to anyone I have worked with before I became a mother and before I fully understood how being a parent is actually a prized asset…
‘We cannot achieve our goals without entrepreneurs’ – Kate Forbes on vision for new ‘tech scaler’ network
From the very start of my ministerial career, I have had responsibility for the Scottish tech sector – and I can still say what I have said from the start,…
Finding a role in cyber was ‘tough’ for Cheryl Torano. Now she’s determined to help other women join an under-represented industry
When I decided to upskill to change careers at the age of 30 and dive into the digital world, I knew I would be starting out at the bottom of…
Why innovation and marketing are the perfect partners to make changes that matter￼
With the rapid evolution of traditional marketing and the appearance of digital marketing, technology and innovation has become part of any marketer’s life without the need of working for a…
Transitioning to a four-day week – CEO’s vow to strike a healthier balance in the workplace
I came to Scotland nearly 20 years ago from Ireland, with no contacts but a lot of determination. While Ireland will always be my home, Scotland has given me amazing…