You are browsing the archive for School of Data.

Αξιολόγηση 1ου Σχολείου Δεδομένων

Χριστίνα Καρυπίδου - December 1, 2017 in Featured, Featured @en, News, School of Data, ανοικτά δεδομένα, Νέα, συμμετοχικός προϋπολογισμός, σχολείο δεδομένων

Θετική και με ενδιαφέροντα ευρήματα είναι η γενική αξιολόγηση του 1ου Σχολείου Δεδομένων στην Περιφέρεια Δυτικής Μακεδονίας για στελέχη της ηλεκτρονικής διακυβέρνησης των ΟΤΑ, όπως διαπιστώνεται από τις απαντήσεις των συμμετεχόντων σε σχετικό ερωτηματολόγιο. Ειδικότερα: Μόλις το ¼ των συμμετεχόντων είχε γνώση του νόμου Ν.4305/2014 σχετικά με τα ανοικτά δεδομένα, ως εκ τούτου, η πλειοψηφία των […]

Open Data Day 2016 Malaysia Data Expedition – Measuring Provision of Public Services for Education

Mor Rubinstein - March 28, 2016 in data expedition, Open Data Day, School of Data

International Open Data DayThis blog post was written by the members of the Sinar project in Malaysia  In Malaysia, Sinar Project with the support of Open Knowledge International organised a one-day data expedition based on the guide from School of Data to search for data related to government provision of health and education services. This brought together a group of people with diverse skills to formulate questions of public interest. The data sourced would be used for analysis and visualisation in order to provide answers.

Data Expedition

School of Data D&D Character Sheet GiraffeA data expedition is a quest to explore uncharted areas of data and report on those findings. The participants with different skillsets gathered throughout the day at the Sinar Project office. Together they explored data relating to schools and clinics to see what data and analysis methods are available to gain insights on the public service provision for education and health. We used the guides and outlines for the data expedition from School of Data website. The role playing guides worked as a great ice breaker. There was healthy competition on who could draw the best giraffes for those wanting to prove their mettle as a designer for the team.    

Deciding what to explore, education or health?

The storyteller in the team, who was a professional journalist started out with a few questions to explore.
  • Are there villages or towns which are far away from schools?
  • Are there villages or towns which are far away from clinics and hospitals?
  • What is the population density and provision of clinics and schools?
The scouts then went on a preliminary exploration for whether this data exists.

Looking for the Lost City of Open Data

The Scouts, with the aid of the rest of the team, looked for data that could answer the questions. They found a lot of usable data from the Malaysian government open data portal data.gov.my. This data included lists of all public schools and clinics with addresses, as well as numbers of teachers for each district. It was decided by the team that given the time limitation, the focus would be to answer the questions on education data. Another priority was to find data relating to class sizes to see if schools are overcrowded or not. Below you can see the data that the team found.  School of Data D&D Character Sheet 2

Education

Open Data

Data in Reports

 

Definitions

Not all schools are created equal, there are different types, some are considered as high achieving schools or Sekolah Berprestasi Tinggi

Health

Open Data

GIS

 

Other Data

CIDB Construction Projects contains relevant information such as construction of schools and clinics Script to import into Elastic Search

Budgets

Sinar Project had some budgets as open data, at state and federal levels that could be used as additional reference point. These were created as part of the Open Spending project.

Selangor State Government

http://data.sinarproject.org/dataset/selangor-state-government-2015-budget

Federal Government

Higher education
Education

Participants

Methodology

The team opted to focus on the available datasets to answer questions about education provision, by first converting all school addresses into geocoding, and then looking at joining up data to find out the relationship between enrollments, school and teacher ratios.

Joining up data

To join up data; the different data sets such as teacher numbers and schools, VLOOKUP function in Excel was used to join by School code.

Converting Address to geolocation (latlong)

To convert street addresses to latitude, longitude coordinates we used the dataset with the cleansed address’ along with a geocoding tool csvgeocode ./node_modules/.bin/csvgeocode ./input.csv ./output.csv --url "https://maps.googleapis.com/maps/api/geocode/json?address={{Alamat}}&key=" --verbose

Convert the completed CSV to GeoJSON points

