Spreckels Mansion (Q100451768)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1912 establishments in California, Houses in San Francisco, Mansions, San Francisco Designated Landmarks
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.79273,-122.42751)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.79273,-122.42751)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.79273,-122.42751)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.79273,-122.42751)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

Spreckels Mansion is a French Classical mansion located in the Pacific Heights neighborhood at 2080 Washington Street in San Francisco, California, built c. 1912-1913. The three-story mansion is in a French Baroque Chateau-style, designed by George Adrian Applegarth (1876–1972) and Kenneth A. MacDonald Jr. (of MacDonald & Applegarth firm), and built by businessman Adolph B. Spreckels. It is listed as city landmark No. 197.

Wikidata location: 37.7927, -122.4275 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: Spreckels Mansion (OSM)exact location match [show tags]
ele: 104
name: Spreckels Mansion
height: 15
source: USGS Geonames
tourism: yes
building: yes
wikidata: Q100451768
addr:state: CA
gnis:reviewed: no
building:levels: 3
gnis:feature_id: 1655557
gnis:county_name: San Francisco
gnis:import_uuid: 57871b70-0100-4405-bb30-88b2e001a944

wikidata match: Q100451768

Search criteria from Wikidata

view with query.wikidata.org

residential building (Q11755880) building=residential, building:use=residential
house (Q3947) amenity=shelter, building=house
building (Q41176) building=yes
dwelling (Q699405) amenity=shelter
shelter (Q989946) amenity=shelter

Search criteria from categories

Houses in San Francisco historic=manor, building=country_house