SRID - SIRGAS-2000 - Oracle Spatial - 10g
Date: Sat, 1 Oct 2011 21:22:59 -0300
Message-ID: <CAJdDhaN8ACK=AL3WRxJAauqpB8hzf=0ajJrta=tUu6NKk7Bhkw_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 01 2011 - 19:22:59 CDT