Limoncello

SAN FRANCISCO, CA 94109 · O3fdef5b5e101 · first seen 2026-10-08
1 sourceon 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
Limoncello
a licence name in capitals, cleaned (derived; record_title.py)no other value
Street
1406 SUTTER ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94109
ca-abcno other value
Pin
37.78737, -122.42358 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00659847|41|LIC|0 · ca-abc 00659847|58|LIC|0
every licence and permit record in the outlet
Joined by singleton · absorbed ids: Ofa9f79e99986

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-abcLIMONCELLO
00659847|41|LIC|0
1406 SUTTER ST, SAN FRANCISCO, CA, 9410937.78737, -122.423582026-10-082026-11-04
ca-abcLIMONCELLO
00659847|58|LIC|0
1406 SUTTER ST, SAN FRANCISCO, CA, 9410937.78737, -122.423582026-10-082026-11-04

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 LIMONCELLOdoordash limoncello san francisco1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “proximity” pair)
The distinctive name 'Limoncello' matches the DoorDash slug (with its city appended), and the two addresses are 1406 and 1400 Sutter St, only 10 m apart in the same ZIP, so both records point to one r
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Limoncello restaurant, adjacent number, 10m apart.
  • Claude Haiku 5.5, prompt v9: same, 82% confident — The names match (LIMONCELLO / limoncello san francisco), both are on Sutter St in the same ZIP 94109 about 10 m apart, and the only address difference is 1406 vs 1400, which is likely a numbering or entry discrepancy; the CA eating-place licence is the same restaurant's licence beside its DoorDash listing.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — The distinctive name LIMONCELLO matches the DoorDash slug with the city, the two records sit about 10 m apart on the same block of Sutter St in the same ZIP, and no other business is held at that address; the house numbers differ (1406 vs 1400), which is a small discrepancy.
pair 346f3b9cd39f697ec10c
ca-abc LIMONCELLOvtinfo LIMONCELLO1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same restaurant name, adjacent numbers 16m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records carry the identical name LIMONCELLO in the same city and ZIP, and their coordinates are about 16 m apart, so they likely describe one restaurant; the street numbers differ (1406 vs 1400), which keeps this from being certain.
pair 22adb30cb5db3ac5bad4
ca-abc LIMONCELLOdoordash limoncello san francisco1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “proximity” pair)
The distinctive name 'Limoncello' matches in both records, and the addresses sit within 10 m on Sutter St in San Francisco (1400 vs 1406), so they read as one restaurant, with the street-number differ
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Limoncello same name, 10m apart
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the same name (Limoncello / limoncello san francisco) in the same ZIP 94109, about 10 m apart, and the street numbers 1406 and 1400 Sutter are plausibly one building, with only one business at that address in the data; the CA record is a restaurant licence matching the DoorDash listing.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — The DoorDash listing 'limoncello san francisco' matches the ABC restaurant licence 'LIMONCELLO' on Sutter Street in the same ZIP, with coordinates only about 10 m apart; the 1400 vs 1406 house-number difference is the only conflict, and the address is likely a single building.
pair 69317a81e7ac31bc7d35
ca-abc LIMONCELLOvtinfo LIMONCELLO1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “proximity” pair)
Distinctive name, adjacent numbers, 16 m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the identical name LIMONCELLO in the same city and ZIP, with coordinates only 16 m apart, so the 1400 and 1406 Sutter house numbers likely refer to one premises; the name is distinctive and not a chain, and only one business is at the address.
pair deb8714c90283c376895
ca-abc LIMONCELLOca-abc LIMONCELLO1.00one licence filemergedfile: 00659847 · same_address

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; CA 58 (add-on: follows the base licence)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,758 within 1 mi · 5,881 within 3 mi
Off / on premise
234 / 1,100 within 1 mi · 771 / 3,730 within 3 mi
Selling alcohol
1,076 within 1 mi · 3,670 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.01 mi
Setting
urban (16,231 people per sq mi)
People within 3 mi
458,908 (401,249 adults 21+, 231,740 households) from 148 tract(s), tracts within 3 mi
Income
per capita $108,485 · median household ~$152,853 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 47% · Black 5% · Asian 28%
Adults per alcohol outlet
109
Alcohol spend within 3 mi
$221,661,308 a year ($94,187,018 at home, $127,406,345 away) · $60,382 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-18 18:58insertca-abc 00659847|58|LIC|0 ↔ vtinfo de2fcd6b25d438f3Claude judge: sameheld: same-source-conflict15
2026-11-18 18:58insertca-abc 00659847|41|LIC|0 ↔ vtinfo de2fcd6b25d438f3Claude judge: sameheld: same-source-conflict15
2026-11-11 12:56insertca-abc 00659847|58|LIC|0 ↔ doordash 98328Claude judge: sameheld: same-source-conflict12
2026-11-11 12:56insertca-abc 00659847|41|LIC|0 ↔ doordash 98328Claude judge: sameheld: same-source-conflict12
2026-10-09 13:59backfillca-abc 00659847|41|LIC|0 ↔ ca-abc 00659847|58|LIC|0one licence filemerged