Match tracker
ROCKS DEN
ca-abc · 4753 MISSION ST, SAN FRANCISCO, CA, 94112
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: ROCKS DEN✓ Street with a house number: 4753 MISSION ST✓ ZIP: 94112✓ City + state: SAN FRANCISCO, CA✓ Pin (lat/lng): 37.72224, -122.43655✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ROCKS DEN 4753 MISSION ST, SAN FRANCISCO, CA, 94112 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Rocks Den 4753 Mission St, San Francisco, CA, 94112 | 6 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Flats Burgers 4753 Mission St, San Francisco, CA, 94112 | 9 m | address+name rule: does not pass (name similarity 0.18) | not joined |
| doordash flats burgers san francisco 4753 Mission St, San Francisco, CA, 94112 | 13 m | address+name rule: does not pass (name similarity 0.18) | not joined |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
5 found (4 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ROCKS DEN 4753 MISSION ST, SAN FRANCISCO, CA, 94112 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Rocks Den 4753 Mission St, San Francisco, CA, 94112 | 6 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Flats Burgers 4753 Mission St, San Francisco, CA, 94112 | 9 m | address+name rule: does not pass (name similarity 0.18) | not joined |
| doordash flats burgers san francisco 4753 Mission St, San Francisco, CA, 94112 | 13 m | address+name rule: does not pass (name similarity 0.18) | not joined |
| doordash fryze san francisco 4753 Mission St, San Francisco, CA | 15 m | address+name rule: does not pass (name similarity 0.11) | not joined |
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?
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 ROCKS DEN 4753 MISSION ST, SAN FRANCISCO, CA, 94112 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Rocks Den 4753 Mission St, San Francisco, CA, 94112 | 6 m | stratum addr-agree | joined (address+name) |
| ab-inbev YICKS LIQUOR 4701 MISSION ST, SAN FRANCISCO, CA, 94112 | 8 m | stratum control | not joined |
| ab-inbev FRANKS MARKET & LIQUOR 4799 MISSION ST, SAN FRANCISCO, CA, 94112 | 8 m | stratum control | not joined |
| overture Flats Burgers 4753 Mission St, San Francisco, CA, 94112 | 9 m | stratum same-address | not joined |
| doordash flats burgers san francisco 4753 Mission St, San Francisco, CA, 94112 | 13 m | stratum same-address | not joined |
33 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| doordash fryze san francisco 4753 Mission St, San Francisco, CA | 15 m | stratum same-address | not joined |
| doordash calabria bros san francisco 4763 Mission Street, San Francisco, CA | 18 m | stratum control | not joined |
| ca-abc TUFO MICHAEL BIAGIO 4763 MISSION ST, SAN FRANCISCO, CA, 94112 | 18 m | same source — different name: never merged within one source | not joined |
| ubereats Calabria Bros 4763 Mission St, San Francisco, CA, 94112 | 26 m | stratum control | not joined |
| overture Pupuseria Metapan 4769 Mission St, San Francisco, CA, 94112 | 27 m | stratum control | not joined |
| doordash pupuseria metapan san francisco 4769 Mission Street, San Francisco, CA, 94112 | 28 m | stratum control | not joined |
| ubereats Pupuseria Metapan #1 4769 Mission Street, San Francisco, CA, 94112 | 29 m | stratum control | not joined |
| ca-abc PUPUSERIA METAPAN 4769 MISSION ST, SAN FRANCISCO, CA, 94112 | 29 m | same source — different name: never merged within one source | not joined |
| ubereats TS Cafe 4754 Mission Street, San Francisco, CA, 94112 | 48 m | stratum control | not joined |
| doordash ts cafe san francisco 4754 Mission Street, San Francisco, CA, 94112 | 50 m | stratum control | not joined |
| overture TS Cafe 4754 Mission St, San Francisco, CA, 94112 | 50 m | stratum control | not joined |
| doordash north beach pizza san francisco 4787 Mission Street, San Francisco, CA, 94112 | 57 m | stratum control | not joined |
| ubereats North Beach Pizza - Mission 4787 Mission St, San Francisco, CA, 94112 | 57 m | stratum control | not joined |
| ab-inbev CLUB BOTTOMS UP 4704 MISSION ST, SAN FRANCISCO, CA, 94112 | 57 m | stratum control | not joined |
| doordash mama maris taqueria san francisco 4791 Mission Street, San Francisco, CA, 94112 | 62 m | stratum control | not joined |
| ca-abc NORTH BEACH PIZZA 4787 MISSION ST, SAN FRANCISCO, CA, 94112 | 63 m | same source — different name: never merged within one source | not joined |
| ca-abc MAMA MARI'S TAQUERIA 4791 MISSION ST, SAN FRANCISCO, CA, 94112 | 70 m | same source — different name: never merged within one source | not joined |
| doordash restaurante el pastorsito san francisco 4780 Mission St, San Francisco, CA | 73 m | stratum control | not joined |
| overture Frank's Market & Liquors 4799 Mission St, San Francisco, CA, 94112 | 80 m | stratum control | not joined |
| doordash sandyy m american food san francisco 4780 Mission Street, San Francisco, CA, 94112 | 81 m | stratum control | not joined |
| vtinfo FRANKS MARKET & LIQUOR 4799 MISSION ST, SAN FRANCISCO, CA, 94112 | 81 m | stratum control | not joined |
| vtinfo ITALIAN AMER SOCIAL CLUB 25 RUSSIA AVE, SAN FRANCISCO, CA, 94112 | 83 m | stratum control | not joined |
| ca-abc FRANKS MARKET & LIQUOR 4799 MISSION ST A, SAN FRANCISCO, CA, 94112 | 85 m | same source — different name: never merged within one source | not joined |
| ca-abc CLUB BOTTOMS UP 4704 MISSION ST, SAN FRANCISCO, CA, 94112 | 86 m | same source — different name: never merged within one source | not joined |
| ca-abc CLUB BOTTOMS UP 4704 MISSION ST, SAN FRANCISCO, CA, 94112 | 86 m | same source — different name: never merged within one source | not joined |
| ca-abc ITALIAN AMERICAN SOCIAL CLUB OF S F 25 RUSSIA AVE, SAN FRANCISCO, CA, 94112 | 86 m | same source — different name: never merged within one source | not joined |
| vtinfo CLUB BOTTOMS UP 4704 MISSION ST, SAN FRANCISCO, CA, 94112 | 87 m | stratum control | not joined |
| ubereats Restaurante El Pastorsito 4780 Mission Street, San Francisco, CA, 94112 | 87 m | stratum control | not joined |
| overture Italian American Social Club 25 Russia Ave, San Francisco, CA, 94112 | 92 m | stratum control | not joined |
| ca-abc YICKS LIQUORS 4701 MISSION ST, SAN FRANCISCO, CA, 94112 | 93 m | same source — different name: never merged within one source | not joined |
| ab-inbev ITALIAN AMER SOCIAL CLUB 25 RUSSIA AVE, SAN FRANCISCO, CA, 94112 | 95 m | stratum control | not joined |
| vtinfo YICKS LIQUOR 4701 MISSION ST, SAN FRANCISCO, CA, 94112 | 96 m | stratum control | not joined |
| overture Yick's Liquors 4701 Mission St, San Francisco, CA, 94112 | 97 m | stratum control | not joined |
6. Claude judge found, not joined
What did Claude's judge say?
answered 1 pair(s)
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.| Pair with | Answer | What the master did |
|---|---|---|
| doordash flats burgers san francisco 4753 Mission St, San Francisco, CA, 94112 | claude-haiku-5-5:v4:medium: different (0.90) — Both records share the same street address and ZIP, but the names differ (ROCKS DEN, a licensed bar, versus Flats Burgers, a food store listing), and the address is shared by two businesses per the data, so the names must agree for SAME and claude-haiku-5-5:v7:medium: different (0.90) — Both records share 4753 Mission St, but the address is shared by two businesses (businesses_at_address is 2) and the names do not agree: ROCKS DEN holds a bar licence (on-sale public premises), while the DoorDash listing is a burger restaur claude-haiku-5-5:v9:medium: different (0.93) — Same street address, but the California licence is for ROCKS DEN, a bar/nightclub (on-sale public premises), while the DoorDash listing is for Flats Burgers, a separate business; the address is shared by two businesses (businesses_at_addres | not joined |
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 O1d2af645d4f9: 3 record(s) from ca-abc, overture.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc ROCKS DEN 4753 MISSION ST, SAN FRANCISCO, CA, 94112 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| overture Rocks Den 4753 Mission St, San Francisco, CA, 94112 | 6 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.