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

learn more… | top users | synonyms

1
vote
1answer
29 views

Random Selection using Select By Attributes tool in ArcMap?

How I can make a SQL syntax to generate "RANDOM SELECTION" in Select by attributes tool in ArcMap?. E.g. We have two kind of sample: Quantitative an Qualitative data. Quantitative (seven cases): 1,...
1
vote
0answers
17 views

spatial join on selected features?

I am working with a set of housing data and I am trying to combine a set of apartments into a single point. I was wondering if it would be possible to select only the apartments I want to join and ...
9
votes
7answers
10k views

Selecting by month in date/time field using ArcGIS Desktop?

I would like to select by a specific month from my date/time field in ArcGIS, and just can't seem to find a statement that will work. I have multiple years and multiple days, but want to filter those ...
0
votes
0answers
54 views

Using date field and today's date with arcpy.SelectLayerByAttribute_management()? [on hold]

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. ...
4
votes
2answers
14k views

How to Extract by Attribute Using ModelBuilder with User Input?

Using ModelBuilder, I want to create a tool that will let a user choose the value or values that will be used to extract a shapefile. I have a parcel layer with a "Parcel_Type" field. I want the user ...
2
votes
1answer
108 views

Arcpy SelectByAttributes and Show Selection

I understand that in order to do a SelectByAttribute in Python, you need to first convert the shapefile to a feature layer using the MakeFeatureLayer_management function, and run the SelectByAttribute ...
0
votes
1answer
23 views

ArcMap highlight features from code

I have a shapefile of lines containing an amount n of elements. I exported these features and analyzed them with another program (Matlab), which provided me as an output a row vector of length n ...
2
votes
0answers
37 views

select living-end-streets from a local osm-road-extract with QGIS

I am looking for a method or query to select living-end-streets from a local osm-road-extract. Living-end-streets are dead-end-streets for cars but cyclists and pedestrians can continue on their way. ...
1
vote
1answer
56 views

automated selection by attributes and location within another Layer

I have two Polygon Layers. Layer A are Districts of a City and Layer B are Blocks of a City. Currently i'm working with QGIS 2.6.1 and i don't have access to any other GIS. What i'm trying to do is: ...
-1
votes
0answers
36 views

Arcpy: Make feature layer, select by attribute, and copy features failing to execute

I ran the following script five times, and got my expected result of an individual file for each polygon I had selected from the original shapefile. I then closed Pythonwin, then reopened the file and ...
1
vote
1answer
13 views

Sum habitat type within region using MapInfo?

I have two layers; one shows admin regions and the other shows habitats within those regions with columns for specific attributes and the corresponding area in hectares. I need to work out the total ...
1
vote
2answers
192 views

Highlighting features selected by Python script in ArcMap and ArcGIS Viewer for Flex?

I have a database of orders, with geo data attached. I want the subset of features related to a specific order to be highlighted on screen (for starters in ArcMap, but later in Flex) in a python ...
0
votes
0answers
13 views

Selection anchor when selecting features programatically

In an edit session, I am using code to select multiple features from an SDE polygon layer. After the selection is performed, the user can then use the rotate tool to adjust the features to their ...
1
vote
2answers
226 views

Select by Attributes Crashes ArcGIS

I have a feature class that contains 131000 records. One of its fields (which was originally joined from a table) only has three possible values: null, 0, and 1. I have been trying to select the ...
0
votes
2answers
34 views

Arcpy Select by attributes IN operator with Tuple

I have two layers 1. Buffer zones with a string ID 2. the same buffer zones with the String ID plus an extra field call it zone B *this process is taking place within a loop already, just to give ...
1
vote
1answer
969 views

Debugging Select By Attribute tool within loop giving ERROR 000358: Invalid expression Cannot acquire a lock?

I have seen several similar posts related to this technique but I am still having issues. The following script is intended to select all points from one shapefile that are within the boundaries of a ...
3
votes
1answer
93 views

QGIS Select overlapped feature

I have points that are not equal but the distance between them is so small that it can't be seen even at scale 200k:1. I calculated the distance between these points and add it as attribute. Now I ...
1
vote
0answers
18 views

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

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 ...
5
votes
3answers
21k 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 ...
3
votes
1answer
35 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 ...
2
votes
1answer
55 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 ...
4
votes
2answers
1k views

Select by attribute expression invalid in python

I'm not sure how my expression is failing. Any ideas? inPoints = "points.shp" i = 0 arcpy.MakeFeatureLayer_management(inPoints, "pts") arcpy.SelectLayerByAttribute_management("pts", "NEW_SELECTION", '...
3
votes
1answer
36 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
31 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
75 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
45 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 ...
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. ...
1
vote
2answers
52 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
57 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 ...
2
votes
2answers
176 views

QGIS keyboard shortcut to launch a 'Select by expression' query

I can't find if it is possible to launch a 'Select by expression' query (not to open the dialog) with a keyboard shortcut. I can't find this option in the Settings > Configure shortcuts list... If ...
2
votes
1answer
34 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 ...
0
votes
1answer
61 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 (x86)\...
1
vote
1answer
66 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 ...
3
votes
4answers
5k views

How to group and count attribute data?

I have a problem with group same data to count it. For example, i want to group same code to one and count them. I can do it when i use MapInfo (Pic 1) but i can't in QGIS. (Pic 2: i can classify ...
1
vote
1answer
28 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 (...
4
votes
1answer
91 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
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
147 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 ...
2
votes
1answer
69 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 ...
6
votes
1answer
1k views

ogr2ogr selecting features by attributes

I am writing a shapefile after some processing; however, in the final step I need to do some selection by attributes from the the shapefile. I am using the command in a shell with the aim of using it ...
0
votes
2answers
674 views

How to Select By Location with matching attribute?

I have a whole bunch of overlapping polygons (buffers), I want to select with points only those poly's which: the point falls within; and the poly attribute matches the point attribute What would ...
1
vote
1answer
105 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 ...
9
votes
3answers
13k views

How to give multiple colors to features within a single shapefile?

I want to give multiple colors to different features within a shapefile based on attribute values , is this possible in QGIS ? If yes what is the procedure ? Is there a way to provide color by means ...
2
votes
1answer
90 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
40 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
56 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: ...
1
vote
1answer
117 views

Debugging ERROR 000358: Invalid expression from SelectLayerByAttribute? [duplicate]

I'm creating a script tool and using the SelectLayerBy Attribute function (below), arcpy.SelectLayerByAttribute_management("cities_lyr", "NEW_SELECTION", '"CRIME_INDX" <= 0.02') However, I keep ...
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 5\\Lab05_data\\part2\\...
1
vote
1answer
33 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 ...