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.

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.