38/42:376 GIS II: Spatial Data Management and Analysis
Instructor: Lecture, Dr. Dion J. Wiseman
Office: Brodie Room 4-07
Office Hours: Monday, Wednesday, Friday; 11 am – 12 pm; or by Appointment
Phone: 727-9774
Email: wiseman@brandonu.ca
Course Resources
Course Website: https://people.brandonu.ca/wiseman/courses/gis2/
Required Text: Introduction to Geographic Information Systems, 9th ed. 2019, Chang.
Optional Text: Cartography: Thematic Map Design, 6th ed. 2009, Dent, et al.
Note: Both texts will also be used for 38/42:376, GIS II: Spatial Data Management and Analysis. Copies of both texts will be available on reserve in the main library. 2) An earlier edition of either text is acceptable.
Course Description
This course is designed as an intermediate level GIS course for students who plan to manage and analyze geospatial databases in their chosen field of study or future careers. The objectives are to provide you with a solid theoretical and applied background in geospatial database management and analysis that transcends any particular software application. The lecture component of the course will focus on theoretical concepts related to building, managing, and analyzing geospatial databases by addressing the lecture topics outlined below. The lab component of the course will provide practical experience with ArcGIS Desktop 10, ArcPro, and various extensions that provide additional functionality.
By the end of this course you will have acquired the theoretical background and applied skills to work as a GIS technician and pursue advanced training in specific applications of GIS (e.g. network, weighted overlay, or hydrologic analysis, etc.) and technologies for collecting and creating geospatial data (e.g. Total Station, RTK GPS, RPAS).
The prerequisite for this course is GIS I (38/42:286). Additional readings and/or assignments may be required for those who have not completed the prerequisite. This course is the prerequisite for 38/42:477/677 Advanced Geomatics.
Grading Scheme
| Midterm | 20/30%* | > 90% | A+ | 70-72% | B- |
| Final | 20/30%* | 85-89% | A | 67-69% | C+ |
| Lab Assignments | 25% | 80-84% | A- | 63-66% | C |
| Lab Midterm | 10/15%* | 77-79% | B+ | 60-62% | C- |
| Lab Final | 10/15%* | 73-76% | B | 50-59% | D |
| Bonus (optional) | 5% | < 50% | F | ||
| Total | 100% | * variably weighted | |||
Tentative Course Outline
1. Spatial Data Representation, the Object-based Model and Geodatabases (Geodatabase Demo)
- Review of Raster /Vector Models
- Georelational vs. Object-based
- The Geodatabase Model
- Subtypes, Topology Rules, Attribute Domains
- Raster Data Catalogues
- Terrain Datasets
2. Managing Geospatial Databases (Tables Demo)
- Functions of a DBMS
- Tables and Data Relations
- Types of Relations – Relate vs. Join
- Attribute-based Operations
3. Exploratory Data Analysis
- Descriptive Methods
- Query by Attribute & Location
- Relational Algebra
- Boolean Logic
- Querying Rasters
4. Vector Data Analysis (Simpson’s Vector Demo)
- Buffers and Setbacks, Applications of
- Map Overlay: Union vs. Intersection
- Other Vector Tools
5. Raster Data Analysis (Raster Cougar Demo)
- Basic Raster Operations
- Environment Settings Local Operations
- Local, Focal, Zonal Operations
- Global Operations
MIDTERM EXAM – TUESDAY, MARCH 2
6. Surface Representation & Analysis (Interpolation Demo)
- TINS vs. DEMS
- Spatial Interpolation
- Global vs. Local, Exact vs. Inexact
- Interpolation Algorithms
- Kriging and Semivariograms
- Surfaces and Isolines
- Density Surfaces
7. Point Pattern Analysis
- Descriptive Measures
- Nearest Neighbour
- Spatial Autocorrelation
8. Network Analysis
- Components of a Network
- Creating and Managing Networks
- Types of Network Analysis
9. Spatial Data Quality
- What is it and Why do we Care?
- Measures of Data Quality
- Metadata
10. GIS Implementation & Management
- Implementation vs. Management
- User Centered Approach
- Implementation Strategies
- Project Management
FINAL EXAM – THURSDAY, APRIL 22, 9 AM
Tentative Laboratory Schedule
Labs are scheduled Monday & Tuesday afternoons and will be delivered synchronously online.
| Date | Lab | Topic |
| Jan 11/12 | 1 | Introduction to the Geodatabase Model (ArcGIS Pro) |
| Jan 18/19 | 2 | Building Geospatial Databases: Import & Construct a Geodatabase |
| Jan 25/26 | 3 | Building Geospatial Databases: Subtypes and Attribute Domains |
| Feb 1 /2 | 4 | Building Geospatial Databases: Editing; data collection & editing workflows using ArcGIS Pro |
| Feb 8/9 | 5 | Working with Attribute Data: Querying (create basic selections; calculate fields); Joins |
| Feb 15/16 | — | No Lab (Louis Riel Day & Reading Week) |
| Feb 22/23 | QUIZ | Timed Lab Quiz #1 |
| Mar 1 /2 | 6 | Vector-based Spatial Analysis (Geoprocessing tools) |
| Mar 8/9 | 7 | Raster-based Spatial Analysis (Spatial Analyst); suitability analysis |
| Mar 15/16 | 8 | Creating & Analyzing Digital Elevation Models; 3D Analyst; surface analysis in ArcGIS Pro |
| Mar 22/23 | 9 | Analyzing Spatial Patterns (clustering tools in ArcGIS Pro); Point Pattern Analysis |
| Mar 29/30 | 10 | Networks; network analyst in ArcGIS Pro |
| Apr 5/6 | QUIZ | Timed Lab Quiz #2 |