I want to filter a OSM file by several criterias by combining several AND
and OR
operators via Layer Properties -> Source -> Query Builder. My filter looks like:
"highway" in ('secondary','tertiary','unclassified','residential','secondary_link','tertiary_link','living_street','service','services','road','rest_area','yes')
and ("waterway" IS NULL or "waterway" in ('no'))
and ("barrier" IS NULL or "barrier" in ('no'))
and ("maxspeed" IS NULL or "maxspeed" in ('5','10','15','20','25','30','35','40','45','50','55','60') or "maxspeed" <= 60)
and ("access" IS NULL or "access" in ('allowed','*','public','residential','services','unknown','yes','bus'))
and ("tunnel" IS NULL or "tunnel" in ('no'))
However, it returns all features. Maxspeed currently is a String field, but thats not always the case.
How do I set up a complex filter expression for QGIS 3 correctly, or to be more specific, how do I combine several AND
and OR
operators?
100 mph
... but usually it should be a numerical value.