<div dir="ltr">Thank you all for your help!<br>I tried at first to override the coordinate system with an 'Arbitrary X-Y Coordinates (Meter) (XY-M)'<br>but like Dennis said, it fails. In the preview I got the error that the ressource was not found.<br>
<br><font size="1"><i>Resource was not found:
Session:7731e412-0000-1000-8000-02004c4f4f50_en_7F0000010AFC0AFB0AFA//Samples/Nasca/Layers/ROAD.<br>LayerDefinition
Exception occurred in method MgResourceDefinitionManager.<br>GetDocument at
line 476 in file
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\services\resource\ResourceDefinitionManager.cpp<br><br></i><font size="2">Thanks too, Dennis for the sql-command. I will ask at first my professor for this way of solution.<br>
<br>Kind regards,<br>Alexander Fischer<br><br></font></font><br><div class="gmail_quote">2008/8/13 Jonio, Dennis (Aviation) <span dir="ltr"><<a href="mailto:DJonio@miami-airport.com">DJonio@miami-airport.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="white" link="blue" vlink="blue" lang="EN-US">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Zac,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">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 … </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">r,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">dennis </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: windowtext;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext; font-weight: bold;">From:</span></font></b><font color="black" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: windowtext;"> <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>Kenneth Skovhede, GEOGRAF A/S<div><div>
</div><div class="Wj3C7c"><br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, August 13, 2008
6:53 AM<br>
<b><span style="font-weight: bold;">To:</span></b> MapGuide
Users Mail List<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [mapguide-users] Map
or Layer Preview don't show the Geometry</div></div></span></font><font color="black"><span style="color: windowtext;"></span></font></p>
</div><div><div></div><div class="Wj3C7c">
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">If the "Coordinate System Override" method
that Zac mentions does not work, <br>
it seems like there will be better coordinate system support in the next
MapGuide release:<br>
<a href="http://trac.osgeo.org/mapguide/wiki/MapGuideRfc55" target="_blank">http://trac.osgeo.org/mapguide/wiki/MapGuideRfc55</a><br>
<br>
</span></font></p>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Regards, Kenneth Skovhede, GEOGRAF A/S</span></font></pre>
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br>
Zac Spitzer skrev: </span></font></p>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">did you try to override the feature source co-ordinates system?</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">On Wed, Aug 13, 2008 at 8:25 PM, Jonio, Dennis (Aviation)</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><a href="mailto:DJonio@miami-airport.com" target="_blank"><DJonio@miami-airport.com></a> wrote:</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<blockquote style="margin-top: 5pt; margin-bottom: 5pt;" type="cite"><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Alex,</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Yes, it is known.</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Here is the sql 'knowledge' you need to transform your table. Just plug in</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">the new SRID, in this case I transform to SRID = 8307. Also sdo_geometry</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">column in this case is 'geometry'. Your 'time' issue I am not sure of but</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">for me a transform of 200M records takes about 15 seconds.</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">update YOUR_TABLE_NAME_HERE c set c.GEOMETRY = (select</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">SDO_CS.TRANSFORM(c.GEOMETRY, m.diminfo, 8307) FROM user_sdo_geom_metadata m</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">WHERE m.table_name = 'YOUR_TABLE_NAME_HERE');</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">-- After completion make sure your user_sdo_geom_metadata entry for the</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">table is correct.</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">I wish I had a real solution for you. The way it was handed down to me is</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">that MGOS does not like EPSG codes so it abends the methods. (it certainly</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">does this well)</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">IF the MGOS dev folks have addressed the issue their decision on resolution</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">is unknown to me.</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">r,</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">dennis</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">________________________________</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">From: <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">[<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Alexander</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Fischer</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Sent: Wednesday, August 13, 2008 4:53 AM</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">To: MapGuide Users Mail List</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Subject: Re: [mapguide-users] Map or Layer Preview don't show the Geometry</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">So, is this error known that some CoordinateSystems are not working with</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">MGOS? Is there anywhere a list of these CoordinateSystems? I still hope that</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">I made a mistake because I have neither the time nor the knowledge to</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">transform the whole database into another WKT.</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Kind regards,</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">Alex</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">_______________________________________________</span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;">mapguide-users mailing list</span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
</blockquote>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre><pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span style="font-size: 10pt;"> </span></font></pre>
</div></div><div>
<div style="text-align: center;" align="center"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div><div class="Ih2E3d">
<p><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt;">E-mails are automatically scanned for viruses using
McAfee. </span></font></p>
</div></div>
</div>
</div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br></div>