<div>Zac,</div>
<div> </div>
<div>I experienced some bad experience with PostGIS in concern to MGOS 2.0.2/2.1. My reported tickets and posts on the forums did not get a response at all. I am very much sceptical PostGIS really works fine with current releases of MGOS.</div>
<div> </div>
<div>Dejan<br></div>
<div class="gmail_quote">On Fri, Oct 30, 2009 at 00:58, Zac Spitzer <span dir="ltr"><<a href="mailto:zac.spitzer@gmail.com">zac.spitzer@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">if your looking at databases, PostGIS was consistently faster than<br>Oracle in the FOSS4G WMS shootout as a spatial back end
<div>
<div></div>
<div class="h5"><br><br>
<div class="gmail_quote">On Fri, Oct 30, 2009 at 4:10 AM, Martin Morrison <span dir="ltr"><<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Dejan,</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">I have used 2.01, 2.02 and 2.1 RC1.</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">The data I have is in State Plane coordinates, so I used geometry.</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">As far as the quality of the FDO, the AutoDESK guys wrote it. It seems to be pretty good.</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Martin</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: rgb(181,196,223) 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <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>On Behalf Of </b>Dejan Gregor<br>
<b>Sent:</b> Thursday, October 29, 2009 11:09 AM
<div>
<div></div>
<div><br><b>To:</b> MapGuide Users Mail List<br><b>Subject:</b> Re: [mapguide-users] Oracle 10g Standard</div></div></span>
<p></p></p></div>
<div>
<div></div>
<div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Dear Martin,</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">just two more questions. Which version of MapGuide Open Source did you use for the production (2.0.2 or 2.1 beta)? I am concerned about the quality of the FDO for MS SQL Server 2008.</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Also, whcih type of geometry storage type did you use (GEOGRAPHY) and did you migrate the data with any open source tools?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Thanks!</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p style="MARGIN-BOTTOM: 12pt" class="MsoNormal">Dejan</p></div>
<div>
<p class="MsoNormal">On Thu, Oct 29, 2009 at 16:03, Martin Morrison <<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Dejan,</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">On the production website we have full blown SQL Server 2008. However, for the people editing the data and for our demo use, we use SQL Server Express 2008. Both work well. Please note the version number, you stated 2000 below. The Spatial technology did not get added to SQL Server until the 2008 version.</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt">Martin</span></p>
<p class="MsoNormal"><span style="COLOR: rgb(31,73,125); FONT-SIZE: 11pt"> </span></p>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: rgb(181,196,223) 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <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>On Behalf Of </b>Dejan Gregor<br>
<b>Sent:</b> Thursday, October 29, 2009 10:55 AM<br><b>To:</b> MapGuide Users Mail List </span></p>
<div>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt"><br><b>Subject:</b> Re: [mapguide-users] Oracle 10g Standard</span></p></div></div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Dear Martin,</p></div>
<div>
<div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">I would like to know more about your implementation on the link privided below (Macklenburg). Did you use SQL Server 2000 Express?</p></div>
<div>
<p class="MsoNormal"> </p></div>
<div>
<p class="MsoNormal">Cheers,</p></div>
<div>
<p style="MARGIN-BOTTOM: 12pt" class="MsoNormal">Dejan</p></div>
<div>
<p class="MsoNormal">On Thu, Oct 29, 2009 at 15:04, Martin Morrison <<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>> wrote:</p>
<p class="MsoNormal">Yes.<br><br><a href="http://gis.edsi.com/mecklenburgmain.php" target="_blank">http://gis.edsi.com/mecklenburgmain.php</a><br><br>Send me a note privately if you wish to discuss help with your specific project.<br>
<span style="COLOR: rgb(136,136,136)"><br>Martin</span></p></div></div></div></div></div>
<p style="MARGIN-BOTTOM: 12pt" class="MsoNormal"><br>_______________________________________________<br>mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">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></p></div>
<p class="MsoNormal"> </p></div></div></div></div><br>_______________________________________________<br>mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">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><br clear="all"><br></div></div><font color="#888888">-- <br>
Zac Spitzer -<br><a href="http://zacster.blogspot.com/" target="_blank">http://zacster.blogspot.com</a><br>+61 405 847 168<br></font><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>