Unwined

SAN FRANCISCO, CA 94127 · O363f4ca9958f · first seen 2026-10-08
6 sourcesoff premisealcohol: 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
Unwined 3 other
a source's own spelling of the licence name (record_title.py)
WEST PORTAL LLC ca-abc ×2
Unwine'd SF ubereats
unwine'd sf san francisco doordash
Street
9 W PORTAL AVE 1 other
ca-abc
9 West Portal Avenue doordashubereats ×2
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94127
ca-abcno other value
Pin
37.74068, -122.46578 map 1 other
ubereats
69 m away ab-inbev
Phone
4157026202
vtinfono other value
Licences
ca-abc 00633797|20|LIC|0 · ca-abc 00633797|42|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O49b138dcffb5; O929e3c18ec3b; O69f326828232; Oed63a6ef0587; Oaacdba04a3e7; O3a8197e06d53

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-inbevUNWINED
4536231
9 W PORTAL AVE, SAN FRANCISCO, CA, 9412737.74023, -122.466322026-11-132026-11-13
ca-abcWEST PORTAL LLC
00633797|20|LIC|0
9 W PORTAL AVE, SAN FRANCISCO, CA, 9412737.74070, -122.465852026-10-082026-11-16
ca-abcWEST PORTAL LLC
00633797|42|LIC|0
9 W PORTAL AVE, SAN FRANCISCO, CA, 9412737.74070, -122.465852026-10-082026-11-16
doordashunwine'd sf san francisco
24741483
9 West Portal Avenue, San Francisco, CA, 9412737.74066, -122.465762026-10-082026-11-16
overtureUnwined
ad305db2-8c16-4a86-8cf5-7f1249810a60
9 W Portal Ave, San Francisco, CA, 94127415702620237.74064, -122.465872026-11-132026-11-13
ubereatsUnwine'd SF
ie5xwDKBW8aO8sjRDNLOWA
9 West Portal Avenue, San Francisco, CA, 9412737.74068, -122.465782026-10-142026-11-16
vtinfoUNWINED
44e1751e87e794c9
9 W PORTAL AVE, SAN FRANCISCO, CA, 94127415702620237.74068, -122.465782026-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 UNWINEDoverture Unwined1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 60 m apart · name similarity 1.00
ab-inbev UNWINEDvtinfo UNWINED1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 69 m apart · name similarity 1.00
ca-abc WEST PORTAL LLCca-abc WEST PORTAL LLC1.00one licence filemergedfile: 00633797 · same_address
doordash unwine'd sf san franciscoubereats Unwine'd SF1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
overture Unwinedvtinfo UNWINED1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal
ab-inbev UNWINEDdoordash unwine'd sf san francisco0.66one name contains the other, same addressmergedjudge: None · pair_id: 566f19ba44a9cb5fa94d · person: None · rule: names contained at one address · stratum: near
ab-inbev UNWINEDubereats Unwine'd SF0.66one name contains the other, same addressmergedjudge: None · pair_id: a86fb4356aa4b06e2c28 · person: None · rule: names contained at one address · stratum: near
doordash unwine'd sf san franciscovtinfo UNWINED0.66one name contains the other, same addressmergedjudge: None · pair_id: c96f532d97b0122aeb82 · person: None · rule: names contained at one address · stratum: near
ubereats Unwine'd SFvtinfo UNWINED0.66one name contains the other, same addressmergedjudge: None · pair_id: b211cc2034e073a63b7e · person: None · rule: names contained at one address · stratum: near
ca-abc WEST PORTAL LLCdoordash unwine'd sf san francisco0.14Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Same street address; the licensee holds both off-sale beer and wine and wine-bar public-premises licences, which fits a wine shop and bar such as Unwine'd, and no other name competes for the premises
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 70% confident — Wine bar/store licence matches unwine'd at same address.
  • Claude Haiku 5.5, prompt v9: unsure, 55% confident — The street address and coordinates match exactly, and A's off-sale store plus bar licences fit a wine shop like unwine'd, but A is filed only under the legal name 'West Portal LLC' with no shared name, and the building holds two businesses, so the names must agree for SAME.
  • Claude Haiku 5.5, prompt v7: unsure, 50% confident — The street address, ZIP and coordinates match, but the building is shared by two differently named businesses and the names don't agree: the ABC record is the legal entity WEST PORTAL LLC, while DoorDash lists 'unwine'd sf', so nothing proves they are the same operation.
  • Claude Haiku 5.5, prompt v4: different, 60% confident — The two records share the street address and ZIP, but the building holds two businesses and the names do not agree: the ABC record is the legal entity WEST PORTAL LLC, while the DoorDash listing is 'unwine'd sf', so the address match alone does not establish the same outlet.
