In the previous chapter, we discussed how to location-enable application data and how to organize geographic data into multiple tables, each containing SDO_GEOMETRY columns. In this chapter, we focus on storing and modeling different types of location information using the SDO_GEOMETRY data type in Oracle. The SDO_GEOMETRY type can store a wide variety of spatial data, including the following:

  • A point, which can be used to store the coordinate location of, for example, a customer site, a store location, a delivery address, and so on
  • A line string, which can be used to store the location and shape of a road segment
  • A polygon, which can be used to store city boundaries, business regions, and so on
  • Complex geometries, ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.