Project Overview
Open Data created by Creative Dundee, with help from Dundee City Council (DCC), and which crosses several of the work packages delivered by the 8th City Data Cluster, including:
Work Package 3: Data Analytics
- Deliverable 1 – Development of temporal, spatial and predictive models across the themes of social outcomes, environmental outcomes, economic and efficiency outcomes.
- 3 – Development of a common toolkit.
And
Work Package 4: Community and Capacity Building
- Deliverable 4.1 – Crowd sourced data methodology.
- Deliverable 4.2 – Co-produced open data methodology.
DCC was able to support the process by providing Ordnance Survey OpenMaps, enhancing the collated results and adding them to OpenStreetMap. Training in ArcGIS Online was provided. Training was also provided for publishing data to the Dundee open data platform.
A survey was also created in ArcMap Survey123, which asked the same question. Training was given to Creative Dundee officers on how to use Survey123.
Mentoring was provided throughout the process. More information about the methodology used can be found on the Creative Dundee website.
Why is it needed?
Creative Dundee in collaboration with Dundee Place Partnership wanted to find out more about cultural opportunities across Dundee and how people engage with these opportunities, if at all. To gain the best insight, they wanted to survey the public but lacked the tools and knowledge to ensure that survey results could be published under an open license to the Dundee City open data platform.
Impact and Benefits
Results have been published to the Dundee open data portal and are available in CSV format – https://data.dundeecity.gov.uk/dataset/places-database. The results of this research will allow Creative Dundee to target future activities. Data is also available in an open format under a CC license so others interested can use the data. The map visualization of data is embedded in the open data portal from ArcGIS Online using an iframe. This allows the public to interact with the data without needing to own the proprietary software ArcGIS Online which is licensed and costs to use.
Respondent locations were also heat mapped in ArcGIS by Creative Dundee. The analysis was assisted by DCC and demonstrates current trends in Dundee.
All the results of the survey can be seen on OpenStreetMap, which is an open source database, providing another avenue for people to access and reuse the data.
Tools used (e.g. OpenStreetMap, ArcGIS Online, Google Sheets, Survey123), will go towards a common toolkit shared by the seven cities of the open data cluster, providing useful data analysis techniques and visualisation tools.
The methodology and lessons learned have been fed back to the 8th City Data Cluster and will go towards a description of a methodology for co-production of open data.
Links to the project include:
Creative Dundee’s launch of the project:
https://creativedundee.com/2017/08/what-is-your-perfect-day/
Creative Dundee’s conclusion and analysis of the project:
https://creativedundee.com/2018/04/culture-connects-what-we-learned/
Photos of the events Creative Dundee attended can be seen on Flickr:
https://www.flickr.com/photos/creativedundee/sets/72157685047692603
For more information contact Jill Brash, Senior Research and Information Officer, Dundee City Council – jill.brash@dundeecity.gov.uk
X
Linkedin