Disaster Risk Reduction & Emergency Command
Interactive spatial monitoring for Silay City, Negros Occidental. Powered by live USGS Philippine seismic feeds, OpenStreetMap emergency facility discovery, multilingual Tagalog/Hiligaynon translation, and Voice-enabled Gemini AI.
π Live Philippine Seismic Monitor (USGS API)
Real-time earthquake events (magnitude 3.0+) across Negros Occidental & the Philippine archipelago.
Voice & AI Assistant
Speak or type emergency questions with Web Speech & Gemini AI.
Hazard & Seismic Map
Spatial risk zones + live USGS earthquake epicenter plotting.
Multilingual Translator
Translate CDRRMO advisories (English β Tagalog / Hiligaynon).
Evacuation & Hospitals
OSRM road routing, GPS barangay lookup & live Overpass hospitals.
Go-Bag & Family QR Pass
Preparedness checklist + instant scannable QR evacuee ID pass.
SQL Database
Complete relational database schema & live QR accounts table.
ποΈ NEXA Voice & AI Disaster Assistant
Ask any disaster readiness question for Silay City. Use the ποΈ Speak button for hands-free voice input or π Read Aloud for audio playback.
πΊοΈ Hazard Risk & Live Seismic Visualizer Β· Silay City
Interactive spatial hazard visualizer with barangay risk zones and live USGS Philippine earthquake epicenters.
π Multilingual Emergency Advisory Translator Β· MyMemory API
Free Public API (Optional Custom API Token Supported). Translate Silay CDRRMO emergency warnings between English, Tagalog, and Hiligaynon so every Silaynon resident understands advisories clearly.
π§ Evacuation Spatial Routing & Live Emergency Facilities
Powered by OSRM Street Routing, Nominatim GPS-to-Barangay Reverse Geocoding, and Overpass API (Hospitals, Fire & Police Stations).
πͺͺ Family Evacuee Digital QR Pass (QRServer API)
Generate a scannable QR code pass for rapid family check-in at Silay City evacuation shelters. All generated passes are automatically saved to the database users table.
Juan Dela Cruz β Barangay Balaring
4 Members | Blood: O+ | No Allergies
Saved to database users table. Present this QR code to Silay CDRRMO personnel upon arrival.
π Family Preparedness & Go-Bag Tracker
Check off emergency items to measure household readiness. Progress is saved automatically.
ποΈ NEXA Relational Database & QR Accounts Console
Complete relational database schema and live interactive records table. Every family QR pass generated in the app is automatically inserted here.
Table: users (Live QR Pass Registrations)
These records are populated in real-time whenever a resident creates a Family QR Pass.
Table: evacuation_centers
| center_id | center_name | barangay | capacity | status |
|---|---|---|---|---|
| 1 | Silay City Hall Evacuation Center | Poblacion 1 | 1,200 | Open |
| 2 | Silay City Central School | Barangay 3 | 850 | Open |
| 3 | Silay City Sports Complex | Barangay 5 | 2,000 | Open |
| 4 | Balaring Covered Court | Balaring | 500 | Standby |
π Project Review & Database Architecture Matrix
Technical summary of integrated zero-key public APIs and relational database persistence for Silay City DRRM project review.
| # | Service / Module | Integration Purpose | Status |
|---|---|---|---|
| 1 | Relational Database (`users` & `centers`) | Persistent storage for generated family QR accounts and shelter telemetry | β Live & Connected |
| 2 | Three.js Engine | Interactive Silay City tactical globe & radar | β WebGL Active |
| 3 | Google Gemini + Web Speech API | Voice-enabled AI Assistant & audio readout | |
| 4 | USGS Earthquake API | Live Philippine seismic telemetry (100% Free) | β Live GeoJSON Active |
| 5 | MyMemory Translation API | English β Tagalog / Hiligaynon alert translator | β Active |
| 6 | Overpass & Nominatim API | Live Silay hospitals/fire stations & GPS barangay lookup | β Active (No Key) |
| 7 | QRServer & OSRM Routing | Scannable Family QR Passes & street evacuation routes | β Active (No Key) |
βοΈ API Credentials & Optional Tokens
All core features work out-of-the-box. You can input custom API keys below.