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

learn more… | top users | synonyms

3
votes
1answer
29 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 ...
2
votes
3answers
72 views

How to select top 10 records in an attribute table

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 ...
0
votes
1answer
24 views

select a line with specific numeric field value using an inline variable for 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 ...
0
votes
0answers
26 views

Simple query not returning values

I have a super simple select by attribute query "Coefficient" = #, the #'s are 0, .2, .3, etc... to 1. The query will select some of the #s but not others. Example) when I query 0,1,.5 the attributes ...
2
votes
1answer
33 views

Getting attributes from a lyr file

I have downloaded a crime dataset from imaps, an online GIS server for Raleigh, NC. The dataset shows the location and types of crimes in the past 90 days. Using the info tool, I can see all of the ...
1
vote
2answers
32 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 ...
1
vote
1answer
34 views

Need to select and delete features in ModelBuilder

I'm new to ModelBuilder and I'm planning to take some class of it, but in the meantime I have a project with a relative easy task. The high-level plan of this project is: Load shapefile into ...
3
votes
1answer
49 views

Select duplicate attributes in same shape file in QGIS

I have this vector layer of lines between 2 nodes. I need to select all second entries that have the same length of the previous one. Can someone help me with this?
0
votes
1answer
43 views

Not showing the unselected elements for map production

I have made a selection using attributes, from two different feature classes, once I have done that, i want to make map, but i want other 'unselected elements' to be not seen in actual map, below ...
1
vote
3answers
22 views

Selecting an attribute from a classified raster image

I am trying to select just the black attribute (classified water in the image) but I can not select anything. In the attribute table it lets me select the row, but it will not select in the map. I ...
6
votes
2answers
123 views

Select by Attribute within a specific area (using Select by Location?)

I have a map with four layers. Two of these layers cover an entire state, and the other two focus on the area I'm actually interested in within the state. I'm trying to Select by Attribute with one ...
0
votes
2answers
59 views

Select Layer by Attribute: SQL and variable problems

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
73 views

Returning feature with maximum OBJECTID from Select By Attribute tool of ArcMap?

I want to get the maximum OBJECTID from a layer using "select by attribute" tool. But the result is not with the maximum OBJECTID. When I use "select by attribute" tool to get the maximum ...
2
votes
0answers
30 views

Exporting attribute data from vector data by selecting object in QGIS?

I'm using QGIS (2.4.0), and i need to export the attribute data of the object i select (shapefile) to another file ( Excel, txt,...it is yet to be determined depending on the solution). I know how it ...
1
vote
1answer
106 views

How to delete selected features in Qgis using Python

I have a shape file with only one field DN. I would like to delete all features which does not have specific value of the field. Let say the DN can be 1,2 or 3. So far I was able to find out how to ...
2
votes
1answer
92 views

ArcPy inconsistently accepts SQL queries for MakeFeatureLayer or SelectLayerByAttribute

I need to buffer a subset of features in a particular feature class. To do this, I am first creating a feature layer (using a SQL query to select only what I want), and then running Buffer. So my ...
2
votes
2answers
132 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
40 views

Alternative to Copy Features in ModelBuilder to display a result [closed]

I have created a model that takes in a raster, converts it to a point shapefile, then extracts a set of points based on location, then further selects a set of points based on a SQL expression. I ...
1
vote
1answer
156 views

Select By Attribute: Between Two Numbers [closed]

I am trying to select house numbers that are between 200 and 499. I've been using: "HOUSE_" >= '200' AND "HOUSE_" <= '499' ... and it's coming up with almost everything else. The numbers it ...
1
vote
1answer
57 views

How to perform a spatio-temporal query in attribute table? [duplicate]

I am not good at programming, so I would ask for your understanding concerning my question. I have an attribute table that contains five columns which are: (Date, ID, Latitude, Longitude, Rainfall). ...
0
votes
2answers
74 views

How to handle list variable in a where clause

I am calling a list of names in from a text file and would like to use each of those to make new layers. I am running into an issue where I get "TypeError: cannot concatenate 'str' and 'list' objects" ...
0
votes
0answers
65 views

How to select records in a table based on attributes in related table

I am using ArcMap 10.1 and Python I have a list of addresses to geocode, but I want to thin the list because I only need a specific area of the addresses. I have a layer containing the streets in ...
2
votes
3answers
339 views

SQL expression error for Select Layer By Attribute

arcpy.MakeFeatureLayer_management("N05-12_Station2_JGD.shp","station_12") year=2012 arcpy.SelectLayerByAttribute_management("station_12","#",'"closing">=%d AND "opening"<=%d' % year) ...
0
votes
1answer
51 views

Selecting Features in ArcGIS based on their relation other layers

I am extremely new to GIS mapping and I'm trying to do what I believe would be relatively simple. I have two layers: one contains data on school locations in Chicago and the other contains data on ...
0
votes
0answers
38 views

How to select the longest vector in a couple of parallel polylines?

I work with ArcGis 10.2. I need to find the longest vector in a couple of parallel vectors. They are extracted from an Intersect of Streets buffer and a flooding limit. So I have sometimes only one ...
1
vote
1answer
50 views

How to Select By Attributes on only Field with all its chars in Capital letters?

