The Farmacy

SAN FRANCISCO, CA 94107 · O3f0f18089ee0 · first seen 2026-10-08
5 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
The Farmacy 1 other
a source's own spelling of the licence name (record_title.py)
farmacy san francisco doordash
Street
1 S PARK AVE 2 other
ca-abc
1 S PARK ST ab-inbevdoordashoverture ×3
1 South Park, 103A ubereats
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94107 1 other
ca-abc
94110 doordash
Pin
37.78227, -122.39286 map
ubereatsno other value
Phone
none
no other value
Licences
ca-abc 00665128|41|LIC|0 · ca-abc 00665128|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8dbc7f7d7c2e; O64d0df967f62; O8a1c7274105a; Oda10232713f6; O6a26511f6e14

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-inbevTHE FARMACY
4827189
1 S PARK ST, SAN FRANCISCO, CA, 9410737.78224, -122.393032026-11-132026-11-13
ca-abcTHE FARMACY
00665128|41|LIC|0
1 S PARK AVE, SAN FRANCISCO, CA, 9410737.78238, -122.392842026-10-082026-11-11
ca-abcTHE FARMACY
00665128|58|LIC|0
1 S PARK AVE, SAN FRANCISCO, CA, 9410737.78238, -122.392842026-10-082026-11-11
doordashfarmacy san francisco
33811207
1 S Park St, San Francisco, CA, 9411037.78221, -122.392842026-10-082026-11-10
overtureThe Farmacy
888b3b08-f31c-4720-bb34-3e9958f72510
1 S Park St, San Francisco, CA, 9410737.78237, -122.392842026-11-092026-11-09
ubereatsThe Farmacy
kiwLg1AJXq6-VW1_UPYplg
1 South Park, 103A, San Francisco, CA, 9410737.78227, -122.392862026-11-142026-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 THE FARMACYdoordash farmacy san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
ab-inbev THE FARMACYoverture The Farmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc THE FARMACYca-abc THE FARMACY1.00one licence filemergedfile: 00665128 · same_address
ca-abc THE FARMACYdoordash farmacy san francisco1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “proximity” pair)
The name 'The Farmacy' is distinctive and matches the DoorDash slug 'farmacy san francisco'. The address is 1 South Park, 19 m apart, despite the Ave/St and ZIP variation. Only one business is recorde
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Farmacy name matches, same address 19m apart
  • Claude Haiku 5.5, prompt v9: same, 82% confident — The names match (THE FARMACY and farmacy san francisco), the coordinates are about 19 m apart, and both sit on South Park in San Francisco, with the only one-building address and no other business there; the ZIP mismatch (94107 vs 94110) and the restaurant licence against a delivery listing are minor doubts.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — The DoorDash slug 'farmacy san francisco' matches the ABC name 'THE FARMACY', the coordinates are about 19 m apart, and only one business is held at that address; the street suffix (Ave vs St) and ZIP (94107 vs 94110) differ, which lowers confidence slightly.
pair 424685f4b82aee3d7bac
ca-abc THE FARMACYubereats The Farmacy1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 12 m apart · name similarity 1.00 · street similarity 0.76
ca-abc THE FARMACYdoordash farmacy san francisco1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “proximity” pair)
The distinctive name 'The Farmacy' matches the DoorDash slug 'farmacy san francisco', and the coordinates are 19 m apart at 1 South Park, where only one business is recorded; the Ave/St and ZIP differ
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 80% confident — Farmacy name and address match; coordinates within 19 m
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name the same restaurant (THE FARMACY / farmacy san francisco) at effectively the same spot, coordinates 19 m apart and one business at the address; the CA eating-place licence fits a restaurant's delivery listing, though the ZIP (94107 vs 94110) and street suffix (Ave vs St) differ slightly.
  • Claude Haiku 5.5, prompt v7: same, 82% confident — The names match (The Farmacy / farmacy san francisco), the coordinates are about 19 m apart, and only one business is held at this address; the 'Ave' vs 'St' and ZIP 94107 vs 94110 differences are minor and the restaurant licence fits a DoorDash restaurant listing.
pair 37c5db1b67442fbf9ab6
ca-abc THE FARMACYubereats The Farmacy1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 12 m apart · name similarity 1.00 · street similarity 0.76
doordash farmacy san franciscooverture The Farmacy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00

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)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,369 within 1 mi · 5,335 within 3 mi
Off / on premise
127 / 864 within 1 mi · 690 / 3,324 within 3 mi
Selling alcohol
750 within 1 mi · 3,312 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (13,005 people per sq mi)
People within 3 mi
367,694 (324,810 adults 21+, 189,767 households) from 126 tract(s), tracts within 3 mi
Income
per capita $106,046 · median household ~$147,156 (weighted mean of tract medians)
Age and education
median age ~39.8 · bachelor's or higher 65%
Ethnicity
Hispanic 16% · White 45% · Black 6% · Asian 28%
Adults per alcohol outlet
98
Alcohol spend within 3 mi
$176,116,610 a year ($75,075,521 at home, $100,985,406 away) · $53,159 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-14 20:23insertca-abc 00665128|58|LIC|0 ↔ ubereats kiwLg1AJXq6-VW1_UPYplgstreet written two waysmerged15
2026-11-14 20:23insertca-abc 00665128|41|LIC|0 ↔ ubereats kiwLg1AJXq6-VW1_UPYplgstreet written two waysmerged15
2026-11-13 17:47insertab-inbev 4827189 ↔ doordash 33811207same address and namemerged15
2026-11-13 17:47insertab-inbev 4827189 ↔ overture 888b3b08-f31c-4720-bb34-3e9958f72510same address and namemerged15
2026-11-11 12:56insertca-abc 00665128|41|LIC|0 ↔ doordash 33811207Claude judge: samemerged12
2026-11-11 12:56insertca-abc 00665128|58|LIC|0 ↔ doordash 33811207Claude judge: samemerged12
2026-11-09 15:32insertdoordash 33811207 ↔ overture 888b3b08-f31c-4720-bb34-3e9958f72510same address and namemerged11
2026-10-09 13:59backfillca-abc 00665128|41|LIC|0 ↔ ca-abc 00665128|58|LIC|0one licence filemerged