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

learn more… | top users | synonyms

1
vote
1answer
535 views

How to select features where attribute is not NULL?

I have an OS AddressBase shape file. One of the attributes is 'paoText'. It is either a text string like 'Anchor House' or is NULL. I want to extract all the records where there is a text string ...
3
votes
4answers
9k 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
vote
3answers
5k 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 ...
6
votes
1answer
3k views

Select all “NULL” values in the attribute table?

I have a quite simple syntax question. I want to select ALL my null values in an attribute table of a feature class, not just the values in a single field. So the question would be: what is the ...
5
votes
2answers
2k views

ArcGIS 10 Field Calculator doesn't notice selection/Attribute Table problem?

I just have an annoying problem with the Field Calculator in ArcGIS 10. I selected specific points of a Shapefile I want to calculate, but FC is always calculating all fields. Unfortunately there is ...
3
votes
1answer
400 views

How to Select polygon feature in ArcMap and pass Selection into Python Addin?

I have a script that uses a arcpy's 'SelectByAttribute' syntax to choose a record in a polygon feature class. Following that, I do a 'SelectbyLocation' to select points from a feature class that lie ...
2
votes
0answers
171 views

Select a distinct attribute with maximum shape area

I am trying to manipulate a large dataset containing a lot of sliver polygons resulting from an overlay operations. (The eliminate tool is very time consuming to generalize them.) I identified the ...
9
votes
1answer
696 views

Arcmap Select by Attribute with Python

I would like the following to select (highlight) the "project" layer that intersects the grid, and then pull a record from the selected "Grid". I do not need to save the layer. Note: Running the ...
0
votes
1answer
740 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 = ...
1
vote
1answer
330 views

Search By Location

Using Arcmap 9.3 I was curious if anybody has a script or vba tool that will select items from a layer that are not within a selected polygon or not touching the selected polygon. Thanks for your ...
3
votes
1answer
522 views

Selecting multiple variables by Attribute from different target layers

I have a model with species point data as a source layer and a number of different shapefiles as target layers. To start I run a search by location tool to determine where the source and target layers ...
1
vote
4answers
776 views

Making multiple separate selections from attributes [duplicate]

I am using ArcGIS 10 with ArcEditor license. I have a 10 year composite of month-to-month temperature values for 17 weather stations. That makes 120 months. I have to select each and every month ...
3
votes
2answers
6k 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 ...
4
votes
1answer
333 views

Selecting the most recent entries from a table in Arc

I have a point shape file that has many event occurances stored for ever point. I am trying to select the most recent event for every point. Is there a way to do this through the "Select by ...
4
votes
2answers
4k 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 ...
0
votes
2answers
450 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 ...
28
votes
2answers
2k views

Is there a “Select by Attributes” plugin/widget for ArcGIS Server JS API?

I'm hoping to find some existing code which emulates the "Select by Attributes" dialog in ArcMap, within the ArcGIS Server JavaScript API. Writing a hard-coded QueryTask is easy - I'm looking for ...
5
votes
2answers
531 views

select by attribute on shapefiles with open-source python modules

I usually use ArcGis 9.3.1, but when running a python script that includes Select_by_attribute (from gp), the script runs very very slowly. Is there a way I can perform a select-by-attribute on a ...
4
votes
4answers
4k views

Automate Select by Location

I have 2 shape files (A and B) each with thousands of polygons. I want to select polygons from A which intersect a specific polygon from B, and save the selected polygons from A as a new shapefile. I ...
1
vote
2answers
611 views

Select By Attribute using geoprocessing without using layers?

I am selecting features based on attributes within an ArcGIS Add-In. The selections are pretty simple(e.g. "DESCRIPTION = left"). Is there a tool or method of doing this that doesn't require passing ...
19
votes
5answers
23k 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
4answers
2k views

How can you auto-populate field using spatial location of another feature and its attributes?

I want to auto-populate a field based on the spatial location of another feature's attribute. Add a point on top of a building. The point automatically adds the name of the building. This seems like ...
7
votes
2answers
3k views

SELECT TOP query in ArcGIS

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 ...
7
votes
1answer
9k views

How to use Select by Attributes query with semicolons?

I am trying to select multiple (50 or more) unique numeric records using ArcGIS 10's "Select by Attributes" using semicolons ';' after each record which it verifies as good to go. Please see screen ...
7
votes
2answers
1k views

selecting by attribute and specific value replace

I want to select all of the features by attribute where the attribue in myattrib is like... Selection "criteria H". That is not a problem. However then I need to replace (myattrib," H", "") except ...
4
votes
3answers
525 views

Setting defaults in the 'Select By Attribute' SQL editor

Is there a way to set default values in the 'Select By Attribute' SQL editor (the where clause) ? I want to set a permanent value that will appear every time I enter the 'Select by Attribute' window, ...