Match tracker
WALMART SUPERCENTER #1903
ca-abc · 1150 HARTER RD, YUBA CITY, CA, 95993
Joined with 4 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: WALMART SUPERCENTER #1903✓ Street with a house number: 1150 HARTER RD✓ ZIP: 95993✓ City + state: YUBA CITY, CA✓ Pin (lat/lng): 39.14495, -121.65541✗ 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 WALMART SUPERCENTER #1903 1150 HARTER RD, YUBA CITY, CA, 95993 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 79 m | address+name rule: passes (name similarity 1.00) | joined (name-contained) |
| overture WALMART #001903 1150 Harter Rd, Yuba City, CA, 95993 | 122 m | address+name rule: passes (name similarity 0.58) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 160 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)?
4 found (3 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc WALMART SUPERCENTER #1903 1150 HARTER RD, YUBA CITY, CA, 95993 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 79 m | address+name rule: passes (name similarity 1.00) | joined (name-contained) |
| overture WALMART #001903 1150 Harter Rd, Yuba City, CA, 95993 | 122 m | address+name rule: passes (name similarity 0.58) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 160 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
4. Street spelling found, not joined
Same house number, street written differently?
1 found (1 from another source); none joined by this step
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| doordash mcdonald's yuba city 1150 Harter Parkway, Yuba City, CA, 95993 | 177 m | street-variant rule: does not pass | not joined |
5. Nearby pins found, not joined
Anyone within 100 m?
5 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 WALMART SUPERCENTER #1903 1150 HARTER RD, YUBA CITY, CA, 95993 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 79 m | stratum addr-agree | joined (name-contained) |
| ca-abc HARTER ROAD AMPM 1097 HARTER PKWY, YUBA CITY, CA, 95993 | 28 m | same source — different name: never merged within one source | not joined |
| vtinfo AMPM 1097 HARTER PKWY, YUBA CITY, CA, 95993 | 30 m | stratum control | not joined |
| ubereats Michaels 1120 Harter Rd, Yuba City, CA, 95993 | 70 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 mcdonald's yuba city 1150 Harter Parkway, Yuba City, CA, 95993 | claude-haiku-5-5:v4:medium: different (0.93) — The names are different businesses (Walmart Supercenter with an off-sale liquor licence versus a McDonald's storefront), so a shared street number and ZIP do not make them one outlet. claude-haiku-5-5:v7:medium: different (0.90) — Record A is a Walmart Supercenter liquor licence and record B is a McDonald's storefront; they are different businesses that at most share a building near the same coordinates, and the names do not agree. | 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 4 other record(s)
Outlet O71676559d934: 5 record(s) from ab-inbev, ca-abc, overture, vtinfo.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc WALMART SUPERCENTER #1903 1150 HARTER RD, YUBA CITY, CA, 95993 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 79 m | address+name rule: passes (name similarity 1.00) | joined (name-contained) |
| overture WALMART #001903 1150 Harter Rd, Yuba City, CA, 95993 | 122 m | address+name rule: passes (name similarity 0.58) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 1150 HARTER RD, YUBA CITY, CA, 95993 | 160 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.