What do attribute tables store
data associated with a spatial feature class
what do standalone tables store
tabular data from any source: excel, text files, CSV files, and data base files
what is x and y in arc GIS
X is Longitude and Y is Latitude
how to correctly name a field in excel for arcGIS
what is a boolean operator
logical operator used in the formulation of a boolean expression
examples of boolean operators
AND –> combo of conditions (A and B)
OR –> specifies list of alternative conditions ( A OR B)
XOR –> mutually exclusive
NOT
what is NOT boolean connector
AT LEAST
what is selection by location used for
spatial data query
what is selection by attribute used for
attribute data query
when is boolean connector AND used for
INTERSECT operation on sets ( see paper)
when is boolean connector OR used
UNION operation on setshat
what does target layer contain
FEATURES to be selectedw
what does source layer contain
contains the features being compared to (where query results will be found in relation to)
what are rows called in tables
RECORDS (and represent an individual geographic feature)
what are columns called in tables
FIELDS
where does information go in a JOIN
the TARGET table recieves the additional information
what is a rule with join
each record in the target tables must match ONE and ONLY ONE record in the join table
what cardinality exist for joins
one-to-one and many-to-one cardinality (NOT ONE-TO-MANY!)
example of attribute queries
test TABLE VALUES –> e.x. populations greater than 100,000
example of spatial queries
test spatial relationships –> e.x. parcels that are in a flood plain
what is an interactive query
the USER visually identifies the desired features in a map or records in a table
what are arithmetic operators
+ - x / ^ (act on numbers)
what are logical operators)
> < = _< _> (test conditions and return true or false)
what are spatial operators
intersect contains proximity –> test spatial relationships between features