data engineering

Timezones from coordinates (lat/long): enriching ingestion with PostGIS

A datetime with an offset isn't a timezone. Here's how we use PostGIS and the Timezone Boundary Builder dataset to turn a driver's GPS coordinates into the IANA zone their planner actually needs to see.