what does an attribute table store
data of a spatial feature class
what do standalone tables store
tabular data from any source e.x. excel, text files, csv files
–> HIDDEN because without spatial reference
XY point data in arcgis what is x what is y
X is longitude
Y is latitude
what is boolean operator (with two examples)
logical operator used in the formulation of boolean expression (so 1/2/3/etc= true, 0 = false)
–> AND (specific combo of conditions –> intersect operation)
–> OR (list of alternative conditions)
what is not boolean connector
AT LEAST
Selection by Location in ArcGIS is designed for
SPATIAL DATA QUERY
Selection by Attribute in ArcGIS is designed for
ATTRIBUTE DATA QUERY
boolean operator for UNION sets
OR
target layer contains…
features to be selected
what are rows and what are columns called
rows = records, columns = fields
when joining tables, where does additional info go
TARGET table
when naming fields in excel for ARCGIS what are the rules
must start with a letter, no spaces or special characters, generally 10 units, ONLY LETTERS NUMBERS AND UNDERSCORES
what is a union operator
analysis tool to perform overlay analysis on feature classes
why do you need to focus on cardinality in table joins?
because based on direction of join and information, changes whether one-to-one join or many-to-one join or one-to-many join.
what is a rule for joining tables
each record in the target table must match one AND ONLY ONE record in the join table (true for one-to-one and many-to-one cardinality but not one-to-many)
how to perform joins
fields to join data MUST BE SAME DATA TYPE e.x. text to text, long to long, short to short, or float to float
what are short and long data types
integers
what are float and double data types
decimal values
Summary of cardinality types
One-to-one
* States to Governors.
* Countries to capitals.
One-to-many
* States to cities.
* Districts to schools.
(Target table on the left)
Many to one
* Cities to states.
* Schools to districts.
Many-to-many
* Students to classes.
* Stores to customers.
–> In evaluating cardinality, always put the target table first.
what is the art and science of making maps
cartography
what is CMYK model used for AND WARNING
PRINTING color maps, not perfect match between screen and paper
what shoes larger geographic area? small or large map scale
SMALL MAP SCALE = LARGER GEO AREA
on what map scale are cities shown as points
a VERY SMALL map scale
what is largest map scale –> 1:5000, 1:12000, 1:1000000, 1:24000
1:5000 is LARGEST