Need some assistance with this situation: I have a polygon feature class with a string Field. It has mixed values like: "PARIS" - "LISBON" - "london" - "luxemburg" - "Athens". In this example, I'd ...
2
votes
0answers
65 views

How to move points to another polygon based on attribute?

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 ...
-3
votes
1answer
48 views

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

Annotations beginning with character "C" refers to continents and I want to select only these annotations.
0
votes
0answers
77 views

select by attributes in modelbuilder while using iterate?

I have crated a model that iterates GPX-files from a folder and works through it and gives me a raster as output with pixel values after how many tracks passes through each pixel. This works the way ...
1
vote
1answer
82 views

Stream Trace to Select Attributes

I'm trying to work on a school project, but I only need streams up stream from a certain point. As you can see in the picture, I've run the stream trace tool upstream from a point i've created. I'm ...
0
votes
2answers
927 views

QGIS select features from attribute table using the “LIKE” operator

I created an expression with the help of the GUI in the QGIS attribute table of a vector (shapefile) layer of Native American ("Indian") reservations in the USA state of New Mexico. "NAME" LIKE ...
-1
votes
4answers
918 views

What is a SQL Query to all values in a column with Select by Attribute in ArcGIS? [closed]

I would like to select all values for an attribute using select layer by attribute to use in model builder and hopefully save the expression for automation purposes. If I have an attribute named ...
0
votes
1answer
94 views

problem with SelectLayerByAttribute management in script

hello my problem is that this tool works perfectly in IDLE or PyScripter programs, but if I use in the script in ArcGIS desktop this problem occurs: arcgisscripting.ExecuteError:ERROR 000582... why ...
1
vote
1answer
454 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 ...
1
vote
1answer
217 views

What is correct Where Clause when using variable and Select By Attribute tool within loop?

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 ...
0
votes
1answer
55 views

Using attributes of a polygon in one layer to identify polygons in another

So I'm in the process of developing a web application, I am using open source tools so qgis, postgis, play framework for the web app. And I have come across an interesting problem that I'm trying to ...
3
votes
1answer
102 views

Is it possible to save frequently used expressions in QGIS?

Is there any way to save frequently used expressions in the selection or field calculator dialogs? Obviously I can cut and paste them into a file where I might save them, but I mean within the context ...
1
vote
0answers
77 views

select remove layers not working second time

http://www.youtube.com/watch?v=qxVO0tFdiuA&feature i captured video. You can watch. Now i explain my problem. Firstly, when i create popup and in popup menu when i call function and select ...
3
votes
1answer
259 views

ArcMAP SQL Statement Iterate Feature Selection 'IN' 'BY' 'IS' - escape character

We have a problem when selecting Features from a Feature Class in ArcMAP 10.2 using the Iterate Feature Selection tool in Model builder Our dataset has a Attribute Field with two character codes like ...
2
votes
0answers
260 views

Shapefile From Excel Sheet Crash When Selected Spatialy or By Attributes

Using ArcGIS 10.2, I am receiving an Excel sheet, on a daily basis, which contains 105 columns(Fields) and includes has X and Y values. For whatever reason (which I cannot understand) all data types ...
2
votes
2answers
321 views

Why cant I use SelectLayerByAttribute_management while a cursor is set

I've been having a problem with arcpy in that the simple line: arcpy.SelectLayerByAttribute_management ("TEMP_LINES") produces this response: Runtime error : ERROR 000358: Invalid expression Failed ...
0
votes
1answer
80 views

How to subset some polygons from shapefile?

I have a shapefile of lakes with lots of polygons. The area I'm interested in is only big lakes. Is there any way to subset only the polygons I interested from the shapefile? How can I do it in ...
0
votes
2answers
378 views

What causes ExecuteError: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute) on shapefile? [duplicate]

My script runs perfectly for feature classes, but not shapefiles. It crashes at the point of selection, provided there is a query. gp.Workspace = "C:/someworkspace" fc = "featureclass.shp" query = ...
1
vote
1answer
221 views

Python problems with select by attributes and user input

I am attempting to create a tool where the user can input a census tract number within the city of Plano (there are 77 tracts) and it ultimately creates a map layout showing the population density. I ...
0
votes
1answer
75 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 ...
1
vote
0answers
124 views

How to select and highlight feature by attribute

I have the below code which does a select by shape on my arc map how do I achieve this with attributes 1.The map has only one layer 2.There is a filter for the attributes on features Below is the ...
1
vote
3answers
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 ...
0
votes
0answers
68 views

arcgisscripting - setValue error

I'm having difficulty isolating this problem - at the point I attempt to alter a record with update cursor, the script returns a 999999 error. I've tried running this script without ArcMap running in ...
1
vote
2answers
95 views

How to implement predefined attribute filters in an Openlayers web map? [closed]

I imagine this situation: I've got relatively big point layer and I want to split(filter) the points to predefined selections. Predefined selection would be based on the attribute(for example ...
3
votes
2answers
3k views

How to select multiple value in select by attributes in ArcGIS 10

Does anybody can help me with select multiple values from the attribute table? I try this command: "Classes"='14'AND'07' but doesn't work. Thank you.