Use the  csv2geojson <span style="font-weight: 400;">csv2geojson --lat "Lat" --lon "Lng" Selangor_Joined_Up_Moe.csv</span>

To get population by PBT

Use the data from state economic planning unit agency site for socio-economic data specifically section Jadual 8

To get all the schools separated by individual PBT (District)

UseGeoJSON of Schools data and PBT Boundary loaded into QGIS; and use the Vector > Geo-processing > Intersect.   A post from Stack Exchange suggests  it might be better to use Vector > Spatial Query > Spatial Query option.

Open Datasets Generated

The cleansed and joined up datasets created during this expedition are made available on GitHub. While the focus was on education, due to the similarity in available data, the methods were also applied to clinics also. See it on our repository – https://github.com/Sinar/SinarODD2016

Visualizations

All Primary and Secondary Schools on a Map with Google Fusion Tables

All Primary and Secondary Schools on a Map with Google Fusion Tables https://www.google.com/fusiontables/DataSource?docid=1lVyjIIEm_McqmiSEfQY5vecrhqRjmaJ1wzdiEo1q#map:id=7

Teacher to Students per school ratios

Teacher to Students per school ratios https://www.google.com/fusiontables/DataSource?docid=18ieB8OqzpK3Ch9KcD4BiiADdmk8SXnS0x_IINxHc#map:id=3  

Discovery

  • Teachers vs enrollment did not provide data relating to class size or overcrowding
  • Demographic datasets to measure schools to eligible population
  • More school datasets required for teachers, specifically by subject and class ratios
  • Methods used for location of schools can also be applied to clinics & hospital data
It was discovered that additional data was needed to provide useful information on the quality of education. There was not enough demographic data found to check against the number of schools in a particular district. Teacher to student ratio was also not a good indicator of problems reported in the news. The teacher to enrollment ratios was generally very low with a mean of 13 and median of 14. What was needed, was ratio by subject teachers, class size or against the population of eligible children of each area, to provide better insights. Automatically calculating the distance from points was also considered and matched up with whether there are school bus operators in the area. This was discussed because the distance from schools may not be relevant for rural areas, where there were not enough children to warrant a school within the distance policy. A tool to check distance from a point to the nearest school could be built with the data made available. This could be useful for civil society to use data as evidence to prove that distance was too far or transport not provided for some communities. Demographic data was found for local councils; this could be used by researchers using local council boundary data on whether there were enough schools against the population of local councils. Interestingly in Malaysia, education is under Federal government and despite having state and local education departments, the administrative boundaries do not match up with local council boundaries or electoral boundaries. This is a planning coordination challenge for policy makers. Administrative local council boundary data was made available as open data thanks to the efforts of another civil society group Tindak Malaysia, which scanned and digitized the electoral and administrative boundaries manually.

Running future expeditions

This was a one day expedition so it was time limited. For running these brief expeditions we learned the following:
  • Focus and narrow down expedition to specific issue
  • Be better prepared, scout for available datasets beforehand and determine topic
  • Focus on central repository or wiki of available data
Thank you to all of the wonderful contributors to the data expedition:
  • Lim Hui Ying (Storyteller)
  • Haris Subandie (Engineer)
  • Jack Khor (Designer)
  • Chow Chee Leong (Analyst)
  • Donaldson Tan (Engineer)
  • Michael Leow (Engineer)
  • Sze Ming (Designer)
  • Swee Meng (Engineer)
  • Hazwany (Nany) Jamaluddin (Analyst)
  • Loo (Scout)

Data in December: Sharing Data Journalism Love in Tunisia

Ali Rebaie - January 11, 2016 in Big Data, Data Blog, Data Expeditions, Data for CSOs, Data Journalism, data science, data visualization, Open Data, School of Data, Tunisia

