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

learn more… | top users | synonyms

0
votes
2answers
427 views

Arcpy SelectLayerByAttribute_management where_clause with LIKE not returning like values

I am selecting 2 intersections from a shape file using info from a File Geodatabase Table. The values are very similar as shown in example at the bottom. I am using a LIKE in the statement but it is ...
1
vote
4answers
2k views

Zoom to selected features with ArcObjects

I am trying to figure out what is the best way to set the active view extent to be able to view all the selected features on the Arc Map. 1.The Map has only one layer. 2.The features are filtered ...
1
vote
1answer
171 views

How to select and zoom in features from a QGIS Python Plugin

I'm very new to Python. I'm trying to find a way to select and zoom to the features from a QGIS layer. I've created a plugin and built a custom form. I have 3 values from the form which I need to ...
1
vote
2answers
47 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 ...
1
vote
2answers
28 views

On line shapefile, how to compare attribute between consecutives edges

I have a line shapefile with speed restriction attribute on each edge. I like to verify differences between two consecutive edges for all shapefile edges. Example: One line has speed restriction set ...
3
votes
3answers
5k views

Make selected polygon different color without covering everything?

Working in ArcGIS Desktop 9.3 I'm selecting polygons by attributes and trying to have the selection show up as a light yellow. I set the selection color to the light yellow and it's the 'lowest/last' ...
0
votes
0answers
25 views

SQL fails in python. In ArcMap error FDO error: -2147024871 returned

I'm having issues with an SQL expression for a feature class in a file geodatabase. When working in ArcMap, the SQL will fail on its first attempt, and produce the following error: However, when I ...
2
votes
2answers
426 views

Selection subquery using another table in database ArcGIS

I need to 'extract' a list of variables based on the IDs from another table. Using a subquery seems to be the best method. I have a large list of variables and have outside calculated a second list. ...
1
vote
1answer
28 views

Using Select Layer By Attribute in ArcGIS ModelBuilder multiple times?

I want to use Select Layer By Attribute in ArcGIS ModelBuilder multiple times. It works everything fine until a new feature is created (e.g. after Dissolve or Multipart to Singlepart). Then I can't ...
0
votes
1answer
55 views

How to get features “not getting” intersected in arcobjects?

I have two feature classes. I'm intersecting both of them. I have to return features which does not intersect with the other. Lets take an example. I have two feature classes: villages and colleges. ...
1
vote
0answers
19 views

Is order of selection in Spatial Data important (attribute, location, graphic)?

When dealing with spatial data in a GIS system, does it matter which way you select the information if you're using all 3 - attribute location and graphical selection? In my experience it seems to not ...
0
votes
1answer
50 views

Select by attributes with user input using Python

I am new to GIS and Python is not my forte, so I am looking for some help. Ideally, what I am trying to do is create a tool that allows the user to select an address from my Address points layer. I ...
1
vote
1answer
51 views

arcpy; Select by attribute with an If, then statement

I am looking for some advice on how to construct an if, then statement based on a select by attribute SQL query or some other method (search cursor?). I am asking users to input a unique ID ...
1
vote
1answer
909 views

QGIS Advanced String Filter Expression returns too many results

"GNR" is a string column and I expect the filter expression "GNR"='.11' to only return the feature with the value '0.11'. Why are the other features with values of '.110'and '.1100' included? Is ...
21
votes
5answers
29k views

Get list of coordinates for points in a layer?

I've got a layer in QGIS that is comprised of points. Its attribute table doesn't have (show) the corresponding x and y coordinates for each point. Is there a way for me to extract a list of ...
2
votes
3answers
77 views

How to use the SQL in select by attribute to select the entries for each values in certain field?

I am trying to use select by attribute for the table in ArcGIS, which is similar to the following picture (lets say): I want to select those entries for each A and B, which have maximum count. I ...
4
votes
2answers
73 views

How can I use boolean value in QGIS style rule?

I'm trying to make a style based on rules, and I want to use a boolean field I have created for that. But I do the following: "field" like 'TRUE' "field" like TRUE "field" like 1 "field" like '1' ...
0
votes
0answers
30 views

How does getLegendGraphic, from GeoServer, handle attribute-based styles?

Suppose I have a layer with a color attribute. Now, I write an SLD with a fill color like this: <sld:PolygonSymbolizer> <sld:Fill> <sld:CssParameter name="fill"> ...
1
vote
1answer
42 views

Using Select by Location and Select by Attributes in single ModelBuilder model?

I'm working on a project involving wind turbines. I'm using ArcMap 10.2 and ModelBuilder to count the number of wind turbines within a 5km buffer zone of a given project (let's call it Project A), and ...
5
votes
1answer
272 views

Select by Attribute all features with values that are multiples of 5?

In my shapefile, I have a bunch of features and one field is a integer numerical attribute. I'd like to select all of the features whose value is a multiple of another value. For instance, I have a ...
1
vote
1answer
179 views

Easy Extraction of features from a Feature dataset ( Not feature class)

My Feature dataset (residing inside a GDB) contains more than 30 feature classes and every month I like to extract features from this GDB based on one attribute, which is repeating in all the feature ...
0
votes
1answer
50 views

ArcGIS Select by Attribute SQL syntax problem

I have a list of aprox 150 unique road names in Excel. I copy and paste (as text option) that list into Word (2013 version). I then "replace" all the end paragraphs (^p) with quotes and commas (','). ...
1
vote
1answer
54 views

Why does Select Layer By Attribute give errors 000622 & 000628?

I try to select line segments from a layer "t_Pavement_Line which is open in TOC using the following line: arcpy.SelectLayerByAttribute_management("t_Pavement_Line", "NEW_SELECTION", ...
3
votes
4answers
13k 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
votes
0answers
29 views

Selecting Polygons that falls in another polygon [on hold]

1) I have 2 different polygons, surveyed lots and tenure boundary for a particular country. I would like to label the tenure attributes of the surveyed lots as they fall into the tenure boundaries. ...
0
votes
0answers
25 views

