PetSmart

Colonie, NY 12110 · O88759cd4cf7e · first seen 2026-10-08
3 sourcesnon beverage · pet_supplychain: Petsmartalcohol: no alcohol retail

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
PetSmart 1 other
the most common name a source states
petsmart latham doordash
Street
609 Troy Schenectady Rd 2 other
ubereats
609 Troy Schenectady Road doordash
609 Troy-Schenectady Rd overture
City
Latham 1 other
ubereats
Colonie overture
State
NY
ubereatsno other value
ZIP
12110
ubereatsno other value
Pin
42.75491, -73.76596 map
ubereatsno other value
Phone
5187854621
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob617593bb8f0; Oa21a83a9c2c0

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
doordashpetsmart latham
1440093
609 Troy Schenectady Road, Latham, NY, 1211042.75503, -73.766002026-10-082026-11-06
overturePetSmart
c23967b0-9699-400f-bd0a-9ef9930ee3b7
609 Troy-Schenectady Rd, Colonie, NY, 12110
ZIP lookup: Latham, NY
518785462142.75511, -73.765982026-11-062026-11-06
ubereatsPetSmart
tLdxYlWmVkamhWvjcP8O_Q
609 Troy Schenectady Rd, Latham, NY, 1211042.75491, -73.765962026-11-012026-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
doordash petsmart lathamoverture 69bfeb78-cb72-419f-88f2-4218d55c64901.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
overture 69bfeb78-cb72-419f-88f2-4218d55c6490ubereats PetSmart1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
doordash petsmart lathamubereats PetSmart1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
overture PetSmartubereats PetSmart1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00

Attributes

Channel
non_beverage · pet_supply — ubereats-type conflicting evidence
Chain
Petsmart — ubereats-parent
Alcohol
no_alcohol_retail — Petsmart: licensed at 0 of 510 outlets in licence states
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "non_beverage",
   "pet_supply"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
105 within 1 mi · 255 within 3 mi
Off / on premise
35 / 53 within 1 mi · 69 / 125 within 3 mi
Selling alcohol
53 within 1 mi · 153 within 3 mi
Nearest
same channel 1.28 mi · licensed 0.21 mi
Setting
suburban (1,720 people per sq mi)
People within 3 mi
48,637 (35,214 adults 21+, 18,816 households) from 11 tract(s), tracts within 3 mi
Income
per capita $54,106 · median household ~$106,993 (weighted mean of tract medians)
Age and education
median age ~39.1 · bachelor's or higher 47%
Ethnicity
Hispanic 4% · White 75% · Black 7% · Asian 10%
Adults per alcohol outlet
230
Alcohol spend within 3 mi
$14,928,758 a year ($6,692,565 at home, $8,229,735 away) · $97,574 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:13insertdoordash 1440093 ↔ overture 69bfeb78-cb72-419f-88f2-4218d55c6490same address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture 69bfeb78-cb72-419f-88f2-4218d55c6490 ↔ ubereats tLdxYlWmVkamhWvjcP8O_Qsame address and nameheld: same-source-conflict11
2026-11-06 18:13insertoverture c23967b0-9699-400f-bd0a-9ef9930ee3b7 ↔ ubereats tLdxYlWmVkamhWvjcP8O_Qsame address and namemerged11
2026-11-01 21:05backfilldoordash 1440093 ↔ ubereats tLdxYlWmVkamhWvjcP8O_Qsame address and namemerged