GEO5030 - Geospatial Data Management

Course Description

This class teaches students how to design and implement spatial databases, topology, spatial data models, spatial query languages, relational database architecture, data storage and indexing, SQL, data mining, etc. Students learn data management skills including relational databases, server GIS, schemas, and enterprise data management using OGC standards, web application program Interfaces (iOS, Android), data security and risk management.

Learner Outcomes

• Retrieve data from an existing database using SQL Select queries;
• Design and implement a database schema;
• Create spatially enabled tables in Postgres/PostGIS;
• Work with PostGIS data using open-source desktop GIS software (QGIS);
• Model real-world entities through subtypes, domains, topology rules, and relationship classes;
• Manage vector and raster data in an enterprise geodatabase;
• Understand enterprise geodatabase editing workflows;
• Interoperability and data ETL (extract, transform, load) methods.

Duration