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

learn more… | top users | synonyms

1
vote
0answers
13 views

Checking for the presence of a particular field in ModelBuilder [on hold]

The model that I'm now building in ModelBuilder will take as an input a certain feature class that may, or may not, have a certain field. I would like the model to check for the presence of that field ...
2
votes
1answer
47 views

Using function to query text field in ArcGIS Select By Attributes?

I can do this: And get result: On the other hand, when I do this: I get an error message: Why query using function is working on numeric field and is not working on text in both shapefile ...
3
votes
1answer
26 views

Why does the Select by expression dialog not show field values?

I haven't found a similar question that already has an answer so I hope I can get one... Please forgive me if the answer is obvious. I'm using QGIS version 2.14.0-Essen on my macbook pro with OSX ...
2
votes
0answers
23 views

Using ModelBuilder to calculate field in a point dataset based on polygon dataset?

I am attempting to take stormwater point and features and calculate a field "SUBBASIN". The subbasin layer is several polygons of a stormwater basin. In the point feature, I am trying to calculate the ...
5
votes
1answer
60 views

Select every other n rows in ArcGIS for Desktop?

I am trying to select n rows then skip n rows and then select the next n rows until the completion of all rows in a feature class in a file-geodatabase. Below is an example where n =3: Select ...
1
vote
1answer
37 views

How to Select polygons within a feature based on rules applied to FID

I want to select all the polygons of a vector grid which have a FID multiple of N (e.g. N=5). Is that possible?
2
votes
1answer
43 views

QGIS: How to modify the appearence of selected attributes [duplicate]

I am using QGIS version 2.14.1 (Essen). When I open the attributes table of a layer, I select some data which is then highlighted in yellow on the map. I was wondering if it is possible to change the ...
3
votes
1answer
34 views

Performing selection on Attribute and Location of two different feature classes using ArcGIS for Desktop?

I have a point FC and a Polygon FC. Both FC have the attribute VILLAGE. The point with Village = 1500 should be completely within the Polygon with Village = 1500. How can I make a selection not only ...
1
vote
2answers
51 views

Creating a subselection with arcpy

I want to do the following: from a point layer's table, 1) grab all GEBID (an attribute) and create a list(1) with unique GEBIDs 2) iterate through the list(1) in a loop:   2a) stuff all features ...
1
vote
2answers
48 views

Select by attributes on PYQGIS 2.14 Essen

I'm trying to make a selection by attribute with python on QGIS Essen, but it looks like I am making a mistake on the script and I can not find it. Can somebody tell me what I have made wrong, or how ...
1
vote
1answer
23 views

Selecting lowest n values in from attribute table in ModelBuilder?

I have a shapefile with a "Random Number" Column. I'd like to use ModelBuilder to Select and export the lowest N values. I've seen this post about selecting the top 10 records which is pretty similar. ...
2
votes
1answer
32 views

Arcpy tool attribute selection

I'm trying to make tool of change detection between two polygons layers by fields of initial state and final state. Everything is working except attribute selection, I would like user could choose ...
1
vote
1answer
58 views

Pass sql expression with GetParameterAsText to SelectLayerbyAttribute in .py script

With Arctoolbox and python scripting I'm creating long tool, but one of the steps is to select by attributes with SQL expression. Let's imagine that: featureCar = arcpy.GetParameterAsText(0) is Data ...
0
votes
0answers
49 views

Arcpy expression using date field and today's date?

I would like to create an expression similar to the following to incorporate into the arcpy.SelectLayerByAttribute_management function. It's not correct, I just wrote down what I would like it to do. ...
1
vote
1answer
27 views

Performing join on simultaneous spatial and attribute criteria in ArcGIS for Desktop in Modelbuilder?

A similar question was posted here, but I have an additional problem that seems to make the answers there unlikely to work. I am interested in performing a spatial join between point feature class A ...
1
vote
1answer
39 views

Selecting for a specific character

I am using ArcGIS 10.3.1 and editing a file GDB and a string field. I have several fields that are similar to the following, 34-01, 23-14, 87-09, 23-12... I am trying to select for fields that have ...
3
votes
1answer
134 views

Selecting multiple attributes, greater and less than

