Difference between revisions of "Prostorové operátory"

From Wikivyuka
Jump to: navigation, search
m
m
Line 8: Line 8:
 
  SDO_WITHIN_DISTANCE Determines if two geometries are within a specified distance from one another.
 
  SDO_WITHIN_DISTANCE Determines if two geometries are within a specified distance from one another.
 
  SDO_RELATE      Determines whether or not two geometries interact in a specified way. (See for convenient alternative operators for performing specific mask value operations.)
 
  SDO_RELATE      Determines whether or not two geometries interact in a specified way. (See for convenient alternative operators for performing specific mask value operations.)
 +
 +
'''Convenience Operators for SDO_RELATE Operations'''
 +
 +
Operator      Description
 +
SDO_ANYINTERACT        Checks if any geometries in a table have the ANYINTERACT topological relationship with a specified geometry.
 +
SDO_CONTAINS          Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry.
 +
SDO_COVEREDBY          Checks if any geometries in a table have the COVEREDBY topological relationship with a specified geometry.
 +
SDO_COVERS            Checks if any geometries in a table have the COVERS topological relationship with a specified geometry.
 +
SDO_EQUAL              Checks if any geometries in a table have the EQUAL topological relationship with a specified geometry.
 +
SDO_INSIDE            Checks if any geometries in a table have the INSIDE topological relationship with a specified geometry.
 +
SDO_ON                Checks if any geometries in a table have the ON topological relationship with a specified geometry.
 +
SDO_OVERLAPBDYDISJOINT Checks if any geometries in a table have the OVERLAPBDYDISJOINT topological relationship with a specified geometry.
 +
SDO_OVERLAPBDYINTERSECT Checks if any geometries in a table have the OVERLAPBDYINTERSECT topological relationship with a specified geometry.
 +
SDO_OVERLAPS            Checks if any geometries in a table overlap (that is, have the OVERLAPBDYDISJOINT or OVERLAPBDYINTERSECT topological relationship with) a specified geometry.
 +
SDO_TOUCH              Checks if any geometries in a table have the TOUCH topological relationship with a specified geometry.

Revision as of 07:17, 25 March 2010

Základní Spatial Operators

Operator         Description
SDO_FILTER       Specifies which geometries may interact with a given geometry.
SDO_JOIN         Performs a spatial join based on one or more topological relationships.
SDO_NN           Determines the nearest neighbor geometries to a geometry.
SDO_NN_DISTANCE  Returns the distance of an object returned by the SDO_NN operator.
SDO_WITHIN_DISTANCE Determines if two geometries are within a specified distance from one another.
SDO_RELATE       Determines whether or not two geometries interact in a specified way. (See for convenient alternative operators for performing specific mask value operations.)

Convenience Operators for SDO_RELATE Operations

Operator       	Description
SDO_ANYINTERACT        Checks if any geometries in a table have the ANYINTERACT topological relationship with a specified geometry.
SDO_CONTAINS           Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry.
SDO_COVEREDBY          Checks if any geometries in a table have the COVEREDBY topological relationship with a specified geometry.
SDO_COVERS             Checks if any geometries in a table have the COVERS topological relationship with a specified geometry.
SDO_EQUAL              Checks if any geometries in a table have the EQUAL topological relationship with a specified geometry.
SDO_INSIDE             Checks if any geometries in a table have the INSIDE topological relationship with a specified geometry.
SDO_ON                 Checks if any geometries in a table have the ON topological relationship with a specified geometry.
SDO_OVERLAPBDYDISJOINT Checks if any geometries in a table have the OVERLAPBDYDISJOINT topological relationship with a specified geometry.
SDO_OVERLAPBDYINTERSECT Checks if any geometries in a table have the OVERLAPBDYINTERSECT topological relationship with a specified geometry.
SDO_OVERLAPS            Checks if any geometries in a table overlap (that is, have the OVERLAPBDYDISJOINT or OVERLAPBDYINTERSECT topological relationship with) a specified geometry.
SDO_TOUCH              Checks if any geometries in a table have the TOUCH topological relationship with a specified geometry.