<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">I use</div><div class=""><br class=""></div><div class="">select tz.tzid from location</div><div class=""> join tz_world tz on st_within(location."locationPoint", tz.geom) </div><div class=""><br class=""></div><div class="">with the tz_world shapefile that I'm 99% sure I got from</div><div class=""><br class=""></div><div class=""><font color="#0069d9" class=""><u class=""><a href="http://efele.net/maps/tz/world/" class="">http://efele.net/maps/tz/world/</a></u></font></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">
<span class="Apple-style-span" style="border-collapse: separate; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; border-spacing: 0px;"><div class=""><div class="">--</div><div class="">John Abraham</div><div class=""><a href="mailto:jea@hbaspecto.com" class="">jea@hbaspecto.com</a></div><div class=""><br class=""></div></div></span></div><div><blockquote type="cite" class=""><div class="">On Mar 22, 2017, at 3:23 PM, suraj birla <<a href="mailto:surajbirla@gmail.com" class="">surajbirla@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">How to find the timezone for a given lat/long using postgis?<div class=""><br class=""></div><div class="">We have to requirement to fnd the local timezone for millions of records which has UTC timestamp and lat/long info.</div><div class=""><br class=""></div><div class="">Google provide API but it's single request per call.. Not feasible for milion records.</div><div class=""><br class=""></div><div class="">Any suggestion?</div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Suraj</div></div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</div></blockquote></div><br class=""></body></html>