Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| ZIP | 94108 | ca-abc | no other value |
| Pin | 37.79007, -122.41028 map | ubereats | no other value |
| Phone | 4158292737 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | ALIMENT legal name: 790 BUSH ST VENTURES INC. 00627749|47|LIC|0 | 790 BUSH ST, SAN FRANCISCO, CA, 94108 | 37.79005, -122.41012 | 2026-10-08 | 2026-11-12 | |
| ca-abc | ALIMENT legal name: 790 BUSH ST VENTURES INC. 00655088|47|LIC|0 | 790 BUSH ST, SAN FRANCISCO, CA, 94108 | 37.79005, -122.41012 | 2026-10-08 | 2026-11-12 | |
| ubereats | Aliment 3j_THCMET3uucSgUIC1GaA | 786 Bush St, San Francisco, USA, SF, CA, 94108 ZIP lookup: San Francisco, CA | 37.79007, -122.41028 | 2026-10-18 | 2026-11-12 | |
| vtinfo | ALIMENT 86f6090527958993 | 790 BUSH ST, SAN FRANCISCO, CA, 94108 | 4158292737 | 37.79009, -122.41028 | 2026-11-12 | 2026-11-12 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc ALIMENT | ca-abc ALIMENT | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| ca-abc ALIMENT | ubereats Aliment | 1.00 | Claude judge: same | merged | 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:
pair a6a3ea97fb6d5ec838bc |
| ca-abc ALIMENT | vtinfo ALIMENT | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| ca-abc ALIMENT | ubereats Aliment | 1.00 | Claude judge: same | merged | 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:
pair 5a3c3ee1277d95d50e5f |
| ca-abc ALIMENT | vtinfo ALIMENT | 1.00 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ca-abc 00627749|47|LIC|0 ↔ vtinfo 86f6090527958993 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00655088|47|LIC|0 ↔ vtinfo 86f6090527958993 | same address and name | merged | 12 |
| 2026-11-05 17:26 | backfill | ca-abc 00627749|47|LIC|0 ↔ ca-abc 00655088|47|LIC|0 | one store listed twice | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00627749|47|LIC|0 ↔ ubereats 3j_THCMET3uucSgUIC1GaA | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00655088|47|LIC|0 ↔ ubereats 3j_THCMET3uucSgUIC1GaA | Claude judge: same | merged |