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 city's own decoder for Philadelphia zoning district codes. 39 rows pairing a code such as RSA-5 with its written name, "Residential Single-Family Attached-5".
This is a lookup table with no geometry. It renders no map and ships no styles. Its purpose is to make zoning_basedistricts readable.
Coordinates are EPSG:3857 (Web Mercator) metres. DuckDB reads geometry
natively, so do not wrap it in ST_GeomFromWKB.
new_code — the zoning code with dashes, e.g. CMX-2.5. Joins to zoning_basedistricts.long_code.code_description — the written name.objectid — row identifier from the source service.The 39 codes fall into four families:
No geometry column, so this collection is tabular. Spatial functions do not apply.
Covers base district codes only. Overlay symbols live in zoning_overlays and are not decoded here.
The table was written with DuckDB rather than portolan extract, which reports "0/0 layers" for ArcGIS services advertising a table instead of a layer. See portolan-cli#812. All 39 rows were verified against the source.
The whole table is small enough to read at once:
Label a zoning map. All 29,205 district polygons match:
Residential codes only: