Talk:TangoGPS

From Openmoko

Revision as of 23:15, 7 February 2009 by Kd8ikt (Talk | contribs)

Jump to: navigation, search

subproject

navicache poi import

(geocaching) work in progress HELPHELPHELP

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;


conclusion i'm looking into python for importing/parsing the lat lon name and desc inside each waypoint heading then export those into the tangogps sqlite poi.db

Personal tools

subproject

navicache poi import

(geocaching) work in progress HELPHELPHELP

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;


conclusion i'm looking into python for importing/parsing the lat lon name and desc inside each waypoint heading then export those into the tangogps sqlite poi.db