Taiwan Coordinate System - TWD 67 & TWD 97 Testing Scripts

To test the Coordinate Systems, just use SQL*Plus
The following is the examples
SQL> select
sdo_cs.transform(
SDO_GEOMETRY(
2001,
20000067,
SDO_POINT_TYPE(
121 + 5 / 60 + 2.255 / 3600,
23 + 37 / 60 + 42.655 / 3600,
NULL),
NULL,
NULL),
200000671)
from
dual;

SDO_CS.TRANSFORM(SDO_GEOMETRY(2001,20000067,SDO_POINT_TYPE(121+5/60+2.255/3600,2
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 200000671, SDO_POINT_TYPE(258566.571082774, 2613894.79614095,
NULL), NULL, NULL)


SQL> select
sdo_cs.transform(
SDO_GEOMETRY(
2001,
200000671,
SDO_POINT_TYPE(
258566.57,
2613894.80,
NULL),
NULL,
NULL),
20000067)
from
dual;

SDO_CS.TRANSFORM(SDO_GEOMETRY(2001,200000671,SDO_POINT_TYPE(258566.57,2613894.80
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 20000067, SDO_POINT_TYPE(121.083959711632, 23.6285153121797,
NULL), NULL, NULL)

SQL>