PI BAR

WOODBRIDGE, CA 95258 · O08032a03337b · first seen 2026-10-08
5 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
PI BAR 3 other
the most common name a source states
PI BAR WOODBRIDGE ca-abc ×2
RREM INC ca-abc (legal name) ×2
pi bar woodbridge woodbridge doordash
Street
18879 N LOWER SACRAMENTO RD
ca-abcno other value
City
WOODBRIDGE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95258
ca-abcno other value
Pin
38.15387, -121.30139 map 1 other
doordash
71 m away ab-inbev
Phone
2093106177
vtinfono other value
Licences
ca-abc 00642330|47|LIC|0 · ca-abc 00642330|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O231dd77a9448; O15df77c576a2; O90bb6947a6a2; O87f205bd7ea5; Ocefdf7f399bd

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-inbevPI BAR
4764259
18879 N LOWER SACRAMENTO RD, WOODBRIDGE, CA, 9525838.15326, -121.301122026-11-112026-11-11
ca-abcPI BAR WOODBRIDGE
legal name: RREM INC
00642330|47|LIC|0
18879 N LOWER SACRAMENTO RD, WOODBRIDGE, CA, 9525838.15370, -121.301012026-10-082026-11-05
ca-abcPI BAR WOODBRIDGE
legal name: RREM INC
00642330|58|LIC|0
18879 N LOWER SACRAMENTO RD, WOODBRIDGE, CA, 9525838.15370, -121.301012026-10-082026-11-05
doordashpi bar woodbridge woodbridge
31082804
18879 N Lower Sacramento Rd, Woodbridge, CA, 9525838.15387, -121.301392026-10-082026-11-10
overturePi bar
70480ecc-8333-4ad5-9d87-0dcd202d51d8
18879 N Lower Sacramento Rd, Woodbridge, CA, 95258209310617738.15378, -121.301222026-11-092026-11-09
vtinfoPI BAR
4e784a3e60fab30b
18879 N LOWER SACRAMENTO RD, WOODBRIDGE, CA, 95258209310617738.15378, -121.301222026-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 PI BARdoordash pi bar woodbridge woodbridge1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00
ab-inbev PI BARoverture Pi bar1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ab-inbev PI BARvtinfo PI BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 59 m apart · name similarity 1.00
ca-abc PI BAR WOODBRIDGEca-abc PI BAR WOODBRIDGE1.00one licence filemergedfile: 00642330 · same_address
ca-abc PI BAR WOODBRIDGEdoordash pi bar woodbridge woodbridge1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 38 m apart · name similarity 1.00
ca-abc PI BAR WOODBRIDGEdoordash pi bar woodbridge woodbridge1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 38 m apart · name similarity 1.00
doordash pi bar woodbridge woodbridgeoverture Pi bar1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
doordash pi bar woodbridge woodbridgevtinfo PI BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
overture Pi barvtinfo PI BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00 · phone: equal
ab-inbev PI BARca-abc PI BAR WOODBRIDGE0.59Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “near” pair)
Pi Bar same address, name matches.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are at the same street address and ZIP with nearly identical coordinates (0.05 km), and the names 'PI BAR' and 'PI BAR WOODBRIDGE' match closely; the only business at that address is the one listed, and the California licence is a restaurant with full bar, which fits a bar listing as one operation rather than a separate business.
pair 18273e0a8b39b7f4f5ec

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
RREM INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
34 within 1 mi · 412 within 3 mi
Off / on premise
9 / 11 within 1 mi · 117 / 187 within 3 mi
Selling alcohol
30 within 1 mi · 292 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.00 mi
Setting
suburban (1,673 people per sq mi)
People within 3 mi
47,300 (34,550 adults 21+, 16,871 households) from 13 tract(s), tracts within 3 mi
Income
per capita $40,498 · median household ~$89,073 (weighted mean of tract medians)
Age and education
median age ~38.1 · bachelor's or higher 25%
Ethnicity
Hispanic 35% · White 56% · Black 1% · Asian 9%
Adults per alcohol outlet
118
Alcohol spend within 3 mi
$11,719,394 a year ($5,370,148 at home, $6,343,761 away) · $39,998 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 17:29insertab-inbev 4764259 ↔ ca-abc 00642330|58|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4764259 ↔ vtinfo 4e784a3e60fab30bsame address and namemerged12
2026-11-12 14:25insertdoordash 31082804 ↔ vtinfo 4e784a3e60fab30bsame address and namemerged12
2026-11-12 14:25insertoverture 70480ecc-8333-4ad5-9d87-0dcd202d51d8 ↔ vtinfo 4e784a3e60fab30bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4764259 ↔ doordash 31082804same address and namemerged12
2026-11-11 12:56insertab-inbev 4764259 ↔ overture 70480ecc-8333-4ad5-9d87-0dcd202d51d8same address and namemerged12
2026-11-09 15:32insertdoordash 31082804 ↔ overture 70480ecc-8333-4ad5-9d87-0dcd202d51d8same address and namemerged11
2026-11-09 14:23insertca-abc 00642330|58|LIC|0 ↔ doordash 31082804same address and namemerged11
2026-11-09 14:23insertca-abc 00642330|47|LIC|0 ↔ doordash 31082804same address and namemerged11
2026-10-09 13:59backfillca-abc 00642330|47|LIC|0 ↔ ca-abc 00642330|58|LIC|0one licence filemerged