CALIFORNIA FISH MARKET RESTAURANT

San Francisco, CA 94133 · O58015ce79f33 · first seen 2026-10-08
2 sourceson premise · restaurantalcohol: 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
CALIFORNIA FISH MARKET RESTAURANT 2 other
the most common name a source states
Vicoletto overture
VICOLETTO INC ca-abc (legal name)
Street
550 GREEN ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94133
ca-abcno other value
Pin
37.79976, -122.40833 map
overtureno other value
Phone
4154335800
overtureno other value
Licences
ca-abc 00675902|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oda07caa5d043; O7317f5db5998

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-abcCALIFORNIA FISH MARKET RESTAURANT
legal name: VICOLETTO INC
00675902|47|LIC|0
550 GREEN ST, SAN FRANCISCO, CA, 9413337.79965, -122.408252026-10-082026-11-09
overtureVicoletto
9c708dc3-ae2e-4d7a-9a54-ae4eceb5843a
550 Green St, San Francisco, CA, 94133415433580037.79976, -122.408332026-11-062026-11-06

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 CALIFORNIA FISH MARKET RESTAURANToverture 59b3f00e-4377-4b71-916f-617008e8c6e41.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ca-abc CALIFORNIA FISH MARKET RESTAURANToverture Vicoletto1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · matched through the licence's legal name: VICOLETTO INC · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
VICOLETTO INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,898 within 1 mi · 4,859 within 3 mi
Off / on premise
194 / 1,169 within 1 mi · 608 / 3,036 within 3 mi
Selling alcohol
1,153 within 1 mi · 3,003 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (11,984 people per sq mi)
People within 3 mi
338,850 (300,200 adults 21+, 177,204 households) from 116 tract(s), tracts within 3 mi
Income
per capita $105,599 · median household ~$143,436 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 65%
Ethnicity
Hispanic 15% · White 45% · Black 6% · Asian 29%
Adults per alcohol outlet
100
Alcohol spend within 3 mi
$162,510,858 a year ($69,417,700 at home, $93,039,925 away) · $54,098 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-09 15:32updateca-abc 00675902|47|LIC|0 ↔ overture 9c708dc3-ae2e-4d7a-9a54-ae4eceb5843asame address and namemerged11
2026-11-06 18:13insertca-abc 00675902|47|LIC|0 ↔ overture 9c708dc3-ae2e-4d7a-9a54-ae4eceb5843asame address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00675902|47|LIC|0 ↔ overture 59b3f00e-4377-4b71-916f-617008e8c6e4same address and namemerged11