SAN FRANCISCO WINE TRADING COMPANY

SAN FRANCISCO, CA 94116 · O1a351e6e93a8 · first seen 2026-10-08
3 sourcesoff premise · liquor_storealcohol: 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
SAN FRANCISCO WINE TRADING COMPANY 2 other
the most common name a source states
J.J. BUCKLEY LLC ca-abc (legal name) ×2
The San Francisco Wine Trading Company overture
Street
250 TARAVAL 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.74342, -122.46902 map
overtureno other value
Phone
4157316222
vtinfono other value
Licences
ca-abc 00629686|21|LIC|0 · ca-abc 00629686|42|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O89e8c2538e7f; O694cc6d48331; O21f943426f21; O8a60447b9311

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-abcSAN FRANCISCO WINE TRADING COMPANY
legal name: J.J. BUCKLEY LLC
00629686|21|LIC|0
250 TARAVAL ST, SAN FRANCISCO, CA, 9411637.74342, -122.468632026-10-082026-11-09
ca-abcSAN FRANCISCO WINE TRADING COMPANY
legal name: J.J. BUCKLEY LLC
00629686|42|LIC|0
250 TARAVAL ST, SAN FRANCISCO, CA, 9411637.74342, -122.468632026-10-082026-11-09
overtureThe San Francisco Wine Trading Company
b326ceaa-83f3-41a3-adbb-1028a8e97686
250 Taraval St, San Francisco, CA, 94116415731622237.74342, -122.469022026-11-062026-11-06
vtinfoSAN FRANCISCO WINE TRADING COMPANY
e22ac2f0a21e88de
250 TARAVAL ST, SAN FRANCISCO, CA, 94116415731622237.74360, -122.469012026-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
ca-abc SAN FRANCISCO WINE TRADING COMPANYca-abc SAN FRANCISCO WINE TRADING COMPANY1.00one licence filemergedfile: 00629686 · same_address
ca-abc SAN FRANCISCO WINE TRADING COMPANYoverture The San Francisco Wine Trading Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ca-abc SAN FRANCISCO WINE TRADING COMPANYoverture d01afbd2-2ccf-4e54-a3e3-21aa0ae63fa01.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 804 m apart · name similarity 1.00
ca-abc SAN FRANCISCO WINE TRADING COMPANYvtinfo SAN FRANCISCO WINE TRADING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
ca-abc SAN FRANCISCO WINE TRADING COMPANYoverture The San Francisco Wine Trading Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ca-abc SAN FRANCISCO WINE TRADING COMPANYoverture d01afbd2-2ccf-4e54-a3e3-21aa0ae63fa01.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 804 m apart · name similarity 1.00
ca-abc SAN FRANCISCO WINE TRADING COMPANYvtinfo SAN FRANCISCO WINE TRADING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
overture The San Francisco Wine Trading Companyvtinfo SAN FRANCISCO WINE TRADING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
J.J. BUCKLEY LLC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_off — CA 21; CA 42
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
183 within 1 mi · 2,535 within 3 mi
Off / on premise
24 / 125 within 1 mi · 448 / 1,679 within 3 mi
Selling alcohol
112 within 1 mi · 1,677 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (15,937 people per sq mi)
People within 3 mi
450,604 (371,814 adults 21+, 179,503 households) from 112 tract(s), tracts within 3 mi
Income
per capita $90,015 · median household ~$163,126 (weighted mean of tract medians)
Age and education
median age ~42.0 · bachelor's or higher 62%
Ethnicity
Hispanic 16% · White 40% · Black 3% · Asian 37%
Adults per alcohol outlet
222
Alcohol spend within 3 mi
$183,325,869 a year ($77,473,608 at home, $105,798,714 away) · $109,253 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:25insertca-abc 00629686|21|LIC|0 ↔ vtinfo e22ac2f0a21e88desame address and namemerged12
2026-11-12 14:25insertca-abc 00629686|42|LIC|0 ↔ vtinfo e22ac2f0a21e88desame address and namemerged12
2026-11-12 14:25insertoverture b326ceaa-83f3-41a3-adbb-1028a8e97686 ↔ vtinfo e22ac2f0a21e88desame address and namemerged12
2026-11-09 15:32updateca-abc 00629686|21|LIC|0 ↔ overture b326ceaa-83f3-41a3-adbb-1028a8e97686same address and namemerged11
2026-11-09 15:32updateca-abc 00629686|42|LIC|0 ↔ overture b326ceaa-83f3-41a3-adbb-1028a8e97686same address and namemerged11
2026-11-06 18:13insertca-abc 00629686|21|LIC|0 ↔ overture b326ceaa-83f3-41a3-adbb-1028a8e97686same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00629686|21|LIC|0 ↔ overture d01afbd2-2ccf-4e54-a3e3-21aa0ae63fa0same address and namemerged11
2026-11-06 18:13insertca-abc 00629686|42|LIC|0 ↔ overture b326ceaa-83f3-41a3-adbb-1028a8e97686same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00629686|42|LIC|0 ↔ overture d01afbd2-2ccf-4e54-a3e3-21aa0ae63fa0same address and namemerged11
2026-10-09 13:59backfillca-abc 00629686|21|LIC|0 ↔ ca-abc 00629686|42|LIC|0one licence filemerged