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 11/04/25 04:56 190 37.06 BBWS Citanduy
2 CUKANGLEULEUS CIKAWUNG 11/04/25 04:56 301 112.60 BBWS Citanduy
3 CIRAHONG CITANDUY 11/04/25 04:55 537 222.61 BBWS Citanduy
4 CIBEKA CIMUNTUR 11/04/25 04:55 167 46.73 BBWS Citanduy
5 BATUNUNGGUL CIMUNTUR 11/04/25 04:55 348 81.80 BBWS Citanduy
6 PATARUMAN CITANDUY 11/04/25 04:53 193 211.07 BBWS Citanduy
7 CIAWITALI CISEEL 11/04/25 04:53 252 215.17 BBWS Citanduy
8 BUNAR CILEUEUR 11/04/25 04:51 49 5.79 BBWS Citanduy
9 BEBEDAHAN CIJOLANG 11/04/25 04:51 92 16.17 BBWS Citanduy
10 STINGGIL CIMENENG 11/04/25 04:50 122 36.76 BBWS Citanduy
11 PITULASI CIKAWUNG 10/04/25 21:40 111 BBWS Citanduy
12 CIPUTRAHAJI CIPUTRAHAJI 10/04/25 21:40 205 BBWS Citanduy
13 GUNUNG CUPU CITANDUY 10/04/25 21:40 71 0.00 BBWS Citanduy
14 BENDMANGANTI CITANDUY 10/04/25 21:30 0 0.00 BBWS Citanduy
15 SITUBATU CIKEMBANG 10/04/25 20:27 90 13.16 BBWS Citanduy
16 BOJONGSALAWE CITANDUY 26/03/25 00:33 23 7.79 BBWS Citanduy
Normal  Siaga 3  Siaga 2  Siaga 1