Barcelona-Tech-Center-ITU/gmst_awsdocker_demo

Giga Mobile Simulation Tool - Apache Superset dashboard for visualizing Rwanda school connectivity and cell tower coverage data with PostGIS geospatial queries # Giga Mobile Simulation Tool (MST) A Dockerized Apache Superset deployment for visualizing Rwanda school connectivity and cell tower coverage data using PostGIS for geospatial queries. ## Overview The Giga Mobile Simulation Tool provides interactive dashboards and map visualizations for analyzing: - School locations with connectivity attributes - Cell tower positions and radio types (2G/3G/4G) - Coverage polygons and connectivity gaps ## Architecture ``` ┌─────────────────────────────────────────────────────────────┐ │ Docker Compose Stack │ ├──────────────┬──────────────┬──────────────┬────────────────┤ │ superset │ celery_worker│ celery_beat │ database │ │ (app) │ (async tasks)│ (scheduler) │ (PostGIS) │ ├──────────────┴──────────────┴──────────────┼────────────────┤ │ metadata_db (Postgres 16) │ redis │ └────────────────────────────────────────────┴────────────────┘ ``` ## Quick Start ### Prerequisites - Docker & Docker Compose - Git ### 1. Clone the Repository ```bash git clone github.com cd mst ``` ### 2. Configure Environment Variables Copy the template files and fill in your values: ```bash cp env/.superset.env.template env/.superset.env cp env/.database.env.template env/.database.env cp env/.metadata.env.template env/.metadata.env ``` Edit each file with your configuration (passwords, API keys, etc.) ### 3. Initialize Superset (First Time Only) ```bash docker compose -f compose.init.yaml up --build ``` This will: - Create the admin user - Run database migrations - Load example dashboards (only once; subsequent init runs skip because a marker is written in the persisted `superset_home` volume) ### 4. Start the Application ```bash docker compose up --build -d ``` Access Superset at: **http://localhost:8088** ## Services | Service | Port | Description | |---------|------|-------------| | superset | 8088 | Main web appl …