Panimoravintola Koulu (Q7131168)

  • matcher place: Turku (relation 399906)
  • view on Wikidata
  • Wikipedia: English, Finnish
  • English Wikipedia categories: Beer in Finland, Buildings and structures in Turku, Pubs in Turku, Restaurants established in 1998, Restaurants in Finland, School buildings completed in 1889, Tourist attractions in Turku
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,60.44972,22.26472)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[cuisine][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[shop][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[amenity=bar][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[amenity=cafe][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)["amenity"="fast_food"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[amenity=nightclub][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[amenity=pub][name];
    way(around:1000,60.44972,22.26472)[amenity=pub][name];
    rel(around:1000,60.44972,22.26472)[amenity=pub][name];
    node(around:1000,60.44972,22.26472)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[amenity=restaurant][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)["man_made"="works"][name];
    way(around:1000,60.44972,22.26472)["man_made"="works"][name];
    rel(around:1000,60.44972,22.26472)["man_made"="works"][name];
    node(around:1000,60.44972,22.26472)[microbrewery=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[microbrewery=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[microbrewery=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[tourism=attraction][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,60.44972,22.26472)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,60.44972,22.26472)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,60.44972,22.26472)[tourism=museum][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from Suomi / Finnish Wikipedia (fiwiki)

Panimoravintola Koulu on Turussa toimiva panimoravintola. Ravintola avattiin 18. tammikuuta 1998, ja se toimii vuonna 1889 valmistuneessa entisessä koulurakennuksessa Eerikinkadun ja Kristiinankadun kulmatontilla. Rakennuksen ovat suunnitelleet arkkitehdit Ludvig Isak Lindqvist ja Bruno Granholm. Uusrenessanssityylisessä koulutalossa toimi pääasiassa ruotsinkielisiä tyttökouluja. Vuodesta 1966 koulun nimi oli Cygnaeus skola. Panimoravintola Koulu on toiminut kouluna vuosien 1889 ja 1997 välisenä aikana.

Summary from English Wikipedia (enwiki)

Panimoravintola Koulu is a Finnish brewery restaurant in the city of Turku. Koulu (Finnish for "school") is the largest brewery restaurant in Finland and it is situated in a former Neo-Renaissance style school building from 1889 by architects L. I. Lindqvist and Bruno Granholm. The school to first occupy the building was "Svenska Fruntimmerskolan i Åbo", which was later renamed as the "Svenska flickskolan i Åbo" in 1916, again in 1955 when it became "Åbo svenska flicklyseum", until finally in 1966 the name was changed to "Cygnaeus skola". On 4 February 1940, during the Winter War, the school was hit by a Soviet incendiary bomb, which set fire to the roof and destroyed the assembly hall (now known as the Bellman assembly hall). One of the high points in the history of Koulu was the visit of Commander-in-Chief, Baron Carl Gustaf Emil Mannerheim on 14 February 1941. The school was shut down in 1970. The restaurant was opened in 1998.

Wikidata location: 60.4497, 22.2647 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

node: Panimoravintola Koulu (OSM), 31 m from Wikidata [show tags]
url: http://www.panimoravintolakoulu.fi
name: Panimoravintola Koulu
craft: brewery
email: mypa@panimoravintolakoulu.fi
phone: +358 2 2745757
amenity: restaurant
website: https://www.panimoravintolakoulu.fi/
wikidata: Q7131168
addr:city: Turku
check_date: 2023-01-05
diet:halal: no
wheelchair: yes
addr:street: Eerikinkatu
diet:kosher: no
addr:country: FI
microbrewery: yes
payment:cash: yes
opening_hours: Mo-Th 11:00-24:00; Fr-Sa 11:00-02:00; Su 12:00-24:00
indoor_seating: yes
outdoor_seating: yes
addr:housenumber: 18
payment:debit_cards: yes
payment:credit_cards: yes
opening_hours:covid19: off

wikidata match: Q7131168

Search criteria from Wikidata

view with query.wikidata.org

brewery (Q131734) craft=brewery, brewery
industrial building (Q1662011) building=industrial
bar (Q187456) amenity=bar, bar
production structure (Q2111778) building=industrial
pub (Q212198) amenity=pub
shop (Q213441) shop=yes, shop
brewpub (Q3640372) microbrewery=yes
building (Q41176) building, building=yes
microbrewery (Q5487333) microbrewery=yes
commercial building (Q655686) building=commercial
factory (Q83405) man_made=works, industrial=factory

Search criteria from categories

Pubs in Turku amenity=pub, building=pub, amenity=nightclub, amenity=restaurant, amenity=bar
Restaurants established in 1998 shop=bakery, shop=deli, amenity=cafe, amenity=restaurant, cuisine, amenity=fast_food
Restaurants in Finland shop=bakery, shop=deli, amenity=cafe, amenity=restaurant, cuisine, amenity=fast_food
Tourist attractions in Turku tourism=attraction, tourism=museum