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.
At a Glance
Details
| Credits |
3.00
|
|---|---|
| Topics |
Applications in GIS
Geospatial Programming and Software Development
|
| Technologies |
Amazon Web Services
ArcGIS Pro
ArcSDE/Multiuser Geodatabases
PostgreSQL/PostGIS
QGIS
SQL
|
| Syllabus | GEOG 868 Syllabus |
Upcoming Offerings
| Semester | Instructor |
|---|---|
| Spring 2, 2024 | Jim Detwiler, M.S. |
| Fall 1, 2024 | Jim Detwiler, M.S. |
Meet Our Faculty Instructors
What Our Students Say
Helped make me a more well-rounded and versatile employee.
“[This] course provided me with great hands-on experience in how to design and administer an ArcSDE database, including how to do so using a cloud-based web server. All of these skills are relevant in the workplace and helped make me a more well-rounded and versatile employee.”
— Adam Shinal
The addition of the GIS-centric commands helped me prepare for a new position.
“Being a long time developer, I wondered what this course might teach me that I already had not run into during my career. I was pleasantly surprised that the course went deeper into SQL than expected and the addition of the GIS-centric commands helped me prepare for a new position … that required these geospatial skills.”
— Ron Ingraham, Principal Software Engineer