Blocks and census tracts
x_block_tractrelease v0.7.1CC0 1.0
About
One assessor block in one tract map: the tract holding most of the block's EAS address points. Not from the Internet Archive (DataSF EAS address points and Census tract maps).
- 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
- x_block_tract
- Rows
- 20,389
- Columns
- 5
- Parquet
- x_block_tract.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 5
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| block | VARCHAR | yes | none | as is | Assessor block. |
| boundary_vintage | INTEGER | yes | none | as is | Tract map year (1990, 2000, 2010, 2020). |
| tract | VARCHAR | yes | none | as is | Six-digit tract code. |
| share_of_address_points | DOUBLE | yes | none | as is | Share of the block's address points inside that tract (below 0.8: the block straddles tracts). |
| address_points | INTEGER | yes | none | as is | Number of address points used. |
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 | boundary_vintage | tract | share_of_address_points | address_points |
|---|---|---|---|---|
| qipu:sf/place/block/7310 | 2,020 | 033204 | 1.0 | 68 |
| qipu:sf/place/block/3778 | 2,020 | 018000 | 1.0 | 47 |
| qipu:sf/place/block/0838 | 2,020 | 016802 | 1.0 | 60 |
| qipu:sf/place/block/2690 | 1,990 | 020400 | 1.0 | 60 |
| qipu:sf/place/block/2833 | 1,990 | 030500 | 1.0 | 18 |
| qipu:sf/place/block/5696 | 2,020 | 025100 | 1.0 | 11 |
| qipu:sf/place/block/6594 | 2,000 | 021500 | 1.0 | 91 |
| qipu:sf/place/block/7560 | 1,990 | 021700 | 0.5 | 2 |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | x_block_tract.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).