Difference between revisions of "Prostorové operátory"

From Wikivyuka
Jump to: navigation, search
m
m
Line 8: Line 8:
 
  SDO_NN_DISTANCE  Returns the distance of an object returned by the SDO_NN operator.
 
  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_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'''
 
'''Convenience Operators for SDO_RELATE Operations'''
Line 14: Line 15:
 
  Operator                Description
 
  Operator                Description
  
−
  SDO_ANYINTERACT        Checks if any geometries in a table have the ANYINTERACT topological relationship with a specified geometry.
+
  SDO_ANYINTERACT        Checks if any geometries in a table have the ANYINTERACT topological relationship
−
  SDO_CONTAINS            Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry.
+
                        with a specified geometry.
−
  SDO_COVEREDBY          Checks if any geometries in a table have the COVEREDBY topological relationship with a specified geometry.
+
  SDO_CONTAINS            Checks if any geometries in a table have the CONTAINS topological relationship  
−
  SDO_COVERS              Checks if any geometries in a table have the COVERS topological relationship with a specified geometry.
+
                        with a specified geometry.
−
  SDO_EQUAL              Checks if any geometries in a table have the EQUAL topological relationship with a specified geometry.
+
  SDO_COVEREDBY          Checks if any geometries in a table have the COVEREDBY topological relationship
−
  SDO_INSIDE              Checks if any geometries in a table have the INSIDE topological relationship with a specified geometry.
+
                        with a specified geometry.
−
  SDO_ON                  Checks if any geometries in a table have the ON topological relationship with a specified geometry.
+
  SDO_COVERS              Checks if any geometries in a table have the COVERS topological relationship  
−
  SDO_OVERLAPBDYDISJOINT  Checks if any geometries in a table have the OVERLAPBDYDISJOINT topological relationship with a specified geometry.
+
                        with a specified geometry.
−
  SDO_OVERLAPBDYINTERSECT Checks if any geometries in a table have the OVERLAPBDYINTERSECT topological relationship with a specified geometry.
+
  SDO_EQUAL              Checks if any geometries in a table have the EQUAL topological relationship  
−
  SDO_OVERLAPS            Checks if any geometries in a table overlap (that is, have the OVERLAPBDYDISJOINT or OVERLAPBDYINTERSECT topological relationship with) a specified geometry.
+
                        with a specified geometry.
−
  SDO_TOUCH              Checks if any geometries in a table have the TOUCH 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.
  
 
[http://gis.vsb.cz/wikivyuka/index.php/Prostorov%C3%A9_datab%C3%A1ze_-_cvi%C4%8Den%C3%AD Hlavní stránka předmětu]
 
[http://gis.vsb.cz/wikivyuka/index.php/Prostorov%C3%A9_datab%C3%A1ze_-_cvi%C4%8Den%C3%AD Hlavní stránka předmětu]

Revision as of 07:22, 5 August 2014

Základní Spatial Operátory 

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.

Hlavní stránka předmětu

Retrieved from "http://gisak.vsb.cz/wikivyuka/index.php?title=Prostorové_operátory&oldid=3178"