NRGI hosted the event #DataMuseTunisia in collaboration with Data Aurora and School of Data senior fellow Ali Rebaie on the 11th of December 2015 in beautiful Tunis where a group of CSO’s from different NGOs met in the Burge Du Lac Hotel to learn how to craft their datasets and share their stories through creative visuals. Bahia Halawi, one of the leading women data journalism practitioners in the MENA region and the co-founder at Data Aurora, led this workshop for 3 days. This event featured a group of professionals from different CSO’s. NRGI has been working closely with School of Data for the sake of driving economic development & transparency through data in the extractive industry. Earlier this year NRGI did similar events in Washington, Istanbul, United Kingdom, GhanaTanzania, Uganda and many others. The experience was very unique and the participants were very excited to use the open source tools and follow the data pipeline to end up with interactive stories. The first day started with an introduction to the world of data driven journalism and storytelling. Later on, participants checked out some of the most interesting stories worldwide before working with different layers of the data pipeline. The technical part challenged the participants to search for data related to their work and then scraping it using google spreadsheets, web extensions and scrapers to automate the data extraction phase. After that, each of the participants used google refine to filter and clean the data sets and  then remove redundancies ending up with useable data formats. The datasets were varied and some of them were placed on interactive maps through CartoDB while some of the participants used datawrapper to interactively visualize them in charts. The workshop also exposed participants to Tabula, empowering them with the ability of transforming documents from pdfs to excel. Delegates also discussed some of the challenges each of them faces at different locations in Tunisia. It was very interesting to see 12321620_1673319796270332_5440100026922548095_nparticipants share their ideas on how to approach different datasets and how to feed this into an official open data portal that can carry all these datasets together. One of the participants, Aymen Latrach, discussed the problems his team faces when it comes to data transparency about extractives in Tataouine. Other CSO’s like Manel Ben Achour who is a Project Coordinator at I WATCH Organization came already from a technical backgrounds and they were very happy to make use of new tools and techniques while working with their data. Most of the delegates didn’t come from technical backgrounds however and this was the real challenge. Some of the tools, even when they do not require any coding, mandate the knowledge about some technical terms or ideas. Thus, each phase in the data pipeline started with a theoretical explanatory session to familiarize delegates with the technical concepts that are to be covered. After that, Bahia had to demonstrate the steps and go around the delegates facing any problems to assist them in keeping up with the rest of the group. It was a little bit messy at the beginning but soon the participants got used to it and started trying out the tools on their own. In reality, trial and error is very crucial to developing the data journalism skills. These skills can never be attained without practice. 11232984_1673319209603724_5889072769128707064_n Another important finding, according to Bahia who discussed the importance of the learnt skills to the delegate’s community and workplace, is that each of them had his/her own vision about its use. The fact that the CSO’s had a very good work experience allowed them to have unique visions about the deployment of what they have learnt at their workplaces. This, along with the strong belief in the change open data portals can drive in their country are the only triggers to learning more tools and skills and bringing out better visualizations and stories that impact people around. The data journalism community 3 years ago was still at a very embryonic stage with few practitioners and data initiatives taking place in Africa and Asia. Today, with enthusiastic practitioners like Bahia Halawi and Ali Rebaie, and a community like School of Data spreading the love of data and the spirit of change it can make, the data journalism field has very promising expectations. The need for more initiatives and meet ups to develop the skills of CSOs in the extractive industries as well as other fields remains a priority for reaching out for true transparency in every single domain.  Thank you, You can connect with Bahia on Twitter @HalawiBahia. Flattr this!

Join the School of Data team: Technical Trainer wantd

Open Knowledge International - November 9, 2015 in Featured, Jobs, School of Data

Background

