Questions tagged [select]
The selection of data from a database based on some criteria.
451
questions
0
votes
1answer
29 views
Querying for all rows that have the pattern of a constant value in one field but different values in another field using ArcMap
In ArcGIS (ArcMap 10.8 or Pro 2.6) I have a table of 4000 buildings (rows). Each row/building belongs to one of fifty groups and thus has a group ID of 1-50 in the field GROUP_ID. Each row also has a ...
1
vote
2answers
92 views
Selection of names according to their termination
I would like to select cities in my attribute table according to their suffix. For example: select only cities which end with "ton". How can I do this?
8
votes
1answer
128 views
Selecting features by quartiles in QGIS
I have a polygon layer. I drew a boxplot calculated from field area in the layer.
How can I select the features whose area value is within interquartile range (25%-75%)?
1
vote
1answer
40 views
Showing only selected features of vector layer in PyQGIS [closed]
I am developing a Plugin in QGIS and I want to show only selected parts of a layer. How can I handle this with PyQGIS?
4
votes
1answer
57 views
Selecting only the first row of polygons around polygons
I am currently working on my thesis and after trying for a few days I decided to ask this questions since I guess I'm stuck. I'm working on ArcGIS PRO 2.7.0 with datasets obtained via Esri (online) ...
2
votes
0answers
38 views
Pie charts in QGIS: attributes generated with Expressions not working when using aggregate function
I have a problem to add values generated by expressions with aggregate functions to pie charts (see the screenshot below for better understanding). This question is a follow up question to this one ...
0
votes
0answers
9 views
Selecting Terrain Dataset by elevation in ArcGIS Pro
I have added the Terrain Dataset to my project in ArcGIS Pro. I would like to select the areas which have an elevation above some threshold.
Eventually, I want to use this selection as a clipping mask ...
1
vote
0answers
19 views
How to range vertex select in QGIS 3?
I am a QGIS 2 user and trying to use vertex tool in QGIS 3.
I noticed that there is a feature for QGIS3:
https://qgis.org/en/site/forusers/visualchangelog30/index.html#feature-range-vertex-selection-...
1
vote
2answers
71 views
Selecting only 10000 records from layer using PyQGIS
I would like to join attributes by location of 2 layers. My INPUT layer has 446k records and it is too many. I would like to divide my layer and select for example 10000 records.
For example in Python ...
0
votes
1answer
35 views
Increasing click selection tolerance in ArcGIS Online
Will the 2016 solution listed at Increase FeatureLayer click tolerance work in Web App Builder (ArcGIS Online) or perhaps a newer solution exists?
We have valid feedback:
I am having a little trouble ...
2
votes
1answer
45 views
Filtering out attributes fields of a vector layer using PyQGIS
I have a vector layer with 50 columns/fields. I have been trying to find a way of selecting 6 columns of particular interest (by name or index) and then creating a new layer from that selection, such ...
1
vote
1answer
46 views
Selecting more than one point using QGIS
I am trying to convert the monasteries layers from:
https://harvard-cga.maps.arcgis.com/apps/View/index.html?appid=b4dad589ee4b40e39a93bb0b026e4ee8
into a csv table. For that I am using the WMS link:
...
0
votes
1answer
32 views
Can Survey123 have a select_one create another respective select_one that repeats
Per boss's request, I need to make a survey that is broken into 3 different Test Well sections, where each Test Well has an associating list of Monitoring Wells. Basically, field tech will choose the ...
3
votes
1answer
77 views
Several QGIS layers sharing single shapefile
Is it possible for several QGIS layers to share a single attribute file, but each layer containing a different set of features from that one shapefile based on the value of an attribute?
0
votes
0answers
24 views
Selecting more than layer with polygon selection or select by location with different CRS in QGIS 2.18 [duplicate]
I want to select more than one layer in the same time, select by polygon not rectangle.
2
votes
2answers
91 views
How do I precisely select lines within a polygon in QGIS?
I want to select lines (bahnstrecken) within a polygon (bundesland). My goal is a selection shown in the following screenshot, which I did manually. Before I used two tools: I converted the polygons ...
1
vote
0answers
23 views
Speed up colouring of contour lines by creating new layer?
Related to my previous question: Colouring contour lines differently when they are inside polygons of another layer I would like to create a new layer based upon the result of the geometry generator ...
1
vote
0answers
44 views
Filter a QGIS report to get only selected features information
I have a layer with about 28000 points. What I'm trying to do is create a report showing just the information of the selected points, but looking at the report manager options I have not found an ...
2
votes
1answer
36 views
Select features that do not intersect with another polygon in QGIS
See the image below. What I want to do is select all features that do NOT intersect with the features of the selected layer. How do I go about doing this?
1
vote
2answers
44 views
Selecting the smallest number for each ID-group using ArcMap
I have attribute table with duplicate "ID" numbers, i.e. "1,1,2,2,3,3,....." and there is a unique number value in another field. I want to select the smallest number for each &...
2
votes
1answer
175 views
Selecting features by mouse click using PyQGIS
I am following a tutorial where I am trying to learn how to use PyQGIS to programmatically accept a user's feature selection from the map canvas of QGIS by mouse click. I have encountered a problem ...
2
votes
0answers
84 views
QGIS select multiple features by value
I have a polygon layer and every polygon has a unique gml_id. I want to select multiple at the same time. Normaly I use selection by expression and it works very well. I fount the tool select by value ...
1
vote
1answer
88 views
Layer selectByExpression is Not select any feature even Expression is right why?
I am trying select the features by expression if i pass query as string its working but if pass variable is not return any result why.
WORKING CODE
InputFeatureLayer.selectByExpression("\"...
1
vote
3answers
130 views
Creating definition query from selected features using ArcGIS Pro
I have a layer with 2000 or so points, and I selected 50 of them (with no attributes in common, they were randomly chosen). Now I want to make a definition query, so should I will only visualize these ...
3
votes
1answer
150 views
A column was specified that does not exist error - ArcGIS
I have some code that ran just fine on ArcMap 10.7 in May, but is now giving me an error when trying to create a new shapefile. The join that precedes the code that throws an error succeeds, and when ...
0
votes
0answers
57 views
How to get the value of specific pixels in Google Earth Engine
I want to extract the value of some pixels.
I have already select the pixels that I want to extract the value with this code:
var pixel_snowcover = glacierfilled_M1.select('albedofill1').map(...
3
votes
3answers
172 views
Duplicating layer, copies all records, NOT JUST selected records using QGIS
The requirement is to display only selected records as a New Layer pointing to same source data on disk. If I were selecting using attributes of the current layer it would be simple - I use the filter ...
0
votes
0answers
32 views
Selection of objects on different layers
How could I select two different objects from two different layers using code or in the QGIS interface itself?
An example.
I have two elements in two different layers; that green dot, and the orange ...
-1
votes
3answers
49 views
Deleting rows that have the same attribute value
I need to delete one of the two rows that have the same DestinationID and bigger value in Total_TravelTime.
0
votes
0answers
28 views
Making selection with ModelBuilder using parameter
I am using ArcMap 10.5.
I am trying to calculate the volume and area of a pit using ModelBuilder (I need a non-python solution). The pit will by preselection have the largest volume of any pits in the ...
3
votes
0answers
100 views
Selecting features by current map extent in QGIS 3
I'd like to select all features in the current map extent that also satisfy some other condition via "Select by Expression".
For instance I'd like to do something like this:
intersects($...
0
votes
0answers
17 views
Selecting attributes using ArcGIS Pro [duplicate]
Note the attributes selected.
I would like to select the attributes that cross two polygons.
Note the darker polygons represents a overlayed polygon.
I can do this manually, but is there a tool in ...
0
votes
0answers
27 views
Selecting attributes or rows of polygons that intersect two attributes of overlaying polygon using ArcGIS Pro
I would like to highlight census tracts that overlap and touch two precincts. Most tracts are contained within a precinct, but a few touch more than one. I would like to highlight these.
I am using ...
0
votes
0answers
50 views
Vector tile selection layer (canvas) drawn outside the map div. Bug?
I loaded a PBF vector tile layers into my map, and when I select a feature, OpenLayers 6.3.1 creates the selected layer canvas outside the map.
Is it a general problem, or just mine?
I don't attach ...
0
votes
1answer
36 views
Calculate field: expression is not defined [duplicate]
I'm tyring to write a script the allow me to select a layer by location, then calculate a field of the selected feature. But I'm having issue with CalculateField_management.
Here part of the script:
...
1
vote
2answers
102 views
Only show features, related to a selected feature in another layer (QGIS)
I have: ways (tracks) and points (way signs). The tracks are outgoing from the way signs.
This should be the visible result:
The ways with name 'A' are visible (coloured) because the related way ...
1
vote
1answer
35 views
Trouble with syntax of preselection in a cursor
I am trying to determine the maximum values in a column [1] in relation to a column [2]. For this purpose I have written all occurring values of column [2] in a list and now I want to make a selection ...
1
vote
0answers
25 views
Select attribute from a layer
I'm trying to show an array of selected field values in HTML in the map composer.
So far, this works but only for a specific value1 :
[% array_to_string( array( attribute(get_feature('layer', '...
0
votes
0answers
16 views
Identifying where selected features are
I am able to select the features from the attribute table but my data is so small that I am unable to identify where the selected features are. The features selected are from a raster attribute table ...
1
vote
1answer
47 views
How to add geometry to current section in arcpy?
I looping through feature class. I want select the features that are 3 meters distance but not intersected features. I know we can do by select layer by location or attribute.
with arcpy.da....
0
votes
0answers
71 views
Selection on PostGIS layers is… randomly working in QGIS
Context
Quick question...
Since the last minor update of QGIS 3, I cannot select features anymore on some (not all) PostGIS layers (see Fig.1).
Fig.1: On the left table, the selection is not ...
0
votes
1answer
22 views
Selecting polygons that meet minimum containment of certain raster cell value using ArcGIS Desktop
I have a census block shapefile with a land cover TIFF underneath it. The Raster layer has three different cell values. I am trying to select the census blocks that have a minimum of 50% of cells ...
1
vote
1answer
61 views
QGIS sum selected line lengths
I need a tool which displays the sum of selected lines as I go in QGIS. Something like the Measure line-tool. I´m new to PyQGIS. The logic seems quite simple, I just don´t know where to start. I guess ...
1
vote
1answer
105 views
Selecting multiple vertices by dragging box doesn't work
I'm doing a QGIS course at the moment using QGIS 3.10 on a Windows 10 Pro 64bit system at the moment.
Settings are default, except for the "filter invalid geometries" option is set to "ignore".
With ...
0
votes
0answers
27 views
Create a polygon from a line layer [duplicate]
I am using QGIS 2.14. I am trying to create a polygon from a line layer(roads) so that I can clip layers within that area, but my output layer will not clip any other layer only the roads it lies ...
3
votes
1answer
184 views
QGIS - make selected hidden objects visible
Selected objects in QGIS are not visible as selected (i.e. not visible with standard colour yellow) if they are covered by overlaying objects.
This is the case for objects in underlaying layers as ...
3
votes
1answer
101 views
Select by raster colour in ArcMap
Is it possible to select every pixel with a certain RGB combination in ArcMap 10.5? For example, from a .tif image I want to select and extract all the red pixels. In this case the RGB codes would be: ...
1
vote
0answers
28 views
Select attributes in a column that are similar to attributes from another column
I have two map layers. One layer contains names of roads, on which some road accident occures. Those are the roads from whole region. The road names on this layer also contains the km or the number of ...
0
votes
0answers
31 views
Automatically copy an attribute when selecting a feature
In QGIS, I need to copy one attribute of a selected feature from shapefile1 to another feature of shapefile2. Since I have to do it for a very large number of features, I use Go2NextFeatures plugin to ...
3
votes
2answers
82 views
Exporting selection to Excel file using ArcMap
I selected a list of facilities that intersect a polygon using ArcMap, and I want to export them to Excel.
Is there a way to do this without having to export the selection to a shapefile first?