[Openstreetmap] major db refactoring and GPS data
lists at riscott.ukfsn.org
Tue Jan 17 17:10:06 GMT 2006
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/ ).
More information about the talk