Outlets /
On the Bridge
San Francisco, CA 94115 · O3bf19ad19855 · first seen 2026-10-08
4 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | On the Bridge 4 other | the most common name a source states | NAKAMURA MITSUHIRO ca-abc (legal name) On the Bridge Japanese Restaurant ubereats On the bridge restaurant ubereats on the bridge san francisco doordash |
| Street | 1581 WEBSTER ST 4 other | ca-abc | 1581 Webster St #206 overture 1581 Webster Street doordash 1581 Webster Street #206 ubereats 1581 Webster Street Ste 205 ubereats |
| City | SAN FRANCISCO | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94115 | ca-abc | no other value |
| Pin | 37.78518, -122.43157 map | ubereats | no other value |
| Phone | 4159227765 | overture | no other value |
| Licences | ca-abc 00272782|41|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe522730c9b51; Obee02c388056; Oc29c4db9c310; Od95ac87fc72e
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ca-abc | ON THE BRIDGE legal name: NAKAMURA MITSUHIRO 00272782|41|LIC|0 | 1581 WEBSTER ST, SAN FRANCISCO, CA, 94115 | 37.78518, -122.43149 | 2026-10-08 | 2026-11-05 | |
| doordash | on the bridge san francisco 4541 | 1581 Webster Street, San Francisco, CA, 94115 | 37.78511, -122.43147 | 2026-10-08 | 2026-11-02 | |
| overture | On the Bridge 35a5f9e0-a685-4848-984f-82e7d47715e8 | 1581 Webster St #206, San Francisco, CA, 94115 | 4159227765 | 37.78509, -122.43136 | 2026-11-06 | 2026-11-06 |
| ubereats | On the bridge restaurant 5EE6PZ8SS1uUdc1opO7rrA | 1581 Webster Street #206, San Francisco, CA, 94115 | 37.78518, -122.43157 | 2026-10-10 | 2026-11-03 | |
| ubereats | On the Bridge Japanese Restaurant vzosrDh8UeehZ4wD75qxjw | 1581 Webster Street Ste 205, San Francisco, CA, 94115 | 37.78508, -122.43151 | 2026-10-09 | 2026-11-03 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ca-abc ON THE BRIDGE | overture bf69de97-ae07-4c2e-b08f-22a6e58d4e17 | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2158 m apart · matched through the licence's legal name: NAKAMURA MITSUHIRO · name similarity 1.00 |
| ca-abc ON THE BRIDGE | doordash on the bridge san francisco | 1.00 | same address and name | merged | address similarity 1.00 · same street + city + state · name similarity 1.00 |
| ca-abc ON THE BRIDGE | overture On the Bridge | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| doordash on the bridge san francisco | overture On the Bridge | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| ca-abc ON THE BRIDGE | ubereats On the bridge restaurant | 0.64 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair) The distinctive name 'On the Bridge' matches, and the CA restaurant licence fits the Uber Eats restaurant listing at the same street and ZIP; only the Uber Eats record gives a suite, which is consiste Other Claude answers on this pair:
pair 3ba74df5bddecb7fc190 |
| doordash on the bridge san francisco | ubereats On the bridge restaurant | 0.64 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair) The distinctive independent name 'On the Bridge' matches on both records (the DoorDash slug just appends the city) at 1581 Webster St in the shared Japan Center building, so the names agree despite th Other Claude answers on this pair:
pair a6da58b7ca879b678628 |
| overture On the Bridge | ubereats On the bridge restaurant | 0.64 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 21 m apart · name similarity 0.64 |
| doordash on the bridge san francisco | ubereats On the Bridge Japanese Restaurant | 0.49 | Claude judge: same | merged department listings of one store | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The names agree on the distinctive independent name 'On the Bridge' at the same street address in San Francisco, so the shared building (9 businesses) and the suite named on only one side do not separ Other Claude answers on this pair:
pair f369b693dd1c6e39a70e |
| ca-abc ON THE BRIDGE | ubereats On the Bridge Japanese Restaurant | 0.49 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair) The distinctive name 'On the Bridge' matches at the same street address. The restaurant licence fits the Japanese restaurant listing, so the shared building and the suite given on only one side do not Other Claude answers on this pair:
pair 7c70378f78cbf0392e2e |
| overture On the Bridge | ubereats On the Bridge Japanese Restaurant | 0.49 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: japanese, restaurant · name Jaro-Winkler 0.84 · same street + ZIP · pins 14 m apart · name similarity 0.49 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 11, computed 2026-11-20 23:33.
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
- 1,367 within 1 mi · 6,026 within 3 mi
- Off / on premise
- 193 / 890 within 1 mi · 795 / 3,833 within 3 mi
- Selling alcohol
- 831 within 1 mi · 3,778 within 3 mi
- Nearest
- same channel 0.00 mi · licensed 0.00 mi
- Setting
- urban (17,309 people per sq mi)
- People within 3 mi
- 489,392 (425,834 adults 21+, 244,443 households) from 155 tract(s), tracts within 3 mi
- Income
- per capita $107,256 · median household ~$152,955 (weighted mean of tract medians)
- Age and education
- median age ~39.6 · bachelor's or higher 67%
- Ethnicity
- Hispanic 15% · White 47% · Black 5% · Asian 28%
- Adults per alcohol outlet
- 113
- Alcohol spend within 3 mi
- $234,335,254 a year ($99,557,799 at home, $134,705,443 away) · $62,010 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | overture 35a5f9e0-a685-4848-984f-82e7d47715e8 ↔ ubereats vzosrDh8UeehZ4wD75qxjw | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | overture 35a5f9e0-a685-4848-984f-82e7d47715e8 ↔ ubereats 5EE6PZ8SS1uUdc1opO7rrA | same address and name | merged | 14 |
| 2026-11-06 18:13 | insert | ca-abc 00272782|41|LIC|0 ↔ overture bf69de97-ae07-4c2e-b08f-22a6e58d4e17 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00272782|41|LIC|0 ↔ overture 35a5f9e0-a685-4848-984f-82e7d47715e8 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 4541 ↔ overture 35a5f9e0-a685-4848-984f-82e7d47715e8 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00272782|41|LIC|0 ↔ ubereats vzosrDh8UeehZ4wD75qxjw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 4541 ↔ ubereats vzosrDh8UeehZ4wD75qxjw | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | doordash 4541 ↔ ubereats 5EE6PZ8SS1uUdc1opO7rrA | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00272782|41|LIC|0 ↔ ubereats 5EE6PZ8SS1uUdc1opO7rrA | Claude judge: same | merged | |
| 2026-10-25 00:02 | backfill | ca-abc 00272782|41|LIC|0 ↔ doordash 4541 | same address and name | merged |