Straw Hat Pizza

Fairfield, CA 94533 · O4ae7af871d2d · first seen 2026-10-08
5 sourceson premise · restaurantchain: Straw Hat Pizzaalcohol: 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
Straw Hat Pizza 3 other
the most common name a source states
SGS FOOD INC ca-abc (legal name)
Straw Hat Pizza (1295 Horizon Drive) - Deprecated ubereats
straw hat pizza fairfield doordash
Street
1295 HORIZON DR 3 other
ca-abc
1295 HORIZON DR A ab-inbev
1295 Horizon Drive doordash
1295 Horizon Drive, Suite A ubereats
City
FAIRFIELD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94533
ca-abcno other value
Pin
38.27549, -122.00696 map 1 other
ubereats
85 m away ca-abc
Phone
7074218300
overtureno other value
Licences
ca-abc 00633688|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obe7b7742b8e7; O52753e5fba99; Ofb29130cd1d2; Offa003d07f0b; Oab5ee43a0ee0

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-inbevSTRAW HAT PIZZA
3122412
1295 HORIZON DR A, FAIRFIELD, CA, 9453338.27574, -122.007402026-11-112026-11-11
ca-abcSTRAW HAT PIZZA
legal name: SGS FOOD INC
00633688|41|LIC|0
1295 HORIZON DR, FAIRFIELD, CA, 9453338.27606, -122.007612026-10-082026-11-06
doordashstraw hat pizza fairfield
2837229
1295 Horizon Drive, Fairfield, CA38.27547, -122.007072026-10-082026-11-16
overtureStraw Hat Pizza
df952f54-711e-47e1-b944-3a83acb14dc6
1295 Horizon Dr, Fairfield, CA, 94533707421830038.27550, -122.006782026-11-062026-11-06
ubereatsStraw Hat Pizza (1295 Horizon Drive) - Deprecated
6rY754tEQL6AvILHYW3d9w
1295 Horizon Dr, Fairfield, CA, 9453338.27549, -122.006962026-11-102026-11-11
ubereatsStraw Hat Pizza
kSZzSd8BXGaGGCrTu1uOZQ
1295 Horizon Drive, Suite A, Fairfield, CA, 9453338.27550, -122.006972026-10-302026-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
ab-inbev STRAW HAT PIZZAca-abc STRAW HAT PIZZA1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 40 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev STRAW HAT PIZZAdoordash straw hat pizza fairfield1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 42 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev STRAW HAT PIZZAoverture Straw Hat Pizza1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 60 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev STRAW HAT PIZZAubereats Straw Hat Pizza1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 46 m apart · name similarity 1.00 · street similarity 0.91
ca-abc STRAW HAT PIZZAdoordash straw hat pizza fairfield1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 81 m apart · name similarity 1.00
ca-abc STRAW HAT PIZZAoverture Straw Hat Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 95 m apart · name similarity 1.00
ca-abc STRAW HAT PIZZAubereats Straw Hat Pizza1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
doordash straw hat pizza fairfieldoverture Straw Hat Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
doordash straw hat pizza fairfieldubereats Straw Hat Pizza1.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 Straw Hat Pizzaubereats Straw Hat Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ca-abc STRAW HAT PIZZAubereats Straw Hat Pizza (1295 Horizon Drive) - Deprecated0.46Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The two records share the same chain name, Straw Hat Pizza, and the same street address, 1295 Horizon Dr, Fairfield 94533, with a restaurant licence matching a pizza listing, so the shared building is
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records name Straw Hat Pizza at 1295 Horizon Dr, Fairfield 94533, with coordinates 85 m apart. The CA licence is an active on-sale eating-place (restaurant) licence, which matches a pizza restaurant's Uber Eats listing. The shared building (3 businesses) is outweighed by the matching names, and the 'Deprecated' tag suggests a stale listing rather than a different outlet.
pair c71b5979e581d483a1e9

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
Straw Hat Pizza — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
SGS FOOD INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 7, computed 2026-11-16 17:17.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT",
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
12 within 1 mi · 363 within 3 mi
Off / on premise
3 / 5 within 1 mi · 93 / 218 within 3 mi
Selling alcohol
6 within 1 mi · 180 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (3,502 people per sq mi)
People within 3 mi
99,015 (71,832 adults 21+, 31,772 households) from 21 tract(s), tracts within 3 mi
Income
per capita $38,730 · median household ~$97,121 (weighted mean of tract medians)
Age and education
median age ~36.9 · bachelor's or higher 22%
Ethnicity
Hispanic 35% · White 29% · Black 17% · Asian 16%
Adults per alcohol outlet
397
Alcohol spend within 3 mi
$23,682,182 a year ($10,664,932 at home, $13,006,074 away) · $130,841 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-16 14:56insertab-inbev 3122412 ↔ doordash 2837229street written two waysmerged15
2026-11-16 14:56insertdoordash 2837229 ↔ ubereats kSZzSd8BXGaGGCrTu1uOZQsame address and namemerged15
2026-11-16 14:56insertca-abc 00633688|41|LIC|0 ↔ doordash 2837229same address and namemerged15
2026-11-16 14:56insertdoordash 2837229 ↔ overture df952f54-711e-47e1-b944-3a83acb14dc6same address and namemerged15
2026-11-11 12:56insertca-abc 00633688|41|LIC|0 ↔ ubereats 6rY754tEQL6AvILHYW3d9wClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 3122412 ↔ ca-abc 00633688|41|LIC|0street written two waysmerged12
2026-11-11 12:56insertab-inbev 3122412 ↔ ubereats kSZzSd8BXGaGGCrTu1uOZQstreet written two waysmerged12
2026-11-11 12:56insertab-inbev 3122412 ↔ overture df952f54-711e-47e1-b944-3a83acb14dc6street written two waysmerged12
2026-11-06 18:13insertca-abc 00633688|41|LIC|0 ↔ overture df952f54-711e-47e1-b944-3a83acb14dc6same address and namemerged11
2026-11-06 18:13insertoverture df952f54-711e-47e1-b944-3a83acb14dc6 ↔ ubereats kSZzSd8BXGaGGCrTu1uOZQsame address and namemerged11
2026-10-30 17:27backfillca-abc 00633688|41|LIC|0 ↔ ubereats kSZzSd8BXGaGGCrTu1uOZQsame address and namemerged