Skip to main content
Penn State College of Earth and Mineral Sciences Logo Penn State shield logo with links to Penn State homepage and College of Earth and Mineral Sciences

Department of Geography

Department of

Geography

GEOG 868: Spatial Database Management for the Geospatial Professional

User account menu

  • Log in
  1. Home
  2. Welcome to GEOG 868 - Spatial Database Management
  3. Lesson 4: Advanced Postgres/PostGIS Topics

Checklist

Lesson 4 is one week in length. See the Canvas Calendar for specific due dates. To finish this lesson, you must complete the activities listed below:

  1. Download the data needed for Project 4.
  2. Work through Lesson 4.
  3. Complete Project 4 and upload its deliverables to the Project 4 Dropbox.
  4. Complete the Lesson 4 Quiz.

Book traversal links for Checklist

  • ‹ Overview
  • Up
  • Management Functions ›
Printer-friendly version

Search

Lessons

  • Welcome to GEOG 868 - Spatial Database Management
    • Lesson 1: Retrieving Data From a Relational Database
    • Lesson 2: Relational Database Concepts and Theory
    • Lesson 3: Building a Postgres/PostGIS Database
    • Lesson 4: Advanced Postgres/PostGIS Topics
      • Overview
      • Checklist
      • Management Functions
      • Geometry Constructors
      • Geometry Accessors
      • Geometry Editors
      • Geometry Outputs
      • Spatial Relationship and Measurement Functions
      • PostGIS Spatial Function Practice Exercises
      • PostGIS Spatial Function Practice Exercise Solutions
      • Project 4: Jen and Barry's Site Selection in PostGIS
    • Lesson 5: Working with Esri's Desktop Geodatabases
    • Lesson 6: Introduction to the Enterprise Geodatabase
    • Lesson 7: Data Management in an Enterprise Geodatabase
    • Lesson 8: Versioned Editing
    • Final Project

Course materials prepared by Jim Detwiler and Jim Sloan, College of Earth and Mineral Sciences, The Pennsylvania State University

Unless otherwise noted, this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License(opens in a new tab), part of Penn State's College of Earth and Mineral Sciences' OER Initiative and the Libraries’ Repository of Open and Affordable Materials (ROAM(opens in a new tab)).

The College of Earth and Mineral Sciences is committed to making its websites accessible to all users, and welcomes comments or suggestions on access improvements. Please send comments or suggestions on accessibility to the site editor. (opens email client).

The John A. Dutton Institute for Teaching and Learning Excellence is the learning design unit of the College of Earth and Mineral Sciences at The Pennsylvania State University. About the Institute | Contact Us | Email the Site Editor. (opens email client)

© The Pennsylvania State University | Privacy | Non Discrimination | Accessibility | Equal Opportunity | Copyright