Talk:TangoGPS
From Openmoko
subproject
(geocaching)
import navicache.com waypoints via gpx (xml) into tangogps's ~/.tangogps/poi.db (sqlitedb)
example navicache.com gpx file
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?> <gpx version="1.0" creator="NaviCache Cache Download 1.0.0 - http://www.navicache.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.topografix.com/GPX/1/0" xsi:schemaLocation="http://www.topografix.com/GPX/1/0 http://www.topografix.com/GPX/1/0/gpx.xsd "> <name>acountnames's GPX download</name> <author>NaviCache.com</author> <email>support@navicache.com</email> <url>http://www.navicache.com</url> <urlname>NaviCache</urlname> <time>2009-02-06T21:35:30Z</time> <wpt lat="39.3173666666667" lon="-84.54635"> <name>N00BD5</name> <desc>A Chip Off the Old Block by Web_ling</desc> <url>http://www.navicache.com/cgi-bin/db/displaycache2.pl?CacheID=3029</url> <urlname>Cache Details</urlname> <sym>Default</sym> <type>Geocache</type> </wpt> <wpt lat="39.32035" lon="-84.5737333333333"> <name>N0114D</name> <desc>Cache Hopper by Web_ling</desc> <url>http://www.navicache.com/cgi-bin/db/displaycache2.pl?CacheID=4429</url> <urlname>Cache Details</urlname> <sym>Default</sym> <type>Geocache</type> </wpt>
poi.db format/schema?
i exported the poi.db tangogps created with my example poi cat poi.db.sql.txt BEGIN TRANSACTION; 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); COMMIT;