{"id": "n-de174732a9", "slug": "san-francisco-490-south-van-ness", "type": "gas-station", "name": "490 South Van Ness", "aka": [], "city": "San Francisco", "county": "San Francisco County", "state": "CA", "country": "US", "census_division": 9, "lat": 37.76537, "lon": -122.41758, "geocode_method": "census-address", "address": null, "metro": null, "original_use": "gas station", "year_opened": null, "year_closed": null, "acres": null, "gla_sqft": null, "stores_peak": null, "levels": null, "original_developer": null, "original_architect": null, "before_notes": "Draft from missionlocal.org, model-extracted, unreviewed: A former gas station at 490 South Van Ness proposed for 84 condo units is stalled due to toxic fumes during soil excavation.", "strategy": ["redevelop"], "new_use": ["housing"], "share_retrofit": null, "status": "stalled", "year_retrofit": null, "developer": null, "architect": null, "after_notes": null, "narrative": null, "narrative_license": null, "narrative_source": null, "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": null, "wikipedia": null, "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": "06075", "opp_score": 20.0, "opp_reasons": ["county shrank -3.9% 2018–23", "median rent $2,419", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/gas-stations/ca/san-francisco-490-south-van-ness/", "events": [], "sources": [{"id": 7929, "site_id": "n-de174732a9", "url": "https://missionlocal.org/2013/12/developers-turn-old-gas-stations-into-new-condos/", "title": "Mission's New Condos Built Atop Old Gas Stations (and Leaky Gas ...", "publisher": "missionlocal.org", "date": null, "quote": "490 South Van Ness", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Gas station at 490 South Van Ness (San Francisco) is stalled for redevelopment into housing. Original use: gas station. Strategy: redevelop. New use: housing. Status: stalled. Verified: draft.", "why": "County rent is high ($2,419 median), housing demand is evident in context. Nearby projects include 7 within 10km (2 proposed housing sites within 1km: 899 Valencia, 1198 Valencia). County retail establishments declined 19% (2012–2023).", "where_it_stands": "Stalled. No permits or construction noted. County housing market shows strong demand (ZHVI $1.44M, ZORI $4,784).", "for_a_planner": ["High rent and housing demand align with strategy. Nearby projects (e.g., Stonestown Galleria mall, 3km away) show similar redevelopment trends. Retail decline may support housing conversion."], "for_a_developer": ["Stalled status suggests potential hurdles. Market data (high rent, housing demand) supports new use. Nearby projects (1–3km) indicate active competition. County retail decline may reduce future retail competition."], "risks_and_unknowns": ["Reason for stall unknown. 'County shrank -3.9% 2018–23' unclear (population? retail space?). Traffic data shows no truck volume (trucks_aadt: null). No site-specific permit data."], "data_quality": "partial", "one_line": "Stalled gas station redevelopment into housing in high-rent San Francisco; supported by market data but stalled with unclear reasons.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "e5ac4773a157"}, "cluster": {"within_10km": [{"id": "n-0a0bdeca85", "name": "899 Valencia", "city": "San Francisco", "status": "proposed", "km": 0.8}, {"id": "n-28296958e1", "name": "1198 Valencia", "city": "San Francisco", "status": "proposed", "km": 1.3}, {"id": "m-c770687f0b", "name": "San Francisco Centre", "city": "San Francisco", "status": "operating", "km": 2.3}, {"id": "m-cd17255142", "name": "Westfield San Francisco Centre", "city": "San Francisco", "status": "partial", "km": 2.3}, {"id": "n-9c2f5cf16e", "name": "Stonestown Galleria mall", "city": "San Francisco", "status": "approved", "km": 2.7}, {"id": "n-d1b23217a6", "name": "Westlake Shopping Center", "city": "Daly City", "status": "approved", "km": 9.4}, {"id": "n-6bad73edb5", "name": "Jagalchi", "city": "Daly City", "status": "built", "km": 9.6}], "count_10km": 7, "count_25km": 17}, "elevation": {"elevation_ft": 24.8, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "06075020100", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 21.725451233648, "median_family_income": 47083.0, "snap_households": 518.0, "pop2010": 6172.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 1441170, "month": "2026-09", "change_1y": 0.155, "change_5y": 0.033}, "zori": {"latest": 4784, "month": "2026-09", "change_1y": 0.264, "change_5y": 0.475}, "county_fips": "06075", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "06075020102", "jobs": 1362, "retail_jobs": 238, "food_accommodation_jobs": 183, "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": "94103", "month": "202609", "median_listing_price": 749000, "median_listing_price_yy": -0.1381, "active_listing_count": 60, "median_days_on_market": 61, "price_reduced_share": 0.0575, "pending_ratio": 0.2667, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "06075020100", "kfr_p25": 0.4521, "jail_p25": 0.0267, "kids_count": 874.5306, "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-28296958e1", "name": "1198 Valencia", "city": "San Francisco", "state": "CA", "score": 5.5, "why": ["same strategy: redevelop", "also in CA", "1 km away"]}, {"id": "n-0a0bdeca85", "name": "899 Valencia", "city": "San Francisco", "state": "CA", "score": 5.5, "why": ["same strategy: redevelop", "also in CA", "1 km away"]}, {"id": "m-1f82526ab4", "name": "Bayfair Center", "city": "San Leandro", "state": "CA", "score": 5.0, "why": ["same strategy: redevelop", "also in CA", "26 km away"]}, {"id": "m-c2a3d25cfb", "name": "San Mateo Fashion Island", "city": "San Mateo", "state": "CA", "score": 5.0, "why": ["same strategy: redevelop", "also in CA", "26 km away"]}, {"id": "n-5d8dc66f1c", "name": "3000 Clearview Way", "city": "San Mateo", "state": "CA", "score": 5.0, "why": ["same strategy: redevelop", "also in CA", "27 km away"]}, {"id": "n-9c2f5cf16e", "name": "Stonestown Galleria mall", "city": "San Francisco", "state": "CA", "score": 5.0, "why": ["same strategy: redevelop", "also in CA", "3 km away"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "San Francisco County", "2024": {"units_1": 27, "units_2_4": 38, "units_5plus": 705, "value_total": 433848285}, "2023": {"units_1": 29, "units_2_4": 31, "units_5plus": 1076, "value_total": 485823681}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "06075", "year": 2025, "establishments": 2658, "employment": 30800, "avg_annual_pay": 82963, "lq_employment": 0.45, "employment_change_1y": -5.7, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 3589, "emp": 41598}, "2023": {"estab": 2908, "emp": 41993}, "estab_change": -0.19, "emp_change": 0.009, "county_fips": "06075"}, "schools": {"district": "San Francisco Unified School District", "district_geoid": "0634410", "grades": "KG-12", "district_vintage": "SY2024-25", "public_schools_1mi": 16, "schools": ["Thomas Edison Charter Academy", "Mission Preparatory", "Carmichael (Bessie)/FEC", "Downtown High", "Moscone (George R.) Elementary", "Chavez (Cesar) Elementary"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "06075", "years": "2016-2025", "events": 103, "by_type": {"Flood": 78, "Hail": 10, "Lightning": 6, "Heavy Rain": 4, "Thunderstorm Wind": 4, "Debris Flow": 1}, "property_damage_usd": 120, "deaths_direct": 1, "injuries_direct": 4, "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": 16604, "trucks_aadt": null, "road": null, "class": "principal arterial", "lanes": 2, "segments_600m": 16, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "7 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "place-retail-shrinking-county", "name": "County lost 10%+ of retail establishments since 2012", "group_": "place", "evidence": "-19%", "origin": "census-cbp"}, {"slug": "place-rent-2000-plus", "name": "County typical rent $2,000+", "group_": "place", "evidence": "$4,784/mo", "origin": "zillow"}, {"slug": "place-shrinking-county", "name": "Shrinking county", "group_": "place", "evidence": "-3.9%", "origin": "census-acs"}], "details": {}, "photos": [], "provenance": {}, "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\": …}"}}