Ontario College Graduate Certificate in Geographic Information Systems - Applications Specialist Curriculum
Accepting Applications for September 2018
Courses and Descriptions
This course presents principles and techniques of database design and processing in a GIS environment. Lab exercises and project work provide opportunities for students to develop skills in designing, implementing and managing databases using industry standard software such as Microsoft Access, Oracle and ESRI's Geodatabase. Structured Query Language will be used to build databases and manipulate data in preparation for future work in data processing, GIS analysis, and cartographic presentation.
Geodesy is the science related to the determination of the size and shape of the earth. Due to the curvature of the earth, geodetic principles must be applied to small scale maps covering large areas. Students will develop an increased awareness of this foundation science and the issues involved in measuring and mapping the earth, such as applying appropriate map projections and coordinate systems.
This course will engage students in the exploration of the cartographic communication process. Effective geographical display is dependent upon the decisions involved in its design, such as colour, symbology, and typography in map making. Students will also be introduced to concepts and processes that are central to cartography, enabling the student to build a cartographic foundation for subsequent studies. Industry standard, graphic design software will be used to create various paper products and screen images.
Geomatics software systems include programming capabilities to enable technical users to build specialised applications to process data and automate repetitive tasks. Using these facilities, a few well placed lines of code can save days of tedium or can accomplish tasks that would otherwise not be feasible. In this course students will prepare to utilise these capabilities by: (1) developing problem solving and algorithm design skills, and (2) implementing solutions in a high-level programming language and (3) designing graphic user interfaces in objected-oriented, event-driven environments. This course also serves as the foundation to the other programming and technical courses in the GIS specialist programs.
This course provides an introduction to the basic interpretation and measurement of physical, biological, and cultural features on remotely sensed imagery. Basic photogrammetry concepts will be examined and practiced in scale determination, height, and measurement. Students will acquire an understanding of basic remote sensing techniques and their application in natural resource disciplines. In lab and field work students will gather control points, register the image to the ground, and compile data from industry standard software. Lab software: PCI Geomatica.
This course will enable students to explore the principles and fundamental concepts and types of Geographic Information Systems (GIS) and apply them in projects. Students will be introduced to the five main technical components of a GIS, namely, input, storage, pre-processing, analysis and output using both the raster and vector spatial data models. Hands-on experience, using current software applications is provided through a series of laboratory exercises.
Through project work in the field and in lab, students will gain practical experience in equipment use, maintenance and troubleshooting in survey camp. Collected features will be placed in a GIS, adjusted and points positioned by control methods. Students will have hands on experience using Total Stations, Data Loggers, GPS differential corrections and trigonometric leveling for TIN models.
Acquiring spatial data and attribute data, in the field, is an important part of mapping and GIS. Once back in the office, this new data must be integrated in an efficient manner. Building on the skill sets associated with measuring for maps and land-type surveys, students will develop methods of placing field data onto existing maps and plans. These collected features will be placed in a GIS/Land Information System and appended to existing digital maps and plans.
This course introduces students to the growing field of distributed geographic information. Principles of web design will be explored using industry standard software, with a focus on issues of accessibility. Various technologies for building dynamic web sites in a client-server environment will be introduced, and students will use client-side programming languages in the development of a website. This course prepares students for the use and customization of web GIS applications in the second semester.
The goals of this advanced course are three-fold. First, today's professional airborne digital mapping systems will be reviewed. In so doing, students will be able to use current imaging and GIS software to compile a 3-D map. Second, a thorough analysis of the applications of synthetic aperture radar (SAR - both airborne and from space) will be completed. In understanding that process students will be involved in measuring ground subsidence by means of GPS data densification achieved through SAR imagery and interferometry. Third, the ever increasing utility of the data from the MODIS and ASTER space-borne sensors will be reviewed, and in parallel, students will perform advanced fully-automated, (as well as semi-automated), data extraction.
As GIS software packages become more sophisticated, there is a greater need for GIS specialists who not only perform GIS analyses, but also are highly skilled in customizing GIS applications, thereby facilitating the use of GIS applications to end-users. Students will learn how to develop customized GIS applications to meet specific user needs and how to link these applications to other programs. Customization will be done within a GIS application and also by developing standalone programs that integrate GIS capabilities.
Environmental Modeling is the science of predicting the behaviour and occurrence of environmental processes and variables. The use of GIS in Environmental Modeling extends this science to the creation of spatial surfaces. Environmental modeling using GIS is being applied to a wide variety of environmental and natural resource applications for decision-making at all levels, and as such is an important tool for the GIS Analyst. This course will provide the fundamental knowledge required to perform environmental modeling using industry standard GIS software. Students create surfaces using a variety of interpolation techniques, will learn the appropriate algorithm to choose for a given scenario, and will create and use 3D surfaces for enhanced visualization. In addition, hydrological surfaces will be created and examined in order to better understand the physical processes which take place in our environment.
The skills developed in this course will help students select, design, build, and implement a complex GIS application and/or a cartographic representation in response to an industry defined problem, using a business project management model. The course will assist students in negotiating the complexities of project planning unique to this sector, as well as issues such as client relations, time management and scheduling, data acquisition, negotiating intellectual property rights and copyrights and managing team work and interactions. Project design principles will provide a foundation for the iterative process of planning, establishing schedules, and writing a GIS project proposal. GIS Collaborative Project Planning precedes the GIS Collaborative Project in the final semester, and develops a skill set critical to its success.
This course builds on GIS Database Principles to introduce more advanced relational database topics that are increasingly important for GIS and mapping professionals. Through application of the principles of relational database design, students will learn how to design a model of the users' view of their data. Students will also learn the Object-Relational model whereby relational database tables can be built using objects. The core concepts of geodatabase development will be explored, including determining domains, subtypes, and relationships using spatial data. The differences between personal and enterprise geodatabases will be explored. Students will learn how to integrate relational databases with applications using ODP.NET.
This course will provide the conceptual background to more advanced GIS analysis. Designed to provide an understanding of spatial analysis techniques available within a GIS environment, topics covered may include: spatial distribution and trends, geostatistical analysis, geocoding and networking, geodatabase topologies and advanced spatial analysis. Material presented in lectures will be placed in an applied context through laboratory exercises designed to strengthen practical understanding and awareness of complex GIS methodology in a variety of application areas.
This course introduces GIS students to the broad possibilities of the single greatest impetus for change in the GIS industry - the Internet. Building on Web Design and Programming in the previous semester, Web GIS Development provides an overview and develops a conceptual understanding of, existing Web-based applications for GIS and the innovations that will affect the shape of the industry's future. Students will create web GIS sites using the built-in capabilities of several of the leading commercial web GIS applications, and will later customize these sites using scripts and programming. Planning and development stages for a GIS website will also be covered, with practical work in accessing, displaying, querying, and analyzing GIS data over the Internet.
This course provides the student with an opportunity to finalize the design, development and implementation of a GIS project initiated in the Project Planning course. This team based project will address a variety of GIS issues and use mapping techniques to promote the research, development, testing, and analyzing of real world information in a 'real world' environment. Students will be challenged to assign responsibilities, create and maintain satisfactory working relationships with the client, accept feedback, meet project deadlines, manage the production of deliverables to industry standard, and formally present their findings.
- GIS Collaborative Project Planning (GEOM 68)
- Geodesy (GEOM 104)
- Geovisualization I (GEOM 102)
- Problem Solving and Programming (GEOM 67)
- Remote Sensing and Image Analysis (GEOM 66)
- Spatial Analysis I (GEOM 103)
- Surveying and CAD Mapping (SURV 21)
- Web Design and Programming (GEOM 101)
- GIS Database Principles (GEOM 65)
This course will teach participants how to design, manage and access spatial databases in an enterprise environment using Oracle Spatial. Students will learn the structure of Oracle's Spatial Data Model, how to work with spatial objects and perform spatial analysis using spatial operators and spatial functions. Students will also gain practical skills processing spatial data with Oracle's PL/SQL.