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
2
votes
1answer
34 views

Using ArcGIS Pro to select all data collected “Yesterday” regardless of the time of day

I am using ArcGIS Pro 2.4.3. I can upgrade if needed. I am reading a hosted feature layer from my Organisation's AGOL site in ArcGIS Pro. This is using the standard Esri Data Store. This dataset ...
2
votes
1answer
36 views

Differences in the Select by expression between QGIS 2.18 and 3.4

I want to select in a population table the growth rate between two years greather than 1.5. In QGIS 2.18 the following expression works fine "POP_P2014" / "POP_P2000" > 1.5 With the same data ...
0
votes
1answer
25 views

Using Select Layer By Attribute in Python Script Tool

I just want to try to use a Python script to select specific roads in my Layer called "Route_01_Shatin" and so I coded as below: arcpy.management.SelectLayerByAttribute('Route_01_Shatin', '...
0
votes
1answer
69 views

Using input parameters to select layer by attribute

I am trying to create a Python-Toolbox with following Tool: inputFeature: A User has to load a Feature inputField: Then he has to to select a field from the Input Feature inputValue: At the end ...
3
votes
1answer
293 views

Show string that contains specific number?

For example, 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 showed every point on ...
0
votes
1answer
29 views

ERROR 000732: Layer Name or Table View: Dataset targetAreas does not exist or is not supported Failed to execute (SelectLayerByAttribute)

My goal with this script is to create 9 PDFs and 9 sheets within an Excel workbook. The script utilizes select by location, attributes, and searchcursors to read data to Excel and iterate through user ...
0
votes
1answer
53 views

How to Select Attributes from a Selection of Attributes

I have a land-cover map for an area in which I want to identify certain attributes that fall within a category. I want to select the shapes that represent wetlands that are in a grassland area. To do ...
35
votes
12answers
63k views

Exporting feature class into multiple feature classes based on field values using ArcGIS Desktop?

I have a feature class with over 2,000 features, and I need to make them all individual feature classes based on a field. Is there a way to do this?
1
vote
2answers
54 views

Difficulty with select by attributes using list fields in for loop

I am trying to add fields to a table and then populate the fields with text values (Yes/No). The text values are based on whether or not a species was found in a specific block. If the species was ...
0
votes
1answer
78 views

For loop with SearchCursor stops after first iteration

I'm trying to iteratively select and export a layer using da.SearchCursor, but the loop stops after the first iteration. Here is the code: arcpy.env.workspace = ScratchGDB # infc= "PA" field = '...
0
votes
1answer
28 views

select which is having specific double value

Title: Trying to Select which is having double space I have data like below: field name - Address: Winding Springs Dr Winding Hollow Dr Windsong Ln in above data i have to select double space ...
0
votes
0answers
29 views

Using ModelBuilder to Select by Attributes and Calculate Field in ArcGIS Pro

I have a layer that has two column attributes which have information in numerical order, that is one is 1,2,3,4 and the other is 1,2,3. I have created a 3rd column that I want to be able to "select by ...
1
vote
1answer
30 views

Output of an algorithm in QGIS Graphic Modeler

I use two Processing tools in a graphic Model in QGIS: 1-Select by Location 2-Select by Attribute The problem is that I can't get the output of the selection by location so that I can't use it as ...
0
votes
0answers
47 views

Using ArcPy to select joined field

I have written a script which takes two inputs, intersects them, creates a new field in the output feature class and joins it back to one of the input feature classes. I would then like to select the ...
0
votes
1answer
37 views

Select evenly distirbuted points of unevenly distributed set

I have a task which looks pretty nontrivial yet pretty standard. Let's say, I have a set of points, unevenly distributed on the map (i.e. in some regions there are a lot of points, while in the ...
1
vote
2answers
2k views

Selecting Layer by Attribute using SQL and variable in ArcPy

I've had a good look around the site and haven't been able able to find any 'select by attribute' questions regarding string variables and how to integrate them into an SQL statement. In my particular ...
1
vote
1answer
27 views

No output is being generated by ArcPy's MakeFeatureLayer method

I have a feature class that I would like to filter by an attribute and write the result to a new feature layer. I can achieve this with a simple one-liner in the R programming language, but I need to ...
1
vote
3answers
1k views

Select Layer By Attribute Python Script Tool?

I'm trying to script another Select by Attributes tool. I want to be able to find a specific building using a field and zoom in to the location. However, my tool needs to allow a user to input any ...
3
votes
0answers
75 views

Select by attributes returning wrong records [closed]

I'm trying to select by attributes on a parcel shapefile with 555k+ records using the apn field and the statement is returning records that have completely different values. My initial statement was "...
4
votes
2answers
6k views

Select features using an expression, QGIS

I've a problem when using Select features using an expression. I've an attribute table with many features: It's a shapefile from a previous CSV table. The data are localities for water analysis, where ...
1
vote
1answer
61 views

Using SelectByAttribute_management after making XY Event layer in ArcPy

I imported a CSV file using the MakeXYEventLayer_management and trying to use the SelectlayerByAttribute_management function, but I am getting error message saying on "Object ID(OID)" is present.. Is ...
0
votes
1answer
48 views

SQL wildcard for Field Name?

I'm wondering if there's anyway to use a wildcard character in a field name. Like using ["Species_%" = 'Hemlock'] instead of ["Species_1" = 'Hemlock' OR "Species_2" = 'Hemlock' ...]. I tried the way ...
0
votes
2answers
67 views

Automate saving features by results of join attributes by location

In QGIS v3.8.3 I have one shapefile of all US Census Tracts and another of ~1,000 US Counties. There are multiple tracts in a county. So I did a many-to-one join in Join attributes by location to add ...
8
votes
4answers
40k views

Using String Functions (LEFT, RIGHT, MID) in Select By Attributes against a File Geodatabase using ArcMap 10

I finally (albeit reluctantly) made the switch from a personal geodatabase (pGDB) to a file geodatabse (fGDB) not too long ago. The main reason it took so long to switch has to do with how Select by ...
1
vote
1answer
27 views

Select ArcMap attributes that are in CSV

Is there an ArcMap 10.1 method for selecting only attribute rows that have an identifier in common with those in a CSV sheet? I exported an attribute table (5000 rows) and eliminated all but the ...
1
vote
2answers
61 views

ArcPy Select Layer by Attribute for Date and Time

I have a list of trips with a field, "Trip Start Timestamp" thats type is date where it appears on the attribute table as M/D/YYYY HH:MM:SS AM/PM I need group all trips with the same trip start ...
0
votes
0answers
23 views

Selecting lowest values in from attribute table in ModelBuilder? [duplicate]

I am trying to select the lowest value from an attribute table within model builder. I have used the Sort tool to sort the values in ascending order but when I add the Select tool and go to enter an ...
3
votes
3answers
4k views

Runtime error : ERROR 000358: Invalid expression using SelectLayerByAttribute in ArcPy?

I cannot for the life of me persuade SelectLayerByAttribute to work (I need to automate this for a complex script). Working in ArcMap's python console on already loaded shapefile, the format below: ...
3
votes
1answer
191 views

Selecting features using attributes of another file in QGIS

I have a table of attributes in which a field contains combinations of IDs from another shapefile (ex. '[6, 4]' where 6 and 4 are each individual IDs in my shapefile). Here's an example for ...
9
votes
2answers
62k views

Selecting multiple values with Select by Attributes in ArcGIS Desktop?

Can anyone help me with selecting multiple values from the attribute table? I tried "Classes"='14'AND'07' but it doesn't work.
0
votes
0answers
31 views

I have polygon contain two lines; I want to select and delete the smallest shape length line

I have polygon contain two lines. I want to select and delete the smallest shape length line. Or clip the largest line length. Can't do it manually so I need a model idea or something.
-1
votes
1answer
38 views

Remove selected rows in Geodatabase [closed]

Attempting to delete selected records in a geodatabase. The issue is this geodatabase feature classes stay the same on a weekly basis but the top level geodatabase name changes. My questions are: ...
3
votes
3answers
1k views

Using Select Layer By Attribute to return top 3 records

I have a feature class in a file geodatabase using ArcGIS 10.1. I want to create a model that selects the three features with the highest values in one field (Average Price). Basically I want my ...
6
votes
1answer
297 views

Extracting features with equal field value using graphical modeler of QGIS

Is it possible to automate the following procedure with graphical modeler in qgis 3.4 or is it easier to perform such action with a python script using PyQGIS? Identify a feature (a line) in a vector ...
3
votes
1answer
111 views

Limit on Filter Query Stipulations?

I am novice mapper. I ran into some trouble with QGIS today when trying to add additional census tracts to a layer filter. The tract exists within the layer I'm filtering, but there seems to be a ...
0
votes
0answers
28 views

Select By Attribute: If-Then VB Statement

I am attempting to write an If-Then Statement where if all the UtilityBillingMerge101719.() are true then return all of the results that are true that have an account number. This currently works, ...
0
votes
1answer
56 views

Iterating through geodatabase and assigning field value based on spatial location using ArcPy

This is very similar to Python script to iterate through geodatabase and assign field value based on spatial location and Assigning field value based on location without join just different data. ...
2
votes
2answers
115 views

Selecting latest date by expression

I am trying to select the latest date by expression in QGIS. I tried to use this code "Date"= maximum("Date"). But nothing was selected. I wonder what is the right expression code to select the ...
1
vote
1answer
88 views

Selecting line with specific numeric field value using inline variable for arcpy.UpdateCursor()

I'm currently away in a remote field station using Arc 10.0 and having a hard time using an inline variable substitution for a numeric field value. I am trying to use UpdateCursor to select only a ...
1
vote
4answers
7k views

Zooming to selected features with ArcObjects

I am trying to figure out how to set the active view extent to be able to view all the selected features on the ArcMap. The Map has only one layer. The features are filtered with attributes. Below ...
4
votes
3answers
3k views

Selecting top 10 records in attribute table using ArcMap

I am using ModelBuilder in ArcMap 10.2 to try and find a way to select the first 10 records sorted by Category and then by Distance. For example, my table has 100 banks and 100 churches, which is the "...
4
votes
1answer
641 views

Selecting and updating attribute values using Python console in QGIS?

I am working with Landusefc and Class columns (ref table). What I want is: Selecting all water from "Class" and giving a value say '8' in the "Landusefc" column for these selected features. Table ...
0
votes
1answer
273 views

Arcpy SelectLayerByAttribute for loop with “ADD_TO_SELECTION”

I am a little bit confused with the "ADD_TO_SELECTION" possibility. I process a point layer. First, the idea was to process the points with the different GBAUPS attribute separately. And it worked ...
0
votes
1answer
24 views

Creating a layer with selected values (divided by commas) from another layer - query or model needed

I have a very large dataset in ArcMap 10.6 and I would like to create a subset that selects only rows that have specific attributes (some of them with special characters) from a field that in my case ...
0
votes
0answers
38 views

SelectLayerByAttribute_management not selecting anything

I've read through most of the other similar questions and nothing so far has addressed my issue; most are about syntax. I'm trying to select by attribute from a Feature Layer. But every time, Arc ...
1
vote
2answers
38 views

SelectLayerByAttribute_management selects all of type of attribute instead of specific one?

I want to create a tool that allows a user to select all the points within a specific zip code by inputting that zip code. The code below selects ALL of the points with a zip code - which is all of ...
0
votes
1answer
38 views

Selection of duplicate values of column and update of another column based of selection using ModelBuilder?

How to select a row in ModelBuilder if a number appears again in the column "MyName_C"? For the selected features the column "Ausrichtung" should be added with 180. I am working with ArcGIS ...
0
votes
0answers
21 views

Selecting Polygons of one layer with information from table using ArcGIS Desktop?

I have two 2 datasets: A shapefile with many polygons. They all have an ID. A table (.csv) that has one column with IDs. I need to select all Polygons in 1) that are mentioned in the column of ...
0
votes
1answer
14 views

Defining categories adds previously unselected attributes (ArcMap)

I am using ArcMap 10.5.1 and want to create a layer from a selection of another layer (Selection > Select by attributes..). This works fine and my new layer is displayed. Now I want to assign ...
0
votes
1answer
32 views

arcpy.SelectLayerByAttribute_management ExecuteError

This python code works in ArcGIS Pro but Not in ArcMap . I read some issues that mention a get around by making a feature layer. I tried that and I then get an error saying polytest doesn't exist. ...

1
2 3 4 5
10