Match tracker
ROADSIDE ROSY'S
ca-abc · 1018 COLUMBUS AVE, SAN FRANCISCO, CA, 94133
Joined with 2 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: ROADSIDE ROSY'S✓ Street with a house number: 1018 COLUMBUS AVE✓ ZIP: 94133✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.80377, -122.41509✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
2 found (2 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Roadside Rosy's Liquor Grocery and Deli 1018 Columbus Ave, San Francisco, CA, 94133 | 24 m | address+name rule: passes (name similarity 0.49) | joined (address+name) |
| vtinfo ROADSIDE ROSYS 1018 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 26 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 (2 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Roadside Rosy's Liquor Grocery and Deli 1018 Columbus Ave, San Francisco, CA, 94133 | 24 m | address+name rule: passes (name similarity 0.49) | joined (address+name) |
| vtinfo ROADSIDE ROSYS 1018 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 26 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?
26 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 |
|---|---|---|---|
| overture Roadside Rosy's Liquor Grocery and Deli 1018 Columbus Ave, San Francisco, CA, 94133 | 24 m | stratum addr-agree | joined (address+name) |
| vtinfo ROADSIDE ROSYS 1018 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 26 m | stratum addr-agree | joined (address+name) |
| ca-abc BIMBOS 365 CLUB 1025 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 13 m | same source — different name: never merged within one source | not joined |
| overture International Cocktail Lounge 1000 Columbus Ave, San Francisco, CA, 94133 | 13 m | stratum control | not joined |
| vtinfo INTERNATIONAL COCKTAIL 1000 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 14 m | stratum control | not joined |
| doordash pats cafe san francisco 2330 Taylor Street, San Francisco, CA, 94133 | 24 m | stratum control | not joined |
20 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc INTERNATIONAL COCKTAIL 1000 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 24 m | same source — different name: never merged within one source | not joined |
| ca-abc PAT'S CAFE INC. 2330 TAYLOR ST, SAN FRANCISCO, CA, 94133 | 28 m | same source — different name: never merged within one source | not joined |
| overture Pat's Cafe 2330 Taylor St, San Francisco, CA, 94133 | 33 m | stratum control | not joined |
| vtinfo BIMBOS 365 CLUB 1025 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 33 m | stratum control | not joined |
| overture Bimbo's 365 Club 1025 Columbus Ave, San Francisco, CA, 94133 | 45 m | stratum control | not joined |
| ttb UNLISTED WINE CO. LLC 2350 TAYLOR ST UNIT 1, SAN FRANCISCO, CA, 94133 | 58 m | stratum control | not joined |
| ca-abc UNLISTED WINE CO. 2350 TAYLOR ST, SAN FRANCISCO, CA, 94133 | 58 m | same source — different name: never merged within one source | not joined |
| ca-abc UNLISTED WINE CO. 2350 TAYLOR ST, SAN FRANCISCO, CA, 94133 | 58 m | same source — different name: never merged within one source | not joined |
| overture La Rocca's Corner 957 Columbus Ave, San Francisco, CA, 94133 | 63 m | stratum control | not joined |
| ca-abc RRC WINES 79 WATER ST, SAN FRANCISCO, CA, 94133 | 64 m | same source — different name: never merged within one source | not joined |
| ca-abc RRC WINES 79 WATER ST, SAN FRANCISCO, CA, 94133 | 64 m | same source — different name: never merged within one source | not joined |
| ttb RRC GLOBAL 79 WATER ST, SAN FRANCISCO, CA, 94133 | 64 m | stratum control | not joined |
| vtinfo THE LOST CHURCH 988 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 72 m | stratum control | not joined |
| ca-abc THELOSTCHURCH.ORG INC. 665 CHESTNUT ST BASEMENT & 990 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 76 m | same source — different name: never merged within one source | not joined |
| ab-inbev LA ROCCAS CORNER 957 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 76 m | stratum control | not joined |
| vtinfo LA ROCCAS CORNER 957 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 80 m | stratum control | not joined |
| overture The Lost Church 988 Columbus Ave, San Francisco, CA, 94133 | 84 m | stratum control | not joined |
| overture Curry Leaf 943 Columbus Ave, San Francisco, CA, 94133 | 89 m | stratum control | not joined |
| ca-abc LA ROCCAS CORNER 957 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 90 m | same source — different name: never merged within one source | not joined |
| doordash curry leaf san francisco 943 Columbus Avenue, San Francisco, CA, 94133 | 92 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 O379b3f8ac15a: 3 record(s) from ca-abc, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Roadside Rosy's Liquor Grocery and Deli 1018 Columbus Ave, San Francisco, CA, 94133 | 24 m | address+name rule: passes (name similarity 0.49) | joined (address+name) |
| vtinfo ROADSIDE ROSYS 1018 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | 26 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.