Lone Star Saloon

SAN FRANCISCO, CA 94103 · O2b1c2f75c0b7 · first seen 2026-10-08
4 sourceson premise · baralcohol: 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
Lone Star Saloon 1 other
a source's own spelling of the licence name (record_title.py)
BEAR TRAP LSSF INC. ca-abc (legal name) ×2
Street
1354 HARRISON ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94103
ca-abcno other value
Pin
37.77209, -122.41080 map
overtureno other value
Phone
4158639999
vtinfono other value
Licences
ca-abc 00575345|48|LIC|0 · ca-abc 00575345|48|LIC|1
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob1631e544dfc; O7a284b2d20c3; O502ecacd4095; O49bed906f957

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-inbevLONE STAR SALOON
2143853
1354 HARRISON ST, SAN FRANCISCO, CA, 9410337.77206, -122.410742026-11-132026-11-13
ca-abcLONE STAR SALOON
legal name: BEAR TRAP LSSF INC.
00575345|48|LIC|0
1354 HARRISON ST, SAN FRANCISCO, CA, 9410337.77184, -122.411052026-10-082026-11-13
ca-abcLONE STAR SALOON
legal name: BEAR TRAP LSSF INC.
00575345|48|LIC|1
1354 HARRISON ST, SAN FRANCISCO, CA, 9410337.77184, -122.411052026-10-082026-11-13
overtureLone Star Saloon
4cb0d96a-8511-4d07-916e-591aa72b7bab
1354 Harrison St, San Francisco, CA, 94103415863999937.77209, -122.410802026-11-062026-11-13
vtinfoLONE STAR SALOON
1a12cc86079011d4
1354 HARRISON ST, SAN FRANCISCO, CA, 94103415863999937.77190, -122.411112026-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 LONE STAR SALOONca-abc LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00
ab-inbev LONE STAR SALOONca-abc LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00
ab-inbev LONE STAR SALOONoverture Lone Star Saloon1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ab-inbev LONE STAR SALOONvtinfo LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 37 m apart · name similarity 1.00
ca-abc LONE STAR SALOONca-abc LONE STAR SALOON1.00one licence filemergedfile: 00575345 · same_address
ca-abc LONE STAR SALOONoverture Lone Star Saloon1.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 LONE STAR SALOONvtinfo LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc LONE STAR SALOONoverture Lone Star Saloon1.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 LONE STAR SALOONvtinfo LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
overture Lone Star Saloonvtinfo LONE STAR SALOON1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BEAR TRAP LSSF INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 48
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
1,421 within 1 mi · 6,024 within 3 mi
Off / on premise
174 / 900 within 1 mi · 816 / 3,760 within 3 mi
Selling alcohol
809 within 1 mi · 3,725 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.10 mi
Setting
urban (17,471 people per sq mi)
People within 3 mi
493,980 (428,319 adults 21+, 242,587 households) from 157 tract(s), tracts within 3 mi
Income
per capita $106,260 · median household ~$153,901 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 66%
Ethnicity
Hispanic 16% · White 46% · Black 5% · Asian 28%
Adults per alcohol outlet
115
Alcohol spend within 3 mi
$232,684,436 a year ($98,807,855 at home, $133,805,232 away) · $62,449 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 17:47insertab-inbev 2143853 ↔ vtinfo 1a12cc86079011d4same address and namemerged15
2026-11-13 17:47insertab-inbev 2143853 ↔ ca-abc 00575345|48|LIC|1same address and namemerged15
2026-11-13 17:47insertab-inbev 2143853 ↔ ca-abc 00575345|48|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 2143853 ↔ overture 4cb0d96a-8511-4d07-916e-591aa72b7babsame address and namemerged15
2026-11-12 14:25insertca-abc 00575345|48|LIC|1 ↔ vtinfo 1a12cc86079011d4same address and namemerged12
2026-11-12 14:25insertca-abc 00575345|48|LIC|0 ↔ vtinfo 1a12cc86079011d4same address and namemerged12
2026-11-12 14:25insertoverture 4cb0d96a-8511-4d07-916e-591aa72b7bab ↔ vtinfo 1a12cc86079011d4same address and namemerged12
2026-11-06 18:13insertca-abc 00575345|48|LIC|1 ↔ overture 4cb0d96a-8511-4d07-916e-591aa72b7babsame address and namemerged11
2026-11-06 18:13insertca-abc 00575345|48|LIC|0 ↔ overture 4cb0d96a-8511-4d07-916e-591aa72b7babsame address and namemerged11
2026-10-09 13:59backfillca-abc 00575345|48|LIC|0 ↔ ca-abc 00575345|48|LIC|1one licence filemerged