The Aquarium

PETALUMA, CA 94952 · O7b5ed7d428e1 · first seen 2026-10-08
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
The Aquarium 2 other
a licence name in capitals, cleaned (derived; record_title.py)
UP THE DUBS LLC ca-abc (legal name) ×2
Aquarium Food & Spirits overture
Street
1030 PETALUMA BLVD N
ca-abcno other value
City
PETALUMA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94952
ca-abcno other value
Pin
38.24585, -122.64325 map 3 other
overture
152 m away ca-abc ×2
151 m away ab-inbev
136 m away vtinfo
Phone
7077788825
vtinfono other value
Licences
ca-abc 00601444|47|LIC|0 · ca-abc 00601444|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeb49ccfffbb8; Od2f645a1fa60; O970c07a20bec; O8f2a85ba398b; Od4c1c287369d

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-inbevTHE AQUARIUM
2925759
1030 PETALUMA BLVD N, PETALUMA, CA, 9495238.24596, -122.644972026-11-112026-11-11
ca-abcTHE AQUARIUM
legal name: UP THE DUBS LLC
00601444|47|LIC|0
1030 PETALUMA BLVD N, PETALUMA, CA, 9495238.24600, -122.644982026-10-082026-11-11
ca-abcTHE AQUARIUM
legal name: UP THE DUBS LLC
00601444|58|LIC|0
1030 PETALUMA BLVD N, PETALUMA, CA, 9495238.24600, -122.644982026-10-082026-11-11
overtureAquarium Food & Spirits
bccc6514-94bf-4c09-84a3-e79b9e162fab
1030 Petaluma Blvd N, Petaluma, CA, 94952707778882538.24585, -122.643252026-11-132026-11-13
vtinfoTHE AQUARIUM
58c627609e07930d
1030 PETALUMA BLVD N, PETALUMA, CA, 94952707778882538.24592, -122.644802026-11-132026-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 THE AQUARIUMca-abc THE AQUARIUM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev THE AQUARIUMca-abc THE AQUARIUM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev THE AQUARIUMoverture 2a81e4a5-fff3-44bd-b951-0e693013e0ef1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 139 m apart · name similarity 1.00
ab-inbev THE AQUARIUMvtinfo THE AQUARIUM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
ca-abc THE AQUARIUMca-abc THE AQUARIUM1.00one licence filemergedfile: 00601444 · same_address
ca-abc THE AQUARIUMoverture 2a81e4a5-fff3-44bd-b951-0e693013e0ef1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 140 m apart · name similarity 1.00
ca-abc THE AQUARIUMvtinfo THE AQUARIUM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ca-abc THE AQUARIUMoverture 2a81e4a5-fff3-44bd-b951-0e693013e0ef1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 140 m apart · name similarity 1.00
ca-abc THE AQUARIUMvtinfo THE AQUARIUM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ab-inbev THE AQUARIUMoverture Aquarium Food & Spirits0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, spirits · name Jaro-Winkler 0.88 · same street + ZIP · pins 151 m apart · name similarity 0.44
ca-abc THE AQUARIUMoverture Aquarium Food & Spirits0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, spirits · name Jaro-Winkler 0.88 · same street + ZIP · pins 152 m apart · name similarity 0.44
ca-abc THE AQUARIUMoverture Aquarium Food & Spirits0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, spirits · name Jaro-Winkler 0.88 · same street + ZIP · pins 152 m apart · name similarity 0.44
overture Aquarium Food & Spiritsvtinfo THE AQUARIUM0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, spirits · name Jaro-Winkler 0.88 · same street + city + state · pins 136 m apart · name similarity 0.44 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
UP THE DUBS LLC — 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 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
229 within 1 mi · 450 within 3 mi
Off / on premise
58 / 132 within 1 mi · 130 / 221 within 3 mi
Selling alcohol
155 within 1 mi · 322 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.03 mi
Setting
suburban (1,791 people per sq mi)
People within 3 mi
50,653 (39,992 adults 21+, 20,945 households) from 11 tract(s), tracts within 3 mi
Income
per capita $59,283 · median household ~$112,433 (weighted mean of tract medians)
Age and education
median age ~45.7 · bachelor's or higher 41%
Ethnicity
Hispanic 23% · White 70% · Black 1% · Asian 4%
Adults per alcohol outlet
124
Alcohol spend within 3 mi
$17,733,934 a year ($7,777,710 at home, $9,948,991 away) · $54,904 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-13 14:10insertoverture bccc6514-94bf-4c09-84a3-e79b9e162fab ↔ vtinfo 58c627609e07930dsame address and namemerged15
2026-11-13 14:10insertca-abc 00601444|58|LIC|0 ↔ overture bccc6514-94bf-4c09-84a3-e79b9e162fabsame address and namemerged15
2026-11-13 14:10insertab-inbev 2925759 ↔ overture bccc6514-94bf-4c09-84a3-e79b9e162fabsame address and namemerged15
2026-11-13 14:10insertca-abc 00601444|47|LIC|0 ↔ overture bccc6514-94bf-4c09-84a3-e79b9e162fabsame address and namemerged15
2026-11-13 14:10insertca-abc 00601444|58|LIC|0 ↔ vtinfo 58c627609e07930dsame address and namemerged15
2026-11-13 14:10insertab-inbev 2925759 ↔ vtinfo 58c627609e07930dsame address and namemerged15
2026-11-13 14:10insertca-abc 00601444|47|LIC|0 ↔ vtinfo 58c627609e07930dsame address and namemerged15
2026-11-11 12:56insertab-inbev 2925759 ↔ overture 2a81e4a5-fff3-44bd-b951-0e693013e0efsame address and namemerged12
2026-11-11 12:56insertab-inbev 2925759 ↔ ca-abc 00601444|58|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2925759 ↔ ca-abc 00601444|47|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00601444|58|LIC|0 ↔ overture 2a81e4a5-fff3-44bd-b951-0e693013e0efsame address and namemerged11
2026-11-06 18:13insertca-abc 00601444|47|LIC|0 ↔ overture 2a81e4a5-fff3-44bd-b951-0e693013e0efsame address and namemerged11
2026-10-09 13:59backfillca-abc 00601444|47|LIC|0 ↔ ca-abc 00601444|58|LIC|0one licence filemerged