Places
placesrelease v0.7.1CC0 1.0
About
Today's places with stable qipu ids.
- Where it comes from
- Today's city records: DataSF's address points (Enterprise Addressing System), assessor parcels and blocks, streets and neighbourhoods; Wikidata for named features. source names it on every row.
- How it was read
- Copied from those records and given stable qipu ids. Named features drawn as a circle around a point say so in geometry_note.
- 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
- places
- Rows
- 470,596 (San Francisco 470,595; Vancouver 1)
- Columns
- 29
- Parquet
- places.parquet, 19.9 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by kind
| Value | Rows | Share | |
|---|---|---|---|
| parcel | 233,334 | 49.6% | |
| address | 224,390 | 47.7% | |
| block | 5,409 | 1.1% | |
| street_name | 3,523 | 0.7% | |
| street | 2,064 | 0.4% | |
| census_tract | 778 | 0.2% | |
| park | 365 | 0.1% | |
| zoning_district | 269 | 0.1% | |
| landmark | 250 | 0.1% | |
| campus | 152 | < 0.1% | |
| neighbourhood | 41 | < 0.1% | |
| cemetery | 9 | < 0.1% |
Rows by geometry_note
| Value | Rows | Share | |
|---|---|---|---|
| (empty) | 470,587 | 100.0% | |
| approximate: a circle around the feature point, not the real boundary | 5 | < 0.1% | |
| approximate: Wikidata point + radius | 4 | < 0.1% |
Rows by type_id
| Value | Rows | Share | |
|---|---|---|---|
| parcel | 233,334 | 49.6% | |
| address | 224,390 | 47.7% | |
| assessor_block | 5,409 | 1.1% | |
| street_name | 3,523 | 0.7% | |
| street | 2,064 | 0.4% | |
| census_tract | 778 | 0.2% | |
| park | 365 | 0.1% | |
| zoning_district | 269 | 0.1% | |
| landmark | 250 | 0.1% | |
| campus | 152 | < 0.1% | |
| neighbourhood | 41 | < 0.1% | |
| cemetery | 9 | < 0.1% |
Method and accuracy
Copied from those records and given stable qipu ids. Named features drawn as a circle around a point say so in geometry_note.
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 29
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| place_id | VARCHAR | no | none | as is | qipu:sf/place/address/eas-<EAS id>, .../parcel/<block>-<lot>, .../block/<block>, .../street/<name-type>, .../street/<name> (printed without type, street_name), .../hood/<slug>, .../landmark/<slug>, .../city.Values e.g. qipu:sf/place/block/1 |
| kind | VARCHAR | no | none | as is | address, parcel, block, street, street_name, neighbourhood, landmark, city. Values address, block, burn_zone, city, contaminated_site, creek, fill_area, freeway, landmark, neighbourhood, parcel, redevelopment_area ... |
| name | VARCHAR | yes | none | as is | Readable name: the address (26 REARDON RD), <block>/<lot> (<addresses>), Assessor block <n>, the street, neighbourhood or feature name. |
| parent_id | VARCHAR | yes | none | as is | address -> parcel -> block -> neighbourhood -> city. |
| apn | VARCHAR | yes | none | as is | Assessor block + lot. |
| eas_id | VARCHAR | yes | none | as is | DataSF Enterprise Addressing System base id. |
| cnn | VARCHAR | yes | none | as is | Empty in v1. |
| wikidata | VARCHAR | yes | none | as is | Wikidata id, for named features. Values Q1348537, Q211386, Q24639, Q4049033, Q6081595, Q62, Q6878535, Q719317, Q757971, Q7987437 |
| lat | DOUBLE | yes | none | as is | Latitude: the EAS point for addresses, the mean of address points for parcels, blocks and streets, the Wikidata point for features. Values degrees (WGS 84); 36.0..50.0 |
| lon | DOUBLE | yes | none | as is | Longitude: the EAS point for addresses, the mean of address points for parcels, blocks and streets, the Wikidata point for features. Values degrees (WGS 84); SF-owned land reaches the Sierra (Hetch Hetchy, Camp Mather); -125.0..-119.0 |
| number | BIGINT | yes | none | as is | House number (addresses). |
| street | VARCHAR | yes | none | as is | Street name and type, upper case (MISSION ST). |
| street_id | VARCHAR | yes | none | as is | The street place (qipu:sf/place/street/<name-type>). |
| block | VARCHAR | yes | none | as is | Assessor block. |
| lot | VARCHAR | yes | none | as is | Assessor lot. |
| hood | VARCHAR | yes | none | as is | DataSF Analysis Neighborhood (point in polygon). |
| valid_from | DATE | yes | none | as is | Empty in v1 (the historic place index comes later). |
| valid_to | DATE | yes | none | as is | Last day the place existed; only the 1906 burn zone has one. |
| source | VARCHAR | yes | none | as is | Where the place comes from (DataSF Enterprise Addressing System (3mea-di5p), PDDL, DataSF parcels, Wikidata, ...).Values DataSF Analysis Neighborhoods (j2bu-swwd), DataSF EAS (3mea-di5p), PDDL, DataSF EAS parcel numbers (3mea-di5p), PDDL, DataSF Enterprise Addressing System (3mea-di5p), PDDL, DataSF ff3a-iqhv (1906 Fire perimeter), DataSF parcels, DataSF parcels: zoning_code, Wikidata (point, dates); radius set by qipu, Wikidata Q4049033 (point, dates); radius set by qipu, Wikidata Q6081595 (point, dates); radius set by qipu, Wikidata Q6878535 (point, dates); radius set by qipu, Wikidata Q757971 (point, dates); radius set by qipu ... |
| radius_m | DOUBLE | yes | none | as is | Radius in metres of the circle qipu draws around a feature's Wikidata point. |
| gnis | VARCHAR | yes | none | as is | USGS GNIS feature id. Values 254827 |
| geometry_note | VARCHAR | yes | none | as is | Says when the geometry is approximate (a circle around a Wikidata point). Values approximate: Wikidata point + radius, approximate: a circle around the feature point, not the real boundary |
| type_id | VARCHAR | no | none | as is | Place type (see place_types): parcel, address, assessor_block, street, street_name, zoning_district, landmark, ...Values address, assessor_block, burn_zone, city, contaminated_site, creek, fill_area, freeway, landmark, neighbourhood, parcel, redevelopment_area ... |
| city | VARCHAR | no | none | as is | sf or van.Values sf, van |
| specificity | DOUBLE | yes | none | as is | -log10 of the clickable footprint in m² (place_geometries.hit_area_m2); higher = smaller, ranked first by places_at. |
| rep_lat | DOUBLE | yes | none | as is | Latitude of a point on the place's geometry (point on surface). Values degrees (WGS 84); 36.0..50.0 |
| rep_lon | DOUBLE | yes | none | as is | Longitude of a point on the place's geometry (point on surface). Values degrees (WGS 84); SF-owned land reaches the Sierra (Hetch Hetchy, Camp Mather); -125.0..-119.0 |
| status | VARCHAR | yes | none | as is | current, or historic when valid_to is set.Values current, historic |
| area_m2 | DOUBLE | yes | none | as is | Polygon area in m²; empty for points and lines. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| place_id | kind | name | parent_id | apn | eas_id | cnn | wikidata |
|---|---|---|---|---|---|---|---|
| place/address/eas-313042 | address | 859 26TH AVE | place/parcel/1669-015 | 1669015 | 313042 | — | — |
| place/address/eas-334228 | address | 2275 26TH AVE | place/parcel/2323-011 | 2323011 | 334228 | — | — |
| place/address/eas-338901 | address | 2547 32ND AVE | place/parcel/2433-010 | 2433010 | 338901 | — | — |
| place/address/eas-340178 | address | 2666 35TH AVE | place/parcel/2462A-017 | 2462A017 | 340178 | — | — |
| place/address/eas-466290 | address | 561 42ND AVE | place/parcel/1502-005E | 1502005E | 466290 | — | — |
| place/address/eas-309872 | address | 789 45TH AVE | place/parcel/1599-013A | 1599013A | 309872 | — | — |
| place/address/eas-328310 | address | 1827 47TH AVE | place/parcel/2084-005 | 2084005 | 328310 | — | — |
| place/address/eas-408083 | address | 1261 ALEMANY BLVD | place/parcel/6801-030 | 6801030 | 408083 | — | — |
8 of 29 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | places.parquet ↗ | 19.9 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM places
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/places.parquet' LIMIT 5").show()