The Orchard Hotel

SAN FRANCISCO, CA 94108 · O62618d807ab1 · first seen 2026-10-08
2 sourceson premise · restaurantalcohol: licensed2 licences

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
The Orchard Hotel 2 other
a source's own spelling of the licence name (record_title.py)
665 BUSH STREET INC ca-abc (legal name) ×2
ORCHARD HOTEL THE ca-abc ×2
Street
665 BUSH ST 1 other
ca-abc
665 Bush St #1 overture
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94108
ca-abcno other value
Pin
37.79011, -122.40847 map
overtureno other value
Phone
4153650307
overtureno other value
Licences
ca-abc 00365674|47|LIC|0 · ca-abc 00365674|66|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe611e82bc3ca; Oec71ada4874d

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ca-abcORCHARD HOTEL THE
legal name: 665 BUSH STREET INC
00365674|47|LIC|0
665 BUSH ST, SAN FRANCISCO, CA, 9410837.79016, -122.408292026-10-082026-11-05
ca-abcORCHARD HOTEL THE
legal name: 665 BUSH STREET INC
00365674|66|LIC|0
665 BUSH ST, SAN FRANCISCO, CA, 9410837.79016, -122.408292026-10-082026-11-05
overtureThe Orchard Hotel
ef514cea-2e38-4697-a2c7-0dc34fab247c
665 Bush St #1, San Francisco, CA, 94108415365030737.79011, -122.408472026-11-062026-11-06

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ca-abc ORCHARD HOTEL THEca-abc ORCHARD HOTEL THE1.00one licence filemergedfile: 00365674 · same_address
ca-abc ORCHARD HOTEL THEoverture The Orchard Hotel1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc ORCHARD HOTEL THEoverture The Orchard Hotel1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
665 BUSH STREET INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 66
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,599 within 1 mi · 5,462 within 3 mi
Off / on premise
260 / 1,631 within 1 mi · 721 / 3,423 within 3 mi
Selling alcohol
1,467 within 1 mi · 3,414 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (14,216 people per sq mi)
People within 3 mi
401,950 (353,366 adults 21+, 205,372 households) from 135 tract(s), tracts within 3 mi
Income
per capita $107,648 · median household ~$149,523 (weighted mean of tract medians)
Age and education
median age ~39.3 · bachelor's or higher 66%
Ethnicity
Hispanic 16% · White 46% · Black 5% · Asian 28%
Adults per alcohol outlet
103
Alcohol spend within 3 mi
$193,160,398 a year ($82,217,248 at home, $110,882,919 away) · $56,562 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-06 18:13insertca-abc 00365674|66|LIC|0 ↔ overture ef514cea-2e38-4697-a2c7-0dc34fab247csame address and namemerged11
2026-11-06 18:13insertca-abc 00365674|47|LIC|0 ↔ overture ef514cea-2e38-4697-a2c7-0dc34fab247csame address and namemerged11
2026-10-09 13:59backfillca-abc 00365674|47|LIC|0 ↔ ca-abc 00365674|66|LIC|0one licence filemerged