Welcome to Spatial Database Management for Geospatial Professionals
This syllabus is divided into several sections. You can read it sequentially by scrolling down the length of the document or by clicking on any of the links below to "jump" to a specific section.
- Course Overview
- Course Objectives
- Required Course Materials
- Assignments and Grading
- Course Schedule
- Course Policies
Office: 2217 EES Building, The Pennsylvania State University,
University Park, PA 16802
Email: Please use the Canvas course e-mail system.
Office hours: Students are welcome to contact me by Course Mail any time. I am typically able to respond within 24 hours, usually much sooner. Although e-mail correspondence is preferred, students may also arrange to contact me by telephone.
GEOG897D: Spatial Database Management for Geospatial Professionals. Advanced topics in the storage, management and retrieval of geospatial data using common proprietary and open-source relational database technologies.
Prerequisites: GEOG 484 or equivalent experience
Access to accurate data is a cornerstone on which all successful organizations are built. The data stewards who maintain an organization's information systems thus have a crucial role to play. This course is intended for students who want to learn how to create, maintain, and retrieve data from a spatially enabled database.
The course begins by covering relational database topics that are of relevance in both geographic and non-geographic contexts (e.g., Structured Query Language and database design). It then focuses on the special considerations involved in the management of a spatial database by demonstrating two broad approaches. The first utilizes open-source technologies (specifically, the Postgres database management system and its spatial extension PostGIS); the second utilizes technology from a leading vendor (Esri's geodatabase).
The course is 10 weeks in length and requires a minimum of 10-12 hours of student activity each week.
What will be expected of you?
Like any graduate level course, you will be challenged to move beyond the knowledge and skills that you bring to the class. However you'll be glad to know that you don't have to show up for class at a certain time! All you need to do is complete your assignments before the published deadlines. Some of the assignments are one week in length, while others are two.
During the term, we encourage everyone to use the class discussion forums, chat rooms, or e-mail to help each other find relevant materials and learn about interesting applications of mashups. We can always be contacted via class e-mail and will check our accounts daily during the week (and typically at least once each weekend). If we are traveling we may check somewhat less frequently, but we will alert you of this beforehand.
We have worked hard to make this the most effective and convenient educational experience possible. How much and how well you learn is ultimately up to you. You will succeed if you are diligent about keeping up with the class schedule, and if you take advantage of opportunities to communicate with the instructors, as well as with your fellow students.
For a more detailed look at what will be covered in each lesson, as well as due dates for our assignments and activities, please refer to the semester-specific course schedule that is part of this syllabus (see "Course Schedule").
GEOG 897D will teach students how to create a spatial database and use it to answer geographic questions. Students will learn using both open-source and proprietary database technologies.
At the successful completion of this course, students should be able to:
- retrieve data from an existing database using SQL Select queries
- design a database schema from a set of requirements
- implement that design through the creation of related tables
- insert and update rows in a table
- create spatially enabled tables in Postgres/PostGIS
- work with PostGIS data using open-source desktop GIS software (QGIS)
- answer questions using PostGIS spatial functions
- create an Esri file geodatabase
- model real-world entities through subtypes, domains, topology rules, and relationship classes
- set up and administer an enterprise (ArcSDE) geodatabase
- manage vector and raster data in an enterprise geodatabase
- understand enterprise geodatabase editing workflows
- discuss the suitability of an open-source or proprietary approach to various project scenarios
In order to take this course, you need to have the required course materials listed below. All (other) materials needed for this course are presented online through our course website and in Canvas. In order to access the online materials, you need to have an active Penn State Access Account user ID and password (used to access the on-line course resources). If you have any questions about obtaining or activating your Penn State Access Account, please contact the Outreach Helpdesk. They can be reached at 1-800-252-3592 in the US or internationally at 814-865-5403 (country code 1). You may reach them by e-mail at firstname.lastname@example.org (link sends e-mail).
We'll be using a number of different software packages in this course, but the good news is that you shouldn't need to pay anything for them:
- Microsoft Access 2008 or later (available to PSU students at no cost)
- PostgreSQL (free)
- PostGIS (free)
- QGIS (free)
- ArcGIS for Desktop (Advanced / ArcInfo)
Free educational licenses available if you don't already have one.
- ArcSDE (we'll use a cloud-based server that will be covered by educational coupons from Amazon)
You can succeed in the course with just our online materials, but you may find the following book useful as a reference:
- PostGIS in Action, 2nd Edition by Regina O. Obe and Leo S. Hsu (ISBN: 9781617291395) -- This book can be ordered at www.postgis.us. After submitting your order, you'll be able to immediately download an electronic version.
Using the Library
Just like on-campus students, as a Penn State student you have a wealth of library resources available to you!
As a user of Penn State Libraries, you can...
- search for journal articles (many are even immediately available in full-text)
- request articles that aren't available in full-text and have them delivered electronically
- borrow books and other materials and have them delivered to your doorstep
- access materials that your instructor has put on Electronic Reserve
- talk to reference librarians in real time using chat, phone, and e-mail
- ...and much more!
Students earn grades that reflect the extent to which they achieve the learning objectives listed above. Opportunities to demonstrate learning include the following. Grades will be based on points assigned to each of several components of the course as follows:
- 8 Individual Projects - 50% of course grade:
Each lesson concludes with a hands-on project to be completed individually by the student. See the Course Schedule for project due dates. Project deliverables, which sometimes include write-ups of lessons learned, are submitted through Canvas.
- 8 Lesson Quizzes - 20% of course grade:
A quiz will be held at the end of each lesson to test the student's comprehension of class materials and other reading as required.
- Review Quiz - 10% of course grade:
A 20-question review quiz at the end of the course will cover all of the course material.
- Final Project - 20% of course grade:
A final project will be submitted in the last week of the course.
Course grades are awarded on the following basis :
Note: Students need to earn at least a "C" grade in all four courses to be eligible for one of our Postbaccalaureate Certificates. Only credits associated with a grade of "B" or higher may be counted toward the MGIS degree.
|Management Functions, Geometry, Spatial Functions|
|Data Management in an Enterprise Geodatabase: Vector and Raster|
Withdrawals and Refunds
Students who officially withdraw from the class may be entitled to a pro-rated refund of tuition. For more information, see Refund Policy under World Campus Student Policies.
Use of Trade Names
Where trade names are used no discrimination is intended and no endorsement by the World Campus, Outreach and Cooperative Extension, the College of Earth and Mineral Sciences, or The Pennsylvania State University is implied.
For this course, we recommend the minimum technical requirements outlined on our "Program Technical Requirements" page. If you need technical assistance at any point during the course, please contact the Outreach Helpdesk (for World Campus students) or the IT Service Desk (for students at all other campus locations).
Access to a reliable broadband Internet connection is required for this course. A problem with your Internet access may not be used as an excuse for late, missing, or incomplete coursework. If you experience problems with your Internet connection while working on this course, it is your responsibility to find an alternative Internet access point, such as a public library or wireless hotspot.
This site is considered a secure website, which means that your connection is encrypted. We do, however, link to content that isn't necessarily encrypted. This is called mixed content. By default, mixed content is blocked in Internet Explorer, Firefox and Chrome. This may result in a blank page or a message saying that only secure content is displayed. Follow the directions on our technical requirements page to view the mixed content.
This course must be viewed using one of the following browsers: Firefox (any version), Safari (versions 5.1 or 6.0), Chrome (0.3 or later), or Internet Explorer with the MathPlayer PlugIn. If you use any other browser, there will be pages containing equations that do not render properly. If you need technical assistance at any point during the course, please contact the Outreach Helpdesk (for World Campus students) or the IT Service Desk (for students at all other campus locations).
Penn State E-mail Accounts
All official communications from the Penn State World Campus are sent to students' Penn State e-mail accounts. Be sure to check your Penn State account regularly, or forward your Penn State e-mail to your preferred e-mail account, so you don't miss any important information.
This course follows the guidelines for academic integrity of Penn State's College of Earth and Mineral Sciences. Penn State defines academic integrity as "the pursuit of scholarly activity in an open, honest and responsible manner." Academic integrity includes "a commitment not to engage in or tolerate acts of falsification, misrepresentation, or deception." In particular, the University defines plagiarism as "the fabrication of information and citations; submitting others' work from professional journals, books, articles, and papers; submission of other students' papers, lab results or project reports and representing the work as one's own." Penalties for violations of academic integrity may include course failure. To learn more, see Penn State's "Plagiarism Tutorial for Students."
All course materials students receive or to which students have online access are protected by copyright laws. Students may use course materials and make copies for their own use as needed, but unauthorized distribution and/or uploading of materials without the instructor’s express permission is strictly prohibited. University Policy AD 40, the University Policy Recording of Classroom Activities and Note Taking Services addresses this issue. Students who engage in the unauthorized distribution of copyrighted materials may be held in violation of the University’s Code of Conduct, and/or liable under Federal and State laws.
For example, uploading completed labs, homework, or other assignments to any study site constitutes a violation of this policy.
Accommodations for Students with Disabilities
Penn State welcomes students with disabilities into the University's educational programs. Every Penn State campus has an office for students with disabilities. The Student Disability Resources (SDR) website provides contact information for every Penn State campus: Contacts for Disability Resources at all Penn State Campuses. For further information, please visit the Student Disability Resources (SDR) website.
In order to receive consideration for reasonable accommodations, you must contact the appropriate disability services office at the campus where you are officially enrolled. You will participate in an intake interview and provide documentation, see Applying for Services from Student Disability Resources. If the documentation supports your request for reasonable accommodations, your campus’s disability services office will provide you with an accommodation letter. Please share this letter with your instructors and discuss the accommodations with them as early in your courses as possible. You must follow this process for every semester that you request accommodations.
Counseling and Psychological Services
Many students at Penn State face personal challenges or have psychological needs that may interfere with their academic progress, social development, or emotional wellbeing. The university offers a variety of confidential services to help you through difficult times, including individual and group counseling, crisis intervention, consultations, online chats, and mental health screenings. These services are provided by staff who welcome all students and embrace a philosophy respectful of clients’ cultural and religious backgrounds, and sensitive to differences in race, ability, gender identity and sexual orientation. Services include the following:
Counseling and Psychological Services at University Park (CAPS): 814-863-0395
Counseling and Psychological Services at Commonwealth Campuses
Penn State Crisis Line (24 hours/7 days/week): 877-229-6400
Crisis Text Line (24 hours/7 days/week): Text LIONS to 741741
Reporting Bias-Motivated Incidents
Penn State takes great pride to foster a diverse and inclusive environment for students, faculty, and staff. Acts of intolerance, discrimination, or harassment due to age, ancestry, color, disability, gender, gender identity, national origin, race, religious belief, sexual orientation, or veteran status are not tolerated (Policy AD29 Statement on Intolerance) and can be reported through Educational Equity via the Report Bias webpage.
Veterans and currently serving military personnel and/or spouses with unique circumstances (e.g., upcoming deployments, drill/duty requirements, disabilities, VA appointments, etc.) are welcome and encouraged to communicate these, in advance if possible, to the instructor in the case that special arrangements need to be made.
In case of weather-related delays at the University, this online course will proceed as planned. Your instructor will inform you if there are any extenuating circumstances regarding content or activity due dates in the course due to weather delays. If you are affected by a weather-related emergency, please contact your instructor at the earliest possible time to make special arrangements.
Connect Online with Caution
Penn State is committed to educational access for all. Our students come from all walks of life and have diverse life experiences. As with any other online community, the lack of physical interaction in an online classroom can create a false sense of anonymity and security. While one can make new friends online, digital relationships can also be misleading. Good judgment and decision making are critical when choosing to disclose personal information with others whom you do not know.
If you are prevented from completing this course within the prescribed amount of time, it is possible to have the grade deferred with the concurrence of the instructor. To seek a deferred grade, you must submit a written request (by e-mail or U.S. post) to your instructor describing the reason(s) for the request. It is up to your instructor to determine whether or not you will be permitted to receive a deferred grade. If, for any reason, the course work for the deferred grade is not complete by the assigned time, a grade of "F" will be automatically entered on your transcript.
This course will be conducted entirely online. There will be no set class meeting times, but you will be required to complete weekly assignments with specific due dates. Many of the assignments are open for multiple days, so it is your responsibility to complete the work early if you plan to travel or participate in national holidays, religious observances or University approved activities.
If you need to request an exception due to a personal or medical emergency, contact the instructor directly as soon as you are able. Such requests will be considered on a case-by-case basis.
Please note that the specifics of this Course Syllabus can be changed at any time, and you will be responsible for abiding by any such changes. All changes will be communicated with you via e-mail, course announcement and/or course discussion forum.