Square Pie Guys

San Francisco, CA 94103 · O1bee817434b4 · 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
Square Pie Guys 2 other
the most common name a source states
ADAM MADISON LLC ca-abc (legal name)
square pie guys san francisco doordash
Street
1077 & 1081 MISSION ST 2 other
ca-abc
1077 Mission St overture
1081 Mission Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.77951, -122.41035 map
doordashno other value
Phone
4158729290
overtureno other value
Licences
ca-abc 00605123|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od08ad551af16; O8cf4946e357f

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-abcSQUARE PIE GUYS
legal name: ADAM MADISON LLC
00605123|41|LIC|0
1077 & 1081 MISSION ST, SAN FRANCISCO, CA, 9410337.77952, -122.410442026-10-082026-11-18
doordashsquare pie guys san francisco
680654
1081 Mission Street, San Francisco, CA, 9410337.77951, -122.410352026-10-082026-11-18
overtureSquare Pie Guys
2458f036-521b-4e89-9f89-54ae77a198ac
1077 Mission St, San Francisco, CA, 94103415872929037.77953, -122.410382026-11-182026-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 SQUARE PIE GUYSdoordash square pie guys san francisco1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “proximity” pair)
The name matches (the DoorDash slug is 'Square Pie Guys' with the city appended), the address 1081 Mission St is covered by the licence's '1077 & 1081 Mission St', and only one business is known at th
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same restaurant name and address
  • Claude Opus 5.5, prompt v9: same, 95% confident — Same restaurant name 'Square Pie Guys' at 1081 Mission St, San Francisco; the licence covers 1077 & 1081 Mission and the coordinates are 8 m apart.
  • Claude Haiku 5.5, prompt v9: same, 85% confident — The California ABC record for SQUARE PIE GUYS at 1077 & 1081 Mission St (legal entity ADAM MADISON LLC, restaurant eating-place licence) matches the DoorDash listing 'square pie guys san francisco' at 1081 Mission Street, ZIP 94103, with a distance of 8 m and no other businesses at the address, so it is one operation's licence beside its own delivery listing.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records name Square Pie Guys at the same Mission Street address and ZIP in San Francisco, the DoorDash slug matches the ABC DBA, the coordinates are about 8 m apart, and no other business is held at that address, so this is one restaurant listed twice.
pair 00d5c037ebcf1560d5e5
ca-abc SQUARE PIE GUYSoverture Square Pie Guys1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 6 m apart · name similarity 1.00 · street similarity 0.80

Attributes

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

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 00605123|41|LIC|0 ↔ overture 2458f036-521b-4e89-9f89-54ae77a198acstreet written two waysmerged15
2026-11-06 18:13insertca-abc 00605123|41|LIC|0 ↔ doordash 680654Claude judge: samemerged11