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

[Petter Reinholdtsen]

[SteveC]
> thats fantastic!

Yes, it is.

By using SQL cursors, I was finally able to extract the complete list
of points and generate GPX files including the 7 million GPS points.

I split the file by month, and compressed them.  The complete dump is
available from <URL:http://developer.skolelinux.no/~pere/openstreetmap/>.

Next step is to write the GPX import tool to store the points into
your database.  Unless someone is already working on this, I will have
a look later.  But I suspect the import should be done locally, as the
amount of data is huge, and it will take forever to insert 7 million
GPS points using XML-RPC over the Internet.

(I tried to import the files into qgis, but ran out of memory. :( ))