33 Tehama Street (Q28222856)

  • matcher place: San Francisco (relation 111968)
  • view on Wikidata
  • Wikipedia: English
  • Wikimedia Commons
  • English Wikipedia categories: Apartment buildings in California, Arquitectonica buildings, Residential buildings completed in 2018, Residential skyscrapers in San Francisco, South of Market, San Francisco
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,37.78730,-122.39620)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)["building:levels"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[height][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[height][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[height][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[building=apartments][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[building=apartments][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[building=apartments][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[building=house][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)["building"="mixed_use"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)["building"="mixed_use"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)["building"="mixed_use"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[building=residential][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[building=yes][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,37.78730,-122.39620)[landuse=residential][name];
    way(around:1000,37.78730,-122.39620)[landuse=residential][name];
    rel(around:1000,37.78730,-122.39620)[landuse=residential][name];
    node(around:1000,37.78730,-122.39620)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,37.78730,-122.39620)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,37.78730,-122.39620)[tourism=artwork][~"^(addr:housenumber|.*name.*)$"~".",i];
);
out center tags;
Summary from English Wikipedia (enwiki)

33 Tehama is a luxury residential apartment complex in the South of Market neighborhood in San Francisco, California. The building is 380 feet (120 m) tall, 35 stories, and contains 403 residential units.

Wikidata location: 37.7873, -122.3962 view on OSM or edit on OSM

matches

login to upload wikidata tags

found a single match candidate

way: 33 Tehama (OSM)exact location match [show tags]
name: 33 Tehama
website: https://www.33tehama.com/
building: residential
wikidata: Q28222856
addr:street: Tehama Street
building:levels: 34
addr:housenumber: 33;41

wikidata match: Q28222856

Search criteria from Wikidata

view with query.wikidata.org

building (Q41176) building=yes

Search criteria from categories

Apartment buildings in California building=residential, building=house, building=apartments, landuse=residential, building=mixed_use
Residential buildings completed in 2018 landuse=residential, building=apartments, building=residential, building=house
Residential skyscrapers in San Francisco height, building:levels