Questions tagged [select-by-attribute]
To select data records according to logical criteria applied to their field values ("attributes")
634
questions
0
votes
0
answers
17
views
Randomly creating areas within one country focusing on built-up area using ArcGIS Pro
I need to Randomly select 60 areas(square 2*2=4km2) within one country and it should take into account all six landscape types.
I need it to compare the build-up area changes during a few decades (...
1
vote
2
answers
72
views
Selecting multiple points from an attribute table in QGIS, based on uncategorized field value
I have a point shapefile in QGIS (3.30.2) containing more than 2000 points. I selected about 150 of these points based on a special criteria.
I need to create a separate shapefile with only these 200 ...
2
votes
1
answer
67
views
Extracting or selecting only 4 digit numbers from attribute field
I have a field, this field has integer numbers, what I need is to find only the 4 digit numbers and select/extract them. I do know a few solutions but they didn’t work out. What exactly I want to do ...
0
votes
2
answers
47
views
Selecting records after using insert cursor
Using ArcPy and on the same script, I would like to perform a SelectLayerByAttribute tool to select the features created with the InsertCursor tool.
coords = [1, 2, 3, 4]
pointlyr = 'point'
Sr = ...
1
vote
1
answer
19
views
ArcGIS Pro: Area of certain land cover types for each main type (simplifiable?)
I have multiple areas with a unique ID (wetland sites) and now want to calculate the area of certain land cover types (grassland, woodland etc.) for each wetland site. I found a solution but am ...
0
votes
1
answer
74
views
Pass a variable to a SQL Expression for a Select by Attribute in ModelBuilder
Working to create a script which iterates over a set of CSV files and then joins to a ZIP file. Once that is completed, it goes through to Select by Attribute to ensure we are looking only at true ...
0
votes
1
answer
40
views
Select Layer by Attribute not working with variable, but doesn't give errors using ArcPy
I'm trying to make a simple script tool that allows the user to search a for a specific polygon in a feature class using a unique number.
Using the python window in ArcGisPro I run arcpy.management....
1
vote
1
answer
35
views
Select points by polygon and update attribute field
For each record in the pointLayer, I'm trying to see where they are located using the polygonLayer. Then, update this location information to the "SWPsubwatersheds" field from the pointLayer ...
0
votes
1
answer
70
views
Selecting all multipart features in feature class using ArcGIS Pro [closed]
How do I select and visualize all multipart features in a feature class using ArcGIS Pro?
1
vote
1
answer
47
views
PyQGIS zoomscale freezes map canvas
I have a PyQGIS code made partially with graphical modeler and some personal completion.
Basically, based on this code I want:
Type any city from my point shapefile, select it by attribute.
Zoom to ...
0
votes
0
answers
103
views
QGIS - attribute(@atlas_feature) function in overlay filter
I am actually trying to make a QGIS style that match my current entity in the atlas. For this, I need to use :
the functions overlay_intersects with one of my layer with filter the attribute value of ...
0
votes
0
answers
77
views
Choosing parcels listed from Excel sheet in QGIS
I was sent an Excel sheet by a different department with all the parcel numbers they want to be mapped. They are all over the county.
What is the best way to select the parcels that were given to me ...
1
vote
0
answers
39
views
QGIS3 weed tracking via polygon attributes
I have been requested to provide some information about weed distribution on a site in the form of polygons that describe land forms. I am using QGIS3 and slowly getting the hang of it, might be too ...
6
votes
1
answer
130
views
Limiting administrative shapefile to less granular level using ArcGIS Pro
I am using an administrative shapefile of Jamaica in ArcGIS Pro. I have a number of attributes at varying levels of granularity. There are 14 Parishes, 65 "Constituencies", roughly 650 "...
1
vote
0
answers
34
views
Locating a specific field in an attribute table using SQL with ArcGIS
I am a beginner at GIS/ArcGIS and have a quick question about locating a field in an attribute table of a feature using SQL. Attached is an image of a (crude) example of the kind of attribute table I ...
0
votes
0
answers
15
views
Splitting data column into multiple columns
I have a table of tsunami data that I imported from NOAA, but the problem is that they are not sorted by severity at all--there is instead a catch-all "description" box that has everything ...
1
vote
1
answer
242
views
Explode a layer into multiple layers based on an attribute field, using QGIS [duplicate]
I have a layer where every feature contains a type attribute with a value from a restricted set. Is there a way in QGIS to explode the layer into multiple layers, one for each value for the type ...
0
votes
1
answer
102
views
Select Features by polygon colour
I am using QGIS V3.22.6.
I have imported a set of polygons digitised in Google Earth. They all have the same name but have different polygon colours.
I would like to rename these according to their ...
-2
votes
1
answer
60
views
ArcGIS SelectLayerByAttribute is not working
I have the following script:
Area_f = input_folder + "\\Area_f.shp"
Area_f_layer = "Area_f_layer"
fld_objekt_nr = "OBJEKT_NR"
arcpy.AddField_management(Area_f_layer, ...
0
votes
1
answer
152
views
Select multiple features from multiple layers in QGIS
I am analysing land use across multiple region.
Each region has its own vector dataset. Each dataset contains the same columns and land use classifications (e.g. 'AC66' or 'TC01'), describing units of ...
0
votes
1
answer
84
views
Select by attribute and location within a for loop? [closed]
I have dozens of feature classes in a project geodatabase. I have the code that will identify all the misplaced wells in each dataset, but for the life of me I can't figure out how to get the lines of ...
0
votes
1
answer
46
views
Python Script - SelectLayerByAttribute 'Invalid Expression' Error Message
I am fine tuning a 'snap by attribute' python script. It takes points in one layer and snaps them to points in another layer based on unique attribute. I keep running into an 'invalid expression' ...
1
vote
0
answers
253
views
Using select by attributes in ArcGIS Pro ModelBuilder
Summary of my problem:
When I use the select by attributes option directly from the attribute table, my query works perfectly, however, if I run the exact same query from the ModelBuilder. It doesn't ...
3
votes
2
answers
264
views
Selecting features and create new field with QGIS Field Calculator
For example, Column A (1, Michigan Street, Michigan), Column B (Michigan Street) and Column C (Yes, No).
I want to use Field Calculator to update Column C in a way that it return NO if Column A ...
3
votes
1
answer
308
views
Selecting features with values whose difference is greater than 20 in QGIS
I have a LineString layer and it's attribute table has two different fields. I want to select all features with a difference of more than 20 between both fields.
1
vote
1
answer
212
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 ...
0
votes
1
answer
159
views
Arcpy.CopyFeatures_management creates empty feature class
I am trying to iteratively copy selection layers to new feature classes. My script successfully creates the new feature classes, but they are empty. Can anyone point out what I'm doing wrong?
arcpy....
0
votes
1
answer
105
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 ...
1
vote
1
answer
150
views
Changing attribute values of selected features using PyQGIS
I am selecting the features by "Property_T" and its attribute is 'Open Land' and I want to add some attribute to "SS" field for same record. What is wrong?
from PyQt5.QtCore import ...
0
votes
1
answer
201
views
Expected field not found using SearchCursor and SelectLayerByAttribute tools in ArcPy ArcGIS Pro 3.0.0
ArcGIS Pro 3.0.0 - using ArcPy
First, I'm very new to coding with Python, so there may be a few mistakes in my code that I am not catching. I'm trying to select each row in a table (line feature class)...
1
vote
2
answers
508
views
Selecting points based on mutual distance and same attribute value using ArcGIS Pro
I have a layer of many points. From those, I need to select only those, that meet condition of having atleast two other points, in specified distance (lets say for example 100 meters) but where these ...
1
vote
0
answers
85
views
How to select distinct points in an attribute table with multiple duplicates in arcgis pro?
I have an attribute table with 400+ values of chemical sampling results associated with ~100 different testing sites. Each sampling site has 2-10 result values associated with it. The points are ...
0
votes
1
answer
136
views
Select Layer By Attribute_management not taking variable
I am trying to make SelectLayerByAttribute_management to take a string (that is an input variable) as the "where_clause". The string would be inputted by the user. If I just put the text I ...
0
votes
1
answer
143
views
Where-clause based on attribute value in ArcPy
I am trying to create a Python toolbox which will iterate through selected features and create a statistics table for each selected feature.
It works as follow:
Define parameters, including the input ...
0
votes
1
answer
20
views
Using select by attributes across mutliple layers in ArcMap
I am using ArcMap 10.8.2.
I'm working on a GIS update for a local municipality. They've asked that I only send them back data that I've added or changed.
It seems the easiest way for me to do this ...
2
votes
1
answer
364
views
AttributeError: 'NoneType' object has no attribute 'selectByExpression'
I get the error: AttributeError: 'NoneType' object has no attribute 'selectByExpression'
The first run through the loop is fine but at the second run the error occurs.
How do I fix this?
import ...
1
vote
2
answers
69
views
Keep only one nearest OD link (QNEAT)
I've made a distance matrix from one point layer (layer A) to another (layer B) using QNEAT plugin (QGIS Network Analysis Toolbox 3).
I got a web with links from every point from A to every point from ...
0
votes
1
answer
165
views
Select polygons that contain attribute listed in a separate table
I am using ArcGIS Pro and am trying to select a number of polygons based on a list of postcodes from a standalone table.
I am using the Code-Point Polygon Dataset for the entirety of England, and I am ...
0
votes
2
answers
180
views
How to create custom tool via Python that selects by attribute, then outputs new feature classes
I am trying to create a custom tool via python script that selects features in multiple fc's within a feature dataset that are missing values, then from the selected features, creates two outputs: one ...
0
votes
1
answer
209
views
Select points by number of unique values by group - ArcGIS Pro
Similar to this question,
I have two datasets that consist of points and polygons, where all the points are inside the polygons. The polygon IDs (called cluster IDs) were previously joined with the ...
0
votes
1
answer
954
views
Select and save as shapefile feature in R using sf
How can I select the shapefile feature there is, "D3" in "New.Code" columns using sf packages in R
Here is the attribute table of my shapefile:
0
votes
0
answers
320
views
Create a new feature layer from an existing feature class selection with python/arcpy
I am attempting to create a new layer from the selection of streams and rivers in an NHD feature class. I have tried every iteration that I can think of without success. I am very new to Python, so ...
3
votes
1
answer
263
views
Select NULL values by attribute statement
Having some difficulty figuring out "and" statements as i am quite new to GIS. What errors am I making in this statement here?
STATUS = 'QC Required' and WORKFROMHOMEEMPLOYEES = 'NULL'
0
votes
3
answers
97
views
Deleting feature from Costa Rica shapefile using ArcMap
I would like to remove an island from the Costa Rica shapefile. This island is highlighted in the attached picture. There is not enough information in the attribute table for this island and that part ...
9
votes
2
answers
1k
views
Selecting items in the attribute column based on items of another layer in QGIS
I have the items in my data attribute table, which were selected. I want to make the object with the same value be selected in the attribute table, which belongs to another layer. In both cases, the ...
4
votes
2
answers
581
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 ...
4
votes
3
answers
603
views
Selecting certain text from attribute values in QGIS using field calculator
I am using QGIS 3.16 (Field Calculator). I have a number of values in the attributes of my GML file that read:
'Nonconiferous Trees' or
'Nonconiferous Trees (Scattered)' or
'Nonconiferous Trees, ...
0
votes
1
answer
216
views
Square brackets are causing SQL syntax error for ArcPy SelectLayerByAttribute [closed]
I have been trying to use ArcPy’s SelectLayerByAttribute funciton and I can get it to work with this code:
arcpy.SelectLayerByAttribute_management("LAYER", "NEW_SELECTION", "...
6
votes
3
answers
1k
views
Selecting features in one layer based on mutual field with another layer in QGIS
I have two layers in QGIS, each one with a field called "Name". I need to select the features in 'layer2' whose name exists in 'layer1' (totally or partially).
For example, in the images ...
1
vote
1
answer
570
views
Select rows using Python? (without creating a new field or table)
ArcMap 10.7.1 — Oracle 18c SDE.ST_GEOMETRY — Polyline FC
Occasionally, we come across scenarios where we want to select rows in a FC in the attribute table, but there isn't a way to run the query ...