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 15/06/25 01:01 214 44.11 BBWS Citanduy
2 CUKANGLEULEUS CIKAWUNG 15/06/25 01:03 239 79.52 BBWS Citanduy
3 CIBEKA CIMUNTUR 15/06/25 01:02 98 19.40 BBWS Citanduy
4 BOJONGSALAWE CITANDUY 15/06/25 01:00 60 23.94 BBWS Citanduy
5 BATUNUNGGUL CIMUNTUR 15/06/25 00:59 237 48.24 BBWS Citanduy
6 BUNAR CILEUEUR 15/06/25 00:56 33 3.49 BBWS Citanduy
7 STINGGIL CIMENENG 15/06/25 00:44 89 23.09 BBWS Citanduy
8 CIRAHONG CITANDUY 15/06/25 00:35 353 99.62 BBWS Citanduy
9 PATARUMAN CITANDUY 14/06/25 18:01 137 100.38 BBWS Citanduy
10 SITUBATU CIKEMBANG 14/06/25 04:12 50 5.41 BBWS Citanduy
11 BEBEDAHAN CIJOLANG 13/06/25 08:58 80 12.79 BBWS Citanduy
12 CIAWITALI CISEEL 05/06/25 18:58 79,695 35,275,759.71 BBWS Citanduy
13 PITULASI CIKAWUNG 20/05/25 15:00 0 BBWS Citanduy
14 GUNUNG CUPU CITANDUY 20/05/25 15:00 63 0.00 BBWS Citanduy
15 BENDMANGANTI CITANDUY 20/05/25 15:00 0 0.00 BBWS Citanduy
16 CIPUTRAHAJI CIPUTRAHAJI 20/05/25 15:00 212 BBWS Citanduy
Normal  Siaga 3  Siaga 2  Siaga 1