Searching within a string

المشرف العام

Administrator
طاقم الإدارة
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

"foot"=>"permissive","horse"=>"permissive","tracktype"=>"grade2"

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'



أكثر...
 
أعلى