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
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
1answer
185 views

Getting ERROR 000840 from arcpy.SelectLayerByAttribute_management? [duplicate]

I am trying to select layer by attribute and for that, I am using arcpy.SelectLayerByAttribute_management function . My command is as follows: arcpy.SelectLayerByAttribute_management(union, '...
0
votes
0answers
52 views

Selecting layer by attribute in Python Toolbox of ArcPy?

I have this code where te input parameters are a shapefile [param0] and a string list [param1]. The second parameter is a list because I want that user select it. class Tool(object): def __init__(...
0
votes
0answers
30 views

Selecting values with date-format by using SelectLayerByAttribute_management with input Parameter

I am working on a Tool which selects records depending on the input value. Works fine, till I want to select date-records. I used def buildWhereClause(self, table, field, value): # Add DBMS-...
0
votes
1answer
64 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 ...
0
votes
1answer
132 views

Equivalent of 'Left' function in Select_analysis

I tried to find the equivalent of Left fuction because it doesn't work in ArcGis. I found a post that suggested the word substring: the query is: WHERE (IAS.C_A)<>Left([C_A1],5))); and I ...
0
votes
0answers
72 views

Selecting Points by their Spatial Location to an Attribute of a Layer

I have a large point layer of addresses within a district. Each address point has a field called "Street External Key [SEK]" which is tied (meaning identical to) the corresponding "Street External Key ...
0
votes
0answers
38 views

Can arcpy let the user enter a query expression for select layer by attribute?

I have written something like this: inFc = sys.argv[1] FLayer = sys.argv[2] FValue = sys.argv[3] arcpy.MakeFeatureLayer_management(inFc, FLayer) #feature layer created arcpy....
0
votes
0answers
86 views

Formating a query in ArcPy- why the error?

I have the following Select Layer By Attribute statement throwing a 000358 invalid expression error using Python with ArcGIS 10.4. The input feature layer is valid because I can select features using ...
0
votes
2answers
69 views

What's wrong with my expression?

I'm trying to have a user input a county in my tool, and then use that string to select from a layer of counties. County = arcpy.GetParameterAsText(0) #Select county to clip arcpy....
0
votes
0answers
517 views

Clear selection - argument as a layer name or layer object?

I am writing a script tool that takes multiple layers, selects every item from each layer, zooms to it and exports the image. After the last row in layer, the selection is cleared and new layer comes ...
0
votes
1answer
164 views

Using variable in SelectByAttribute_management [duplicate]

I am new in Python. I was trying to use a variable for selecting a feature instead of giving a direct input. My code sample will explain it better: import arcpy from arcpy import env env....
0
votes
0answers
63 views

How to select areas from a target layer which do not intersect source layer? [duplicate]

I have two different layers, one is county boundary and another one is soil map. My question is I would like to select only those areas which are outside the county boundary. Using "Select by ...
0
votes
1answer
895 views

Python: 'Select by Attribute' in ArcMap 10

I would like to get the search the field value 'SURFACE LOCATION%' in column 'RefName' in layer '*.dwg Annotation' This is what I have so far... # Find the Dataframe df = arcpy.mapping....
-1
votes
1answer
52 views

how do I select records from a layer that do NOT have features from another layer within them? [closed]

I'm trying to find vacant land in my city. I have a layer with buildings and a layer of parcels. I want to create a layer of the parcels that do not have buildings within them. I have tried select by ...
-1
votes
1answer
35 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: ...
-1
votes
1answer
42 views

Select by using ArcPy? [closed]

From the below table: If number of ID_T's counts is more than 2 then, I have to select, same ID_T but DIST value vary of minimum 10 meters
-1
votes
1answer
83 views

How to select attribute specific values? [closed]

I have table like I need to select if R_no values is more than two same values and in ANGLE select first three numbers common and more than three attributes is same Finally I want to select like ...
-1
votes
1answer
55 views

Select analysis tool is creating an empty feature class in an arcpy stand alone script [closed]

I'm using select analysis to find a specific value. My program is working and I'm not getting any errors. However, the feature class that the program is creating is empty. I've double checked to make ...
-1
votes
1answer
190 views

Select by Attribute Sum Fields [closed]

Is it possible to sum fields together in the select by attribute tool with a SQL query? I'm working in ArcMap 10.3.
-1
votes
1answer
70 views

Error: 000358 Failed to execute (SelectLayerByAttribute) halfway through the script

Its strange that the script would start and work on some data, but then fails more than half way through. Here is the error message and relevant script (error line 229 in bold) line 229, ...
-1
votes
2answers
58 views

Selecting parcels with multiple features [closed]

So i have a parcel polygon layer and a house point layer. I want to select parcels that have two or more points in them? Any suggestions?
-1
votes
0answers
37 views

Getting values from cells in selected rows using ModelBuilder

If I use a selection query to select certain rows in a table, say "Fruit = 'Bannana' ". How would I then get cell values from a different column for example 'Type: Cavandish, Ladyfinger' to use ...
-1
votes
1answer
66 views

Finding and labeling intersections between polygons on a shapefile

I have two shapefiles-- one is labeled islands, the other is unlabeled parcels of land on some of the islands. My issue is that I need to label the islands that have parcels of land. My instinct is to ...
-3
votes
1answer
71 views

Is there a function when using Select by attributes, to select only the continents' annotations? [closed]

Annotations beginning with character "C" refers to continents and I want to select only these annotations.

1 6 7 8 9 10