Moscone West

SAN FRANCISCO, CA 94103 · O2cc0c5d76d73 · 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
Moscone West 1 other
a licence name in capitals, cleaned (derived; record_title.py)
SMG FOOD AND BEVERAGE LLC ca-abc (legal name) ×2
Street
800 HOWARD ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.78283, -122.40335 map 1 other
ca-abc
134 m away vtinfo
Phone
4153484358
vtinfono other value
Licences
ca-abc 00406175|47|LIC|0 · ca-abc 00406175|68|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of2135149e65e; Occ6c3338a4fe

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-abcMOSCONE WEST
legal name: SMG FOOD AND BEVERAGE LLC
00406175|47|LIC|0
800 HOWARD ST, SAN FRANCISCO, CA, 9410337.78283, -122.403352026-10-082026-11-11
ca-abcMOSCONE WEST
legal name: SMG FOOD AND BEVERAGE LLC
00406175|68|LIC|0
800 HOWARD ST, SAN FRANCISCO, CA, 9410337.78283, -122.403352026-10-082026-11-11
vtinfoMOSCONE WEST
09497396ff765671
800 HOWARD ST, SAN FRANCISCO, CA, 94103415348435837.78292, -122.404872026-11-112026-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 MOSCONE WESTca-abc MOSCONE WEST1.00one licence filemergedfile: 00406175 · same_address
ca-abc MOSCONE WESTvtinfo MOSCONE WEST1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 134 m apart · name similarity 1.00
ca-abc MOSCONE WESTvtinfo MOSCONE WEST1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 134 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
SMG FOOD AND BEVERAGE LLC — 18 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 68
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,197 within 1 mi · 5,613 within 3 mi
Off / on premise
222 / 1,402 within 1 mi · 749 / 3,495 within 3 mi
Selling alcohol
1,276 within 1 mi · 3,503 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (14,869 people per sq mi)
People within 3 mi
420,424 (368,820 adults 21+, 214,427 households) from 140 tract(s), tracts within 3 mi
Income
per capita $108,826 · median household ~$151,645 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 67%
Ethnicity
Hispanic 16% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
105
Alcohol spend within 3 mi
$203,259,435 a year ($86,416,042 at home, $116,780,545 away) · $58,008 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-11 12:56insertca-abc 00406175|68|LIC|0 ↔ vtinfo 09497396ff765671same address and namemerged12
2026-11-11 12:56insertca-abc 00406175|47|LIC|0 ↔ vtinfo 09497396ff765671same address and namemerged12
2026-10-09 13:59backfillca-abc 00406175|47|LIC|0 ↔ ca-abc 00406175|68|LIC|0one licence filemerged