Thread: Maemo Mapper v1.4 for 770/N800
View Single Post
cjackiewicz is offline cjackiewicz
2007-02-20 , 17:53
Posts: 116 | Thanked: 5 times | Joined on Jun 2006 @ Warsaw, Poland
#58
Originally Posted by revwillie View Post
Is there a way to make my own POI database with known coordinates from other sources?
Yes, it's very simple. Install sqlite3, and:
- create new database:

sqlite3 new_poi.db

- create new category:

sqlite> insert into category (label, desc, enabled) values ('Geocaching', 'Geocaching category', 1);

- new poi:

insert into poi (lat, lon, label, desc, cat_id) vales (52.000, 21.000, 'Box', 'black box', 1);

(where 1 is category ID), add more poi...

- close database - type .q (dot q)