portolan-pipeline
Point addresses from the City and County of San Francisco Enterprise Addressing System, a 5,000-feature extract of the official DataSF open data layer, converted to cloud-native GeoParquet with a PMTiles visualization. The source asset points at the full live DataSF layer.
License, PDDL-1.0. Providers, City and County of San Francisco (producer, licensor), DataSF (processor), Portolan SDI (host). Original source, https://data.sfgov.org/resource/ramy-di5m.geojson?$limit=5000&$order=:id . Features, 5000. Cloud-native asset, san-francisco-addresses.parquet (GeoParquet). Note, the upstream source is a live endpoint, so it is referenced by URL only and not archived as a source asset.
The data asset is GeoParquet 2.0 with a native geometry type and a covering bbox column for fast web-client pruning. Read it with a recent GeoPandas built on pyarrow 24 or newer.
Or query it in place with a recent DuckDB spatial.
