= Final Report: Implement Geospatial Data Viewer in pgAdmin4 for PostGIG =

* **Title:** Implement Geospatial Data Viewer in pgAdmin4 for PostGIS
* **Organization:** [https://www.osgeo.org/ OSGeo]
* **Mentors:** [http://www.up.ac.za/en/centre-for-geoinformation-science/article/2060495/victoria-rautenbach Victoria Rautenbach] and Frikan Erwee
* **Student:** Xuri Gong, Peking University
* **GSoC Proposal:** [https://trac.osgeo.org/postgis/raw-attachment/wiki/GeospatialDataViewerInPgAdmin4ForPostGIS/Proposal%20for%20GSoC%20%202018.pdf Proposal for GSoC 2018.pdf]
* **Result:** [https://www.postgresql.org/message-id/CAA7HE_fnAKtAqfzz2jNZGfYnB5BAcuSt_ZCsJ%2Be-nwFPDHCdxg%40mail.gmail.com patch has been sent]
== Status Before GSoC

[https://www.pgadmin.org/ pgAdmin] is the GUI management tool for PostgreSQL. The latest version pgAdmin4 is web-based and written in Python and jQuery with Bootstrap, using the Flask framework. But currently there is no geospatial data viewer in pgAdmin4-3.1, and external applications, such as QGIS are required if we want to  browser the data in a map. It’s not convenient for users to view geometries directly in pgAdmin4 “Data Output” table panel.

== My Proposal And Work.

I propose to implement a geospatial data viewer in pgAdmin4 that will allow users to view the tables in a spatial database and the results of queries executed. With the viewer I intend to develop, users can directly view geospatial data on a map within the pgAdmin4 GUI.

Now users can view individual geometry and the whole output geometries in the map. They can also view the properties directly by clicking the geometry.

[[Image(https://trac.osgeo.org/postgis/raw-attachment/wiki/GeospatialDataViewerInPgAdmin4ForPostGIS_FinalReport/screenshot_1.png, 600px)]]