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

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

Book traversal links for Lesson 3: Building a Postgres/PostGIS Database

  • ‹ Project 2: Designing a Relational Database
  • Up
  • Overview ›
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
      • 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
    • 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

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