Talk:TangoGPS

Revision as of 22:50, 7 February 2009

subproject

navicache poi import

(geocaching)

import navicache.com geocache waypoints via their downloadable 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 in sql txt file format

$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;