Module 7 Flashcards Preview

Y3 T2 Geography 322 > Module 7 > Flashcards

Flashcards in Module 7 Deck (18)
Loading flashcards...
1
Q

Joined Vs. Related

A

Join:▪ separate tables can be joined based on the unique identifier, which is shared between each table – in this case the two tables are combined into a new table that contains all of the information of the two separate tables
-▪ joins are very useful for incorporating standalone tables into a GIS analysis

Related:▪ separate tables can be related based on the unique identifier, such that when you select a specific feature in one table, the associated records in the 2nd table are also selected

2
Q

Standalone Tables

A

▪ standalone tables often do not have explicit spatial coordinate variables, so they cannot be mapped - they contain attribute data but no feature data

3
Q

direction

A

.you must correctly choose which table to add the 2nd table to

▪ the destination table is the table that will accept the additional attribute data from the other table
▪ the source table is the table containing the information you want to add
-it is important that the destination table contain spatial features so that the newly joined data can be mapped – if you make a standalone table the destination table, there will be no way to map the data

4
Q

many types of relationships between tables, and these are defined by their cardinality: 4 describe each

A
  1. one-to-one cardinality
    - one record in table 1 corresponds with 1 record in table 2 (eg, one table contains census tracts, the other contains unemployment rate)
  2. one-to-many cardinality
    - for every record in table 1, there are several records in table 2 (eg, one table contains all of the national parks in Canada, the other table contains individual lakes found in national parks – each national park may have more than 1 lake)
  3. many-to-one cardinality
    - each record in the source table could fit into more than one record in the destination table (eg, a table listing the properties of major highways is joined to a table containing city boundaries)
  4. many-to-many cardinality
    - several records in 1 table can be related to many records in another table (eg, different soil types can grow more than one type of crop, and different crops can grow in different soil types)
5
Q

Rule of Joining****

A

there must be one and only one record in the source table for each record in the destination table
-this rule is broken by the “many to one cardinality”

6
Q

we can’t use a join in a many-to-one relationship, but we can use a ______

many-to-many relationship cannot be joined – the most effective way would be to establish several…

A

relate

many-to-one relationships from the data and then create multiple relates to bring them all together

7
Q

DBMS

A

tool to find the aspatial data and where it is stored

8
Q

the ______ in ArcGIS is the primary tool

for database management

A

Catalog

9
Q

3 main Steps in using a Data Management System

A
  1. Data Entry
  2. Verification(checking data vs. original source)
  3. Updates
10
Q

multiple membership

A

where an individual can

exist in more than one group and potentially at more than one level

11
Q

______ data structure cannot handle multiple membership data connections

A

hierarichal

12
Q

relational databases

A

relational databases are one of the paradigm shifts
that redefined how DBMS’s could be built
▪ the relational model uses many tables that contain
unique levels of attribute data, but the individuals in
the tables are linked by some unique identifier

13
Q

GIS Summarize function

A

▪ the summarize function is useful for performing

statistical analysis on groups of data

14
Q

in a raster the count field in the atribute table is..

A

a count field that displays how many raster cells are of each code – the count field can be thought of as an area field as well, since you know the cell dimensions (eg, 30 x 30 m)

15
Q

clip and erase tools

A

clip would keep everything within the clip shape

erase would erase everything within the shape

16
Q

object-oriented database

A

the object-oriented database allows the user to specify both the structure of the objects and the processes that can be applied to them, such that:
▪ the ‘state’ of an object is the set of values of its attributes, and the ‘behaviour’ represents how those attributes might change

.object-oriented databases are potentially more appropriate for geographic data
than the relational model, since they allow for the modeling of complex, real-world
objects, does not distinguish between spatial and attribute data, and is appropriate
for graphics operations

17
Q

The ______ database type is the best for GIS because…3

A

.object-oriented databases are potentially more appropriate for geographic data
than the relational model, since they allow for the modeling of complex, real-world
objects, does not distinguish between spatial and attribute data, and is appropriate
for graphics operations

– the packaging together of the description of state and behaviour
in each object
– the ability to re-use some or all of the characteristics of one object
in another object
– the specific implementation of operations like draw, create, or
delete for each object

18
Q

faults of the object oriented databases

A

▪ since many geographic ideal have implicit uncertainty and the spatial objects
that we require our databases to model are often the products of interpretation
or generalizations, it can be difficult to represent the world as rigidly bounded
objects
▪ the methods of creating object-oriented models are in their infancy and much
work is need to simply implement them, either practically or theoretically