spatial database structure Flashcards

1
Q

database

A

structured set of data that has a connection or relationship to each other
database may contain both non-spatial and spatial data
GIS directly deals with spatial data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

advantages of digital databases

A

multiple access methods
data sharing more efficient
redundancy and costs mininmizes
central control and maintenance
efficient analysis and production of info for decision mkaing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

data relationships

A

draw pic slide 7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

relational (tabular) db model

A

most common
data is stored in and relationships are created between one or more flat files or tables where each pair of tables has a field in common or key
data extracted using SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

geodatabase model

A

container of db files
data model uses an object-relational arrangement of the data
2 parts: data types and database schema
types: feature classes, raster datasets and tables
db schema contains info about objects and their relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

querying the db

A

attributes (non-spatial)
location (spatial)
graphics (geometry)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

GIS data input sources

A

keyboard entry: entering values into tables/templates
manual digitizing: digitizing tablet
automatic digitizing: large format scanner
data transfer: data from GPS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

maps present unique problems

A

deformation
generalization
artifical errors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

quality and accuracy standards

A

data interoperability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

data source 1: GPS

A

constellation of earth orbiting satellites maintained by the USA for the purpose of defining geographic positions on and above the surface of the earth

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

3 segments of GPS

A

space - satellite
control - base stations
user - gps receivers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

challenges with gps recevier

A

selective availability
multipath errors
dilution or precision

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

selective avail

A

us dept of defense distort the satellite time signal reducing positional accuracies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

multipath errors

A

signals coming directly from the satellite and reflected off other objects interfere and create location errors

17
Q

dilution of precision

A

geometry of satellites in the horizon are not equally spread out but clustered

18
Q

data source 2: canadian census

A

census table
census geog

19
Q

data source 3: open data

A

avail on web

20
Q

data interoperability

A

deals with seamless interactions b/w people, data and systems
goal is to share, preserve and manage data, info and knowledge

21
Q

metadata is needed to

A

identify geospatial resources
exchange
manipulate
catalouge

22
Q

stylesheets

A

used to format the metadata
determine the layout and other style info aboht the data

23
Q

documenting data quality

A

location accuracy and precision
attribute accuracy and precision
logical consistency
completeness
data currency
accessibility