queries Flashcards
query
a tool for data analysis used in data exploration to find patterns, extract features from a map
interactive query
user looks at a map or table and manually selects desired features
attribute query
uses values in the attribute table to test a condition
spatial query
uses information on how features from different layers are related
logical operators
used in attribute queries to test specified conditions, <,>,=
SQL
structured query language, a standard language in computing with specific syntax requirements
Boolean operators
used to evaluate a pair of true false conditions, and, or, not, Xor
like or contains operators
allows you to search for partial matches where data may be inconsistent
ex: all of the Smiths in a field of first and last names where it may or may not be capitalized
spatial operators
test spatial relationships, such as contains, intersects, within, and within a distance
buffers
type of spatial query used to delineate areas that fall within a certain distance of a set of features
selection type parameter
controls what happens to an existing selection when a new query is performed on a layer: add to current selection, new selection, remove from current selection, select subset from current selection, switch current selection
make feature layer tool
creates a new layer from the query
definition query
performed in the properties window, makes the layer only show the selection
export
used to make permanent copies of a selection breaking the link to the original feature class
target layers
features that will be selected by the query
