{"id": "n-4af820edeb", "slug": "denver-union-station-north", "type": "industrial", "name": "Union Station North", "aka": [], "city": "Denver", "county": "Denver County", "state": "CO", "country": "US", "census_division": 8, "lat": 39.7598, "lon": -104.9968, "geocode_method": "wikipedia", "address": null, "metro": null, "original_use": "industrial buildings, waste, railroad tracks", "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 Wikipedia, model-extracted, unreviewed: Union Station North, formerly an industrial area with waste and railroad tracks, was redeveloped into multi-story residential buildings, restaurants, and amenities with access to the South Platte River Trail.", "strategy": ["redevelop", "regreen"], "new_use": ["civic", "housing", "park", "retail"], "share_retrofit": null, "status": "built", "year_retrofit": null, "developer": null, "architect": null, "after_notes": null, "narrative": "Union Station North, formerly known as Prospect, is a neighborhood within the city limits of Denver, Colorado. Previously dominated by industrial buildings, waste, railroad tracks and considered an area of the city to be avoided, today it has been rehabilitated into multi-story residential buildings, restaurants, amenities, easy access to downtown Denver, and is a short walk to the South Platte River Trail, which runs along its northern boundary.\n\n\n== Name ==\nOriginally an area of Denver known as, \"The Bottoms\", \"Prospect\", or \"Prospect Park\", Union Station North is one of the oldest parts of Denver.", "narrative_license": "CC BY-SA 4.0", "narrative_source": "https://en.wikipedia.org/wiki/Union_Station_North", "zoning_change": null, "public_subsidy": null, "entitlement_year": null, "planning_notes": null, "wikidata_qid": "Q107619371", "wikipedia": "https://en.wikipedia.org/wiki/Union_Station_North", "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": "08031", "opp_score": 0.0, "opp_reasons": ["retrofit already built", "median rent $1,770", "housing in the record"], "for_sale": 0, "distressed": 0, "url": "https://retrofitatlas.org/industrial/co/denver-union-station-north/", "events": [], "sources": [{"id": 7086, "site_id": "n-4af820edeb", "url": "https://en.wikipedia.org/wiki/Union_Station_North", "title": "Union Station North", "publisher": "Wikipedia", "date": null, "quote": "Union Station North", "kind": "wikipedia", "license": "CC BY-SA 4.0", "retrieved": "2026-10-18"}], "deals": [], "parties": [], "parcels": [], "context": {"assessment": {"what_happened": "Union Station North was redeveloped from industrial buildings, waste, and railroad tracks into civic, housing, park, and retail uses. The project is complete (status: built).", "why": "Opp_score is 0.0 because retrofit is already built, median rent is $1,770, and housing is already present in the record. No new opportunity exists here.", "where_it_stands": "Within 10km, 15 nearby sites exist (e.g., built K-Mart, Central Park, proposed Park Hill Golf Course). Housing market shows ZHVI at $528,188 (2026-09) with a 1.8% annual decline. 872 housing units were permitted in 2024.", "for_a_planner": ["No active development opportunity", "High traffic volume (I-25, 274k ADT) supports retail/park access", "Peer projects (e.g., Villa Italia Mall, 9km away) share similar redevelop strategy"], "for_a_developer": ["Not an opportunity: already built", "Median rent ($1,770) aligns with current market", "No vacant parcels noted in record"], "risks_and_unknowns": ["No vacant land or pending permits identified", "No details on park/civic implementation", "Housing market shows slight decline (1.8% YoY)"], "data_quality": "partial", "one_line": "Built industrial-to-housing redevelop, no active opportunity.", "model": "qwen3-30b-a3b-64k:latest", "machine": "Dell 5820 RTX 3090 (Ollama, qwen3-30b-a3b)", "record_sha1": "8341333a55bb"}, "cluster": {"within_10km": [{"id": "n-4742daa26a", "name": "Celebrity Sports Center", "city": "Denver", "status": "built", "km": 2.5}, {"id": "n-6454e0acd6", "name": "Former Park Hill Golf Club", "city": "Denver", "status": "proposed", "km": 2.5}, {"id": "n-928826c11a", "name": "Former K-Mart site", "city": "Denver", "status": "built", "km": 2.5}, {"id": "n-a5ddca1d49", "name": "Central Park", "city": "Denver", "status": "built", "km": 2.5}, {"id": "n-aad5d93c49", "name": "Park Hill Golf Course", "city": "Denver", "status": "proposed", "km": 5.0}, {"id": "n-70930b3d44", "name": "Kmart in the Broadway Marketplace", "city": "Denver", "status": "under construction", "km": 5.5}, {"id": "n-d230d1a844", "name": "Sears in Cherry Creek", "city": "Denver", "status": "proposed", "km": 5.7}, {"id": "n-69f80451de", "name": "Cherry Lane", "city": "Denver", "status": "proposed", "km": 5.8}, {"id": "m-c41eb9f17a", "name": "Broadway Plaza", "city": "Denver", "status": "unknown", "km": 6.2}, {"id": "m-0c376645d0", "name": "Lamar Plaza Station", "city": "Lakewood", "status": "partial", "km": 6.5}, {"id": "n-647f652e0f", "name": "Solana Olde Town Station Apartments", "city": "Arvada", "status": "built", "km": 8.5}, {"id": "m-fe8ce81673", "name": "Villa Italia Mall", "city": "Lakewood", "status": "built", "km": 8.9}], "count_10km": 15, "count_25km": 27}, "elevation": {"elevation_ft": 5174.1, "resolution": 1, "source": "USGS EPQS (3DEP)", "retrieved": "2026-10-20"}, "food_access": {"tract10": "08031001600", "urban": 1, "lila_1_10": 0, "low_access_1mi": 0, "poverty_rate": 13.5534014496551, "median_family_income": 83726.0, "snap_households": 299.0, "pop2010": 7685.0, "source": "USDA ERS Food Access Research Atlas 2019 (ArcGIS copy)", "retrieved": "2026-10-20"}, "housing_market": {"zhvi": {"latest": 528188, "month": "2026-09", "change_1y": -0.018, "change_5y": -0.008}, "zori": {"latest": 1867, "month": "2026-09", "change_1y": 0.001, "change_5y": 0.063}, "county_fips": "08031", "source": "Zillow Research (ZHVI, ZORI)"}, "jobs_lodes": {"tract20": "08031001602", "jobs": 3884, "retail_jobs": 39, "food_accommodation_jobs": 334, "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": "80202", "month": "202609", "median_listing_price": 567000, "median_listing_price_yy": -0.0542, "active_listing_count": 222, "median_days_on_market": 93, "price_reduced_share": 0.2375, "pending_ratio": 0.1239, "source": "Realtor.com Research, inventory core metrics by ZIP (ZCTA at the site point)", "retrieved": "2026-10-20"}, "opportunity": {"tract10": "08031001600", "kfr_p25": 0.3221, "jail_p25": 0.097, "kids_count": 582.6834, "commuting_zone": "Denver", "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-fe8ce81673", "name": "Villa Italia Mall", "city": "Lakewood", "state": "CO", "score": 6.5, "why": ["same strategy: redevelop, regreen", "also in CO", "9 km away"]}, {"id": "m-e5c459ed4b", "name": "Crossroads Mall", "city": "Boulder", "state": "CO", "score": 6.5, "why": ["same strategy: redevelop", "also in CO", "36 km away"]}, {"id": "m-d993699a33", "name": "SouthGlenn Mall", "city": "Centennial", "state": "CO", "score": 6.5, "why": ["same strategy: redevelop, regreen", "also in CO", "19 km away"]}, {"id": "m-5f44df2309", "name": "Cinderella Mall", "city": "Englewood", "state": "CO", "score": 6.5, "why": ["same strategy: redevelop, regreen", "also in CO", "12 km away"]}, {"id": "m-685f3c2586", "name": "Buckingham Mall", "city": "Aurora", "state": "CO", "score": 6.5, "why": ["same strategy: redevelop, regreen", "also in CO", "13 km away"]}, {"id": "n-2e8a724f11", "name": "Stapleton International Airport", "city": "Denver", "state": "CO", "score": 6.0, "why": ["same strategy: redevelop", "also in CO", "9 km away"]}], "method": "size, era, strategy, status, type, state, distance"}, "permits": {"county": "Denver County", "2024": {"units_1": 872, "units_2_4": 4, "units_5plus": 3118, "value_total": 788494244}, "2023": {"units_1": 1174, "units_2_4": 2, "units_5plus": 4549, "value_total": 1073491646}, "retrieved": "2026-10-18"}, "qcew_retail": {"county": "08031", "year": 2025, "establishments": 2329, "employment": 30425, "avg_annual_pay": 52368, "lq_employment": 0.55, "employment_change_1y": -5.4, "source": "BLS QCEW 2025 annual, county, NAICS 44-45 retail trade, private", "retrieved": "2026-10-20"}, "retail_trend": {"2012": {"estab": 2272, "emp": 26298}, "2023": {"estab": 2348, "emp": 32628}, "estab_change": 0.033, "emp_change": 0.241, "county_fips": "08031"}, "schools": {"district": "Denver County School District 1", "district_geoid": "0803360", "grades": "PK-12", "district_vintage": "SY2024-25", "public_schools_1mi": 3, "schools": ["Bryant Webster Dual Language ECE-8 School", "University Prep - Arapahoe St.", "RiseUp Community School"], "schools_vintage": "SY2023-24", "source": "NCES EDGE", "retrieved": "2026-10-20"}, "storms": {"county": "08031", "years": "2016-2025", "events": 183, "by_type": {"Hail": 127, "Thunderstorm Wind": 41, "Flash Flood": 7, "Heavy Rain": 3, "Tornado": 3, "Lightning": 1, "Flood": 1}, "property_damage_usd": 820000, "deaths_direct": 0, "injuries_direct": 2, "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": 274000, "trucks_aadt": 25000, "road": "I-25", "class": "Interstate", "lanes": 10, "segments_600m": 40, "year": "2024", "source": "FHWA HPMS", "retrieved": "2026-10-20"}}, "elements": [{"slug": "use-retail", "name": "Retail (continued)", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "place-mall-cluster", "name": "3+ other atlas sites within 10 km", "group_": "place", "evidence": "15 within 10 km", "origin": "computed"}, {"slug": "place-apartment-boom-county", "name": "County permitting 2,000+ apartment units a year", "group_": "place", "evidence": "3,118 units, Denver County", "origin": "census-bps"}, {"slug": "strategy-redevelop", "name": "Redeveloped", "group_": "strategy", "evidence": "", "origin": "record"}, {"slug": "strategy-regreen", "name": "Regreened", "group_": "strategy", "evidence": "", "origin": "record"}, {"slug": "use-housing", "name": "Housing", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "use-park", "name": "Park and open space", "group_": "use", "evidence": "new_use field", "origin": "record"}, {"slug": "place-high-traffic", "name": "30,000+ vehicles a day on an adjacent road", "group_": "place", "evidence": "274,000 on I-25", "origin": "fhwa-hpms"}, {"slug": "place-freeway-frontage", "name": "Interstate or freeway within 600 m", "group_": "place", "evidence": "I-25", "origin": "fhwa-hpms"}, {"slug": "use-civic", "name": "Civic and government", "group_": "use", "evidence": "new_use field", "origin": "record"}], "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\": …}"}}