Spatial Database Management

Credit: © 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.

Course Number

GEOG 868

License

CC BY-NC-SA 4.0

Resource
Author(s)

Online Resource

View the entire resource online here: Spatial Database Management

Download Source Files

Download the resource's source files here: .zip (81.14 MB)

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.

Learn more