Taiwan Coordinate System - TWD 67 & TWD 97

Here is how to add Taiwan Coordinate Systems - TWD 67 & TWD97- in Oracle Database.

---

The following is the EPSG format:

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TWD67',
2000067,
2000067,
'Oracle Taiwan',
'GEOGCS [ "TWD67", DATUM ["Australian Geodetic Datum 1966 (EPSG ID 6202)", SPHEROID ["Australian National Spheroid (EPSG ID 7003)", 6378160, 298.25]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TM67 / TWD67',
20000671,
20000671,
'Oracle Taiwan',
'PROJCS["TM67 / TWD67", GEOGCS [ "TWD67", DATUM ["Australian Geodetic Datum 1966 (EPSG ID 6202)", SPHEROID ["Australian National Spheroid (EPSG ID 7003)", 6378160, 298.25]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]], PROJECTION ["TM67 / TWD67 (EPSG OP 2000067)"], PARAMETER ["Latitude_Of_Origin", 0], PARAMETER ["Central_Meridian", 121], PARAMETER ["Scale_Factor", .9999], PARAMETER ["False_Easting", 250000], PARAMETER ["False_Northing", 0], UNIT ["Meter", 1]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TWD97',
2000097,
2000097,
'Oracle Taiwan',
'GEOGCS [ "TWD97", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298.257223563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TM97 / TWD97',
20000971,
20000971,
'Oracle Taiwan',
'PROJCS["TM97 / TWD97", GEOGCS [ "TWD97", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298.257223563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]], PROJECTION ["TM97 / TWD97 (EPSG OP 2000097)"], PARAMETER ["Latitude_Of_Origin", 0], PARAMETER ["Central_Meridian", 121], PARAMETER ["Scale_Factor", .9999], PARAMETER ["False_Easting", 250000], PARAMETER ["False_Northing", 0], UNIT ["Meter", 1]]',
null);

---

The following is the pre-Oracle 10gR2 translation

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TWD67',
20000067,
20000067,
'Oracle Taiwan',
'GEOGCS [ "TWD67", DATUM ["Australian Geodetic Datum 1966 (EPSG ID 6202)", SPHEROID ["Australian National Spheroid (EPSG ID 7003)", 6378160, 298.25]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TM67 / TWD67',
200000671,
200000671,
'Oracle Taiwan',
'PROJCS["TM67 / TWD67", GEOGCS [ "TWD67", DATUM ["Australian Geodetic Datum 1966 (EPSG ID 6202)", SPHEROID ["Australian National Spheroid (EPSG ID 7003)", 6378160, 298.25]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]], PROJECTION ["Transverse Mercator"], PARAMETER ["Latitude_Of_Origin", 0], PARAMETER ["Central_Meridian", 121], PARAMETER ["Scale_Factor", .9999], PARAMETER ["False_Easting", 250000], PARAMETER ["False_Northing", 0], UNIT ["Meter", 1]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TWD97',
20000097,
20000097,
'Oracle Taiwan',
'GEOGCS [ "TWD97", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298.257223563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]]',
null);

insert into cs_srs (
cs_name,
srid,
auth_srid,
auth_name,
wktext,
cs_bounds)
values (
'TM97 / TWD97',
200000971,
200000971,
'Oracle Taiwan',
'PROJCS["TM97 / TWD97", GEOGCS [ "TWD97", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298.257223563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]], PROJECTION ["Transverse Mercator"], PARAMETER ["Latitude_Of_Origin", 0], PARAMETER ["Central_Meridian", 121], PARAMETER ["Scale_Factor", .9999], PARAMETER ["False_Easting", 250000], PARAMETER ["False_Northing", 0], UNIT ["Meter", 1]]',
null);