<div>The one to one join issue has a side effect - </div>
<div> </div>
<div>If you have disparate geometry with the same ID - only one of the objects will display - and it will randlomly alternate between displaying each object on each map redraw.</div>
<div> </div>
<div>You have to ensure that the geometry is multipolygon etc. in order for the entirety of the geometry to display. The one to many join did not solve the issue.</div>
<div> </div>
<div> </div>
<div>Cheers,</div>
<div> </div>
<div>Kori Maleski<br><br></div>
<div class="gmail_quote">On Fri, Dec 12, 2008 at 9:23 AM, Andy Morsell <span dir="ltr"><<a href="mailto:amorsell@spatialgis.com">amorsell@spatialgis.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I have encountered very similar problems with almost every join I have<br>attempted in MGOS or MGE. My most recent experience was for a class that I<br>
taught at AU where a polygon SDF file is joined to a small Access database.<br>Both MGE 2009 and MGOS 2.0.2 just spin on this join with the a CPU maxed<br>anytime the layer is accessed. I will let it spin for a couple of minutes<br>
and then end the process. The crazy thing is that I know for a fact that<br>this exact join worked just fine in MGE 2008 / MGOS 1.2 because I used the<br>same dataset for the same class last year!<br><font color="#888888"><br>
Andy Morsell, P.E.<br>Spatial Integrators, Inc.<br><a href="http://www.spatialgis.com/" target="_blank">www.SpatialGIS.com</a><br></font>
<div>
<div></div>
<div class="Wj3C7c"><br><br>-----Original Message-----<br>From: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a><br>[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Jackie Ng<br>
Sent: Thursday, December 11, 2008 8:39 PM<br>To: <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>Subject: [mapguide-users] Does anyone use Feature Joins?<br><br><br>Hi All,<br><br>I was wondering if anyone uses this feature (pardon the pun).<br>
<br>When I first started with MapGuide, this was the feature that was of most<br>interest to me as it seemed like an easy way to link spatial data with<br>whatever non-spatial databases we have around.<br><br>But after many bad experiences with performance, and some really nasty join<br>
bugs (mainly <a href="http://trac.osgeo.org/mapguide/ticket/502" target="_blank">http://trac.osgeo.org/mapguide/ticket/502</a>), I've have totally<br>shunned using feature joins, and either resorting to either pre-joining,<br>
baking the data and refreshing the dataset at regular intervals, or using a<br>spatially enabled rdbms that does the joins at the dbms level.<br><br>I've have followed the best practices guide, but is seems every database I<br>
have encountered has its own set of quirks that don't play nice with<br>MapGuide.<br><br>Most of our clients were sold on the feature joins capability (well by my<br>sales colleagues anyway), and it pains me (as an implementer, one to has to<br>
deliver) to have to workaround this feature because it fails to perform at a<br>satisfactory level.<br><br>I'd like to hear other people's experiences with feature joins. Is your<br>experience better/worse?<br><br>
- Jackie<br>--<br>View this message in context:<br><a href="http://n2.nabble.com/Does-anyone-use-Feature-Joins--tp1646599p1646599.html" target="_blank">http://n2.nabble.com/Does-anyone-use-Feature-Joins--tp1646599p1646599.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<br><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>_______________________________________________<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>
</div></div></blockquote></div><br>