Match tracker
OFARRELL LIQUORS
ab-inbev · 405 OFARRELL ST, SAN FRANCISCO, CA, 94102
Joined with 4 other record(s) — by address+name.
1. Record ready
What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: OFARRELL LIQUORS✓ Street with a house number: 405 OFARRELL ST✓ ZIP: 94102✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.78583, -122.41222✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
4 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| doordash o'farrell liquor san francisco 405 O'Farrell Street, San Francisco, CA, 94102 | 62 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture O'Farrell Liquors 405 O'Farrell St, San Francisco, CA, 94102 | 66 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 69 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)?
4 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| doordash o'farrell liquor san francisco 405 O'Farrell Street, San Francisco, CA, 94102 | 62 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture O'Farrell Liquors 405 O'Farrell St, San Francisco, CA, 94102 | 66 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 69 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
4. Street spelling found, not joined
Same house number, street written differently?
2 found (2 from another source); none joined by this step
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo HOTEL SPERO 405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 63 m | street-variant rule: does not pass | not joined |
| overture Hotel Serrano 405 Taylor St, San Francisco, CA, 94102 | 64 m | street-variant rule: does not pass | not joined |
5. Nearby pins found, not joined
Anyone within 100 m?
39 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 |
|---|---|---|---|
| vtinfo OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 61 m | stratum addr-agree | joined (address+name) |
| ttb WEST COAST WINE EXPORTS LLC 449 O'FARRELL ST APT 506, SAN FRANCISCO, CA, 94102 | 1 m | stratum control | not joined |
| ca-abc XPRESS MARKET INC 451 & 453 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 6 m | stratum control | not joined |
| ab-inbev XPRESS MARKET 498 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 33 m | same source — different name: never merged within one source | not joined |
| doordash marrakech moroccan restaurant san francisco 419 O'Farrell Street, San Francisco, CA, 94102 | 42 m | stratum control | not joined |
| doordash el mariachi sf san francisco 345 Taylor St, San Francisco, CA, 94102 | 53 m | stratum control | not joined |
33 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| doordash le carousel patisserie san francisco 345 Taylor St, San Francisco, CA, 94102 | 53 m | stratum control | not joined |
| ubereats Fire Ass Thai by Million Thai Restaurant 385 Taylor St, San Francisco, CA, 94102 | 61 m | stratum control | not joined |
| vtinfo TILDEN HOTEL 345 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 62 m | stratum control | not joined |
| vtinfo HOTEL SPERO 405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 63 m | stratum control | not joined |
| overture Tilden Hotel 345 Taylor St, San Francisco, CA, 94102 | 63 m | stratum control | not joined |
| overture Hotel Serrano 405 Taylor St, San Francisco, CA, 94102 | 64 m | stratum control | not joined |
| overture Khun Mae Thai Noodles 385 Taylor St, San Francisco, CA, 94102 | 67 m | stratum control | not joined |
| ca-abc BOURBON AND BRANCH 501-503-505 JONES ST, SAN FRANCISCO, CA, 94102 | 74 m | stratum control | not joined |
| overture Le Carousel Patisserie at Tilden 345 Taylor St, San Francisco, CA, 94102 | 74 m | stratum control | not joined |
| ca-abc MILLION THAI 385 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 75 m | stratum control | not joined |
| overture Red Chilli 522 Jones St, San Francisco, CA, 94102 | 76 m | stratum control | not joined |
| ca-abc HOTEL SPERO 403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 76 m | stratum control | not joined |
| ca-abc HOTEL SPERO 403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 76 m | stratum control | not joined |
| ca-abc HOTEL SPERO 403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 76 m | stratum control | not joined |
| ca-abc HOTEL SPERO 403-405 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 76 m | stratum control | not joined |
| ca-abc NAPA VALLEY WINERY EXCHANGE 415 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 78 m | stratum control | not joined |
| ca-abc OX & TIGER 552 JONES ST, SAN FRANCISCO, CA, 94102 | 79 m | stratum control | not joined |
| ubereats Shalimar Restaurant 532 Jones Street, San Francisco, CA, 94102 | 82 m | stratum control | not joined |
| doordash pakwan restaurant san francisco 501 O'Farrell Street, San Francisco, CA, 94102 | 82 m | stratum control | not joined |
| overture Pakwan 501 O'Farrell St, San Francisco, CA, 94102 | 83 m | stratum control | not joined |
| vtinfo ZOMBIE VILLAGE 441 JONES ST, SAN FRANCISCO, CA, 94102 | 84 m | stratum control | not joined |
| overture The Zombie Village 441 Jones St, San Francisco, CA, 94102 | 85 m | stratum control | not joined |
| ab-inbev YOUNG ELLIS PRODUCE 398 ELLIS ST, SAN FRANCISCO, CA, 94102 | 86 m | same source — different name: never merged within one source | not joined |
| overture Bourbon and Branch 501 Jones St, San Francisco, CA, 94102 | 89 m | stratum control | not joined |
| ca-abc TILDEN HOTEL 345 TAYLOR ST, SAN FRANCISCO, CA, 94102 | 90 m | stratum control | not joined |
| vtinfo SWIG 561 GEARY ST, SAN FRANCISCO, CA, 94102 | 93 m | stratum control | not joined |
| ubereats Blue Earth South Indian 511 Jones St, San Francisco, CA, 94102 | 94 m | stratum control | not joined |
| doordash cargado arriba san francisco 345 Taylor St, San Francisco, CA | 95 m | stratum control | not joined |
| doordash dirty burger san francisco 345 Taylor St, San Francisco, CA | 95 m | stratum control | not joined |
| doordash leadoff breakfast burrito san francisco 345 Taylor St, San Francisco, CA | 95 m | stratum control | not joined |
| doordash million thai san francisco 385 Taylor Street, San Francisco, CA, 94102 | 96 m | stratum control | not joined |
| vtinfo YOUNG ELLIS PRODUCE 398 ELLIS ST, SAN FRANCISCO, CA, 94102 | 96 m | stratum control | not joined |
| ubereats Le Carousel Patisserie At Tilden 345 Taylor Street, San Francisco, CA, 94102 | 97 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 4 other record(s)
Outlet O127427365e44: 5 record(s) from ab-inbev, ca-abc, doordash, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| vtinfo OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 61 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| doordash o'farrell liquor san francisco 405 O'Farrell Street, San Francisco, CA, 94102 | 62 m | address+name rule: passes (name similarity 0.65) | joined (address+name) |
| overture O'Farrell Liquors 405 O'Farrell St, San Francisco, CA, 94102 | 66 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ca-abc OFARRELL LIQUORS 405 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 69 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.