<div dir="ltr"><div><div style="font-family:arial,sans-serif">Hello,</div><div style="font-family:arial,sans-serif"><br></div><div style="font-family:arial,sans-serif">Please find the GSOC week #3 report as follow.</div></div>
<div style="font-family:arial,sans-serif"><br></div><div style="font-family:arial,sans-serif">Report URL - <a href="https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%233">https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%233</a><br>
</div><div style="font-family:arial,sans-serif"><br></div><div style="font-family:arial,sans-serif"><strong style="color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;line-height:25.5px">Weekly Report (1st June to 7th June) -</strong><br>
</div><div style="font-family:arial,sans-serif"><strong style="color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;line-height:25.5px"><br>Aim</strong><span style="color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;line-height:25.5px"> - Prepare the technical design pipeline for PostGIS view module.</span><br>
</div><div style="font-family:arial,sans-serif"><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;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;line-height:25.5px">
<li>Understood the current implementation of geometric field display in Cartaro.<ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li><strong>Available pipeline</strong> -<ol class="" style="padding:0px 0px 0px 30px;margin:0px;list-style-type:lower-alpha">
<li>PostGIS (To store the raw geometric data)</li><li>Geo-Server (To prepare geometric layer[WMS])</li><li>OpenLayers (To display WMS layer)</li></ol></li><li><strong>Proposed pipeline</strong> -<ol class="" style="padding:0px 0px 0px 30px;margin:0px;list-style-type:lower-alpha">
<li>PostGIS</li><li>View Module - Build the spatial query, execute the query, get the data and pass it to OpenLayers using handler.</li><li>OpenLayers<br></li></ol></li></ul></li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;line-height:25.5px">
<strong>Technical Design for Module (folder structure and class description)</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;line-height:25.5px">
<li><p style="margin:15px 0px"><strong>postgis/</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li>postgis.openlayers.inc - Provides hooks for integration with OpenLayers.</li></ul></li><li><p style="margin:15px 0px">
<strong>postgis/views/</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li>postgis.views.inc - Hooks for views integration. A class that contain all of the data to generate a view, plus the member functions to build the view query, execute the query and render the output.</li>
<li>postgis_views_handler_filter_geometry.inc - Provide filter for geo-spatial data.<br></li></ul></li><li><p style="margin:15px 0px"><strong>postgis/views/handlers/</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>Implement all handlers which are needed. like: sort, field, argument proximity, filter etc.</li></ul></li><li><p style="margin:15px 0px"><strong>Available filter</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>'ST_Contains', 'ST_Intersects', 'ST_Disjoint'</li></ul></li><li><p style="margin:15px 0px"><strong>Plugin</strong> -</p><ul class="" style="padding:0px 0px 0px 30px;margin:0px"><li>/plugins/geoserver/layer_types/geoserver_layer_type_postgis_field.inc - GeoServer layer type for PostGIS fields. [Contain select query]</li>
</ul></li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;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;line-height:25.5px">
<li>Working on relationship plugin.</li><li>Understand how exactly view module query on Postgres DB and pass the result to OpenLayers.</li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;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;line-height:25.5px"><li>Geofield - <a href="https://drupal.org/project/geofield" style="color:rgb(65,131,196);text-decoration:none">https://drupal.org/project/geofield</a><ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>geofield.views.inc</li><li>geofield.openlayers.inc</li><li>/handlers/geofield_handler_filter.inc</li><li>/handlers/geofield_handler_argument_proximity.inc</li></ul></li><li>View - <a href="https://drupal.org/project/views" style="color:rgb(65,131,196);text-decoration:none">https://drupal.org/project/views</a><ul class="" style="padding:0px 0px 0px 30px;margin:0px">
<li>view.inc</li></ul></li></ul><p style="margin:15px 0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;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;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"><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>