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

[Ross Scanlon]

Hi All,

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 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.


When trying to access the database for poi's it keeps giving an error.  I've narrowed this down to the fact there is no column poi in the table planet_osm_points.

What should have put this column into the database table?  Is it something that needs to be run seperately when installing gpsdrive and/or mapnik?


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.


TIA

Cheers
Ross