Lecture & Lab: T R 16:00-17:50 in 418 (T) and 469 (R)
Cramer Hall
Instructor:
Email: jduh@pdx.edu
Course webpage: http://web.pdx.edu/~jduh (Select
“Courses-> GEOG 4/575” from the pull-down menu.)
Office: 424J Cramer Hall
Office Hours: M 1-3, W 1-2
Course mailing list: gisdb_f5@lists.pdx.edu
Course Objectives:
GEOG 475/575 covers the theory and methods of designing, compiling, and managing GIS databases that can be used in applications ranging from natural resources management, parcel and cadastral mapping, transportation and location analyses, census and land survey, and cartographic representations, etc. Students will learn in lectures several basic and advanced spatial data automation and integration methods, including the use of vector layer editors, spatial data manipulation tools, and database management tools, to build a GIS database through practical components of the course. After completing the course, students will be able to design, develop, and manage a GIS database and understand the critical issues of its design and operation for their research projects or most GIS data management tasks.
The required textbooks for this course are "Introduction to GIS 3nd Edition"
(Chang 2005) and ArcGIS
9: Building a Geodatabase (ESRI 2004). These books are available at the Portland State Bookstore. A digital copy of ESRI’s ArcGIS
9: Building a Geodatabase can be found at
I:\Students\data\GIS\ArcGIS9.1_documentation\ESRI_Library\
Managing_data_with_ArcGIS\ Building_a_Geodatabase.pdf.
Additional references (These pdf files can be found in I:\Students\data\GIS\ArcGIS9.1_documentation\ESRI_Library\)
·
Weblinks referenced in Chang 2005, 3rd
Edition.
·
ArcGIS Geodatabase Topology Rules
(poster).
·
ArcGIS
9 Geodatabase Workbook
(Managing_data_with_ArcGIS\GeodatabaseWorkbook.pdf)
·
ArcGIS
3D-Analyst (& ArcScene).
(ArcGIS_Extensions\Using_3D_Analyst.pdf)
·
Getting
Started with ArcIMS (ArcIMS\ Getting_Started_with_ArcIMS.pdf)
·
Understanding
ArcSDE (Managing_data_with_ArcGIS\
Understanding_ArcSDE.pdf)
The lecture component of this course consists of discussions of the readings and therefore you should have read the material before class. Students are expected to come to class ready to be active participants in the discussion.
During the lab sessions on
Thursdays you will do practical exercises on the computers. If you do not
finish the labs during the assigned time periods the lab also has open hours.
The practical exercises provide a way to acquire skills using MicroSoft Access, ArcGIS, and other software packages and to apply the course
concepts to real data. NH 437/448, CH 1/322, and Broadway Computer Lab
all have ArcGIS on the computers. The labs are open when classes are not
scheduled in these rooms and the NH labs are open on weekends. Broadway
Computer Lab opens 24-7. CH 475 is also open to students in this class and
the computers have MS Access and ArcGIS.
Lab exercise data are
available in: I:\Students\Instructors\Geoffrey_Duh\Chang_3e.
Group Projects:
Class will be
divided into five groups. Each group will work on a GIS database project of its
own choice or assigned by the instructor. Each group should submit a project
proposal on the fifth week and a final report by the scheduled final exam time.
During the scheduled final examine time, students will present their work to
the class. Details of group projects will be announced later in class.
Lab
Assignments 25%
Midterm Exam 15%
Project Proposal 10%
Participation 10%
Final Take-home Exam 15%
Project 25%
Attendance
to this course is mandatory. If you miss more than two class periods then you
will be penalized five percent of your final grade per absence. PLEASE DO NOT
MISS CLASS. You are expected to take part in the discussions and if you are not
in class then you cannot. If you are repeatedly late you will be given an
absence. The labs are due by Thursday before class the week
after they are assigned. You can hand them in class or put them in my mailbox in CH424.
Schedule of Lectures,
|
Date |
Tuesday (meet
in CH 418) |
Thursday (meet in CH 469) |
|
Sep 27, 29 |
Course Overview |
Computer Terminology and SQL (ESRI Ch 2) (Slides) Lab 0 (Optional): Chang Ch 1 Tasks. |
|
Oct 4, 6 |
Attribute Data Input and Management (Chang Ch 9, 11) (Slides) |
Subtypes and Attribute Domains (ESRI Ch 5, 6) (Slides) |
|
Oct 11, 13 |
Vector Data Models (Chang Ch 3, 4) (Slides)
|
|
|
Oct 18, 20 |
Spatial Data Editing (Chang Ch 8) (Slides) Overview of Group Project |
Topology (ESRI Ch 4) |
|
Oct 25, 27 |
Raster Data (Chang Ch 5, ESRI 12) (Slides) |
Terrain Mapping and Analysis (Ch 14) Lab 5: Raster
and Terrain Data Manipulation |
|
Nov 1, 3 |
GIS Data
Analysis (Chang Ch 12, 13) (Slides) Midterm Exam |
GIS Models and Modeling (Chang Ch 19) (see Nov 1 slides) |
|
Nov 8, 10 |
Geodatabase Design and Metadata (Arctur & Zeiler Ch 1) (Slides) |
|
|
Nov 15, 17 |
Geocoding & Dynamic Segmentation (Chang Ch 17) (Slides) |
Geometric Networks (ESRI Ch 7) |
|
Nov 22, 24 |
Path
Analysis & Network Applications (Chang Ch18) (Slides) |
Thanksgiving-No Class |
|
Nov 29, Dec 1 |
Internet GIS Database (Slides)
( |
Students work on group projects in CH 469. |
|
Final Exam |
Student Presentations During Scheduled Exam Time |
Final Exam Due on Dec 8 by 5 PM |
