SIH BBWS Citanduy

DAFTAR POS DUGA AIR
SELECT m_lokasi.*, m_debit.*,m_bbws.nama_bbws, CASE WHEN ((m_lokasi.WLevel/100)+m_debit.nilai_a) < 0 THEN FORMAT(m_debit.nilai_c * POW(0, LEAST(m_debit.nilai_b, 1023)),2) ELSE FORMAT(m_debit.nilai_c * POW(((m_lokasi.WLevel/100)+m_debit.nilai_a), LEAST(m_debit.nilai_b, 1023)),2) END AS 'debit' FROM m_lokasi LEFT JOIN m_bbws ON m_bbws.id_bbws = m_lokasi.id_bbws LEFT JOIN m_debit ON m_debit.id_lokasi = m_lokasi.id_lokasi WHERE m_lokasi.id_bbws IN ('8') AND m_lokasi.id_tipe = 'PDA' AND m_lokasi.status_lokasi=1 ORDER BY m_lokasi.SamplingDate DESC, m_lokasi.SamplingTime DESC
NO LOKASI SUNGAI TANGGAL JAM TMA(cm) DEBIT (m³/s) PENGELOLA
1 BINANGUN CISEEL 08/04/25 04:46 138 23.68 BBWS Citanduy
2 BEBEDAHAN CIJOLANG 08/04/25 04:48 96 17.37 BBWS Citanduy
3 BUNAR CILEUEUR 08/04/25 04:46 53 6.40 BBWS Citanduy
4 CIBEKA CIMUNTUR 08/04/25 04:45 167 46.73 BBWS Citanduy
5 BATUNUNGGUL CIMUNTUR 08/04/25 04:45 308 69.04 BBWS Citanduy
6 STINGGIL CIMENENG 08/04/25 04:40 66 14.82 BBWS Citanduy
7 CUKANGLEULEUS CIKAWUNG 08/04/25 04:37 362 148.59 BBWS Citanduy
8 CIRAHONG CITANDUY 08/04/25 04:30 470 173.25 BBWS Citanduy
9 SITUBATU CIKEMBANG 07/04/25 14:25 92 13.60 BBWS Citanduy
10 CIAWITALI CISEEL 07/04/25 11:19 266 240.03 BBWS Citanduy
11 PITULASI CIKAWUNG 06/04/25 17:30 126 BBWS Citanduy
12 BENDMANGANTI CITANDUY 06/04/25 17:30 0 0.00 BBWS Citanduy
13 CIPUTRAHAJI CIPUTRAHAJI 06/04/25 17:30 212 BBWS Citanduy
14 GUNUNG CUPU CITANDUY 06/04/25 17:30 77 0.00 BBWS Citanduy
15 PATARUMAN CITANDUY 02/04/25 18:00 174 168.01 BBWS Citanduy
16 BOJONGSALAWE CITANDUY 26/03/25 00:33 23 7.79 BBWS Citanduy
Normal  Siaga 3  Siaga 2  Siaga 1