15 - Spatial and attribute queries

Question 1

SQL

Answer 1

Structured query language

Question 2

SQL def

Answer 2

A data query language designed for the manipulation of relational databases
- command language used to communicate with the database (Microsoft access)

Question 3

Boolean expression

Answer 3

Contains 2 operands and a logical operator.

Question 4

Spatial querying def

Answer 4

the process of retrieving a data subset from a layer by working directly with feature geometries (there is a locational component)

Question 5

Solving a site selection problem

Answer 5

Step 1 - Select by attributes
Step 2 - Select by attributes
Step 3 - select by location
Step 4 - Select by location
Step 5 - Clip sites using buffer
Step 6 - Recalculate geometry

Question 6

Boolean connectors

Answer 6

A compound statement with separate expressions usually applies to multiple rasters. Eg: ([slope] = 2) AND ([aspect] = 1)