Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle Spatial (Read 2326 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle Spatial
13.10.07 at 12:10:03
 
Oracle Spatial
 
The basic building block in Oracle Spatial is an element: a Point, a LineString, or a Polygon. Each element is described by an array of its vertices. For a two-dimensional element, the array is read as { X1, Y1, X2, Y2, X3, Y3, ... }.  
 
Spatial data is stored in the Oracle database in a column of type MDSYS.SDO_GEOMETRY.
 
The function SDO_FILTER can be used to compare two spatial objects:
SDO_FILTER(geometry1 MDSYS.SDO_GEOMETRY, geometry2 MDSYS.SDO_GEOMETRY, params VARCHAR2)
 
For 2 dimensional data the function SDO_RELATE can be used also:  
SDO_RELATE(geometry1 MDSYS.SDO_GEOMETRY, geometry2 MDSYS.SDO_GEOMETRY,params VARCHAR2)
 
Other functions one can use in queries are SDO_NN to find the nearest neighbor and SDO_SDO_WITHIN_DISTANCE to find geometries within a given distance.
 
 
References:
http://www.oreillynet.com/pub/a/network/2003/11/10/oracle_spatial.html
Oracle Spatial home page:
http://www.oracle.com/technology/documentation/spatial.html
List of Examples:
http://download.oracle.com/docs/html/B14255_01/loe.htm
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1