In this chapter you learned how to create different geometry types in CQL using the Spatial cartridge, such as points, rectangles, and arbitrary polygons. The geometry objects are layered on different coordinate systems. The Cartesian coordinate system and the geodetic coordinate system are supported.
Next, you learned how to use different spatial operations. These operations allow you to determine if a geometry contains, is inside, is within distance, or interacts with another geometry. Further, you can find the nearest neighbor a geometry in relation to another collection of geometries. All of these spatial operations are executed in memory during processing of CQL queries and optimized by being indexed using an R-tree data structure.
A spatial context can be created in the EPN to set spatial-related configuration, such as the default coordinate system to be used.
You also learned how to use the JDBC cartridge to invoke any arbitrary SQL statement. This is done by wrapping the SQL...