POI waypoints.db with zoom >= 50000

View: New views
9 Messages — Rating Filter:   Alert me  

POI waypoints.db with zoom >= 50000

by Rick Richardson-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I was using 2.09 and MySQL.  So I svn checkout the latest (2.10 pre8) and create the sqlite3 ~/.gpsdrive/waypoints.db.

$ geo-2gpsdrive -V 2.10 -P -S ~/Caches/999.tabsep

BUT, the waypoints (Geocaches) don't get drawn unless the zoom is appoximately 1:50000 or less.  This sucks!  However, ~/.gpsdrive/way.txt do get drawn.

What do I look for in the *.c to patch this?

--
Rick Richardson rick.richardson@... http://rickrich1.home.comcast.net/
Linux printer drivers for JBIG (GDI printers): Konica Minolta magicolor,
                         HP LaserJet, Samsung, Xerox, Lexmark, and Oki.
                                           http://foo2zjs.rkkda.com/
Linux tools for geocaching                  http://geo.rkkda.com/


_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Guenther Meyer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Am Sonntag 25 Oktober 2009 14:39:56 schrieb Rick Richardson:

> I was using 2.09 and MySQL.  So I svn checkout the latest (2.10 pre8) and
> create the sqlite3 ~/.gpsdrive/waypoints.db.
>
> $ geo-2gpsdrive -V 2.10 -P -S ~/Caches/999.tabsep
>
> BUT, the waypoints (Geocaches) don't get drawn unless the zoom is
> appoximately 1:50000 or less.  This sucks!  However, ~/.gpsdrive/way.txt do
> get drawn.
>
> What do I look for in the *.c to patch this?
>
there's no patching necessary.
you can change the range for that the points are shown in the sqlite database
in /usr/share/gpsdrive/geoinfo.db
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Rick Richardson-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

What do I use to admin the setting? 

On Sun, Oct 25, 2009 at 11:07 AM, Guenther Meyer <d.s.e@...> wrote:
Am Sonntag 25 Oktober 2009 14:39:56 schrieb Rick Richardson:
> I was using 2.09 and MySQL.  So I svn checkout the latest (2.10 pre8) and
> create the sqlite3 ~/.gpsdrive/waypoints.db.
>
> $ geo-2gpsdrive -V 2.10 -P -S ~/Caches/999.tabsep
>
> BUT, the waypoints (Geocaches) don't get drawn unless the zoom is
> appoximately 1:50000 or less.  This sucks!  However, ~/.gpsdrive/way.txt do
> get drawn.
>
> What do I look for in the *.c to patch this?
>
there's no patching necessary.
you can change the range for that the points are shown in the sqlite database
in /usr/share/gpsdrive/geoinfo.db
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive



--
Rick Richardson rick.richardson@... http://rickrich1.home.comcast.net/
Linux printer drivers for JBIG (GDI printers): Konica Minolta magicolor,
                         HP LaserJet, Samsung, Xerox, Lexmark, and Oki.
                                           http://foo2zjs.rkkda.com/
Linux tools for geocaching                  http://geo.rkkda.com/

Samuel Goldwyn  - "I'm willing to admit that I may not always be right, but I am never wrong."
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by hamish_b :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> there's no patching necessary.
>
> you can change the range for that the points are shown in
> the sqlite database
>
> in /usr/share/gpsdrive/geoinfo.db


Rick:
> What do I use to admin the setting?  



try "sqlitebrowser".

also there is a popular plugin for firefox whose names escapes me right
now.



Hamish
(greetings from Google HQ)



     
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Guenther Meyer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Am Sonntag 25 Oktober 2009 19:33:56 schrieb Hamish:

> > there's no patching necessary.
> >
> > you can change the range for that the points are shown in
> > the sqlite database
> >
> > in /usr/share/gpsdrive/geoinfo.db
>
> Rick:
> > What do I use to admin the setting?
>
> try "sqlitebrowser".
>
if you know sql, you could also use the sqlite3 commandline tool.
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Guenther Meyer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Am Sonntag 25 Oktober 2009 20:10:25 schrieb Guenther Meyer:

> Am Sonntag 25 Oktober 2009 19:33:56 schrieb Hamish:
> > > there's no patching necessary.
> > >
> > > you can change the range for that the points are shown in
> > > the sqlite database
> > >
> > > in /usr/share/gpsdrive/geoinfo.db
> >
> > Rick:
> > > What do I use to admin the setting?
> >
> > try "sqlitebrowser".
>
> if you know sql, you could also use the sqlite3 commandline tool.
>
to show geocaches at scales of 1:100000 and less use the following sql
statement:
  update poi_type set scale_max=100000 where poi_type like 'geocache%';