The mission of Open Knowledge International is to open up all essential public interest information and see it utilized to create insight that drives change. To this end we work to create a global movement for open knowledge, supporting a network of leaders and local groups around the world; we facilitate coordination and knowledge sharing within the movement; we build collaboration with other change-making organisations both within our space and outside; and, finally, we prototype and provide a home for pioneering products. A decade after its foundation, Open Knowledge International is ready for its next phase of development. We started as an organisation that led the quest for the opening up of existing data sets – and in today’s world most of the big data portals run on CKAN, an open source software product developed first by us. Today, it is not only about opening up of data; it is making sure that this data is usable, useful and – most importantly – used, to improve people’s lives. Our current projects (School of Data, OpenSpending, OpenTrials, and many more) all aim towards giving people access to data, the knowledge to understand it, and the power to use it in our everyday lives. The School of Data is growing in size and scope, and to support this project – alongside our partners – we are looking for an enthusiastic Technical Trainer (flexible location, part time). School of Data is a network of data literacy practitioners, both organisations and individuals, implementing training and other data literacy activities in their respective countries and regions. Members of the School of Data work to empower civil society organizations (CSOs), journalists, governments and citizens with the skills they need to use data effectively in their efforts to create better, more equitable and more sustainable societies. Over the past four years, School of Data has succeeded in developing and sustaining a thriving and active network of data literacy practitioners in partnership with our implementing partners across Europe, Latin America, Asia and Africa. Our local implementing partners are Social TIC, Code for Africa, Metamorphosis, and several Open Knowledge chapters around the world. Together, we have produced dozens of lessons and hands-on tutorials on how to work with data published online, benefitting thousands of people around the world. Over 4500 people have attended our tailored training events, and our network has mentored dozens of organisations to become tech savvy and data driven. Our methodologies and approach for delivering hands-on data training and data literacy skills – such as the data expedition – have now been replicated in various formats by organisations around the world. One of our flagship initiatives, the School of Data Fellowship Programme, was first piloted in 2013 and has now successfully supported 26 fellows in 25 countries to provide long-term data support to CSOs in their communities. School of Data coordination team members are also consistently invited to give support locally to fellows in their projects and organisations that want to become more data-savvy. In order to give fellows a solid point of reference in terms of content development and training resources, and also to have a point person to give capacity building support for our members and partners around the world, School of Data is now hiring an outstanding trainer/consultant who’s familiar with all the steps of the Data Pipeline and School of Data’s innovative training methodology to be the all-things-content-and-training for the School of Data network.

Objectives

The hired professional will have three main objectives:
  • Technical Trainer & Data Wrangler: represent School of Data in training activities around the world, either supporting local members through our Training Dispatch or delivering the training themselves;
  • Data Pipeline & Training Consultant: give support for members and fellows regarding training (planning, agenda, content) and curriculum development using School of Data’s Data Pipeline;
  • Curriculum development: work closely with the Programme Manager & Coordination team to steer School of Data’s curriculum development, updating and refreshing our resources as novel techniques and tools arise.

Terms of Reference

  • Attend regular (weekly) planning calls with School of Data Coordination Team;
  • Work with current and future School of Data funders and partners in data-literacy related activities in an assortment of areas: Extractive Industries, Natural Disaster, Health, Transportation, Elections, etc;
  • Be available to organise and run in person data-literacy training events around the world, sometimes in short notice (agenda, content planning, identifying data sources, etc);
  • Provide reports of training events and support given to members and partners of School of Data Network;
  • Work closely with all School of Data Fellows around the world to aid them in their content development and training events planning & delivery;
  • Write for the School of Data blog about curriculum and training events;
  • Take ownership of the development of curriculum for School of Data and support training events of the School of Data network;
  • Work with Fellows and other School of Data Members to design and develop their skillshare curriculum;
  • Coordinate support for the Fellows when they do their trainings;
  • Mentor Fellows including monthly point person calls, providing feedback on blog posts and curriculum & general troubleshooting;
  • The position reports to School of Data’s Programme Manager and will work closely with other members of the project delivery team;
  • This part-time role is paid by the hour. You will be compensated with a market salary, in line with the parameters of a non-profit-organisation;
  • We offer employment contracts for residents of the UK with valid permits, and services contracts to overseas residents

Deliverables

  • A lightweight monthly report of performed activities with Fellows and members of the network;
  • A final narrative report at the end of the first period (6 months) summarising performed activities;
  • Map the current School of Data curriculum to diagnose potential areas of improvement and to update;
  • Plan and suggest a curriculum development & training delivery toolkit for Fellows and members of the network

Requirements

  • Be self-motivated and autonomous;
  • Fluency in written and spoken English (Spanish & French are a plus);
  • Reliable internet connection;
  • Outstanding presentation and communication skills;
  • Proven experience running and planning training events;
  • Proven experience developing curriculum around data-related topics;
  • Experience working remotely with workmates in multiple timezones is a plus;
  • Experience in project management;
  • Major in Journalism, Computer Science, or related field is a plus
We strive for diversity in our team and encourage applicants from the Global South and from minorities.

