Union Lake Tap

Waterford, MI 48327 · O1b83257c1bfa · first seen 2026-11-03
4 sourceson premise · restaurantalcohol: 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
Union Lake Tap 2 other
a licence name in capitals, cleaned (derived; record_title.py)
SWEETWATER WATERFORD, INC mi-lcc (legal name) ×2
Union Lake Tap Bar and Grill overture
Street
7760 & 7770 Cooley Lake Rd 1 other
mi-lcc
7760 COOLEY LAKE RD ab-inbevoverturevtinfo ×3
City
Waterford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48327
mi-lccno other value
Pin
42.61526, -83.43821 map
overtureno other value
Phone
8106257171 1 other
vtinfo
2483630400 mi-lccoverture ×3
Licences
mi-lcc L-000255871 · mi-lcc L-000415846
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ode8d33dbce3e; Obc8bdbbf40c4; Ofe0377cd22ae; O7cfb6d36424a

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-inbevUNION LAKE TAP
4139214
7760 COOLEY LAKE RD, WATERFORD, MI, 4832742.61547, -83.437822026-11-112026-11-18
mi-lccUNION LAKE TAP
legal name: SWEETWATER WATERFORD, INC
L-000255871
7760 & 7770 Cooley Lake Rd, Waterford, MI, 48327248363040042.61515, -83.438122026-11-032026-11-18
mi-lccUNION LAKE TAP
legal name: SWEETWATER WATERFORD, INC
L-000415846
7760 & 7770 Cooley Lake Rd, Waterford, MI, 48327248363040042.61515, -83.438122026-11-032026-11-18
overtureUnion Lake Tap Bar and Grill
c1d4199d-8e47-4634-86cd-352471c398da
7760 Cooley Lake Rd, Waterford, MI, 48327248363040042.61526, -83.438212026-11-132026-11-18
vtinfoUNION LAKE TAP
fe5715b2cbf06d7a
7760 COOLEY LAKE RD, WATERFORD, MI810625717142.61544, -83.438242026-11-182026-11-18

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 UNION LAKE TAPmi-lcc UNION LAKE TAP1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 43 m apart · name similarity 1.00 · street similarity 0.85
ab-inbev UNION LAKE TAPmi-lcc UNION LAKE TAP1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 43 m apart · name similarity 1.00 · street similarity 0.85
ab-inbev UNION LAKE TAPvtinfo UNION LAKE TAP1.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 UNION LAKE TAPmi-lcc UNION LAKE TAP1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc UNION LAKE TAPvtinfo UNION LAKE TAP1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 33 m apart · name similarity 1.00 · street similarity 0.85
mi-lcc UNION LAKE TAPvtinfo UNION LAKE TAP1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 33 m apart · name similarity 1.00 · street similarity 0.85
ab-inbev UNION LAKE TAPoverture Union Lake Tap Bar and Grill0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.73 · same street + ZIP · pins 39 m apart · name similarity 0.67
overture Union Lake Tap Bar and Grillvtinfo UNION LAKE TAP0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.73 · same street + city + state · pins 20 m apart · name similarity 0.67 · phone: differs

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SWEETWATER WATERFORD, INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-18 18:58insertoverture c1d4199d-8e47-4634-86cd-352471c398da ↔ vtinfo fe5715b2cbf06d7asame address and namemerged15
2026-11-18 18:58insertmi-lcc L-000255871 ↔ vtinfo fe5715b2cbf06d7astreet written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000415846 ↔ vtinfo fe5715b2cbf06d7astreet written two waysmerged15
2026-11-18 18:58insertab-inbev 4139214 ↔ vtinfo fe5715b2cbf06d7asame address and namemerged15
2026-11-13 14:10insertab-inbev 4139214 ↔ overture c1d4199d-8e47-4634-86cd-352471c398dasame address and namemerged15
2026-11-11 12:56insertab-inbev 4139214 ↔ mi-lcc L-000415846street written two waysmerged12
2026-11-11 12:56insertab-inbev 4139214 ↔ mi-lcc L-000255871street written two waysmerged12
2026-11-03 13:33backfillmi-lcc L-000255871 ↔ mi-lcc L-000415846one store listed twicemerged