Difference between revisions of "Prostorové operátory"
From Wikivyuka
m |
m |
||
| Line 1: | Line 1: | ||
| − | '''Základní Spatial | + | '''Základní Spatial Operátory''' |
Operator Description | Operator Description | ||
| + | |||
SDO_FILTER Specifies which geometries may interact with a given geometry. | 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_JOIN Performs a spatial join based on one or more topological relationships. | ||
| Line 11: | Line 12: | ||
'''Convenience Operators for SDO_RELATE Operations''' | '''Convenience Operators for SDO_RELATE Operations''' | ||
| − | Operator | + | Operator Description |
| − | SDO_ANYINTERACT | + | |
| − | SDO_CONTAINS | + | SDO_ANYINTERACT Checks if any geometries in a table have the ANYINTERACT topological relationship with a specified geometry. |
| − | SDO_COVEREDBY | + | SDO_CONTAINS Checks if any geometries in a table have the CONTAINS topological relationship with a specified geometry. |
| − | SDO_COVERS | + | SDO_COVEREDBY Checks if any geometries in a table have the COVEREDBY topological relationship with a specified geometry. |
| − | SDO_EQUAL | + | SDO_COVERS Checks if any geometries in a table have the COVERS topological relationship with a specified geometry. |
| − | SDO_INSIDE | + | SDO_EQUAL Checks if any geometries in a table have the EQUAL topological relationship with a specified geometry. |
| − | SDO_ON | + | SDO_INSIDE Checks if any geometries in a table have the INSIDE 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_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_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_OVERLAPS Checks if any geometries in a table overlap (that is, have the OVERLAPBDYDISJOINT or OVERLAPBDYINTERSECT topological relationship with) a specified geometry. | ||
| − | SDO_TOUCH | + | SDO_TOUCH Checks if any geometries in a table have the TOUCH topological relationship with a specified geometry. |
Revision as of 07:19, 25 March 2010
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.
