[Openstreetmap] major db refactoring and GPS data

[SteveC]

Hello,

I'm refactoring the database which will require some downtime perhaps
tomorrow night again. This is in preperation for getting streets, areas
and curved street segments done. As well as for a move to postgres at
some point.

I'm removing all the dead tables, renaming tables and columns to
sensible names and changing all the timestamp like fields from using
unix time to SQL datetime fields.

This is quite a chunk of work, with changes all over the place in the
codebase.

I've noticed in the gps data table we have fields for:

* horizontal dilution
* vertical dilution
* number of visible satellites
* quality

And none of them are used. Indeed, it's hard to find retail GPS
receivers that even give that data in their output through gpsbabel.
Granted you can get these things out of a USB GPS etc.

So given we have 14 or 15 million rows with 4 unused columns and I don't
recall anyone really wanting that data parsed and stored... should we
keep it?

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/