Geocode-sqlite: Geocode rows in an SQLite database table
1–10 of 20 posts
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#2Most egregious example of an editorialized title I've ever seen on HN, ha.
You don't actually pronounce it "ESS-CUE-ELL ITE", do you?!
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#3Not to be confused with spatial lite which trended on the front page earlier this year: https://www.gaia-gis.it/fossil/libspatialite/index
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#4Just keep in mind while there is no API key required for OSM's Nominatum, there are no guarantees and they explicitly discourage bulk geocoding, with no clarification on what is bulk. [1] The lack of clarification seems intentional, which is understandable.
geocode-sqlite does support non-OSM hosted instances of Nominatum so find an alternative if you have large or regular geocoding tasks.
[1] https://operations.osmfoundation.org/policies/nominatim/
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#5Just keep in mind while there is no API key required for OSM's Nominatum, there are no guarantees and they explicitly discourage bulk geocoding, with no clarification on what is bulk. [1] The lack of clarification seems intentional, which is understandable. geocode-sqlite does support non-OSM hosted instances of Nominatum so find an alternative if you have large or regular geocoding tasks. [1] https://operations.osmf…
I've been trying to find a good self hosted docker version but just haven't had any luck. I have about 30k addresses I need to geocode and the paid solution are way out of budget.
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#6I recently ran into the problem of how to efficiently filter a list of geo-locations based on a specific distance to a given geo-location. I could not find any discussion anywhere about possible algorithms. Does anyone have a recommendation (article, book, Web-site)?
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#7I recently ran into the problem of how to efficiently filter a list of geo-locations based on a specific distance to a given geo-location. I could not find any discussion anywhere about possible algorithms. Does anyone have a recommendation (article, book, Web-site)?
If you can use PostgreSQL, the obvious solution is PostGIS and the "geography" data type:
https://postgis.net/ https://postgis.net/docs/postgis_usage.html#PostGIS_Geograph...
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#8The name is misleading to me. The name implies you can geocode from sqlite querying but this is basically a python package that uses sqlite as the data store for locations to be geocoded and where the results are stored.
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#9I recently ran into the problem of how to efficiently filter a list of geo-locations based on a specific distance to a given geo-location. I could not find any discussion anywhere about possible algorithms. Does anyone have a recommendation (article, book, Web-site)?
https://gis.stackexchange.com/ and to a lesser extend https://help.openstreetmap.org/
Re: Geocode-sqlite: Geocode rows in an SQLite database table
#10Just keep in mind while there is no API key required for OSM's Nominatum, there are no guarantees and they explicitly discourage bulk geocoding, with no clarification on what is bulk. [1] The lack of clarification seems intentional, which is understandable. geocode-sqlite does support non-OSM hosted instances of Nominatum so find an alternative if you have large or regular geocoding tasks. [1] https://operations.osmf…
The example of Nominatum use at the geocode-sqlite page shows using a local, thus non-OSM hosted, instance of Nominatum.
nominatum = Nominatum(user_agent="this-is-me", domain="nominatum.local.dev", scheme="http")
I have not tried it myself, thus if it fails, could you please report on what goes wrong there?