Interactive publication
Back to the catalogueData qualityCase 05 of 05
Timezone inferred from geography
Bidstream and sensor data often lack a reliable device timezone, so it is inferred from a lat/long via a timezone-boundary shapefile — a GEO × TIME crosswalk. A wrong zone shifts the local hour and the daypart. A lat/long is a location plus an error bar, and so is the tz lookup it feeds.
Class
Case to account for
Affects
2 conversions
01
Detection
The zone is derived from coordinates rather than declared.
02
Mitigation
01
Record the tz source and confidence; cap daypart precision to the lookup's reliability, exactly as the geo KB caps a point→cell assignment to its accuracy radius.
03
Affected conversions
Daypart (local band) ⇄ UTC slot-set
OPENTimestamp + zonehour-of-week slot
OPEN