Place geometries
place_geometriesrelease v0.7.1CC0 1.0
About
Dated geometry versions of places (EPSG:4326): parcel and block polygons, address points, street lines, neighbourhoods, the 1906 burn zone, showcase features (approximate circles). hit_geom is the clickable footprint (points and lines buffered by the place type), hit_area_m2 drives specificity.
- How far to trust it
- The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority. Details
- Licence
- CC0 1.0: use it for anything, no permission needed. The scans and other sources keep their own rights.
- Version
- v0.7.1, published 21 October 2026. A published release is never changed; corrections come as a new release.
Technical details
- Table
- place_geometries
- Rows
- 459,992
- Columns
- 16
- Parquet
- place_geometries.parquet, 137.7 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by geom_kind
Rows by bounds
| Value | Rows | Share | |
|---|---|---|---|
| official | 459,987 | 100.0% | |
| approximate | 5 | < 0.1% |
Rows by source
| Value | Rows | Share | |
|---|---|---|---|
| DataSF parcels | 227,664 | 49.5% | |
| DataSF EAS | 224,390 | 48.8% | |
| Assessor blocks (DataSF), via the map block index | 5,404 | 1.2% | |
| DataSF street centerlines (CNN) | 2,234 | 0.5% | |
| DataSF Recreation and Parks Properties (gtr9-ntp6) | 253 | 0.1% | |
| DataSF Analysis Neighborhoods (simplified) | 41 | < 0.1% | |
| Wikidata point + radius set by qipu | 5 | < 0.1% | |
| DataSF ff3a-iqhv | 1 | < 0.1% |
Method and accuracy
No accuracy measure for this table yet.
The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority.
Columns 16
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| place_id | VARCHAR | no | none | as is | The place (see places). |
| geom_version | INTEGER | yes | none | as is | Version of the place's shape; 1 on every row. |
| valid_from | DATE | yes | none | as is | First day the shape is valid; empty = always. |
| valid_to | DATE | yes | none | as is | Last day the shape is valid; empty = still. |
| geom | GEOMETRY('OGC:CRS84') | yes | none | as is | The shape (WGS84 lon/lat): point, line or polygon. |
| hit_geom | GEOMETRY('OGC:CRS84') | yes | none | as is | Clickable footprint: polygons as drawn; points and lines buffered by place_types.hit_buffer_m (at least 3 m). |
| geom_kind | VARCHAR | no | none | as is | polygon, point or line.Values line, point, polygon |
| bounds | VARCHAR | yes | none | as is | official (from a register) or approximate (a circle around a point).Values approximate, official |
| source | VARCHAR | yes | none | as is | Layer the shape comes from (DataSF parcels, DataSF EAS, DataSF street centerlines (CNN), ...).Values Assessor blocks (DataSF), via the map block index, DataSF Analysis Neighborhoods (simplified), DataSF EAS, DataSF ff3a-iqhv, DataSF parcels, DataSF street centerlines (CNN), Wikidata point + radius set by qipu |
| area_m2 | DOUBLE | yes | none | as is | Polygon area in m²; empty for points and lines. |
| length_m | DOUBLE | yes | none | as is | Line length in metres; empty for points and polygons. |
| hit_area_m2 | DOUBLE | yes | none | as is | Area of hit_geom in m². |
| bbox_xmin | DOUBLE | yes | none | as is | West edge of hit_geom (longitude). |
| bbox_ymin | DOUBLE | yes | none | as is | South edge of hit_geom (latitude). |
| bbox_xmax | DOUBLE | yes | none | as is | East edge of hit_geom (longitude). |
| bbox_ymax | DOUBLE | yes | none | as is | North edge of hit_geom (latitude). |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| place_id | geom_version | valid_from | valid_to | geom | hit_geom | geom_kind | bounds |
|---|---|---|---|---|---|---|---|
| place/block/6305 | 1 | — | — | b'\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00;\xc8\xeb\xc1$\x9a^\xc0\x9a9\xc9\xfb\xdd\xdaB@\x8d^\rP\x1a\x9a^\xc0Yb\xaf\xc1\x0c\xd… | b'\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00;\xc8\xeb\xc1$\x9a^\xc0\x9a9\xc9\xfb\xdd\xdaB@\x8d^\rP\x1a\x9a^\xc0Yb\xaf\xc1\x0c\xd… | polygon | official |
| place/parcel/1361-018A | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x07\x00\x00\x00\xd7\xcd_\xfdl\x9d^\xc0\x98L}o\x7f\xe4B@\x00G\xd… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x07\x00\x00\x00\xd7\xcd_\xfdl\x9d^\xc0\x98L}o\x7f\xe4B@\x00G\xd… | polygon | official |
| place/parcel/3725-116 | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x08\x00\x00\x00\xfb\xec\x94\xcf\x11\x9a^\xc0\x105%\xe7\xf1\xe3B… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x08\x00\x00\x00\xfb\xec\x94\xcf\x11\x9a^\xc0\x105%\xe7\xf1\xe3B… | polygon | official |
| place/parcel/6116-033 | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x07\x00\x00\x00\xa2\xf8\xe7X\x14\x9a^\xc0X6\x01\xf3\x81\xdcB@\x… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x07\x00\x00\x00\xa2\xf8\xe7X\x14\x9a^\xc0X6\x01\xf3\x81\xdcB@\x… | polygon | official |
| place/parcel/3534-126 | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00%\x1a\x19\xee@\x9b^\xc0\x9aP\x9d\x1bN\xe2B@Z\xe4… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00%\x1a\x19\xee@\x9b^\xc0\x9aP\x9d\x1bN\xe2B@Z\xe4… | polygon | official |
| place/parcel/6779-004 | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00\xa4\xc6\x8e\n\xff\x9b^\xc0\xf2\xfb\xf7\x13g\xdd… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00\xa4\xc6\x8e\n\xff\x9b^\xc0\xf2\xfb\xf7\x13g\xdd… | polygon | official |
| place/parcel/1918-001A | 1 | — | — | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00\xbf\xc6|\xe0\xed\x9e^\xc0\xee\x1b\x04\xc2\xf3\x… | b'\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\x05\x00\x00\x00\xbf\xc6|\xe0\xed\x9e^\xc0\xee\x1b\x04\xc2\xf3\x… | polygon | official |
| place/parcel/2764-008 | 1 | — | — | b"\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\n\x00\x00\x00\x01\xf6\xc2~>\x9c^\xc0(\xb5\r_\x83\xe0B@CQ\x87\xb… | b"\x01\x06\x00\x00\x00\x01\x00\x00\x00\x01\x03\x00\x00\x00\x01\x00\x00\x00\n\x00\x00\x00\x01\xf6\xc2~>\x9c^\xc0(\xb5\r_\x83\xe0B@CQ\x87\xb… | polygon | official |
8 of 16 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | place_geometries.parquet ↗ | 137.7 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM place_geometries
LIMIT 100
Run in the SQL console (DuckDB in the browser, over the Parquet file).
Python
import duckdb
duckdb.sql("SELECT * FROM 'https://tiles.qipu.org/data/releases/v0.7.1/parquet/place_geometries.parquet' LIMIT 5").show()