eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MDSYS.SDO_NET dependencies on SDO_GEOMETRY

Line 405: -- create a spatial (SDO_GEOMETRY) network

401: storage_parameters IN VARCHAR2 DEFAULT '');
402:
403:
404:
405: -- create a spatial (SDO_GEOMETRY) network
406: PROCEDURE create_sdo_network(network IN VARCHAR2,
407: no_of_hierarchy_levels IN NUMBER,
408: is_directed IN BOOLEAN,
409: node_table_name IN VARCHAR2,

Line 423: -- create a spatial (SDO_GEOMETRY) network

419: subpath_geom_column IN VARCHAR2,
420: is_complex IN BOOLEAN DEFAULT FALSE,
421: storage_parameters IN VARCHAR2 DEFAULT '');
422:
423: -- create a spatial (SDO_GEOMETRY) network
424: PROCEDURE create_sdo_network(network IN VARCHAR2,
425: no_of_hierarchy_levels IN NUMBER,
426: is_directed IN BOOLEAN,
427: node_table_name IN VARCHAR2,

Line 441: -- create a spatial (SDO_GEOMETRY) network

437: storage_parameters IN VARCHAR2 DEFAULT '');
438:
439:
440:
441: -- create a spatial (SDO_GEOMETRY) network
442: PROCEDURE create_sdo_network(network IN VARCHAR2,
443: no_of_hierarchy_levels IN NUMBER,
444: is_directed IN BOOLEAN,
445: node_with_cost IN BOOLEAN DEFAULT FALSE,

Line 737: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

733: -- create a point geometry from an LRS geometry and a measure
734: --
735: FUNCTION get_lrs_node_geometry(network in VARCHAR2,
736: node_id in number)
737: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
738:
739: --
740: -- create a point geometry from a topology
741: --

Line 744: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

740: -- create a point geometry from a topology
741: --
742: FUNCTION get_topo_node_geometry(network in VARCHAR2,
743: node_id in number)
744: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
745:
746:
747: --
748: -- get the node geometry

Line 752: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

748: -- get the node geometry
749: --
750: FUNCTION get_node_geometry(network in VARCHAR2,
751: node_id in number)
752: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
753:
754:
755: --
756: -- create linestring geometry from an LRS geometry and start/end measure

Line 761: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

757: --
758: FUNCTION get_lrs_link_geometry(network in VARCHAR2,
759: link_id in number)
760:
761: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
762:
763: --
764: -- create linestring geometry from a topo geometry
765: --

Line 769: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

765: --
766: FUNCTION get_topo_link_geometry(network in VARCHAR2,
767: link_id in number)
768:
769: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
770:
771:
772: --
773: -- get the link geometry

Line 780: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

776: link_id in number,
777: start_percentage IN NUMBER default 0,
778: end_percentage IN NUMBER default 1.0)
779:
780: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
781:
782:
783:
784: --

Line 828: FUNCTION sdo_geometry_network(network IN VARCHAR2)

824: FUNCTION is_node_in_path(network IN VARCHAR2,path_id in number,node_id in number)
825: RETURN VARCHAR2;
826:
827:
828: FUNCTION sdo_geometry_network(network IN VARCHAR2)
829: RETURN VARCHAR2;
830: PRAGMA RESTRICT_REFERENCES(sdo_geometry_network,WNDS,WNPS,RNPS);
831:
832: FUNCTION lrs_geometry_network(network IN VARCHAR2)

Line 830: PRAGMA RESTRICT_REFERENCES(sdo_geometry_network,WNDS,WNPS,RNPS);

826:
827:
828: FUNCTION sdo_geometry_network(network IN VARCHAR2)
829: RETURN VARCHAR2;
830: PRAGMA RESTRICT_REFERENCES(sdo_geometry_network,WNDS,WNPS,RNPS);
831:
832: FUNCTION lrs_geometry_network(network IN VARCHAR2)
833: RETURN VARCHAR2;
834: PRAGMA RESTRICT_REFERENCES(lrs_geometry_network,WNDS,WNPS,RNPS);

Line 1021: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1017: -- compute the geometry of a path from its constituent link geometries
1018: FUNCTION compute_path_geometry(network IN VARCHAR2,
1019: path_id IN NUMBER,
1020: tolerance IN NUMBER)
1021: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1022:
1023: -- Partition the nodes in the network and write the result into the
1024: -- partition table.
1025: PROCEDURE spatial_partition(network IN VARCHAR2,

Line 1141: FUNCTION get_percentage(network IN VARCHAR2, link_id IN NUMBER, pt_geom IN mdsys.sdo_geometry)

1137:
1138: -- return the percentage of the given pt geometry from the start of the linestring geometry
1139: -- if the pt geometry is not on the link geometry, the nearest pt on the link geometry is used
1140: -- percentage is between [0,1]
1141: FUNCTION get_percentage(network IN VARCHAR2, link_id IN NUMBER, pt_geom IN mdsys.sdo_geometry)
1142: RETURN NUMBER;
1143:
1144:
1145: -- return the pt geometry on the givne link geometry based on the given percentage

Line 1149: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1145: -- return the pt geometry on the givne link geometry based on the given percentage
1146: -- if the pt geometry is not on the link geometry, the nearest pt on the link geometry is used
1147: -- valid percentage is between [0,1]
1148: FUNCTION get_pt(network IN VARCHAR2, link_id IN NUMBER, percentage IN NUMBER)
1149: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1150:
1151: -- return the geometry on the givne link geometry based on the given percentages
1152: -- valid percentage is between [0,1]
1153: FUNCTION get_geometry(network IN VARCHAR2, link_id IN NUMBER, start_percentage IN NUMBER, end_percentage IN NUMBER)

Line 1154: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1150:
1151: -- return the geometry on the givne link geometry based on the given percentages
1152: -- valid percentage is between [0,1]
1153: FUNCTION get_geometry(network IN VARCHAR2, link_id IN NUMBER, start_percentage IN NUMBER, end_percentage IN NUMBER)
1154: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1155:
1156: -- Generates node levels for the specified multi-level network.
1157: -- If the the input network is single level, do nothing.
1158: -- @param overwrite: whether to overwrite existing node level table or not

Line 1203: FUNCTION get_pt_geom_ord(geometry IN MDSYS.SDO_GEOMETRY, idx IN INTEGER)

1199:
1200: -- Returns the ordinate of a point geometry given the ordinate index
1201: -- the point geometry can be a 2d standard geometry or an LRS geometry
1202:
1203: FUNCTION get_pt_geom_ord(geometry IN MDSYS.SDO_GEOMETRY, idx IN INTEGER)
1204: RETURN NUMBER;
1205:
1206:
1207: ----------------------------