<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Rahul,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Not sure if Victoria hangs out on dev or not. I've cc'd her and also PostGIS Users of your interest.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I also cc'd Dave in case he has any words of wisdom to share. (Dave sorry for the call out but thought you might be interested in this since it's desired it could be integrated in pgAdmin4 </span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> ).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Looks like you have made progress already. I'm very excited at the thought of having a spatial viewer in pgAdmin4.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Rahul Soshte<br><b>Sent:</b> Friday, March 09, 2018 3:09 PM<br><b>To:</b> postgis-devel@lists.osgeo.org; discuss@lists.osgeo.org<br><b>Subject:</b> [postgis-devel] GSOC Postgis Project<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><div><div><div><div><div><div><div><p class=MsoNormal style='margin-left:.5in'>Hi,<o:p></o:p></p></div><p class=MsoNormal style='margin-left:.5in'><br>I am Rahul Soshte,a 3rd Year Computer Engineering Student from Mumbai University.<o:p></o:p></p></div><p class=MsoNormal style='margin-left:.5in'><br>I quite liked the idea of a Spatial Query viewer for pgadmin4 which would be a quick handy tool for viewing the output of the geospatial queries which is mentioned <a href="https://trac.osgeo.org/postgis/wiki/GoogleSummerCode2018">here</a>.<o:p></o:p></p></div><p class=MsoNormal style='margin-left:.5in'><br>I am willing to contribute to this organization by Leveraging my efforts for this GSOC project.<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'><br>I have solved the 2 Tasks mentioned in the <a href="https://trac.osgeo.org/postgis/wiki/GoogleSummerCode2018">link</a> which were the tasks for potential GSOC students and the output and code of both the tasks are attached hereby.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>Code:<a href="https://github.com/rahul-soshte/gsoctaskspostgis">https://github.com/rahul-soshte/gsoctaskspostgis</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'>For the Task 2----->I have used OpenLayers and displayed a JSON layer by procuring data from here.<br><br><a href="https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/significant_month.geojson">https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/significant_month.geojson</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>which is data about earthquakes in the past month over the world.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'>For the next step I will be setting up my development environment for the project.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>Regards,<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'>Rahul Soshte<br>(<a href="https://rahul-soshte.github.io/">Here's a 'brief' and 'plain' description of myself</a>)<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'><o:p> </o:p></p></div></div></div></body></html>