Conscape: Mapping Berlin’s Live Music Scene
•
8 likes•1,758 views
1. The document discusses mapping Berlin's live music scene by showing venues, genres, and additional data layers on an interactive map. 2. It collected data on music events from sources like Last.fm, and grouped events by genre using tags from artists. 3. The map analysis aimed to reveal patterns about genres in different areas of Berlin and how the music scene has changed over time.
Conscape: Mapping Berlin’s Live Music Scene
- 1. Hello!
- 2. Julian Florian Jeremias Stahnke Schulz Volker
- 3. We are interaction design students at FH Potsdam.
- 4. Usability Graphic Coding Design Interaction Design
- 12. Mapping Berlin’s Live Music Scene
- 14. Show venues/gigs on a map Show what genres are popular in certain areas Change over time Show additional layers (that might affect all of the above) - Rents - East vs West - Public transportation - Tourist attractions - Flickr photos - Nearby bars/restaurants/etc. Gig reviews Tweets Newspaper articles/stories/texts about clubs/important gigs
- 15. How we got the data Skipping the design phase Interesting ndings The truth behind ticket prices What we learned
- 16. How We Got the Data
- 19. { "event": { "id": "62021", "title": "David Hasselhoff", "artists": { "artist": "David Hasselhoff", "headliner": "David Hasselhoff" }, "attendance": "6", "startDate": "Sun, 31 Dec 1989 20:00:00", "reviews": "0", "tag": "lastfm:event=62021", "url": "http://www.last.fm/event/62021+David+Hasselhoff+at+Berlin+Wall+on+31+December+1989", "website": "", "tickets": "n ", "cancelled": "0", "description": "", "venue": { "id": "8792359", "name": "Berlin Wall", "location": { "geo:point": { "geo:lat": "52.516111", "geo:long": "13.376944" }, "city": "Berlin", "country": "Germany", "street": "", "postalcode": "" }, "url": "http://www.last.fm/venue/8792359+Berlin+Wall", "website": "", "phonenumber": "", "image": [{
- 20. { "event": { "id": "62021", "title": "David Hasselhoff", "artists": { "artist": "David Hasselhoff", "headliner": "David Hasselhoff" }, "attendance": "6", "startDate": "Sun, 31 Dec 1989 20:00:00", "reviews": "0", "tag": "lastfm:event=62021", "url": "http://www.last.fm/event/62021+David+Hasselhoff+at+Berlin+Wall+on+31+December+1989", "website": "", "tickets": "n ", "cancelled": "0", "description": "", "venue": { "id": "8792359", "name": "Berlin Wall", "location": { "geo:point": { "geo:lat": "52.516111", "geo:long": "13.376944" }, "city": "Berlin", "country": "Germany", "street": "", "postalcode": "" }, "url": "http://www.last.fm/venue/8792359+Berlin+Wall", "website": "", "phonenumber": "", "image": [{
- 25. Pop Bastard Pop Beatmusik Bebop Modern Jazz Britpop Easy Listening Electro Pop Future Pop HipHop hip-hop hip hop Britcore TripHop J-Pop Japan Pop New Wave Dark Wave Electro Wave Minimal Electro Neue Deutsche Welle Synthpop Rhythm & Blues RnB Skif e Black
- 26. This screen intentionally left blank.
- 27. SELECT events.title, event_artists.tag_list FROM events INNER JOIN ( SELECT event, COUNT(*) AS anzahl, GROUP_CONCAT(artist_tag_list SEPARATOR ',') as tag_list FROM event_artists INNER JOIN ( SELECT artist, GROUP_CONCAT(tag SEPARATOR ',') as artist_tag_list FROM artist_tags GROUP BY artist ) artist_tags ON event_artists.artist = artist_tags.artist GROUP BY event ) event_artists ON event_artists.event = events.id ORDER BY event_artists.anzahl DESC
- 28. number of events average visitors 5,000 20 3,750 15 2,500 10 1,250 5 1958 1960 1962 1964 1966 1968 1970 1972 1974 1976 1978 1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 2008 2010 Biggest event Berlin Festival 2010 10th September 2010 First event 1,875 attendees Tattooine @ Grüner Salon 26th January 1958 0 attendees Most artists at one event CTM.10 – Club Transmediale @ WMF 28th January – 7th February 2010 99 artists
- 29. Skipping the Design Phase
- 35. map.addEventListener(GestureEvent.GESTURE_SCALE, onZoom); map.addEventListener(TouchEvent.TOUCH_MOVE, onMapMove);
- 46. What we found out
- 48. Average Number of Events 3000 2250 1500 750 0 January February March April May June July August September October November December
- 49. Average Attendees 16 12 8 4 0 January February March April May June July August September October November December
- 52. The truth behind ticket prices
- 54. Number of eBay Auctions (January 12 — February 1) System of a Down 54 Justin Bieber 29 Der W 19 Kylie Minogue 15 Beatsteaks 14 Alive And Swingin’ 12 Roxette 10 Usher 9 Godspeed You! Black Emperor 8 Katie Melua 8 Mario Barth 7 The National 4 Herbert Grönemeyer 4 James Blunt 4 Eagles 3 PJ Harvey 2 Ne-Yo 2 Kim Wilde in Berlin 2 José González 2 The Script 2 The Sisters of Mercy 1 Jennifer Rostock 1 Jamiroquai 1 Cold War Kids 1 Bright Eyes 1 A Day to Remember 1 Chris De Burgh & Band 1 Adele 1 The Wall Live 1 Sade 1 0 15 30 45 60
- 55. Difference of Black Market Price compared to Official Price (January 12 — February 1) y Auctions (January 12 — February 1) 125% Justin Bieber 579% Der W 169% Kylie Minogue 199% Beatsteaks 79% Alive And Swingin’ 175% Roxette 164% Usher 96% Godspeed You! Black Emperor 115% Katie Melua 223% Mario Barth 95% The National 212% Herbert Grönemeyer 245% James Blunt 228% Eagles 101% PJ Harvey 195% Ne-Yo 19% Kim Wilde in Berlin -23% José González 153% The Script 67% The Sisters of Mercy 13% Jennifer Rostock 228% Jamiroquai -25% Cold War Kids 124% Bright Eyes 115% A Day to Remember 122% Chris De Burgh & Band 234% Adele 275% The Wall Live 203% Sade 26% -100% 0% 100% 200% 300% 400% 500% 600%
- 56. What we learned
- 57. Design is important. Especially for design students.
- 58. Design is important. Especially for design students. Find the right story to tell. And then tell it.
- 59. Design is important. Especially for design students. Find the right story to tell. And then tell it. Multi-touch is only fun if it’s good.
- 60. Thanks! @get ourish @julians jerry@sinnbus.de https://get ourish.github.com/Conscape-as3 (im Laufe des Abends)