22.43 SDO_CS.VALIDATE_EPSG_MATRIX
Format
SDO_CS.VALIDATE_EPSG_MATRIX( method_id IN NUMBER, parameter_id IN NUMBER, matrix IN CLOB ) RETURN VARCHAR2;
Description
Validates an EPSG matrix of NADCON, NTv2, or VERTCON format.
Parameters
- method_id
-
EPSG method ID to which the matrix refers.
- parameter_id
-
EPSG parameter id identifying the matrix, if an operation has more than one matrix, such as NADCON.
- matrix
-
Matrix CLOB (loaded, using SDO_CS.LOAD_EPSG_MATRIX or manually).
Usage Notes
You can load an EPSG matrix using the SDO_CS.LOAD_EPSG_MATRIX procedure.
Examples
The following example loads an NTv2 matrix for operation 1703 ("NAD27 to WGS 84 (32)"). For an NTv2 operation, a single matrix is sufficient, assigned to parameter ID 8656.
SQL> select m.coord_op_method_name "Method", vals.parameter_id "Parameter", sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file) "Valid", count(*) "#" from sdo_coord_op_param_vals vals, sdo_coord_op_methods m where m.coord_op_method_id = vals.coord_op_method_id and not(vals.param_value_file is null) group by m.coord_op_method_name, vals.parameter_id, sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file) order by m.coord_op_method_name, vals.parameter_id, sdo_cs.validate_epsg_matrix(m.coord_op_method_id, vals.parameter_id, vals.param_value_file); Method Parameter Valid # -------------------------------------------------- ---------- ----- ---------- Geographic3D to Geographic2D+GravityRelatedHeight 8666 TRUE 2 Geographic3D to GravityRelatedHeight (OSGM02) 8666 TRUE 14 NADCON 8657 TRUE 104 NADCON 8658 TRUE 104 NTv2 8656 TRUE 4 Ordnance Survey National Transformation 8664 TRUE 3 6 rows selected.
Parent topic: SDO_CS Package (Coordinate System Transformation)