<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z="urn:schemas-microsoft-com:" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you do try that, you will need a build of GDAL/OGR compiled with
Geos support. I am not sure how the one that comes with the FDO binary
distribution is built. We could probably remove this requirement by changing
OgrFeatureReader::ReadNext() to perform the intersects using FdoSpatialUtility
rather than OGR’s OGRGeometry::Intersects.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Traian<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Kenneth,
GEOGRAF A/S<br>
<b>Sent:</b> Wednesday, April 16, 2008 4:41 PM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> Re: [mapguide-users] Precision when selecting polygons<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>You can try the OGR provider, which also supports MySQL.<br>
I am positive that the BBOX problem is solved there, but I am unsure about the
performance aspect.<br>
There may be other hidden problems, but it might be easier than migrating data.<br>
<br>
<o:p></o:p></p>
<pre>Regards, Kenneth, GEOGRAF A/S<o:p></o:p></pre>
<p class=MsoNormal><br>
<br>
Dave Wilson skrev: <o:p></o:p></p>
<pre>If you are using MGOS 2.0 then you can theme on the joined columns. You can't in the 1.2 version. A join between an SHP and a table in MySQL should work in 2.0 and allow selection since the selection is based on the SHP. The searching should also work on the join since theming and searching are both filters.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>The selection problem is specific to MySQL so having all your data in MySQL won't work.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Dave<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: <a
href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a> [<a
href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Krunoslav<o:p></o:p></pre><pre>Sent: Wednesday, April 16, 2008 12:21 PM<o:p></o:p></pre><pre>To: <a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><o:p></o:p></pre><pre>Subject: RE: [mapguide-users] Precision when selecting polygons<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Dave Wilson-3 wrote:<o:p></o:p></pre><pre> <o:p></o:p></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>MySQL only does Envelope operations.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>For example when selecting MapGuide might do an Intersect spatial<o:p></o:p></pre><pre>operation; however, MySQL (at least version 5 and earlier) only does<o:p></o:p></pre><pre>Envelope Intersects so you won't always get the results you expect<o:p></o:p></pre><pre>depending on how the polygons sit next to each other.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>This is a known issue with MySQL. I'm not sure if they have resolved this<o:p></o:p></pre><pre>in later versions.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre> <o:p></o:p></pre></blockquote>
<pre><o:p> </o:p></pre><pre>Thank you for your answer. Since I have all data in mysql tables, I created<o:p></o:p></pre><pre>new Geometry column, converted my SHP to mysql with shp2mysql tool, so I<o:p></o:p></pre><pre>have everything in same table.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>It seemed perfect, but obviously it won't work this way.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Since I have to use styling which is related to property in one column, I<o:p></o:p></pre><pre>also tried to use SHP <-> MySQL join, without geometry data in mysql. I can<o:p></o:p></pre><pre>get properties from mysql table, but layer isn't themed, I don't know why,<o:p></o:p></pre><pre>all parcels are the same color, even if mapguide studio can "pull"<o:p></o:p></pre><pre>properties from the table.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Same procedure works fine when everything (converted SHP) is in mysql, but<o:p></o:p></pre><pre>there is problem as mentioned above.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>So, is there any solution for this or should I give up from using mysql?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Anyway, before starting on a project:<o:p></o:p></pre><pre>I have few shp files and data tables in Excel (which I can easely convert to<o:p></o:p></pre><pre>mysql tables). What would you recommend for next things to work?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>1. Properly selecting polygons<o:p></o:p></pre><pre>2. Searching (regarding to some property from table)<o:p></o:p></pre><pre>3. Themes (also regarding to one column in table).<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>What database to use and how to join this together?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Sorry for my bad english and thank you in advance.<o:p></o:p></pre><pre>--<o:p></o:p></pre><pre>View this message in context: <a
href="http://www.nabble.com/Precision-when-selecting-polygons-tp16718926s16610p16728445.html">http://www.nabble.com/Precision-when-selecting-polygons-tp16718926s16610p16728445.html</a><o:p></o:p></pre><pre>Sent from the MapGuide Users mailing list archive at Nabble.com.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>mapguide-users mailing list<o:p></o:p></pre><pre><a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><o:p></o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>mapguide-users mailing list<o:p></o:p></pre><pre><a
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><o:p></o:p></pre><pre> <o:p></o:p></pre></div>
</div>
</body>
</html>