Switzerland's 4th make.opendata.ch-Hackdays in Berne and Sierre brought thinkers and makers together around the topic of financial open data. Please support these projects to help accelerate openness, innovation and efficiency in private and public budgeting!

:: Projects from Sierre ::Projects from Berne :: Blogs and press coverage ::

Video: Podiumsgespräch über Möglichkeiten und Grenzen der Visualisierung von Finanzdaten (Opendata.ch Mitgliederversammlung, 21.03.2013)

Tax Freedom Day: Recently, various media published results of the ESTV (Eidgenössische Steuerverwaltung) which show the so-called “Tax Freedom Day”, the day of the year when a citizen has earned enough money to compensate for the taxes he/she paid. The idea of this project is thus to craft an interactive, thematic map/visualization of this data. It should allow the viewer a quick, informative and salient overview of the spatial disparities in the Swiss tax system. See: demo - source - doku

Qualified Money: This project simulates the spreading of tainted money. In a second step, it implements qualifiers that regulate different qualities of money. First step was to gather money flow data. For this purpose, every country's trade import and export is used. Money can be contagious (i.e. if a country receives _any_ bad money, the country is 'bad') or bad money dilutes with respect to the money reservoir of the country. Starting from an initial setup (all countries good, one bad; half good; half bad; …), year by year the quality indicater is updated according to the flows of money. See: source - doku

Open Aid: The idea of this project is to visualize financial flows data on Swiss foreign aid. In a study about transparency of foreign aid by an NGO last year, the Swiss Agency for Development and Cooperation SDC only received 25 out of 100 points. How much money goes to foreign aid from the public and the private sector, where does the money come from and where does it go? And how much of your tax money is used on foreign aid? Let's make this data transparent, by using great visualizations! See: demo - source - doku

Open Budget: Building upon a successful project initiated in April 2012 at the 1st Berne Open Data Hackday to create an interactive visualization of the budget of the city of Berne, the project team at the finance hackdays concentrated on visualizing the budget of the city of Zurich as well as of all (!) municipalities of the canton of Bern. Dive into and through your city's budget and get a sense of where your money goes, and where your city gets it from. See: demo (City of Zurich, 2013) - source - doku

Finanzausgleich Kanton Bern: Dieses Projekt visualisiert die Geldflüsse des kantonalberner Finanzausgleichs und stellt so einer breiten Öffentlichkeit übersichtliche Grundlagen für die Diskussionen über das Thema “intrakantonale Solidarität” zur Verfügung. Siehe: demo - source - doku

FTTH Business Model Navigator: The objective of this project is to visualize the current FTTH deployment status, and to create a easy-to-use service for municipalities and the public to make a business plan for facilitating the decision if setting up FTTH pays out or not. See: doku

Cumulizer: This project has got a focus on analyzing personal shopping data. We have started by aggregating data available from the Cumulus purchase points program run by Migros, but would be interested in expanding the concept to Coop Superpunkt and others. See: demo - source - doku

Mobile Deck Card Game with Financial Data: The outcome of this project is a card game, where you compare a community's financial data with anothers, the one with the higher value wins, if you loose, you loose a card, if you win, you get one. See: demo - source - doku

Semantic Legal: Swiss laws and regulations are mostly accessible online, though some by subscription only. The goal of this project is to think about new ways of how Swiss laws and regulations could be published using powerful semantic tools to create Linked Open Data. See: doku

1. Thomas Preusse, local.ch: Open Budget App Bern (Presentation)
2. Christoph Schaller, Berner Fachhochschule: Finanzstatistik Gemeinden Kt. Bern (Präsentation)
3. Daniel Studer, Amt für Gemeinden und Raumordnung Kanton Bern, und Beat Dänzer, Finanzverwaltung Kanton Bern: Finanzausgleichsdaten des Kantons Bern (Präsentation)
4. Claudia Bretscher, Statistik Stadt Zürich: Finanzdaten der Stadt Zürich (Präsentation)
5. Urs Derendinger: Steuerdaten des Kanton Schwyz - Einkommen und Vermögen von 2001 bis 2009 (Präsentation)
6. Roland Studer, Puzzle: Gemeinde-Quartett (Präsentation)
7. Timo Grossenbacher: Vis 4 Tax Freedom Day (Präsentation)
8. Andreas Kellerhals, Direktor Schweizerisches Bundesarchiv: Digitalisierte Staatsrechnungen und Budgets des Bundes 1849 bis 1998 (Präsentation als PPS und PDF)
9. Niklaus Hug und Martin Blumenthal, NTS: FTTH Business Model Navigator
10. Prof. Dr. Dirk Helbing, ETH Zürich: FuturICT Financial + Innovation Platform (Präsentation)
11. Adrienne Fichter und Stefan Zollinger, Orell Füssli Wirtschaftsinformationen OFWI: Öffentliche vernetzte Handelsregisterdaten Infocube.ch (Präsentation)
12. Thomas Bisig, Olsen: The Bubbles of Market Dynamics - A Dynamic Tool to Assess Market Dynamics (Präsentation)
13. Barbara Kummler, Hochschule Luzern: Verständlichkeit (Präsentation)
14. Sebastian Loosli: Demokratie und Entscheidungen (Präsentation)
15. Christian Studer: M-Connect Migros Cumulus
16. Danilo: OpenDEZA http://make.opendata.ch/wiki/project:opendeza
17. Oleg: Statistical Linked Datasets and http://Tambur.io
18. Julius Chorbak: http://Mingle.io

• CROWD INTEREST: It is difficult to get an aggregated source of data that describes the number of tourists having visited different places in Wallis. The idea is to infer this information by using flickr: by using either the geotagging of the uploaded photos or the taggs it is possible to get an idea of how much persons have visited a certain place.

• Partons en piste ! (DEMO): This project aims to develop an app that help by selecting certain criteria (meteo, quality of the snow, traveling duration, …) the best place to make ski.

• Holiday Apartments:

• Linked Open Tourism Data: To create an added value, different information from various data sources must be linked together. Many data sources implement the RDF format to describe their meta data. That's why we're going to use as much RDF data sources as possible. Those statistical data will thus be linked to other Linked Open Data sets (as DBPedia, geoNames), and the information from the different sources can thus be queried at will.

• Calcul du pouvoir d'achat selon le salaire et le coût de la vie

• Partis Budgets:

• Electronomy

• Le mouvement Open Data et ses ateliers Make Open Data – Antoine Logean (Opendata.ch)
• Linked Open Data et Web sémantique – Anne Le Calve (HES-SO Valais-Wallis)
• 3 Façons d’accèder aux services proposé par les Administrations ch.ch / services web (SECO) / web sémantique (Ecole d’Ingénieurs Fribourg) – Florian Stoller (Softcom/eGovTech)
• Geo.admin.ch et son API – Loic Gasser (Office fédéral de topographie swisstopo) (15 min)

Blogs and press coverage:

• Software zeigt, ob sich Glasfaser auch lohnt (Blick am Abend, 22.03.2013)
• Videobotschaft an die Open Data Community von Jacqueline Badran, Nationalrätin (make.opendata.ch Hackdays, 22.03.2013)
• Politische Komplexitat vs. Datenjournalismus (hymnos.existenz.ch/Christian Studer, 21.03.2013)