Summary of node count of potentially mis-tagged objects in each Philippine region

otq_query_osmph_papercuts_11.txt

/*
OSMph Papercuts issue #11 - https://git.io/vFCea
*/
[out:csv(name, total )];

//All PH regions
area["ISO3166-2"~"^PH.*"][admin_level=3];

// Count the occurunces in each area
foreach->.region(
  // Collect tagged objects in the area
  ( node(area.region)[tourism=artwork];
    node(area.region)[tourism=attraction];
    node(area.region)[tourism=guest_house];
    node(area.region)[tourism=viewpoint];
    node(area.region)[historic=castle]);
  
  make count "Pilipinas" = region.set(t[ "Pilipinas"]),
             name = region.set(t["name"]),
             total = count(nodes);
  out;
);