[ gpsdrive ] gpsdrive, mapnik, openstreetmap and poi's

[Hamish]

Ross Scanlon 
> After three days I have finally have got gpsdrive working
> with mapnik and osm data on Ubuntu 8.04
> 
> I will write it all up as a howto shortly

nice,

> but first, a couple of questions.
> 
> How can I change the colours used by/with mapnik. 
> Currently the ocean is rendered as a lovely (i'm being
> sarcastic) shade of yellow/orange.
> 
> All the rivers and creeks etc are shaded blue, road shading
> is correct.

If someone decides to work on this, may I suggest (re)using the IHO's S-52 coloring standard as a starting point? details here:
  http://grass.osgeo.org/wiki/S-57_data#GRASS_S-52_interface_for_rendering_S-57_data


> How can I access all my mysql poi's from previous
> gpsdrive installation?  I have about 5000 in a mysql
> database that I was using previously with gpsdrive.

dump to .csv then reimport?

does SQLite support "COPY table FROM 'filename.txt'" ?


Hamish