Place relations
place_relationsrelease v0.7.1CC0 1.0
About
How places relate, computed from geometry each build (plus declared links): an address within a block, a block within a neighbourhood, a street crosses a creek ...
- 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_relations
- Rows
- 1,284,690
- Columns
- 9
- Parquet
- place_relations.parquet, 5.3 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by relation
Rows by basis
Rows by note
| Value | Rows | Share | |
|---|---|---|---|
| point in polygon | 615,002 | 47.9% | |
| DataSF parcels zoning_code (today) | 226,906 | 17.7% | |
| DataSF EAS street | 224,390 | 17.5% | |
| DataSF EAS parcel number | 212,918 | 16.6% | |
| street line intersects the area | 4,504 | 0.4% | |
| area vs area | 934 | 0.1% | |
| block point within 150 m of the feature circle (approximate) | 21 | < 0.1% | |
| by definition (the feature drains / encloses it) | 6 | < 0.1% | |
| block point inside the feature circle (approximate) | 5 | < 0.1% | |
| configured street of the feature | 2 | < 0.1% | |
| renamed Cesar Chavez Street in 1995 | 2 | < 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 9
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| from_id | VARCHAR | no | none | as is | place ids Values e.g. qipu:sf/place/block/1 |
| relation | VARCHAR | no | none | as is | within, overlaps, crosses, on_street ...Values contains, within, overlaps, touches, crosses, near, on_street, segment_of, at_intersection_of, part_of, replaced_by, split_into ... |
| to_id | VARCHAR | no | none | as is | place ids Values e.g. qipu:sf/place/block/1 |
| basis | VARCHAR | yes | none | as is | geometry or declaredValues declared, geometry |
| valid_from | DATE | yes | none | as is | when the relation holds (historic places) |
| valid_to | DATE | yes | none | as is | when the relation holds (historic places) |
| overlap_ratio | DOUBLE | yes | none | as is | the geometric measure behind it |
| distance_m | DOUBLE | yes | none | as is | the geometric measure behind it |
| note | VARCHAR | yes | none | as is | how it was computed Values DataSF EAS parcel number, DataSF EAS street, DataSF parcels zoning_code (today), area vs area, by definition (the feature drains / encloses it), configured street of the feature, point in polygon, street line intersects the area, renamed Cesar Chavez Street in 1995, block point inside the feature circle (approximate), block point within 150 m of the feature circle (approximate) |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| from_id | relation | to_id | basis | valid_from | valid_to | overlap_ratio | distance_m |
|---|---|---|---|---|---|---|---|
| place/address/eas-499367 | within | place/hood/sunset-parkside | geometry | — | — | — | — |
| place/address/eas-431360 | within | place/hood/outer-richmond | geometry | — | — | — | — |
| place/address/eas-473005 | within | place/hood/we…of-twin-peaks | geometry | — | — | — | — |
| place/address/eas-475594 | within | place/hood/potrero-hill | geometry | — | — | — | — |
| place/address/eas-433465 | within | place/superfu…oint-shipyard | geometry | 1870-01-01 | — | — | — |
| place/address/eas-302279 | within | place/hood/seacliff | geometry | — | — | — | — |
| place/address/eas-325256 | within | place/hood/sunset-parkside | geometry | — | — | — | — |
| place/address/eas-494978 | within | place/hood/sunset-parkside | geometry | — | — | — | — |
8 of 9 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | place_relations.parquet ↗ | 5.3 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM place_relations
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_relations.parquet' LIMIT 5").show()