Difference between revisions of "Prostorové operátory"
From Wikivyuka
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.
