Royal Gas & Oil Co

Ferndale, MI 48220 · O29b9f8890d62 · first seen 2026-11-03
4 sourcesoff premise · conveniencealcohol: 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
Royal Gas & Oil Co 1 other
a source's own spelling of the licence name (record_title.py)
ROYAL GAS & OIL ab-inbevvtinfo ×2
Street
1710 Hilton Rd
mi-lccno other value
City
Ferndale
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48220
mi-lccno other value
Pin
42.46044, -83.12262 map
overtureno other value
Phone
2483981520
vtinfono other value
Licences
mi-lcc L-000280473
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa4d191d9bf95; O5c0d58720751; O3bbddeedfe4e

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-inbevROYAL GAS & OIL
3454577
1710 HILTON RD, FERNDALE, MI, 4822042.46075, -83.122932026-11-112026-11-12
mi-lccROYAL GAS & OIL CO.
L-000280473
1710 Hilton Rd, Ferndale, MI, 4822042.46022, -83.122922026-11-032026-11-12
overtureRoyal Gas & Oil Co
f1256138-ff80-4f01-a59f-cf99988f19b2
1710 Hilton Rd, Ferndale, MI, 48220248398152042.46044, -83.122622026-11-062026-11-12
vtinfoROYAL GAS & OIL
fd3df2c1d3e12562
1710 HILTON RD, FERNDALE, MI, 48220248398152042.46054, -83.122622026-11-122026-11-14

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 ROYAL GAS & OILmi-lcc ROYAL GAS & OIL CO.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 59 m apart · name similarity 1.00
ab-inbev ROYAL GAS & OILoverture Royal Gas & Oil Co1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 43 m apart · name similarity 1.00
ab-inbev ROYAL GAS & OILvtinfo ROYAL GAS & OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00
mi-lcc ROYAL GAS & OIL CO.overture Royal Gas & Oil Co1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
mi-lcc ROYAL GAS & OIL CO.vtinfo ROYAL GAS & OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 m apart · name similarity 1.00
overture Royal Gas & Oil Covtinfo ROYAL GAS & OIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · convenience — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROYAL GAS & OIL CO. — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
206 within 1 mi · 717 within 3 mi
Off / on premise
33 / 111 within 1 mi · 170 / 377 within 3 mi
Selling alcohol
108 within 1 mi · 380 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.04 mi
Setting
urban (4,956 people per sq mi)
People within 3 mi
140,120 (111,971 adults 21+, 63,170 households) from 49 tract(s), tracts within 3 mi
Income
per capita $48,067 · median household ~$84,798 (weighted mean of tract medians)
Age and education
median age ~38.3 · bachelor's or higher 42%
Ethnicity
Hispanic 4% · White 56% · Black 32% · Asian 4%
Adults per alcohol outlet
294
Alcohol spend within 3 mi
$41,582,101 a year ($19,118,517 at home, $22,444,500 away) · $109,139 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-12 14:25insertoverture f1256138-ff80-4f01-a59f-cf99988f19b2 ↔ vtinfo fd3df2c1d3e12562same address and namemerged12
2026-11-12 14:25insertab-inbev 3454577 ↔ vtinfo fd3df2c1d3e12562same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000280473 ↔ vtinfo fd3df2c1d3e12562same address and namemerged12
2026-11-11 12:56insertab-inbev 3454577 ↔ overture f1256138-ff80-4f01-a59f-cf99988f19b2same address and namemerged12
2026-11-11 12:56insertab-inbev 3454577 ↔ mi-lcc L-000280473same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000280473 ↔ overture f1256138-ff80-4f01-a59f-cf99988f19b2same address and namemerged11