Match tracker
WAL MART STORE 1574
ca-abc · 6225 COLONY ST, BAKERSFIELD, CA, 93307
Joined with 5 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: WAL MART STORE 1574✓ Street with a house number: 6225 COLONY ST✓ ZIP: 93307✓ City + state: BAKERSFIELD, CA✓ Pin (lat/lng): 35.29632, -119.02734✗ Phone
2. Address joined
Is anyone else at this street + ZIP?
6 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc WAL MART STORE 1574 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 36 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
| walmart-stores Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 325 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
| doordash wetzel's pretzels bakersfield 6225 Colony St, Bakersfield, CA, 93307 | 326 m | address+name rule: does not pass (name similarity 0.17) | not joined |
3. City key joined
Anyone at this street in this city (no ZIP needed)?
6 found (5 from another source); joined
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc WAL MART STORE 1574 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 36 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
| walmart-stores Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 325 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
| doordash wetzel's pretzels bakersfield 6225 Colony St, Bakersfield, CA, 93307 | 326 m | address+name rule: does not pass (name similarity 0.17) | 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?
22 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 WAL MART STORE 1574 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 36 m | stratum near | same outlet (through another record) |
| overture Los Taqueiros 2300 Panama Ln, Bakersfield, CA, 93307 | 12 m | stratum control | not joined |
| vtinfo SHELL 2300 PANAMA LN, BAKERSFIELD, CA, 93307 | 26 m | stratum control | not joined |
| doordash los taqueiros bakersfield 2300 Panama Ln, Bakersfield, CA, 93307 | 30 m | stratum control | not joined |
| overture Shell 2300 Panama Ln, Bakersfield, CA, 93307 | 33 m | stratum control | not joined |
16 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| shell Shell 2300 PANAMA LN, BAKERSFIELD, CA, 93307 | 35 m | stratum control | not joined |
| ca-abc PANAMA COLONY SHELL 2300 PANAMA LN, BAKERSFIELD, CA, 93307 | 43 m | same source — different name: never merged within one source | not joined |
| overture Panda Express 2200 Panama Ln, Bakersfield, CA, 93307 | 49 m | stratum control | not joined |
| ca-abc BASHAAR CHEVRON 2301 PANAMA LN, BAKERSFIELD, CA, 93307 | 56 m | same source — different name: never merged within one source | not joined |
| ubereats Panda Express 2200 Panama Lane, Bakersfield, CA, 93304 | 61 m | stratum control | not joined |
| doordash panda express bakersfield 2200 Panama Lane, Bakersfield, CA | 63 m | stratum control | not joined |
| ab-inbev SHELL 2300 PANAMA LN, BAKERSFIELD, CA, 93307 | 69 m | stratum control | not joined |
| overture Jack in the Box 2221 Panama Ln, Bakersfield, CA, 93307 | 88 m | stratum control | not joined |
| overture Chevron 2301 Panama Ln, Bakersfield, CA, 93307 | 89 m | stratum control | not joined |
| overture El Taco Loco 2301 Panama Ln, Bakersfield, CA, 93307 | 89 m | stratum control | not joined |
| overture Wendy's 2150 Panama Lane, Bakersfield, CA, 93307 | 91 m | stratum control | not joined |
| vtinfo CHEVRON 2301 PANAMA LN, BAKERSFIELD, CA, 93307 | 93 m | stratum control | not joined |
| doordash wendy's bakersfield 2150 Panama Lane, Bakersfield, CA, 93307 | 93 m | stratum control | not joined |
| doordash el taco loco bakersfield 2301 Panama Lane, Bakersfield, CA, 93307 | 94 m | stratum control | not joined |
| ubereats Wendy's 2150 Panama Lane, Bakersfield, CA, 93307 | 96 m | stratum control | not joined |
| ubereats Jack in the Box 2221 Panama Ln, Bakersfield, CA, 93307 | 96 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 5 other record(s)
Outlet O317c85a6f1df: 6 record(s) from ab-inbev, ca-abc, overture, vtinfo, walmart-stores.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ca-abc WAL MART STORE 1574 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 0 m | same source — identical name: a duplicate listing | joined (premises-id) |
| ab-inbev WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 36 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
| walmart-stores Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Walmart 6225 Colony St, Bakersfield, CA, 93307 | 309 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| vtinfo WALMART SUPERCENTER 6225 COLONY ST, BAKERSFIELD, CA, 93307 | 325 m | address+name rule: does not pass (name similarity 0.52) | same outlet (through another record) |
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.