Arco

Vista, CA 92081 · O9c3ee8f1cbdd · first seen 2026-10-08
4 sourcesoff premise · conveniencechain: AMPMalcohol: 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
Arco 3 other
a licence name in capitals, cleaned (derived; record_title.py)
ampm franchise vista doordash
ARCO AM/PM ca-abc
MELROSE PETROLEUM LLC ca-abc (legal name)
Street
600 HACIENDA DR 1 other
ca-abc
600 Hacienda Drive overtureubereats ×2
City
VISTA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92083 1 other
ca-abc
92081 doordashovertureubereats ×3
Pin
33.19335, -117.25412 map
ubereatsno other value
Phone
7607260501
overtureno other value
Licences
ca-abc 00629191|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc22ae3eb8475; Of1244634d20b; Ob0a4e1cadaf2

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
ca-abcARCO AM/PM
legal name: MELROSE PETROLEUM LLC
00629191|20|LIC|0
600 HACIENDA DR, VISTA, CA, 9208333.19361, -117.253782026-10-082026-11-11
doordashampm franchise vista
45374435
600 Hacienda Dr, Vista, CA, 9208133.19303, -117.254072026-10-082026-10-18
overtureARCO
2a49b438-9518-444a-b20d-1d3dfa5eaed9
600 Hacienda Drive, Vista, CA, 92081760726050133.19303, -117.254102026-11-062026-11-11
ubereatsARCO
z2Hn14XEWoWtkra-CUalNg
600 Hacienda Drive, Vista, CA, 9208133.19335, -117.254122026-11-052026-11-11

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 AMPMdoordash ampm franchise vista0.47one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 92c06edb8269a12f720d · person: None · rule: names contained at one address · stratum: near
doordash ampm franchise vistavtinfo AMPM0.47one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 1a9203edd08bb7391395 · person: None · rule: names contained at one address · stratum: near
overture ARCOubereats ARCO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ca-abc ARCO AM/PMubereats ARCO0.45Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “near” pair)
Both records name the same ARCO/AM-PM station at 600 Hacienda Dr, Vista, 42 m apart, and the CA licence is off-sale beer and wine, matching a convenience store; the differing ZIP is likely a geocoding
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 78% confident — Both list the same street address (600 Hacienda Dr, Vista) 42 m apart, and the names agree on ARCO with A's AM/PM matching B's AMPM chain. The ZIP differs (92083 vs 92081) and the building holds three businesses, which keeps this from being certain.
pair fde9099e2a327fb7f2ac
doordash ampm franchise vistaubereats ARCO0.17Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “same-address” pair)
Both records sit at 600 Hacienda Dr, Vista 92081, and the facts map both to the AMPM chain: ARCO and its ampm convenience store are one station operation, so the matching address and chain identify on
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records sit at 600 Hacienda Drive, Vista, about 37 m apart, and both are attributed to the AMPM chain (the Uber Eats listing's parent chain is AMPM), so they most likely describe one AMPM store; the 'ARCO' name and the three businesses at the address lower my confidence.
pair 83c035a67c34999e73a5

Attributes

Channel
off_premise · convenience — ca-licence
Chain
AMPM — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
MELROSE PETROLEUM LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 11, computed 2026-11-19 21:43.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
117 within 1 mi · 510 within 3 mi
Off / on premise
21 / 75 within 1 mi · 144 / 289 within 3 mi
Selling alcohol
65 within 1 mi · 287 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.03 mi
Setting
urban (5,018 people per sq mi)
People within 3 mi
141,871 (103,334 adults 21+, 47,666 households) from 28 tract(s), tracts within 3 mi
Income
per capita $42,717 · median household ~$100,015 (weighted mean of tract medians)
Age and education
median age ~38.4 · bachelor's or higher 32%
Ethnicity
Hispanic 44% · White 45% · Black 3% · Asian 7%
Adults per alcohol outlet
359
Alcohol spend within 3 mi
$37,054,985 a year ($16,560,770 at home, $20,479,246 away) · $128,663 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-16 14:56insertdoordash 45374435 ↔ vtinfo b5126022f82480fcone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4508580 ↔ doordash 45374435one name contains the other, same addressheld: same-source-conflict15
2026-11-11 12:56insertdoordash 45374435 ↔ ubereats z2Hn14XEWoWtkra-CUalNgClaude judge: samemerged12
2026-11-11 12:56insertca-abc 00629191|20|LIC|0 ↔ ubereats z2Hn14XEWoWtkra-CUalNgClaude judge: samemerged12
2026-11-06 18:13insertoverture 2a49b438-9518-444a-b20d-1d3dfa5eaed9 ↔ ubereats z2Hn14XEWoWtkra-CUalNgsame address and namemerged11