From Google Maps to WGS84
Hi guys,
I'm working on Oracle 10g RDBMS (10.2.0.5) with Locator.
I've loaded some shapefile into my database.
In my mapviewer I'm able to see my overlayed WGS84 Fuse 32N (Italy) data on Google Maps, using MapGuide OS Server.
Using an onmouseclick event I'm able to get the Google coordinates but I'd like to save the WGS84-32N coordinates.
During onSave function, I'm using a trigger like this:
CREATE OR REPLACE
TRIGGER "P_VC"."TRG_EC_STAB_GEOMETRY" BEFORE
UPDATE OF GEOMETRY ON EC_STAB FOR EACH ROW
DECLARE
geometria mdsys.sdo_geometry;
BEGIN
geometria := sdo_cs.transform(mdsys.sdo_geometry (2001,3857, :new.geometry.sdo_point,null,null),32632);
0