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

[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 told what's the difference. I can reveal that for me writing a couple of PostgreSQL functions _is_ hard (well, don't know for sure because I have never tried to program anything) while it did not took more than a day to make select from hstore to work inside mapfile's DATA. In addition hstore can be indexed with gin or gist indexes and they seem to work pretty well.

-Jukka-


-----Alkuperäinen viesti-----
Lähettäjä: mapserver-users-bounces at lists.osgeo.org puolesta: Milo van der Linden
Lähetetty: to 20.5.2010 18:17
Kopio: mapserver-users at lists.osgeo.org
Aihe: Re: [mapserver-users] Mapserver, OpenStreetMap and hstore - greatnew	possibilities
 
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 to make these arrays searchable.

Kind regards,


Milo van der Linden
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users