Match tracker
HILTON SAN FRANCISCO UNION SQUARE
ca-abc · 333 OFARRELL ST, SAN FRANCISCO, CA, 94102
Trace another record of this outlet: ab-inbevca-abcca-abcca-abc ✓ca-abcca-abcca-abcca-abcca-abcca-abcca-abcoverturevtinfo
Joined with 12 other record(s) — by address+name, name-contained, premises-id.
1. Record ready
What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ Name: HILTON SAN FRANCISCO UNION SQUARE✓ Street with a house number: 333 OFARRELL ST✓ ZIP: 94102✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.78612, -122.40987✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
12 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
6 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| vtinfo HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 88 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
| overture Hilton San Francisco Union Square 333 Ofarrell St, San Francisco, CA, 94102 | 88 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 89 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
12 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
6 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| vtinfo HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 88 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
| overture Hilton San Francisco Union Square 333 Ofarrell St, San Francisco, CA, 94102 | 88 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 89 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
4. Street spelling found, not joined
Same house number, street written differently?
6 found (4 from another source); none joined by this step
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc INN AT THE OPERA 333 FULTON ST, SAN FRANCISCO, CA, 94102 | 1.4 km | same source — different name: never merged within one source | not joined |
| ca-abc INN AT THE OPERA 333 FULTON ST, SAN FRANCISCO, CA, 94102 | 1.4 km | same source — different name: never merged within one source | not joined |
| overture Inn at the Opera 333 Fulton St, San Francisco, CA, 94102 | 1.4 km | street-variant rule: does not pass | not joined |
| vtinfo PLAJ RESTAURANT 333 FULTON ST, SAN FRANCISCO, CA, 94102 | 1.4 km | street-variant rule: does not pass | not joined |
| vtinfo INN AT THE OPERA 333 FULTON ST, SAN FRANCISCO, CA, 94102 | 1.4 km | street-variant rule: does not pass | not joined |
| doordash boisson san francisco 333 Hayes Street, San Francisco, CA, 94102 | 1.5 km | 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 |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
33 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| vtinfo HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 88 m | stratum same-address | joined (name-contained) |
| overture Hilton San Francisco Union Square 333 Ofarrell St, San Francisco, CA, 94102 | 88 m | stratum addr-agree | joined (address+name) |
| ab-inbev HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 89 m | stratum same-address | joined (name-contained) |
| doordash black sugar san francisco 320 O'Farrell Street, San Francisco, CA, 94102 | 23 m | stratum none | not joined |
| ca-abc FREDS LIQUORS 300 MASON ST, SAN FRANCISCO, CA, 94102 | 27 m | same source — different name: never merged within one source | not joined |
| ca-abc OMA SUSHI 330 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 32 m | same source — different name: never merged within one source | not joined |
| doordash oma sushi san francisco 330 O'Farrell Street, San Francisco, CA, 94102 | 37 m | stratum none | not joined |
| overture Oma Sushi 330 O'Farrell St, San Francisco, CA, 94102 | 38 m | stratum control | not joined |
| ca-abc CAFE MASON 320 MASON ST, SAN FRANCISCO, CA, 94102 | 44 m | same source — different name: never merged within one source | not joined |
| ubereats Union Square Pizza & Kitchen 284 O'Farrell Street, San Francisco, CA, 94102 | 44 m | stratum none | not joined |
| doordash the halal guys san francisco 336 O'Farrell Street, San Francisco, CA, 94102 | 47 m | stratum none | not joined |
| overture Union Square Pizza & Kitchen 284 Ofarrell St, San Francisco, CA, 94102 | 49 m | stratum none | not joined |
| overture The Halal Guys 336 O'Farrell St, San Francisco, CA, 94102 | 50 m | stratum control | not joined |
| vtinfo FREDS LIQUOR & DELI 300 MASON ST, SAN FRANCISCO, CA, 94102 | 53 m | stratum control | not joined |
| ca-abc KING GEORGE HOTEL 334 MASON ST, SAN FRANCISCO, CA, 94102 | 68 m | same source — different name: never merged within one source | not joined |
| overture King George Hotel 334 Mason St, San Francisco, CA, 94102 | 73 m | stratum control | not joined |
| ca-abc HOTEL NIKKO 222 MASON ST, SAN FRANCISCO, CA, 94102 | 74 m | same source — different name: never merged within one source | not joined |
| ca-abc HOTEL NIKKO 222 MASON ST, SAN FRANCISCO, CA, 94102 | 74 m | same source — different name: never merged within one source | not joined |
| ca-abc HOTEL NIKKO 222 MASON ST, SAN FRANCISCO, CA, 94102 | 74 m | same source — different name: never merged within one source | not joined |
| ca-abc HOTEL NIKKO 222 MASON ST, SAN FRANCISCO, CA, 94102 | 74 m | same source — different name: never merged within one source | not joined |
| doordash mastro's restaurants san francisco 336 Mason Street, San Francisco, CA, 94102 | 78 m | stratum none | not joined |
| overture CVS 399 Geary St Ste B, San Francisco, CA, 94102 | 91 m | stratum control | not joined |
| toast Toni Rembe Theatre 415 Geary Street, San Francisco, CA, 94102 | 94 m | stratum control | not joined |
| ca-abc MAGNIN STREET CAFE & BISTRO 138 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102 | 94 m | same source — different name: never merged within one source | not joined |
| overture Miyabiya Sushi and Grill 115 Cyril Magnin St, San Francisco, CA, 94102 | 95 m | stratum control | not joined |
| vtinfo THE CURRAN THEATER 445 GEARY ST, SAN FRANCISCO, CA, 94102 | 96 m | stratum control | not joined |
| overture Johnny Foley's Irish House 243 O'Farrell St, San Francisco, CA, 94102 | 98 m | stratum control | not joined |
| doordash amazing kitchen san francisco 101 Cyril Magnin St, San Francisco, CA, 94102 | 98 m | stratum none | not joined |
| vtinfo AMERICAN CONSERVATORY THEATRE 413 GEARY ST, SAN FRANCISCO, CA, 94102 | 98 m | stratum control | not joined |
| overture Pinecrest Diner 401 Geary St, San Francisco, CA, 94102 | 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 12 other record(s)
Outlet O0c632e6a22d1: 13 record(s) from ab-inbev, ca-abc, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
6 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| ca-abc HILTON SAN FRANCISCO UNION SQUARE 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 0 m | same source — identical name: a duplicate listing | same outlet (through another record) |
| vtinfo HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 88 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
| overture Hilton San Francisco Union Square 333 Ofarrell St, San Francisco, CA, 94102 | 88 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev HILTON 333 OFARRELL ST, SAN FRANCISCO, CA, 94102 | 89 m | address+name rule: does not pass (name similarity 0.25) | joined (name-contained) |
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.