[mapguide-users] Map or Layer Preview don't show the Geometry

[Jonio, Dennis (Aviation)]

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: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] 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)
<DJonio at miami-airport.com> <mailto:DJonio at miami-airport.com>  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: mapguide-users-bounces at lists.osgeo.org
	[mailto:mapguide-users-bounces at lists.osgeo.org] 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
	mapguide-users at lists.osgeo.org
	http://lists.osgeo.org/mailman/listinfo/mapguide-users
	 
	 
	    

 
 
 
  
________________________________


E-mails are automatically scanned for viruses using McAfee. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080813/38db4172/attachment.html