<font size="2"><span style="font-family: arial,sans-serif;">
</span></font><style type="text/css">P { margin-bottom: 0.21cm; direction: ltr; color: rgb(0, 0, 0); line-height: 115%; widows: 2; orphans: 2; }P.western { font-family: "Calibri",sans-serif; font-size: 11pt; }P.cjk { font-family: "Calibri",sans-serif; font-size: 11pt; }P.ctl { font-family: "Times New Roman",serif; font-size: 11pt; }A:link { color: rgb(0, 0, 255); }</style><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);" align="RIGHT">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">Week
#1</span></span></font></p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">Hi
there, </span></span></font>
</p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">I
am Francesco Massa and my GSoC project is</span> <span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">the
istSOS implementation of a “profile” data structure to
manage data from fixed or mobile sensors (CTD probe or
GLIDER AUV acquisition): the data profile ideal is more that a
set of measurements as it keeps inside many environmental details.</span></span></font></p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">Work
done in week 1</span></span></font></p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">In
this first week I anwered to these questions:</span></span></font></p><ul><li><font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">What does “a profile data structure”
mean for me and for other users (Mentor, Oceanographers, Engineers,
Geologists, others end-Users)? <br>So I understand the profiles are seen by all
of us in different but similar way (and just as well, in my view)
expected of the field application or the instruments of measure.</span></span></font></li></ul><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><div style="margin-left: 40px;">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);"> I
get a definition in INSPIRE documents (D2.9_O&M_Guidelines_v2.0rc3):
</span>
<br></span></font>
</div><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255); margin-left: 40px;">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">“A
ProfileObservation is an Observation representing the measurement of
a property along a vertical profile in space at a single time
instant. For example a profile measuring salinity at different depths
in the ocean.” For example in oceanography CTD probe profile, ADCP
current profiler, inclinometer profile are all good example of this
definition.</span></span></font></p><ul><li><font size="2"><span style="font-family: arial,sans-serif;"><span class="st">How </span></span></font><font size="2"><span style="font-family: arial,sans-serif;"><span class="st"><font size="2"><span style="font-family: arial,sans-serif;"><span class="st">are</span></span></font> the data stored in a database</span>? So I started exploring the istSOS database model and I understood it. <span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);"></span></span></font></li></ul><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
</p><div class="span6 result-right row-fluid"><font size="2"><span style="font-family: arial,sans-serif;"><span class="span9"></span></span></font></div><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
</p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);"><font size="2"><span style="font-family: arial,sans-serif;">I think that to store ProfileObservation I could use an Array data: so all data are linked in a unique and more efficient "structure" and this makes easy manage, validate this data type.</span></font></p><ul><li><font size="2"><span style="font-family: arial,sans-serif;">Which kind of filters are expected in GetObservation operation in both SOS standards 1.0 and 2.0? <span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">So I read and compared both implementation standards 1.0 and 2.0.<br></span></span></font></li></ul><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">Work
to be done in week 2</span></span></font></p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);"><font size="2"><span style="font-family: arial,sans-serif;">
<span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">There are many questions in my mind </span><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">about
data Array</span>: </span></span></font>
</p><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><ul><li><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">Can
I run any queries on the table with array fields? </span></span></font>
</p>
</li><li><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">What
is SQL syntax to make select, filter or join using array data?</span></span></font></p>
</li><li><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);">
<font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);"> Can
I extract array data using a SQL WHERE condition? (example:
A=[1,2,3,4,5] X=3 is it possible to extract a new array B with the
only elements of A in which A>X, B[4,5]?)</span></span></font></p>
</li></ul><font size="2"><span style="font-family: arial,sans-serif;">
</span></font><p class="western" style="margin-bottom: 0.42cm; background: none repeat scroll 0% 0% rgb(255, 255, 255);"><font size="2"><span style="font-family: arial,sans-serif;"> Next week I need to do some test with array data after I've modified istSOS model database with arrays fields. <span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);"><br></span></span></font></p><ul><li><font size="2"><span style="font-family: arial,sans-serif;"><span style="background: none repeat scroll 0% 0% rgb(246, 246, 246);">How is XML
model for the observations and measurements (OM) used and how could the profile data type fit into the XML model? </span></span></font>
</li></ul><font size="2"><span style="font-family: arial,sans-serif;">
</span></font>