Duration

Six months to one year: from November 2015 (as soon as possible) to April 2016, with the possibility to extend until October 2016 and beyond, at 10-12 days per month (8 hours/day).

Application Process

Interested? Then send us a motivational letter and a one page CV via https://okfn.org/about/jobs/. Please indicate your current country of residence, as well as your salary expectations (in GBP) and your earliest availability. Early application is encouraged, as we are looking to fill the positions as soon as possible. These vacancies will close when we find a suitable candidate. Interviews will be conducted on a rolling basis and may be requested on short notice. If you have any questions, please direct them to jobs [at] okfn.org.

In memory of Michael Bauer

Nikesh Balami - September 27, 2015 in Data Diva, Featured, Mchal, Memories, Open Knowledge, School of Data

Reblogged from School of Data Blog, licensed under Creative Commons Attribution-ShareAlike v3.0 License   “It was with great sadness that we learned last week that we had lost one of our greats. Michael Bauer passed away suddenly on 13th September 2015 while running the Wachau half marathon. In this post, the School of Data team (both past and present) remember what he gave to the project, and our favourite moments from working with him.” Michael joined School of Data as one of the first team members in 2012 and worked on the project up until October 2014. In this time, he trained and helped hundreds of activists from across the world and built an amazing community of likeminded people – a community which is now thriving, in large part due to the contributions and skills that Michael gave. His extraordinary intelligence and skills gave School of Data an “edge”; for him, anything done on the project had to be both educational and fun, else there was no point in doing it. He taught all of us personally a huge amount about what it means to be a ‘data trainer’. He was a great colleague, and an even better friend. The School of Data team is largely remote – we work from wherever we like and connect with each other online. This means we don’t see each other so often and most of our contact is done via emails, online meetings or, as usually was the case with Michael, Skype chats from airport lounges…
Playing ‘Where is Michael?’ was always a fun game.

Playing ‘Where is Michael?’ was always a fun game.

It also means that when we do meet in person, the time is precious. We travelled together across the world – and wow, did Michael travel. He was always up for spontaneous trips (sometimes with as little as twelve hours notice before intercontinental travel), for throwing himself into getting to know new communities, to spend nights dancing even with early starts due the next day. Colourful both in personality and turnout, we will always remember Michael in his shiny cape at Mozfest when we ran our first ever data expedition – our Data Diva. 8173097617_5ebd4a94b2_zPeople genuinely never forgot Michael – he was charismatic and commanded people’s attention. He managed to understand data and people, and he could inspire every single person he met, no matter how many were in the workshop. He was a true polymath, too – he went from medical doctor, to academic, to data trainer/coder, to a journalist – and all before the age of 35. To us, Michael was intelligent, always ready to help people, honest (sometimes painfully), funny and, as all the best people are, wonderfully awkward. Most of all, he was generous with his time, humble, and thoughtful. He managed to foster an environment where anyone could ask him a question, or for help on building something – and he would answer without any fuss, and with contagious enthusiasm. 8683527172_2ea6930fdf_o (1)As a key architect of many of School of Data’s workshop styles, particularly Data Clinics and Data Expeditions, his legacy lives on through the character sheets he made just 10 minutes before the first expedition started, and in many of the materials the community use today 8173129738_06a92976cb_m 8173096061_83bd95bac8_mWhen he moved on to derStandard.at, we were torn between happiness for him – that he was starting a new stage in his life – and sadness, that he was leaving our team. He was so excited about it though: finally, he would “stop talking about data journalism and start doing it.” As a leaving gift, we made him this video to show him how much we appreciated him. Watch it from YouTube.

In memory of Michael Bauer

Nikesh Balami - September 27, 2015 in Data Diva, Featured, Mchal, Memories, Open Knowledge, School of Data

