<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi,</p>
<p>i'm using QGIS 3.4 on ubuntu and want to categorize some data
using hstore.</p>
<p>i was told (*) to use <b>map_get(hstore_to_map("tags"),'entrance')</b>,
but that does not work (for me). the result is ony one category
for all nodes.<br>
</p>
<p>psql: <br>
</p>
<p><tt>select osm_id,tags->'entrance' "tags->'entrance'"</tt><tt><br>
</tt><tt> from planet_osm_point</tt><tt><br>
</tt><tt> where tags ? 'entrance'</tt><tt><br>
</tt><tt> limit 10;</tt><tt><br>
</tt><tt> osm_id | tags->'entrance' </tt><tt><br>
</tt><tt> ------------+------------------</tt><tt><br>
</tt><tt> 3812284860 | main</tt><tt><br>
</tt><tt> 2312180146 | yes</tt><tt><br>
</tt><tt> 2773679231 | yes</tt><tt><br>
</tt><tt> 339015388 | main</tt><tt><br>
</tt><tt> 561073309 | service</tt><tt><br>
</tt><tt> 367081276 | main</tt><tt><br>
</tt><tt> 339015386 | yes</tt><tt><br>
</tt><tt> 1783531793 | main</tt><tt><br>
</tt><tt> 1783531816 | main</tt><tt><br>
</tt><tt> 367081281 | main</tt><tt><br>
</tt><tt> (10 Zeilen)</tt><tt><br>
</tt><tt> </tt><tt><br>
</tt><tt> Zeit: 3,194 ms</tt><br>
</p>
<p>any idea what's going wrong?<br>
</p>
<p>regards</p>
<p>walter</p>
<p>*)
<a class="moz-txt-link-freetext"
href="https://gis.stackexchange.com/questions/209421/how-to-categorize-features-based-on-hstore-values-in-qgis/288550">https://gis.stackexchange.com/questions/209421/how-to-categorize-features-based-on-hstore-values-in-qgis/288550</a></p>
<p> image: <a class="moz-txt-link-freetext"
href="https://wambachers-osm.website/images/osm/snaps_2018/categorize.png">https://wambachers-osm.website/images/osm/snaps_2018/categorize.png</a></p>
<p>btw: posted this question on qgis-user and FOSSGIS-talk during
the last 2 weeks but did not get any answer :(<br>
</p>
<div class="moz-signature">-- <br>
My projects:<br>
<br>
<a href="https://wambachers-osm.website/boundaries">Admin
Boundaries of the World</a><br>
<a
href="https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries">Missing
Boundaries</a><br>
<a href="https://wambachers-osm.website/emergency">Emergency Map</a><br>
<a href="https://wambachers-osm.website/plz">Postal Code Map
(Germany only)</a><br>
<a href="https://wambachers-osm.website/fools">Fools (QA for
zipcodes in Germany)</a><br>
<a href="https://wambachers-osm.website/pcoundaries"> Postcode
Boundaries of Germany</a></div>
</body>
</html>