[Tagging] creameries

[Frederik Ramm]

Hi,

On 21.09.21 15:04, Andy Townsend wrote:
> gis=> SELECT distinct building FROM planet_osm_polygon WHERE (amenity =
> 'place_of_worship') AND (building != 'yes') AND (building != 'church')
> AND (building != 'mosque') AND (building != 'cathedral') AND (building
> != 'chapel') AND (building != 'convent') AND (building != 'monastery')
> AND (building != 'temple');

and vice versa, there are many things in a building that used to be a
church... (this is also for a rough UK/Ireland box)

select count(*) as number,coalesce(amenity,tourism) as use
from planet_osm_polygon where
(amenity is not null or tourism is not null)
and building in ('church','chapel','cathedral')
group by coalesce(amenity,tourism) order by number desc;

 number |              use
--------+------------------------------------
  18918 | place_of_worship
     33 | community_centre
     13 | attraction
     12 | arts_centre
     10 | social_facility
      8 | theatre
      6 | events_venue
      6 | kindergarten
      5 | library
      5 | museum
      4 | pub
      4 | school
      3 | childcare
      3 | chalet
      3 | restaurant
      2 | community_hall
      2 | nightclub
...

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"