On The Road

Katy, TX 77494 · O447bd43257f8 · first seen 2026-11-02
5 sourcesunknownalcohol: 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
On The Road 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ON THE ROAD 109 lotterytx-tabctx-tobacco ×3
Tan Katy LLC tx-tabc (legal name)tx-tobacco (legal name) ×2
Street
24985 Katy Fwy
tx-tabcno other value
City
Katy
tx-tabcno other value
State
TX
tx-tabcno other value
ZIP
77494
tx-tabcno other value
Pin
29.78490, -95.80128 map 2 other
lottery
326 m away ab-inbev
88 m away vtinfo
Phone
2812509816
vtinfono other value
Licences
tx-tabc 200056900
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe80dcdfbb985; Oa3f21e00ec2d; Of2c6b8f4427f; O9ea96236ab55

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-inbevON THE ROAD
4123792
24985 KATY FWY, KATY, TX, 7749429.78492, -95.797912026-11-112026-11-20
lotteryON THE ROAD 109
lottery|tx|191729
24985 KATY FWY, Katy, TX, 7749429.78490, -95.801282026-11-202026-11-20
tx-tabcOn The Road 109
legal name: Tan Katy LLC
200056900
24985 Katy Fwy, Katy, TX, 7749429.78490, -95.801282026-11-022026-11-20
tx-tobaccoON THE ROAD 109
legal name: TAN KATY LLC
tx-tobacco|32080965109|1
24985 KATY FWY, Katy, TX, 7749429.78490, -95.801282026-11-202026-11-20
vtinfoON THE ROAD
04804064a1e6fb1c
24985 KATY FWY, KATY, TX, 77494281250981629.78423, -95.800792026-11-122026-11-20

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 ON THE ROADlottery ON THE ROAD 1091.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 326 m apart · name similarity 1.00
ab-inbev ON THE ROADtx-tobacco ON THE ROAD 1091.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 326 m apart · name similarity 1.00
ab-inbev ON THE ROADvtinfo ON THE ROAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 289 m apart · name similarity 1.00
lottery ON THE ROAD 109tx-tabc On The Road 1091.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
lottery ON THE ROAD 109tx-tobacco ON THE ROAD 1091.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
lottery ON THE ROAD 109vtinfo ON THE ROAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 88 m apart · name similarity 1.00
tx-tabc On The Road 109tx-tobacco ON THE ROAD 1091.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
tx-tobacco ON THE ROAD 109vtinfo ON THE ROAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 88 m apart · name similarity 1.00
ab-inbev ON THE ROADtx-tabc On The Road 1090.72Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
On The Road same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 82% confident — Both records sit at the same street address in Katy, TX 77494, with only one business at that address, and the names match apart from the store number suffix ('On The Road' vs 'On The Road 109'), so they most likely describe one outlet.
pair 20e1e461a39c409f7165

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Tan Katy LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — TX Retail/Q
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": []
}

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-20 22:08inserttx-tabc 200056900 ↔ tx-tobacco tx-tobacco|32080965109|1same address and namemerged17
2026-11-20 22:08inserttx-tobacco tx-tobacco|32080965109|1 ↔ vtinfo 04804064a1e6fb1csame address and namemerged17
2026-11-20 22:08insertlottery lottery|tx|191729 ↔ tx-tobacco tx-tobacco|32080965109|1same address and namemerged17
2026-11-20 22:08insertlottery lottery|tx|191729 ↔ tx-tabc 200056900same address and namemerged17
2026-11-20 22:08insertlottery lottery|tx|191729 ↔ vtinfo 04804064a1e6fb1csame address and namemerged17
2026-11-20 22:08insertab-inbev 4123792 ↔ tx-tobacco tx-tobacco|32080965109|1same address and namemerged17
2026-11-20 22:08insertab-inbev 4123792 ↔ lottery lottery|tx|191729same address and namemerged17
2026-11-12 17:29insertab-inbev 4123792 ↔ tx-tabc 200056900Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4123792 ↔ vtinfo 04804064a1e6fb1csame address and namemerged12