SAUSAGE FACTORY

SAN FRANCISCO, CA 94114 · O09df5f0d04a5 · first seen 2026-10-08
5 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
SAUSAGE FACTORY 4 other
the most common name a source states
RESTAURANT AT 517 CASTRO INC. ca-abc (legal name)
SAUSAGE FACTORY THE ca-abc
The Sausage Factory overture
the sausage factory san francisco doordash
Street
517 CASTRO ST 1 other
ca-abc
517 Castro Street doordash
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94114
ca-abcno other value
Pin
37.76056, -122.43482 map 1 other
doordash
52 m away ab-inbev
Phone
4156261250
vtinfono other value
Licences
ca-abc 00590745|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocd434b38e091; O82a5c11fe893; Oe8e023804a79; O6c33ffbd0a50

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-inbevSAUSAGE FACTORY
1949654
517 CASTRO ST, SAN FRANCISCO, CA, 9411437.76009, -122.434852026-11-112026-11-11
ca-abcSAUSAGE FACTORY THE
legal name: RESTAURANT AT 517 CASTRO INC.
00590745|41|LIC|0
517 CASTRO ST, SAN FRANCISCO, CA, 9411437.76059, -122.434902026-10-082026-11-11
doordashthe sausage factory san francisco
25913099
517 Castro Street, San Francisco, CA, 9411437.76056, -122.434822026-10-082026-11-13
overtureThe Sausage Factory
71a500da-44c8-4ee9-bbd9-5135be6ee945
517 Castro St, San Francisco, CA, 94114415626125037.76052, -122.434782026-11-062026-11-11
vtinfoSAUSAGE FACTORY
8daa48c5ea694253
517 CASTRO ST, SAN FRANCISCO, CA, 94114415626125037.76051, -122.434612026-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 SAUSAGE FACTORYca-abc SAUSAGE FACTORY THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ab-inbev SAUSAGE FACTORYdoordash the sausage factory san francisco1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ab-inbev SAUSAGE FACTORYoverture The Sausage Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ab-inbev SAUSAGE FACTORYvtinfo SAUSAGE FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00
ca-abc SAUSAGE FACTORY THEdoordash the sausage factory san francisco1.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 SAUSAGE FACTORY THEoverture The Sausage Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc SAUSAGE FACTORY THEvtinfo SAUSAGE FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
doordash the sausage factory san franciscooverture The Sausage Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
doordash the sausage factory san franciscovtinfo SAUSAGE FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
overture The Sausage Factoryvtinfo SAUSAGE FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00 · phone: equal

Attributes

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

Trade area

Other outlets
877 within 1 mi · 6,036 within 3 mi
Off / on premise
137 / 571 within 1 mi · 862 / 3,895 within 3 mi
Selling alcohol
608 within 1 mi · 3,736 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (21,656 people per sq mi)
People within 3 mi
612,316 (522,271 adults 21+, 280,056 households) from 176 tract(s), tracts within 3 mi
Income
per capita $98,727 · median household ~$153,727 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 63%
Ethnicity
Hispanic 17% · White 43% · Black 4% · Asian 31%
Adults per alcohol outlet
140
Alcohol spend within 3 mi
$270,650,157 a year ($114,908,675 at home, $155,659,035 away) · $72,424 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-12 14:25insertoverture 71a500da-44c8-4ee9-bbd9-5135be6ee945 ↔ vtinfo 8daa48c5ea694253same address and namemerged12
2026-11-12 14:25insertab-inbev 1949654 ↔ vtinfo 8daa48c5ea694253same address and namemerged12
2026-11-12 14:25insertca-abc 00590745|41|LIC|0 ↔ vtinfo 8daa48c5ea694253same address and namemerged12
2026-11-12 14:25insertdoordash 25913099 ↔ overture 71a500da-44c8-4ee9-bbd9-5135be6ee945same address and namemerged12
2026-11-12 14:25insertab-inbev 1949654 ↔ doordash 25913099same address and namemerged12
2026-11-12 14:25insertca-abc 00590745|41|LIC|0 ↔ doordash 25913099same address and namemerged12
2026-11-12 14:25insertdoordash 25913099 ↔ vtinfo 8daa48c5ea694253same address and namemerged12
2026-11-11 12:56insertab-inbev 1949654 ↔ ca-abc 00590745|41|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 1949654 ↔ overture 71a500da-44c8-4ee9-bbd9-5135be6ee945same address and namemerged12
2026-11-06 18:13insertca-abc 00590745|41|LIC|0 ↔ overture 71a500da-44c8-4ee9-bbd9-5135be6ee945same address and namemerged11