---
description: Maning`s OSMaPaaralan log
---

# OSMaPaaralan Logs

Mapping logs for the OSMaPaaralan project.

[toc]

:::spoiler Click for details about the project

{%hackmd T31162aWSOqhxUMmO-G-ZQ %}

:::

## Big numbers

* **98.3% (0%)** - percentage of Fixed items in [MapRoulette challenge](https://maproulette.org/browse/challenges/9413).
* **80/81 (0%)** - provinces with > 90% Fixed items in MapRoulette.
* **47,407 (+0.7%)** - [total (public and private) schools mapped ](http://overpass-turbo.eu/s/Xqy).
* **40,688(+1%)** - [total schools with `ref`](http://overpass-turbo.eu/s/Xqz).

*as of 2021-11-30, updated monthly*

## Details by province

<details>

{%hackmd cecVBNIFQECbapZWoDRMIg %}

</details>

## Data via Overpass

:::spoiler Queries

Total schools with `ref` and output as centroid

[out:json][timeout:100];
{{geocodeArea:Philippines}}->.searchArea;
// gather results
(
  // query part for: “amenity=school and ref=*”
  nwr["amenity"="school"]["ref"](area.searchArea);
);
// print results
out center meta;

Total schools

[out:xml][timeout:1000];
// fetch area “Philippines” to search in
{{geocodeArea:Philippines}}->.searchArea;
// gather results
(
  // query part for: “amenity=school”
  nwr["amenity"="school"](area.searchArea);

);
// print results
out meta;
>;
out meta qt;

:::

---

:::spoiler **Other QA tasks**

- Replace school node to polygon.
- Retag `building=*` to `building=school` if within school grounds.
> except for "gyms" (`building=roof`+`layer=1`+`leisure=sports_hall`, which are visually identifiable
- Add `place=village` nodes to location where it doesn't exist.
> sometimes, the school data will have sitio, or subdivision information. Add these as `place=neighbourhood` when possible
- Add MapwithAI detected roads around the school.
- Fix JOSM validator errors.
- Ensure that "integrated school" data are correctly mapped.
> These schools share the same name, and some facilities, but has separate `ref` elements for elementary, and high school divisions and aren't always obvious from imagery.
> Sometimes one school will have "integrated school" in their name while the other school will just use "x elementary school", or the other way around.
:::

**Previous big numbers**

Date | % Fixed in MR challenge | Provinces with > 90% Fixed in MR| Total (public and private) schools mapped | total schools with `ref`| Image highlight
---|---|---|---|---|---
**2020-04-30** | 30% | 3/81 | 25,117 |12,431 |
**2020-05-31** | 33% (+10%) | 5/81 (+66%) | 26,176(+4%) | 13,791(+11%) |
**2020-06-30** | 39% (+18%) | 15/81 (+200%) | 27,944 (+7%) | 16,250 (+18%) | <br> *Walking times in minutes (10, 15, 30, 60) for a location to a school in Guimaras ([demo](https://bl.ocks.org/maning/raw/7390ae88b18a496c48868e82d9fc7264/)).*
**2020-07-30** | 42% (+7%) | 19/81 (+26%) | 29,072 (+4%) |17,658 (+9%) | <br>*Tawi-tawi schools and communities within storm surge hazard zones.*
**2020-08-31** | 46% (+9%) | 21/81 (+9%) | 30,396 (+5%) | 19,296 (+9%) | <img width="400" alt="Screen Shot 2020-08-13 at 15 06 15" src="https://user-images.githubusercontent.com/353700/91682209-666ec500-eb83-11ea-8796-091137fd4101.png"><br>*Pangasinan schools from Overpass query*
**2020-09-30** | 52% (+13%) | 23/81 (+9%) | 32,109 (+6%) | 21,491 (+11%)| <img width="400" alt="" src="https://user-images.githubusercontent.com/353700/94638706-2844fc80-030d-11eb-9803-1df9a75f2bed.png"><br>*HOTOSM Philippines adding DRR related tags in public schools.*
**2020-10-30** | 54% (+4%) | 26/81 (+13%) | 33,070 (+3%) |22,582 (+5%)| <img width="400" alt="" src="https://user-images.githubusercontent.com/353700/97969328-da834e80-1dfa-11eb-9757-f3c2df018d9d.gif"><br>*Schools added every month (2019-09 to 2020-10).*
**2020-11-30** | 57% (+5%) | 27/81 (+4%) | 33,908 (+2%) |23,541 (+4%)| <img width="400" alt="pnm20" src="https://user-images.githubusercontent.com/353700/100689608-bdbd4500-33bf-11eb-9070-5f53b271bacc.png"><br>*OSMaPaaralan project updates presented at Pista ng Mapa 2020 ([youtube](https://youtu.be/vJEOzRey5JE))*
**2020-12-31** | 60% (+5%) | 30/81 (+11%) | 35,072 (+3%) |24,896 (+5%)| <img width="400" alt="" src="https://raw.githubusercontent.com/feyeandal/photos/master/yearend_8.gif"><br>*HOTOSM-PH ground validated schools in Pampanga ([report](https://feyeandal.github.io/hotphmappingteam/))*
**2021-02-28** | 67% (+12%) | 35/81 (+17%) | 37,513 (+7%) |27,830 (+12%)|
**2021-03-31** | 71% (+6%) | 38/81 (+8%) | 38,715 (+3%) | 29,097 (+4%)| <img width="400" alt="" src="">
**2020-04-30** | 74% (+4%) | 43/81 (+13%) | 39,709 (+2%) | 30,300 (+4%) |
**2021-05-31** | 78% (+5%) | 50/81 (+16%) | 41,146 (+3%) | 32,036 (+5%)|
**2021-06-30** | 82% (+5%) | 59/81 (+18%) | 42,694 (+4%) |33,934 (+6%)|
**2021-07-31** | 86% (+5%) | 61/81 (+3%) | 43,876 (+3%) | 35,661 (+5%)|
**2021-08-31** | 92% (+7%) | 70/81 (+14%) | 45,312 (+3%) | 37,764 (+6%)|
**2021-09-30** | 97.5% (+6%) | 78/81 (+11%) | 46,643 (+3%) | 39,521 (+4%)|
**2021-10-31** | 98.3% (+1%) | 80/81 (+2%) | 47,059 (+1%) | 40,132 (+1%)|
**2021-11-30** | 98.3% (0%) | 80/81 (0%) | 47,407 (+0.7%) | 40,688(+1%)|
**2021-12-31** | -- | -- | 47,896 (+1%) | 41,344 (+1.6%)|
**YYYY-MM-DD** | xx% (+x%) | xx/81 (+xx%) | xx (+x%) | xx(+x%)|
<img width="400" alt="" src=""><br>*blurb*

---