[postgis-users] Timezone for a given lat/long

John Abraham jea at hbaspecto.com
Wed Mar 22 16:21:40 PDT 2017

I use

select tz.tzid from location
        join tz_world tz on st_within(location."locationPoint", tz.geom) 

with the tz_world shapefile that I'm 99% sure I got from


John Abraham
jea at hbaspecto.com

> On Mar 22, 2017, at 3:23 PM, suraj birla <surajbirla at gmail.com> wrote:
> How to find the timezone for a given lat/long  using postgis?
> We have to requirement to fnd the local timezone for millions of records which has  UTC timestamp and lat/long info.
> Google provide API but it's single request per call.. Not feasible for milion records.
> Any suggestion?
> Thanks
> Suraj
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170322/633e816c/attachment.html>

More information about the postgis-users mailing list