As a next step, we wanted select those cultural events from the database that took place in Katowice. For this purpose, we used a publicly available data set from the National Register of Boundaries and QGIS, a geographic information system application designed for, among others, collecting, processing and analysing spatial data, and creating maps. Based on the CSV file, we created a vector layer with points representing event venues. Then we cut out of it those which are held in Katowice, i.e. are located within a polygon representing the boundaries of the city. Finally, we saved the thus obtained data into the GeoJSON file.
Thanks to Leaflet, we were then able to put the database on the map and give it a desired style with data on the number of events and their organisers visualised in a clear and unfussy manner. Based on the map, we were able to study the distribution of “cultural spots” and search for the area in which the largest number of cultural events are aggregated. Thanks to appropriate styling, it was also easy to see the division of events into those organised by public entities and those delivered by NGOs and private promoters.
By adding additional attributes to the output data, it is possible to study various characteristics of the events in different ways, such as location variations depending on the season/month of the year. The developed model of operation is a prototype that will subject to further development in the coming months. The final product will illustrate e.g. the variability of “cultural centres” over the years.