3 ms·
> I didn't publish the code (or better said, I didn't make it public), but it's similar to yours. Instead of SQLite I used a PostGis database where I stored the
by vageli 5y ago
> I didn't publish the code (or better said, I didn't make it public), but it's similar to yours. Instead of SQLite I used a PostGis database where I stored the apartments with their point to point public transport distance from my office (pre-covid search). I did it in Rust.
How did you convert an address to long/lat for postgis?
- denysvitali 5y agoI was lucky, the data also included lat/lng and the address for most (if not all) the entries. If I would have been confronted with such a situation though, I would have probably used some Geocoding API like Google Maps's geocoding [0] or OSM's Nominatim [1]. [0]: https://developers.google.com/maps/documentation/geocoding/overview https://developers.google.com/maps/documentation/geocoding/o... [1]: https://wiki.openstreetmap.org/wiki/Nominatim https://wiki.openstreetmap.org/wiki/Nominatim
- mattrighetti 5y agoYou could use nominatim [0] [0]: https://nominatim.org https://nominatim.org
- megous 5y agoSome countries publish all addresses with geolocation information as part of open data initiatives.