Google Summer of Code 2019

Enhancing the pgAdmin4 geometry viewer

Mentors: ​Victoria Rautenbach and Frikan Erwee

During the 2018 GSoC, Xuri Gong developed a geometry viewer for pgAdmin4. The new geometry viewer was released as part of pgAdmin from pgAdmin4 v3.3 (​read more here). The viewer allows the user to view geometires directly in pgAdmin, which was not possible previously . The report from 2018 GSoC is available ​here.

We have asked the community for ideas and suggestion to improve the geometry viewer. The mailing thread is available ​here. The main ideas for improvements or new functionalities are as follows:

• Shapefile loader plugin for pgAdmin4
• Overlay queries
• ​Highlight geometries
• ​Basic styling of the features on the map
• Events, such as mouse over, to show attributes
• Optimising for large data sets, for example, drawing only a subset
• Rendering of raster queries
• Other requests in the email thread

Languages and APIs: Python, JavaScript and JavaScript APIs such as, require.js, bootstrap and Leaflet.