[Openstreetmap] How do we handle large amount of GPS points?
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
track num bigint
satellites (type spec for this?)
uid bigint not null
SteveC steve at fractalus.com http://www.fractalus.com/steve/
More information about the talk