Guru Session: Data Driven Storytelling (Nerderlands edition)

The session takes place in the Commandantswoning 001. See the map: http://marineterrein.nl/nl/praktisch/plattegrond/

Data has gone from scarce to superabundant. That brings huge new possibilities. However, few people know how to process and analyse all this information. When you're able to analyse (big) data in order to make connections, the sky is the limit for you to create unique stories...

FINAL CALL! Are you a journalist and are you interested in big data and visualizations? Join us then for this challenge on Thursday August 18.

For this special event Bill Ferster (VisualEyes (http://www.viseyes.org/)) is joining forces with Teun Gautier (founder of De Coöperatie (https://decooperatie.org/)) for a data driven storytelling Guru Session. After an introduction, it will be up to the journalists and hackers...

Agenda

• 10:00 doors open & coffee

• 10:30 introduction visualization, walk through making a project, and announcement of today's topic/challenge by Bill Ferster and Teun Gautier

• 12:00 team forming

• 12:30 lunch

• 13:00 hack-a-gogo

• 16:00 team presentations

• 17:30 Announcement of today's winners, networking, free pizza & BBQ thanks to Schuberg Philis (https://www.schubergphilis.com/). Please take some cash with you for the drinks. And feel free to hang around for the next session:

• 19:00 Interactive Storytelling meetup (https://www.facebook.com/events/1592899041009464/)

Preparations before entering the session

• Look (http://www.viseyes.org/viseyes.htm) at VisualEyes site for past projects
• Look (http://www.viseyes.org/visualeyes) at VisualEyes 5 sample project
• Watch (http://www.youtube.com/watch?v=BG1VaBPThZ8&feature=youtu.be) the screencast on how to make projects
• Peek at the documentation, found here (https://docs.google.com/document/d/161td5ZuqKqT5R5r9z1P8AxBA6l9LaP-eYl_RvCyvw2g/edit?usp=sharing)
• Think about your own projects
• Think about data to support your projects
• Don’t forget to bring your laptop!

About digital visualization

Digital visualization is a new tool for telling stories using data and digital artifacts from the real world. The goal of this session is to create visualizations using a new tool that is developed at the University of Virginia called VisualEyes. VisualEyes is an HTML5 web-based authoring tool to weave images, maps, charts, video and data into highly interactive and compelling dynamic visualizations. See some examples here (http://www.viseyes.org/viseyes.htm).

Additional tools

On viseyes.org (http://viseyes.org/) you will find other great tools that you can use:

SHIVA (http://www.viseyes.org/shiva/): fast and easy creation visualizations in HTML (use with Visualeyes!).
Qmedia (http://www.qmediaplayer.com/): create interactive videos.

Sample data sets

Together with the folks of data.amsterdam.nl (http://data.amsterdam.nl/) we have prepared a couple of data sets you may use. As most files are in CVS formats we have created Excel versions to save you time. Where needed we added a column for GPS locations that you can use straight away.

Source: http://maps.amsterdam.nl/open_geodata/

In the Excel files data filtering is enabled (pull down arrows in header row). You can use those to find a usable subset for Visualeyes. Example: some records in the data sets have links to pictures. Filter on "nonblanks" to only display entries what have a picture....

Tip: as the bottom of the filter menu you see normally see "show blanks" and "show nonblanks". Some times scrolling down takes a long time. Then create a custom filer (at the top of the menu): select "does not equal to" and leave the field empty. That works the same.

In this Excel file (http://files.camerize.com/datahack/visualeyes_column_calculations.xlsx) you will find examples of how to derive Visualize columns from other data columns. Select "show comments" for details.

THE HISTORY OF TRAFFIC LIGHTS

Traffic lights, info and example (http://maps.amsterdam.nl/verkeerslichten/?LANG=en)
• CVS file (http://files.camerize.com/datahack/verkeerslichten/VERKEERSLICHTEN.csv)
• Excel file (http://files.camerize.com/datahack/verkeerslichten/VERKEERSLICHTEN.xlsx)

PUBLIC SPACE REPORTS (complaints/queries/reports of citizens)New and outstanding reports are public. Close reports are not (yet). These sets contain sustantial amounts of data. Tip use filtering on sub category to find arelevant subset.

Waste, example (https://kaart.amsterdam.nl/datasets/datasets-item/t/mor-afval-1)
• CVS file (http://files.camerize.com/datahack/meldingen/mor-afval-1.csv)
• Excel file (http://files.camerize.com/datahack/meldingen/mor-afval-1.xlsx)

Public water and greenery, example (https://kaart.amsterdam.nl/datasets/datasets-item/t/mor-openbaar-groen-en-water)
• CVS file (http://files.camerize.com/datahack/meldingen/mor-openbaar-groen-en-water.csv)
• Excel file (http://files.camerize.com/datahack/meldingen/mor-openbaar-groen-en-water.xlsx)

Public space and nuisance, example (https://kaart.amsterdam.nl/datasets/datasets-item/t/mor-openbare-ruimte-en-overlast)
• CVS file (http://files.camerize.com/datahack/meldingen/mor-openbare-ruimte-en-overlast.csv)
• Excel file (http://files.camerize.com/datahack/meldingen/mor-openbare-ruimte-en-overlast.xlsx)

Roads, traffic and street furniture, example (https://kaart.amsterdam.nl/datasets/datasets-item/t/mor-wegen-verkeer-en-straatmeubilair-1)
• CVS file (http://files.camerize.com/datahack/meldingen/mor-wegen-verkeer-en-straatmeubilair-1.csv)
• Excel file (http://files.camerize.com/datahack/meldingen/mor-wegen-verkeer-en-straatmeubilair-1.xlsx)

ESTATE & ESTATE PROJECTS

Vacant Office buildings, example (http://maps.amsterdam.nl/leegstandskaart/?LANG=en)
• CVS file
• Excel file (http://files.camerize.com/datahack/gebouwen/LEEGSTANDSKAART.xlsx)
• No timestamps, use the number of vacant years and you have a date.

Monuments, example (http://maps.amsterdam.nl/monumenten/)
• CVS file (http://files.camerize.com/datahack/gebouwen/MONUMENTEN.csv)
• Excel file (http://files.camerize.com/datahack/gebouwen/MONUMENTEN.xlsx)
• There is a massive amount of monuments. Using filtering a sub-selection can be made (hint: for example only those that have picture).
• The year of construction is not there, but can be traced through this API (https://api.datapunt.amsterdam.nl/atlas/search/adres/?q=Amstel%201)

Housing Construction Plans, example (http://maps.amsterdam.nl/woningbouwplannen/?LANG=en)
• CVS file (http://files.camerize.com/datahack/gebouwen/WONINGBOUWPLANNEN.csv)
• Excel file (http://files.camerize.com/datahack/gebouwen/WONINGBOUWPLANNEN.xlsx)
• This set contains polygons, but there also is a center lat/lon column.

• Large infrastructure projects (advanced)http://open.datapunt.amsterdam.nl/Projecten_Amsterdam_GeoJson.json
• In GeoJSON, and polygons in National Triangulation System coordinates (Rijksdriehoekcoordinatenstelsel).

This event is part of Nerderlands (http://www.nerderlands.com/), a new festival organized by Amsterdam's finest tech communities.