Talk:TangoGPS

From Openmoko

(Difference between revisions)
Jump to: navigation, search
(navicache poi import)
Line 6: Line 6:
  
  
example navicache.com gpx file
+
<B>example navicache.com gpx file </B>
 
<PRE>
 
<PRE>
 
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
 
<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
Line 69: Line 69:
  
  
poi.db format/schema?
+
<B>poi.db format/schema? </B>
  
 
<PRE>
 
<PRE>
Line 82: Line 82:
  
  
conclusion  
+
<B>conclusion </B><br>
 
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
 
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

Revision as of 23:16, 7 February 2009

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