Castillito Yucateco

SAN FRANCISCO, CA 94110 · O0984ea4367c3 · first seen 2026-10-08
4 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
Castillito Yucateco 2 other
a source's own spelling of the licence name (record_title.py)
CASTILLITO YUCATECO INC ca-abc ×2
castillito yucateco san francisco doordash
Street
2052 MISSION ST. 1 other
ca-abc
2052 Mission Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94110 1 other
ca-abc
94105 overture
Pin
37.76414, -122.41983 map
doordashno other value
Phone
4154109962 1 other
vtinfo
4156215510 overture
Licences
ca-abc 00542295|41|APP|0 · ca-abc 00627675|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaf602a2af58e; O32d12ccff908; O8be98abe5069; O739d443008c0

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-abcCASTILLITO YUCATECO INC
00542295|41|APP|0
2052 MISSION ST., SAN FRANCISCO, CA, 9411037.76419, -122.419662026-10-082026-11-05
ca-abcCASTILLITO YUCATECO INC
00627675|47|LIC|0
2052 MISSION ST., SAN FRANCISCO, CA, 9411037.76419, -122.419662026-10-082026-11-04
doordashcastillito yucateco san francisco
297570
2052 Mission Street, San Francisco, CA, 9411037.76414, -122.419832026-10-082026-11-05
overtureCastillito Yucateco
08f97250-ed3e-466a-9c91-db8d91223a2c
2052 Mission St, San Francisco, CA, 94105415621551037.76413, -122.419702026-11-062026-11-06
vtinfoCASTILLITO YUCATECO
b3bb43ee212e7529
2052 MISSION ST, SAN FRANCISCO, CA, 94110415410996237.76410, -122.419932026-11-142026-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 CASTILLITO YUCATECO INCca-abc CASTILLITO YUCATECO INC1.00one store listed twicemergedsame street + ZIP · name: identical
ca-abc CASTILLITO YUCATECO INCdoordash castillito yucateco san francisco1.00same address and namemergedaddress similarity 1.00 · same street + city + state · name similarity 1.00
ca-abc CASTILLITO YUCATECO INCoverture Castillito Yucateco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
ca-abc CASTILLITO YUCATECO INCvtinfo CASTILLITO YUCATECO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ca-abc CASTILLITO YUCATECO INCdoordash castillito yucateco san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc CASTILLITO YUCATECO INCoverture Castillito Yucateco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
ca-abc CASTILLITO YUCATECO INCvtinfo CASTILLITO YUCATECO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
doordash castillito yucateco san franciscooverture Castillito Yucateco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
doordash castillito yucateco san franciscovtinfo CASTILLITO YUCATECO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
overture Castillito Yucatecovtinfo CASTILLITO YUCATECO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CASTILLITO YUCATECO INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,257 within 1 mi · 6,309 within 3 mi
Off / on premise
179 / 816 within 1 mi · 868 / 3,957 within 3 mi
Selling alcohol
843 within 1 mi · 3,890 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (20,053 people per sq mi)
People within 3 mi
566,990 (486,943 adults 21+, 268,280 households) from 172 tract(s), tracts within 3 mi
Income
per capita $102,217 · median household ~$153,597 (weighted mean of tract medians)
Age and education
median age ~40.3 · bachelor's or higher 64%
Ethnicity
Hispanic 17% · White 44% · Black 5% · Asian 30%
Adults per alcohol outlet
125
Alcohol spend within 3 mi
$258,522,913 a year ($109,750,270 at home, $148,694,168 away) · $66,441 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-14 20:23insertoverture 08f97250-ed3e-466a-9c91-db8d91223a2c ↔ vtinfo b3bb43ee212e7529same address and namemerged15
2026-11-14 20:23insertca-abc 00627675|47|LIC|0 ↔ vtinfo b3bb43ee212e7529same address and namemerged15
2026-11-14 20:23insertdoordash 297570 ↔ vtinfo b3bb43ee212e7529same address and namemerged15
2026-11-14 20:23insertca-abc 00542295|41|APP|0 ↔ vtinfo b3bb43ee212e7529same address and namemerged15
2026-11-06 18:13insertca-abc 00542295|41|APP|0 ↔ overture 08f97250-ed3e-466a-9c91-db8d91223a2csame address and namemerged11
2026-11-06 18:13insertca-abc 00627675|47|LIC|0 ↔ overture 08f97250-ed3e-466a-9c91-db8d91223a2csame address and namemerged11
2026-11-06 18:13insertdoordash 297570 ↔ overture 08f97250-ed3e-466a-9c91-db8d91223a2csame address and namemerged11
2026-11-05 17:26backfillca-abc 00542295|41|APP|0 ↔ ca-abc 00627675|47|LIC|0one store listed twicemerged
2026-10-16 20:04backfillca-abc 00627675|47|LIC|0 ↔ doordash 297570same address and namemerged
2026-10-16 20:04backfillca-abc 00542295|41|APP|0 ↔ doordash 297570same address and namemerged