Zac,
My experience with the "override thingee" has not been positive. It is rather bizarre in my case ... hit refresh and it pulls in the "correct" SRID from s-l king and shows the correct wkt!!! (same thing I get w/in Map3d by the way) ... anything I select for an override fails even arbXY ... but then again, maybe I just don't understand ... r, dennis ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Skovhede, GEOGRAF A/S Sent: Wednesday, August 13, 2008 6:53 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Map or Layer Preview don't show the Geometry If the "Coordinate System Override" method that Zac mentions does not work, it seems like there will be better coordinate system support in the next MapGuide release: http://trac.osgeo.org/mapguide/wiki/MapGuideRfc55 Regards, Kenneth Skovhede, GEOGRAF A/S Zac Spitzer skrev: did you try to override the feature source co-ordinates system? On Wed, Aug 13, 2008 at 8:25 PM, Jonio, Dennis (Aviation) <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> wrote: Alex, Yes, it is known. Here is the sql 'knowledge' you need to transform your table. Just plug in the new SRID, in this case I transform to SRID = 8307. Also sdo_geometry column in this case is 'geometry'. Your 'time' issue I am not sure of but for me a transform of 200M records takes about 15 seconds. update YOUR_TABLE_NAME_HERE c set c.GEOMETRY = (select SDO_CS.TRANSFORM(c.GEOMETRY, m.diminfo, 8307) FROM user_sdo_geom_metadata m WHERE m.table_name = 'YOUR_TABLE_NAME_HERE'); -- After completion make sure your user_sdo_geom_metadata entry for the table is correct. I wish I had a real solution for you. The way it was handed down to me is that MGOS does not like EPSG codes so it abends the methods. (it certainly does this well) IF the MGOS dev folks have addressed the issue their decision on resolution is unknown to me. r, dennis ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Fischer Sent: Wednesday, August 13, 2008 4:53 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] Map or Layer Preview don't show the Geometry So, is this error known that some CoordinateSystems are not working with MGOS? Is there anywhere a list of these CoordinateSystems? I still hope that I made a mistake because I have neither the time nor the knowledge to transform the whole database into another WKT. Kind regards, Alex _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users ________________________________ E-mails are automatically scanned for viruses using McAfee.
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
