MID CITY MARKET

SAN FRANCISCO, CA 94109 · O11e1c8bbc473 · first seen 2026-10-08
4 sourcesoff premise · conveniencealcohol: 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
MID CITY MARKET 2 other
the most common name a source states
2E SHQAIR INC ca-abc (legal name)
Mid City Market & Deli overture
Street
868 GEARY 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.78626, -122.41761 map
overtureno other value
Phone
4154741568
vtinfono other value
Licences
ca-abc 00462767|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O3aefd5329341; O54097b2a2c99; Oed23c1d0e8c4

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-inbevMID CITY MARKET
1949524
868 GEARY ST, SAN FRANCISCO, CA, 9410937.78628, -122.417282026-11-132026-11-13
ca-abcMID CITY MARKET
legal name: 2E SHQAIR INC
00462767|21|LIC|0
868 GEARY ST, SAN FRANCISCO, CA, 9410937.78623, -122.417572026-10-082026-11-05
overtureMid City Market & Deli
93129ed5-7c1a-4826-951d-1d64a866199b
868 Geary St, San Francisco, CA, 94109415474156837.78626, -122.417612026-11-062026-11-06
vtinfoMID CITY MARKET
25b7574dfaa89aa7
868 GEARY ST, SAN FRANCISCO, CA, 94109415474156837.78630, -122.417642026-11-112026-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 MID CITY MARKETca-abc MID CITY MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ab-inbev MID CITY MARKETvtinfo MID CITY MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
ca-abc MID CITY MARKETvtinfo MID CITY MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
ab-inbev MID CITY MARKEToverture Mid City Market & Deli0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.88 · same street + ZIP · pins 29 m apart · name similarity 0.80
ca-abc MID CITY MARKEToverture Mid City Market & Deli0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.88 · same street + ZIP · pins 6 m apart · name similarity 0.80
overture Mid City Market & Delivtinfo MID CITY MARKET0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.88 · same street + city + state · pins 5 m apart · name similarity 0.80 · phone: equal

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
2E SHQAIR INC — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
2,251 within 1 mi · 5,788 within 3 mi
Off / on premise
259 / 1,456 within 1 mi · 766 / 3,648 within 3 mi
Selling alcohol
1,364 within 1 mi · 3,619 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.00 mi
Setting
urban (16,260 people per sq mi)
People within 3 mi
459,747 (401,882 adults 21+, 231,651 households) from 149 tract(s), tracts within 3 mi
Income
per capita $109,014 · median household ~$153,624 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
111
Alcohol spend within 3 mi
$221,813,040 a year ($94,212,262 at home, $127,532,837 away) · $61,274 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 1949524 ↔ overture 93129ed5-7c1a-4826-951d-1d64a866199bsame address and namemerged15
2026-11-13 17:47insertab-inbev 1949524 ↔ vtinfo 25b7574dfaa89aa7same address and namemerged15
2026-11-13 17:47insertab-inbev 1949524 ↔ ca-abc 00462767|21|LIC|0same address and namemerged15
2026-11-11 12:56insertoverture 93129ed5-7c1a-4826-951d-1d64a866199b ↔ vtinfo 25b7574dfaa89aa7same address and namemerged12
2026-11-11 12:56insertca-abc 00462767|21|LIC|0 ↔ vtinfo 25b7574dfaa89aa7same address and namemerged12
2026-11-06 18:13insertca-abc 00462767|21|LIC|0 ↔ overture 93129ed5-7c1a-4826-951d-1d64a866199bsame address and namemerged11