CHAPTER 8Spatial Indexes and Operators

To run the examples in this chapter, you need to import the following datasets:

imp spatial/spatial file=app_with_loc.dmp full=y indexes=n imp spatial/spatial file=map_large.dmp full=y imp spatial/spatial file=citybldgs.dmp full=y

In previous chapters, we showed how to store location information in Oracle tables. We augmented existing tables, such as branches, customers, and competitors, with an SDO_GEOMETRY column to store locations of data objects. In this chapter, we describe how to use this spatial information to perform proximity analysis.

Proximity analysis refers to query/analysis using the locations of data objects. Specifically, in a business application, you might be interested in (but not limited ...

Get Pro Oracle Spatial for Oracle Database 11g now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial