VectorAnalysis

What are query expressions used for in GIS?

To select a subset of features and table records.

What language is used for writing query expressions in GIS?

SQL (Structured Query Language).

What does the SQL function max([field1!, !field2!, !field3!]) do?

Calculates the maximum value for each record from a list of fields.

How do you calculate the sum for each record using SQL?

Using the expression sum([!field1!, !field2!, !field3!]).

What are logical patterns in Python used for in GIS?

To classify fields based on values using if, else, and elif statements.

How is the 'LIKE' operator used in SQL?

To find strings that match a specified pattern.

What does the SQL expression UPPER(STATE_NAME) = 'RHODE ISLAND' accomplish?

Selects states with a name matching 'Rhode Island' regardless of case.

What is the purpose of the Dissolve function in vector data analysis?

To combine like features within a data layer by removing common boundaries.

What does the 'Clip' method do in vector overlay?

Cuts one layer using the outline of another layer, discarding data outside the boundary.

What is the difference between INTERSECTION and UNION in vector overlays?

INTERSECTION combines data only within a bounding area; UNION includes all data from both layers.