Reblogged from School of Data Blog, licensed under Creative Commons Attribution-ShareAlike v3.0 License   “It was with great sadness that we learned last week that we had lost one of our greats. Michael Bauer passed away suddenly on 13th September 2015 while running the Wachau half marathon. In this post, the School of Data team (both past and present) remember what he gave to the project, and our favourite moments from working with him.” Michael joined School of Data as one of the first team members in 2012 and worked on the project up until October 2014. In this time, he trained and helped hundreds of activists from across the world and built an amazing community of likeminded people – a community which is now thriving, in large part due to the contributions and skills that Michael gave. His extraordinary intelligence and skills gave School of Data an “edge”; for him, anything done on the project had to be both educational and fun, else there was no point in doing it. He taught all of us personally a huge amount about what it means to be a ‘data trainer’. He was a great colleague, and an even better friend. The School of Data team is largely remote – we work from wherever we like and connect with each other online. This means we don’t see each other so often and most of our contact is done via emails, online meetings or, as usually was the case with Michael, Skype chats from airport lounges…
Playing ‘Where is Michael?’ was always a fun game.

Playing ‘Where is Michael?’ was always a fun game.

It also means that when we do meet in person, the time is precious. We travelled together across the world – and wow, did Michael travel. He was always up for spontaneous trips (sometimes with as little as twelve hours notice before intercontinental travel), for throwing himself into getting to know new communities, to spend nights dancing even with early starts due the next day. Colourful both in personality and turnout, we will always remember Michael in his shiny cape at Mozfest when we ran our first ever data expedition – our Data Diva. 8173097617_5ebd4a94b2_zPeople genuinely never forgot Michael – he was charismatic and commanded people’s attention. He managed to understand data and people, and he could inspire every single person he met, no matter how many were in the workshop. He was a true polymath, too – he went from medical doctor, to academic, to data trainer/coder, to a journalist – and all before the age of 35. To us, Michael was intelligent, always ready to help people, honest (sometimes painfully), funny and, as all the best people are, wonderfully awkward. Most of all, he was generous with his time, humble, and thoughtful. He managed to foster an environment where anyone could ask him a question, or for help on building something – and he would answer without any fuss, and with contagious enthusiasm. 8683527172_2ea6930fdf_o (1)As a key architect of many of School of Data’s workshop styles, particularly Data Clinics and Data Expeditions, his legacy lives on through the character sheets he made just 10 minutes before the first expedition started, and in many of the materials the community use today 8173129738_06a92976cb_m 8173096061_83bd95bac8_mWhen he moved on to derStandard.at, we were torn between happiness for him – that he was starting a new stage in his life – and sadness, that he was leaving our team. He was so excited about it though: finally, he would “stop talking about data journalism and start doing it.” As a leaving gift, we made him this video to show him how much we appreciated him. Watch it from YouTube. We “the Team of Open Knowledge Nepal” met him during his visit at Nepal for “Open Aid Data Bootcamp 2014 Nepal”. Bedside being an awesome Data Diva, he was a really good Human Being. May his soul rest in peace. Here are some photos from his Nepal visit:

1403014_663865340316186_7629432323719393036_o  1493536_663276910375029_6292061856107192354_o1961674_663280980374622_529895436118032986_o 10317588_663280590374661_8352466045646900454_o

In memory of Michael Bauer

Nikesh Balami - September 27, 2015 in Data Diva, Featured, Mchal, Memories, Open Knowledge, School of Data

Reblogged from School of Data Blog, licensed under Creative Commons Attribution-ShareAlike v3.0 License   “It was with great sadness that we learned last week that we had lost one of our greats. Michael Bauer passed away suddenly on 13th September 2015 while running the Wachau half marathon. In this post, the School of Data team (both past and present) remember what he gave to the project, and our favourite moments from working with him.” Michael joined School of Data as one of the first team members in 2012 and worked on the project up until October 2014. In this time, he trained and helped hundreds of activists from across the world and built an amazing community of likeminded people – a community which is now thriving, in large part due to the contributions and skills that Michael gave. His extraordinary intelligence and skills gave School of Data an “edge”; for him, anything done on the project had to be both educational and fun, else there was no point in doing it. He taught all of us personally a huge amount about what it means to be a ‘data trainer’. He was a great colleague, and an even better friend. The School of Data team is largely remote – we work from wherever we like and connect with each other online. This means we don’t see each other so often and most of our contact is done via emails, online meetings or, as usually was the case with Michael, Skype chats from airport lounges…
Playing ‘Where is Michael?’ was always a fun game.

