[Openstreetmap] How do we handle large amount of GPS points?

SteveC steve at fractalus.com
Sun Nov 21 22:45:38 GMT 2004

* Petter Reinholdtsen (pere at hungry.com) wrote:
> > Now, my table looks like lat,lon,alt,time,userid
> My table includes (lat,lon)::point, altitude, quality
> (0,1=gpx,2=dgps), satellites, and hor. dilution.  I fetch data using
> the GGA NMEA sentence.

Ok, AFAIR talking to matt we need more than this. We need track numbers
and stuff to do line extraction, and data for later dgps resoving. To
clear this up, how does this scheme look where we ignore exactly
how lat/long is stored (eg two columns or in a Point or what).

lat float not null
long float not null
alt float not null
hor_dilution float
vert_dilution float
track num bigint
quality byte
satellites (type spec for this?)
timetamp long
time_dilution int
uid bigint not null


have fun,

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

More information about the talk mailing list