2020 QUARTER 01

A B C D E F G H I K L M N O P R S T U V W
PD-17 - SQL Languages for GIS

SQL (Structured Query Language) is a declarative programming language that is closely linked to the relational database model. It is an accessible and widely adopted language used for query, data modification, and data definition—that is, defining data structures (tables) and other database objects. Important additions to the SQL standard include SQL/PSM, which adds control flow, local variables, and other procedural language features; and SQL/MM Part 3, which adds spatial support. Many complex geoprocessing workflows typically implemented in desktop GIS or scripting languages can easily be implemented in spatial SQL.

CV-05 - Statistical Mapping (Enumeration, Normalization, Classification)

Proper communication of spatial distributions, trends, and patterns in data is an important component of a cartographers work. Geospatial data is often large and complex, and due to inherent limitations of size, scalability, and sensitivity, cartographers are often required to work with data that is abstracted, aggregated, or simplified from its original form. Working with data in this manner serves to clarify cartographic messages, expedite design decisions, and assist in developing narratives, but it also introduces a degree of abstraction and subjectivity in the map that can make it easy to infer false messages from the data and ultimately can mislead map readers. This entry introduces the core topics of statistical mapping around cartography. First, we define enumeration and the aggregation of data to units of enumeration. Next, we introduce the importance of data normalization (or standardization) to more truthfully communicate cartographically and, lastly, discuss common methods of data classification and how cartographers bin data into groups that simplify communication.

DC-13 - Stereoscopy and orthoimagery
  • Explain the relevance of the concept “parallax” in stereoscopic aerial imagery
  • Evaluate the advantages and disadvantages of photogrammetric methods and LiDAR for production of terrain elevation data
  • Specify the technical components of an aerotriangulation system
  • Outline the sequence of tasks involved in generating an orthoimage from a vertical aerial photograph
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.

DC-11 - Street-level Imagery

Street-level imagery consists of collections of photographs taken from the perspective of moving pedestrians or vehicles. These collections are often stitched together digitally and georeferenced to create interactive and immersive landscapes that are virtually navigable by users. Such landscapes, sometimes called 360-degree panoramas, or bubbles, are uploaded onto web platforms, and linked with geographical databases, which allows users to search and explore the imagery in various ways. IT companies such as Google have created street-level imagery platforms that rely primarily on paid drivers, although they have begun to rely on contributor submissions to complement and expand their coverage. Recently services such as Mapillary and OpenStreetCam have advanced a model that relies primarily on volunteer contributors, leveraging community interest from projects such as OpenStreetMap. While street-level imagery has become a widespread tool with multiple commercial and non-commercial applications, it is also entangled various legal and public opinion controversies, due to its capabilities for private data collection and surveillance. 

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
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.

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.

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.

Pages