<div dir="ltr"><div><div style="font-family:arial,sans-serif"><div>Hello,</div><div><br></div><div>Please find the GSOC week #11 report as follow.</div></div><div style="font-family:arial,sans-serif"><br></div><div style><font face="arial, sans-serif" style="font-family:arial,sans-serif">Report URL - </font><font face="arial, sans-serif"><a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%2311">https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%2311</a></font></div>
</div><div><br></div><div><p style="margin-right:0px;margin-bottom:15px;margin-left:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px;margin-top:0px!important">
<strong>Weekly Report (27th July to 2nd August) -<br><br></strong></p><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<strong>Aim</strong> - Implement the spatial filter functions for the module.</p><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<strong>Things, I have done this week</strong></p><ul class="" style="padding:0px 0px 0px 30px;margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<li>Completed the query for <strong>Spatial Operators</strong></li><li>Made the list of all functions which we are going to provide to user, as well as divide them into different categories based on inputs/outputs</li><li>
Wiki page - <a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/List-of-spatial-functions" style="color:rgb(65,131,196);text-decoration:none;background:transparent">List of spatial functions</a></li>
<li><del>Modified the query to add additional field in the select statement but couldn't figure out, how to get derived field value as results</del>.</li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<strong>Mentor Suggestions</strong></p><ul class="" style="padding:0px 0px 0px 30px;margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<li>We will stay focused on filtering area and work on other means of geometry input for geometry B. For example, using the geometry from other nodes as input.</li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<strong>Things to do next week</strong></p><ul class="" style="padding:0px 0px 0px 30px;margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<li>Add the existing PostGIS field to user input form and enable them for query.</li><li>Add more filter functions to module.</li><li>Testing for existing functionality.</li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<strong>Reference Modules/Files</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px">
<li>Add Field - <code style="font-family:Consolas,'Liberation Mono',Menlo,Courier,monospace;margin:0px;border:1px solid rgb(221,221,221);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;padding:0px;background-color:rgb(248,248,248)">$this->query->add_field($table_name, $field_name, $alias = '', $params = array());</code></li>
<li><a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/List-of-spatial-functions" style="color:rgb(65,131,196);text-decoration:none;background:transparent">List of spatial functions</a></li><li>
<a href="http://postgis.net/docs/manual-2.0/reference.html" style="color:rgb(65,131,196);text-decoration:none;background:transparent">PostGIS Reference Manual</a></li><li><a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/blob/20964232f29365a6ff28f54c11b09244936f9eec/cartaro/profiles/cartaro/modules/contrib/postgis/views/postgis_views_handler_filter_geometry.inc" style="color:rgb(65,131,196);text-decoration:none;background:transparent">postgis_views_handler_filter_geometry.inc</a></li>
</ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px"><strong>Am I blocked on anything ?</strong></p>
<p style="margin-top:15px;margin-right:0px;margin-left:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif,'Segoe UI Emoji','Segoe UI Symbol';line-height:25.5px;margin-bottom:0px!important">
No.</p></div><div><br></div><br clear="all"><div><div dir="ltr"><div><font face="arial, helvetica, sans-serif" color="#000000">--</font></div><div><font face="arial, helvetica, sans-serif" color="#666666">Regards,</font></div>
<div style="text-align:left"><font face="arial, helvetica, sans-serif" color="#073763"><b>Naveen Panwar</b></font></div><div style="text-align:left"><div style="color:rgb(102,102,102);font-family:arial,helvetica,sans-serif">
<span style="text-align:-webkit-auto">IIIT-Hyderabad, India.</span><br></div></div><div style="text-align:left"><span style="text-align:-webkit-auto;background-image:initial"><font face="arial, helvetica, sans-serif" color="#666666"><div>
+91-9030736015</div><div><br></div></font></span></div><div style="text-align:left"><div><span style="background-color:rgb(255,255,255)"><font face="arial, helvetica, sans-serif" color="#3d85c6"><a href="http://lsi.iiit.ac.in/naveen.panwar" target="_blank">http://lsi.iiit.ac.in/naveen.panwar</a></font></span></div>
<div><span style="background-color:rgb(255,255,255)"><font color="#999999"><br></font></span></div><div><span style="background-color:rgb(255,255,255)"><br></span></div></div></div></div>
</div>