{"id": "n-fd7b7e0572", "slug": "san-bruno-shops-at-tanforan", "type": "mall", "name": "Shops at Tanforan", "aka": [], "city": "San Bruno", "county": "San Mateo County", "state": "CA", "country": "US", "census_division": 9, "lat": 37.636, "lon": -122.418, "geocode_method": "wikipedia", "address": null, "metro": null, "original_use": "horse racing track", "year_opened": null, "year_closed": null, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": "The Hapsmith Company", "original_architect": null, "before_notes": "Draft from Wikipedia, model-extracted, unreviewed: The Shops at Tanforan, a regional shopping mall opened in 1971 on a former horse racing track site, is proposed to be demolished and replaced with a biotech campus by Alexandria Real Estate.", "strategy": ["redevelop"], "new_use": ["office"], "share_retrofit": null, "status": "proposed", "year_retrofit": null, "developer": "Alexandria Real Estate", "architect": null, "after_notes": "biotech campus", "narrative": "The Shops at Tanforan is a regional shopping mall in San Bruno, California, United States. It is located on the San Francisco Peninsula, 10 miles (16 km) south of San Francisco city limits.\nThe site was originally used as a horse racing track from 1899 until 1964, when the grandstand was destroyed by fire. During World War II the track was used as the Tanforan Assembly Center where Japanese American citizens, primarily from the San Francisco Bay Area, were interned until more permanent War Relocation Centers were opened. A shopping mall was built on the site and opened in 1971. The mall underwent a 3-year renovation, and reopened in 2005.", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/The_Shops_at_Tanforan", "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": "Q7763958", "wikipedia": "https://en.wikipedia.org/wiki/The_Shops_at_Tanforan", "osm_id": null, "verified": "draft", "verified_by": null, "last_verified": null, "last_updated": "2026-10-18", "created": "2026-10-18", "contributor_name": null, "contributor_org": null, "contributor_link": null, "international": 0, "county_fips": "06081", "opp_score": 0.0, "opp_reasons": ["already in play: under construction, approved, or sold to a developer with housing plans", "county shrank -2.7% 2018–23", "median rent $2,893"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/malls/ca/san-bruno-shops-at-tanforan/", "events": [], "sources": [{"id": 9133, "site_id": "n-fd7b7e0572", "url": "https://en.wikipedia.org/wiki/The_Shops_at_Tanforan", "title": "The Shops at Tanforan", "publisher": "Wikipedia", "date": null, "quote": "The Shops at Tanforan", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}], "deals": [], "parties": [{"name": "Alexandria Real Estate", "kind": "developer", "role": "developer", "year_from": null, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "Shops at Tanforan (San Bruno, CA) is a proposed redevelopment of a former mall site. The original site was a horse racing track (1899–1964), later used as a WWII internment center. The current mall opened in 1971 and was renovated in 2005. The project is proposed as an office/biotech campus by Alexandria Real Estate. It is listed as 'proposed' with no construction status noted. ", "why": "The opportunity is flagged as 'already in play' (under construction, approved, or sold to a developer with housing plans). County population declined -2.7% (2018–2023). Median rent is $2,893. The site is 1.3km from YouTube HQ (built) and 8.9km from Westlake Mall (approved).", "where_it_stands": "No active retail tenants listed in EDGAR filings. Retail establishments declined 11.3% (2012–2023) in the county. Traffic data shows high volume (160k ADT) on Interstate 380 nearby.", "for_a_planner": ["County population decline noted", "Retail establishment count down 11.3% since 2012", "Median rent $2,893 (2026 data)"], "for_a_developer": ["Project status: proposed (no construction confirmed)", "Adjacent to YouTube HQ (1.3km)", "County population decline (-2.7%) and high median rent ($2,893) are noted constraints"], "risks_and_unknowns": ["No current construction status", "Biotech campus use is 'after_notes' (not confirmed)", "No details on zoning approvals or timeline"], "data_quality": "partial", "one_line": "Proposed office/biotech campus on former mall site; flagged as 'already in play' with county population decline and high median rent.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "dc3fdd1b308f"}, "cluster": {"within_10km": [{"id": "n-58089ed8a1", "name": "YouTube Headquarters", "city": "San Bruno", "status": "built", "km": 1.3}, {"id": "n-6bad73edb5", "name": "Jagalchi", "city": "Daly City", "status": "built", "km": 7.7}, {"id": "n-d1b23217a6", "name": "Westlake Shopping Center", "city": "Daly City", "status": "approved", "km": 8.9}], "count_10km": 3, "count_25km": 17}, "edgar": {"query": "Shops at Tanforan", "city": "San Bruno", "total": 89, "name_only_total": null, "common_name": false, "sampled": 89, "latest": "2026-10-07", "earliest": "2003-09-15", "cmbs": [], "public": [{"name": "Seritage Growth Properties  (SRG, SRG-PA)", "cik": "0001628063", "n": 5, "first": "2016-03-11", "last": "2020-03-02", "forms": {"10-K": 5}, "cmbs": false, "kind": "owner", "sic": "6500", "acc": "0001564590-20-008210", "doc": "srg-10k_20191231.htm", "adjacent": true}, {"name": "Copper Property CTL Pass Through Trust  (CPPTL)", "cik": "0001837671", "n": 67, "first": "2021-03-05", "last": "2026-10-07", "forms": {"8-K": 67}, "cmbs": false, "kind": "owner", "sic": "6500", "acc": "0001837671-26-000080", "doc": "cptexhibit991sep26.htm", "adjacent": false}, {"name": "BEHRINGER HARVARD MULTIFAMILY REIT I INC", "cik": "0001384710", "n": 1, "first": "2010-08-05", "last": "2010-08-05", "forms": {"8-K": 1}, "cmbs": false, "kind": "owner", "sic": "6798", "acc": "0001104659-10-042117", "doc": "a10-15340_1ex99d1.htm", "adjacent": false}], "other": [{"name": "GUESS INC  (GES)", "cik": "0000912463", "n": 1, "first": "2010-06-10", "last": "2010-06-10", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "2340", "acc": "0001104659-10-033198", "doc": "a10-10417_1ex10d7.htm", "adjacent": true}, {"name": "FREDERICK'S OF HOLLYWOOD GROUP INC /NY/", "cik": "0000093631", "n": 5, "first": "2010-03-09", "last": "2012-06-06", "forms": {"8-K": 3, "10-Q": 2}, "cmbs": false, "kind": "other", "sic": "2340", "acc": "0001144204-12-033414", "doc": "v315128_ex10-1.htm", "adjacent": false}, {"name": "ABERCROMBIE & FITCH CO /DE/  (ANF)", "cik": "0001018840", "n": 2, "first": "2017-12-04", "last": "2021-06-09", "forms": {"10-Q": 2}, "cmbs": false, "kind": "other", "sic": "5651", "acc": "0001018840-21-000041", "doc": "exhibit103-amendedandresta.htm", "adjacent": false}, {"name": "JONES APPAREL GROUP INC", "cik": "0000874016", "n": 2, "first": "2010-07-30", "last": "2011-04-28", "forms": {"8-K": 2}, "cmbs": false, "kind": "other", "sic": "2330", "acc": "0000950123-11-040836", "doc": "y90974exv10w1.htm", "adjacent": false}, {"name": "BJs RESTAURANTS INC  (BJRI)", "cik": "0001013488", "n": 1, "first": "2005-10-27", "last": "2005-10-27", "forms": {"8-K": 1}, "cmbs": false, "kind": "other", "sic": "5812", "acc": "0001193125-05-210016", "doc": "dex991.htm", "adjacent": false}, {"name": "COLLECTIVE BRANDS, INC.", "cik": "0001060232", "n": 1, "first": "2010-09-02", "last": "2010-09-02", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "5661", "acc": "0000950123-10-083320", "doc": "c58976exv10w2.htm", "adjacent": false}, {"name": "New York & Company, Inc.", "cik": "0001211351", "n": 1, "first": "2011-09-08", "last": "2011-09-08", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "5621", "acc": "0001047469-11-007889", "doc": "a2205351zex-10_1.htm", "adjacent": false}, {"name": "COLE NATIONAL GROUP INC", "cik": "0000909492", "n": 1, "first": "2003-09-15", "last": "2003-09-15", "forms": {"10-Q": 1}, "cmbs": false, "kind": "other", "sic": "5945", "acc": "0000950152-03-008275", "doc": "l03023aexv10w1.txt", "adjacent": false}], "forms": {"8-K": 75, "10-Q": 9, "10-K": 5}, "url": "https://efts.sec.gov/LATEST/search/#/q=%22Shops%20at%20Tanforan%22%20%22San%20Bruno%22&forms=10-K,10-D,8-K,10-Q,ABS-EE&dateRange=custom&startdt=2001-01-01", "retrieved": "2026-10-20", "v": 4, "adj": ["0000912463", "0001628063"], "adj_total": 6, "first_in_sample": null, "securitised": null, "vintage": null, "vintage_strong": false, "source": "SEC EDGAR full-text search"}, "elevation": {"elevation_ft": 59.6, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "06081604102", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 4.59376071306136, "median_family_income": 96429.0, "snap_households": 43.0, "pop2010": 2321.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 1579058, "month": "2026-09", "change_1y": 0.044, "change_5y": 0.076}, "zori": {"latest": 3993, "month": "2026-09", "change_1y": 0.112, "change_5y": 0.277}, "county_fips": "06081", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "06081604102", "jobs": 8401, "retail_jobs": 1300, "food_accommodation_jobs": 589, "year": 2022, "source": "Census LEHD LODES8 WAC 2022 (all jobs, primary and secondary), blocks summed to the 2020 tract", "retrieved": "2026-10-20"}, "listings": {"zip": "94066", "month": "202609", "median_listing_price": 1394750, "median_listing_price_yy": 0.6242, "active_listing_count": 33, "median_days_on_market": 26, "price_reduced_share": 0.0425, "pending_ratio": 0.6, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "06081604102", "kfr_p25": 0.4987, "jail_p25": 0.0222, "kids_count": 96.0719, "commuting_zone": "San Francisco", "vintage": "children born 1978-83, outcomes measured 2014-15", "source": "Opportunity Insights, Opportunity Atlas (Chetty, Friedman, Hendren, Jones, Porter 2018)", "retrieved": "2026-10-20"}, "peers": {"peers": [{"id": "n-2e2adda646", "name": "Northgate Town Square", "city": "San Rafael", "state": "CA", "score": 6.5, "why": ["same strategy: redevelop", "also in CA", "39 km away"]}, {"id": "n-aa92991491", "name": "Hilltop Mall", "city": "Richmond", "state": "CA", "score": 6.5, "why": ["same strategy: redevelop", "also in CA", "34 km away"]}, {"id": "n-98abfb6d68", "name": "Hillsdale Mall", "city": "San Mateo", "state": "CA", "score": 6.5, "why": ["same strategy: redevelop", "also in CA", "11 km away"]}, {"id": "m-8989aa18b3", "name": "Old Mills Mall", "city": "Mountain View", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "37 km away"]}, {"id": "n-e03df26111", "name": "San Antonio Shopping Center", "city": "Mountain View", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "38 km away"]}, {"id": "n-1ed1f8ec6b", "name": "Shuttered Macy’s location", "city": "Corte Madera", "state": "CA", "score": 6.0, "why": ["same strategy: redevelop", "also in CA", "34 km away"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "San Mateo County", "2024": {"units_1": 521, "units_2_4": 29, "units_5plus": 538, "value_total": 577977677}, "2023": {"units_1": 398, "units_2_4": 25, "units_5plus": 750, "value_total": 443893104}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "06081", "year": 2025, "establishments": 1714, "employment": 28461, "avg_annual_pay": 58616, "lq_employment": 0.7, "employment_change_1y": -3.1, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 2060, "emp": 34019}, "2023": {"estab": 1827, "emp": 32272}, "estab_change": -0.113, "emp_change": -0.051, "county_fips": "06081"}, "schools": {"district": "San Mateo Union High School District", "district_geoid": "0634980", "grades": "09-12", "district_vintage": "SY2024-25", "public_schools_1mi": 2, "schools": ["Allen (Decima M.) Elementary", "South San Francisco High"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "06081", "years": "2016-2025", "events": 101, "by_type": {"Flood": 50, "Debris Flow": 18, "Thunderstorm Wind": 15, "Hail": 9, "Lightning": 4, "Flash Flood": 3, "Heavy Rain": 2}, "property_damage_usd": 10060, "deaths_direct": 0, "injuries_direct": 0, "note": "county-typed events only; events logged to forecast zones (CZ_TYPE Z: most winter, heat, flood and coastal events) are not counted", "source": "NOAA NCEI Storm Events Database, details files", "retrieved": "2026-10-20"}, "traffic": {"max_aadt": 160000, "trucks_aadt": 10160, "road": "380", "class": "Interstate", "lanes": 8, "segments_600m": 40, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "use-office", "name": "Office", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "3 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "biotech campus", "origin": "record"}, {"slug": "use-education", "name": "Education", "group_": "use", "evidence": "biotech campus", "origin": "newtypes-extraction"}, {"slug": "place-retail-shrinking-county", "name": "County lost 10%+ of retail establishments since 2012", "group_": "place", "evidence": "-11%", "origin": "census-cbp"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "160,000 on 380", "origin": "fhwa-hpms"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "380", "origin": "fhwa-hpms"}, {"slug": "place-rent-2000-plus", "name": "County typical rent $2,000+", "group_": "place", "evidence": "$3,993/mo", "origin": "zillow"}, {"slug": "place-shrinking-county", "name": "Shrinking county", "group_": "place", "evidence": "-2.7%", "origin": "census-acs"}, {"slug": "anchor-sears", "name": "Sears", "group_": "anchor", "evidence": "Sears", "origin": "wikipedia"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "proposed", "origin": "record"}], "details": {}, "photos": [], "provenance": {"original_developer": "newtypes-extraction", "after_notes": "newtypes-extraction", "developer": "newtypes-extraction"}, "restricted_fields": {"parcels": ["owner_addr", "assessed", "taxable", "tax_amount", "sale_price", "deed_ref"], "deals": ["price", "price_per_acre", "price_per_sqft", "loan_amount", "asking_price"], "how": "free API key: POST /api/v1/keys {\"email\": …}"}}