CAFE MYSTIQUE

San Francisco, CA 94114 · O044679544f7f · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
CAFE MYSTIQUE 2 other
the most common name a source states
cafe mystique san francisco doordash
Café Mystique ubereats
Street
464 CASTRO ST 1 other
ca-abc
464 Castro Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94114
ca-abcno other value
Pin
37.76149, -122.43522 map
ubereatsno other value
Phone
4158659810 1 other
vtinfo
4158659963 overture
Licences
ca-abc 00467810|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocbd62cf5e550; Ob38b6c4770c3; Ofc95021dc454; Odd933ef7d396

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-abcCAFE MYSTIQUE
00467810|41|LIC|0
464 CASTRO ST, SAN FRANCISCO, CA, 9411437.76152, -122.435132026-10-082026-11-06
doordashcafe mystique san francisco
2349
464 Castro Street, San Francisco, CA, 9411437.76150, -122.435242026-10-082026-11-10
overtureCafe Mystique
2d253d1f-3cce-4351-9e82-61ffe9325f7f
464 Castro St, San Francisco, CA, 94114415865996337.76149, -122.435212026-11-062026-11-06
ubereatsCafé Mystique
odaoIFizQUKfS0hYK4BN0w
464 Castro St, San Francisco, CA, 9411437.76149, -122.435222026-10-312026-11-06
vtinfoCAFE MYSTIQUE
7c1dedece8512866
464 CASTRO ST, SAN FRANCISCO, CA, 94114415865981037.76146, -122.435412026-11-122026-11-13

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 CAFE MYSTIQUEdoordash cafe mystique san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
ca-abc CAFE MYSTIQUEoverture Cafe Mystique1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ca-abc CAFE MYSTIQUEubereats Café Mystique1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc CAFE MYSTIQUEvtinfo CAFE MYSTIQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
doordash cafe mystique san franciscooverture Cafe Mystique1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 m apart · name similarity 1.00
doordash cafe mystique san franciscoubereats Café Mystique1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
doordash cafe mystique san franciscovtinfo CAFE MYSTIQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
overture Cafe Mystiqueubereats Café Mystique1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
overture Cafe Mystiquevtinfo CAFE MYSTIQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: differs
ubereats Café Mystiquevtinfo CAFE MYSTIQUE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 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
none
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
885 within 1 mi · 6,247 within 3 mi
Off / on premise
140 / 574 within 1 mi · 870 / 3,976 within 3 mi
Selling alcohol
617 within 1 mi · 3,813 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (21,705 people per sq mi)
People within 3 mi
613,698 (523,837 adults 21+, 281,664 households) from 177 tract(s), tracts within 3 mi
Income
per capita $98,921 · median household ~$153,626 (weighted mean of tract medians)
Age and education
median age ~40.8 · bachelor's or higher 64%
Ethnicity
Hispanic 16% · White 43% · Black 4% · Asian 31%
Adults per alcohol outlet
137
Alcohol spend within 3 mi
$272,134,866 a year ($115,554,916 at home, $156,496,850 away) · $71,352 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 2d253d1f-3cce-4351-9e82-61ffe9325f7f ↔ vtinfo 7c1dedece8512866same address and namemerged12
2026-11-12 14:25insertca-abc 00467810|41|LIC|0 ↔ vtinfo 7c1dedece8512866same address and namemerged12
2026-11-12 14:25insertubereats odaoIFizQUKfS0hYK4BN0w ↔ vtinfo 7c1dedece8512866same address and namemerged12
2026-11-12 14:25insertdoordash 2349 ↔ vtinfo 7c1dedece8512866same address and namemerged12
2026-11-09 14:23insertca-abc 00467810|41|LIC|0 ↔ doordash 2349same address and namemerged11
2026-11-09 14:23insertdoordash 2349 ↔ ubereats odaoIFizQUKfS0hYK4BN0wsame address and namemerged11
2026-11-09 14:23insertdoordash 2349 ↔ overture 2d253d1f-3cce-4351-9e82-61ffe9325f7fsame address and namemerged11
2026-11-06 18:13insertca-abc 00467810|41|LIC|0 ↔ overture 2d253d1f-3cce-4351-9e82-61ffe9325f7fsame address and namemerged11
2026-11-06 18:13insertoverture 2d253d1f-3cce-4351-9e82-61ffe9325f7f ↔ ubereats odaoIFizQUKfS0hYK4BN0wsame address and namemerged11
2026-10-31 21:02backfillca-abc 00467810|41|LIC|0 ↔ ubereats odaoIFizQUKfS0hYK4BN0wsame address and namemerged