GLASS & BOTTLE LIQUORS

SAN FRANCISCO, CA 94116 · O3788f07812e2 · first seen 2026-10-08
4 sourcesoff premise · conveniencealcohol: licensed1 licence

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
GLASS & BOTTLE LIQUORS 2 other
the most common name a source states
D&S SPIRITS LLC ca-abc (legal name)
Glass and Bottles Liquors overture
Street
3150 VICENTE ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94116
ca-abcno other value
Pin
37.73834, -122.50091 map
overtureno other value
Phone
4156827708
vtinfono other value
Licences
ca-abc 00665324|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4b241a77047d; Oc738b3a3321b; Occ976520abec

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
ab-inbevGLASS & BOTTLE LIQUORS
1343164
3150 VICENTE ST, SAN FRANCISCO, CA, 9411637.73828, -122.500612026-11-112026-11-11
ca-abcGLASS & BOTTLE LIQUORS
legal name: D&S SPIRITS LLC
00665324|21|LIC|0
3150 VICENTE ST, SAN FRANCISCO, CA, 9411637.73827, -122.500612026-10-082026-11-06
overtureGlass and Bottles Liquors
9dc7d30b-bec8-4787-a552-0d08e689df2f
3150 Vicente St, San Francisco, CA, 94116415682770837.73834, -122.500912026-11-062026-11-06
vtinfoGLASS & BOTTLE LIQUORS
4174a98e7d4635d1
3150 VICENTE ST, SAN FRANCISCO, CA, 94116415682770837.73845, -122.500802026-11-122026-11-14

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
ab-inbev GLASS & BOTTLE LIQUORSca-abc GLASS & BOTTLE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
ab-inbev GLASS & BOTTLE LIQUORSvtinfo GLASS & BOTTLE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00
ca-abc GLASS & BOTTLE LIQUORSvtinfo GLASS & BOTTLE LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00
ab-inbev GLASS & BOTTLE LIQUORSoverture Glass and Bottles Liquors0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 27 m apart · name similarity 0.74
ca-abc GLASS & BOTTLE LIQUORSoverture Glass and Bottles Liquors0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 27 m apart · name similarity 0.74
overture Glass and Bottles Liquorsvtinfo GLASS & BOTTLE LIQUORS0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 16 m apart · name similarity 0.74 · phone: equal

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
D&S SPIRITS LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
62 within 1 mi · 818 within 3 mi
Off / on premise
11 / 39 within 1 mi · 137 / 550 within 3 mi
Selling alcohol
46 within 1 mi · 476 within 3 mi
Nearest
same channel 0.20 mi · licensed 0.01 mi
Setting
urban (7,478 people per sq mi)
People within 3 mi
211,425 (171,311 adults 21+, 79,877 households) from 49 tract(s), tracts within 3 mi
Income
per capita $78,560 · median household ~$151,279 (weighted mean of tract medians)
Age and education
median age ~43.4 · bachelor's or higher 59%
Ethnicity
Hispanic 13% · White 34% · Black 3% · Asian 45%
Adults per alcohol outlet
359
Alcohol spend within 3 mi
$78,816,066 a year ($33,520,456 at home, $45,270,174 away) · $165,233 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-12 14:25insertoverture 9dc7d30b-bec8-4787-a552-0d08e689df2f ↔ vtinfo 4174a98e7d4635d1same address and namemerged12
2026-11-12 14:25insertab-inbev 1343164 ↔ vtinfo 4174a98e7d4635d1same address and namemerged12
2026-11-12 14:25insertca-abc 00665324|21|LIC|0 ↔ vtinfo 4174a98e7d4635d1same address and namemerged12
2026-11-11 12:56insertab-inbev 1343164 ↔ overture 9dc7d30b-bec8-4787-a552-0d08e689df2fsame address and namemerged12
2026-11-11 12:56insertab-inbev 1343164 ↔ ca-abc 00665324|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00665324|21|LIC|0 ↔ overture 9dc7d30b-bec8-4787-a552-0d08e689df2fsame address and namemerged11