Maurizio, Thank you very much for pointing to me right direction.
On Mon, Jul 15, 2019 at 11:03 AM Maurizio Napolitano <[email protected]> wrote: > You can find all the answers to your questions here > https://www.stevegattuso.me/2019/05/29/postgis-reverse-geocoder.html > Enjoy > > Il lun 15 lug 2019, 19:53 suraj birla <[email protected]> ha scritto: > >> Hi, >> >> Our environment has Postgres database with PostGIS extension. >> User/application run postGIS query. Works fine. >> >> Normally we get millions of point ( lat/lon) and our requirement to >> assign addresses to most of the point. >> >> Currently we use Google API/ 3rd party service and call reverse geocode >> api to get the addresses for lat/lon. >> >> Since the number of points are increasing day by day, its becoming >> challenging to process millions of points and sometime our processes get >> hung. Lastly there is cost associated to the API calls and throttle . >> >> I was thinking of loading OSM data into postgres database and then write >> a sql job which will do a lookup to OSM tables and assign address to each >> lat/lon. >> >> >> Question: >> 1. Where do I find free OSM data which I can directly load into database? >> 2. Is there any document /link which will guide to load the address for >> lat/lon? >> 3. Any tips/recommendations? >> >> Thanks >> Suraj >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
