Ace Hardware

San Francisco, CA 94133 · O08f3e3810475 · first seen 2026-10-08
3 sourcesoff premise · retail_otherchain: Ace Hardwarealcohol: no alcohol retail

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
Ace Hardware 1 other
the most common name a source states
ace hardware san francisco doordash
Street
627 Vallejo St
ubereatsno other value
City
San Francisco
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94133
ubereatsno other value
Pin
37.79857, -122.40811 map
ubereatsno other value
Phone
4154322653
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocda6820ad5ef; O553c5982b9d1

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
doordashace hardware san francisco
30934920
627 Vallejo St, San Francisco, CA, 9413337.79855, -122.408152026-10-082026-11-04
overtureAce Hardware
0a363982-0a12-487a-b90f-b673f6b8657b
627 Vallejo St, San Francisco, CA, 94133415432265337.79856, -122.408152026-11-062026-11-06
ubereatsAce Hardware
xYGW0AOpVVST5v03Y-oHiA
627 Vallejo St, San Francisco, CA, 9413337.79857, -122.408112026-11-042026-11-04

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
doordash ace hardware san franciscooverture b292d636-3620-4d64-8997-fefe902abd6a0.61same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 17 m apart · name similarity 0.61
overture b292d636-3620-4d64-8997-fefe902abd6aubereats Ace Hardware0.61same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 15 m apart · name similarity 0.61
doordash ace hardware san franciscooverture Ace Hardware1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
doordash ace hardware san franciscoubereats Ace Hardware1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
overture Ace Hardwareubereats Ace Hardware1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00

Attributes

Channel
off_premise · retail_other — ubereats-type
Chain
Ace Hardware — ubereats-parent
Alcohol
no_alcohol_retail — Ace Hardware: licensed at 5 of 1338 outlets in licence states
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "retail_other"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
2,081 within 1 mi · 4,959 within 3 mi
Off / on premise
214 / 1,293 within 1 mi · 622 / 3,107 within 3 mi
Selling alcohol
1,250 within 1 mi · 3,080 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (12,609 people per sq mi)
People within 3 mi
356,500 (315,009 adults 21+, 185,060 households) from 121 tract(s), tracts within 3 mi
Income
per capita $106,029 · median household ~$145,562 (weighted mean of tract medians)
Age and education
median age ~39.3 · bachelor's or higher 65%
Ethnicity
Hispanic 15% · White 45% · Black 6% · Asian 29%
Adults per alcohol outlet
102
Alcohol spend within 3 mi
$171,495,650 a year ($73,156,240 at home, $98,284,126 away) · $55,680 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-06 18:13insertoverture b292d636-3620-4d64-8997-fefe902abd6a ↔ ubereats xYGW0AOpVVST5v03Y-oHiAsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertdoordash 30934920 ↔ overture b292d636-3620-4d64-8997-fefe902abd6asame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 0a363982-0a12-487a-b90f-b673f6b8657b ↔ ubereats xYGW0AOpVVST5v03Y-oHiAsame address and namemerged11
2026-11-06 18:13insertdoordash 30934920 ↔ overture 0a363982-0a12-487a-b90f-b673f6b8657bsame address and namemerged11
2026-11-04 18:12backfilldoordash 30934920 ↔ ubereats xYGW0AOpVVST5v03Y-oHiAsame address and namemerged