Researching
92

06 Quantification of visitors of cultural events in Lucerne

Create a prototype of a technical solution to count visitors of cultural events.

⛶ Full screen

Title

Problem

The City of Lucerne would like to register how many people visiting cultural events in the City of Lucerne are actually residents of Lucerne and how many are visiting from the agglomeration (K5: Ebikon, Emmen, Horw, Kriens, City of Lucerne incl. Littau and Reussbühl) or even outside the Region. This information would be used by the City of Lucerne to discuss more accurately with the agglomeration, how much they have to pay to the city on cultural promotion.

Idea

At the entrance of the cultural events we would put a tablet where visitors are asked to insert the zip code of their home address. This would be a voluntary process and the visitors will be rewarded with a funny thank you note, once they put in the information. For the City of Lucerne a dashboard with visualisations of the visitor flow to the different cultural events can be created.

Goal

Create a prototype of a technical solution to count visitors of cultural events. What is the percentage of visitors from the city of Lucerne and the surrounding municipalities?

Data

There is no data which can be used as the goal of the challenge is to find a way of collecting the data.

Partner

Judith Christen City of Lucerne, Kultur & Sport

Title

These contents were scraped from an external site. Visit the original location to see all the formatting.

Hackathon Shape my City - 27-28. November 2020

06 Quantification of visitors of cultural events in Lucerne

Create a prototype of a technical solution to count visitors of cultural events

Team: Yvonne Schärli, Salome Isch, Thushanth Gunasegaram, Adriana Ricklin, Cengiz Cetinkaya, Christina Sudermann

1) What is the challenge about

Problem Description

The City of Lucerne would like to register how many people visiting cultural events in the City of Lucerne are actually residents of Lucerne and how many are visiting from the agglomeration (K5: Ebikon, Emmen, Horw, Kriens, City of Lucerne incl. Littau and Reussbühl) or even outside the Region. This information would be used by the City of Lucerne to discuss more accurately with the agglomeration, how much they have to pay to the city on cultural promotion.

Idea of Implementation

At the entrance of the cultural events we would put a tablet where visitors are asked to insert the zip code of their home address. This would be a voluntary process and the visitors will be rewarded with a funny thank you note, once they put in the information. For the City of Lucerne a dashboard with visualisations of the visitor flow to the different cultural events can be created.

Goal

Create a prototype of a technical solution to count visitors of cultural events. What is the percentage of visitors from the city of Lucerne and the surrounding municipalities?

Data

There is no data which can be used as the goal of the challenge is to find a way of collecting the data.

Partner

City of Lucerne, Kultur & Sport

Link to the Hackathon Challenges: hack.opendata

2) Practical Approach to solve the challenge

Architecture

For this project the database management system MongoDB is used for the data storage. For the backend Python Flask is used, for the frontend the JavaScript React Framework and for the visualisations Tableau. Architecture

Backend

For Backend the Python web application framework Flask is used. A connection to MongoDB is setup. Functions to get all postal codes and events entered by the visitors of the events on the web app and to write it into the database.

Frontend: WebApp

For the Front end Web development, the JavaScript React Framework was used. For this challenge a very simple App will be setup because only a few buttons are needed for the input of the zip codes. It should be as simple as possible for the user. The user gets a feedback after inserting the zip code on the tablet.

Here is a first look of the WebApp with different buttons for the zip codes. WebApp

Visualisation

For the visualisations we wanted to set up a connection to the MongoDB, but this was in the short time of the hackathon not possible. Therefore Tableau visaulisations were created without a connection and with a sample dataset. The original idea was, to have a connection to MongoDB server which is regularly updated in order to have nearly real time data of the input of the zip codes at the events.

Here is an example of what it could look like on the tablet. Further visualisations can be found in the folder images in the power point presentation.

Visualisation

3) Next steps

  1. Frontend enlargement. To make it more user friendly the setup should be brought to the cloud. This would make the data more accessible for different users. Additionally, more postal codes are added for surrounding areas and the design of the web app is finalised.
  2. Create further visualisations to give feedback to the visitors at the events.
  3. In order for the city of Lucerne to have an overview over the visitors, a second use case is created. According to the needs of the city of Lucerne visualisations in Tableau will be created.
  4. A pilot should be setup at one event location to test the web app.
28.11.2020 18:00

Hackathon finished

28.11.2020 14:19

Documentation

Worked on by christina_sudermann

28.11.2020 14:10

Documentation

Worked on by waisch

28.11.2020 13:39

Synchronized

Readme fetched from source by waisch

28.11.2020 12:50

Team forming

AR8 has joined

28.11.2020 12:40

Synchronized

Readme fetched from source by wagunase

28.11.2020 12:38

Documentation

Worked on by wagunase

28.11.2020 10:29

Documentation

Worked on by christina_sudermann

28.11.2020 10:17

Synchronized

Readme fetched from source by waisch

28.11.2020 10:15

Documentation

Worked on by waisch

28.11.2020 10:14

Synchronized

Readme fetched from source by waisch

28.11.2020 10:14

Documentation

Worked on by waisch

28.11.2020 10:10

Synchronized

Readme fetched from source by waisch

28.11.2020 10:10

Documentation

Worked on by waisch

28.11.2020 10:06

Documentation

Worked on by christina_sudermann

27.11.2020 22:04

Documentation

Worked on by wacetink

27.11.2020 18:33

Documentation

Worked on by waisch

27.11.2020 14:18

Team forming

christina_sudermann has joined

27.11.2020 11:14

Team forming

wnschaer has joined

27.11.2020 09:36

Documentation

Worked on by wacetink

27.11.2020 09:00

Hackathon started

30.10.2020 08:17

Team forming

waisch has joined

30.10.2020 08:10

Team forming

warickli has joined

30.10.2020 07:53

Team forming

wacetink has joined

29.10.2020 20:02

Documentation

Worked on by wagunase

29.10.2020 19:58

Team forming

wagunase has joined

29.10.2020 19:58

Project started

Initialized by wagunase

All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody. For more details on how the event is run, see the Guidelines on our wiki.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.