Match tracker
TOTAL WINE & MORE
ca-abc · 1750 HARRISON ST, SAN FRANCISCO, CA, 94103
Joined with 7 other record(s) — by address+name, premises-id.
1. Record ready
What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: TOTAL WINE & MORE✓ Street with a house number: 1750 HARRISON ST✓ ZIP: 94103✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.76906, -122.41350✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
7 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ubereats Total Wine & More 1750 Harrison Street, San Francisco, CA, 94103 | 47 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| totalwine Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
1 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
7 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ubereats Total Wine & More 1750 Harrison Street, San Francisco, CA, 94103 | 47 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| totalwine Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
1 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
4. Street spelling nothing found
Same house number, street written differently?
no other record found
5. Nearby pins found, not joined
Anyone within 100 m?
13 within 100 m — distance alone never merges; these are questions for Claude
Pins are often geocoded from the address itself, so two pins agree whenever the addresses do — they cannot confirm a match, and never merge on their own.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ubereats Total Wine & More 1750 Harrison Street, San Francisco, CA, 94103 | 47 m | stratum addr-agree | joined (address+name) |
| totalwine Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | stratum addr-agree | joined (address+name) |
| overture Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | stratum addr-agree | joined (address+name) |
| ab-inbev TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | stratum addr-agree | joined (address+name) |
7 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | stratum addr-agree | joined (address+name) |
| doordash el tonayense san francisco 1719 Harrison St, San Francisco, CA, 94103 | 27 m | stratum control | not joined |
| overture El Tonayense 1719 Harrison St, San Francisco, CA, 94103 | 29 m | stratum control | not joined |
| ubereats Best Buy 1717 Harrison St, San Francisco, CA, 94103 | 41 m | stratum control | not joined |
| ca-abc SUE MILLS INC 1830 HARRISON ST, SAN FRANCISCO, CA, 94103 | 69 m | same source — different name: never merged within one source | not joined |
| overture Best Buy 1717 Harrison St, San Francisco, CA, 94103 | 74 m | stratum control | not joined |
| doordash best buy san francisco 1717 Harrison Street, San Francisco, CA, 94103 | 79 m | stratum control | not joined |
6. Claude judge nothing found
What did Claude's judge say?
no judgement on these pairs
Haiku screens every candidate pair; only Opus judge
claude-opus-5-5:v12:low can merge, at confidence ≥ 0.8, with a numbered street on both sides.7. Web agent nothing found
What did the web agent find?
not asked
8. Person nothing found
What did a person answer?
no answers yet
9. Result joined
Where did it end up?
one outlet with 7 other record(s)
Outlet O2109079e6b95: 8 record(s) from ab-inbev, ca-abc, overture, totalwine, ubereats, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ubereats Total Wine & More 1750 Harrison Street, San Francisco, CA, 94103 | 47 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| totalwine Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Total Wine & More 1750 Harrison St, San Francisco, CA, 94103 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
1 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo TOTAL WINE & MORE 1750 HARRISON ST, SAN FRANCISCO, CA, 94103 | 63 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
Read-only. Every candidate is scored by the same code the master build uses, and "what the master did" is what the last build stored. Each search shows at most 40 records.