Crustacean Restaurant

San Francisco, CA 94109 · O093944d1f481 · first seen 2026-10-26
2 sourceson premise · restaurantalcohol: unknown

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
Crustacean Restaurant 1 other
the most common name a source states
OTT Crustacean Restaurant ubereats
Street
1475 Polk St
ubereatsno other value
City
San Francisco
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94109
ubereatsno other value
Pin
37.79028, -122.42090 map
ubereatsno other value
Phone
4157762722
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8fec28b76058

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
overtureCrustacean Restaurant
47d57f53-b662-4f3e-90da-ff24d4020fc9
1475 Polk St, San Francisco, CA, 94109415776272237.79029, -122.420902026-11-062026-11-06
ubereatsOTT Crustacean Restaurant
-o2uHT1uSBKK2E6bn3sgAw
1475 Polk St, San Francisco, CA, 9410937.79028, -122.420902026-10-262026-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
overture Crustacean Restaurantubereats OTT Crustacean Restaurant0.79same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 1 m apart · name similarity 0.79

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
2,253 within 1 mi · 5,674 within 3 mi
Off / on premise
255 / 1,422 within 1 mi · 743 / 3,586 within 3 mi
Selling alcohol
1,346 within 1 mi · 3,543 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.00 mi
Setting
urban (15,481 people per sq mi)
People within 3 mi
437,704 (383,764 adults 21+, 222,591 households) from 144 tract(s), tracts within 3 mi
Income
per capita $108,910 · median household ~$152,425 (weighted mean of tract medians)
Age and education
median age ~39.3 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 47% · Black 5% · Asian 28%
Adults per alcohol outlet
108
Alcohol spend within 3 mi
$212,065,598 a year ($90,129,043 at home, $121,871,387 away) · $59,855 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-06 18:13insertoverture 47d57f53-b662-4f3e-90da-ff24d4020fc9 ↔ ubereats -o2uHT1uSBKK2E6bn3sgAwsame address and namemerged11