Introduction to Desktop GIS u Review of Database

Introduction to Desktop GIS u Review of Database Data Base Components • Records (row) • Fields (column) • Keys - query fields (key column) Three Classic Models The style of describing and manipulating the data in the data base. • Hierarchical • Network • Relational

Introduction to Desktop GIS u Relational (Tabular) Database Model A design used in database systems in which relationships are created between one or more flat files or tables based on the idea that each pair of tables has a field in common. TABLE 1 ITEM NUMBER 20 21 TABLE 2 TYPE VO CL ARTIST The Carpenters Boston Pops FORMAT T C TABLE 3 STORE ITEM NUMBER Music Stax 21 Record World 20 TITLE The Singles 1969 -73 Pops in Space ARTIST The Carpenters Boston Pops PURCHASE DATE 91 89 RECORDING DATE 73 80 COST 16. 99 8. 99 Borrowed from http: //www. wiley. co. uk/college/busin/icmis/oakman/outline/chap 08/slides/relation. htm

Introduction to Desktop GIS u One to One Relational Database ID zone 11 residential 12 industrial ID owner 11 Smith 12 White ID zone 11 residential Smith 12 industrial White owner

Introduction to Desktop GIS u One to Many Relational Database owner zone Smith residential White industrial owner Parcel area (sq km) White 1. 5 Smith 0. 6 Smith 0. 25 owner White Smith Parcel area (sq km) zone industrial 1. 5 0. 6 residential 0. 25 residential

Introduction to Desktop GIS u Database Management in Arc. View • One to One/Many Relational Database • Query and Analysis of the database Since geographical features and their attributes are linked, you can perform queries and analysis on either the "map-side" or the "table-side”. For instance you can select rows in a table and highlight the related features in the view. By performing a selection that matches a special condition you can analyze your database. Additionally Arc. View allows you to define new fields in an existing table and calculate data for it from the old fields.

Introduction to Desktop GIS u Review Elements of a Map Theme Title Legend Scale Source North Arrow, etc. u Map Resources in UCB Before you start creating your own maps it’s good to get an idea of different map design styles. Get some inspiration while browsing the UCB Library Collections in Maps and Cartography (www. lib. berkeley. edu/eart/mapcollections. html) or other digital map libraries on the web.