but maybe you should use a copy of the original geoinfo.db and set its path in
gpsdriverc; otherwise your changes may be overwritten on the next gpsdrive
update.
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Rick Richardson-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I assume that sqlite and sqlitebrowser will not be neccesary in 2.10, and gpsdrive will provide the interface!

On Sun, Oct 25, 2009 at 2:17 PM, Guenther Meyer <d.s.e@...> wrote:
Am Sonntag 25 Oktober 2009 20:10:25 schrieb Guenther Meyer:
> Am Sonntag 25 Oktober 2009 19:33:56 schrieb Hamish:
> > > there's no patching necessary.
> > >
> > > you can change the range for that the points are shown in
> > > the sqlite database
> > >
> > > in /usr/share/gpsdrive/geoinfo.db
> >
> > Rick:
> > > What do I use to admin the setting?
> >
> > try "sqlitebrowser".
>
> if you know sql, you could also use the sqlite3 commandline tool.
>
to show geocaches at scales of 1:100000 and less use the following sql
statement:
 update poi_type set scale_max=100000 where poi_type like 'geocache%';

but maybe you should use a copy of the original geoinfo.db and set its path in
gpsdriverc; otherwise your changes may be overwritten on the next gpsdrive
update.
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive



--
Rick Richardson rick.richardson@... http://rickrich1.home.comcast.net/
Linux printer drivers for JBIG (GDI printers): Konica Minolta magicolor,
                         HP LaserJet, Samsung, Xerox, Lexmark, and Oki.
                                           http://foo2zjs.rkkda.com/
Linux tools for geocaching                  http://geo.rkkda.com/

Joan Crawford  - "I, Joan Crawford, I believe in the dollar. Everything I earn, I spend."
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Rick Richardson-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Oh yeah, Fedora11 has this for geoinfo.db...

$ locate geoinfo.db
/home/rick/proj/gpsdrive2/trunk/data/geoinfo.db
/usr/share/icons/map-icons/geoinfo.db

$ sqlitebrowser /usr/share/icons/map-icons/geoinfo.db


On Sun, Oct 25, 2009 at 2:39 PM, Rick Richardson <rick.richardson@...> wrote:
I assume that sqlite and sqlitebrowser will not be neccesary in 2.10, and gpsdrive will provide the interface!


On Sun, Oct 25, 2009 at 2:17 PM, Guenther Meyer <d.s.e@...> wrote:
Am Sonntag 25 Oktober 2009 20:10:25 schrieb Guenther Meyer:
> Am Sonntag 25 Oktober 2009 19:33:56 schrieb Hamish:
> > > there's no patching necessary.
> > >
> > > you can change the range for that the points are shown in
> > > the sqlite database
> > >
> > > in /usr/share/gpsdrive/geoinfo.db
> >
> > Rick:
> > > What do I use to admin the setting?
> >
> > try "sqlitebrowser".
>
> if you know sql, you could also use the sqlite3 commandline tool.
>
to show geocaches at scales of 1:100000 and less use the following sql
statement:
 update poi_type set scale_max=100000 where poi_type like 'geocache%';

but maybe you should use a copy of the original geoinfo.db and set its path in
gpsdriverc; otherwise your changes may be overwritten on the next gpsdrive
update.
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive



--
Rick Richardson rick.richardson@... http://rickrich1.home.comcast.net/
Linux printer drivers for JBIG (GDI printers): Konica Minolta magicolor,
                         HP LaserJet, Samsung, Xerox, Lexmark, and Oki.
                                           http://foo2zjs.rkkda.com/
Linux tools for geocaching                  http://geo.rkkda.com/

Joan Crawford  - "I, Joan Crawford, I believe in the dollar. Everything I earn, I spend."



--
Rick Richardson rick.richardson@... http://rickrich1.home.comcast.net/
Linux printer drivers for JBIG (GDI printers): Konica Minolta magicolor,
                         HP LaserJet, Samsung, Xerox, Lexmark, and Oki.
                                           http://foo2zjs.rkkda.com/
Linux tools for geocaching                  http://geo.rkkda.com/

Ogden Nash  - "The trouble with a kitten is that when it grows up, it's always a cat."
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

Re: POI waypoints.db with zoom >= 50000

by Guenther Meyer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Am Sonntag 25 Oktober 2009 20:39:43 schrieb Rick Richardson:
> I assume that sqlite and sqlitebrowser will not be neccesary in 2.10, and
> gpsdrive will provide the interface!
>
that depends on which gpsdrive version will be called the final 2.10
release... ;-)
this feature will come, but there are other more important things first...


_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive