Advertisement

The SDO_GEOMETRY Data Type

  • Ravi Kothuri
  • Albert Godfrind
  • Euro Beinat

Abstract

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, such as multiple polygons, which can be used to store boundaries for states such as Texas, Hawaii, and California

Keywords

Geometry Type Compound Element Point Geometry Geometry Object Polygon Element 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Ravi Kothuri, Albert Godfrind, Euro Beinat 2004

Authors and Affiliations

  • Ravi Kothuri
  • Albert Godfrind
  • Euro Beinat

There are no affiliations available

Personalised recommendations