Development of a Geospatial Web Portal

Project Description

This was my final project for the Markup Languages and Geoinformation on the Web courses, completed during my specialization in Geomatics. A web portal was implemented to facilitate the registration and classification of mass movements (MM) in the city of Cali, Colombia

Selected Topic: In response to the final evaluation report on vulnerability and risk by Mass Movement (MM) in Cali (Corporación OSSO, 2016), which highlighted the need to construct an inventory for registration and classification of MM, a portal was developed following those guidelines.

Methodology

A PostgreSQL database was built with PostGIS support and CRUD operations. Shapefiles for MM susceptibility zoning, population centers, districts, and geology were imported into the database.

A table was added for reporting movements, with fields automatically populated via triggers that execute SQL queries (testing for intersection, containment, and distance relative to the spatial layers). Additionally, another table was created for user management and logging, with different roles for administrator, web user, and registered user.

The geoportal was designed using HTML, CSS, and JavaScript (with jQuery on the client side) and PHP on the server side. The interface included multiple layers: WMS layers from IDESC for the base map, along with additional layers uploaded, styled, and served from Geoserver.

A login and registration form with basic validations and sensitive data encryption was also implemented.

A UML diagram of the project and the corresponding database schema were created:

Moreover, the portal includes:

• MM report form
• Login/registration form
• Interactive map visualization and dynamically generated graphs
• Various plugins and libraries (Leaflet for maps, Chart.js for graphs) for functionalities like data clustering, measurement tools, and coordinate readouts.
• A fully implemented CRUD for user management with different roles.

Finally, a reporting form was integrated to allow for the creation of activity records.

The final database, containing the inventory data, was also established.

You can check the repository here: Geovisor Repository.