<div dir="ltr"><div style="font-family:arial,sans-serif"><div>Hello,</div><div><br></div><div>Please find the GSOC week #10 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-%2310">https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%2310</a></font></div>
<div style="font-family:arial,sans-serif"><font face="arial, sans-serif"><br></font></div><div style="font-family:arial,sans-serif"><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 (20th July to 26th July) -<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>Tested the query function for the remaining operations like: ST_Within, ST_Covers, ST_Overlaps etc..</li><li>Geometry validation by adding <a href="http://postgis.refractions.net/documentation/manual-1.4/ST_IsValid.html" style="color:rgb(65,131,196);text-decoration:none;background:transparent">ST_IsValid</a> in where clause of query.</li>
<li>Added more spatial relationship function to module like: ST_Crosses, ST_CoveredBy, ST_ContainsProperly.</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">
<a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%2310#Revised%20Plan" style="color:rgb(65,131,196);text-decoration:none;background:transparent"><strong>Revised Plan/Timeline</strong></a></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>Week 11 - Building query for <strong>Spatial Measurements</strong> and <strong>Operators</strong>.</li>
<li>Week 12 - Building query for specific functions for <strong>Geometry Accessors</strong> and <strong>Geometry Editors</strong>.</li><li>Week 13 - Testing the all functionality of View module.</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>Approach</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">There are two ways to provide all spatial functions/operations to users.</p>
<ol 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><p style="margin:15px 0px">
<strong>Categorization</strong></p><ol class="" style="padding:0px 0px 0px 30px;margin:0px;list-style-type:lower-roman"><li>We can categorize all functions/operations according the <a href="http://postgis.net/docs/manual-2.0/reference.html#Spatial_Relationships_Measurements" style="color:rgb(65,131,196);text-decoration:none;background:transparent">PostGIS Reference</a> and make different input forms to access them.</li>
<li>Once user select the category then he will get the list of all available functions/operations in that particular category and customized input form.</li><li>Example<ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>Drop-down for list of categories.</li><li>Spatial Measurements<ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li>ST_Area, ST_Azimuth, ST_Centroid etc..</li></ul></li><li>Spatial Relationships<ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>ST_Equals, ST_Touches, ST_Within etc..</li></ul></li><li>Respective input form</li></ul></li></ol></li><li><p style="margin:15px 0px"><strong>Query Builder</strong></p><ol class="" style="padding:0px 0px 0px 30px;margin:0px;list-style-type:lower-roman">
<li>We can provide the list of all available functions/operations at once and a common form to take the all possible inputs.</li><li>Once user submit this form then based on his selected function we will consider only particular fields values associate with it and build the query.</li>
<li>Example form<ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li>List of all functions</li><li>Choose PostGIS field drop-down</li><li>Input Geometry B data</li><li>Extra Value (like: distance for ST_DWithin function etc..)</li>
</ul></li></ol></li></ol><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>Select one out of two approaches and modified the code accordingly.</li>
<li>Complete the query functionality for all <strong>Spatial Measurements</strong> and <strong>Operators</strong>.<br></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><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 style="font-family:arial,sans-serif"><font face="arial, sans-serif"><br></font></div><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>