Task Refresh your knowledge of spatial queries. You first objective is to appreciate the role of querying, then you should identify different queries on raster and vector data and finally learn how SQL is used.
Structured Query Language, Queries and Reasoning
[ pdf ]
Source: Modified from Longley PA, Goodchild MF, Maguire DJ and Rhind DW, 2001. Sections 11.4 and 13.2, in Geographic Information Systems & Science. New York: Wiley. pp. 231 - 2, 282 - 6.
Spatial Queries
[ pdf ]
Source: Trodd NM, 2006. Spatial queries. Modified from Cornelius S and Heywood I, 2001. Manchester: UNIGIS.
Structured Query Language

Queries

Updated version of source: Longley PA, Goodchild MF, Maguire DJ and Rhind DW, 2005. Sections 10.4 and 14.2 in Geographic Information Systems & Science. New York: Wiley. 2nd edtion. pp. 225 - 6 and pp. 320 - 3.
Task Refresh your SQL skills by working with these demonstrators from Manifold. When might you query spatial data using SQL in your work / studies?
Town of Monroe
[ URL ]
Source: Manifold. URL last accessed 2-12-2007.
Query Builder
[ URL ]
Source: Manifold. URL last accessed 2-12-2007.
Task Follow the tutorial and complete the practical exercises in Module 3 of Turning Data into Information. Your task is to demonstrate simple queries and measurements using ArcGIS.
Understanding GIS Queries
[ URL ]
Source: ESRI Virtual Campus. Understanding GIS queries. <http://training.esri.com/acb2000/showdetl.cfm?DID=6&Product_ID=723> URL last accessed 2-12-2007.
Query and Measurement
[ URL ]
Source: ESRI Virtual Campus. Module 3 of Turning Data Into Information. <http: //training.esri.com/acb2000/showdetl.cfm?DID=6&Product_ID=821> URL last accessed 2-12-2007.
Task Spatial data can be explored in many different ways. Examine the case study on earthquakes and then work through the Map Analysis topic on Linking Data Space and Geographic Space. Your task is to identify and exemplify the different environments (views) in which a user can visually or computationally query and analyse spatial data.
Earthquakes
[ URL ]
Source: ESRI Virtual Campus. Earthquakes 1. Module 1 of Spatial Analysis of Geohazards using ArcGIS 9. <http://training.esri.com/acb2000/showdetl.cfm?DID =6&Product_ID=819> URL last accessed 2-11-2006.
Exploring Data Space
[ URL ] [ pdf ]
Source: Berry JK, 1998. Exploring data space. In Topic 7 of Map Analysis. Fort Collins, Colorado: BASIS Press. <http://www.innovativegis.com/basis/Map Analysis/Topic7/Topic7.htm#Exploring> URL last accessed 8-11-2006.
Identifying Data Patterns
[ URL ] [ pdf ]
Source: Berry JK, 1998. Identifying data patterns. In Topic 7 of Map Analysis. Fort Collins, Colorado: BASIS Press. <http://www.innovativegis.com/basis/Map Analysis/Topic7/Topic7.htm#Identifying> URL last accessed 8-11-2006.
Making Space for Mapped Data
[ URL ] [ pdf ]
Source: Berry JK, 2005. Making space for mapped data. In Topic 24 of Map Analysis. Fort Collins, Colorado: BASIS Press. <http://www.innovativegis.com /basis/MapAnalysis/Topic24/Topic24.htm#Spatial_Data_Mining> URL last accessed 8-11-2006.