Block points
block_pointsrelease v0.7.1CC0 1.0
About
One point per assessor block (the map's block index), for fast lookups.
- 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
- block_points
- Rows
- 5,102
- Columns
- 4
- Parquet
- block_points.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
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 4
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| block | VARCHAR | yes | none | as is | assessor block number |
| lat | DOUBLE | yes | none | as is | a point inside the block |
| lon | DOUBLE | yes | none | as is | a point inside the block |
| hood_id | VARCHAR | yes | none | as is | the neighbourhood place id |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| block | lat | lon | hood_id |
|---|---|---|---|
| qipu:sf/place/block/2040 | 37.755668 | -122.466228 | place/hood/inner-sunset |
| qipu:sf/place/block/7521 | 37.743914 | -122.439661 | place/hood/glen-park |
| qipu:sf/place/block/7119 | 37.713533 | -122.466637 | place/hood/oc…ced-ingleside |
| qipu:sf/place/block/6022 | 37.722214 | -122.427458 | place/hood/excelsior |
| qipu:sf/place/block/0933 | 37.79909 | -122.446671 | place/hood/marina |
| qipu:sf/place/block/0159 | 37.796803 | -122.410871 | place/hood/chinatown |
| qipu:sf/place/block/6049 | 37.725662 | -122.403291 | place/hood/portola |
| qipu:sf/place/block/7255 | 37.733085 | -122.49033 | place/hood/sunset-parkside |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | block_points.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM block_points
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/block_points.parquet' LIMIT 5").show()