[Openstreetmap] major db refactoring and GPS data

[Robert Scott]

On Tuesday 17 Jan 2006 16:16, SteveC wrote:
> 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?

This is actually a feature I've been looking for and I would really love to be 
able to use, but unfortunately would only be useful to me if I spent ages 
harassing garmin to make a firmware update which logged this information - I 
doubt they'd be very interested.

Being able to plot breadcrumbs in slightly different colours according to 
their reliability _would_ be great. But that's clearly a hypothetical.

> As well as for a move to postgres at
> some point.

Hm. I had always assumed you were using postgis 
( http://postgis.refractions.net/ ).


-robert.