Final Report: Implement Geospatial Data Viewer in pgAdmin4 for PostGIG

• Title: Implement Geospatial Data Viewer in pgAdmin4 for PostGIS
• Organization: ​OSGeo
• Mentors: ​Victoria Rautenbach and Frikan Erwee
• Student: Xuri Gong, Peking University
• GSoC Proposal: ​Proposal for GSoC 2018.pdf
• Result: ​patch has been sent

Status Before GSoC

​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.