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 |
30/07/25 |
15:39 |
103 |
15.88 |
BBWS Citanduy |
2 |
PATARUMAN
|
CITANDUY |
30/07/25 |
15:38 |
148 |
118.33 |
BBWS Citanduy |
3 |
BEBEDAHAN
|
CIJOLANG |
30/07/25 |
15:37 |
186 |
54.10 |
BBWS Citanduy |
4 |
CIAWITALI
|
CISEEL |
30/07/25 |
15:37 |
1 |
0.28 |
BBWS Citanduy |
5 |
CUKANGLEULEUS
|
CIKAWUNG |
30/07/25 |
15:38 |
215 |
67.54 |
BBWS Citanduy |
6 |
CIRAHONG
|
CITANDUY |
30/07/25 |
15:36 |
142 |
13.12 |
BBWS Citanduy |
7 |
CIBEKA
|
CIMUNTUR |
30/07/25 |
15:35 |
129 |
30.74 |
BBWS Citanduy |
8 |
BATUNUNGGUL
|
CIMUNTUR |
30/07/25 |
15:35 |
309 |
69.35 |
BBWS Citanduy |
9 |
BUNAR
|
CILEUEUR |
30/07/25 |
15:31 |
40 |
4.39 |
BBWS Citanduy |
10 |
STINGGIL
|
CIMENENG |
30/07/25 |
15:28 |
21 |
2.98 |
BBWS Citanduy |
11 |
PITULASI
|
CIKAWUNG |
30/07/25 |
07:50 |
0 |
|
BBWS Citanduy |
12 |
CIPUTRAHAJI
|
CIPUTRAHAJI |
30/07/25 |
07:50 |
208 |
|
BBWS Citanduy |
13 |
GUNUNG CUPU
|
CITANDUY |
30/07/25 |
07:50 |
56 |
0.00 |
BBWS Citanduy |
14 |
BENDMANGANTI
|
CITANDUY |
30/07/25 |
07:50 |
0 |
0.00 |
BBWS Citanduy |
15 |
SITUBATU
|
CIKEMBANG |
09/07/25 |
12:02 |
140 |
25.75 |
BBWS Citanduy |
16 |
BOJONGSALAWE
|
CITANDUY |
30/07/25 |
15:35 |
82 |
34.63 |
BBWS Citanduy |
Normal
| Siaga 3
| Siaga 2
| Siaga 1 |
|
|
|