Home » Server Options » Spatial » To convert from 3785 to 8265 srid (ORacle 11g R2 ,Windows)
To convert from 3785 to 8265 srid [message #459209] Thu, 03 June 2010 23:29 Go to next message
rakeshramm
Messages: 170
Registered: September 2006
Location: Oracle4u.com
Senior Member

Hi all ,

My Database version is Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production.

With me there is a spatial table POWER which contains spatial data with srid 40983, with this data ; using the function sdo_util.to_kmlgeometry ( ie
:select sdo_util.to_kmlgeometry(sdo_cs.transform(u.GEOM,8265)) from POWER
)
and transforming 40983 to 8265 (for Longitude / Latitude )
i am able to generate the kml file and its pointing correct loaction . But for viewing GoogleMaps in Mapviewer I transformed my spatial table POWER_3785 data to srid 3785 and then tried to use sdo_util.to_kmlgeometry ( ie :
select sdo_util.to_kmlgeometry(sdo_cs.transform(u.GEOM,8265)) from POWER_3785
)
by transforming 3785 to 8265 (for Longitude / Latitude )
i am able to generate the kml file But its not pointing in correct loaction
Re: To convert from 3785 to 8265 srid [message #459279 is a reply to message #459209] Fri, 04 June 2010 04:55 Go to previous messageGo to next message
_jum
Messages: 490
Registered: February 2008
Senior Member
I did not find no SRID=3785 in the CS_SRS table. Did you define it by yourself, may be wrong ?
select srid, cs_name from MDSYS.CS_SRS where srid in (3785,8265,40983);
 SRID   CS_NAME
--------------------------------------------------------
 8265	Longitude / Latitude (NAD 83)
40983	California 0405, Zone V (1983, US Survey feet)

[Updated on: Fri, 04 June 2010 04:56]

Report message to a moderator

Re: To convert from 3785 to 8265 srid [message #459282 is a reply to message #459279] Fri, 04 June 2010 05:05 Go to previous messageGo to next message
rakeshramm
Messages: 170
Registered: September 2006
Location: Oracle4u.com
Senior Member

Hi ,

what is the version of your oracle database ? ; SRID 3785 is there in Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 (11GR2) from onwards .
Re: To convert from 3785 to 8265 srid [message #459287 is a reply to message #459282] Fri, 04 June 2010 05:13 Go to previous messageGo to next message
_jum
Messages: 490
Registered: February 2008
Senior Member
My version:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
So I can't proof your results Sad
Re: To convert from 3785 to 8265 srid [message #459297 is a reply to message #459287] Fri, 04 June 2010 05:48 Go to previous messageGo to next message
rakeshramm
Messages: 170
Registered: September 2006
Location: Oracle4u.com
Senior Member

No you can you just want to do execute inset statements and to execute some packages ; just refer this site

http://oraclemaps.blogspot.com/2009/03/displaying-mapviewer-tile-layers-over.html
Re: To convert from 3785 to 8265 srid [message #459298 is a reply to message #459297] Fri, 04 June 2010 05:49 Go to previous messageGo to next message
rakeshramm
Messages: 170
Registered: September 2006
Location: Oracle4u.com
Senior Member



OH ! but you cant try sdo_util.to_kml_geometry its in Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production its only in Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 (11GR2) from onwards

[Updated on: Fri, 04 June 2010 05:50]

Report message to a moderator

Re: To convert from 3785 to 8265 srid [message #459303 is a reply to message #459298] Fri, 04 June 2010 06:21 Go to previous messageGo to next message
_jum
Messages: 490
Registered: February 2008
Senior Member
SDO_UTIL.to_kmlgeometry is accessible:
SELECT geom 
  FROM test_geom WHERE id=56195008;

(2001; 83032; ; (1; 1; 1; 3; 1; 0; ... ); (3294961.19712802; 5703830.25752743; 0; 1; ... ))     
        
SELECT SDO_UTIL.to_kmlgeometry (SDO_CS.transform (geom, 8265)) xml
  FROM test_geomt WHERE id=56195008;

<Point>
  <extrude>0</extrude>
  <tessellate>0</tessellate>
  <altitudeMode>relativeToGround</altitudeMode>
  <coordinates>45.251559362461,45.4259980027815</coordinates>
</Point>
Re: To convert from 3785 to 8265 srid [message #459304 is a reply to message #459303] Fri, 04 June 2010 06:24 Go to previous messageGo to next message
rakeshramm
Messages: 170
Registered: September 2006
Location: Oracle4u.com
Senior Member


OH then its great ; please have a look
Re: To convert from 3785 to 8265 srid [message #459319 is a reply to message #459304] Fri, 04 June 2010 06:46 Go to previous message
_jum
Messages: 490
Registered: February 2008
Senior Member
After download of CS=3785 (Popular Visualisation CRS / Mercator):
SELECT SDO_UTIL.to_kmlgeometry (SDO_CS.transform (geom, 3785)) xml
  FROM test_geom WHERE id=56195008;

<Point>
  <extrude>0</extrude>
  <tessellate>0</tessellate>
  <altitudeMode>relativeToGround</altitudeMode>
  <coordinates>5037380.54583075,5658370.15886842</coordinates>
</Point>

Have You got a testpoint to transform ?

[Updated on: Fri, 04 June 2010 06:49]

Report message to a moderator

Previous Topic: ORA-29532: Java call terminated by uncaught Java exception
Next Topic: Different WKB values
Goto Forum:
  


Current Time: Thu Sep 18 22:55:57 CDT 2014

Total time taken to generate the page: 0.09988 seconds