## 2018 QUARTER 04

##### KE-03 - Strategic Planning for GIS Design

Geographic Information Systems (GIS) are pervasive and have become an essential feature in many professional disciplines. Prior to adoption, implementation or use of any GIS, a system must be properly designed to meet its organizational goals, and this requires comprehensive strategic planning to take place ahead of the design. In this article, we discuss methods for strategic planning in GIS design, drawing from literature in Information Systems and GIS research and practice, and business management. We present a four-step approach toward planning for GIS design that will ensure the system is well-suited to further an organization’s long-term functions, applications, and users’ needs.

##### FC-12 - Structured Query Language (SQL) and attribute queries
• Define basic terms of query processing (e.g., SQL, primary and foreign keys, table join)
• Create an SQL query to retrieve elements from a GIS
• Explain the basic logic of SQL syntax
• Demonstrate the basic syntactic structure of SQL
##### DC-01 - Survey theory and electro-optical methods
• Apply coordinate geometry to calculate positions in a coordinate system grid based on control point locations and measured angles and distances
• Given the elevation of one control point, calculate the elevation of a second point by differential (spirit or direct) leveling
• Given the elevation of one control point, calculate the elevation of a second point by trigonometric (indirect) leveling
• Describe the differences between differential and trigonometric leveling
• Explain how electronic distance measurement instruments work
• Define the concepts ellipsoidal (or geodetic) height, geoidal height, and orthometric elevation
• Illustrate the relationship between the concepts of ellipsoidal (or geodetic) height, geoidal height, and orthometric elevation
##### CV-08 - Symbolization and the Visual Variables

Maps communicate information about the world by using symbols to represent specific ideas or concepts. The relationship between a map symbol and the information that symbol represents must be clear and easily interpreted. The symbol design process requires first an understanding of the underlying nature of the data to be mapped (e.g., its spatial dimensions and level of measurement), then the selection of symbols that suggest those data attributes. Cartographers developed the visual variable system, a graphic vocabulary, to express these relationships on maps. Map readers respond to the visual variable system in predictable ways, enabling mapmakers to design map symbols for most types of information with a high degree of reliability.

##### PD-07 - System deployment
• Develop a phasing schedule for deployment of an enterprise-wide system
• Integrate geospatial applications with other enterprise information systems
##### KE-21 - System Modelling for Effective GIS Management

A geographic information system in operation is highly complex, as the scope of the GIS&T Body of Knowledge demonstrates. Modern society relies on many complex systems, but most are self-contained mechanisms with limited and well defined interfaces. A GIS is a complex open system that extends across the realms of hardware, software, data, science, and human processes. A conceptual model of a GIS can be an effective tool to design, implement, operate, maintain, manage, and assessment tool.

##### PD-06 - System testing
• Describe the goals of alpha and beta testing
• Implement established testing procedures on prototype systems
• Use testing results to prepare a system for deployment
• Conduct a quality assurance review
##### CP-05 - Technology transfer
• Explain how an understanding of use of current and proposed technology in other organizations can aid in implementing a GIS
##### CV-14 - Terrain Representation

Terrain representation is the manner by which elevation data are visualized. Data are typically stored as 2.5D grid representations, including digital elevation models (DEMs) in raster format and triangulated irregular networks (TINs). These models facilitate terrain representations such as contours, shaded relief, spot heights, and hypsometric tints, as well as automate calculations of surface derivatives such as slope, aspect, and curvature. 3D effects have viewing directions perpendicular (plan), parallel (profile), or panoramic (oblique view) to the elevation’s vertical datum plane. Recent research has focused on automating, stylizing, and enhancing terrain representations. From the user’s perspective, representations of elevation are measurable or provide a 3D visual effect, with much overlap between the two. The ones a user can measure or derive include contours, hypsometric tinting, slope, aspect, and curvature. Other representations focus on 3D effect and may include aesthetic considerations, such as hachures, relief shading, physiographic maps, block diagrams, rock drawings, and scree patterns. Relief shading creates the 3D effect using the surface normal and illumination vectors with the Lambertian assumption. Non-plan profile or panoramic views are often enhanced by vertical exaggeration. Cartographers combine techniques to mimic or create mapping styles, such as the Swiss-style.