I am trying to select by attributes from a polygon shape file. I need to select areas with a temperature greater than 10 oC and lower than 15oC using gridcode but i can not seem to work out the ...
4
votes
1answer
80 views

Selection by attribute string in ArcGIS 10 with wildcard as part of the name

I have an attribute field in my file geodatabase (GDB) where I'm trying to select all records that contain an underbar in the string field. The issue is that the underbar is considered a SQL wildcard ...
1
vote
1answer
104 views

SQL statement to find differences between two fields

I am trying to find the difference of 11 feet or more between two fields (Both are Double types). For example, I have a field called shape_length and another field called station_length and I want to ...
2
votes
1answer
84 views

SQL / Select by Attributes query for “does not include text found in another specified field”

I'm using ArcMap 10.2 and I'd like to write a query to select features where Field A does not include text found in Field B. Specifically, Field A contains street numbers and street names. Field B ...
0
votes
1answer
38 views

SelectByAttribute is not working (ArcGIS, Arcpy. Python script) -

My script is below. I use to file from filegeodatabase to select all of rows (in a loop, one by one) to create a simple map and export it to jpeg. For some reason, once I updated my script to run ...
1
vote
1answer
53 views

Open source replacement of ArcGIS select command

Is there an open source (gdal, pyshp, shapely etc.) programmatic option to the select command in ArcGIS. I want to select polygons within a shapefile based on an attribute value. This command is here: ...
0
votes
0answers
7 views

Fixing error arcgisscripting.ExecuteError: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute)? [duplicate]

This is my code: import arcpy arcpy.env.overwriteOutput= True inputpath= "S:\\376\\Spring16\\jthoma16\\Lab 5\\Lab05_data\\part2\\" outputpath= "S:\\376\\Spring16\\jthoma16\\Lab ...
0
votes
1answer
50 views

Invalid Expression ERROR 000358: Select by Attribute

I'm attempting to select a certain point in a feature layer so I can perform buffer analysis on it. The code seems fine, but I am getting an invalid expression error: File "C:\Program Files ...
1
vote
1answer
30 views

SelectLayerByAttribute_management - Python string syntax

I am having trouble getting my syntax correct, currently I have arcpy.SelectLayerByAttribute_management ("SpatialSCRIMNet", "NEW_SELECTION", RtyF LIKE 'D%' OR RtyF = 'S1' ) RtyF is a defined ...
2
votes
1answer
64 views

QGIS modeler: select by attribute wrong results

I am new to QGIS modeler and trying to write a script in which certain attributes are selected and written to a shapefile. See the attached image for the script and the select by attributes box. In ...
0
votes
1answer
58 views

Select Layer By Attribute: SQL Expression using ArcGIS ModelBuilder?

I am currently using ArcMap 10.3's ModelBuilder. Having created a feature class of 300 zones, I would like to filter these to the 15 zones above 200 hectares in size, the model is shown below: I ...
2
votes
1answer
56 views

Selecting many maximum points within polygons

I've got a point layer with three values such as high, age etc. and polygon layer with many forest area. What I want to do is to select the 100 maximum (highest) points in every polygon. I can't do ...
1
vote
1answer
29 views

Selecting the minimum point in a polygon

I am attempting to find the minimum point value within a polygon using ArcGIS 10.3. I have two datasets: 1) A series of polygons & 2) A series of points scattered about. After selecting a given ...
0
votes
4answers
59 views

Web service with geoprocessing capabilities (i.e. use of select tool)?

We would like to have a published web service with capabilities to allow geoprocessing operations (consume feature data) - select tool (e.g. select by attributes) - on the service when we view/open it ...
0
votes
0answers
59 views

Rasterize layer with GDAL after attribute filtering

I am working with GDAL/OGR and I need to do the following task : I have a shapefile with many attributes. I performed a query over one of them, "type_of_building='Church'". I have done this with the ...
9
votes
2answers
229 views

Select by Attributes - Strings with < 5 characters

