[postgis-users] Reverse Geocode

Maurizio Napolitano napoogle at gmail.com
Mon Jul 15 11:03:37 PDT 2019

You can find all the answers to your questions here

Il lun 15 lug 2019, 19:53 suraj birla <surajbirla at gmail.com> 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
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190715/579dcb9e/attachment.html>

More information about the postgis-users mailing list