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

From: Rahul Soshte <rahulsoshte360(at)gmail(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, soc(at)lists(dot)osgeo(dot)org
Cc: Frikan Erwee <ferwee(at)gmail(dot)com>, Victoria Rautenbach <victoria(dot)rautenbach(at)gmail(dot)com>
Subject: GSoC-Improvements in my Ideas for Geospatial Query Viewer for pgAdmin4
Date: 2018-04-17 16:28:13
Message-ID: CAKyzeV1V1c_=KfLLxnzF7-fXWKLBiGgru1tz_+XRDXJWJ=nbVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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,

<goog_1461466975>
https://docs.google.com/document/d/1WN3FPpLudNNXLWQgGlP91yDAMe7D0DC8gTBhdyrI_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 )

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Victoria Rautenbach 2018-04-17 16:56:22 Re: GSoC-Improvements in my Ideas for Geospatial Query Viewer for pgAdmin4
Previous Message Chris Marx 2018-04-17 16:17:43 Re: pgAdmin 3.0 builds