GEOSPATIAL DATABASE DESIGN AND DEVELOPMENT
Introduces the basic concepts, techniques and methodologies for designing and implementing a spatial database to prepare for professional work as a GIS designer, analyst, specialist or researcher. Design conceptual spatial database models and implement them within specific spatial data management systems (DBMS). Covers basic SQL database language and the latest developments in database systems (e.g. NoSQL database) for managing and mining spatial big data such as social media datasets and GPS trajectories.
Prerequisites & course information
Requisites: GEOG 170 , GEOG 370 , ENVIR ST/CIV ENGR/GEOG 377 or graduate/professional standing Course Designation: Core GenEd - Natural Science & Wellness + Lab Level - Advanced L&S Credit - L&S Liberal Arts and Science Grad 50% - Counts toward 50% graduate coursework requirement Repeatable for Credit: No Last Taught: Spring 2026 Learning Outcomes: 1. Describe database design and implementation in GIS. Audience: Both Grad & Undergrad 2. Utilize open-source database software to create, manipulate, and manage spatial relational databases. Audience: Both Grad & Undergrad 3. Perform spatial queries and operations to analyze and manage geospatial data within a spatial database environment. Audience: Both Grad & Undergrad 4. Use spatial databases for big data management. Audience: Both Grad & Undergrad 5. Design and develop a spatial database and program to solve specific geographic information problems. Audience: Both Grad & Undergrad 6. Describe the concept of spatial indexing and its significance in optimizing spatial data retrieval. Audience: Both Grad & Undergrad 7. Design, develop, and implement spatial database solutions to address real-world geographic information problems . Audience: Both Grad & Undergrad 8. Integrate spatial databases with programming languages to develop data-driven geospatial applications. Audience: Graduate Learning Outcomes: 1. Describe database design and implementation in GIS. Audience: Both Grad & Undergrad 2. Utilize open-source database software to create, manipulate, and manage spatial relational databases. Audience: Both Grad & Undergrad 3. Perform spatial queries and operations to analyze and manage geospatial data within a spatial database environment. Audience: Both Grad & Undergrad 4. Use spatial databases for big data management. Audience: Both Grad & Undergrad 5. Design and develop a spatial database and program to solve specific geographic information problems. Audience: Both Grad & Undergrad 6. Describe the concept of spatial indexing and its significance in optimizing spatial data retrieval. Audience: Both Grad & Undergrad 7. Design, develop, and implement spatial database solutions to address real-world geographic information problems . Audience: Both Grad & Undergrad 8. Integrate spatial databases with programming languages to develop data-driven geospatial applications. Audience: Graduate
Sources
- Course catalogue ↗2026-2027