<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
        {font-family:SimSun;
        panose-1:2 1 6 0 3 1 1 1 1 1;}
@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:"\@SimSun";
        panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:SimSun;}
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;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@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 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'>Using “native” MySQL to store your SHP files will not associate
a coordinate system with the data. The SRID type column that MySQL has is for
future use, but not currently used. I don’t believe the MySQL FDO provider
reads this value. As a result no spatial context (coordinate system and data
extent) are saved with the associated connection. The result is that users must
assign the coordinate system and bounds of the data manually in a map in order
to see the data. Note because the coordinate system is not known the layers
cannot be used in other maps where a transformation is required.<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'>It’s possible that a recent fix on coordinate system overrides
post the current Open Source Beta may resolve the coordinate system lookup, but
this won’t likely resolve the extent issues. Depending on what version of
Studio you have today it likely doesn’t contain the override field.<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'>The 4326 that you are thinking of is likely the EPSG code which
is conceptually the same thing as an SRID. SRID in the context of Oracle is
Oracle’s own coordinate system id values. MySQL has a placeholder for SRID
values, but nothing is actually defined for the 5.0 version indicating what
these values are or how the server plans to use them. This functionality does
not appear to be implemented yet. Whether the FDO provider could be modified to
interpret MySQL SRID values as an EPSG code might be an idea worth pursuing,
but would only be a workaround until such time as MySQL implements an SRID
solution.<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'>In the case where you use both the MySQL and SHP layers in a map
using the coordinate system of the data both layers may show since no
transformation needs to occur. You likely won’t be able to add the MySQL layers
to a map using a UTM or other type coordinate system requiring a
transformation.<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'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Dave<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-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"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>fishtrees<br>
<b>Sent:</b> Monday, May 14, 2007 1:53 PM<br>
<b>To:</b> mapguide-users-maillist<br>
<b>Subject:</b> [mapguide-users] The data read from MySQL connection has
incorrectcoordinate system<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hi,all<br>
<br>
I use shp2mysql.exe to convert SHP files to MySQL.<br>
<br>
convert command is "shp2mysql -s 4326 roads1 roads_table my_db >
roads.sql",<br>
the -s option specify the SRID for roads1.shp.<br>
and then I read from MapGuide Studio,<br>
but the coordinate system may not be readed out from mysql database,beacause
the preview of map display a incorrect coordinate system.<br>
if I use SHP files as data resource directly,<br>
it can be display correct with my lower left x,y and uper right x,y.<br>
<br>
Is the WGS84's SRID 4326? or whether SHP files must be projected?<br>
when created a mysql connection ,there is no coordinate system option in
MapGuide Studio ,<br>
or I don't know where it is.<br>
<br>
THX very much <br>
<br>
<o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><a href="http://event.mail.163.com/chanel/xyq.htm?from=163"
target="_blank"><span lang=ZH-CN style='font-size:10.5pt'>免费试玩</span><span
style='font-size:10.5pt'>2006<span lang=ZH-CN>中国最佳网络游戏</span>--<span
lang=ZH-CN>梦幻西游 </span></span></a><o:p></o:p></p>
</div>
</body>
</html>