View source for Talk:TangoGPS

From Openmoko

Jump to: navigation, search

You do not have permission to edit this page, for the following reasons:

  • The action you have requested is limited to users in the group: Administrators.
  • You must confirm your email address before editing pages. Please set and validate your email address through your user preferences.

You can view and copy the source of this page:

Return to Talk:TangoGPS.

Personal tools


navicache poi import


import geocache waypoints via gpx (xml) into tangogps's ~/.tangogps/poi.db (sqlitedb)

example gpx file

<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>



   creator="NaviCache Cache Download 1.0.0 -"



   xsi:schemaLocation=" ">

      <name>acountnames's GPX download</name>






      <wpt lat="39.3173666666667" lon="-84.54635">


         <desc>A Chip Off the Old Block by Web_ling</desc>


         <urlname>Cache Details</urlname>




      <wpt lat="39.32035" lon="-84.5737333333333">


         <desc>Cache Hopper by Web_ling</desc>


         <urlname>Cache Details</urlname>




poi.db format/schema?

i exported the poi.db tangogps created with my example poi in sql txt file format

$cat poi.db.sql.txt 
CREATE TABLE poi (			idmd5 TEXT, lat REAL, lon REAL, visibility REAL, cat REAL, subcat REAL, 		keywords TEXT, desc TEXT, price_range REAL, extended_open REAL,			creator TEXT, bookmarked REAL, user_rating REAL, rating REAL, user_comment TEXT);
INSERT INTO poi VALUES(109496141722186324,39.283409,-84.317535,0.0,14.0,0.0,'home','home duh',3.0,0.0,NULL,NULL,NULL,NULL,NULL);