GIS Data and Database Design

Autumn 2008

 

Home

Course Calendar

Syllabus

Sherman Lab and Technical Resources

GIS certificate Program

Resources

Assignment Dropbox

 

 

 

Course Calendar  (to be updated weekly)

Timeline Starting Date Exercise Lecture/Discussion Reading
Week 1 Oct 6 Working with vector, raster, and CAD data in a personal geodatabase

Orientation& GIS Overview – hardware and software components, spatial data types, and other considerations. 

Additional/optional Readings provided

Week 2 Oct 13 Tabular joins, spatial selections, and link to data in RDBMS Introduction to database fundamentals and ESRI/GIS data types

Additional/optional Readings provided

Week 3 Oct 20 Virtual Campus Course work

Geodatabase Design Considerations

Harmon, Anderson Chapter 8: “… Selecting Hardware and Software” Chapter 2: “Before Design: Needs Assessment and Requirements Analysis”

Understanding Coordinate Management in the Geodatabase, ESRI White paper (PDF)
Week 4 Oct 27 Creating a Geodatabase and Loading datasets Creating the Geodatabase Part 1

Harmon, Anderson text… Chapter 4 (pages 69-111): “Designing Spatial Data” and

Chapter 5: “Design Issues for Attribute Data”  

 

 

Additional/optional Readings provided
Week 5 Nov 3 Very Personal Geodatabase  

Inital Project Ideas  

Harmon, Anderson text… Read Chapter 3: “Designing the GIS Database Schema”
Week 6 Nov 17 Site Selection GIS Data and Analysis Harmon, Anderson text… Read Chapter 7: “Implementation: Data Development and Conversion”
Week 7 Nov 24 Bad Maps! Map1, Map2, Map3, Map4 No Lecture

Tonight’s focus is on identifying project interests

Project Team Matrix  

Harmon, Anderson text… Read Chapter 6: “Remotely Sensed Data as Background Layers and Data Sources”

Week 8 Dec 1 Georeferencing Imagery and Raster Data

Prepare for Presentations

 

Review: GeoDatabase design,  feature datasets and subclasses

Bad Maps! Presentations

Remote sensing

Data Model examples

 

Week 9 Dec 8 Bad Maps! Presentations

Topology Exercise

Topology Lecture

Editing Demo

Harmon, Anderson text… Read Chapter 6: “Remotely Sensed Data as Background Layers and Data Sources”

 

Additional/optional Readings provided

Week 10 Dec 15 Fall Quarter Wrap-up

10 - 15 Minute Project Presentations

none