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-17 - Spatiotemporal Representation
Space and time are integral components of geographic information. There are many ways in which to conceptualize space and time in the geographic realm that stem from time geography research in the 1960s. Cartographers and geovisualization experts alike have grappled with how to represent spatiotemporal data visually. Four broad types of mapping techniques allow for a variety of representations of spatiotemporal data: (1) single static maps, (2) multiple static maps, (3) single dynamic maps, and (4) multiple dynamic maps. The advantages and limitations of these static and dynamic methods are discussed in this entry. For cartographers, identifying the audience and purpose, medium, available data, and available time to design the map are vital aspects to deciding between the different spatiotemporal mapping techniques. However, each of these different mapping techniques offers its own advantages and disadvantages to the cartographer and the map reader. This entry focuses on the mapping of time and spatiotemporal data, the types of time, current methods of mapping, and the advantages and limitations of representing spatiotemporal data.