Guerneville Road Shell

Santa Rosa, CA 95403 · O05958bba46f6 · first seen 2026-10-08
2 sourcesoff premisealcohol: 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.

FieldMaster valueTaken fromWhat other sources say
Name
Guerneville Road Shell 2 other
a licence name in capitals, cleaned (derived; record_title.py)
AU ENERGY LLC ca-abc (legal name)
GUERNEVILLE SHELL ca-abc
Street
2005 GUERNEVILLE RD
ca-abcno other value
City
SANTA ROSA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95403
ca-abcno other value
Pin
38.45285, -122.75182 map
overtureno other value
Phone
7075738322
overtureno other value
Licences
ca-abc 00534443|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9059a00c6fd5

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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ca-abcGUERNEVILLE SHELL
legal name: AU ENERGY LLC
00534443|20|LIC|0
2005 GUERNEVILLE RD, SANTA ROSA, CA, 9540338.45264, -122.751542026-10-082026-11-06
overtureGUERNEVILLE ROAD SHELL
7615daba-153c-4ed6-9e45-098775fd8ae0
2005 Guerneville Rd, Santa Rosa, CA, 95403707573832238.45285, -122.751822026-11-062026-11-06

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev SHELL FOOD MARTca-abc GUERNEVILLE SHELL0.34one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: bd2b8116480a6bb11041 · person: None · rule: names contained at one address · stratum: same-address
ca-abc GUERNEVILLE SHELLvtinfo SHELL FOOD MART0.34one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d35548362eadc76bfe24 · person: None · rule: names contained at one address · stratum: same-address
ca-abc GUERNEVILLE SHELLoverture GUERNEVILLE ROAD SHELL0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 33 m apart · name similarity 0.77

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
AU ENERGY LLC — 70 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
80 within 1 mi · 844 within 3 mi
Off / on premise
33 / 32 within 1 mi · 261 / 357 within 3 mi
Selling alcohol
59 within 1 mi · 598 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.04 mi
Setting
urban (3,726 people per sq mi)
People within 3 mi
105,353 (79,105 adults 21+, 38,679 households) from 22 tract(s), tracts within 3 mi
Income
per capita $44,457 · median household ~$94,689 (weighted mean of tract medians)
Age and education
median age ~39.7 · bachelor's or higher 27%
Ethnicity
Hispanic 43% · White 48% · Black 2% · Asian 6%
Adults per alcohol outlet
132
Alcohol spend within 3 mi
$28,686,344 a year ($12,944,904 at home, $15,727,943 away) · $47,890 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”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertab-inbev 2777290 ↔ ca-abc 00534443|20|LIC|0one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00534443|20|LIC|0 ↔ vtinfo 01e05251625c721aone name contains the other, same addressheld: same-source-conflict15
2026-11-06 18:13insertca-abc 00534443|20|LIC|0 ↔ overture 7615daba-153c-4ed6-9e45-098775fd8ae0same address and namemerged11