{"id": "n-3031765968", "slug": "providence-providence-arcade", "type": "mall", "name": "Providence Arcade", "aka": [], "city": "Providence", "county": "Providence County", "state": "RI", "country": "US", "census_division": 1, "lat": 41.82399, "lon": -71.41283, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "mall", "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 avisonyoung.us, model-extracted, unreviewed: Providence Arcade in Rhode Island, once the oldest mall in the nation, is now home to affordable micro-apartments and is planned for further redevelopment into condos and retail units.", "strategy": ["redevelop", "reinhabit"], "new_use": ["housing", "retail"], "share_retrofit": null, "status": "partial", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "home to affordable micro-apartments and will redevelop once again into condos, with retail units available to purchase.", "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": "44007", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "county grew 3.9% 2018–23", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/malls/ri/providence-providence-arcade/", "events": [], "sources": [{"id": 7602, "site_id": "n-3031765968", "url": "https://www.avisonyoung.us/w/adaptive-reuse-the-way-forward-for-america-s-aging-malls", "title": "Adaptive reuse: The way forward for America's aging malls", "publisher": "avisonyoung.us", "date": null, "quote": "Providence Arcade", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Providence Arcade (Providence, RI) is partially redeveloped, currently housing affordable micro-apartments. It plans future condo redevelopment with retail units available for purchase. ", "why": "Permits show active residential construction (2024: 314 single-unit, 249 multi-unit units). Housing market shows rising ZHVI (+2.3% YoY) and ZORI (+4.2% YoY). Peer Westminster Arcade (0.2km, operating) shares same reinhabit strategy. Retail employment grew 6% (2012–2023) despite business decline (-4.6%).", "where_it_stands": "Adjacent to Westminster Arcade (0.2km) and Mechanical Fabric Company (0km). Traffic on US-6 E: 19,955 ADT (2024).", "for_a_planner": ["Current use: micro-apartments", "Planned: condos + retail", "Local housing demand supported by market trends", "Peer context: Westminster Arcade operating nearby"], "for_a_developer": ["Active construction permits (2024)", "Retail employment growth", "No known barriers to retail units"], "risks_and_unknowns": ["Exact timeline for condo phase unknown", "Current occupancy rate unknown", "No financial details beyond permit values"], "data_quality": "partial", "one_line": "Micro-apartments currently occupy site; plans for condo/retail redevelopment supported by active construction and local housing market trends.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "b1a450303c9f"}, "cluster": {"within_10km": [{"id": "n-8adc6eb7fe", "name": "Mechanical Fabric Company", "city": "Providence", "status": "built", "km": 0.0}, {"id": "m-fb765d3238", "name": "Westminster Arcade", "city": "Providence", "status": "operating", "km": 0.2}, {"id": "m-10b1459bff", "name": "Davol Square Marketplace", "city": "Providence", "status": "unknown", "km": 0.9}], "count_10km": 3, "count_25km": 8}, "elevation": {"elevation_ft": 9.0, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "44007000800", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 38.1863266029047, "median_family_income": 76125.0, "snap_households": 603.0, "pop2010": 4569.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 453475, "month": "2026-09", "change_1y": 0.023, "change_5y": 0.319}, "zori": {"latest": 2053, "month": "2026-09", "change_1y": 0.042, "change_5y": 0.344}, "county_fips": "44007", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "44007000800", "jobs": 20794, "retail_jobs": 1507, "food_accommodation_jobs": 2904, "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": "02903", "month": "202609", "median_listing_price": 438675, "median_listing_price_yy": -0.0875, "active_listing_count": 33, "median_days_on_market": 44, "price_reduced_share": 0.212, "pending_ratio": 0.2154, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "44007000800", "kfr_p25": 0.3824, "jail_p25": 0.0127, "kids_count": 37.0975, "commuting_zone": "Providence", "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-04366ccb9c", "name": "Rhode Island Mall", "city": "Warwick", "state": "RI", "score": 5.5, "why": ["same strategy: redevelop", "also in RI", "13 km away"]}, {"id": "m-fb765d3238", "name": "Westminster Arcade", "city": "Providence", "state": "RI", "score": 5.0, "why": ["same strategy: reinhabit", "also in RI", "0 km away"]}, {"id": "n-8adc6eb7fe", "name": "Mechanical Fabric Company", "city": "Providence", "state": "RI", "score": 5.0, "why": ["same strategy: redevelop, reinhabit", "also in RI", "0 km away"]}, {"id": "n-631e86925b", "name": "Davisville Naval Construction Battalion Center", "city": "Davisville", "state": "RI", "score": 5.0, "why": ["same strategy: redevelop", "also in RI", "24 km away"]}, {"id": "m-5a855ce72a", "name": "Highland Mall", "city": "Austin", "state": "TX", "score": 4.5, "why": ["same strategy: redevelop, reinhabit"]}, {"id": "m-59f54a644e", "name": "Chapel Square Mall", "city": "New Haven", "state": "CT", "score": 4.5, "why": ["same strategy: reinhabit"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Providence County", "2024": {"units_1": 314, "units_2_4": 249, "units_5plus": 219, "value_total": 123462839}, "2023": {"units_1": 232, "units_2_4": 61, "units_5plus": 196, "value_total": 90276531}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "44007", "year": 2025, "establishments": 2010, "employment": 23726, "avg_annual_pay": 39929, "lq_employment": 0.83, "employment_change_1y": -1.4, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 1995, "emp": 24493}, "2023": {"estab": 1904, "emp": 25964}, "estab_change": -0.046, "emp_change": 0.06, "county_fips": "44007"}, "schools": {"district": "Providence School District", "district_geoid": "4400900", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 15, "schools": ["Urban Collaborative Program", "Trinity Academy Performing Art", "RINI Middle College", "Sheila Skip Nowell", "Village Green Virtual", "SouthSide Elementary Charter"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "44007", "years": "2016-2025", "events": 196, "by_type": {"Thunderstorm Wind": 86, "Flood": 42, "Flash Flood": 38, "Hail": 10, "Heavy Rain": 8, "Lightning": 6, "Tornado": 6}, "property_damage_usd": 2852800, "deaths_direct": 0, "injuries_direct": 3, "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": 19955, "trucks_aadt": 1102, "road": "US-6 E", "class": "Interstate", "lanes": 1, "segments_600m": 26, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "strategy-reinhabit", "name": "Reinhabited", "group_": "strategy", "evidence": "home to affordable micro-apartments and will redevelop once again into condos, with retail units available to purchase.", "origin": "record"}, {"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "-apartments and will redevelop once again into condos, with retail units available to purchase.", "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": "home to affordable micro-apartments and will redevelop once again into condos, with retail units available to purchase.", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "home to affordable micro-apartments and will redevelop once again into condos, with retail unit", "origin": "newtypes-extraction"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "US-6 E", "origin": "fhwa-hpms"}, {"slug": "place-rent-2000-plus", "name": "County typical rent $2,000+", "group_": "place", "evidence": "$2,053/mo", "origin": "zillow"}], "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\": …}"}}