<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:odc="urn:schemas-microsoft-com:office:odc" 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:st="" 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)">
<!--[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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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:11.0pt;
font-family:"Calibri","sans-serif";}
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";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.balloontextchar0
{mso-style-name:balloontextchar;
mso-style-priority:99;
font-family:"Tahoma","sans-serif";}
span.htmlpreformattedchar0
{mso-style-name:htmlpreformattedchar;
mso-style-priority:99;
font-family:"Courier New";}
span.balloontextchar00
{mso-style-name:balloontextchar0;
font-family:"Tahoma","sans-serif";}
span.balloontextchar000
{mso-style-name:balloontextchar00;
font-family:"Tahoma","sans-serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.emailstyle18
{mso-style-name:emailstyle18;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.emailstyle20
{mso-style-name:emailstyle20;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.balloontextchar0000
{mso-style-name:balloontextchar000;
font-family:"Tahoma","sans-serif";}
span.emailstyle24
{mso-style-name:emailstyle24;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.emailstyle26
{mso-style-name:emailstyle26;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle32
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle33
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle34
{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;}
/* List Definitions */
@list l0
{mso-list-id:853148406;
mso-list-type:hybrid;
mso-list-template-ids:-1435194616 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:1047990244;
mso-list-type:hybrid;
mso-list-template-ids:-1690035758 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:1832717181;
mso-list-type:hybrid;
mso-list-template-ids:-684961590 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</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='color:#1F497D'>If any of you out there are
interested, with the help of Nelson (thanks again) I was successful in getting
MySQL installed on my computer, a user created and then linked this database up
to GeoMOOSE.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Reason:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I am using Access to capture XY
locations from a GPS unit<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In Access I am updating a Table
that is in MySQL<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I then use GeoMOOSE to plot
these XY locations in the map…if you were wireless it would be live every
refresh<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Could lead into vehicle tracking<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='font-size:16.0pt'>Download and Install
three files from MySQL <o:p></o:p></span></u></b></p>
<p class=MsoNormal><b><span style='font-size:9.0pt'><o:p> </o:p></span></b></p>
<p class=MsoNormal>Files:<o:p></o:p></p>
<ul style='margin-top:0in' type=disc>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level1 lfo1'>Install Community Server first<o:p></o:p></li>
<ul style='margin-top:0in' type=circle>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level2 lfo1'><a
href="http://dev.mysql.com/downloads/mysql/5.0.html#downloads">http://dev.mysql.com/downloads/mysql/5.0.html#downloads</a><o:p></o:p></li>
</ul>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level1 lfo1'>Then install GUI Tools<o:p></o:p></li>
<ul style='margin-top:0in' type=circle>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level2 lfo1'><a
href="http://dev.mysql.com/downloads/gui-tools/5.0.html">http://dev.mysql.com/downloads/gui-tools/5.0.html</a><o:p></o:p></li>
</ul>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level1 lfo1'>Download and install the ODBC Driver<o:p></o:p></li>
<ul style='margin-top:0in' type=circle>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level2 lfo1'><a
href="http://dev.mysql.com/downloads/connector/odbc/5.1.html">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a><o:p></o:p></li>
</ul>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level1 lfo1'>Create a new User in the Database and give privleges<o:p></o:p></li>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l1 level1 lfo1'>Set up an ODBC to the database<o:p></o:p></li>
</ul>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='font-size:16.0pt'>Connect up to GeoMOOSE
and retrieve data<o:p></o:p></span></u></b></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Three things have to be set to use this data in GeoMOOSE:<o:p></o:p></p>
<ul style='margin-top:0in' type=disc>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l2 level1 lfo2'>Create .ovf file<o:p></o:p></li>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l2 level1 lfo2'>Create a new Map file<o:p></o:p></li>
<li class=MsoNormal style='margin-bottom:10.0pt;line-height:115%;mso-list:
l2 level1 lfo2'>Modify the MapleGrove_demo.xml file<o:p></o:p></li>
</ul>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><b><span style='font-size:16.0pt'>Create the .ovf file.<o:p></o:p></span></b></p>
<p class=MsoNormal><b><o:p> </o:p></b></p>
<p class=MsoNormal>Create a new txt file and rename it to “Coordinatedata.ovf”<o:p></o:p></p>
<p class=MsoNormal>Please the file in “
C:\ms4w\apps\GeoMOOSE\Maple_Grove_GeoMoose\Databases” or <u>where ever you are
storing the map file for the database</u><o:p></o:p></p>
<p class=MsoNormal>Add this code:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'><OGRVRTDataSource>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
<OGRVRTLayer name="Coordinatedata"><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
<SrcDataSource>MYSQL:coordinates_database,user=</span><span
style='font-size:9.0pt;color:#548DD4'>User name in Database</span><span
style='font-size:9.0pt;color:#943634'>,password=</span><span style='font-size:
9.0pt;color:#548DD4'>Passowrd to database</span><span style='font-size:9.0pt;
color:#943634'>,host=127.0.0.1,port=3306,tables=coordinates</SrcDataSource>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
<SrcSQL>SELECT X,Y FROM coordinates</SrcSQL> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
<GeometryType>wkbPoint</GeometryType><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> <GeometryField
encoding="PointFromColumns" x="X" y="Y"/> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> </OGRVRTLayer><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'></OGRVRTDataSource><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Coordinates_database
is the database name in MySQL<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>User
and password set for a specific user<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Host
– local machine so 127.0.0.1<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Port
was assigned on install<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Next
is the SQL SELECT Statement<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Geometry
sets to a point<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;line-height:115%;
mso-list:l0 level1 lfo3'><![if !supportLists]><span style='font-size:9.0pt;
line-height:115%;font-family:Symbol'><span style='mso-list:Ignore'>·<span
style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='font-size:9.0pt;line-height:115%'>Geometry
Field assigns XY to fields<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><b><span style='font-size:16.0pt'>Create the Map File…</span></b><b><span
style='font-size:10.0pt'>create a new map file and add this code. Save it
somewhere…save the above ovf file in the same location<o:p></o:p></span></b></p>
<p class=MsoNormal><b><span style='font-size:16.0pt'><o:p> </o:p></span></b></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>MAP<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> NAME
'Database'<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> SIZE
800 650<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STATUS
ON<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> EXTENT
189783.560000 4816309.330000 761653.524114 5472346.500000<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> UNITS
METERS<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> FONTSET
'../fonts/fontset.list'<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> SYMBOLSET
'../symbols/symbol.sym'<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> TRANSPARENT
TRUE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> IMAGETYPE
PNG<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> QUERYMAP<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STATUS
ON<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STYLE
SELECTED<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> WEB<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
INCLUDE "/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/web_config.map"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> LEGEND<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STATUS
ON<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>LAYER # Points
from the MySQL Database<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> NAME
Database </span><span style='font-size:9.0pt'> <span
style='color:red'># MATCHES THE MAPBOOK IN THE demo.xml FILE</span><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STATUS
DEFAULT<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> TYPE POINT<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
CONNECTIONTYPE OGR <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> CONNECTION
'./Coordinatedata.ovf' </span><span style='font-size:9.0pt'> <span
style='color:red'># THIS IS THE NAME OF THE ovf FILE</span><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> DATA
'Coordinatedata' </span><span style='font-size:9.0pt'> <span
style='color:red'># THIS IS THE NAME OF THE FUNCTION INSIDE THE ovf FILE</span><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> CLASS <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> #NAME
"ID"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> STYLE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
SYMBOL "circle"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
SIZE 40<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>
COLOR 0 100 100<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>END <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#943634'>END ## end Map<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><b><span style='font-size:16.0pt'>MODIFY THE
MapleGrove_demo.xml file…</span></b><b><span style='font-size:12.0pt'>call the
map file created above to draw the points</span></b><b><span style='font-size:
16.0pt'><o:p></o:p></span></b></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'> <map
title="Database" default="true"
reference="false"><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'> <file>/ms4w/apps/GeoMOOSE/Maple_Grove_GeoMoose/Databases/Coordinate_Points_8bit.map</file><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;color:#943634'> </map><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<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"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Nelson Soto
[mailto:NSoto@plotplans.com] <br>
<b>Sent:</b> Friday, November 07, 2008 10:08 AM<br>
<b>To:</b> Jay Kapalczynski; geomoose-developers@lists.sourceforge.net;
geomoose-users@lists.sourceforge.net<br>
<b>Subject:</b> RE: [Geomoose-developers] [Geomoose-users] MySQL<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>The ogrvrt code is supposed to go in the ovf file you are told to
make here: <a
href="http://mapserver.gis.umn.edu/docs/howto/ogrmysql/?searchterm=ovf">http://mapserver.gis.umn.edu/docs/howto/ogrmysql/?searchterm=ovf</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>It technically doesn’t matter where you save from what I gather;
Just point to wherever you put it in your map file. So, probably in the same
folder as your map file if you want to try to be consistent. It’s really up to
you..<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<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"'> Jay Kapalczynski
[mailto:jkapalczynski@ci.maple-grove.mn.us] <br>
<b>Sent:</b> Friday, November 07, 2008 10:48 AM<br>
<b>To:</b> 'geomoose-developers@lists.sourceforge.net';
'geomoose-users@lists.sourceforge.net'<br>
<b>Subject:</b> Re: [Geomoose-developers] [Geomoose-users] MySQL</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>If I am doing something like
this where does the </span>OGRVRTDataSource<span style='color:#1F497D'>
code have to be?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<pre><OGRVRTDataSource><o:p></o:p></pre><pre> <OGRVRTLayer name="aqidata"><o:p></o:p></pre><pre> <SrcDataSource>MYSQL:aqiTest,user=uuuuu,password=ppppp,host=192.170.1.100,port=3306,tables=testdata</SrcDataSource> <o:p></o:p></pre><pre> <SrcSQL>SELECT areaID, x, y, sampleValue FROM testdata</SrcSQL> <o:p></o:p></pre><pre> <GeometryType>wkbPoint</GeometryType><o:p></o:p></pre><pre> <GeometryField encoding="PointFromColumns" x="x" y="y"/> <o:p></o:p></pre><pre> </OGRVRTLayer><o:p></o:p></pre><pre></OGRVRTDataSource><o:p></o:p></pre>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>LAYER<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
NAME "MyAqi"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
STATUS DEFAULT<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
TYPE POINT<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
CONNECTIONTYPE OGR <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
CONNECTION "aqidata.ovf"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
DATA "aqidata"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
CLASS <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
NAME "MyClass"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
STYLE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
SYMBOL 'circle'<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
SIZE 15<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
COLOR 0 255 0<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>
END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>END</span><span
style='color:#1F497D'><o:p></o:p></span></p>
</div>
</body>
</html>