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.
Test for potential students:
Task 1: Write a Python program to construct an array by repeating the values within the original array three times.
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.