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

[Jorge Gustavo Rocha]

Hi,

You can import the timezone shapefile [1] in postgis and then use the
st_contains function to return the proper timezone id. Make sure you use
a GIST index. The timezone table has 27742 rows. If you have points at
the sea, maybe this shapefile is not suitable. Try to find a another one.

[1] http://efele.net/maps/tz/world/

If you have trouble with the query, post here your attempt and we will
try to help.

Regards,

Jorge Gustavo


Às 21:23 de 22-03-2017, suraj birla escreveu:
> 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
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor