<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.5945" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>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 actually but it behaves
like a garden shed and collects all the junk that exists, with the difference
that from hstore it is also possible to find something.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>I had a try by
importing some OSM data into PostGIS and making a Mapserver layer that
queries the hstore column. LAYER DATA is something like
this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>DATA "way from
(select (way),osm_id,tags from osm_point where (tags @>'amenity=>cafe'))
as foo using unique osm_id using srid=2393"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>This layer shows now
all the points which have amenity=cafe tag in the OSM data. Layer can also
be make to dynamic one by using variables</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>DATA "way from
(select (way),osm_id,tags from osm_point where (tags @>'%tag%=>%value%'))
as foo using unique osm_id using srid=2393"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>By
adding &tag=something&value=somevalue into WMS GetMap request
I can show on a map just enything that I want from OSM data. And
GetFeatureInfo can show all the tags of the queried feature, see a QGis example
at <A
href="http://wiki.openstreetmap.org/wiki/User_talk:JRA">http://wiki.openstreetmap.org/wiki/User_talk:JRA</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010>-Jukka
Rahkonen-</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=169301712-20052010> </DIV>
<DIV><BR></DIV>
<DIV><BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=169301712-20052010></SPAN></FONT> </DIV></BODY></HTML>