Playing ‘Where is Michael?’ was always a fun game.

It also means that when we do meet in person, the time is precious. We travelled together across the world – and wow, did Michael travel. He was always up for spontaneous trips (sometimes with as little as twelve hours notice before intercontinental travel), for throwing himself into getting to know new communities, to spend nights dancing even with early starts due the next day. Colourful both in personality and turnout, we will always remember Michael in his shiny cape at Mozfest when we ran our first ever data expedition – our Data Diva. 8173097617_5ebd4a94b2_zPeople genuinely never forgot Michael – he was charismatic and commanded people’s attention. He managed to understand data and people, and he could inspire every single person he met, no matter how many were in the workshop. He was a true polymath, too – he went from medical doctor, to academic, to data trainer/coder, to a journalist – and all before the age of 35. To us, Michael was intelligent, always ready to help people, honest (sometimes painfully), funny and, as all the best people are, wonderfully awkward. Most of all, he was generous with his time, humble, and thoughtful. He managed to foster an environment where anyone could ask him a question, or for help on building something – and he would answer without any fuss, and with contagious enthusiasm. 8683527172_2ea6930fdf_o (1)As a key architect of many of School of Data’s workshop styles, particularly Data Clinics and Data Expeditions, his legacy lives on through the character sheets he made just 10 minutes before the first expedition started, and in many of the materials the community use today 8173129738_06a92976cb_m 8173096061_83bd95bac8_mWhen he moved on to derStandard.at, we were torn between happiness for him – that he was starting a new stage in his life – and sadness, that he was leaving our team. He was so excited about it though: finally, he would “stop talking about data journalism and start doing it.” As a leaving gift, we made him this video to show him how much we appreciated him. Watch it from YouTube. We “the Team of Open Knowledge Nepal” met him during his visit at Nepal for “Open Aid Data Bootcamp 2014 Nepal”. Bedside being an awesome Data Diva, he was a really good Human Being. May his soul rest in peace. Here are some photos from his Nepal visit:

1403014_663865340316186_7629432323719393036_o  1493536_663276910375029_6292061856107192354_o1961674_663280980374622_529895436118032986_o 10317588_663280590374661_8352466045646900454_o

French open data connection: drinks & chat with Cédric Lombion

Michaela Rybičková - July 2, 2015 in data visualisation, Featured, Meetup, okfn, Open Data, open data meetup, open knowledge France, otevřená data, School of Data, Události

Cédric Lombion from Open Knowledge France, is coming to Prague with and aim to do an international research about the state of open data. His plan is to meet public project managers and discuss the problems they face when creating open data policies.  And he’s very keen to meetup with Prague’s open data community – developers, datajournalists, students and data geeks of all sorts! Cedric also works as community manager at School of Data, in which he also participates as a trainer with focus on data visualisation. If you’re interested in exchanging experience with a French peer or just catch up with the latest turns of events with #opendatacz, join us! It’s vacation season, so it will be an informal gathering with no set agenda. Everyone can bring a topic or idea to the table. And test various kinds of beers from small local breweries 🙂 When: Wed 15th of July, 7pm
Where: Pivo a párek, Korunní 105 (map)
Please register so that we can reserve you a seat: http://bit.ly/1HzjMLp

French open data connection: drinks & chat with Cédric Lombion

Michaela Rybičková - July 2, 2015 in data visualisation, Featured, Meetup, okfn, Open Data, open data meetup, open knowledge France, otevřená data, School of Data, Události

Cédric Lombion from Open Knowledge France, is coming to Prague with and aim to do an international research about the state of open data. His plan is to meet public project managers and discuss the problems they face when creating open data policies.  And he’s very keen to meetup with Prague’s open data community – developers, datajournalists, students and data geeks of all sorts! Cedric also works as community manager at School of Data, in which he also participates as a trainer with focus on data visualisation. If you’re interested in exchanging experience with a French peer or just catch up with the latest turns of events with #opendatacz, join us! It’s vacation season, so it will be an informal gathering with no set agenda. Everyone can bring a topic or idea to the table. And test various kinds of beers from small local breweries :) When: Wed 15th of July, 7pm
Where: Pivo a párek, Korunní 105 (map)
Please register so that we can reserve you a seat: http://bit.ly/1HzjMLp

