MACONDRAY

SAN FRANCISCO, CA 94109 · O05b3ca2e4214 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed4 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
MACONDRAY 2 other
the most common name a source states
SHAKEY JAKE'S LLC ca-abc (legal name) ×4
macondray san francisco doordash
Street
2209 POLK ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94109
ca-abcno other value
Pin
37.79708, -122.42226 map
ubereatsno other value
Phone
4157945682 1 other
vtinfo
4158293464 overture
Licences
ca-abc 00608848|47|APP|0 · ca-abc 00608848|47|LIC|0 · ca-abc 00608848|58|APP|0 · ca-abc 00608848|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc52b167bb974; O744eb4407368; O615070d92471; O510a2cda8abb; O66545ddc5d9a; O31d2997b9753; O859181ace60b; Oed33769bd609

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-inbevMACONDRAY
4326477
2209 POLK ST, SAN FRANCISCO, CA, 9410937.79720, -122.422092026-11-132026-11-13
ca-abcMACONDRAY
legal name: SHAKEY JAKE'S LLC
00608848|47|APP|0
2209 POLK ST, SAN FRANCISCO, CA, 9410937.79705, -122.422062026-10-082026-11-12
ca-abcMACONDRAY
legal name: SHAKEY JAKE'S LLC
00608848|47|LIC|0
2209 POLK ST, SAN FRANCISCO, CA, 9410937.79705, -122.422062026-10-082026-11-12
ca-abcMACONDRAY
legal name: SHAKEY JAKE'S LLC
00608848|58|APP|0
2209 POLK ST, SAN FRANCISCO, CA, 9410937.79705, -122.422062026-10-082026-11-12
ca-abcMACONDRAY
legal name: SHAKEY JAKE'S LLC
00608848|58|LIC|0
2209 POLK ST, SAN FRANCISCO, CA, 9410937.79705, -122.422062026-10-082026-11-12
doordashmacondray san francisco
36017409
2209 Polk St, San Francisco, CA, 9410937.79710, -122.422152026-10-082026-11-13
overtureMacondray
ca44e4d2-7db9-469d-ad35-235ae6085ce1
2209 Polk St, San Francisco, CA, 94109415829346437.79710, -122.422202026-11-062026-11-12
ubereatsMacondray
KwikGIsyRO-KxiWElQD1LQ
2209 Polk St, San Francisco, CA, 9410937.79708, -122.422262026-10-132026-11-12
vtinfoMACONDRAY
5b2683da8cfb7b4b
2209 POLK ST, SAN FRANCISCO, CA, 94109415794568237.79709, -122.422272026-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 MACONDRAYca-abc MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev MACONDRAYca-abc MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev MACONDRAYca-abc MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev MACONDRAYca-abc MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev MACONDRAYdoordash macondray san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ab-inbev MACONDRAYoverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ab-inbev MACONDRAYubereats Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev MACONDRAYvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
ca-abc MACONDRAYca-abc MACONDRAY1.00one licence filemergedfile: 00608848 · same_address
ca-abc MACONDRAYca-abc MACONDRAY1.00one licence filemergedfile: 00608848 · same_address
ca-abc MACONDRAYca-abc MACONDRAY1.00one licence filemergedfile: 00608848 · same_address
ca-abc MACONDRAYdoordash macondray san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc MACONDRAYoverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc MACONDRAYubereats Macondray1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc MACONDRAYvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ca-abc MACONDRAYdoordash macondray san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc MACONDRAYoverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc MACONDRAYubereats Macondray1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc MACONDRAYvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ca-abc MACONDRAYdoordash macondray san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc MACONDRAYoverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc MACONDRAYubereats Macondray1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc MACONDRAYvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ca-abc MACONDRAYdoordash macondray san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc MACONDRAYoverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc MACONDRAYubereats Macondray1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc MACONDRAYvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
doordash macondray san franciscooverture Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash macondray san franciscoubereats Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
doordash macondray san franciscovtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
overture Macondrayubereats Macondray1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
overture Macondrayvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: differs
ubereats Macondrayvtinfo MACONDRAY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 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
SHAKEY JAKE'S LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
1,843 within 1 mi · 5,290 within 3 mi
Off / on premise
229 / 1,150 within 1 mi · 687 / 3,342 within 3 mi
Selling alcohol
1,155 within 1 mi · 3,290 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (13,742 people per sq mi)
People within 3 mi
388,532 (341,359 adults 21+, 199,485 households) from 130 tract(s), tracts within 3 mi
Income
per capita $107,567 · median household ~$148,842 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 66%
Ethnicity
Hispanic 15% · White 47% · Black 5% · Asian 29%
Adults per alcohol outlet
104
Alcohol spend within 3 mi
$187,356,072 a year ($79,783,705 at home, $107,513,374 away) · $56,930 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-13 17:47insertab-inbev 4326477 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ doordash 36017409same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ ca-abc 00608848|47|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ ca-abc 00608848|58|APP|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ ca-abc 00608848|58|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ ca-abc 00608848|47|APP|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4326477 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged15
2026-11-12 14:25insertca-abc 00608848|47|LIC|0 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertoverture ca44e4d2-7db9-469d-ad35-235ae6085ce1 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertca-abc 00608848|58|APP|0 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertca-abc 00608848|58|LIC|0 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertca-abc 00608848|47|APP|0 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertubereats KwikGIsyRO-KxiWElQD1LQ ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-12 14:25insertca-abc 00608848|47|LIC|0 ↔ doordash 36017409same address and namemerged12
2026-11-12 14:25insertdoordash 36017409 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged12
2026-11-12 14:25insertca-abc 00608848|58|APP|0 ↔ doordash 36017409same address and namemerged12
2026-11-12 14:25insertca-abc 00608848|58|LIC|0 ↔ doordash 36017409same address and namemerged12
2026-11-12 14:25insertca-abc 00608848|47|APP|0 ↔ doordash 36017409same address and namemerged12
2026-11-12 14:25insertdoordash 36017409 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged12
2026-11-12 14:25insertdoordash 36017409 ↔ vtinfo 5b2683da8cfb7b4bsame address and namemerged12
2026-11-06 18:13insertca-abc 00608848|58|APP|0 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged11
2026-11-06 18:13insertca-abc 00608848|58|LIC|0 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged11
2026-11-06 18:13insertca-abc 00608848|47|APP|0 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged11
2026-11-06 18:13insertca-abc 00608848|47|LIC|0 ↔ overture ca44e4d2-7db9-469d-ad35-235ae6085ce1same address and namemerged11
2026-11-06 18:13insertoverture ca44e4d2-7db9-469d-ad35-235ae6085ce1 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged11
2026-10-13 17:02backfillca-abc 00608848|58|LIC|0 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged
2026-10-13 17:02backfillca-abc 00608848|47|LIC|0 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged
2026-10-13 17:02backfillca-abc 00608848|47|APP|0 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged
2026-10-13 17:02backfillca-abc 00608848|58|APP|0 ↔ ubereats KwikGIsyRO-KxiWElQD1LQsame address and namemerged
2026-10-09 13:59backfillca-abc 00608848|47|APP|0 ↔ ca-abc 00608848|58|LIC|0one licence filemerged
2026-10-09 13:59backfillca-abc 00608848|47|APP|0 ↔ ca-abc 00608848|58|APP|0one licence filemerged
2026-10-09 13:59backfillca-abc 00608848|47|APP|0 ↔ ca-abc 00608848|47|LIC|0one licence filemerged