2862 EMERALD ST
FOR THE PARTIAL DEMOLITION AND REPAIR OF AN ADDITION AT THE REAR OF AN EXISTING ATTACHED STRUCTURE TO RESOLVE CASE #CF-2023-117605. SIZE & LOCATION AS SHOWN ON THE APPLICATION/PLANS. FOR NO CHANGE IN HEIGHT OF EXISTING STRUCTURE.
Philly doesn't publish eviction filings, so this uses demolition permits as the closest proxy for housing stock loss in the immediate area. 19 permits found.
From the city realty-transfer-tax feed. Mortgages and satisfactions filtered out.
Block-level acquisition pattern. 12 transactions in the immediate area.
Pulled from the city's Carto SQL API. Capped at 5000 most-recent permits per refresh. Geocoding is by the city L&I system and is decent but not perfect; ~1% of permits fall outside Philadelphia bounds and get dropped. Status field is normalized from L&I's free-text values with a best-effort mapping. The Zoning Board of Adjustment decisions dataset (which would have been a better fit) appears to have been retired from OpenDataPhilly.