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 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.