Match tracker
ORCHARD HOTEL THE
ca-abc · 665 BUSH ST, SAN FRANCISCO, CA, 94108
Joined with 2 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: ORCHARD HOTEL THE✓ Street with a house number: 665 BUSH ST✓ ZIP: 94108✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.79016, -122.40829✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
2 found (1 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ORCHARD HOTEL THE 665 BUSH ST, SAN FRANCISCO, CA, 94108 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture The Orchard Hotel 665 Bush St #1, San Francisco, CA, 94108 | 16 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)?
2 found (1 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ORCHARD HOTEL THE 665 BUSH ST, SAN FRANCISCO, CA, 94108 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture The Orchard Hotel 665 Bush St #1, San Francisco, CA, 94108 | 16 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?
at least 40 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 ORCHARD HOTEL THE 665 BUSH ST, SAN FRANCISCO, CA, 94108 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture The Orchard Hotel 665 Bush St #1, San Francisco, CA, 94108 | 16 m | stratum addr-agree | joined (address+name) |
| ca-abc EXECUTIVE HOTEL VINTAGE COURT SAN FRANCISCO 648-50 BUSH ST, SAN FRANCISCO, CA, 94108 | 20 m | same source — different name: never merged within one source | not joined |
| vtinfo LAST DROP TAVERN 550 POWELL ST, SAN FRANCISCO, CA, 94108 | 30 m | stratum control | not joined |
| doordash roxanne cafe san francisco 570 Powell St, San Francisco, CA | 30 m | stratum control | not joined |
| ubereats Last Drop Tavern 550 Powell St, San Francisco, CA, 94108 | 31 m | stratum control | not joined |
34 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Chelsea Place 641 Bush St, San Francisco, CA, 94108 | 33 m | stratum control | not joined |
| doordash last drop tavern san francisco 550 Powell St, San Francisco, CA | 35 m | stratum control | not joined |
| ca-abc PIRANESI LLC 570 POWELL ST, SAN FRANCISCO, CA, 94108 | 38 m | same source — different name: never merged within one source | not joined |
| ab-inbev LAST DROP TAVERN 550 POWELL ST, SAN FRANCISCO, CA, 94108 | 38 m | stratum control | not joined |
| overture Last Drop Tavern 550 Powell St, San Francisco, CA, 94108 | 39 m | stratum control | not joined |
| ca-abc LAST DROP TAVERN 550 POWELL ST, SAN FRANCISCO, CA, 94108 | 41 m | same source — different name: never merged within one source | not joined |
| ca-abc FAMILY THE 545 POWELL ST, SAN FRANCISCO, CA, 94108 | 54 m | same source — different name: never merged within one source | not joined |
| ab-inbev CHELSEA PLACE 641 BUSH ST, SAN FRANCISCO, CA, 94108 | 54 m | stratum control | not joined |
| vtinfo CHELSEA PLACE 641 BUSH ST, SAN FRANCISCO, CA, 94108 | 55 m | stratum control | not joined |
| overture Uncle Vito's Pizza 700 Bush St, San Francisco, CA, 94108 | 59 m | stratum control | not joined |
| doordash uncle vito's pizza san francisco 700 Bush Street, San Francisco, CA, 94108 | 62 m | stratum control | not joined |
| overture The Family 545 Powell St, San Francisco, CA, 94108 | 64 m | stratum control | not joined |
| vtinfo FAMILY THE 545 POWELL ST, SAN FRANCISCO, CA, 94108 | 65 m | stratum control | not joined |
| ubereats Sons & Daughters - 708 708 Bush St. San Francisco, CA | 67 m | stratum control | not joined |
| ca-abc HOTEL CORNELL/RESTAURANT JEANNE DARC 715 BUSH ST, SAN FRANCISCO, CA, 94108 | 68 m | same source — different name: never merged within one source | not joined |
| vtinfo MARRIOTT HOTELS & RESORTS 480 SUTTER ST, SAN FRANCISCO, CA, 94108 | 69 m | stratum control | not joined |
| doordash maru sushi san francisco 529 Powell Street, San Francisco, CA | 77 m | stratum control | not joined |
| overture Tunnel Top 601 Bush St, San Francisco, CA, 94108 | 79 m | stratum control | not joined |
| ab-inbev TUNNEL TOP 601 BUSH ST, SAN FRANCISCO, CA, 94108 | 80 m | stratum control | not joined |
| ab-inbev FOOD FAIR MKT 611 BUSH ST, SAN FRANCISCO, CA, 94108 | 80 m | stratum control | not joined |
| vtinfo BOUCHE 603 BUSH ST, SAN FRANCISCO, CA, 94108 | 89 m | stratum control | not joined |
| vtinfo LIQUOR & DELI ON UNION SQUARE 423 STOCKTON ST, SAN FRANCISCO, CA, 94108 | 90 m | stratum control | not joined |
| ubereats Liquor & Deli Union Square 423 Stockton St, San Francisco, CA, 94108 | 90 m | stratum control | not joined |
| ab-inbev MARRIOTT HOTELS & RESORTS 480 SUTTER ST, SAN FRANCISCO, CA, 94108 | 92 m | stratum control | not joined |
| ca-abc BOUCHE 603 BUSH ST, SAN FRANCISCO, CA, 94108 | 93 m | same source — different name: never merged within one source | not joined |
| ca-abc BOUCHE 603 BUSH ST, SAN FRANCISCO, CA, 94108 | 93 m | same source — different name: never merged within one source | not joined |
| ca-abc BOUCHE 603 BUSH ST, SAN FRANCISCO, CA, 94108 | 93 m | same source — different name: never merged within one source | not joined |
| ca-abc BOUCHE 603 BUSH ST, SAN FRANCISCO, CA, 94108 | 93 m | same source — different name: never merged within one source | not joined |
| doordash sutter street cafe san francisco 450 Sutter Street, San Francisco, CA | 93 m | stratum control | not joined |
| ca-abc MARRIOTT SF UNION SQUARE 480 SUTTER ST, SAN FRANCISCO, CA, 94108 | 93 m | same source — different name: never merged within one source | not joined |
| overture Taqueria Mana 439 Stockton St, San Francisco, CA, 94108 | 94 m | stratum control | not joined |
| doordash boba guys san francisco 429 Stockton Street, San Francisco, CA, 94108 | 96 m | stratum control | not joined |
| ca-abc TUNNEL TOP 601 BUSH ST, SAN FRANCISCO, CA, 94108 | 97 m | same source — different name: never merged within one source | not joined |
| vtinfo NOB HILL DELI 660 POWELL ST, SAN FRANCISCO, CA, 94108 | 99 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 2 other record(s)
Outlet O62618d807ab1: 3 record(s) from ca-abc, overture.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ORCHARD HOTEL THE 665 BUSH ST, SAN FRANCISCO, CA, 94108 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture The Orchard Hotel 665 Bush St #1, San Francisco, CA, 94108 | 16 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.