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 23/06/24 06:23 13 1.88 BBWS Citanduy
2 PATARUMAN CITANDUY 23/06/24 06:24 -20 0.02 BBWS Citanduy
3 CIRAHONG CITANDUY 23/06/24 06:24 70 12.64 BBWS Citanduy
4 CIBEKA CIMUNTUR 23/06/24 06:24 68 10.17 BBWS Citanduy
5 BEBEDAHAN CIJOLANG 23/06/24 06:24 202 62.46 BBWS Citanduy
6 BATUNUNGGUL CIMUNTUR 23/06/24 06:21 162 29.16 BBWS Citanduy
7 CIAWITALI CISEEL 23/06/24 06:21 -23 0.00 BBWS Citanduy
8 CUKANGLEULEUS CIKAWUNG 23/06/24 06:22 285 103.66 BBWS Citanduy
9 SITUBATU CIKEMBANG 23/06/24 06:02 -19 0.00 BBWS Citanduy
10 BUNAR CILEUEUR 23/06/24 05:57 24 2.43 BBWS Citanduy
11 STINGGIL CIMENENG 23/06/24 05:50 13 1.56 BBWS Citanduy
12 BOJONGSALAWE CITANDUY 23/06/24 06:20 66 26.90 BBWS Citanduy
13 PITULASI CIKAWUNG 22/06/24 20:50 33 BBWS Citanduy
14 GUNUNG CUPU CITANDUY 22/06/24 21:00 35 0.00 BBWS Citanduy
15 BENDMANGANTI CITANDUY 22/06/24 20:50 0 0.00 BBWS Citanduy
16 CIPUTRAHAJI CIPUTRAHAJI 22/06/24 19:10 198 BBWS Citanduy
Normal  Siaga 3  Siaga 2  Siaga 1