Hi there,
I am importing KML data from Google maps, and need to load it into an SDO_GEOMETRY column with SRID 8307. The original KML data takes the form of an approximately circular polygon, covering an area the size of a large retail park.
So far, I have successfully done the following:
1. Used SDO_UTIL.FROM_KMLGEOMETRY() to create an SDO_GEOMETRY object
2. Explicitly assigned SRID 3785
3. Stored the object in an SDO_GEOMETRY column called SDO_GEOM_3785
What I am trying to understand is how to convert my SDO_GEOMETRY object with SRID 3785 into an SDO_GEOMETRY object with SRID 8307. This topic is mentioned in the Oracle Spatial Developer's Guide, Section 6.12:
Google Maps Considerations
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_cs_concepts.htm#SPATL1413
The issue is that the example code goes in the other direction, e.g. from SRID 8307 --> SRID 3785.
I have tried to create my own EPSG rule, but I think I am failing to understand something, as my sample UK geofence near Oxford ends up off the coast of Nigeria once I've transformed it, on the equator.
Here is the code I tried to create the EPSG rule:
call sdo_cs.create_pref_concatenated_op(12345,'Google 3785 to Oracle 8307',TFM_PLAN(SDO_TFM_CHAIN(3785,19847,4055,1000000000,8307)),null);
It is intended to be the reverse of the example code at the link above:
CALL sdo_cs.create_pref_concatenated_op(302,'CONCATENATED OPERATION',TFM_PLAN(SDO_TFM_CHAIN(8307, 1000000000, 4055, 19847, 3785)),NULL);
Does anyone have any insight as to what I need to do to achieve this?
I am using Oracle 11.2.0.4.0, Enterprise Edition.
Best wishes
Ben