Friends don't let friends parse OSM other_tags data in QGIS with regexes (like I did before figuring there has to be a better way). Use hstore_to_map for great success!

hstore_to_map("other_tags")['name:fi']

#gischat

Tip found from
gis.stackexchange.com/questions/42...

I was reminded abt the old Cipollino lewds I did ages ago so I did a couple sketches as a warmup the other day. It's really fun drawing that onion boy's slightly unsettling smile

#cipollino #nsfw_art #porn #sketch #art #other_tags

Anyone have preferred road network routing libraries? Ideally, able to take an #OpenStreetMap dataset (or a graph generated from one) and do cost-based routing based on OSM fields (HIGHWAY, OTHER_TAGS, etc) #GIS #gischat

Wonder if part of the issue is the feature class I'm using. It's an OSM export with lots of important information lumped into an `other_tags` string column. Could split those out into distinct columns for faster querying/filtering.