- 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
The foundational concepts are the elementary building blocks and context setting constraints of all other entries in the BoK. The latter encompass the philosophical and mathematical support for GIScience as well as data models, while the constituent elements include, among others, notions of scale, spatial data quality, and openness. This knowledge area is also the place to look for the origins and future of GIScience.
Topics in this Knowledge Area are listed thematically below. Existing topics are in regular font and linked directly to their original entries (published in 2006; these contain only Learning Objectives). Entries that have been expanded and revised are in bold. Forthcoming, future topics are italicized.