{"id": "n-b0555f32b1", "slug": "troy-5-story-vacant-warehouse", "type": "industrial", "name": "5-story vacant warehouse", "aka": [], "city": "Troy", "county": "Rensselaer County", "state": "NY", "country": "US", "census_division": 2, "lat": 42.72841, "lon": -73.69179, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "warehouse", "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 troyny.gov, model-extracted, unreviewed: A 5-story vacant warehouse was redeveloped into 74 residential apartment units, approved in 2017.", "strategy": ["redevelop"], "new_use": ["housing"], "share_retrofit": null, "status": "approved", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "74 residential apartment units", "narrative": null, "narrative_license": null, "narrative_source": null, "zoning_change": null, "public_subsidy": null, "entitlement_year": 2017, "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": "36083", "opp_score": 0.0, "opp_reasons": ["already in play: under construction, approved, or sold to a developer with housing plans", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/industrial/ny/troy-5-story-vacant-warehouse/", "events": [{"year": 2017, "date": null, "kind": "note", "detail": "Project Approved", "source_id": 8916}], "sources": [{"id": 8915, "site_id": "n-b0555f32b1", "url": "https://www.troyny.gov/303/Projects", "title": "Projects | Troy, NY", "publisher": "troyny.gov", "date": null, "quote": "5-story vacant warehouse", "kind": "news", "license": null, "retrieved": "2026-10-18"}, {"id": 8916, "site_id": "n-b0555f32b1", "url": "https://www.troyny.gov/303/Projects", "title": "Timeline", "publisher": null, "date": null, "quote": "Project Approved: August 30, 2017", "kind": "quote", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "5-story vacant warehouse in Troy, NY (originally industrial) approved for 74 residential units in 2017. Record states it is 'already in play' (approved, under construction, or sold with housing plans), making it not a new opportunity. Status is 'approved' with no current construction confirmation. Housing market shows strong growth (ZHVI up 32.3% over 5 years), but project is inactive per 'vacant' status. Nearby operating malls include Uncle Sam Atrium (0.4km). No current construction or delivery date provided. Verified as 'draft'.", "why": "Record explicitly lists 'approved' and 'housing in the record' as reasons it's not a new opportunity. No evidence of active development beyond 2017 approval. Context shows housing demand but project status is static.", "where_it_stands": "Approved for housing redevelopment but remains vacant; no active development noted. Not a current opportunity per database logic.", "for_a_planner": ["Nearby operating mall (Uncle Sam Atrium) at 0.4km", "Housing market growth confirmed (ZHVI +32.3% 5y)"], "for_a_developer": ["Not a new opportunity (already approved)", "No active construction status", "74 units planned but no timeline"], "risks_and_unknowns": ["No current construction status", "No delivery date", "Verified as 'draft' (data incomplete)"], "data_quality": "partial", "one_line": "Approved housing project (74 units) but inactive and marked as 'already in play'—not a current opportunity.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "47d9117af408"}, "cluster": {"within_10km": [{"id": "m-6fb9774175", "name": "Uncle Sam Atrium", "city": "Troy", "status": "operating", "km": 0.4}, {"id": "m-db303dd224", "name": "Cohoes Commons", "city": "Cohoes", "status": "operating", "km": 5.3}, {"id": "m-2d3ffbf567", "name": "Latham Circle Mall", "city": "Latham", "status": "operating", "km": 6.2}, {"id": "n-f96effad57", "name": "Albany Felt Company Complex", "city": "Menands", "status": "under construction", "km": 6.6}], "count_10km": 4, "count_25km": 8}, "elevation": {"elevation_ft": 36.0, "resolution": 3.086419871794868e-05, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "36083040700", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "lapop1share": 7.56723865556779, "poverty_rate": 34.6921075455334, "median_family_income": 40278.0, "snap_households": 800.0, "pop2010": 5001.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 327950, "month": "2026-09", "change_1y": 0.058, "change_5y": 0.323}, "zori": {"latest": 1521, "month": "2026-09", "change_1y": 0.055, "change_5y": 0.331}, "county_fips": "36083", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "36083040701", "jobs": 6578, "retail_jobs": 323, "food_accommodation_jobs": 680, "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": "12180", "month": "202609", "median_listing_price": 357425, "median_listing_price_yy": 0.2248, "active_listing_count": 51, "median_days_on_market": 34, "price_reduced_share": 0.1165, "pending_ratio": 1.1275, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "36083040700", "kfr_p25": 0.3509, "jail_p25": 0.0414, "kids_count": 448.8704, "commuting_zone": "Albany", "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": "m-2d3ffbf567", "name": "Latham Circle Mall", "city": "Latham", "state": "NY", "score": 5.0, "why": ["same strategy: redevelop", "also in NY", "6 km away"]}, {"id": "m-dea9dcb49a", "name": "Mohawk Mall", "city": "Niskayuna", "state": "NY", "score": 5.0, "why": ["same strategy: redevelop", "also in NY", "17 km away"]}, {"id": "n-6d401482d8", "name": "W. Averell Harriman State Office Building Campus", "city": "Albany", "state": "NY", "score": 5.0, "why": ["same strategy: redevelop", "also in NY", "11 km away"]}, {"id": "m-caa6dbb6e8", "name": "Midtown Plaza", "city": "Rochester", "state": "NY", "score": 4.0, "why": ["same strategy: redevelop", "also in NY"]}, {"id": "m-251a441e4b", "name": "Summit Park Mall", "city": "Wheatfield", "state": "NY", "score": 4.0, "why": ["same strategy: redevelop", "also in NY"]}, {"id": "m-1b07bc5e65", "name": "University Plaza", "city": "Vestal", "state": "NY", "score": 4.0, "why": ["same strategy: redevelop", "also in NY"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Rensselaer County", "2024": {"units_1": 160, "units_2_4": 29, "units_5plus": 131, "value_total": 73611727}, "2023": {"units_1": 105, "units_2_4": 20, "units_5plus": 156, "value_total": 49896110}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "36083", "year": 2025, "establishments": 413, "employment": 5713, "avg_annual_pay": 39746, "lq_employment": 1.03, "employment_change_1y": 0.5, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 423, "emp": 5978}, "2023": {"estab": 435, "emp": 5717}, "estab_change": 0.028, "emp_change": -0.044, "county_fips": "36083"}, "schools": {"district": "Troy City School District", "district_geoid": "3628950", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 0, "schools": [], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "36083", "years": "2016-2025", "events": 248, "by_type": {"Thunderstorm Wind": 195, "Flash Flood": 19, "Flood": 15, "Hail": 13, "Lightning": 4, "Heavy Rain": 1, "Tornado": 1}, "property_damage_usd": 3961000, "deaths_direct": 0, "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": 9110, "trucks_aadt": 1210, "road": "I787 NB to Lower Hudson Ave", "class": null, "lanes": 1, "segments_600m": 32, "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": "4 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "74 residential apartment units", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "74 residential apartment units", "origin": "newtypes-extraction"}, {"slug": "status-pipeline", "name": "Retrofit in the pipeline", "group_": "finance", "evidence": "approved", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"status": "newtypes-extraction", "after_notes": "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\": …}"}}