Re:OsmAnd's Faster Offline Navigation
by 1vuio0pswjnm7 on Friday February 27, 2026 @07:45PM
(#47188369)
"The best solution I have come up with is to use Google maps to find the address and then copy that into the other app but at that point I might as well use Google maps."
I create an SQLite database of business street addresses using online Yellow Pages, e.g., yellowpages.com
I wrote a simple utility to extract the name, address, phone and URL data from the HTML and convert to SQL. I make the .db file and test it on a laptop
Then I copy the .db file to the phone and query using sqlite3 in Termux
I can then search and copy addresses into OsmAnd or Google Maps
I create an SQLite database of business street addresses using online Yellow Pages, e.g., yellowpages.com
I wrote a simple utility to extract the name, address, phone and URL data from the HTML and convert to SQL. I make the .db file and test it on a laptop
Then I copy the .db file to the phone and query using sqlite3 in Termux
I can then search and copy addresses into OsmAnd or Google Maps