[OSM-talk] calling all python coders for slippy map help

[Jon Burgess]

On Wed, 2006-11-15 at 23:14 +0000, SteveC wrote:
> Hi
> 
> We need help with the slippy map code. We need something that will do
> what this script does (or better):
> 
> http://wiki.openstreetmap.org/index.php/Slippy_Map#python_script
> 
> but not take an infinite amount of memory and do the entire planet.osm
> dump. Then we can generate tiles for everywhere.
> 
> Answers on a postcard.

Not quite what you asked for, but i've had a go at converting the python
script into C. It looks like it produces SQL which looks like the output
of the python script.

On my Athlon64 3000 w/ 2GB of ram it takes about 15 minutes to convert 
planet.osm to an SQL file. The maximum RAM usage seemed to be around
650MB. 

$ time gzip -dc ~/osm/planet/planet-061023.osm.gz | ./convert - >
planet-061023.sql

real    14m27.840s
user    11m9.432s
sys     0m27.593s
[jburgess at shark osm2pg]$ ls -l planet-061023.sql
-rw-r--r-- 1 jburgess jburgess 1114594272 Nov 16 23:04 planet-061023.sql


I've yet to get the rest of the postgres/postgis/mapnik toolchain in
place to know whether there any problems with the output. Perhaps
someone them setup already might be able to try it out. 

Let me know if you want me to email the sources or add them to SVN.

	Jon