Google Summer of Code 2018

pgAdmin4 plugin for viewing data

Mentors: ​Victoria Rautenbach and Frikan Erwee

​pgAdmin graphical user interface (GUI) administration tool for ​PostgreSQL that allows you to execute spatial queries using ​PostGIS on geospatial data. Currently, there is no integrated geospatial data viewer in pgAdmin and external applications, such as ​QGIS, are required. For this project, you will develop a GUI that allows users to view the tables in a spatial database and the results of queries executed as geometries. Also, refer to ​this page for more detail on the project.

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

Test for potential students:

Task 1: Write a Python program to construct an array by repeating the values within the original array three times.

Expected Output:

Original array [1, 2, 3, 4]

Repeating 2 times [1 2 3 4 1 2 3 4]

Repeating 3 times [1 2 3 4 1 2 3 4 1 2 3 4]

Task 2: Create a basic web map using OpenLayers displaying JSON layer, also ensure that you bootstrap the page. You can use any open data JSON layer, for example, datasets from the World Bank Open Data Portal.