I'm using QGIS 3.2.3. I have:
- a shapefile layer of town outlines (about 600 features)
- a spatialite layer of points (about 20000 features)
I would like to filter the points layer to show only those points that are east of a town in the shapefile layer.
I'm stymied by the lack of an obvious join condition between the two sets of data and the fact that one data source is a spatialite database and one is not.
Conceptually, I want something like:
select * from pointtable join polytable on (???) where polytable.town = 'SomeTown' and st_x(polytable.geom) > st_x(pointtable.geom)
...but I'm not sure how to get there.