pair 47cd6904c8b83ab8b2e9
ca-abc WEST PORTAL LLCubereats Unwine'd SF0.14Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
The records share the same street address and ZIP. 'WEST PORTAL LLC' is a legal entity name, and its off-sale plus on-sale beer-and-wine licences fit a wine shop and bar like Unwine'd, which points to
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 70% confident — Both records sit at the same street address and ZIP with coordinates about 7 m apart, and the ABC record shows an off-sale wine store plus an on-sale bar, which fits a wine retailer like Unwine'd; the names differ, but the ABC name is a legal entity that may lack a trade name, and no suite numbers conflict.
pair 8b05bce8863eaa894c91
ca-abc WEST PORTAL LLCdoordash unwine'd sf san francisco0.14Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records sit at 9 West Portal Ave, 94127, and the licensee holds off-sale plus beer-and-wine bar licences, which fits a wine shop and bar like Unwine'd; 'WEST PORTAL LLC' reads as that business's
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 70% confident — Same address; wine bar/shop licences fit Unwine'd; LLC named for location
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records sit at 9 West Portal Ave (about 9 m apart), and the ABC record shows a wine-store licence plus a bar licence under the legal entity WEST PORTAL LLC, which could operate unwine'd. But the names do not agree and the address is shared by two businesses, so the records alone cannot confirm one operation.
  • Claude Haiku 5.5, prompt v7: unsure, 50% confident — The address and coordinates match exactly, and the ABC premises holds an off-sale wine store licence that fits a DoorDash wine shop, but the ABC name is only the legal entity WEST PORTAL LLC, the building holds two businesses, and nothing links 'unwine'd sf' to that entity by name.
  • Claude Haiku 5.5, prompt v4: different, 60% confident — Both records give the same street address and ZIP, but the building holds two businesses and the names do not agree: the ABC licensee is WEST PORTAL LLC, while the DoorDash store is 'unwine'd sf', with no shared name evidence to link them.
  • Claude Opus 5.5, prompt v3: same, 68% confident — The addresses match exactly (9 West Portal Ave, 94127), and A is a bare legal-entity licence ('WEST PORTAL LLC', no DBA filed) that plausibly holds the wine shop trading as unwine'd sf. The two differently named businesses counted at the address may simply be these two records.
pair 49534df5c49a9be9fcd8

Attributes

Channel
off_premise — ca-licence conflicting evidence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
WEST PORTAL LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 20; CA 42
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
154 within 1 mi · 2,555 within 3 mi
Off / on premise
26 / 101 within 1 mi · 454 / 1,686 within 3 mi
Selling alcohol
97 within 1 mi · 1,681 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (16,023 people per sq mi)
People within 3 mi
453,039 (373,270 adults 21+, 177,830 households) from 112 tract(s), tracts within 3 mi
Income
per capita $87,281 · median household ~$161,652 (weighted mean of tract medians)
Age and education
median age ~41.7 · bachelor's or higher 61%
Ethnicity
Hispanic 17% · White 38% · Black 3% · Asian 37%
Adults per alcohol outlet
222
Alcohol spend within 3 mi
$180,264,509 a year ($76,253,608 at home, $103,957,504 away) · $107,173 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-16 14:56insertdoordash 24741483 ↔ vtinfo 44e1751e87e794c9one name contains the other, same addressmerged15
2026-11-16 14:56insertubereats ie5xwDKBW8aO8sjRDNLOWA ↔ vtinfo 44e1751e87e794c9one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4536231 ↔ doordash 24741483one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4536231 ↔ ubereats ie5xwDKBW8aO8sjRDNLOWAone name contains the other, same addressmerged15
2026-11-13 17:47insertab-inbev 4536231 ↔ vtinfo 44e1751e87e794c9same address and namemerged15
2026-11-13 17:47insertab-inbev 4536231 ↔ overture ad305db2-8c16-4a86-8cf5-7f1249810a60same address and namemerged15
2026-11-13 14:10insertoverture ad305db2-8c16-4a86-8cf5-7f1249810a60 ↔ vtinfo 44e1751e87e794c9same address and namemerged15
2026-11-11 12:56insertca-abc 00633797|20|LIC|0 ↔ ubereats ie5xwDKBW8aO8sjRDNLOWAClaude judge: samemerged12
2026-11-11 12:56insertca-abc 00633797|42|LIC|0 ↔ doordash 24741483Claude judge: samemerged12
2026-11-11 12:56insertca-abc 00633797|20|LIC|0 ↔ doordash 24741483Claude judge: samemerged12
2026-10-14 18:03backfilldoordash 24741483 ↔ ubereats ie5xwDKBW8aO8sjRDNLOWAsame address and namemerged
2026-10-09 13:59backfillca-abc 00633797|20|LIC|0 ↔ ca-abc 00633797|42|LIC|0one licence filemerged