Patxi's Pizza

SAN FRANCISCO, CA 94102 · O02dd48b177d3 · 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
Patxi's Pizza 2 other
a source's own spelling of the licence name (record_title.py)
PATXIS PIZZA ab-inbevvtinfo ×2
HAPPY LION INC. ca-abc (legal name)
Street
511 HAYES ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94102
ca-abcno other value
Pin
37.77643, -122.42500 map
overtureno other value
Phone
4155589991
vtinfono other value
Licences
ca-abc 00678421|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7e209d8f1541; O63f1c3f2b3f6; O1bbd581d9454

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-inbevPATXIS PIZZA
2935788
511 HAYES ST, SAN FRANCISCO, CA, 9410237.77650, -122.425432026-11-112026-11-12
ca-abcPATXI'S PIZZA
legal name: HAPPY LION INC.
00678421|41|LIC|0
511 HAYES ST, SAN FRANCISCO, CA, 9410237.77659, -122.424812026-10-082026-11-12
overturePatxi's Pizza
f2b8f346-18d4-46bc-9542-ba1ad9965057
511 Hayes St, San Francisco, CA, 94102415558999137.77643, -122.425002026-11-062026-11-12
vtinfoPATXIS PIZZA
36362261b24603a7
511 HAYES ST, SAN FRANCISCO, CA, 94102415558999137.77643, -122.425002026-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
ab-inbev PATXIS PIZZAca-abc PATXIS CHICAGO PIZZA0.71one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 7ec9a46062b74126a254 · person: None · rule: names contained at one address · stratum: near
ca-abc PATXIS CHICAGO PIZZAvtinfo PATXIS PIZZA0.71one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: e849b93367571429be91 · person: None · rule: names contained at one address · stratum: near
ab-inbev PATXIS PIZZAca-abc PATXI'S PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ab-inbev PATXIS PIZZAoverture Patxi's Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
ab-inbev PATXIS PIZZAvtinfo PATXIS PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 38 m apart · name similarity 1.00
ca-abc PATXI'S PIZZAoverture Patxi's Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00
ca-abc PATXI'S PIZZAvtinfo PATXIS PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
overture Patxi's Pizzavtinfo PATXIS PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal

Attributes

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

Trade area

Other outlets
1,604 within 1 mi · 6,246 within 3 mi
Off / on premise
206 / 1,026 within 1 mi · 837 / 3,935 within 3 mi
Selling alcohol
963 within 1 mi · 3,871 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (17,998 people per sq mi)
People within 3 mi
508,876 (441,209 adults 21+, 252,283 households) from 161 tract(s), tracts within 3 mi
Income
per capita $108,376 · median household ~$155,749 (weighted mean of tract medians)
Age and education
median age ~39.7 · bachelor's or higher 68%
Ethnicity
Hispanic 15% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
114
Alcohol spend within 3 mi
$243,909,844 a year ($103,467,216 at home, $140,369,273 away) · $62,993 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-16 14:56insertca-abc 00418003|41|APP|0 ↔ vtinfo 36362261b24603a7one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 2935788 ↔ ca-abc 00418003|41|APP|0one name contains the other, same addressheld: same-source-conflict15
2026-11-12 14:25insertoverture f2b8f346-18d4-46bc-9542-ba1ad9965057 ↔ vtinfo 36362261b24603a7same address and namemerged12
2026-11-12 14:25insertab-inbev 2935788 ↔ vtinfo 36362261b24603a7same address and namemerged12
2026-11-12 14:25insertca-abc 00678421|41|LIC|0 ↔ vtinfo 36362261b24603a7same address and namemerged12
2026-11-11 12:56insertab-inbev 2935788 ↔ overture f2b8f346-18d4-46bc-9542-ba1ad9965057same address and namemerged12
2026-11-11 12:56insertab-inbev 2935788 ↔ ca-abc 00678421|41|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00678421|41|LIC|0 ↔ overture f2b8f346-18d4-46bc-9542-ba1ad9965057same address and namemerged11