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
