Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Datasets›place_names

Place names

place_namesrelease v0.7.1CC0 1.0

About

Names of places (official, alias). The historic names index starts here; v1 holds today's names and the search aliases.

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
place_names
Rows
2,274
Columns
6
Parquet
place_names.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by name_kind

ValueRowsShare
official2,10792.7%
alias1657.3%
former20.1%

Rows by to

ValueRowsShare
(empty)2,27199.9%
199520.1%
19911< 0.1%

Rows by source

ValueRowsShare
DataSF EAS2,10592.6%
Internet Archive full-text search alias (dl_documents)1637.2%
qipu v0.6.160.3%

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.

Methodology · Accuracy

Columns 6

ColumnTypeCan be emptyPrivacyPublic copyDescription
place_idVARCHARnononeas isThe place (see places).
Can be empty no · Privacy none · Public copy as is
nameVARCHARyesnoneas isThe name.
Can be empty yes · Privacy none · Public copy as is
name_kindVARCHARnononeas isofficial (street and neighbourhood names from DataSF EAS) or alias (a name matched in Internet Archive full-text search).
Values alias, former, official
Can be empty no · Privacy none · Public copy as is
fromVARCHARyesnoneas isEmpty in v0.4. Meant for the first year the name was in use.
Can be empty yes · Privacy none · Public copy as is
toVARCHARyesnoneas isEmpty in v0.4. Meant for the last year the name was in use.
Can be empty yes · Privacy none · Public copy as is
sourceVARCHARyesnoneas isWhere the name comes from.
Values DataSF EAS, Internet Archive full-text search alias (dl_documents), qipu v0.6.1
Can be empty yes · Privacy none · Public copy as is

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_idnamename_kindfromtosource
place/street/sunrise-waySUNRISE WAYofficial——DataSF EAS
place/street/belles-stBELLES STofficial——DataSF EAS
place/street/howard-stHOWARD STofficial——DataSF EAS
place/street/congo-stCONGO STofficial——DataSF EAS
place/street/houston-stHOUSTON STofficial——DataSF EAS
place/street/howth-stHOWTH STofficial——DataSF EAS
place/street/…naventura-waySAN BUENAVENTURA WAYofficial——DataSF EAS
place/street/belcher-stBELCHER STofficial——DataSF EAS

Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetplace_names.parquet ↗< 0.1 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM place_names 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/place_names.parquet' LIMIT 5").show()