[Openstreetmap] How do we handle large amount of GPS points?
pere at hungry.com
Sat Dec 4 21:45:10 GMT 2004
> 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. :( ))
More information about the talk