New answers tagged function
6
votes
Accepted
Working with expressions inside variables in QGIS
Interesting question, as far as I know these variables can only be static string values. But you can pass these string values to eval() to evaluate as an expression.
First store your @maptype variable ...
- 10.7k
2
votes
Check if polygon falls inside other polygon with 2 layers
You can look for polygons partially contained by multiple country polygons, as in Zoltan's answer, or you can look for polygons that are fully contained by no country polygon.
SELECT *
FROM ...
- 40.7k
1
vote
Accepted
Check if polygon falls inside other polygon with 2 layers
To find polygons overlapped by more polygons from another layer you can use the following query.
SELECT a.identifier, a.name, count(*)
FROM layer_polygon a INNER JOIN layer_ countries c ON ST_Overlaps(...
- 7,227
Top 50 recent answers are included