Questions tagged [select-by-attribute]

To select data records according to logical criteria applied to their field values ("attributes")

Filter by
Sorted by
Tagged with
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 (...
YP Environmental Research's user avatar
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 ...
Paris's user avatar
  • 591
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 ...
John's user avatar
  • 21
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 = ...
user206005's user avatar
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 ...
Nepomuk's user avatar
  • 13
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 ...
John D's user avatar
  • 53
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....
grahamsy2k's user avatar
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 ...
user228948's user avatar
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?
raytron333's user avatar
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 ...
Marin Marian's user avatar
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 ...
kgb61393's user avatar
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 ...
user avatar
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 ...
Batco's user avatar
  • 11
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 "...
Matt's user avatar
  • 93
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 ...
Rachel's user avatar
  • 11
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 ...
socrutes's user avatar
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 ...
Steve Bennett's user avatar
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 ...
Norman's user avatar
  • 51
-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, ...
Nanad's user avatar
  • 1
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 ...
Nick Primmer's user avatar
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 ...
redleg_64's user avatar
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' ...
Nicholas Kunkel's user avatar
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 ...
Lau's user avatar
  • 11
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 ...
Irfan Zahid's user avatar
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.
Barrylim_work's user avatar
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 ...
greyhug's user avatar
  • 67
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....
GreggUnited's user avatar
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 ...
DanaAllen's user avatar
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 ...
Srikanth Talla's user avatar
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)...
Cass_789's user avatar
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 ...
Martin's user avatar
  • 13
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 ...
Madsp's user avatar
  • 11
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 ...
Fuscus's user avatar
  • 9
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 ...
Juliette Lapeyre's user avatar
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 ...
Elmojo's user avatar
  • 1
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 ...
Sander Van Beuningen's user avatar
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 ...
barney stinson 2's user avatar
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 ...
Josh's user avatar
  • 1
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 ...
matthiastrek's user avatar
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 ...
Katie Walker's user avatar
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:
Damar Panoto's user avatar
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 ...
GeoJoe's user avatar
  • 1
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'
rheesuspieces 's user avatar
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 ...
Mike Adam's user avatar
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 ...
Geographos's user avatar
  • 4,005
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 ...
OgeiD's user avatar
  • 522
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, ...
cartocraftsman's user avatar
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", "...
Vincent Maresca's user avatar
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 ...
Salevieno's user avatar
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 ...
User1974's user avatar
  • 1,114

1
2 3 4 5
13