Querying the attribute tables of feature layers using ArcMap 10.2

Overview                                                           Video presentation link
Querying or filtering attribute data in a GIS is technically one of the important parts of using a GIS. Fields contain several kinds of values that are linked to a spatial object. In order to get specific information from these data fields, a selection or query is applied.

Task
Our task in this post is to show you how to Select by Attributes using ArcMap 10.2. By this we mean how to query your attribute tables for particular information on them. We have a point layer consisting of some buildings represented as points. We want to query the attribute table to know which buildings are in a bad repair state and are blue in colour.
Procedure
1. Right Click on the layer > open attribute table.

bn

2. Observe the attribute table contains data of the results of a building state of repair survey. We want to know which point satisfies a selection criteria on this table. Criteria – The Repair_ State is bad and Building_col is blue

hj

3. On the main menu, Click Selection>Select by Attributes.

fgi

4. The Select by Attributes dialog box will come up. In this box, we will select the field where the unique values we are querying for lies. We make a common sql statement to execute the query. In green box are the fields we are querying and the unique values are ‘bad’ and ‘blue’(see red box)

ffg2

5. Right Click on the layer>open attribute table. The point(s) that have the attributes that meet the criteria of the selection will be highlighted on the attribute table.(highlighted in blue)

ffg3

Video presentation link

Hope you are already getting some practice. Feel free to send your comments.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s