Jakarta2015

Open Data for Nonprofits
Open Data Lab Jakarta and Humanitarian OpenStreetMap Team ID are organizing a joint training on open data using the OpenStreetMap data and Indonesia portal data. The training will introduce two powerful tools for data mining and cleaning, specifically Overpass-Turbo and OpenRefine.

Overpass-Turbo is a web based data mining tool for OpenStreetMap data. It runs on the Overpass API query and shows the results on an interactive map. Several training modules including:


 * OSM data type and tags
 * Overview of Overpass Turbo: What is Overpass Turbo, when should we use it dan alternative methods to download OSM data.
 * Overpass query Wizard
 * Exporting the data, map or query
 * Way forward

OpenRefine (formerly Google Refine) is a powerful tool for working with messy data and improving the data quality. Several training modules including:


 * Creating a new project,
 * Manipulating columns,
 * Sorting data,
 * Using data facets,
 * Detecting duplicates,
 * Using data transformations,
 * Using data clustering,
 * Splitting data,
 * Transposing data.

Bring your team or just yourself plus your laptop! We will provide snacks, drinks and lots of fun!

Date: Saturday, February 21, 2015

Time: 13.00 - 16.00 WIB

Location: [http://www.openstreetmap.org/?mlat=-6.202352195978165&mlon=106.82659953832626#map=17/-6.20380/106.82394 Jl. Pati No. 1, Menteng, Jakarta 10310]

Resources:


 * OpenRefine - http://openrefine.org/­
 * GREL Specification - https://github.com/OpenRefine/OpenRefine/wiki/Google-refine-expression-language
 * OpenRefine User Manual (in Bahasa) - http://opendatalabjakarta.github.io/trainings/cleaning/
 * Overpass-Turbo - http://overpass-turbo.eu/­
 * OSM Map Features - http://wiki.openstreetmap.org/wiki/Map_features
 * OSM Map Export - http://export.hotosm.org/­