Skip to main content

GEOG 868
Spatial Database Management

Geography Department Penn State

HOME
LESSONS
CANVAS

Lesson 3: Building a Postgres/PostGIS Database

Overview
Checklist
Getting Started with PostGIS
Query-Writing Practice Exercises
Introduction to Spatial Select Queries
PostGIS Geometry Types
Viewing Data in QGIS
Working with Views
Spatial Reference Considerations
Project 3: Mapping the Class Roster
Lesson 3 Practice Exercise Solutions

‹ Project 2: Designing a Relational Database up Overview ›

GEOG 868: Spatial Database Management

Lessons

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
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

Navigation

login

Author and/or Instructor: Jim Detwiler and Jim Sloan, John A. Dutton e-Education Institute,
College of Earth and Mineral Sciences, The Pennsylvania State University

This courseware module is offered as part of the Repository of Open and Affordable Materials at Penn State.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

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. The site editor may also be contacted with questions or comments about this Open Educational Resource.

John A. Dutton e-Education Institute

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.

Navigation

Home
News
About
Contact Us
People
Resources
Services
Login

EMS

College of Earth and Mineral Sciences
Department of Energy and Mineral Engineering
Department of Geography
Department of Geosciences
Department of Materials Science and Engineering
Department of Meteorology and Atmospheric Science
Earth and Environmental Systems Institute
Earth and Mineral Sciences Energy Institute

Programs

Online Geospatial Education Programs
iMPS in Renewable Energy and Sustainability Policy Program Office
BA in Energy and Sustainability Policy Program Office

Related Links

Penn State Digital Learning Cooperative
Penn State World Campus
Web Learning @ Penn State

2217 Earth and Engineering Sciences Building, University Park, Pennsylvania, 16802
Contact Us

Privacy & Legal Statements | Copyright Information
The Pennsylvania State University © 2023