Opdyke Gas Station

Auburn Hills, MI 48326 · O150b24bf9458 · first seen 2026-11-03
5 sourcesoff premise · conveniencechain: Shellalcohol: licensed2 licences

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
Opdyke Gas Station 2 other
a licence name in capitals, cleaned (derived; record_title.py)
SHELL ab-inbevovertureshellvtinfo ×4
OPDYKE GAS STATION, INC. mi-lcc ×2
Street
200 N OPDYKE RD
shellno other value
City
AUBURN HILLS
shellno other value
State
MI
shellno other value
ZIP
48326
shellno other value
Pin
42.63871, -83.24927 map 1 other
shell
141 m away mi-lcc ×2
Phone
2483345327
shellno other value
Licences
mi-lcc L-000148258 · mi-lcc L-000241316
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O76f01ecf445f; O41d17363d5c7; O7d059bf5db36; O1b1ba991a4ee; O6ab9ab677f06

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
ab-inbevSHELL
2763410
200 N OPDYKE RD, AUBURN HILLS, MI, 4832642.63851, -83.249632026-11-112026-11-11
mi-lccOPDYKE GAS STATION, INC.
L-000148258
200 N Opdyke Rd, Auburn Hills, MI, 48326248334532742.63746, -83.249592026-11-032026-11-12
mi-lccOPDYKE GAS STATION, INC.
L-000241316
200 N Opdyke Rd, Auburn Hills, MI, 48326248334532742.63746, -83.249592026-11-032026-11-12
overtureShell
8c9a4b35-13af-4a57-b242-48072b858ef3
200 N Opdyke Rd, Auburn Hills, MI, 48326248334532742.63866, -83.249192026-11-132026-11-13
shellShell
12446641
200 N OPDYKE RD, AUBURN HILLS, MI, 48326248334532742.63871, -83.249272026-11-102026-11-10
vtinfoSHELL
4fe1c674d554c37b
200 N OPDYKE RD, AUBURN HILLS, MI, 48326248334532742.63871, -83.248912026-11-122026-11-13

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 SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
ab-inbev SHELLshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ab-inbev SHELLvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 63 m apart · name similarity 1.00
mi-lcc OPDYKE GAS STATION, INC.mi-lcc OPDYKE GAS STATION, INC.1.00one store listed twicemergedsame street + ZIP · name: identical
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 · phone: equal
overture Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 · phone: equal
shell Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLmi-lcc OPDYKE GAS STATION, INC.0.09Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Shell station and its gas station operator same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records sit at the same street address (about 0.12 km apart), and the only two differently named businesses at that address are these two, so the Shell brand listing most likely belongs to the gas station operator OPDYKE GAS STATION, INC.; the name link is inferred rather than explicit.
pair 484807348b469915abfb

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
OPDYKE GAS STATION, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
21 within 1 mi · 320 within 3 mi
Off / on premise
5 / 7 within 1 mi · 92 / 146 within 3 mi
Selling alcohol
16 within 1 mi · 177 within 3 mi
Nearest
same channel 0.73 mi · licensed 0.29 mi
Setting
suburban (2,087 people per sq mi)
People within 3 mi
59,020 (43,653 adults 21+, 24,239 households) from 19 tract(s), tracts within 3 mi
Income
per capita $33,684 · median household ~$61,647 (weighted mean of tract medians)
Age and education
median age ~38.1 · bachelor's or higher 30%
Ethnicity
Hispanic 20% · White 31% · Black 36% · Asian 7%
Adults per alcohol outlet
245
Alcohol spend within 3 mi
$13,074,618 a year ($6,232,011 at home, $6,835,807 away) · $73,453 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-13 14:10insertoverture 8c9a4b35-13af-4a57-b242-48072b858ef3 ↔ vtinfo 4fe1c674d554c37bsame address and namemerged15
2026-11-13 14:10insertoverture 8c9a4b35-13af-4a57-b242-48072b858ef3 ↔ shell 12446641same address and namemerged15
2026-11-13 14:10insertab-inbev 2763410 ↔ overture 8c9a4b35-13af-4a57-b242-48072b858ef3same address and namemerged15
2026-11-12 17:29insertab-inbev 2763410 ↔ mi-lcc L-000241316Claude judge: samemerged14
2026-11-12 14:25insertshell 12446641 ↔ vtinfo 4fe1c674d554c37bsame address and namemerged12
2026-11-12 14:25insertab-inbev 2763410 ↔ vtinfo 4fe1c674d554c37bsame address and namemerged12
2026-11-11 12:56insertab-inbev 2763410 ↔ shell 12446641same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000148258 ↔ mi-lcc L-000241316one store listed twicemerged