How to use the Query Builder to filter data in ArcGIS

How to use the Query Builder in ArcGIS to filter data when data display check data display check the data situation Query Builder Use function description filtered results

How to use the Query Builder to filter data in ArcGIS

Description: The ArcGIS I use is version 10.4.
Scene: I use someone else's. SHP data mapping found that there is a "township _point.shp" document shows Township, town, street three kinds of data, but I do not want to show street data, how to do it, the following is the resolution process. data display when no tick is selected

data display when checked

look at the data .

Right key

Property List Contents

You can see that the two letters in the back of the street in "Pyname" are "JD."
If the next two letters are "JD" filtered out, it solves the problem.
The following is the use of the workaround query Builder

1. Double-click "Township _point"
2. Select the definition query
3. Click on the Query Builder
4. Fill in the box under the Where Statement filter criteria

SUBSTRING ("Pyname", Char_length ("Pyname") -1,2) <> ' JD '

This condition means that the last two digits of the phonetic name are not "JD" data.

Step diagram:

If you want to know what functions you can use, look at the following figure:
function Description

In substring (string,start,length) string is the string you want to process, start is the starting position, starting from 1, so the last two bits are the Char_length function to take the string length and then subtract 1, not minus 2,length is length. Filtered Results