How Open Map Data is Helping Save Lives in Nepal

Nikesh Balami - June 17, 2015 in Kathmandu Living Labs, Open Data, Open Map, OpenStreet Map, QuakeMap, Quakerelief, School of Data, Summer Fellow

Reblogged form School Of Data Blog, Licensed under Creative Commons Attribution-ShareAlike v3.0 My name is Nirab Pudasaini, and I am a new School of Data fellow from Nepal. Just 5 days after the beginning of my fellowship, a devastating earthquake of magnitude 7.9 hit my country. It was on April 25th. As of May 30 the death toll of the quake had risen to 8691 while 22054 were injured. In one district called Rasuwa, as much of 1.73% of the total population was injured. Nepal was hit bad by the earthquake and there was an immediate need to respond. openmap_0 a map visualization showing the extent of the damage. In the aftermath of the quake, national and international volunteers quickly joined forces to rescue people under debris, provide food and shelter to those who lost their home and generally provide relief to the affected communities. And the mapping effort was essential to this life-saving effort. Mapping as a community effort Crisis mapping, which has been the job of a few specialists in big NGOs like the Red Cross, has dramatically changed in the past few years. With the advent of the open source collaborative mapping project OpenStreetMap (OSM), and more recently the Humanitarian OpenStreetMap Team (HOT), thousands of volunteers contribute to the mapping of countries affected by disasters, with an unprecedented speed. By April 25, 5052 mappers had made 121525 edits to OpenStreetMap. A part of this effort was shouldered by the non-profit tech organisation where I work, Kathmandu Living Labs. As part of this work, I spent the past two years building community around OpenStreetMap, with disaster resilience in mind. With no detailed map of Nepal available, building a map with locals was the most efficient way to get there. Not only we were able to map Kathmandu in great detail, but all the school and health facilities in Kathmandu Valley along with their structural data was made freely available to everyone in OSM. To make this work, we cannot expect to do all the work ourselves. So we train locals and empower communities so they can map their area themselves, using OSM. This way, we expanded our work to other cities than Kathmandu: Bharaptur, Hetaud, and villages like Bajrabarahi, Manahari and Padampur. The maps are used for many applications like agriculture, water health and sanitation and local governance. One of the major area is, of course, humanitarian use. Data collection, needs assessment and supporting relief workers Having centralised information proved to be a essential to help fill the information gaps during the earthquake crisis response. After the quake we have been focusing our efforts in four different tasks: 1) A platform where people can submit reports for earthquakes related needs: http://quakemap.org. 1800 reports have come into the system, which aggregates and display needs related to food, medicine, shelter, and sometimes evacuations. A team of volunteers verifies many of those needs, and signal them to appropriate responding organizations. Responding organizations can, and do subscribe to alerts for new reports that come into the system. openmap_1 2) The collaboration with the international OSM community and Humanitarian OpenStreetMap Team to engage remote mappers. Mapper are given instructions on what and where to map, using the OSM tasking manager. The collaboration extends to satellite imagery providers to make aerial imagery available for post disaster mapping. 3) There is a huge need of data collection after the quake for the need assessment and planning. Data collection, storage and management is much easier, faster and cheaper when a mobile based digital solutions are used. We have developed a system using KLL Collect (a mobile app for data collection) which uses Ona’s Server and Dashboard solution to provide a complete data collection and storage solution. This is being used by various organization for their data collection needs. openmap_2 4) http://quakerelief.info is a platform where we provide printable maps created with OSM data. The website provides instructions on using OSM data for Maps and Navigation without a mobile internet connection. The platform also contains useful digital maps like Deaths and Injuries from Earthquake for different districts, Earthquake Intensity by Population and more. In the coming days information and maps will be playing a vital role in recovery and reconstruction. There are lots of challenges that needs to be overcome in the coming days but with challenges comes opportunity. Having adequate data in an understandable form will be important to plan for all the recovery and reconstruction work that will be done in Nepal and to capitalize those opportunities. Openly accessible map data will be for Nepal a vital piece of that information. As a 2015 School of Data fellow i will keep on working on making Maps for Nepal.