Casaro Marina

SAN FRANCISCO, CA 94123 · O1fe7e0a7cfe9 · first seen 2026-10-08
4 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
Casaro Marina 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Casaro Osteria overturevtinfo ×2
casaro osteria san francisco doordash
Street
2136 UNION ST 1 other
ca-abc
2136 Union Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94123
ca-abcno other value
Pin
37.79733, -122.43449 map
doordashno other value
Phone
4153747788
vtinfono other value
Licences
ca-abc 00636579|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O264bce832a0f; Oba58ad490f82; O2705afdabb42

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-abcCASARO MARINA
00636579|47|LIC|0
2136 UNION ST, SAN FRANCISCO, CA, 9412337.79728, -122.434482026-10-082026-11-11
doordashcasaro osteria san francisco
24645455
2136 Union Street, San Francisco, CA, 9412337.79733, -122.434492026-10-082026-11-10
overtureCasaro Osteria
edf25163-dbdb-49cd-a178-89e681fdb807
2136 Union St, San Francisco, CA, 94123415374778837.79745, -122.434492026-11-092026-11-09
vtinfoCASARO OSTERIA
85576303139e83e5
2136 UNION ST, SAN FRANCISCO, CA, 94123415374778837.79750, -122.434572026-11-122026-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
doordash casaro osteria san franciscooverture Casaro Osteria1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00
doordash casaro osteria san franciscovtinfo CASARO OSTERIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
overture Casaro Osteriavtinfo CASARO OSTERIA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal
ca-abc CASARO MARINAdoordash casaro osteria san francisco0.54Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
Both records sit at the same street address, 2136 Union St, San Francisco 94123, with only one business known there, and the distinctive 'Casaro' name matches: 'Casaro Marina' is a restaurant licence
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 80% confident — Same address, Casaro name shared, restaurant listing
  • Claude Opus 5.5, prompt v9: same, 88% confident — Same street address, with only one business recorded there, and the shared distinctive 'Casaro' name (the licence's 'Casaro Marina' vs the DoorDash listing's 'Casaro Osteria') indicate one restaurant.
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at 2136 Union Street, SF 94123 with coordinates 6 m apart and only one business at the address, and the shared distinctive name 'Casaro' points to one restaurant (CA on-sale eating-place licence beside its DoorDash listing), though 'Marina' vs 'Osteria' leaves some doubt.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records give the same street address, ZIP and coordinates (about 6 m apart), only one business is held at that address, and both names share the distinctive 'Casaro' term; the ABC record is an on-sale restaurant licence, which fits a DoorDash restaurant listing.
pair 01ff2f6d705e348f5788

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, spirits_on — CA 47
Rule version 10, computed 2026-11-18 20:35.
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
879 within 1 mi · 5,418 within 3 mi
Off / on premise
132 / 575 within 1 mi · 692 / 3,448 within 3 mi
Selling alcohol
583 within 1 mi · 3,355 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (13,933 people per sq mi)
People within 3 mi
393,957 (346,213 adults 21+, 202,404 households) from 130 tract(s), tracts within 3 mi
Income
per capita $105,928 · median household ~$146,677 (weighted mean of tract medians)
Age and education
median age ~39.7 · bachelor's or higher 66%
Ethnicity
Hispanic 14% · White 47% · Black 5% · Asian 29%
Adults per alcohol outlet
103
Alcohol spend within 3 mi
$189,476,892 a year ($80,777,731 at home, $108,638,518 away) · $56,459 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 edf25163-dbdb-49cd-a178-89e681fdb807 ↔ vtinfo 85576303139e83e5same address and namemerged12
2026-11-12 14:25insertdoordash 24645455 ↔ vtinfo 85576303139e83e5same address and namemerged12
2026-11-11 12:56insertca-abc 00636579|47|LIC|0 ↔ doordash 24645455Claude judge: samemerged12
2026-11-09 15:32insertdoordash 24645455 ↔ overture edf25163-dbdb-49cd-a178-89e681fdb807same address and namemerged11