SRID - SIRGAS-2000 - Oracle Spatial - 10g

From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 1 Oct 2011 21:22:59 -0300

Hi,
  I need to use the SRID SIRGAS-2000 in Oracle 10g.

  I saw in the site:  http://spatialreference.org/ref/epsg/4988/ the EPSG
4988. The OCG-WKT of the EPSG 4988 is:

GEOCCS["SIRGAS 2000",DATUM["Sistema de Referencia Geocentrico para America
del Sur 2000",SPHEROID["GRS
1980",6378137.0,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0.0,0.0,0.0,0.0,0.0,0.0,0.0],AUTHORITY["EPSG","6674"]],PRIMEM["Greenwich",0.0,AUTHORITY["EPSG","8901"]],UNIT["m",1.0],AXIS["Geocentric
X",OTHER],AXIS["Geocentric Y",EAST],AXIS["Geocentric
Z",NORTH],AUTHORITY["EPSG","4988"]]

  So, i checked in the Oracle if SRID 4988 exists. It does not exist.

SQL> select count(*) from cs_srs where srid = 4988;

  COUNT(*)
----------
         0

 The SRID 4170 exists and has the WKTEXT that is similar to the EPSG 4988.:

GEOGCS [ "SIRGAS", DATUM ["Sistema de Referencia Geocentrico para America
del Sur (EPSG ID 6170)", SPHEROID ["GRS 1980 (EPSG ID 7019)", 6378137.0,
298.257222101]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree",
0.0174532925199433]]

   Questions:

   1.) Do you think I can use the SRID 4170 ?

   2.) If the answer for item 1 is equal to "NO" , what tables must I
populate in order to create new SRID based on the EPSG 4988.

   3.) How can I identify the similar SRID in Oracle for EPSG 4988 ?


Thanks
Eriovaldo


--
//www.freelists.org/webpage/oracle-l

SRID - SIRGAS-2000 - Oracle Spatial - 10g

Other related posts: