Re: GSoC-Improvements in my Ideas for Geospatial Query Viewer for pgAdmin4

Dear Rahul

Thank you for the email and looking into the project a bit more. As you
know, the projects proposals are still being reviewed and the results will
be published by Google on 23 April. Thanks again for submitting a project
proposal and the enthusiasm.

Regards
Victoria

On Tue, Apr 17, 2018 at 6:28 PM, Rahul Soshte <rahulsoshte360(at)gmail(dot)com>
wrote:

> Hi,
>
> I had earlier proposed to use 'Layers' functionality where a query
> containing PostGIS Geometry/Geography will be converted to a Seperate Layer
> for the MapView while building a GeoSpatial Query Viewer.
>
> My Proposal Link,
>
> <http://goog_1461466975>
> https://docs.google.com/document/d/1WN3FPpLudNNXLWQgGlP91yDAMe7D0
> DC8gTBhdyrI_aw/edit
>
> I recently came across a Redmine ticket whose link is given as follows.
> https://redmine.postgresql.org/issues/1407
>
> Which is a Feature #1407 which was added about 2 years ago
> Which mentions
> 1)Switching between the resultset grid and the MapView.
> 2)A parser in Javascript
> 3)Using OpenLayers
>
> Considering the above points I would like to Improve the idea further by
> not going ahead with the "Layer Functionality" but with the following
> procedure and thus decreasing the ambiguity in the way of achieving the
> goal of the project,
>
> 1) Addition of a Panel for MapView in the resultset grid
>
>
>
> 2) pgAdmin4 uses a library called jQuery-contextMenu.
> For rendering a geometry column user will able select the column,User will
> open a contextMenu like in this image.
>
>
> He will have option of 'Render in MapView'
> Now when we switch to the MapView Panel we can see the ouput.
>
> Also in the MapView Panel we can give the options of selecting the
> particular geometry/geography columns the User want to Render.
>
> 3)After deciding on the columns to render, the data will be converted to
> GeoJSON format by using JavaScript and Ajax.
>
> This data will be displayed using OpenLayers in the MapView Panel.
>
> This I feel is doable , achievable within a span of 3 month(Refer GSoC
> Timeline) along with Testing of the code.
>
> Regards,
> Rahul Soshte ( Hunter )
>
>
>
>