<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=utf-8"><meta name=Generator content="Microsoft Word 15 (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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.yiv9641486375msolistparagraph, li.yiv9641486375msolistparagraph, div.yiv9641486375msolistparagraph
{mso-style-name:yiv9641486375msolistparagraph;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.yiv9641486375msonormal, li.yiv9641486375msonormal, div.yiv9641486375msonormal
{mso-style-name:yiv9641486375msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.yiv9641486375msochpdefault, li.yiv9641486375msochpdefault, div.yiv9641486375msochpdefault
{mso-style-name:yiv9641486375msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.yiv9641486375msohyperlink
{mso-style-name:yiv9641486375msohyperlink;}
span.yiv9641486375msohyperlinkfollowed
{mso-style-name:yiv9641486375msohyperlinkfollowed;}
span.yiv9641486375emailstyle17
{mso-style-name:yiv9641486375emailstyle17;}
p.yiv9641486375msonormal1, li.yiv9641486375msonormal1, div.yiv9641486375msonormal1
{mso-style-name:yiv9641486375msonormal1;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.yiv9641486375msohyperlink1
{mso-style-name:yiv9641486375msohyperlink1;
color:#0563C1;
text-decoration:underline;}
span.yiv9641486375msohyperlinkfollowed1
{mso-style-name:yiv9641486375msohyperlinkfollowed1;
color:#954F72;
text-decoration:underline;}
p.yiv9641486375msolistparagraph1, li.yiv9641486375msolistparagraph1, div.yiv9641486375msolistparagraph1
{mso-style-name:yiv9641486375msolistparagraph1;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.yiv9641486375emailstyle171
{mso-style-name:yiv9641486375emailstyle171;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.yiv9641486375msochpdefault1, li.yiv9641486375msochpdefault1, div.yiv9641486375msochpdefault1
{mso-style-name:yiv9641486375msochpdefault1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle30
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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-CA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Brent,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Thank you, Hibernate looks promising! 52North was the first SOS implementation I considered, but it was not evident that it could be used with a custom db structure. I will look into this, as using MapServer just for SOS is clearly a headache!<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><br>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Carsen <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Brent Wood [mailto:pcreso@pcreso.com] <br><b>Sent:</b> November 28, 2014 1:19 AM<br><b>To:</b> Carsen Banister; mapserver-users@lists.osgeo.org<br><b>Subject:</b> Re: [mapserver-users] MapServer SOS setup questions<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div id="yui_3_16_0_1_1417153195375_30612"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Mapservers SOS implementation is pretty minimal these days.<o:p></o:p></span></p></div><div id="yui_3_16_0_1_1417153195375_31307"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_1_1417153195375_31309"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>You might look at 52N for their FOSS SOS server. You can either harvest you data into the internal db, or use Hibernate to build a middleware tool that can access your db directly.<o:p></o:p></span></p></div><div id="yui_3_16_0_1_1417153195375_31496"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_1_1417153195375_31495"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Brent Wood<o:p></o:p></span></p></div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p><div id="yui_3_16_0_1_1417153195375_30520"><div id="yui_3_16_0_1_1417153195375_30519"><div id="yui_3_16_0_1_1417153195375_30518"><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'> Carsen Banister <<a href="mailto:carsen.banister@gmail.com">carsen.banister@gmail.com</a>><br><b>To:</b> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a> <br><b>Sent:</b> Tuesday, November 25, 2014 2:50 PM<br><b>Subject:</b> [mapserver-users] MapServer SOS setup questions</span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div id="yui_3_16_0_1_1417153195375_30630"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p><div id=yiv9641486375><div id="yui_3_16_0_1_1417153195375_30629"><div id="yui_3_16_0_1_1417153195375_30628"><div id="yui_3_16_0_1_1417153195375_30627"><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Hi,<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>I would appreciate any help on some items associated with setting up MapServer SOS. I am quite new to MapServer, and am trying to get up to speed as quickly as possible. The reason for using MapServer’s SOS is that the database structure is custom and I’m not aware of any other SOS servers that support custom MySQL databases (if you can point me in a direction easier than MapServer, please do!).<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>So, the questions I am hoping to get clarification on are:<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div style='margin-left:36.0pt'><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>1.</span><span style='font-size:7.0pt;color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>How do you connect different layers together? e.g. layer and sublayer. What is the syntax for that in the mapfile?</span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'> </span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div style='margin-left:36.0pt'><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>2.</span><span style='font-size:7.0pt;color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>Is there a way to dynamically generate layers (e.g. from database query result), or does the layer structure have to be hardcoded?</span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'> </span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div style='margin-left:36.0pt'><p class=MsoNormal style='background:white'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>3.</span><span style='font-size:7.0pt;color:black'> </span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:black'>When you do a GetObservation, how do you set up MapServer so that that request pulls data from the database, e.g. OVF file configuration?</span><span style='font-family:"Helvetica",sans-serif;color:black'><o:p></o:p></span></p></div><div style='margin-left:18.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div style='margin-left:18.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Thanks in advance for any assistance.<o:p></o:p></span></p></div><div style='margin-left:18.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div style='margin-left:18.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Best regards,<o:p></o:p></span></p></div><div style='margin-left:18.0pt'><p class=MsoNormal style='background:white'><span style='font-family:"Helvetica",sans-serif;color:black'>Carsen<o:p></o:p></span></p></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='font-family:"Helvetica",sans-serif;color:black'><br>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></span></p></div></div></div></div></div></body></html>