Albion Brewery (Q110919812)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1870s architecture in the United States, 1875 establishments in California, American companies disestablished in 1919, American companies established in 1875, Bayview–Hunters Point, San Francisco, Beer brewing companies based in the San Francisco Bay Area, Defunct brewery companies of the United States, History of San Francisco, Houses in San Francisco, Reportedly haunted locations in San Francisco, San Francisco Designated Landmarks
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.73157,-122.37553)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[amenity=pub][name];
    way(around:1000,37.73157,-122.37553)[amenity=pub][name];
    rel(around:1000,37.73157,-122.37553)[amenity=pub][name];
    node(around:1000,37.73157,-122.37553)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[craft=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[industrial=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[industrial=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[industrial=brewery][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[industrial=factory][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.73157,-122.37553)["man_made"="works"][name];
    way(around:1000,37.73157,-122.37553)["man_made"="works"][name];
    rel(around:1000,37.73157,-122.37553)["man_made"="works"][name];
    node(around:1000,37.73157,-122.37553)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.73157,-122.37553)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.73157,-122.37553)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

The Albion Brewery, also known as Albion Ale And Porter Brewing Company and the Albion Castle, is a defunct brewery in San Francisco, California in operation from 1875 until approximately 1919. The site of the former brewery is also the location of the Hunters Point Springs, at 881 Innes Avenue. This building and site is a San Francisco Designated Landmark, listed on April 5, 1974. The building is now privately owned and has hosted events.

Wikidata location: 37.7316, -122.3755 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Albion Castle (OSM), 1 feet from Wikidata [show tags]
name: Albion Castle
height: 7
amenity: events_venue
website: https://www.thealbioncastle.com
building: yes
wikidata: Q110919812
addr:street: Innes Avenue
addr:housenumber: 881

wikidata match: Q110919812

Search criteria from Wikidata

view with query.wikidata.org

brewery (Q131734) craft=brewery
industrial building (Q1662011) building=industrial
production structure (Q2111778) building=industrial
building (Q41176) building=yes
factory (Q83405) man_made=works, industrial=factory

Search criteria from categories

Beer brewing companies based in the San Francisco Bay Area industrial=brewery, amenity=pub, craft=brewery
Houses in San Francisco historic=manor, building=country_house