Outlets /
Heather-Farm Shell
WALNUT CREEK, CA 94598 · O893d148b0bd8 · first seen 2026-10-08
6 sourcesoff premise · conveniencechain: Shellalcohol: licensed1 licence
Golden record
One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Heather-Farm Shell 2 other | a licence name in capitals, cleaned (derived; record_title.py) | SHELL ab-inbevovertureshellvtinfo ×4 PETROMART RETAIL GROUP INC. ca-abc (legal name) |
| Street | 1790 YGNACIO VALLEY RD | shell | no other value |
| City | WALNUT CREEK | shell | no other value |
| State | CA | shell | no other value |
| ZIP | 94598 | shell | no other value |
| Pin | 37.91744, -122.03987 map | shell | no other value |
| Phone | 9259326196 | shell | no other value |
| Licences | ca-abc 00505352|20|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ofe39b926daf5; Od77ede1a5bb5; Oc5a9d87181b2; Oa004629697b6; Odab3328e3e14
Carries
Products seen on this outlet’s shelf in store-level catalogs.
No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.
Sources
Every source record folded into this outlet, as the source states it.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SHELL 2354442 | 1790 YGNACIO VALLEY RD, WALNUT CREEK, CA, 94598 | 37.91744, -122.03982 | 2026-11-11 | 2026-11-16 | |
| ca-abc | HEATHER-FARM SHELL legal name: PETROMART RETAIL GROUP INC. 00505352|20|LIC|0 | 1790 YGNACIO VALLEY RD, WALNUT CREEK, CA, 94598 | 37.91739, -122.03959 | 2026-10-08 | 2026-11-05 | |
| ca-tobacco | HEATHER-FARM SHELL ca-tobacco|091327246 | 1790 YGNACIO VALLEY RD, Walnut Creek, CA, 94598 | 2026-11-20 | 2026-11-20 | ||
| overture | Shell f47bec1f-dcdb-4fed-8b94-beec3c410e4e | 1790 Ygnacio Valley Rd, Walnut Creek, CA, 94598 | 9259326196 | 37.91740, -122.03989 | 2026-11-13 | 2026-11-16 |
| shell | Shell 10008434 | 1790 YGNACIO VALLEY RD, WALNUT CREEK, CA, 94598 | 9259326196 | 37.91744, -122.03987 | 2026-11-10 | 2026-11-16 |
| vtinfo | SHELL 2b946636a3bc775e | 1790 YGNACIO VALLEY RD, WALNUT CREEK, CA, 94598 | 9259326196 | 37.91758, -122.03993 | 2026-11-12 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SHELL | overture Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| ab-inbev SHELL | shell Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| ab-inbev SHELL | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 |
| ca-abc HEATHER-FARM SHELL | ca-tobacco HEATHER-FARM SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| overture Shell | shell Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 · phone: equal |
| overture Shell | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: equal |
| shell Shell | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00 · phone: equal |
| ab-inbev SHELL | ca-abc HEATHER-FARM SHELL | 0.38 | one name contains the other, same address | merged | judge: None · pair_id: 7eeb3ee87c7cf8a0a1b0 · person: None · rule: names contained at one address · stratum: same-address |
| ca-abc HEATHER-FARM SHELL | vtinfo SHELL | 0.38 | one name contains the other, same address | merged | judge: None · pair_id: 8d10804ad7efe0560b41 · person: None · rule: names contained at one address · stratum: same-address |
Attributes
- Channel
- off_premise · convenience — ca-licence
- Chain
- Shell — chain-locator
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- PETROMART RETAIL GROUP INC. — 13 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off — CA 20
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"chain-locator",
"off_premise",
"convenience"
],
[
"overture-category",
"off_premise",
"convenience"
]
]
}Trade area
- Other outlets
- 35 within 1 mi · 707 within 3 mi
- Off / on premise
- 6 / 25 within 1 mi · 157 / 453 within 3 mi
- Selling alcohol
- 21 within 1 mi · 446 within 3 mi
- Nearest
- same channel 0.07 mi · licensed 0.07 mi
- Setting
- urban (4,364 people per sq mi)
- People within 3 mi
- 123,391 (96,713 adults 21+, 51,407 households) from 28 tract(s), tracts within 3 mi
- Income
- per capita $73,376 · median household ~$142,785 (weighted mean of tract medians)
- Age and education
- median age ~41.2 · bachelor's or higher 60%
- Ethnicity
- Hispanic 20% · White 58% · Black 2% · Asian 16%
- Adults per alcohol outlet
- 216
- Alcohol spend within 3 mi
- $48,835,649 a year ($20,993,206 at home, $27,826,638 away) · $109,252 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.
History
Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | ca-abc 00505352|20|LIC|0 ↔ ca-tobacco ca-tobacco|091327246 | same address and name | merged | 17 |
| 2026-11-16 14:56 | insert | ca-abc 00505352|20|LIC|0 ↔ vtinfo 2b946636a3bc775e | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 2354442 ↔ ca-abc 00505352|20|LIC|0 | one name contains the other, same address | merged | 15 |
| 2026-11-13 14:10 | insert | overture f47bec1f-dcdb-4fed-8b94-beec3c410e4e ↔ vtinfo 2b946636a3bc775e | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2354442 ↔ overture f47bec1f-dcdb-4fed-8b94-beec3c410e4e | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture f47bec1f-dcdb-4fed-8b94-beec3c410e4e ↔ shell 10008434 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2354442 ↔ vtinfo 2b946636a3bc775e | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | shell 10008434 ↔ vtinfo 2b946636a3bc775e | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2354442 ↔ shell 10008434 | same address and name | merged | 12 |