Pho-Shi

Troy, MI 48084 · O068319a2f21f · first seen 2026-10-08
3 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
Pho-Shi 2 other
the most common name a source states
PHO SHI inspections
pho shi troy doordash
Street
2008 West Big Beaver Road 1 other
doordash
2008 W BIG BEAVER RD inspectionsoverture ×2
City
Troy
doordashno other value
State
MI
doordashno other value
ZIP
48084
doordashno other value
Pin
42.56213, -83.17480 map 1 other
doordash
66 m away inspections
Phone
2487929928
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa9f36e92e385; Of6cae8fc6a6f

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
doordashpho shi troy
24154482
2008 West Big Beaver Road, Troy, MI, 4808442.56213, -83.174802026-10-082026-11-16
inspectionsPHO SHI
inspections|mi|SFE-3963-263697
2008 W BIG BEAVER RD, Troy, MI, 4808442.56180, -83.175462026-11-202026-11-20
overturePho-Shi
9cbd6228-2bda-4710-b767-dd6f2f29130d
2008 W Big Beaver Rd, Troy, MI, 48084248792992842.56220, -83.174792026-11-152026-11-15

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
doordash pho shi troyinspections PHO SHI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00
doordash pho shi troyoverture Pho-Shi1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00
inspections PHO SHIoverture Pho-Shi1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
95 within 1 mi · 591 within 3 mi
Off / on premise
22 / 63 within 1 mi · 134 / 353 within 3 mi
Selling alcohol
39 within 1 mi · 296 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.08 mi
Setting
urban (3,156 people per sq mi)
People within 3 mi
89,240 (69,103 adults 21+, 38,966 households) from 27 tract(s), tracts within 3 mi
Income
per capita $72,340 · median household ~$123,594 (weighted mean of tract medians)
Age and education
median age ~41.2 · bachelor's or higher 67%
Ethnicity
Hispanic 4% · White 71% · Black 4% · Asian 18%
Adults per alcohol outlet
233
Alcohol spend within 3 mi
$33,645,685 a year ($14,717,956 at home, $18,916,187 away) · $113,668 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-20 22:08insertinspections inspections|mi|SFE-3963-263697 ↔ overture 9cbd6228-2bda-4710-b767-dd6f2f29130dsame address and namemerged17
2026-11-20 22:08insertdoordash 24154482 ↔ inspections inspections|mi|SFE-3963-263697same address and namemerged17
2026-11-15 17:57insertdoordash 24154482 ↔ overture 9cbd6228-2bda-4710-b767-dd6f2f29130dsame address and namemerged15