Ten collections describing property, zoning, vacancy, and affordable housing in Philadelphia, mirrored from the City of Philadelphia's ArcGIS services via OpenDataPhilly.
Guidance for AI agents and LLMs working with this collection.
The ten Philadelphia City Council districts as redrawn after the 2020 census. Each elects one council member; the city also seats seven at-large members who represent no district.
Use these boundaries to aggregate any other collection in this catalog by district.
Coordinates are EPSG:3857 (Web Mercator) metres. DuckDB reads geometry
natively, so do not wrap it in ST_GeomFromWKB.
district — district number as a string, "1" through "10". Style expressions and joins must quote it.district_num — the same value as a small integer, for numeric sorting.shape_leng, Shape__Length, Shape__Area — perimeter and area in Web Mercator units.These boundaries took effect for the 2024 election. Analysis of earlier years needs the matching vintage from the publisher, who also releases 1990, 2000, and 2016.
Districts partition the city, so a point falls in exactly one.
Sorting on district as a string puts "10" between "1" and "2". Sort on district_num for numeric order.
Aggregate any collection by district. Vacant land, for instance:
Affordable housing units delivered per district:
Districts in numeric order:
councildistrict directly, so aggregating them needs no spatial join.