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/07/25 |
22:43 |
65 |
8.76 |
BBWS Citanduy |
2 |
PITULASI
|
CIKAWUNG |
11/07/25 |
15:40 |
0 |
|
BBWS Citanduy |
3 |
BENDMANGANTI
|
CITANDUY |
11/07/25 |
15:30 |
0 |
0.00 |
BBWS Citanduy |
4 |
CIAWITALI
|
CISEEL |
11/07/25 |
22:43 |
1 |
0.28 |
BBWS Citanduy |
5 |
CUKANGLEULEUS
|
CIKAWUNG |
11/07/25 |
22:42 |
222 |
70.80 |
BBWS Citanduy |
6 |
BEBEDAHAN
|
CIJOLANG |
11/07/25 |
22:41 |
160 |
41.65 |
BBWS Citanduy |
7 |
BATUNUNGGUL
|
CIMUNTUR |
11/07/25 |
22:41 |
268 |
57.02 |
BBWS Citanduy |
8 |
CIBEKA
|
CIMUNTUR |
11/07/25 |
22:40 |
87 |
15.80 |
BBWS Citanduy |
9 |
PATARUMAN
|
CITANDUY |
11/07/25 |
22:39 |
133 |
94.28 |
BBWS Citanduy |
10 |
CIRAHONG
|
CITANDUY |
11/07/25 |
22:39 |
95 |
3.84 |
BBWS Citanduy |
11 |
STINGGIL
|
CIMENENG |
11/07/25 |
22:33 |
17 |
2.17 |
BBWS Citanduy |
12 |
CIPUTRAHAJI
|
CIPUTRAHAJI |
11/07/25 |
15:40 |
200 |
|
BBWS Citanduy |
13 |
GUNUNG CUPU
|
CITANDUY |
11/07/25 |
15:30 |
55 |
0.00 |
BBWS Citanduy |
14 |
BUNAR
|
CILEUEUR |
11/07/25 |
03:51 |
32 |
3.38 |
BBWS Citanduy |
15 |
SITUBATU
|
CIKEMBANG |
09/07/25 |
12:02 |
140 |
25.75 |
BBWS Citanduy |
16 |
BOJONGSALAWE
|
CITANDUY |
11/07/25 |
22:40 |
69 |
28.33 |
BBWS Citanduy |
Normal
| Siaga 3
| Siaga 2
| Siaga 1 |
|
|
|