[mapserver-users] Mapserver, OpenStreetMap and hstore - great new possibilities

2010-05-20 Thread Rahkonen Jukka
Hi, For those playing with OpenStreetMap data: it is worth knowing that it is now possible to import all the tags that exists in the OpenStreetMap data into PostGIS. New version of osm2pgsql has an option to import just everything into PosgreSQL column of type hstore. I do not know what it is

Re: [mapserver-users] Mapserver, OpenStreetMap and hstore - great new possibilities

2010-05-20 Thread Milo van der Linden
This was already possible when setting the --slim option whilst using osm2pgsql. Only issue is that when doing so, you get columns that contain arrays with key/value pairs. But when installing the arrayint postgresql extension it is not to hard to write a couple of functions for the database

Re: [mapserver-users] Mapserver, OpenStreetMap and hstore - great new possibilities

2010-05-20 Thread Rahkonen Jukka
Hi, Do you mean the tags colums in tables osm_nodes and osm_rels? They do not look quite the same for me. I have thought that slim mode also imports only those tags which are included in the default.style file while the new -k option imports them all automatically. But even if I am wrong you