I have a column of zip codes which are strings. Most of them are the usual 5 digit zip codes, but some are only 3 digits or missing a digit. (keep in mind, I need this column as strings for other ...
0
votes
2answers
122 views

Using Python Search Cursor results to Select Features by Attributes

I would like to preface this by saying that I am very new to python and its capabilities. So my problem is that while using the in_memory work space I encountered some limitations in querying the ...
0
votes
1answer
37 views

ArcGIS Select largest N rows in group

I have feature class (Name: V1) in personal geodatabase with columns: Height [float] and Id [int] representing group number I need to do SQL query that will select eight highest 'Height' values in ...
3
votes
4answers
566 views

Get Parameter as Text and select layer by attribute

I have written a python script tool wherein a user specifies a feature class (e.g., Landuse) containing different attributes (e.g., parcel size, landcover etc.), name of the attribute field from which ...
2
votes
2answers
168 views

Dissolve line segments in QGIS if they touch and fall within the same class. (tools or script?)

I have line segments that have the following 3 attributes (Class, start_point, end_point). I would like to merge/dissolve line segments that fall within the same class if they intersect (touch). i.e. ...
1
vote
1answer
52 views

How to select attributes by unicode field value?

I have an attribute table in QGIS 2.10 with a string field (myfield) and when I want to make a selection based on the unique values of this field I get no selection at all. >idxmyfield = ...
0
votes
2answers
73 views

Python select by attributes, location, copy features [closed]

Python script is failing. It's supposed to make a selection from a lyer based on attributes value and then select intersecting features of that selection and then make a copy of the selection as a new ...
0
votes
1answer
36 views

Auto-selecting records in all spatial and non-spatial joined/related tables by selecting only “parent” spatial record in ArcGIS for Desktop?

(1) I have a layer of pipes with related spatial and non-spatial data linked via joins and relates. Is there a way of selecting the top/parent record and then having ArcGIS auto-select all related ...
0
votes
1answer
61 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 ...
0
votes
0answers
41 views

How to extract cross pattern in point data based on heading field, automated using ArcPy

I'm trying to automate a process to identify and remove a cross pattern in point data, as seen below: This picture shows the points colored by heading (degrees from North), with the exception of ...
1
vote
2answers
125 views

Python script for select by attribute function for QGIS

The following is of course working, selects these features of my_layer that have attribute 1 for my_field2 and appends the corresponding attributes of my_field1 in my_list: my_layer = ...
2
votes
2answers
102 views

QGIS Select double feature by attributes

There is this point shapefile in QGIS (2.12). There is one column with the street name and one with the housenumber. Is it possible to select all features that have the same street name and ...
0
votes
1answer
102 views

Python code to select streamlines within selected watershed

I'm trying to calculate total stream length for multiple, overlapping watersheds (i.e., each watershed contains the watersheds upstream of it). I have a flowline layer that I've run through the ...
1
vote
1answer
39 views

Empty feature classes made when trying to split by attribute

I am working with a Basic license of ArcMap 10.3, and I am trying to split a feature class into multiple feature classes in a geodatabase by unique values of an attribute. More specifically, I have a ...
3
votes
2answers
198 views

subquery in select by attribute in Arcgis

I have a table with several fields. field A contains the same kind of values as does field B. I tried to select all points where the value in field A does not exist in anywhere field B using query ...
0
votes
1answer
53 views

Copying Multiple Selections (by Attribute) to One Output Shapefile using QGIS Python scripting?

INTRODUCTION The code below makes a selection and then saves to an 'Output' file (shapefile?) each time through the "FINAL ITERATION LOOP". Each 'Output' file will contain all selected civic address ...
3
votes
1answer
122 views

How can I select all streams downstream of a polygon

I have an ordered stream network and I want to select all stream features that contain water that has come from a certain area. To start with I'm running a select by location query to find all stream ...
1
vote
2answers
118 views

QGIS Tool Scripting Help with “Select by attribute”

** I've gone back and edited (shortened and focused) my own question QUESTION: Why am I getting the error message "The following layers were not correctly generated: Output", when writing a script ...
3
votes
1answer
66 views

In ArcGIS 10.x, how do I select features of a point shapefile whose z values are above or below the elevations in a DEM?

I have a multi-point shapefile representing earthquake hypocenters (containing depth values) and I have a DEM raster representing an underground surface (the top of the PreCambrian basement). I want ...