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 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)
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 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)
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 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)
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)
overture Hilton San Francisco Union Square
333 Ofarrell St, San Francisco, CA, 94102
88 mstratum addr-agreejoined (address+name)
doordash black sugar san francisco
320 O'Farrell Street, San Francisco, CA, 94102
23 mstratum nonenot joined
overture Black Sugar
320 O'Farrell St, San Francisco, CA, 94102
30 mstratum controlnot 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
ca-abc UNION SQUARE PIZZA & KITCHEN
284 O'FARRELL ST, SAN FRANCISCO, CA, 94102
44 msame source — different name: never merged within one sourcenot joined
doordash the halal guys san francisco
336 O'Farrell Street, San Francisco, CA, 94102
47 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
overture Fred's Liquor Store
300 Mason St, San Francisco, CA, 94102
51 mstratum controlnot joined
doordash showcase flowers san francisco
325 Mason Street, San Francisco, CA, 94102
52 mstratum nonenot joined
overture Mason Diner (Cafe Mason)
320 Mason St, San Francisco, CA, 94102
56 mstratum controlnot joined
doordash gong cha us san francisco
272 O'Farrell Street, San Francisco, CA, 94102
63 mstratum nonenot joined
ca-abc KING GEORGE HOTEL
334 MASON ST, SAN FRANCISCO, CA, 94102
68 msame source — different name: never merged within one sourcenot 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
overture CVS
399 Geary St Ste B, San Francisco, CA, 94102
91 mstratum controlnot joined
ca-abc MAGNIN STREET CAFE & BISTRO
138 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102
94 msame source — different name: never merged within one sourcenot joined
ubereats Mastro's Steakhouse
399 Geary St, San Francisco, CA, 94102
95 mstratum controlnot joined
overture Miyabiya Sushi and Grill
115 Cyril Magnin St, San Francisco, CA, 94102
95 mstratum controlnot joined
overture Johnny Foley's Irish House
243 O'Farrell St, San Francisco, CA, 94102
98 mstratum controlnot joined
doordash amazing kitchen san francisco
101 Cyril Magnin St, San Francisco, CA, 94102
98 mstratum nonenot joined
vtinfo AMERICAN CONSERVATORY THEATRE
413 GEARY ST, SAN FRANCISCO, CA, 94102
98 mstratum controlnot joined
overture Pinecrest Diner
401 Geary St, San Francisco, CA, 94102
99 mstratum controlnot joined
vtinfo NEW DELHI RESTAURANT
160 ELLIS ST, SAN FRANCISCO, CA, 94102
100 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 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)
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.