🦖 PaleoMapa - Interactive Paleontological Visualization System

PaleoMapa is an interactive web application for visualization, exploration, and management of paleontological data in Portugal. Developed with an educational and scientific focus, it integrates geospatial data with advanced filtering, geographic contextualization, and administration features.

🔗 Visit Online

Main Features

• Interactive Map with visualization of fossils, archaeological sites, and points of interest.
• Advanced Filtering by geological age, fossil type (species, family, order, genus, etc.), and distance radius.
• Admin Panel for inserting, editing, and removing paleontological records and contact requests.
• Geographic Contextualization with museums, parks, cafés, and rest areas.
• Automated Import of paleontological data (Excel).
• Automated Export of paleontological data (SQL, Excel, CSV).
• Isochrone Calculation (travel time by foot, bicycle, or car - 5, 10, 15 minutes).
• Custom Layers with dynamic toggling.

Screenshots

Tech Stack

Frontend:

• OpenLayers
• Turf.js
• HTML, CSS, JavaScript

Backend:

• PHP (API)
• PostgreSQL (PostGIS and PgRouting extensions)

Other:

• QGIS (geodata pre-processing)
• Deck.gl (data visualization)

Architecture

Use Case Diagram

Concept Diagram

Database Diagram

Prototypes

View the low-fidelity Figma prototype here: Low-Fidelity Prototype

View the high-fidelity Figma prototype here: High-Fidelity Prototype

Installation

1. Clone repository

git clone https://github.com/ratmir-mukazhanov/paleomapa
cd paleomapa

2. Create PostgreSQL database and enable PostGIS and PgRouting extensions

PostGIS e PgRouting
psql -U your_user -c "CREATE DATABASE paleomapa;"
psql -U your_user -d paleomapa -c "CREATE EXTENSION postgis;"

Make sure to replace your_user with your actual PostgreSQL username and you have PostgreSQL installed and running.

3. Import data into PostgreSQL

psql -U teu_utilizador -d paleomapa -f data/import.sql

4. Move the project files to your web server directory
5. Iniciar o servidor (Apache + PostgreSQL) com XAMPP, Laragon, etc.

Credits

Our team is composed of dedicated students from the University of Aveiro:

• Gustavo Gião — Team Lead
• Ratmir Mukazhanov
• Filipe Rocha
• Diogo Simão

We would like to thank our professors Luís Jorge Gonçalves (Escola Superior de Tecnologia e Gestão de Águeda) and Rute Lourenço Coimbra (Departamento de Geociências da Universidade de Aveiro) for their guidance and collaboration throughout this project.

Data Source

The paleontological database used in this project was obtained from:

• The Paleobiology Database
• Sample data provided by the Departamento de Geociências da Universidade de Aveiro

All data rights belong to their respective owners.

License

This project is licensed under the MIT License.

Consult the LICENSE file for more details.