Blue Mermaid Cafe

San Francisco, CA 94109 · O615c31f64e9a · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: alcohol

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
Blue Mermaid Cafe 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Blue Mermaid ubereats
blue mermaid san francisco doordash
Street
471 Jefferson Street 1 other
ubereats
471 Jefferson St doordashvtinfo ×2
City
San Francisco
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94109
ubereatsno other value
Pin
37.80750, -122.42000 map
ubereatsno other value
Phone
4157712222
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7544fff8a2ce; O719de8050e59

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
doordashblue mermaid san francisco
27797198
471 Jefferson St, San Francisco, CA, 9410937.80756, -122.420082026-10-082026-11-18
ubereatsBlue Mermaid
kYH4OvFiWOC_x_ph5HPSMg
471 Jefferson Street, San Francisco, CA, 9410937.80750, -122.420002026-11-132026-11-18
vtinfoBLUE MERMAID CAFE
02a5377ab6962ba3
471 JEFFERSON ST, SAN FRANCISCO, CA, 94109415771222237.80748, -122.420562026-11-122026-11-18

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
doordash blue mermaid san franciscoubereats Blue Mermaid1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
doordash blue mermaid san franciscovtinfo BLUE MERMAID CAFE0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.91 · same street + ZIP · pins 44 m apart · name similarity 0.75
ubereats Blue Mermaidvtinfo BLUE MERMAID CAFE0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.91 · same street + city + state · pins 50 m apart · name similarity 0.75

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
alcohol — listed as carrying Boston Beer, Diageo Beer Company, Heineken USA +1 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-18 18:58insertdoordash 27797198 ↔ vtinfo 02a5377ab6962ba3same address and namemerged15
2026-11-18 18:58insertdoordash 27797198 ↔ ubereats kYH4OvFiWOC_x_ph5HPSMgsame address and namemerged15
2026-11-13 14:10insertubereats kYH4OvFiWOC_x_ph5HPSMg ↔ vtinfo 02a5377ab6962ba3same address and namemerged15