SOC 4650/5650 - Definition Query Example

Workflow for executing definition queries in ArcGIS Pro. Created by Branson Fox.

Transcript

1. Definition Queries in ArcGIS Pro
2. When you have data that you would like to filter by some criteria, you can use a definition query in ArcGIS Pro. It is useful to start by looking at the attribute table.
3. In this example, we will filter for Schools in the Zipcode 65101.
4. Navigate to the definition query tab in properties.
5. Navigate to the definition query tab in properties.
6. Click add clause.
7. Select the variable you want to filter by.
8. Select the relationship of this field to a value. In this case, we select “is Equal to”
9. Select the value you would like the variable to be equal to in this case.
10. You can add multiple clauses to the same data, but for now we’ll just use one. Click ok when you’re finished.
11. The data are now filtered to match your criteria.
12. Here is another example using Fire Stations. We will filter for Fire Stations in Jefferson City.
13. Navigate to definition query.
14. Add clause.
15. “City is Equal to Jefferson City”
16. Click ok.
17. The data are now filtered to your criteria.
18. We’ll go through another example, and explain a common error that occurs. Imagine you want to filter for Trees after the year 2000.
19. When you get to the definition query, you may realize that there is no option for “is Greater Than or Equal to”
20. The reason for this is because the year variable in this case is a text value rather than numeric. We will eventually discuss ways to solve this issue.
21. Here is one more example that shows what a definition query for numeric data looks like.
22. In this example, we will filter for Greenways that are greater than 0 feet wide. (0 likely indicates greenways that haven’t been developed yet)
23. Navigate to defintion query.
24. As you will notice, the options for your definition query are different because these data are numeric.
25. In this case, we can filter so that the Width is greater than 0.
26. And now our data are filtered by our definition query.