Course Webpage: http://web.pdx.edu/~jduh/courses/geog475f10/index.htm
(Or go to http://web.pdx.edu/~jduh/ and select "Courses-> GEOG 4/575(F10)")
Instructor: Geoffrey Duh (jduh@pdx.edu), Office: CH 424J, Ph: 503-725-3159, Office hours: Mon 1-3 pm
Course emailing list: gisdb@lists.pdx.edu
Lectures/Lab: Tuesday and Thursday 18:00-19:50 in CH 418 (Tue) and CH469 (Thu). Thursdays are scheduled for labs. Lab attendance is mandatory.
Pre-course survey: http://survey.oit.pdx.edu/ss/wsb.dll/jduh/gisdb.htm
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 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. 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 textbook for this course is "Introduction to GIS 5th Edition" (Chang 2009, ISBN-10: 007729436X). The optional textbook is Designing Geodatabases (Arctur and Zeiler 2004, ISBN: 9781589480216). These books are available at the Portland State Bookstore. We all also use ESRI's ArcGIS 9: Building a Geodatabase (Building_a_Geodatabase.pdf) and Geodatabase Workbook (GeodatabaseWorkbook.pdf). Digital copies of these books can be found in I:\Students\Data\GIS\ArcGIS Documentation\ArcGIS9.1_documentation\ESRI_Library\ Managing_data_with_ArcGIS. The pdf file of Bian 2007 (week 3 reading) is available in I:\Students\Instructors\Geoffrey_Duh\GEOG4575\Readings.
Additional references (These pdf files can be found in I:\Students\Data\GIS\ArcGIS Documentation\ArcGIS9.1_documentation\ESRI_Library\)
● 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.
|
Class Participation |
10% |
|
Lab Assignments |
30% |
|
Midterm Exam |
20% |
|
Project Proposal |
10% |
|
Group Project |
30% |
Class Participation (10%):
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.
All students are required to select a topic from a list provided by the instructor (see page 4 of the syllabus) and give a 10 minutes presentation on that topic to the class. You must prepare a powerpoint presentation, 4 discussion/quiz questions and their answers. Students who are responsible for the week's topics must email the questions to the course mailing list and the questions and their answers to the instructor by 5pm the day before the class (i.e., on Monday); provide the powerpoint file to the instructor at least 30 minutes before the class begins. The presentation should be mainly based on the assigned readings. I strongly encourage you to put additional relevant materials you find on the internet or from other references that might help students understand the topic.
During the lab sessions on Thursdays in CH469 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. CH 475, CH 1, CH 324, and Broadway Computer Lab all have ArcGIS on the computers. Lab exercise data are available in the CD that comes with the textbook and in: I:\Students\Instructors\Geoffrey_Duh\GEOG4575\Chang_5e.
Midterm Exam (20%):
There will be one in-class, closed-book midterm exam and no final exam. Unscheduled in-class quizzes will be administered without notifications. Results of these quizzes will be counted toward class participation.
Group Projects (40%):
Class will be divided into groups of 2 to 3 students. Each group will work on a GIS database project of its own choice or assigned by the instructor. Each group must submit a project proposal in the 5th week and a final report by the scheduled final presentation time. During the scheduled final presentation time students will present their work to the class.
Project Proposal Guideline
Term projects should involve the design and implementation of a GIS database for existing or potential GIS applications. Each group is required to email a typed project outline to jduh@pdx.edu by 5 pm on Oct 26 (Tuesday). Your final term project will be carried out following the project outline. The outline should include the following information.
Includes the essential information described in the proposal, data sets used, the analyses performed, and display the maps and tabular output derived from the analyses (see presentation rubric). The quality of your project is decided by the cohesiveness and logic of your arguments, the clarity of your objectives, and the appropriateness of the methods and techniques. The complexity and comprehensiveness of your project will not be major criteria in judging the quality of your project.
Click here for the information on the requests for academic accommodation and the policy on academic honesty.
Student Discussion Topics
|
Week |
Tuesday |
Presenters |
|
2 Oct 5 |
Primary & Foreign Keys Database Normalization Boolean Operators and Venn Diagram |
- - Jena Ferrarese |
|
3 Oct 12 |
GIS Data Topology ESRI's Coverage Model ESRI's Geodatabase Data Models |
- Wendy Berg Anderson Folts |
|
4 Oct 19 |
Elements of Raster Data Raster Data Structure Raster (Image) Data Compression ArcGIS 10 Mosaic Dataset |
- Dustin Vandehey - Drew Swayne |
|
5 Oct 26 |
Vector Overlay Methods & Slivers Vector map manipulation tools Raster operations (local, neighborhood, zonal) |
- - Larissa Butler |
|
6 Nov 2 |
Location Errors Topological Errors Database schema |
Mele Sax-Barnett Victor Vigil Nic Turinski |
|
7 Nov 9 |
Affine Transformation Root Mean Squared Errors Resampling of Pixel Values |
- Scott Swenson John Marshall |
|
8 Nov 16 |
Geocoding - Address Matching Routes and events in Dynamic Segmentation ESRI Geometric network Temporal Data in ArcGIS |
- - Nicholas Jones Adam Mosbrucker |
|
9 Nov 23 |
Links and junctions in Network Analysis Turn Table in Network Analysis |
Chris Brown - |
Course Schedule & Readings
(Chang refers to the Chang 2009 textbook. ESRI refers to ArcGIS 9: Building a Geodatabase.)
|
Week |
Tuesday |
Thursday Labs |
|
1 Sep 28, Sep 30 |
Course
Overview ( Slides ) |
Computer Terminology and SQL (ESRI Ch 2) Lab 1: SQL, MS Access & Map Projection (Due Oct 7 before class) |
|
2 Oct 5, Oct 7 |
Attribute Data Input and Management (Chang Ch 8, 10) Slides Subtypes and Attribute Domains (ESRI Ch 5, 6) |
Lab 2: Attribute Data Manipulation (Due Oct 14 before class) |
|
3 Oct 12, Oct 14 |
Vector Data Models (Bian 2007; Chang Ch 3, 5) Slides |
Lab 3: Data File and Geodatabase Structures (Due Oct 21 before class) |
|
4 Oct 19, Oct 21 |
Raster Data (Chang Ch 4, ESRI Ch 12) Slides |
Lab 4: Raster and Terrain Data Manipulation (Due Oct 28 before class) |
|
5 Oct 26, Oct 28 |
GIS Data Analysis (Chang Ch 11, 12) Slides Topology (ESRI Ch 4) Slides Group Proposal Due @ 5pm |
Lab 5: Spatial Data Editing and Topology (Due Nov 4 before class) |
|
6 Nov 2, Nov 4 |
Spatial Data Editing (Chang Ch 7) Slides Geodatabase Design and Metadata (Arctur & Zeiler Ch 1) Slides Midterm Exam |
Lab 6: Geodatabase Data Model and Schema - ArcMarine and geometric Transformation (Due Nov 18 before class) |
|
7 Nov 9, Nov 11 |
Geometric Transformation (Chang Ch 6) Slides |
Veterans Day |
|
8 Nov 16, Nov 18 |
Geocoding & Dynamic Segmentation (Chang Ch 16) Geometric Networks (ESRI Ch 7) Slides |
Lab 7: Network and Dynamic Segmentation, Network Analyst (Due Nov 30 before class) |
|
Nov 23, Nov 25 |
Path Analysis & Network Applications (Chang Ch 17) Slides |
Thanksgiving - University Closed |
|
10 Nov 30, Dec 2 |
Student Presentations |
|
|
Dec 7 (Tue) |
Student
Presentations During Scheduled Exam Time |
|