Address resolution
address_resolutionrelease v0.7.1CC0 1.0
About
Raw "<number> <street>" texts seen in claims, resolved exactly to today's EAS address. Only exact, unique matches in v1.
- Where it comes from
- Street addresses written in the records, and DataSF's address points.
- How it was read
- Matched to today's address only when the text matches one address exactly; the rest are left unmatched.
- 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
- address_resolution
- Rows
- 805,748
- Columns
- 7
- Parquet
- address_resolution.parquet, 7.8 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Method and accuracy
Matched to today's address only when the text matches one address exactly; the rest are left unmatched.
| Field | Made by | How well it is known |
|---|---|---|
| address_resolution | exact text match to DataSF EAS | exact matches only, by construction; unmatched texts are not resolved. |
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 7
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| raw_text | VARCHAR | yes | free text | private people's names withheld under the embargo | A <number> <street> place text as printed in a claim. |
| year | INTEGER | yes | none | as is | Year of the claim. |
| place_id | VARCHAR | no | none | as is | Today's EAS address it matched (see places).Values e.g. qipu:sf/place/block/1 |
| precision | VARCHAR | yes | none | as is | address on every row.Values address |
| method | VARCHAR | yes | none | as is | exact on every row: number and street matched exactly one DataSF EAS address.Values exact |
| confidence | DECIMAL(2,1) | yes | none | as is | 1.0 on every row. |
| run_id | VARCHAR | no | none | as is | address-exact-v1 (see runs).Values address-exact-v1 |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| raw_text | year | place_id | precision | method | confidence | run_id |
|---|---|---|---|---|---|---|
| 1441 QUESADA AVE | 1937 | place/address/eas-372295 | address | exact | 1.0 | address-exact-v1 |
| 5 LILAC ST | 1943 | place/address/eas-439519 | address | exact | 1.0 | address-exact-v1 |
| 68 RUDDEN AVE | 1927 | place/address/eas-356616 | address | exact | 1.0 | address-exact-v1 |
| 163 COLBY ST | 1951 | place/address/eas-387187 | address | exact | 1.0 | address-exact-v1 |
| 2747 BRYANT ST | 1949 | place/address/eas-370964 | address | exact | 1.0 | address-exact-v1 |
| 1415 LAKE ST | 1943 | place/address/eas-301668 | address | exact | 1.0 | address-exact-v1 |
| 2450 38TH AVE | 1949 | place/address/eas-336966 | address | exact | 1.0 | address-exact-v1 |
| 305 17TH AVE | 1949 | place/address/eas-428754 | address | exact | 1.0 | address-exact-v1 |
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 | address_resolution.parquet ↗ | 7.8 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).