Given the importance of the management of data within geographic information modelling, this course provides students with the opportunity to develop skills for creating, administering and applying spatial databases. Overview of relational database management systems, focusing on spatial data, relationships and operations and practice creating and using spatial databases. Structured Query Language (SQL) and extensions to model spatial data and spatial relationships. Topics are introduced through a selection of spatial data applications to contextualize, explain, and practice applying spatial databases to achieve application objectives: creating data from scanned maps; proximity and spatial relations; vehicle routing; elementary web services for spatial data. Students will complete a term project applying spatial data to study or model a topic of their choosing.
Social and Behavioural Sciences