| To convert from 3785 to 8265 srid [message #459209] |
Thu, 03 June 2010 23:29  |
rakeshramm
Messages: 175
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  |
_jum
Messages: 577
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 #459303 is a reply to message #459298] |
Fri, 04 June 2010 06:21 |
_jum
Messages: 577
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 #459319 is a reply to message #459304] |
Fri, 04 June 2010 06:46 |
_jum
Messages: 577
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
