I am working with OSM data in QGIS and I often need to query items in the other tags field. When I download the data using the OSM download plugin the other tags come in one field so are not easy to use.
Currently I am looking at permissive paths etc
I can use the expression (badly written) below to pull out what I want and perform a selection but it is a headache. any better ideas? I have tried quick OSM but that doesn't seem to have access to the details in the other tags
substr( substr( "other_tags" , strpos( "other_tags",'foot"=>') ,70),10,strpos( substr( substr( "other_tags" , strpos( "other_tags",'foot"=>') ,70),10,20),'","')) = 'permissive'