O'Reilly logo

Pro Oracle Spatial for Oracle Database 11g by Ravi Kothuri, Euro Beinat, Albert Godfrind

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4The SDO_GEOMETRY Data Type

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required