Royal Farm

COLMAR, PA 18915 · O9ec03ce665b3 · first seen 2026-10-08
4 sourceson premise · restaurantchain: Royal Farmsalcohol: alcohol

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 Farm 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Royal Farms overture
royal farms colmar doordash
Street
935 Bethlehem Pike
doordashno other value
City
Colmar 1 other
doordash
Hatfield Twp overture
State
PA
doordashno other value
ZIP
18915
doordashno other value
Pin
40.28415, -75.26138 map 1 other
doordash
73 m away ab-inbev
Phone
2158220379 1 other
vtinfo
2157162142 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc57919aef29a; Oaf47e42ca9b4; Ofa039fcdb771

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 FARM
4016704
935 BETHLEHEM PIKE, COLMAR, PA, 1891540.28451, -75.262102026-11-122026-11-12
doordashroyal farms colmar
1124006
935 Bethlehem Pike, Colmar, PA, 1891540.28415, -75.261382026-10-082026-11-12
overtureRoyal Farms
898050c9-1bde-4fb2-bdb7-ed70ac1c1f34
935 Bethlehem Pike, Hatfield Twp, PA, 18915215716214240.28423, -75.261282026-11-132026-11-13
vtinfoROYAL FARM
858b3f81417d16c5
935 BETHLEHEM PIKE, COLMAR, PA, 18915215822037940.28448, -75.261302026-11-152026-11-15

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 FARMvtinfo ROYAL FARM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 68 m apart · name similarity 1.00
ab-inbev ROYAL FARMdoordash royal farms colmar0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 73 m apart · name similarity 0.64
ab-inbev ROYAL FARMoverture Royal Farms0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 77 m apart · name similarity 0.64
doordash royal farms colmarvtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 37 m apart · name similarity 0.64
overture Royal Farmsvtinfo ROYAL FARM0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 28 m apart · name similarity 0.64 · phone: differs

Attributes

Channel
on_premise · restaurant — doordash-url conflicting evidence
Chain
Royal Farms — name-prefix
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +6 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 152 within 3 mi
Off / on premise
8 / 20 within 1 mi · 38 / 90 within 3 mi
Selling alcohol
10 within 1 mi · 63 within 3 mi
Nearest
same channel 0.12 mi · licensed 1.83 mi
Setting
suburban (2,000 people per sq mi)
People within 3 mi
56,543 (42,891 adults 21+, 21,179 households) from 13 tract(s), tracts within 3 mi
Income
per capita $53,118 · median household ~$112,154 (weighted mean of tract medians)
Age and education
median age ~41.6 · bachelor's or higher 48%
Ethnicity
Hispanic 7% · White 71% · Black 3% · Asian 17%
Adults per alcohol outlet
670
Alcohol spend within 3 mi
$17,868,358 a year ($7,832,085 at home, $10,030,358 away) · $279,193 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-15 16:24insertoverture 898050c9-1bde-4fb2-bdb7-ed70ac1c1f34 ↔ vtinfo 858b3f81417d16c5same address and namemerged15
2026-11-15 16:24insertdoordash 1124006 ↔ vtinfo 858b3f81417d16c5same address and namemerged15
2026-11-15 16:24insertab-inbev 4016704 ↔ vtinfo 858b3f81417d16c5same address and namemerged15
2026-11-13 14:10insertab-inbev 4016704 ↔ overture 898050c9-1bde-4fb2-bdb7-ed70ac1c1f34same address and namemerged15
2026-11-12 14:25insertab-inbev 4016704 ↔ doordash 1124006same address and namemerged12