SF HOLE IN THE WALL PIZZA

SAN FRANCISCO, CA 94122 · O0889cd4a98c6 · first seen 2026-10-08
3 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
SF HOLE IN THE WALL PIZZA 3 other
the most common name a source states
FARMAY INCORPORATED ca-abc (legal name)
SF HOLE IN THE WALL PIZZA 2 vtinfo
sf hole in the wall pizza san francisco doordash
Street
1825-1827 IRVING ST 2 other
ca-abc
1825 IRVING ST vtinfo
1825 Irving Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94122
ca-abcno other value
Pin
37.76339, -122.47765 map
doordashno other value
Phone
4155643900
vtinfono other value
Licences
ca-abc 00597002|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdd7ec83b4d5; O8229e5ebdfd0

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-abcSF HOLE IN THE WALL PIZZA
legal name: FARMAY INCORPORATED
00597002|41|LIC|0
1825-1827 IRVING ST, SAN FRANCISCO, CA, 9412237.76349, -122.477522026-10-082026-11-05
doordashsf hole in the wall pizza san francisco
396669
1825 Irving Street, San Francisco, CA, 9412237.76339, -122.477652026-10-082026-11-06
vtinfoSF HOLE IN THE WALL PIZZA 2
d610274f27eadb75
1825 IRVING ST, SAN FRANCISCO, CA, 94122415564390037.76333, -122.477662026-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
ca-abc SF HOLE IN THE WALL PIZZAdoordash sf hole in the wall pizza san francisco1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “proximity” pair)
The names match once the city DoorDash appends to its slug is removed, the address is the same (1825 Irving St falls within the 1825-1827 range), and only one business is recorded at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same name and address.
  • Claude Haiku 5.5, prompt v9: same, 90% confident — The California ABC record for SF Hole in the Wall Pizza at 1825 Irving St (ZIP 94122, restaurant on-sale licence) matches the DoorDash listing 'sf hole in the wall pizza san francisco' at the same street address and ZIP, with coordinates about 16 m apart and no other business at the address.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records place 'SF Hole in the Wall Pizza' at 1825 Irving Street, San Francisco 94122 with coordinates about 16 m apart, the only business at that address, and the DoorDash slug is the same name with city appended; the CA licence is an eating-place restaurant licence matching a pizza outlet.
pair 30bcde293dc03a8f3968
doordash sf hole in the wall pizza san franciscovtinfo SF HOLE IN THE WALL PIZZA 20.89same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.84 · same street + city + state · pins 6 m apart · name similarity 0.89

Attributes

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

Trade area

Other outlets
275 within 1 mi · 2,057 within 3 mi
Off / on premise
36 / 192 within 1 mi · 368 / 1,340 within 3 mi
Selling alcohol
154 within 1 mi · 1,359 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (12,876 people per sq mi)
People within 3 mi
364,051 (304,214 adults 21+, 158,446 households) from 96 tract(s), tracts within 3 mi
Income
per capita $101,733 · median household ~$165,126 (weighted mean of tract medians)
Age and education
median age ~42.0 · bachelor's or higher 69%
Ethnicity
Hispanic 11% · White 47% · Black 3% · Asian 33%
Adults per alcohol outlet
224
Alcohol spend within 3 mi
$162,771,142 a year ($68,604,798 at home, $94,119,879 away) · $119,685 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:25insertdoordash 396669 ↔ vtinfo d610274f27eadb75same address and namemerged12
2026-11-06 18:13insertca-abc 00597002|41|LIC|0 ↔ doordash 396669Claude judge: samemerged11