Last updated April 10, 2022

Status: #📥/🟩
Tags: GEOG 150 Inputs #archivedCards/geog150 Links: ' Classes

' GEOG 150 Week 7

Class:: geog150

Notes

Exploring GIS: Database Management

• So much data produced
  • Results in information overload, anxiety, and fatigue
    • Data management is a coping strategy

Database ?

• Structured set of data that has some connection or relationship to eachother
  • May contain non-spatial or spatial data
    • GIS is spatial
  • Easily sharable and manageable
  • Metadata

Relational (tabular) database model ?

• Stored in, relationships created between 1+ flat files/tables where each pair has a field in common, or “key”
• Data extracted by structured query language (SQL)

Records ;; unit that data is specific to

Fields ;; also columns, attribute categories

Cells ;; where individual values of a record/field are stored

Headings ;; labels for columns

Do spatial data contain errors ? All spatial data contains some errors. We must be aware of errors, make necessary connections

Type of location/attribute errors ?

• Impossible values
• Extreme values/outliers
• Internal consistency
• Scatter plots

Querying database (3 values) ? Use SQL to extract values from statements

• Attributes (non-spatial)
• Location (spatial)
• Graphics (spatial)

Thoughts/Questions

Backlinks

1

list from & and !outgoing(&)

Created:: 2021-10-30 16:10