Search Results

There is also a bit lame but working approach using the following expression: array_contains(array_insert(generate_series(10, 100, 10), 0, 1), "id") It includes the following functions: generate_series …

Therefore, like in this thread Drawing 10 nearest lines from each point connecting to the centroid of the 5 points nearest to each point with QGIS expression, I am simply suggesting to delete it by its … However, in such a case, the number in limit should be incremented in one more feature. array_remove_at( overlay_nearest( layer:=@layer, expression:=fid, filter:=letter='A' …

For instance, if I type something in the Expression dialogue I will have a different output. "something", it is written as The Output is NULL. …

You can achieve the result that you are striving for with GRASS toolset v.clean for cleaning topology of a vector element. Probably, you will need to deploy rmdangle option. rmdangle: remove dangl …

Tested on QGIS 2.18 and QGIS 3.4 Additionally, I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer.... Let's assume we have the following layer "line" with i …

So, the main idea is to select the latest date by expression. It could be feasible by means of the expression that must be pasted in 'Select feature using an expression'. And then press Select. … For selecting the oldest date use this expression concat(right("Date",4),'-', regexp_replace(regexp_replace("Date", concat(regexp_substr(regexp_replace("Date", right("Date",5),''),'(\\d …

In QGIS I can suggest using a "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer... Let's assume there is a point layer with it's corresponding attribute table, see image below. With …

If the string should contain lowercase, use this expression in 'Expression Dialog' if(regexp_match("test",'([a-zäöüß]+)'),1,0) for uppercase change '([a-zäöüß]+)' into '([A-ZÄÖÜ]+)'. …

Additionally to the @J. Monticolo's answer, you may try using if-statement if("Surface" >= 30000, 4, if("Surface" >= 10000 and "Surface" < 30000, 3, if("Surface" >= 5000 and "Surface" < 10000, 1, 0))) …

Perhaps, you will find this expression suitable for you: geometry_n( collect( expression:=$geometry, group_by:=substr("NumeroNom", 0, 5), filter:="AmslFt"=maximum("AmslFt", …

Try using the following expression attribute($currentfeature, 'field_name') in the "Expression Dialog", see image below In Record and Attributes Function attribute Returns the value of a specified attribute …

For the example of the question, a working expression could be: map_get(attributes(get_feature_by_id(@layer, maximum("fid", group_by:="fk_id"))), 'comment') References: How to set a default value for …

So, you can try either this: aggregate( layer:='polygon layer's name', aggregate:='max', expression:="polygon layer's field name", filter:=contains($geometry, geometry(@parent)) ) … or this: aggregate( layer:='polygon layer's name', aggregate:='max', expression:="polygon layer's field name", filter:=within(geometry(@parent), $geometry) ) Alternatively you can …

Here is another IMHO a bit sophisticated approach: if("CORINE" IS NULL, 0, map_get( map('AG',1,'BG',2,'LW',3,'NW',4,'MW',5,'WW',6,'WA',7,'DK',8,'LN',9,'NV',11,'SU',12,'SV',13,'TM',14), …

Use the "Geometry by expression" geoalgorithm, where the result of Step 1 crosses features from the layer 'Line 2'. Also you may use a basic "Intersection". …