{"id": "n-5db8e35bb3", "slug": "detroit-rogell-park", "type": "golf-course", "name": "Rogell Park", "aka": [], "city": "Detroit", "county": "Wayne County", "state": "MI", "country": "US", "census_division": 3, "lat": 42.42353, "lon": -83.2671, "geocode_method": "census-address", "address": null, "metro": null, "original_use": "private golf course", "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 clickondetroit.com, model-extracted, unreviewed: A former private golf course along 7 Mile Road and Berg Road has been transformed into a 98-acre public nature park with trails, wetlands, and meadows.", "strategy": ["regreen"], "new_use": ["park"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": null, "architect": null, "after_notes": "expansive nature trails, wetlands, and meadows, along with overlooks, pathways, and boardwalks", "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": "26163", "opp_score": 0.0, "opp_reasons": ["retrofit already built"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/golf-courses/mi/detroit-rogell-park/", "events": [], "sources": [{"id": 7935, "site_id": "n-5db8e35bb3", "url": "https://www.clickondetroit.com/news/local/2026/06/26/from-golf-course-to-green-space-detroits-98-acre-park-transforms-former-course-into-nature-destination/", "title": "From golf course to green space: Detroit's 98-acre park transforms ...", "publisher": "clickondetroit.com", "date": null, "quote": "Rogell Park", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Rogell Park (formerly Rogell Golf Course) was retrofitted from a private golf course to a public park with nature trails, wetlands, meadows, overlooks, pathways, and boardwalks. The retrofit is complete (status: built).", "why": "The opportunity is closed—'retrofit already built' (opp_reasons). No new development is planned.", "where_it_stands": "The site is operational as a park. No ownership, management, or current usage metrics are provided in the record.", "for_a_planner": ["No development permits or housing data apply to this park conversion.", "Traffic data (Grand River Ave, 4 lanes) is unrelated to the park's current use."], "for_a_developer": ["Not an opportunity for new construction (opp_score: 0.0).", "No details on costs, timeline, or community engagement for the retrofit are provided."], "risks_and_unknowns": ["Verified status is 'draft'—no confirmation of completion or current condition.", "No data on park usage, maintenance, or community impact is included."], "data_quality": "good", "one_line": "Former golf course retrofitted to park; no further development possible (already built).", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "3e8c8cc6c619"}, "cluster": {"within_10km": [{"id": "m-d6e048f541", "name": "Livonia Mall", "city": "Livonia", "status": "operating", "km": 5.7}, {"id": "m-3d14c8e5f6", "name": "Northland Center", "city": "Southfield", "status": "under construction", "km": 6.0}, {"id": "m-bdeb3dc307", "name": "Wonderland Mall", "city": "Livonia", "status": "operating", "km": 8.2}, {"id": "m-ae5d41367c", "name": "Tel-Twelve Mall", "city": "Southfield", "status": "operating", "km": 8.5}, {"id": "n-4288c523c4", "name": "Sears store", "city": "Livonia", "status": "proposed", "km": 9.3}], "count_10km": 5, "count_25km": 22}, "elevation": {"elevation_ft": 628.2, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "26163541400", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 31.861533027198902, "median_family_income": 39327.0, "snap_households": 360.0, "pop2010": 2634.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 175631, "month": "2026-09", "change_1y": 0.008, "change_5y": 0.207}, "zori": {"latest": 1402, "month": "2026-09", "change_1y": 0.045, "change_5y": 0.255}, "county_fips": "26163", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "26163541400", "jobs": 264, "retail_jobs": 17, "food_accommodation_jobs": 46, "year": 2021, "source": "Census LEHD LODES8 WAC 2021 (all jobs, primary and secondary), blocks summed to the 2020 tract", "retrieved": "2026-10-20"}, "listings": {"zip": "48219", "month": "202609", "median_listing_price": 89950, "median_listing_price_yy": -0.0971, "active_listing_count": 171, "median_days_on_market": 57, "price_reduced_share": 0.203, "pending_ratio": 0.4135, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "26163541400", "kfr_p25": 0.3203, "jail_p25": 0.0241, "kids_count": 516.0759, "commuting_zone": "Detroit", "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-2e46de2ba4", "name": "Rogell Golf Course", "city": "Detroit", "state": "MI", "score": 6.5, "why": ["same strategy: regreen", "also in MI", "21 km away"]}, {"id": "n-7e2abc8bbb", "name": "Former Rogell Golf Course", "city": "Detroit", "state": "MI", "score": 6.5, "why": ["same strategy: regreen", "also in MI", "21 km away"]}, {"id": "m-3d14c8e5f6", "name": "Northland Center", "city": "Southfield", "state": "MI", "score": 5.0, "why": ["same strategy: regreen", "also in MI", "6 km away"]}, {"id": "m-920fc3d7bc", "name": "Fort Saginaw Mall", "city": "Buena Vista", "state": "MI", "score": 4.0, "why": ["same strategy: regreen", "also in MI"]}, {"id": "m-fe8ce81673", "name": "Villa Italia Mall", "city": "Lakewood", "state": "CO", "score": 4.0, "why": ["same strategy: regreen"]}, {"id": "m-8699fc85c6", "name": "Midtown Square Mall", "city": "Charlotte", "state": "NC", "score": 4.0, "why": ["same strategy: regreen"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Wayne County", "2024": {"units_1": 1058, "units_2_4": 344, "units_5plus": 1227, "value_total": 437511890}, "2023": {"units_1": 956, "units_2_4": 230, "units_5plus": 718, "value_total": 314499766}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "26163", "year": 2025, "establishments": 5616, "employment": 64685, "avg_annual_pay": 41403, "lq_employment": 0.91, "employment_change_1y": 0.9, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 6083, "emp": 65615}, "2023": {"estab": 5635, "emp": 70575}, "estab_change": -0.074, "emp_change": 0.076, "county_fips": "26163"}, "schools": {"district": "Detroit Public Schools Community District", "district_geoid": "2601103", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 7, "schools": ["David Ellis Academy  PK", "Detroit Service Learning Academy Campus", "Old Redford Academy  Elementary", "Old Redford Academy  Middle School", "MadisonCarver Academy", "Communication and Media Arts High School"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "26163", "years": "2016-2025", "events": 201, "by_type": {"Thunderstorm Wind": 138, "Hail": 20, "Flood": 19, "Flash Flood": 16, "Tornado": 8}, "property_damage_usd": 211185500, "deaths_direct": 1, "injuries_direct": 5, "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": 17713, "trucks_aadt": 407, "road": "Grand River Ave", "class": "principal arterial", "lanes": 4, "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": "5 within 10 km", "origin": "computed"}, {"slug": "strategy-regreen", "name": "Regreened", "group_": "strategy", "evidence": "expansive nature trails, wetlands, and meadows, along with overlooks, pathways, and boardwalks", "origin": "record"}, {"slug": "use-park", "name": "Park and open space", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}], "details": {}, "photos": [], "provenance": {"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\": …}"}}