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

[Ross Scanlon]

On Mon, 2 Jun 2008 08:26:11 -0700 (PDT)
Hamish <hamish_b at yahoo.com> wrote:

> > After three days I have finally have got gpsdrive working
> > with mapnik and osm data on Ubuntu 8.04
> > 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.

Actually I've found how to change this.

Open file ~/.gpsdrive/osm.xml in a text editor.

Third line where it starts <Map bgcolor="#ffeed4" ...

Change the #ffeed4 to whatever colour you want the sea to appear.  This is a red/green/blue triplet as in html/css.

Throughout this file there are numerous color="#......" entries which will change rendered colours to whatever you like.

> > 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'" ?


Thought about this but reimport to where?  Are the poi in the postgres osm database or somewhere 
else?



I looked at exporting these to osm but a lot are not overly accurate and so did not want to put erroneous data into that.  Most probably do not comply with the licencing of osm either as the locations are from addresses put through google's geocode to generate the lat/long.  Ususally ends up on the correct road but not always at the correct location (generally within a few hundred metres).


-- 


 Regards
 Ross
 ross at theinternethost.com.au

 -------------------------------------------
 The Internet Hosting Company
 Low Cost, High Value web Hosting and Design
 http://www.theinternethost.com.au
 E: info at theinternethost.com.au
 -------------------------------------------