Assessor real-property directory
x_realprop_dirrelease v0.7.1CC0 1.0
About
Extraction table: the Andrews Real Property Directory of San Francisco, 1943 and 1949 editions (archive.org scans), one row per printed address line: street, number, assessor block and lot, and the owners as printed (read by claude-sonnet-5-5 from page tiles; source-review run). The owners are shown: the editions are more than 75 years old (the privacy rule withholds names only for records under 75 years).
- Where it comes from
- The Andrews Real Property Directory of San Francisco, 1943 and 1949 editions, scanned on the Internet Archive.
- How it was read
- Read line by line by a language model (Claude Sonnet) from images of the pages.
- 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_realprop_dir
- Rows
- 276,599
- Columns
- 13
- Parquet
- x_realprop_dir.parquet, 4.0 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by tile
Method and accuracy
Read line by line by a language model (Claude Sonnet) from images of the pages.
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 13
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| run_id | VARCHAR | no | none | as is | The run that read the pages (see runs).Values andrews-sonnet55-2026-10 |
| page_id | VARCHAR | no | none | as is | The page: <archive.org identifier>:<leaf>.Values e.g. andrewsrealprope1943andr:1 |
| tile | VARCHAR | yes | none | as is | Which quarter of the page image the line was read from (x0y0 top left ...).Values x0y0, x0y1, x1y0, x1y1 |
| seq | VARCHAR | yes | none | as is | The line inside its tile (<tile>/<n>). |
| street_header | VARCHAR | yes | none | as is | The street heading the line is printed under. |
| addr_number | VARCHAR | yes | none | as is | The house number as printed. |
| block | VARCHAR | yes | none | as is | The assessor block as printed. |
| lot | VARCHAR | yes | none | as is | The assessor lot as printed. |
| owners | VARCHAR | yes | a person's name | officials and organisations shown; private people withheld under the embargo | The owners as printed (Curtis, Emma R). Shown for these editions (over 75 years old); a row without a year would be withheld. |
| edition | BIGINT | yes | none | as is | The edition of the directory. Values 1850..2030 |
| year | BIGINT | yes | none | as is | The year the directory states (its edition year). Values 1850..2030 |
| row_key | VARCHAR | no | none | as is | <run_id>/<page_id>/<seq>. |
| page_url | VARCHAR | yes | none | as is | Opens the page on archive.org. Values e.g. https://archive.org/details/andrewsrealprope1943andr/page/n1 |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| run_id | page_id | tile | seq | street_header | addr_number | block | lot |
|---|---|---|---|---|---|---|---|
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:74 | x1y0 | x1y0/28 | Broadway | 2960 | 957 | 6 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:77 | x1y0 | x1y0/33 | Broderick | 1129-31 | qipu:sf/place/block/1125 | 5 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:131 | x0y0 | x0y0/5 | Church | 1080-82 | qipu:sf/place/block/3628 | 12 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:151 | x1y0 | x1y0/24 | Connecticut | 263 | qipu:sf/place/block/4004 | 21 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:186 | x0y1 | x0y1/13 | Douglass | 63-67 | qipu:sf/place/block/2623 | 37 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:205 | x0y0 | x0y0/14 | Elsie Street | V | qipu:sf/place/block/5619 | 53 |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:221 | x0y0 | x0y0/16 | Filbert Street | 2154-62 | 516 | 16,16a |
| andrews-sonnet55-2026-10 | andrewsrealprope1943andr:237 | x1y1 | x1y1/35 | Francis | 88 | qipu:sf/place/block/6797 | 23 |
8 of 13 columns shown. Eight rows sampled at build time, from the years up to 1951. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | x_realprop_dir.parquet ↗ | 4.0 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).