24J010000075 30,2,5,9,11,13,17,22,25,10,15,21,23,26
2,10,13,23,5,9

Offline Sim
95 channel 1, 14, 27
95 164 channel 5, 25
95 165 channel 2, 7, 22, 26

83 channel 32, 33, 35
83 133 channel 20, 21
83 134 channel 27

75 8
75 117 channel 11, 13, 17, 22, 25
75 118 channel 15, 21, 26

24J010000075    d929ed7aee993bab c11, 12, 13, 16, 19 harvested
24J010000083    4db918e1e600d233 c20, 32, 33 harvested
24J010000095    8c063652ae2bed29 c7, 14, 26 harvested

24J010000075    d929ed7aee993bab c14,4
25X010000117	a62c2bcb98b1ae8e c1,2,5,9
25X010000118	c3150df4422c74a7 c10,13,20,23,7

24J010000083    4db918e1e600d233 c9, 37(both heatmap)
25X010000133    716e0a21304f788a c3(heatmap), 5, 6
25X010000134    dd67e5e51476d321 c7(heatmap), 10, 11, 29(both heatmap)
 
24J010000095    8c063652ae2bed29 
25X010000164	ce52f939999e0b3d 
25X010000165	6c479ea8f3c993e2 c18(heatmap)

for d in 11 12 13 14
do
  DATE="2026-04-$d"
  for channel in 20 23
  do
    for h in 11 12 13 14 15 16 17 18
    do
      sudo sqlite3 /home/pi/Raspicam/modules/datacollection.db \
      "INSERT INTO Schedule VALUES('$DATE','$h:00','$h:59','11','$channel','New','scheduled');"
    done
  done
done

for d in 11 12 13 14
do
  DATE="2026-04-$d"
  for channel in 20 23
  do
    for h in 12 14 16
    do
      sudo sqlite3 /home/pi/Raspicam/modules/datacollection.db \
      "INSERT INTO Schedule VALUES('$DATE','$h:30','$h:59','0','$channel','New','scheduled');"
    done
  done
done

for d in 11 12 13 14
do
  DATE="2026-04-$d"
  for channel in 27
  do
    for h in 11 13 15
    do
      sudo sqlite3 /home/pi/Raspicam/modules/datacollection.db \
      "INSERT INTO Schedule VALUES('$DATE','$h:30','$h:59','3','$channel','New','scheduled');"
    done
  done
done


restart:
sudo systemctl restart raspicam

Check video scheduled :
cd projects/Params/0

sudo sqlite3 /home/pi/Raspicam/modules/datacollection.db "SELECT * FROM Schedule"

DELETE FROM Schedule
WHERE date BETWEEN '2026-04-11' AND '2026-04-13'
AND collection_type = '3'
AND camera_number IN ('20','21')
AND source='scheduled';