Mesa Foods and Liquors

Rancho Santa Margarita, CA 92688 · O6791280d24ea · first seen 2026-10-08
4 sourcesoff premise · conveniencealcohol: 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
Mesa Foods and Liquors 2 other
a source's own spelling of the licence name (record_title.py)
Mesa Food & Liquor ubereats ×2
MESA FOODS & LIQUORS ab-inbevvtinfo ×2
Street
28562 Santa Margarita Pkwy #G 2 other
ubereats
28562 OSO PKWY STE G ab-inbevvtinfo ×2
28562 Oso Pkwy overture
City
Rancho Santa Margarita
ubereatsno other value
State
CA
ubereatsno other value
ZIP
92688
ubereatsno other value
Pin
33.58277, -117.63266 map 2 other
ubereats
97 m away ab-inbev
90 m away vtinfo
Phone
9498588156
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oedafaa883330; Obc89dfa69d2c; O7542b3818d9a; Oac7f98528090

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-inbevMESA FOODS & LIQUORS
45928
28562 OSO PKWY STE G, RANCHO SANTA MARGARITA, CA, 9268833.58364, -117.632552026-11-112026-11-11
overtureMesa Foods and Liquors
82ece06f-5714-4cd3-a958-e1911dc107ae
28562 Oso Pkwy, Rancho Santa Margarita, CA, 92688949858815633.58304, -117.632682026-11-132026-11-13
ubereatsMesa Food & Liquor
nDWA6DRTRyqviCXI1BBW8g
28562 Santa Margarita Pkwy #G, Rancho Santa Margarita, CA, 9268833.58277, -117.632662026-10-082026-11-12
ubereatsMesa Food & Liquor
oeLkQmZaROWNucja1POeMA
28562 Santa Margarita Pkwy #G, Rancho Santa Margarita, CA, 9268833.58277, -117.632662026-10-142026-11-12
vtinfoMESA FOODS & LIQUORS
e633d06cd1a29601
28562 OSO PKWY STE G, RANCHO SANTA MARGARITA, CA, 92688949858815633.58356, -117.632452026-11-132026-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 MESA FOODS & LIQUORSoverture Mesa Foods and Liquors1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
ab-inbev MESA FOODS & LIQUORSvtinfo MESA FOODS & LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
overture Mesa Foods and Liquorsvtinfo MESA FOODS & LIQUORS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 61 m apart · name similarity 1.00 · phone: equal
ubereats Mesa Food & Liquorubereats Mesa Food & Liquor1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev MESA FOODS & LIQUORSubereats Mesa Food & Liquor0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same name, number and suite G; street name variant
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records give the same suite (#G) at 28562 (Oso Pkwy / Santa Margarita Pkwy, the same building), the same ZIP, and near-identical names (Mesa Foods & Liquors / Mesa Food & Liquor), with coordinates 0.097 km apart.
pair 48e59bb3da6967dd9460
ab-inbev MESA FOODS & LIQUORSubereats Mesa Food & Liquor0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Same name, suite G, ZIP; street name discrepancy minor.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records give the same unit (Suite/#G) at the same street number and ZIP 92688, with coordinates 0.097 km apart, and the names 'MESA FOODS & LIQUORS' and 'Mesa Food & Liquor' are near-identical, so the name agreement settles a shared building with five businesses.
pair 3c8e03390fe3b97ecff5
ubereats Mesa Food & Liquorvtinfo MESA FOODS & LIQUORS0.57Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Same name, suite G, phone-backed; street name discrepancy minor.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records name nearly identical liquor stores ('Mesa Food & Liquor' and 'MESA FOODS & LIQUORS') with the same street number, suite G, ZIP and city, and coordinates 0.09 km apart; the street name differs (Santa Margarita Pkwy vs Oso Pkwy), but the matching suite and name outweigh that in a shared building.
pair 285e87325597844d2129

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +12 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
11 within 1 mi · 329 within 3 mi
Off / on premise
2 / 8 within 1 mi · 84 / 197 within 3 mi
Selling alcohol
4 within 1 mi · 154 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.03 mi
Setting
urban (3,878 people per sq mi)
People within 3 mi
109,639 (79,550 adults 21+, 37,130 households) from 20 tract(s), tracts within 3 mi
Income
per capita $72,853 · median household ~$176,920 (weighted mean of tract medians)
Age and education
median age ~43.5 · bachelor's or higher 57%
Ethnicity
Hispanic 18% · White 65% · Black 1% · Asian 13%
Adults per alcohol outlet
513
Alcohol spend within 3 mi
$39,819,352 a year ($16,718,608 at home, $23,090,019 away) · $256,899 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-19 20:37insertubereats nDWA6DRTRyqviCXI1BBW8g ↔ vtinfo e633d06cd1a29601Claude judge: samemerged17
2026-11-13 14:10insertab-inbev 45928 ↔ vtinfo e633d06cd1a29601same address and namemerged15
2026-11-13 14:10insertoverture 82ece06f-5714-4cd3-a958-e1911dc107ae ↔ vtinfo e633d06cd1a29601same address and namemerged15
2026-11-13 14:10insertab-inbev 45928 ↔ overture 82ece06f-5714-4cd3-a958-e1911dc107aesame address and namemerged15
2026-11-12 17:29insertab-inbev 45928 ↔ ubereats nDWA6DRTRyqviCXI1BBW8gClaude judge: samemerged14
2026-11-12 17:29insertab-inbev 45928 ↔ ubereats oeLkQmZaROWNucja1POeMAClaude judge: samemerged14
2026-10-14 18:54backfillubereats nDWA6DRTRyqviCXI1BBW8g ↔ ubereats oeLkQmZaROWNucja1POeMAone store listed twicemerged