Spatial Database Management

Credit: (c) Penn State University is licensed under CC BY-NC-SA 4.0

Resource Description

A spatial database is the backbone of a successful organization or website that depends upon maintaining and using data pertinent to locations on Earth. In GEOG 868, Spatial Database Management, capabilities specific to Relational Database Management Systems (RDBMS) and Geographic Information Systems (GIS) are combined to teach students to create, maintain, and query spatial databases in both desktop and enterprise environments. Learn the basics of Standard Query Language (SQL) and database design/normalization, the specifics of managing spatial data in an open-source technologies context (Postgres/PostGIS) and in the context of the Esri geodatabase. Along the way, you will become familiar with spatial functions and versioning, the latter in a server environment hosted by Amazon Web Services.

This resource is part of the following programs: Graduate Certificate in Geospatial Programming and Web Map Development, Master of Professional Studies in Homeland Security, Master of Science In Spatial Data Science, and Masters of Geographic Information Systems.

Course Number

GEOG 868

License

CC BY-NC-SA 4.0

Online Resource

You can view the entire resource here: Spatial Database Management

Download Resource Files

You can download the resource files here: Spatial Database Management
Jim Detwiler

Hi, I'm Jim Detwiler. I've been an instructor in the Geography Department's online GIS program since 2000. Back then, we had just a one-year, non-credit certificate program with few electives. Today, we offer a Master of GIS degree with numerous electives that enable students to focus on application areas of interest to them. I'm very proud to be associated with this program, both in terms of the faculty involved and the adult professionals who enroll in it. Since joining the online geospatial program, I have authored and taught GEOG 485: GIS Programming and Customization (a VBA/ArcObjects course that's now retired), GEOG 489: GIS Application Development, GEOG 863: GIS Mashups and GEOG 897D: Spatial Database Management, first offered in 2002, 2005, 2008, and 2012, respectively.

Hello, my name is Jim Sloan. I teach three of our courses in this online Certificate and Master's programs: this course (Geography 897D), Geography 482: The Nature of Geographic Information, and Geography 484: GIS Database Development. I've been a member of the faculty in this program since January of 2003.

Resource Departments