<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I would suggest use OSM’s Nominatim geocoding service…<div class="">Take a look here: <a href="http://wiki.openstreetmap.org/wiki/Nominatim#Reverse_Geocoding" class="">http://wiki.openstreetmap.org/wiki/Nominatim#Reverse_Geocoding</a></div><div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><div class=""><div style="orphans: 2; widows: 2;" class="">Regards,</div><div style="orphans: 2; widows: 2;" class="">Luiz Claudio</div></div><div class=""><br class=""></div></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">Em 2 de abr de 2017, à(s) 19:16, suraj birla <<a href="mailto:surajbirla@gmail.com" class="">surajbirla@gmail.com</a>> escreveu:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi ,<div class="">I've a requirement to get the address ( country, state/provinces, postal code) for a given lat/lon. I need to this for 100 million+ records.</div><div class=""><br class=""></div><div class="">I'm planning to do this in 3 phases</div><div class="">First find the country using world polygon</div><div class="">Second find the state/provinces for the identified country</div><div class="">Postal code ??? </div><div class=""><br class=""></div><div class="">Question.</div><div class="">1.Whether my approach is correct?</div><div class="">2. Where can I find the polygon for the world map by country.</div><div class="">3. How I can find postal code ?</div><div class=""><br class=""></div><div class="">Thanks</div><div class="">Suraj</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div class=""><br class=""></div><div class=""><br class=""><div class=""><div class=""><br class=""></div><div class=""><br class=""></div></div></div></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=""></div></body></html>