Match tracker

HILTON SAN FRANCISCO UNION SQUARE
ca-abc · 333 OFARRELL ST, SAN FRANCISCO, CA, 94102
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
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
6 more
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
vtinfo HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
88 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
89 maddress+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
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
6 more
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
vtinfo HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
88 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
89 maddress+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
RecordDistanceWhat the rule saysWhat the master did
ca-abc INN AT THE OPERA
333 FULTON ST, SAN FRANCISCO, CA, 94102
1.4 kmsame source — different name: never merged within one sourcenot joined
ca-abc INN AT THE OPERA
333 FULTON ST, SAN FRANCISCO, CA, 94102
1.4 kmsame source — different name: never merged within one sourcenot joined
overture Inn at the Opera
333 Fulton St, San Francisco, CA, 94102
1.4 kmstreet-variant rule: does not passnot joined
vtinfo PLAJ RESTAURANT
333 FULTON ST, SAN FRANCISCO, CA, 94102
1.4 kmstreet-variant rule: does not passnot joined
vtinfo INN AT THE OPERA
333 FULTON ST, SAN FRANCISCO, CA, 94102
1.4 kmstreet-variant rule: does not passnot joined
doordash boisson san francisco
333 Hayes Street, San Francisco, CA, 94102
1.5 kmstreet-variant rule: does not passnot 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.
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
33 more
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
vtinfo HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
88 mstratum same-addressjoined (name-contained)
overture Hilton San Francisco Union Square
333 Ofarrell St, San Francisco, CA, 94102
88 mstratum addr-agreejoined (address+name)
ab-inbev HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
89 mstratum same-addressjoined (name-contained)
ca-abc FREDS LIQUORS
300 MASON ST, SAN FRANCISCO, CA, 94102
27 msame source — different name: never merged within one sourcenot joined
ca-abc OMA SUSHI
330 OFARRELL ST, SAN FRANCISCO, CA, 94102
32 msame source — different name: never merged within one sourcenot joined
doordash oma sushi san francisco
330 O'Farrell Street, San Francisco, CA, 94102
37 mstratum nonenot joined
overture Oma Sushi
330 O'Farrell St, San Francisco, CA, 94102
38 mstratum controlnot joined
ab-inbev FREDS LIQUOR & DELI
300 MASON ST, SAN FRANCISCO, CA, 94102
43 mstratum controlnot joined
ca-abc CAFE MASON
320 MASON ST, SAN FRANCISCO, CA, 94102
44 msame source — different name: never merged within one sourcenot joined
ubereats Union Square Pizza & Kitchen
284 O'Farrell Street, San Francisco, CA, 94102
44 mstratum nonenot joined
overture Union Square Pizza & Kitchen
284 Ofarrell St, San Francisco, CA, 94102
49 mstratum nonenot joined
overture The Halal Guys
336 O'Farrell St, San Francisco, CA, 94102
50 mstratum controlnot joined
ab-inbev HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
50 mstratum controlnot joined
vtinfo FREDS LIQUOR & DELI
300 MASON ST, SAN FRANCISCO, CA, 94102
53 mstratum controlnot joined
overture Mason Diner (Cafe Mason)
320 Mason St, San Francisco, CA, 94102
56 mstratum controlnot joined
vtinfo HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
61 mstratum controlnot joined
overture King George Hotel
334 Mason St, San Francisco, CA, 94102
73 mstratum controlnot joined
ca-abc HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
74 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
74 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
74 msame source — different name: never merged within one sourcenot joined
ca-abc HOTEL NIKKO
222 MASON ST, SAN FRANCISCO, CA, 94102
74 msame source — different name: never merged within one sourcenot joined
doordash mastro's restaurants san francisco
336 Mason Street, San Francisco, CA, 94102
78 mstratum nonenot joined
vtinfo PINECREST RESTAURANT
401 GEARY ST, SAN FRANCISCO, CA, 94102
86 mstratum controlnot joined
overture CVS
399 Geary St Ste B, San Francisco, CA, 94102
91 mstratum controlnot joined
doordash kusina ni tess san francisco
237 Ellis Street, San Francisco, CA, 94102
94 mstratum nonenot joined
toast Toni Rembe Theatre
415 Geary Street, San Francisco, CA, 94102
94 mstratum controlnot joined
overture Miyabiya Sushi and Grill
115 Cyril Magnin St, San Francisco, CA, 94102
95 mstratum controlnot joined
vtinfo THE CURRAN THEATER
445 GEARY ST, SAN FRANCISCO, CA, 94102
96 mstratum controlnot joined
overture Johnny Foley's Irish House
243 O'Farrell St, San Francisco, CA, 94102
98 mstratum controlnot joined
overture Pinecrest Diner
401 Geary St, San Francisco, CA, 94102
99 mstratum controlnot 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.
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingjoined (premises-id)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
6 more
RecordDistanceWhat the rule saysWhat the master did
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
ca-abc HILTON SAN FRANCISCO UNION SQUARE
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
0 msame source — identical name: a duplicate listingsame outlet (through another record)
vtinfo HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
88 maddress+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 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev HILTON
333 OFARRELL ST, SAN FRANCISCO, CA, 94102
89 maddress+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.