Day #2: Art on Auction

For test purposes, we collected data from an art auction website which contains data about each item on auction:

We downloaded a test set of 200 visual art auction pages and found out that 27% was made with oil, 7 % were prints, and 3 % painted with acrylic. The top 4 art selling cities are Berlin (15 % of available art in the auction), Otzberg (6 %), Frankenthal (3 %), and Essen (3 %).

Art auction data gives a new insight into art: what is available, what are the average or median prices of different art forms such as acrylic paintings, or what are the most active art selling cities.

Perhaps such data could also be used for following art trends among specific geographical regions. For example, based on our dataset, Planegg turned out to be a very lively art selling municipality. We also noticed interesting niche (?) art forms, such as “Afrikabild”

Posted in Uncategorized | Leave a comment

Photos from day #2

Posted in Uncategorized | Leave a comment

Day #2: Visualizing rents in Berlin

During the day two, our efforts were mainly focused on processing the data of rents in Berlin. These three visualizations portrait the average price of rental apartments, price is euros per square meter. The data is scraped from the net, we did the calculations and visualization during our workshops at DMY Berlin.

This one is by Ottavia:

This one is by Anu:

And this one by Chiara:

Posted in Uncategorized | Leave a comment

Day #2: The most expensive flat in Berlin

We scraped the data of 10 000 flats for rent in Berlin. Today we have been processing the data in our workshop at DMY Berlin festival. One interesting result is this, the most expensive apartment in Berlin, if you look at price per square meter. This aparment in party-street Simon-Dach-Strasse costs 28 euros per square meter, 1400 euros per month.

(Link to google cache)

Posted in Uncategorized | Leave a comment

Day 1: Network analysis of German government supporters

Here’s a very simple visualisation of German Bundesregierung supporters. All these companies have donated money to the two governing parties FDP and CDU. Look previous post for sums.

This is made with Cytoscape and the data is from www.parteispenden.unklarheiten.de

Posted in Uncategorized | Leave a comment

Supporters of parties governing Germany

Where does the German government get it’s money? Here’s the list of ten top campaign donors from beginning of 2000′s. I’m collecting the data to make network analysis. Here’s the source.

 

German Bank AG CDU 2721000
Southwest Metal CDU 2241000
Daimler Chrysler AG CDU 1761000
Altana AG CDU 1476000
German Bank AG FDP 1287000
VB of the Chemical Industry Association CDU 1135000
Substantia AG (VM Holding AG) FDP 1100000
VB of the metal and electrical industry NRW e. V. CDU 1087000
BMW AG CDU 1031000
Bancassurance German Investment Advisory Ltd. DVAG CDU 1006000
German Bank AG CDU 2721000
Southwest Metal CDU 2241000
Daimler Chrysler AG CDU 1761000
Altana AG CDU 1476000
German Bank AG FDP 1287000
VB of the Chemical Industry Association CDU 1135000
Substantia AG (VM Holding AG) FDP 1100000
VB of the metal and electrical industry NRW e. V. CDU 1087000
BMW AG CDU 1031000
Bancassurance German Investment Advisory Ltd. DVAG CDU 1006000
Posted in Uncategorized | Leave a comment

Day 1#: Kinoatlas.de shows movies on map

Markus Gräser, a berliner open data enthusiast visited our booth. He is interested in mapping services, and suggested we should map our rent data.

He has also made one map-based service himself: kinoatlas.de

It shows movies going in Berlin on a map. Great work!

Posted in Uncategorized | Leave a comment

Day 1: Ideas so far, party spending and artist

We are currently having the workshop on how to process open data at DMY Berlin. Our idea is to gather data on housing prices on Berlin. We have scraped 10 000 house prices, locations and sizes and are currently transforming them to excel file.

People have also brought their ideas to us. Here’s few:

- www.berlinerpool.de has information on artists. How could we visualize it?
- www.parteispenden.unklarheiten.de has info on party spending. How to make it more easily understandable?

Posted in Uncategorized | Leave a comment

Photos: day 0

The We Love Open Data team is now in Berlin – ready to rock. Here are some first photos from Wednesday from the opening evening of the DMY. Welcome to do open data every day at 15.00!

Posted in Uncategorized | Leave a comment

We have workshops at DMY Berlin

We have three workshops at DMY Berlin festival. Feel free to participate.

Gathering Open Data

The We Love Open Data team is on a mission to find interesting open data sources from Germany. The data will be used in the data visualization workshops during the two following days. We are looking for suggestions for interesting data sources – please come and have a chat with us.

Time: THURSDAY 2 JUNE, starting at 15:00.

Processing Open Data

Open data does not have much value unless it’s in a format that is easy to manipulate. Our basic tutorial will give you some valuable tips on how to get started with working on open data. First we gather some data from the web, then we process it. The advanced workshop will focus on complex data sets with current political/cultural relevance. Please bring a laptop, data will be provided. Tools: spreadsheets, database programs, web-based platforms.

Time: FRIDAY 3 JUNE, starting at 15:00. Duration 1-2 hours (basic tutorial) or 4-5 hours (advanced). Max 10 participants.

Visualising Open Data

Learn the basics of data visualization or join us to work on more challenging visualisations, using data sources that have current political/cultural relevance. Please bring a laptop and your own visualisation tools: Photoshop, Illustrator, Gimp, Paint, paper&crayons. We will also experiment with various scripting languages (such as Javascript) to create interactive visualisations. Data will be provided.

Time: SATURDAY 4 JUNE, starting at 15:00. Duration 1-2 hours (basic tutorial) or 4-5 hours (advanced). Max 10 participants.

Posted in General | Leave a comment