7.13 SDO_NFE.GET_CONNECTION_POINT_GEOM
Format
SDO_NFE.GET_CONNECTION_POINT_GEOM( conn_intersection IN SDO_INTERACTION ) RETURN SDO_GEOMETRY;
Description
Given a group of interacting features (lines and/or points), calculates and returns the geometry of the point that must connect them.
Parameters
- conn_intersection
-
Interaction group of features. Set of line and/or point features that interact at a common spatial point. (The SDO_INTERACTION type is described in Data Types Used for NFE Connectivity Rules.)
Usage Notes
This function is mainly used over a validated group of features that must be connected because of the requirement of a connectivity rule (see NFE Rules). To get this group of features, use SDO_NFE.GET_LP_CONN_INTERSECTIONS for Line-Point Rules or SDO_NFE.GET_LL_CONN_INTERSECTIONS for Line-Line Rules.
Examples
The following example gets the connection point geometry for each interacting group that meets the given line-point rule.
DECLARE model_id NUMBER := 1; lp_rule_id NUMBER := 1; inter_grps SDO_INTERACTION_ARRAY; conn_point_geom SDO_GEOMETRY; BEGIN -- Get the groups of interacting features that meet the L-P Rule in the model inter_grps := sdo_nfe.get_interaction_groups( model_id, sdo_nfe.RULE_TYPE_LINE_POINT, lp_rule_id ); -- Iterate through the interacting groups FOR i IN 1..inter_grps.count loop -- Get the connection point geometry for each interacting group conn_point_geom := sdo_nfe.get_connection_point_geom( inter_groups(i)); END loop; END; /
Parent topic: SDO_NFE Package Subprograms