Aliment

SAN FRANCISCO, CA 94108 · O1fd63a51e939 · first seen 2026-10-08
3 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
Aliment 1 other
a source's own spelling of the licence name (record_title.py)
790 BUSH ST VENTURES INC. ca-abc (legal name) ×2
Street
790 BUSH ST 1 other
ca-abc
786 Bush St, San Francisco, USA ubereats
City
SAN FRANCISCO 1 other
ca-abc
SF ubereats
State
CA
ca-abcno other value
ZIP
94108
ca-abcno other value
Pin
37.79007, -122.41028 map
ubereatsno other value
Phone
4158292737
vtinfono other value
Licences
ca-abc 00627749|47|LIC|0 · ca-abc 00655088|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oab23248de5b3; O783761649c0c; O64c9e66c7167

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-abcALIMENT
legal name: 790 BUSH ST VENTURES INC.
00627749|47|LIC|0
790 BUSH ST, SAN FRANCISCO, CA, 9410837.79005, -122.410122026-10-082026-11-12
ca-abcALIMENT
legal name: 790 BUSH ST VENTURES INC.
00655088|47|LIC|0
790 BUSH ST, SAN FRANCISCO, CA, 9410837.79005, -122.410122026-10-082026-11-12
ubereatsAliment
3j_THCMET3uucSgUIC1GaA
786 Bush St, San Francisco, USA, SF, CA, 94108
ZIP lookup: San Francisco, CA
37.79007, -122.410282026-10-182026-11-12
vtinfoALIMENT
86f6090527958993
790 BUSH ST, SAN FRANCISCO, CA, 94108415829273737.79009, -122.410282026-11-122026-11-12

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
ca-abc ALIMENTca-abc ALIMENT1.00one store listed twicemergedsame street + ZIP · name: identical
ca-abc ALIMENTubereats Aliment1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair)
The distinctive independent name 'Aliment' matches, and 790 and 786 Bush St in ZIP 94108 are effectively one frontage; the surrendered licence is under the same name, not a different successor busines
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 60% confident — Both records carry the name Aliment at the same San Francisco building (coordinates about 14 m apart, same ZIP 94108, one business at the address), though the CA licence is surrendered and the street numbers differ (790 vs 786).
  • Claude Haiku 5.5, prompt v7: same, 72% confident — Both records are named Aliment in San Francisco ZIP 94108, with coordinates 14 m apart and only one business at the address; the 786 vs 790 street number gap is minor, though the ABC licence is surrendered, which leaves some doubt.
pair a6a3ea97fb6d5ec838bc
ca-abc ALIMENTvtinfo ALIMENT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ca-abc ALIMENTubereats Aliment1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records carry the distinctive name 'Aliment' in the same ZIP. The street numbers are adjacent (790 vs 786 Bush St), so this is likely one storefront at one premises, and the restaurant licence fi
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name Aliment at essentially the same San Francisco address (790 vs 786 Bush St, about 14 m apart with matching ZIP 94108), no other business is at the address, and the California restaurant licence (eating place) fits the same operation's Uber Eats listing under the same name.
  • Claude Haiku 5.5, prompt v7: same, 82% confident — The names match exactly (ALIMENT / Aliment), both are in San Francisco 94108, and the coordinates are about 14 m apart, though the street numbers differ slightly (790 vs 786 Bush St) and the Uber Eats record has no suite to confirm.
  • Claude Haiku 5.5, prompt v4: same, 75% confident — The names match exactly (ALIMENT / Aliment), both are in San Francisco with ZIP 94108, and Bush Street addresses differ only slightly (790 vs 786), which is most likely a listing or geocoding error for one distinctive independent restaurant; the street-number gap keeps this short of certain.
pair 5a3c3ee1277d95d50e5f
ca-abc ALIMENTvtinfo ALIMENT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
790 BUSH ST VENTURES INC. — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,524 within 1 mi · 5,520 within 3 mi
Off / on premise
254 / 1,591 within 1 mi · 728 / 3,469 within 3 mi
Selling alcohol
1,460 within 1 mi · 3,453 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (14,608 people per sq mi)
People within 3 mi
413,040 (362,724 adults 21+, 210,410 households) from 138 tract(s), tracts within 3 mi
Income
per capita $108,154 · median household ~$150,991 (weighted mean of tract medians)
Age and education
median age ~39.2 · bachelor's or higher 66%
Ethnicity
Hispanic 16% · White 47% · Black 5% · Asian 27%
Adults per alcohol outlet
105
Alcohol spend within 3 mi
$198,954,036 a year ($84,618,288 at home, $114,274,346 away) · $57,601 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 14:25insertca-abc 00627749|47|LIC|0 ↔ vtinfo 86f6090527958993same address and namemerged12
2026-11-12 14:25insertca-abc 00655088|47|LIC|0 ↔ vtinfo 86f6090527958993same address and namemerged12
2026-11-05 17:26backfillca-abc 00627749|47|LIC|0 ↔ ca-abc 00655088|47|LIC|0one store listed twicemerged
2026-11-02 23:02backfillca-abc 00627749|47|LIC|0 ↔ ubereats 3j_THCMET3uucSgUIC1GaAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00655088|47|LIC|0 ↔ ubereats 3j_THCMET3uucSgUIC1GaAClaude judge: samemerged