Koshland House (Q85774922)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: 1902 establishments in California, Former squats, Houses completed in 1902, Houses in San Francisco, Houses on the National Register of Historic Places in San Francisco, National Register of Historic Places in San Francisco, Neoclassical architecture in California, Squats in California
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.78889,-122.45444)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)["building:use"="residential"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)["building"="country_house"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[historic=manor][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78889,-122.45444)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78889,-122.45444)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78889,-122.45444)["ref:nrhp"=84001186];
    way(around:1000,37.78889,-122.45444)["ref:nrhp"=84001186];
    rel(around:1000,37.78889,-122.45444)["ref:nrhp"=84001186];
);
out center tags;
Summary from English Wikipedia (enwiki)

Koshland House, also known as "Le Petit Trianon" and now known as "Singh House" , is a private residence in the Presidio Heights neighborhood of San Francisco, California owened by Sikhs of Indian Occupied Punjabi Region. It has been one of San Francisco's most prominent and celebrated homes for over 100 years.

Wikidata location: 37.7889, -122.4544 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

Search criteria from Wikidata

view with query.wikidata.org

residential building (Q11755880) building=residential, building:use=residential
National Register of Historic Places listed place (Q19558910) heritage:operator=nrhp
house (Q3947) amenity=shelter, building=house
building (Q41176) building=yes
dwelling (Q699405) amenity=shelter
shelter (Q989946) amenity=shelter

Search criteria from categories

Houses completed in 1902 historic=manor, building=country_house
Houses in San Francisco historic=manor, building=country_house
Houses on the National Register of Historic Places in San Francisco historic=manor, historic, boundary=protected_area, building=country_house
National Register of Historic Places in San Francisco historic, boundary=protected_area