空间数据库课件第六章OracleSpatial幻灯片.ppt

SELECT a.gid, b.gid FROM TABLE(SDO_JOIN(PARKS, SHAPE, HIGHWAYS, SHAPE,mask=ANYINTERACT)) c, parks a, highways bWHERE c.rowid1 = a.rowid AND c.rowid2 = b.rowid; 3）Cross-Schema Operator Invocation user A has a spatial table T1 (with index table IDX_TAB1) user B has a spatial table T2 (with index table IDX_TAB2) user C wants to invoke operators on tables in one or both of the other schemas. If user C wants to invoke an operator only on T1, user C must perform the following steps: ① Connect as user A and execute the following statements: GRANT select on T1 to C; GRANT select on idx_tab1 to C; ② Connect as user C and execute a statement such as the following: SELECT a.gid FROM T1 a WHERE sdo_filter(a.geometry, :theGeometry)=TRUE; If user C wants to invoke an operator on both T1 and T2, user C must perform the following steps: ① Connect as user A and execute the following statements: GRANT select on T1 to C; GRANT select on idx_tab1 to C; ② Connect as user B and execute the following statements: GRANT select on T2 to C; GRANT select on idx_tab2 to C; ③ Connect as user C and execute a statement such as the following: SELECT a.gid FROM T1 a, T2 b WHERE b.gid = 5 AND sdo_filter(a.geometry, b.geometry) = TRUE; 2.6 Oracle Spatial空间功能 2.6.1 Spatial Operators Table 6-2-10 Main Spatial Operators Table 6-2-11 Convenience Operators for SDO_RELATE Operations 2.6.2 Spatial Aggregate Functions Many spatial aggregate functions accept an input parameter of type SDOAGGRTYPE. Oracle Spatial defines the object type SDOAGGRTYPE as: spatial aggregate functions are listed at page of 313 CREATE TYPE sdoaggrtype AS OBJECT (geometry SDO_GEOMETRY,tolerance NUMBER); 2.6.3 SDO_GEOM Package (Geometry) Oracle Spatial SDO_GEOM字程序包可以分为以下几类： Relationship (True/False) between two objects: RELATE, WITHIN_DISTANCE Validation:VALIDATE_GEOMETRY_WITH_CONTEXT, VALIDATE_LAYER_WITH_CONTEXT Single-object operations: SDO_ARC_DENSIFY,