{"id": "n-2e46de2ba4", "slug": "detroit-rogell-golf-course", "type": "golf-course", "name": "Rogell Golf Course", "aka": [], "city": "Detroit", "county": "Wayne County", "state": "MI", "country": "US", "census_division": 3, "lat": 42.33155, "lon": -83.04664, "geocode_method": "nominatim-city", "address": null, "metro": null, "original_use": "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 detroitmi.gov, model-extracted, unreviewed: The former Rogell Golf Course, an 18-hole golf course that closed in 2013, was transformed into a 98-acre public nature park and opened in 2026.", "strategy": ["redevelop", "regreen"], "new_use": ["housing", "park", "retail"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": "City of Detroit", "architect": null, "after_notes": "a 98-acre public nature park, featuring a paved walking trail, scenic overlooks, boardwalks and restored wetlands", "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", "housing in the record", "public owner"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/golf-courses/mi/detroit-rogell-golf-course/", "events": [], "sources": [{"id": 7847, "site_id": "n-2e46de2ba4", "url": "https://detroitmi.gov/news/how-former-golf-course-became-detroits-new-98-acre-nature-park", "title": "How a former golf course became Detroit's new 98-acre nature park", "publisher": "detroitmi.gov", "date": null, "quote": "Rogell Golf Course", "kind": "news", "license": null, "retrieved": "2026-10-18"}, {"id": 7848, "site_id": "n-2e46de2ba4", "url": "https://wrif.com/2025/07/08/former-detroit-golf-course-to-become-nature-park-new-development/", "title": "Former Detroit Golf Course to Become Nature Park, New Development", "publisher": "wrif.com", "date": null, "quote": "Rogell Golf Course", "kind": "news", "license": null, "retrieved": "2026-10-18"}, {"id": 7849, "site_id": "n-2e46de2ba4", "url": "https://www.wxyz.com/news/region/detroit/former-detroit-golf-course-transforming-into-nature-park-additional-development", "title": "Former Detroit golf course transforming into nature park, additional ...", "publisher": "wxyz.com", "date": null, "quote": null, "kind": "news", "license": null, "retrieved": "2026-10-18"}, {"id": 7850, "site_id": "n-2e46de2ba4", "url": "https://kissfmdetroit.com/2025/07/08/former-detroit-golf-course-to-become-nature-park-new-development/", "title": "Former Detroit Golf Course to Become Nature Park, New Development", "publisher": "kissfmdetroit.com", "date": null, "quote": "Rogell Golf Course", "kind": "news", "license": null, "retrieved": "2026-10-18"}], "deals": [], "parties": [{"name": "City of Detroit", "kind": "developer", "role": "developer", "year_from": null, "year_to": null}], "parcels": [], "context": {"assessment": {"what_happened": "The site is a 98-acre public nature park (per after_notes), featuring walking trails, wetlands, and overlooks. It was developed by the City of Detroit as a completed retrofit (status: built), not a vacant site needing redevelopment. The \"regreen\" strategy was implemented, converting the former golf course into a park. Current use is park (no housing/retail active).", "why": "Record explicitly states retrofit is complete (opp_reasons: \"retrofit already built\", \"public owner\"). New uses (housing/park/retail) in strategy are not current activities; park is the operational use. No vacant land or pending development noted.", "where_it_stands": "Publicly owned park, fully built, no active housing/retail development. Housing/retail are only listed as potential new uses in the strategy, not implemented.", "for_a_planner": ["Public park is operational", "No vacant land for new development", "City-owned, no private developer involvement"], "for_a_developer": ["Not available for new construction (already built)", "No housing/retail opportunity here", "Public park is the current use, not a site for redevelopment"], "risks_and_unknowns": ["No current housing/retail activity", "No indication of future development plans beyond park use", "Zillow data (ZHVI) shows market trends but not site-specific demand"], "data_quality": "partial", "one_line": "Completed public park, no active development opportunities.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "f53e3fd36027"}, "cluster": {"within_10km": [{"id": "n-721f36596a", "name": "Former MGM Grand Detroit temporary casino building", "city": "Detroit", "status": "built", "km": 0.0}, {"id": "n-7e2abc8bbb", "name": "Former Rogell Golf Course", "city": "Detroit", "status": "built", "km": 0.0}, {"id": "n-db06d3ef5b", "name": "Industrial Building", "city": "Detroit", "status": "operating", "km": 0.4}, {"id": "n-f82fd7da4e", "name": "Graybar Electric Company Building", "city": "Detroit", "status": "built", "km": 2.6}, {"id": "n-a6a7c000ec", "name": "Frederick Stearns Building", "city": "Detroit", "status": "built", "km": 3.6}], "count_10km": 5, "count_25km": 15}, "elevation": {"elevation_ft": 598.7, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "26163520800", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "lapop1share": 0.0, "poverty_rate": 8.12641083521445, "median_family_income": 123355.0, "snap_households": 0.0, "pop2010": 1616.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": "26163520800", "jobs": 16342, "retail_jobs": 112, "food_accommodation_jobs": 382, "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": "48226", "month": "202609", "median_listing_price": 347450, "median_listing_price_yy": -0.0001, "active_listing_count": 38, "median_days_on_market": 74, "price_reduced_share": 0.1506, "pending_ratio": 0.4605, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "26163520800", "kfr_p25": 0.371, "jail_p25": 0.0493, "kids_count": 33.0786, "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-5db8e35bb3", "name": "Rogell Park", "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", "0 km away"]}, {"id": "n-c978d7b868", "name": "Former Kmart property in Plymouth Township", "city": "Plymouth Township", "state": "MI", "score": 6.0, "why": ["same strategy: redevelop", "also in MI", "37 km away"]}, {"id": "n-f82fd7da4e", "name": "Graybar Electric Company Building", "city": "Detroit", "state": "MI", "score": 6.0, "why": ["same strategy: redevelop", "also in MI", "3 km away"]}, {"id": "m-2bd2cb975c", "name": "Muskegon Mall", "city": "Muskegon", "state": "MI", "score": 5.0, "why": ["same strategy: redevelop", "also in MI"]}, {"id": "m-81f2d5ca53", "name": "Eastland Center", "city": "Harper Woods", "state": "MI", "score": 5.0, "why": ["same strategy: redevelop", "also in MI", "16 km away"]}], "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": 3, "schools": ["WAY Michigan", "Cass Technical High School", "Chrysler Elementary 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": 22357, "trucks_aadt": 470, "road": "S M 10", "class": "freeway or expressway", "lanes": 6, "segments_600m": 21, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "5 within 10 km", "origin": "computed"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "a 98-acre public nature park, featuring a paved walking trail, scenic overlooks, boardwalks and restored wetlands", "origin": "record"}, {"slug": "strategy-regreen", "name": "Regreened", "group_": "strategy", "evidence": "a 98-acre public nature park, featuring a paved walking trail, scenic overlooks, boardwalks and restored wetlands", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "newtypes-extraction"}, {"slug": "use-park", "name": "Park and open space", "group_": "use", "evidence": "a 98-acre public nature park, featuring a paved walking trail, scenic overlooks, boardwa", "origin": "newtypes-extraction"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "S M 10", "origin": "fhwa-hpms"}], "details": {}, "photos": [], "provenance": {"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\": …}"}}