<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>sql: <br>
</p>
<p>select osm_id,tags->'entrance' "tags->'entrance'"<br>
from planet_osm_point<br>
where tags ? 'entrance'<br>
limit 10;<br>
osm_id | tags->'entrance' <br>
------------+------------------<br>
3812284860 | main<br>
2312180146 | yes<br>
2773679231 | yes<br>
339015388 | main<br>
561073309 | service<br>
367081276 | main<br>
339015386 | yes<br>
1783531793 | main<br>
1783531816 | main<br>
367081281 | main<br>
(10 Zeilen)<br>
<br>
Zeit: 3,194 ms<br>
</p>
<p>any idea whats 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><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>