Skip to main content

Questions tagged [query-builder]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
70 views

Using to_dm function in model designer

When using the field calculator in an attribute table, it is easy to plug in the various fields you might need from the side bar option 'Fields and Variables'. However, in Model Designer this feature ...
Max's user avatar
  • 31
0 votes
1 answer
40 views

How to use query builder to select range of waypoints?

If I have a range of waypoints (x,y coordinates) in an attribute table, what is the best way in query builder to select a range of those points? I would also like to delete the selected points.
Max's user avatar
  • 31
3 votes
1 answer
155 views

QGIS how to use source query builder to only show the top X values of an attribute?

I have a layer containing polygons, and one of the attributes within it represents population growth. My goal is to filter the layer to display only the polygons with the highest 100 values of ...
VV_61's user avatar
  • 73
1 vote
0 answers
108 views

Filtering 'overlay_intersects' with query builder of QGIS [closed]

In order to filter a data and display only the part of the data that intersects another data, I knew the expression 'overlay_intersects' but this function does not seem to work with the query builder (...
user35117's user avatar
  • 929
4 votes
1 answer
3k views

Grouping features by attribute with sum function in QGIS

I want to consolidate my attribute table by grouping it based on several similar features. I cannot share the data due to confidentiality but it goes like this: 1000 data, grouped with same score, ...
May0123's user avatar
  • 53
0 votes
2 answers
140 views

Selecting from selected features by subquery in ArcMap Query Builder

I've set up a Model in ArcGIS ModelBuilder (ArcMap 10.6) which select some rows of table "Rivers". Then i want to select the River with the Max-Value of Field "Diff" out of the ...
GISDani's user avatar
  • 21
2 votes
3 answers
447 views

SQL expression works in DB Manager but not in Query Builder/Filter, returns "OGR[3] error 1: Undefined function" error

I have a geopackage table/layer of buildings. I need to "offset" by using ST_Translate. https://postgis.net/docs/ST_Translate.html The expression SELECT ST_Translate(geom, 1, 1, 0) FROM &...
BallpenMan's user avatar
  • 1,217