Skip to content

Instantly share code, notes, and snippets.

View govvin's full-sized avatar

거윈 | Win govvin

View GitHub Profile
@govvin
govvin / osmph_offerings.md
Last active November 1, 2015 02:14
OpenStreetMap PH Public Offerings

OSM-PH topic outline for lightning talks, quickies, workshop, and conferences.

Introduction

Overview

OpenStreetMap (www.openstreetmap.org) is a worldwide project which aims to create and share geospatial information to anyone who wants them. The project was started because most maps you think of as free actually have legal or technical restrictions on their use, holding back people from using them in creative, productive or unexpected ways.

More and more people are contributing and using the data in various ways. Local government units and other government agencies are encouraged to use and update the data so that the public may benefit from the shared information particularly for disaster risk reduction.

@govvin
govvin / mapathon_cheat_sheet.md
Last active November 11, 2015 10:23
Mapathon cheat sheet

OpenStreetMap (OSM) Mapathon

A sample activity outline for quickie workshops and mapathons

Schedule

Duration Topic Activity c/o Notes
00:30 Registration & Setup
00:15 Welcome Remarks Presentation Host
@govvin
govvin / overpass.geojson
Created December 24, 2015 06:29 — forked from anonymous/overpass.geojson
data exported by overpass turbo
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@govvin
govvin / taf_3rd_crid_edits.geojson
Created January 20, 2016 06:23
OpenStreetMap edits during the 3rd CR+ID Industry Mapping Workshop, Y Hotel, Butuan City, Caraga, PH
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@govvin
govvin / mapathon_20160123_usembassy.geojson
Last active January 25, 2016 02:35 — forked from anonymous/overpass.geojson
#manilaMapathon edits held at the American Embassy, 2016-01-23. Organized by mapPHL, with OSMph. Source: http://overpass-turbo.eu/s/dXs
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@govvin
govvin / manilaMapathon_edits.tsv
Created January 26, 2016 09:36
U.S. Embassy Mapathon stats, 2016-023
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 32 columns, instead of 1. in line 7.
ekip osmuser_uid osmuser_name changeset objects objects_c objects_m objects_d node_c way_c relation_c node_m way_m relation_m node_d way_d relation_d poi_total_nodes node_amenity node_shop node_office node_power node_place node_man_made node_history node_tourism node_leisure way_highway way_waterway way_building way_landuse way_man_made
0 900923 curran74 0 4053 3899 87 67 3216 683 0 82 5 0 60 7 0 0 0 0 0 0 0 0 0 0 0 11 4 663 1 0
0 3089153 Sea Tea Zen 0 3656 3551 89 16 3132 419 0 67 22 0 15 1 0 0 0 0 0 0 0 0 0 0 0 0 23 383 12 0
0 3556440 sch93 0 2006 1874 120 12 1550 324 0 108 12 0 9 3 0 0 0 0 0 0 0 0 0 0 0 3 12 307 0 0
0 3556185 osmcr 0 1853 1846 7 0 1586 259 1 4 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 7 225 15 0
0 3556439 Fdk Ville 0 1592 1433 99 60 1152 281 0 4 95 0 48 12 0 0 0 0 0 0 0 0 0 0 0 0 0 141 0 0
0 3556479 Jofel Bayron 0 1884 1354 490 40 1284 70 0 428 62 0 40 0 0 0 0 0 0 0 0 0 0 0 0 6 14 24 18 0
0
@govvin
govvin / OTQ_event_edits_bbox_by_uid.md
Last active April 27, 2017 11:14
Overpass Turbo Query for edits made during mapathons, and similar mapping events.

Overpass Turbo Query to return all edits made by users enumerated by UID, within a {{bbox}}.

Use http://whosthat.osmz.ru to determine OSM uid of users. UID is used, instead of usernames, to work around the possibility of users changing their names later on.

// set variables
{{dates="2017-04-26T00:00:00Z", "2017-04-27T23:59:59Z"}}
{{party=uid: 3529916, 3529870, 3091096, 3529864, 2734688, 1041828, 3529877, 3529856, 3529972, 3529907, 3529855}}
//{{party=user:}}
@govvin
govvin / OTQ_event_edits_geocodearea.md
Created February 24, 2016 11:41
Query edits made in a geocoded region, by enumerated uids, within a date range. Perfect for events like mapathons and training workshops.

#Overpass Turbo Query

/* Overpass Turbo Query for edits made during mapathons, and similar mapping events. */

// set variables
{{dates="2016-02-22T00:00:00Z", "2016-02-25T23:59:59Z"}}
{{party=1041828}}
@govvin
govvin / gtq_all_buildings.md
Last active March 1, 2016 14:12
Overpass Turbo Query all buildings within a given area

#Overpass Turbo Query Query all buildings within a named area. A polygon is required.

[out:xml];
{{AOI="San Juan"}}


(
 area["name"={{AOI}}];
@govvin
govvin / otq_buildings_by_province.md
Created March 3, 2016 04:41
Count all buildings within a province

#Overpass Turbo Query Count all buildings within a province.

See: http://overpass-turbo.eu/s/eKL

/*count buildings by province*/

[out:csv(::"type",::"id", name, admin_level,::"count")];