Buckhorn Pickapple

SAN FRANCISCO, CA 94103 · O22295610ad81 · first seen 2026-10-08
2 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
Buckhorn Pickapple 3 other
a licence name in capitals, cleaned (derived; record_title.py)
BUCKHORN PICKAPPLE LLC ca-abc ×2
PICKAPPLE LLC ca-abc (legal name) ×2
BUCKHORN RESTAURANT vtinfo
Street
101 4TH ST 1 other
ca-abc
101 4TH ST ST 1060 vtinfo
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.78448, -122.40416 map 1 other
ca-abc
126 m away vtinfo
Phone
4153696150
vtinfono other value
Licences
ca-abc 00349261|41|APP|0 · ca-abc 00349261|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of2bf320c36cb; O2efeccc97d82

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-abcBUCKHORN PICKAPPLE LLC
legal name: PICKAPPLE LLC
00349261|41|APP|0
101 4TH ST, SAN FRANCISCO, CA, 9410337.78448, -122.404162026-10-082026-11-05
ca-abcBUCKHORN PICKAPPLE LLC
legal name: PICKAPPLE LLC
00349261|41|LIC|0
101 4TH ST, SAN FRANCISCO, CA, 9410337.78448, -122.404162026-10-082026-11-05
vtinfoBUCKHORN RESTAURANT
4cc6c943f3ae7d77
101 4TH ST ST 1060, SAN FRANCISCO, CA, 94103415369615037.78374, -122.403082026-11-122026-11-18

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 BUCKHORN PICKAPPLE LLCca-abc BUCKHORN PICKAPPLE LLC1.00one licence filemergedfile: 00349261 · same_address
ca-abc BUCKHORN PICKAPPLE LLCvtinfo BUCKHORN RESTAURANT0.44Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Buckhorn name matches, both restaurants at 101 4th St
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — The vtinfo record 'BUCKHORN RESTAURANT' shares the distinctive 'Buckhorn' name with the CA licence 'BUCKHORN PICKAPPLE LLC', and the licence is an eating-place (restaurant) licence at the same 101 4th St address, though the suite 1060 appears only on one record and the building holds other businesses.
pair 1651afa6cab3dbf770f1
ca-abc BUCKHORN PICKAPPLE LLCvtinfo BUCKHORN RESTAURANT0.44Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Buckhorn name matches, restaurant licence, same street address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records carry the distinctive name BUCKHORN, and A's restaurant (eating place) licence fits B's 'Buckhorn Restaurant' at the same street address and nearby coordinates, though the building is shared and B's suite 1060 is not in A's record.
pair 8c8e9c7296279b7bf869

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PICKAPPLE LLC — 7 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:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,516 within 1 mi · 5,571 within 3 mi
Off / on premise
232 / 1,564 within 1 mi · 739 / 3,478 within 3 mi
Selling alcohol
1,367 within 1 mi · 3,472 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.00 mi
Setting
urban (14,869 people per sq mi)
People within 3 mi
420,424 (368,820 adults 21+, 214,427 households) from 140 tract(s), tracts within 3 mi
Income
per capita $108,826 · median household ~$151,645 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 67%
Ethnicity
Hispanic 16% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
106
Alcohol spend within 3 mi
$203,259,435 a year ($86,416,042 at home, $116,780,545 away) · $58,526 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 00349261|41|LIC|0 ↔ vtinfo 4cc6c943f3ae7d77Claude judge: samemerged15
2026-11-18 18:58insertca-abc 00349261|41|APP|0 ↔ vtinfo 4cc6c943f3ae7d77Claude judge: samemerged15
2026-10-09 13:59backfillca-abc 00349261|41|APP|0 ↔ ca-abc 00349261|41|LIC|0one licence filemerged