Questions tagged [select-by-expression]
The select-by-expression tag has no usage guidance.
48
questions
1
vote
1
answer
55
views
How to select multiple values (features) in separate columns (QGIS) [closed]
Two parts to this question.
Part 1
I'm trying to select by expression all rows (features) that have a particular value across multiple columns. So, for example, I want to select all features that have ...
- 67
0
votes
1
answer
27
views
Select points within a polygon based on attribute value within polygon and point attribute values
I have a two datasets - a polygon dataset of buffers around a point and a point dataset. The polygon dataset has an elevation value (assigned from the point on which the buffer was created) and each ...
2
votes
1
answer
93
views
Selecting layer by expression with two variables using PyQGIS
I would like to filter a column coming from a layer with the command layer.selectByExpression().
I would like to leave the name of the column as a variable (not fixed). I made a conditions inside the ...
0
votes
1
answer
43
views
QGIS: select multiples attributes which contains different words using select by expression
I would like to select multiple attributes which contains some specific text ("Bus", "Car", and "Motorbike") from the same field ("commodity") using Select by ...
- 538
3
votes
2
answers
101
views
QGIS: Select feature using SQL with highest value for attribute, grouped by another attribute
I have a relatively small attribute table that includes a column where data (parameter 1) is identical across several rows. I would like to select only the row with the highest parameter 2 based on ...
- 39
1
vote
1
answer
163
views
How do I select features with the same values but different IDs from a layer's attribute table in QGIS?
I have a multipolygon layer with several regions (green circles) that are identified through numerical fids. Within each region are multiple points (orange dots) with individual pointIDs. See example ...
- 51
3
votes
1
answer
177
views
Delete any polygon that overlaps polygons on another layer in QGIS
I'm new to GIS software and I couldn't find an answer here for QGIS specifically.
I have layer A with a few thousand polygons that have the attribute "Field". I have layer B which is a ...
1
vote
1
answer
88
views
QGIS Print Layout expression for selected features in project
I have a selected feature in the project that is symbolised differently. I can see it in the print layout, but the is_selected expression returns a false. I need to label only this feature in a text ...
2
votes
1
answer
266
views
QGIS Expression with multiple IS NOT filters
I would like to select features using an expression. I have one field with +-100 different values. I would like to select all values except for two. Something like this:
"FIELD" is NOT ( '...
- 55
4
votes
2
answers
279
views
Selecting values of variable in attribute table which contains specific character in QGIS
I have a shapefile of a grid cell. I would like to select all the observations (cells) whose values in column "mean" is not an entire number. I was thinking to do it selecting all the ...
- 538
5
votes
2
answers
344
views
Displaying only visible in canvas features in attribute table using PyQGIS
As explained by @xunilk in Getting attribute values from vector features visible in QGIS canvas using PyQGIS we can easily access to the attribute values of the features visible in the QGIS canvas (...
- 1,796
3
votes
1
answer
156
views
Selecting first row for group using select by expression
How would/could I use the select by expression tool to select only the first row for each origin_id group? The rows with a yellow border are the ones I want selected.
- 277
5
votes
3
answers
1k
views
QGIS Select points within ONE polygon in a different layer
I have a set of points, which are located in the same area where the other, polygon layer is located.
I would like to have all the points selected, but ONLY within the one polygon belonging to the ...
- 3,533
4
votes
2
answers
441
views
Selecting features containing specific text string using an expression in PyQGIS
I'm trying to select features with a specific text that I have in an attribute. I used the expressions from the PyQGIS Cookbook but I'm having trouble with the selection because the functions I'm ...
- 43
6
votes
1
answer
334
views
Selecting features that do not touch other features in same layer in QGIS
In QGIS I have a polygon layer where there are some isolated objects which do not touch other objects in the same layer. They are isolated and therefore I do not need them.
How can I select these ones?...
- 153
2
votes
2
answers
215
views
QGIS select by expression based on different elements concatenated inside a string
Using the field filter or advanced filter expression in the attribute table of QGIS, I want to select features that have values in the first three levels and exclude features that values other than ...
- 345
2
votes
1
answer
300
views
Using "Select by expression" in processing script context with PyQGIS
Is there a way to select features and use them in subsequent algorithms within a processing script context?
I am looking to iteratively selectbyexpression a subset of line features in a layer based on ...
- 23
3
votes
1
answer
585
views
QGIS: Select polygons that are touching another polygon on all it's sides (not contain but engulfed?)
Given this polygon:
I'm trying to select the inner one, but can't find a simple way using either selection by location or selection by expression
Any idea?
- 205
5
votes
2
answers
298
views
Selecting only polygons that contain another polygon with Select by Location in QGIS
In QGIS 3.16.11 on Windows 10 I have a layer with single polygons.
Given this polygon layer with, I'm trying to select only the polygons that that contain at least one other polygon (A & B)
My ...
- 205
7
votes
1
answer
551
views
Selecting features visible in map extent using QGIS
In QGIS, I'm trying to select all the features that are visible in my map extent but I can't find a solution with "select by expression" or something else.
I will use your tips inside ...
- 1,229
6
votes
1
answer
160
views
QGIS expression not working as expected: selecting nearest neighboring points of a selected point
The problem
In QGIS 3.20.0 (Win 10), I have an expression that does not work as expected and I don't understand why. On a point layer, one point is selected. When using Select by expression, the ...
- 52.8k
7
votes
3
answers
1k
views
Selecting multiple features by ID-attribute from list using PyQGIS
With PyQGIS I would like to use several "ID"s (in a list) to select certain objects in order to make them available later in a temporary layer. I know how to select one or a few more objects,...
- 341
0
votes
1
answer
32
views
Selecting records having special char record
I am trying to select all records which have special char (I'm not mention any specific special char)
Like below:
ADDRESS_N LIKE '%Ö%' or
ADDRESS_N LIKE '%Ü%' or
ADDRESS_N LIKE '%ß%' or
ADDRESS_N ...
0
votes
0
answers
40
views
Iterate a feature by expression with unique values in PyQGIS [duplicate]
Im trying to automate the process of select by expression and afterwards export it to a new layer in Qgis using Python. The Layer I'm using is called "Brutvoegel" and my goal is to get all ...
- 1
2
votes
0
answers
110
views
Iterate through list with numbers (as text)
I want to iterate through a list of coordinates and see it the last coordinate matches the first coordinate. The coordinates are stored in have a GeoJSON string:
'''{"type":"...
- 97
10
votes
1
answer
174
views
Selecting NULL or date values by Expression in QGIS
How can I select by expression from a date field in a shapefile, dates that are NULL or >= 2020-01-01?
This doesn't work, it only selects those with dates >= 2020-01-01, not the NULLs
"...
- 58.6k
1
vote
1
answer
146
views
Deleting lines crossing particular features from another layer using QGIS
I have two QGIS layers. Layer 1 has a floor plan with an attribute field holding feature types, e.g., wall, corridor etc. Layer 2 consists only the lines drawn between door centroids. I want to query ...
- 53
4
votes
1
answer
85
views
Automate the selection of duplicate geometries with QGIS3
I have a layer of buffers calculated from watercourses. Each watercourse/buffer has a Strahler Order (0 to 7).
I need to delete overlaps between buffers order 0 and buffers order 1 to start, but ...
- 683
0
votes
0
answers
62
views
How to performing selection by expression using QGIS
I am using QGIS 3.8.
I have a grid (hexagon) and a set of points.
I am trying to select the hexagons containing at least 1 point. So far nothing complicated. Except that sometimes my points overlap 2 ...
- 11
0
votes
1
answer
199
views
Select and list all the adjacent features of a feature in ArcGIS
I have a shapefile of the Zips of California like the attached image. What I want is to select the adjacent/neighboring polygons (those touch the boundary) of each polygon in ArcMap and want to create ...
- 69
4
votes
1
answer
85
views
Selecting by attributes on features sharing common value
I have a point vector with features sharing non-unique "ID"s. Each feature also has a "distance" field. I want to select among each set of features sharing the same "ID" ...
- 41
3
votes
1
answer
353
views
Select features from the attributes table without opening it in QGIS
I have an attribute table with a vast amount of data in QGIS. I need to export only some of the features. Is there any way to select features without opening the attributes table?
- 419
-1
votes
1
answer
249
views
Selecting a specific number of features in QGIS [duplicate]
I have a layer with several fields on its table and one of these fields is "population". Is there a way to select only the top 3 features with the highest population?
I imagine I need to ...
- 107
1
vote
1
answer
200
views
Is there a way to sort the QGIS attribute table by date modified?
I was wondering if there was a way to sort the attribute table in QGIS Pi by date modified. I have been digitizing a large area and I need to delete the last 50-100 features that were digitized. My ...
- 11
2
votes
1
answer
78
views
Problem selecting features with % operator
I am having problem to select contours with the following expression:
"ELEV" % 0.05=0
As I understand this should select any contour that the remainder of the division by .05 is 0.
For ...
- 2,952
3
votes
1
answer
444
views
Selecting multiple rows in feature based on contents of list using PyQGIS
I am trying to select rows in a feature layer in QGIS based on the values in a list. I am using PyQGIS in the python console
If I just specify one item to find in a column called "gps_code", ...
- 581
2
votes
1
answer
180
views
Python script to set another layer inactive & select point by outside of boundary line?
I have two layers, "IDN_ALL" as Polygon and "Point_Link" as point.
"Point_Link" is the active layer. I want to select point data outside polygon data.
Code:
Layer1 = ...
- 23
4
votes
2
answers
144
views
Selecting features whose text is equal to the text after certain word in QGIS
I have origin-destination lines and I'm looking for intra-city lines or lines whose origin and destination are in the same city.
A sample intra-city feature would be "Quezon_City to Quezon_City&...
- 1,189
0
votes
0
answers
174
views
Make Feature Layer / Select / Select Layer By Attribute "Get Unique Values" grayed out in ArcMap ModelBuilder [10.8.1]
I'm trying to extract road segments from a feature class through ModelBuilder in ArcMap 10.8.1 based on attribute queries, but the "Get Unique Values" button does not pull up a list of ...
- 115
2
votes
1
answer
144
views
Select by expression based on common ID
Background
I need to select features (parcels) from an official source based on a list with no geometries provided by a client. Both data sets have a common, unique ID (parcel number). There are about ...
- 14.2k
2
votes
2
answers
508
views
QGIS expression to check if a an attribute value of a feature exist in another attribute column
I have a shapefile with two fields 'Name' and 'CountyFacilityID'. I would like to create an expression to select all features where Name exists in the CountyFacilityID column for any of the features.
...
- 1,597
1
vote
1
answer
285
views
Create new shapefile for each unique attribute using for-loop with PyQGIS?
I have a roads shapefile. In its name field, I'll create a new shapefile per attribute. I already got each unique attribute under name. The for-loop that iterates over the unique attributes and ...
- 1,189
7
votes
2
answers
168
views
Analysing point attributes within polygons
I'm using QGIS 3.4.4.
I have a polygon layer and a points layer. The points have the attributes district and streetname.
How can a check if all the points within a polygon have the same district and ...
- 305
3
votes
2
answers
2k
views
Selecting more features with "ILIKE" and "IN" operators using QGIS
I would like to select more features with expression in a specific field, which contains the name of the attribute (IN operator is useful). Moreover, the name could not be exact, so the ILIKE operator ...
- 799
3
votes
1
answer
108
views
QGIS increase number of recent selections
is there any possibilty to increase the number of recent selections in the menu select by expression?
I can´t store more than 20 selections. If I create a new selection, the oldest selection is ...
- 401
3
votes
1
answer
663
views
Showing string that contains specific number in QGIS
How to show all the strings that contain '841' on this layer?
I tried to use "NAME" LIKE '841' but somehow it did not just show "841_1Q" and "841_1", instead it still ...
- 51
2
votes
0
answers
1k
views
Select by expression only for selected features using PyQGIS [duplicate]
I'm facing a nested problem using PyQGIS (for QGIS master, but it can be replicated in any version of QGIS 2).
I have a vector layer with some selected features and with a QgsFeatureRequest I can ...
- 3,009
4
votes
2
answers
2k
views
Selecting from selection with PyQGIS
The expression box has a handy "select from selection" button. Is there a way to emulate this with Python? I have the basic expressions down, but can't find a way to do this.
- 965