<div dir="ltr">

<p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">Hi everyone,</p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">this is my report from week 7. It can also be found on my wiki page [0]. As always, any feedback is appreciated! </p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">Enjoy the rest of the weekend!</p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">Kind regards,</p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">Jan Pišl</p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><b><br></b></p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif"></p><h3 style="text-decoration-style:initial;text-decoration-color:initial;color:black;background-image:none;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;margin:0.3em 0px 0px;overflow:hidden;padding-top:0.5em;padding-bottom:0px;border-bottom:none;line-height:1.6;font-family:sans-serif"><span class="gmail-m_6711683973335778367gmail-m_-5722080102080593776gmail-m_-3484986743293044498gmail-m_1511621906611360877gmail-m_-7344675500667721820gmail-m_-1150862609421837306gmail-mw-headline" id="gmail-m_6711683973335778367gmail-m_-5722080102080593776gmail-m_-3484986743293044498gmail-m_1511621906611360877gmail-m_-7344675500667721820gmail-m_-1150862609421837306gmail-Week_1"><span style="font-size:1.17em">Week 7 report</span><font size="2"> </font></span></h3><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial"></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><b>What did you get done this period?</b></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px"><b> </b></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;font-size:14px">- SQLAlchemy is used for storing other datatypes than raster and vector (such as text or CSV) in PostgreSQL [1] [2]</p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">- Unittests test if output data get stored in a SQLite [10] and PostgreSQL [3] [4] [5] databases [9]. Tested output data are vector, raster, text and CSV.</p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">

</p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">- Add CSV as one of data formats available in PyWPS [6]</p>

- Optimize and refactor SQLiteStorage [7] [8] <p></p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">- I did a research on MapServer </p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">- Fixing bugs and some other minor changes and updates to the code [11]</p><p style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><br></p><div style="text-decoration-style:initial;text-decoration-color:initial"><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)"><b>What do you plan on doing next week (period) ?</b></p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)">- Handle metadata<br></p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)">- Establish a connection between MapServer and PostgreSQL</p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)"><br></p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)"><b>Are you blocked on anything?</b></p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)">No.</p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)"><br></p><p style="font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit;color:rgb(37,37,37);font-family:sans-serif;background-color:rgb(255,255,255)"><br></p><p style="font-size:12.8px;color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><font color="#252525" face="sans-serif"><span style="font-size:14px">[0]<span> </span><a href="https://wiki.osgeo.org/wiki/Database_Output_Storage_for_PyWPS" target="_blank" style="color:rgb(17,85,204)">https://wiki.osgeo.org/wik<wbr>i/Database_Output_Storage_for_<wbr>PyWPS</a></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><font color="#252525" face="sans-serif" style="font-size:12.8px;color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-transform:none;white-space:normal;word-spacing:0px"><span style="font-size:14px">[1]<span> </span></span></font><font color="#1155cc"><span style="font-size:14px"><u><a href="https://github.com/janpisl/pywps/commit/652d0dba7906d20260e3cd3b3d5a77b26ea68b86">https://github.com/janpisl/pywps/commit/652d0dba7906d20260e3cd3b3d5a77b26ea68b86</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><font style="font-size:12.8px;color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-transform:none;white-space:normal;word-spacing:0px"><span style="font-size:14px">[2]  </span></font><font color="#1155cc"><span style="font-size:14px"><u><a href="https://github.com/janpisl/pywps/commit/5774cd45cff3ef03fc0ac2739b0821a54405687f">https://github.com/janpisl/pywps/commit/5774cd45cff3ef03fc0ac2739b0821a54405687f</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[3] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/19241b4145522bfddedb3222eaf3fb1c8e7f1fd6">https://github.com/janpisl/pywps/commit/19241b4145522bfddedb3222eaf3fb1c8e7f1fd6</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[4] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/5dadbfbbc1694aecff0418cbbe7a7fd944dd4b57">https://github.com/janpisl/pywps/commit/5dadbfbbc1694aecff0418cbbe7a7fd944dd4b57</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[5] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/d260694eb49a867aa4163c9624afb55cebba6665">https://github.com/janpisl/pywps/commit/d260694eb49a867aa4163c9624afb55cebba6665</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[6] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/256adac2d6025371650870e36735f17ac6009f40">https://github.com/janpisl/pywps/commit/256adac2d6025371650870e36735f17ac6009f40</a></u></span></font></p><p style="text-align:start;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[7] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/7943139e277ff20d3f71c53c85ee7fbf93d83056">https://github.com/janpisl/pywps/commit/7943139e277ff20d3f71c53c85ee7fbf93d83056</a></u></span></font></p></div>



<p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[8] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/c9d35bfbc1d2fafb81c202aefde1c571740fa73a">https://github.com/janpisl/pywps/commit/c9d35bfbc1d2fafb81c202aefde1c571740fa73a</a></u></span></font></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[9] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/78c0d672b1a64d2da504ceb5841004dd054d9417">https://github.com/janpisl/pywps/commit/78c0d672b1a64d2da504ceb5841004dd054d9417</a></u></span></font></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><span style="font-size:12.8px">[10] </span><font color="#1155cc"><span style="font-size:12.8px"><u><a href="https://github.com/janpisl/pywps/commit/7f09a56cfc6104a8d838c5e965d08b8da8d28415">https://github.com/janpisl/pywps/commit/7f09a56cfc6104a8d838c5e965d08b8da8d28415</a></u></span></font></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit">

<span style="color:rgb(37,37,37);font-family:sans-serif;font-size:14px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">[11] </span><a href="https://github.com/janpisl/pywps/commits/master" style="color:rgb(17,85,204);font-family:sans-serif;font-size:14px">https://github.com/janpisl/pywps/commits/master</a><br class="gmail-Apple-interchange-newline">

<br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><br></p><p style="text-decoration-style:initial;text-decoration-color:initial;margin:0.5em 0px;line-height:inherit"><br></p>

<br></div>