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
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
ISO/IEC 13249-3:2003, “Information technology — Database languages — SQL multimedia and application packages — Part 3: Spatial,” http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=31369.
Open GIS Consortium, “OpenGIS Simple Features Specification for SQL Revision 1.1,” http://www.opengis.org/docs/99-049_OnlinePDF.pdf, May 5, 1999.
For example, refer to John P. Snyder’s Flattening the Earth: Two Thousand Years of Map Projections (University of Chicago Press, 1997).
Rights and permissions
Copyright information
© 2007 Ravi Kothuri, Albert Godfrind, Euro Beinat
About this chapter
Cite this chapter
Kothuri, R., Godfrind, A., Beinat, E. (2007). The SDO_GEOMETRY Data Type. In: Pro Oracle Spatial for Oracle Database 11g. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0446-6_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0446-6_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-899-3
Online ISBN: 978-1-4302-0446-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books