Map decision rows
x_site_rowsrelease v0.7.1CC0 1.0
About
The map's decision rows (citywide decades, street layer) with the item they come from (linked_item).
- 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_site_rows
- Rows
- 62,917
- Columns
- 15
- Parquet
- x_site_rows.parquet, 3.5 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by outcome
| Value | Rows | Share | |
|---|---|---|---|
| passed | 60,879 | 96.8% | |
| rejected | 1,148 | 1.8% | |
| refused | 814 | 1.3% | |
| vetoed | 68 | 0.1% | |
| approved by voters | 7 | < 0.1% | |
| rejected by voters | 1 | < 0.1% |
Rows by topic
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 15
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| site_id | VARCHAR | no | none | as is | The map's row id: su:<hash of the item id> for Board items, sd:... for others. |
| decision_id | VARCHAR | no | none | as is | The decision the row shows (see decisions). |
| linked_item | VARCHAR | yes | none | as is | The Board item (<volume>|<n>) the row was matched to; empty when none. |
| origins | VARCHAR[] | yes | none | as is | The map files the row appears in (street_decisions/sd, citywide/decade-1970-routine.json, ...). |
| plain | VARCHAR | yes | free text | private people's names withheld under the embargo | The map's one-line summary, written by a model (claude-haiku-5-5), after accuracy fixes. Person-like names are withheld for records under the 75-year privacy filter (92 years in Vancouver). |
| year | BIGINT | yes | none | as is | Year of the decision. |
| date | VARCHAR | yes | none | as is | Date of the decision (YYYY-MM-DD) where known. |
| outcome | VARCHAR | yes | none | as is | passed, rejected, refused, vetoed, ... as on the map.Values approved by voters, passed, refused, rejected, rejected by voters, vetoed |
| topic | VARCHAR | yes | none | as is | Topic as on the map (admin, budget, property, housing, ...).Values admin, appeals, budget, elections, health, housing, landmarks, names, other, permits, property, redevelopment ... |
| place | VARCHAR | yes | free text | private people's names withheld under the embargo | The place as written on the map. Person-like names are withheld for records under the 75-year privacy filter (92 years in Vancouver). |
| src | VARCHAR | yes | none | as is | Source link as the map gives it. |
| src_mapped | VARCHAR | yes | none | as is | Source link pointed at the item's exact archive.org page with the leaf map where the item is known; else src. |
| blocks | VARCHAR[] | yes | none | as is | Assessor blocks the map files the row under. |
| streets | VARCHAR[] | yes | none | as is | Streets the map files the row under (NAME|TYPE). |
| hoods | VARCHAR[] | yes | none | as is | Neighbourhoods the map files the row under. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| site_id | decision_id | linked_item | origins | plain | year | date | outcome |
|---|---|---|---|---|---|---|---|
| sp:b8ce953767 | decision/sp:b8ce953767 | — | ['street_decisions/sd'] | J. T. Pigott allowed an oil tank (750 gallons) at 3343 Was… | 1927 | 1927-10-10 | passed |
| sp:e126dfe21e | decision/sp:e126dfe21e | — | ['street_decisions/sd'] | Charles F. Thierbach allowed an oil storage tank (1500 gal… | 1917 | 1917-03-12 | passed |
| sq:c52580cf96 | decision/sq:c52580cf96 | — | ['street_decisions/sd'] | Outfall sewer ordered at Great Highway and Vicente Street | 1924 | 1924-12-15 | passed |
| sp:e347100749 | decision/sp:e347100749 | — | ['street_decisions/sd'] | Chas. A. Johnson allowed an oil tank (1500 gallons) at the… | 1925 | 1925-04-06 | passed |
| sp:9f6a90ac82 | decision/sp:9f6a90ac82 | — | ['street_decisions/sd'] | Helbing Co allowed an oil storage tank (1500 gallons) at 3… | 1926 | 1926-07-19 | passed |
| sq:dd223ac38b | decision/sq:dd223ac38b | — | ['street_decisions/sd'] | Official map of part of Mission District between Valencia … | 1914 | 1914-08-31 | passed |
| sp:42a5ab5726 | decision/sp:42a5ab5726 | — | ['street_decisions/sd'] | Hastings Estate allowed oil tanks (1500 gallons) at 321 Sa… | 1930 | 1930-05-19 | passed |
| sq:7e1fb94167 | decision/sq:7e1fb94167 | — | ['street_decisions/sd'] | Garage permit for Peters & Company at 955 Post Street | 1928 | 1928-11-05 | passed |
8 of 15 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_site_rows.parquet ↗ | 3.5 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM x_site_rows
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/x_site_rows.parquet' LIMIT 5").show()