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

[suraj birla]

Thanks John and Jorge. It worked.

On Wed, Mar 22, 2017 at 4:21 PM, John Abraham <jea at hbaspecto.com> wrote:

> 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
>
> *http://efele.net/maps/tz/world/ <http://efele.net/maps/tz/world/>*
>
>
> --
> 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
>
>
>
> _______________________________________________
> 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/20170327/a8686ae7/attachment.html>