update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8601; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8602; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8603; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8604; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8605; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8606; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8607; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8608; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8609; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8610; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8611; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8614; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8617; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8618; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8619; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8620; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8621; update sdo_coord_op_params set unit_of_meas_type = 'angle/length' where parameter_id = 8622; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8623; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8624; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8625; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8626; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8627; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8628; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8629; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8630; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8631; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8632; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8633; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8634; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8635; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8636; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8637; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8638; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8639; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8640; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8641; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8642; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8643; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8644; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8645; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8646; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8647; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8648; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8649; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8650; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8651; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8652; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8653; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8667; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8669; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8670; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8671; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8677; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8681; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8683; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8684; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8685; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8686; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8687; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8690; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8691; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8692; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8694; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8695; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8696; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8697; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8698; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8699; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8700; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8701; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8702; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8703; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8704; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8705; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8706; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8707; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8708; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8709; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8710; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8711; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8712; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8713; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8714; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8715; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8716; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8717; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8718; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8719; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8720; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8721; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8722; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8723; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8724; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8725; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8726; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8801; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8802; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8805; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8806; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8807; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8811; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8812; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8813; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8814; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8815; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8816; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8817; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8818; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 8819; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8821; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8822; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8823; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8824; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8826; update sdo_coord_op_params set unit_of_meas_type = 'length' where parameter_id = 8827; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8828; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8829; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8830; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8831; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8832; update sdo_coord_op_params set unit_of_meas_type = 'angle' where parameter_id = 8833; update sdo_coord_op_params set unit_of_meas_type = 'scale' where parameter_id = 1000000001; commit; alter trigger MDSYS.SDO_COORD_OP_METHODS_TRIGGER disable; update MDSYS.SDO_COORD_OP_METHODS set IS_IMPLEMENTED_FORWARD = 1, IS_IMPLEMENTED_REVERSE = 1 where COORD_OP_METHOD_ID = 9633; update MDSYS.SDO_COORD_OPS set IS_IMPLEMENTED_FORWARD = 1, IS_IMPLEMENTED_REVERSE = 1 where COORD_OP_METHOD_ID = 9633; alter trigger MDSYS.SDO_COORD_OP_METHODS_TRIGGER enable; commit; alter trigger MDSYS.SDO_COORD_OP_METHODS_TRIGGER disable; declare rec_count NUMBER; begin select count(*) into rec_count from MDSYS.SDO_COORD_OP_METHODS where COORD_OP_METHOD_ID = 1024; if(rec_count = 0) then insert into MDSYS.SDO_COORD_OP_METHODS ( COORD_OP_METHOD_ID, COORD_OP_METHOD_NAME, REVERSE_OP, INFORMATION_SOURCE, DATA_SOURCE, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 1024, 'Popular Visualisation Pseudo Mercator', 1, 'OGP Guidance Note 7-2', 'OGP', 1, 1); insert into MDSYS.SDO_COORD_OP_METHODS ( COORD_OP_METHOD_ID, COORD_OP_METHOD_NAME, REVERSE_OP, INFORMATION_SOURCE, DATA_SOURCE, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 1026, 'Mercator (Spherical)', 1, 'EPSG guidance note #7-2, http://www.epsg.org', 'OGP', 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1024, 8801, 1, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1024, 8802, 2, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1024, 8806, 3, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1024, 8807, 4, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1026, 8801, 1, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1026, 8802, 2, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1026, 8806, 3, 'No'); insert into MDSYS.SDO_COORD_OP_PARAM_USE ( COORD_OP_METHOD_ID, PARAMETER_ID, SORT_ORDER, PARAM_SIGN_REVERSAL) VALUES ( 1026, 8807, 4, 'No'); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'Latitude_of_origin' WHERE (COORD_OP_METHOD_ID = 1024 AND PARAMETER_ID = 8801 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'Central_Meridian' WHERE (COORD_OP_METHOD_ID = 1024 AND PARAMETER_ID = 8802 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'False_Easting' WHERE (COORD_OP_METHOD_ID = 1024 AND PARAMETER_ID = 8806 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'False_Northing' WHERE (COORD_OP_METHOD_ID = 1024 AND PARAMETER_ID = 8807 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'Latitude_of_origin' WHERE (COORD_OP_METHOD_ID = 1026 AND PARAMETER_ID = 8801 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'Central_Meridian' WHERE (COORD_OP_METHOD_ID = 1026 AND PARAMETER_ID = 8802 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'False_Easting' WHERE (COORD_OP_METHOD_ID = 1026 AND PARAMETER_ID = 8806 ); UPDATE MDSYS.SDO_COORD_OP_PARAM_USE SET LEGACY_PARAM_NAME = 'False_Northing' WHERE (COORD_OP_METHOD_ID = 1026 AND PARAMETER_ID = 8807 ); INSERT INTO sdo_coord_ops ( coord_op_id, coord_op_name, coord_op_type, source_srid, target_srid, coord_tfm_version, coord_op_variant, coord_op_method_id, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, information_source, data_source, show_operation, is_legacy, legacy_code, reverse_op, is_implemented_forward, is_implemented_reverse) VALUES ( 3856, 'Popular Visualisation Pseudo-Mercator', 'CONVERSION', null, null, '', null, 1024, null, null, 'Microsoft', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 3856, 1024, 8801, 0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 3856, 1024, 8802, 0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 3856, 1024, 8806, 0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 3856, 1024, 8807, 0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3857, 'WGS 84 / Pseudo-Mercator', 'PROJECTED', 4499, null, 6326, 4326, 3856, Null, Null, 'Microsoft.', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 900913, 'Google Mercator', 'PROJECTED', 4499, null, 6326, 4326, 3856, Null, Null, null, null, 'FALSE', null, null, null, 'TRUE', 'TRUE'); INSERT INTO sdo_coord_ops ( coord_op_id, coord_op_name, coord_op_type, source_srid, target_srid, coord_tfm_version, coord_op_variant, coord_op_method_id, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, information_source, data_source, show_operation, is_legacy, legacy_code, reverse_op, is_implemented_forward, is_implemented_reverse) VALUES ( 1003856, 'Popular Visualisation Pseudo-Mercator 1026', 'CONVERSION', null, null, '', null, 1026, null, null, 'Microsoft', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 1003856, 1026, 8801, 0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 1003856, 1026, 8802, 0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 1003856, 1026, 8806, 0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 1003856, 1026, 8807, 0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 1003785, 'Popular Visualisation CRS / Mercator', 'PROJECTED', 4499, null, 6055, 4055, 1003856, Null, Null, null, null, 'FALSE', null, null, null, 'TRUE', 'TRUE'); end if; end; / alter trigger MDSYS.SDO_COORD_OP_METHODS_TRIGGER enable; commit; declare rec_count NUMBER; begin select count(*) into rec_count from MDSYS.SDO_COORD_REF_SYS where srid = 3873; if(rec_count = 0) then insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3860, 'Finland Gauss-Kruger zone 19', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3860, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3860, 9807, 8802, 19, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3860, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3860, 9807, 8806, 19500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3860, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3873, 'ETRS89 / GK19FIN', 'PROJECTED', 4500, null, 6258, 4258, 3860, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3861, 'Finland Gauss-Kruger zone 20', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3861, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3861, 9807, 8802, 20, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3861, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3861, 9807, 8806, 20500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3861, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3874, 'ETRS89 / GK20FIN', 'PROJECTED', 4500, null, 6258, 4258, 3861, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3862, 'Finland Gauss-Kruger zone 21', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3862, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3862, 9807, 8802, 21, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3862, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3862, 9807, 8806, 21500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3862, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3875, 'ETRS89 / GK21FIN', 'PROJECTED', 4500, null, 6258, 4258, 3862, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3863, 'Finland Gauss-Kruger zone 22', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3863, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3863, 9807, 8802, 22, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3863, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3863, 9807, 8806, 22500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3863, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3876, 'ETRS89 / GK22FIN', 'PROJECTED', 4500, null, 6258, 4258, 3863, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3864, 'Finland Gauss-Kruger zone 23', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3864, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3864, 9807, 8802, 23, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3864, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3864, 9807, 8806, 23500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3864, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3877, 'ETRS89 / GK23FIN', 'PROJECTED', 4500, null, 6258, 4258, 3864, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3865, 'Finland Gauss-Kruger zone 24', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3865, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3865, 9807, 8802, 24, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3865, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3865, 9807, 8806, 24500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3865, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3878, 'ETRS89 / GK24FIN', 'PROJECTED', 4500, null, 6258, 4258, 3865, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3866, 'Finland Gauss-Kruger zone 25', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3866, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3866, 9807, 8802, 25, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3866, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3866, 9807, 8806, 25500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3866, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3879, 'ETRS89 / GK25FIN', 'PROJECTED', 4500, null, 6258, 4258, 3866, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3867, 'Finland Gauss-Kruger zone 26', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3867, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3867, 9807, 8802, 26, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3867, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3867, 9807, 8806, 26500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3867, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3880, 'ETRS89 / GK26FIN', 'PROJECTED', 4500, null, 6258, 4258, 3867, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3868, 'Finland Gauss-Kruger zone 27', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3868, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3868, 9807, 8802, 27, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3868, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3868, 9807, 8806, 27500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3868, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3881, 'ETRS89 / GK27FIN', 'PROJECTED', 4500, null, 6258, 4258, 3868, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3869, 'Finland Gauss-Kruger zone 28', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3869, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3869, 9807, 8802, 28, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3869, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3869, 9807, 8806, 28500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3869, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3882, 'ETRS89 / GK28FIN', 'PROJECTED', 4500, null, 6258, 4258, 3869, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3870, 'Finland Gauss-Kruger zone 29', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3870, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3870, 9807, 8802, 29, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3870, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3870, 9807, 8806, 29500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3870, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3883, 'ETRS89 / GK29FIN', 'PROJECTED', 4500, null, 6258, 4258, 3870, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3871, 'Finland Gauss-Kruger zone 30', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3871, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3871, 9807, 8802, 30, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3871, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3871, 9807, 8806, 30500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3871, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3884, 'ETRS89 / GK30FIN', 'PROJECTED', 4500, null, 6258, 4258, 3871, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into sdo_coord_ops ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) values ( 3872, 'Finland Gauss-Kruger zone 31', 'CONVERSION', null, null, null, null, 9807, null, null, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', null, 1, 1, 1); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3872, 9807, 8801, 0, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3872, 9807, 8802, 31, null, null, null, 9102); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3872, 9807, 8805, 1, null, null, null, 9201); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3872, 9807, 8806, 31500000, null, null, null, 9001); insert into sdo_coord_op_param_vals ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, PARAM_VALUE_FILE, PARAM_VALUE_XML, UOM_ID) values ( 3872, 9807, 8807, 0, null, null, null, 9001); insert into sdo_coord_ref_system ( SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID, DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID, CMPD_HORIZ_SRID, CMPD_VERT_SRID, INFORMATION_SOURCE, DATA_SOURCE, IS_LEGACY, LEGACY_CODE, LEGACY_WKTEXT, LEGACY_CS_BOUNDS, IS_VALID, SUPPORTS_SDO_GEOMETRY) values ( 3885, 'ETRS89 / GK31FIN', 'PROJECTED', 4500, null, 6258, 4258, 3872, null, null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); end if; end; / declare rec_count NUMBER; begin select count(*) into rec_count from MDSYS.SDO_COORD_REF_SYS where srid = 3067; if(rec_count = 0) then insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18183, 'Finland ETRS-GK19', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18183, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18183, 9807, 8802, 19.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18183, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18183, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18183, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3126, 'ETRS89 / ETRS-GK19FIN', 'PROJECTED', 4500, null, 6258, 4258, 18183, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18184, 'Finland ETRS-GK20', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18184, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18184, 9807, 8802, 20.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18184, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18184, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18184, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3127, 'ETRS89 / ETRS-GK20FIN', 'PROJECTED', 4500, null, 6258, 4258, 18184, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18185, 'Finland ETRS-GK21', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18185, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18185, 9807, 8802, 21.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18185, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18185, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18185, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3128, 'ETRS89 / ETRS-GK21FIN', 'PROJECTED', 4500, null, 6258, 4258, 18185, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18186, 'Finland ETRS-GK22', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18186, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18186, 9807, 8802, 22.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18186, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18186, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18186, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3129, 'ETRS89 / ETRS-GK22FIN', 'PROJECTED', 4500, null, 6258, 4258, 18186, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18187, 'Finland ETRS-GK23', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18187, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18187, 9807, 8802, 23.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18187, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18187, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18187, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3130, 'ETRS89 / ETRS-GK23FIN', 'PROJECTED', 4500, null, 6258, 4258, 18187, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18188, 'Finland ETRS-GK24', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18188, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18188, 9807, 8802, 24.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18188, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18188, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18188, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3131, 'ETRS89 / ETRS-GK24FIN', 'PROJECTED', 4500, null, 6258, 4258, 18188, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18189, 'Finland ETRS-GK25', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18189, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18189, 9807, 8802, 25.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18189, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18189, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18189, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3132, 'ETRS89 / ETRS-GK25FIN', 'PROJECTED', 4500, null, 6258, 4258, 18189, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18190, 'Finland ETRS-GK26', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18190, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18190, 9807, 8802, 26.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18190, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18190, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18190, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3133, 'ETRS89 / ETRS-GK26FIN', 'PROJECTED', 4500, null, 6258, 4258, 18190, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18195, 'Finland ETRS-GK27', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18195, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18195, 9807, 8802, 27.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18195, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18195, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18195, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3134, 'ETRS89 / ETRS-GK27FIN', 'PROJECTED', 4500, null, 6258, 4258, 18195, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18196, 'Finland ETRS-GK28', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18196, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18196, 9807, 8802, 28.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18196, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18196, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18196, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3135, 'ETRS89 / ETRS-GK28FIN', 'PROJECTED', 4500, null, 6258, 4258, 18196, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18197, 'Finland ETRS-GK29', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18197, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18197, 9807, 8802, 29.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18197, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18197, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18197, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3136, 'ETRS89 / ETRS-GK29FIN', 'PROJECTED', 4500, null, 6258, 4258, 18197, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18198, 'Finland ETRS-GK30', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18198, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18198, 9807, 8802, 30.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18198, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18198, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18198, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3137, 'ETRS89 / ETRS-GK30FIN', 'PROJECTED', 4500, null, 6258, 4258, 18198, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 18199, 'Finland ETRS-GK31', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18199, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18199, 9807, 8802, 31.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18199, 9807, 8805, 1, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18199, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 18199, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3138, 'ETRS89 / ETRS-GK31FIN', 'PROJECTED', 4500, null, 6258, 4258, 18199, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); insert into MDSYS.SDO_COORD_OPS ( COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, SOURCE_SRID, TARGET_SRID, COORD_TFM_VERSION, COORD_OP_VARIANT, COORD_OP_METHOD_ID, UOM_ID_SOURCE_OFFSETS, UOM_ID_TARGET_OFFSETS, INFORMATION_SOURCE, DATA_SOURCE, SHOW_OPERATION, IS_LEGACY, LEGACY_CODE, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE) VALUES ( 16065, 'TM35FIN', 'CONVERSION', NULL, NULL, NULL, NULL, 9807, NULL, NULL, 'National Land Survey of Finland.', 'OGP', 1, 'FALSE', NULL, 1, 1, 1); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 16065, 9807, 8801, 0.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 16065, 9807, 8802, 27.0, NULL, 9102); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 16065, 9807, 8805, 0.9996, NULL, 9201); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 16065, 9807, 8806, 500000.0, NULL, 9001); insert into MDSYS.SDO_COORD_OP_PARAM_VALS ( COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID) VALUES ( 16065, 9807, 8807, 0.0, NULL, 9001); INSERT INTO sdo_coord_ref_system ( srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid, information_source, data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry) VALUES ( 3067, 'ETRS89 / TM35FIN(E,N)', 'PROJECTED', 4400, null, 6258, 4258, 16065, Null, Null, 'National Land Survey of Finland; http://www.maanmittauslaitos.fi', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE'); end if; end; / commit; @@sdoepsgl4.plb