This is a read only archive of pad.okfn.org. See the shutdown announcement for details.

OpenDataDayBerlin2015  Open Data Day 2015: Berlin!
=======================

What
Hackday. http://www.meetup.com/OK-Lab-Berlin/events/220434966/

When
Saturday, February 21 2015, 10:00 AM


Where
CORRECT!V 
Singerstr. 109
10179 Berlin

Contact
Simon, @sjockers
simon.jockers(ät)correctiv.org

---

http://oddber15.hackdash.org/

IDEAS
===== 

Public-private partnerships (PPP) in Germany (Simon)
Gather and visualize data about public-private partnerships. 
Some background (in German): http://www.welt.de/perint/wams/article124667018/Der-verkaufte-Staat.html

Potential data sources:
- http://www.oepp-plattform.de/
- http://www.ppp-projektdatenbank.de/index.php?id=9

---

Justizgelder (Stefan)
Work with our "Court Donations Database". 
This database contains all money flows from the years 2011 to 2013 from judges and public attorneys to local organizations in Germany. 
We have more data from recent years available if you're interested in working with Tabula, OpenRefine and similar tools.
https://apps.correctiv.org/justizgelder/
https://apps.correctiv.org/justizgelder/details/

---

Sparkassen (Jonathan)
Details tba. Questions are, for example:
- Visualization of the regional merging of local banks
- what does your local bank director earn? 
- what's the equity of your local bank compared to other big banks / how did Basel II (2007) and Basel III (2013) change the equity of your local bank

---

Nursing homes (Daniel)
Data on nursing homes is accessible through pflegelotse.de or pflegeheim-navigator.de. The data is inaccessible and the ratings are flawed.
- scraping the data: location, ratings, capacity, prices etc.
- analyzing and visualizing the data to see structures / problems, for example: who are the big players? regional differences? 
- scraping news about nursing homes and elderly homes -> attaching news reports to special homes, making scandals, problems, news reports accessible

There is a new rating system in place for elderly homes since 2014:  http://www.pflegenoten.de/bewertungssystematik/pflegeheime/berechnung_der_noten/berechnung_der_noten_fuer_pflegeheime.jsp

There are a bunch of experts who think this rating system is flawed. What you could do differently:
    
- Only use the rating system for "nursing" and "medical treatment" (the most important categories)
- Because every nursing home gets a good rating you have to emphasize the differences 
- A "traffic light system" using a system based on a national average

This project is a long-term project at CORRECT!V. If you like the project, we are thankful for every help. We are planning to publish more on this in the long run.

Vanessa Wormer is a Data fellow at CORRECT!V, she's at the ODD in Heilbronn today but we can reach her through Skype

---

Berlin Bicycle Accident Locations (Michael)
- I (@data_meining) have scraped and geocoded the locations of all accidents from 2011 to 2013 - Source: http://www.berlin.de/polizei/aufgaben/verkehrssicherheit/verkehrsunfallstatistik/#radfahrer
- We could do awesome stuff with this data - and Berlin isn't exactly doing well bicycle policy wise: http://www.tagesspiegel.de/berlin/stillstand-in-der-verkehrspolitik-von-berlin-der-senat-bremst-die-radler-aus/11377194.html
First result: Bicycle Accidents and Bicycle Paths: http://data-meining.cartodb.com/viz/52328f0e-b9e3-11e4-a36d-0e9d821ea90d/embed_map

BerlinPass Karte [Andreas]
http://greengiraffe.github.io/berlinpass-map/
- used dataset: http://daten.berlin.de/datensaetze/angebote

Berliner Schulen - Finde die passende Schule für dein Kind (Hans-Helge)
GitHub: https://github.com/ini20/berliner-schulen
- project schools on a map
- easy filter functionality
- detail pages for school displaying more information

OParl Client (Lucas)
- OParl is a not yet released JSON standard for data from parliament information systems (Ratsinformationssystem) in Germany
- In those system the result of the political debate ist stored, so there are a lot of different web services you could build 
- We want to write a client as a real world test to find out how well the standard works and improve it!
- http://oparl.org/
- As an example, the information system of Friedrichshain-Kreuzberg: https://www.berlin.de/ba-friedrichshain-kreuzberg/politik-und-verwaltung/bezirksverordnetenversammlung/online/allris.net.asp?
- https://pad.okfn.org/p/OpenDataDayBerlin2015OparlClient

New OKFN.DE (Nadine)
https://github.com/okfde/okfn.de
i
Deportation data (Ulrike)
 - data research!!
 - http://codefor.de/projekte/2014-09-03-abschiebungen.html
 - http://community.codefor.de/abschiebungen
 

OpenCorporates (Knut)
 - Scraper Missions and beta test the meetup!

Refugees - UNHCR data (Katja)
 - visualisation with maybe cartodb

Berlin Pass (Valentin)
- visualization of all places in a map
- Data: http://daten.berlin.de/datensaetze/angebote
- Github: https://github.com/greengiraffe/berlinpass-map