Near Real-time Earthquake Dashboard with Automated ETL Pipeline

🌎 This project delivers a near real-time dashboard to monitor global earthquakes. The data is extracted from the USGS GeoJSON API, enriched with geolocation details using BigDataCloud’s Reverse Geocoding API, and stored in MySQL. A Flask application automates the pipeline, driven by Windows Task Scheduler every minute. Tableau provides a live, interactive dashboard, refreshed to reveal earthquake patterns in a clear, storytelling format.

🌎 Earthquakes are a growing concern, even for Malaysia. In 2025, a 7.7-magnitude quake near Mandalay, Myanmar, shook Thailand, damaging structures. This dashboard highlights that seismic risks are closer than they seem. It displays earthquake locations, magnitudes, and trends, enabling Malaysians to stay informed and prepared for potential future risks in the region.

🌎 The pipeline starts with the USGS API, fetching fresh earthquake data every minute. BigDataCloud’s reverse geocoding adds details like continent, country, and state. Flask processes and stores the data in MySQL, with Task Scheduler ensuring continuous automation. Logs track pipeline activity for reliable monitoring. The result is a robust dataset, ready for visualization.

🌎 Tableau connects directly to MySQL, transforming data into maps, timelines, and charts. A simple refresh updates the dashboard, presenting insights in a storytelling style. This makes earthquake trends accessible to researchers, officials, or anyone seeking clarity on seismic activity.

🌎 This project transforms raw feeds into insights. It’s a wake-up call to notice earthquake risks and stay informed. From API to dashboard, it blends automation and visuals to make seismic data accessible, empowering everyone to understand and prepare for what’s next.

Tech Stack:
- Data Collection and ETL: Python, USGS GeoJSON API, BigDataCloud Reverse Geocoding API
- Backend and Automation: Flask, Windows Task Scheduler, Batch Scripting, File-based logging
- Database: MySQL (managed with MySQL Workbench)
- Data Visualization: Tableau
- Technique: API Integration, Data Engineering, Live Data Visualization