New value in attribute table for big amount of points

I have got a huge amount of points. I need to change their value according to thier current value. Ex. I have got 4000 points. 1000 with value 7 and 3000 with value 8. I have to select all those 1000 ...
3
votes
1answer
51 views

Problem with arcpy select statement

I have a shp layer with an attribute table. One field has the name Nid and the values are strings (e.g. “0150”, “0420”, “3462” …) Now I want to select the rows in the table that match a given Nid ...
3
votes
1answer
66 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 ...
2
votes
1answer
58 views

Using a for loop to execute a query in arcpy

I'm trying to provide the breakdown of fire detection for an area by sorting of confidence levels. The dataset has 12 files (one for each month in a year) with fire records which all have a column ...
3
votes
1answer
107 views

Meaning of empty quotes in select by attribute query?

Can someone please help explain if the empty '' means something? I am wondering if it might be inserted by typo or if you use these empty quotes to locate empty fields within the attributes.
1
vote
1answer
48 views

How do I select all points from a range of dates?

Is there a way to select points from a range of dates to create a new layer? I want to clean up my data by making all points from previous years a separate layer but doing a selection by attributes ...
1
vote
0answers
37 views

Querying on Household Income ranges in a dataset

I've recently been assigned a project to create an ArcGIS database to hold responses from a survey which will be used to perform analysis on the data. One column requires me to enter a dollar-range ...
7
votes
2answers
4k views

SELECT TOP query in ArcGIS Desktop?

Is there a way to use a SELECT TOP (n) within ArcGIS desktop? Is appears that since the ArcGIS query builder is effectively building the SQL statement after the WHERE clause, that this may not be ...
0
votes
0answers
13 views

Field names change when selecting by attribute/location and then copying feature in model builder [duplicate]

I am trying to create a tool to make my workflow faster for a routine job task. Basically, I have a USGS 7.5 min quad layer and a feature (species) layer, and I want to ultimately create a shapefile ...
2
votes
1answer
149 views

How to select features using an expression with pyqgis?

How can I select features with pyqgis using an expression? I tried to use an QgsExpression but the select method doesn't take it: exp = QgsExpression("'ogc_fid' = 482") cLayer = ...
0
votes
1answer
166 views

Error in python code for loop using SearchCursor, selectlayerbyattribute, and copyfeatures tools

I am fairly new to python scripting for ArcGIS. I am trying to create maps where each county is selected and then copied into a new layer with only that county's data. Then, I used ApplySymbologyFrom ...
1
vote
2answers
81 views

How to search by attribute using each row with Python?

I am trying to write a script to select each individual neighborhood using one FC, then use select by location to see the number of lots from another FC that are in the neighborhood and store that ...
0
votes
0answers
35 views

Trouble with select by attribute on ArcSDE

I am having trouble with some extracts on a csv table on ArcSDE. Verifying my expression results in the following pop up: "The expression was verified successfully but no records were returned."
2
votes
2answers
65 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 ...
1
vote
0answers
68 views

ArcMap Select By Attribute finds No feature selected when it should?

When I use ArcObjects to select a feature in a layer, it did not work. After that I tried to use the Select By Attribute function in ArcMap and I found something strange: (1) when I use WHERE ITEM_NO ...
0
votes
0answers
99 views

Output extent environment is not respected by Select Layer By Attribute (ArcGIS 10.2)

I cannot get the arcpy.env.extent working for Select Layer By Attribute GP tool. I can verify that I get various values for coordinates when I have panned to various areas on the map. Copy Features GP ...
2
votes
2answers
864 views

How to select a multiple field value by expression from the same layer in QGIS?

Using QGIS in the operation 'select by expression' how is the correct expression to select multiple field value? ex. City NAME = ROME and NAPLES (expression is invalid)
2
votes
0answers
110 views

How to move points to another polygon based on attribute? [closed]

I have a point layer and a grid cell/fishnet layer. Each point falls within a grid cell. Now I want to move some of the points to another (the nearest) grid cell based on an attribute that exists in ...
7
votes
2answers
9k views

How to select multiple values with Select by Attributes in ArcGIS 10

Can anyone help me with selecting multiple values from the attribute table? I tried "Classes"='14'AND'07' but it doesn't work.
1
vote
3answers
7k views

Python Script for Select by Attributes taking user input

I am trying to write a python script and create a script tool in ArcGIS that will let a user choose the value or values that will be used to extract a shapefile. These selected value(s) will then need ...
1
vote
2answers
161 views

Multi Value User Input as Variable in SQL Statement

I'm attempting to write a script that takes a user's selection as a parameter and uses that as part of the SelectByAttributes function. The parameter represents field attributes and is multi value, ...
2
votes
1answer
71 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 ...
1
vote
2answers
87 views

How to select feature by attribute with expression to use it in ModelBuilder?

I want to create ModelBuilder that contain two process . The first process is select feature using expression then the second process is delete the feature that we selected in first process . I want ...
0
votes
1answer
36 views

ArcGIS error - “invalid SQL” [duplicate]

I have a map with a few different layers. One of these layers is a 'cities' layer. I am trying to use selection->select by attribute-> Select: "Pop_CL"=8 or 9 or 10..... where Pop_CL is the population ...
3
votes
1answer
41 views

Systematic sampling by FID

I have a shapefile created by a corn planter. It creates a point for each planting row every second. So a 16-row planter creates 16 points as it goes along the field. As a consequence, a small 30-acre ...