[Maps-l] New Planet-Import with extra hstore columns

Peter Körner osm-lists at mazdermind.de
Fri Jun 25 08:32:47 UTC 2010


Hi

I'd like to start a new planet import using the new --hstore-column 
feature of osm2pgsql. It would allow us to have a "name:" column, 
containing all translations and thus allow better rendering of 
translated objects.

I'll run it directly on ptolemy into the existing osm_mapnik database 
but with a different prefix. The exact command is

time ./osm2pgsql \
	--slim \
	--cache 2000 \
	--style default.style \
	--prefix planet_hc \
	--host sql-mapnik \
	--database osm_mapnik \
	--hstore \
	--hstore-column "name:" \
	--hstore-column "addr:" \
	--hstore-column "wikipedia:" \
	$HOME/data/planet/planet-100623.osm.bz2

Peter



More information about the Maps-l mailing list