\set ECHO none
add_provenance

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
label|id|formula
mammal of interest|2|Red Deer
predator of interest|2|Red Fox
mammal of interest|5|Red Deer
mammal of interest|5|Red Deer
mammal of interest|5|Red Deer
predator of interest|5|Red Fox
predator of interest|5|Red Fox
(7 rows)
remove_provenance

(1 row)
id|formula
2|Red Deer ⊗ Red Fox
5|(Red Deer ⊗ Red Fox) ⊕ (Red Deer ⊗ Red Fox) ⊕ (Red Deer ⊗ Red Fox) ⊕ (Red Deer ⊗ Red Fox) ⊕ (Red Deer ⊗ Red Fox) ⊕ (Red Deer ⊗ Red Fox)
(2 rows)
remove_provenance

(1 row)
repair_key

(1 row)
remove_provenance

(1 row)
remove_provenance

(1 row)
photo_id|species_id|gtype
2|1|mulinput
2|3|mulinput
5|1|mulinput
5|1|mulinput
5|1|mulinput
5|2|mulinput
5|3|mulinput
5|3|mulinput
5||mulinput
(9 rows)
remove_provenance

(1 row)
photo_id|bbox_id|bexpr|p
5|1|{0=1}[0.400000] ∨ {0=2}[0.300000]|0.7000
(1 row)
remove_provenance

(1 row)
id|prob
22|0.8760
2|0.6120
5|0.5518
28|0.5244
10|0.4818
18|0.3355
(6 rows)
remove_provenance

(1 row)
id
2
10
18
22
28
(5 rows)
remove_provenance

(1 row)
id|prob
9|0.0632
14|0.6888
22|0.9582
(3 rows)
remove_provenance

(1 row)
id|prob
22|0.8760
2|0.6120
5|0.5518
28|0.5244
10|0.4818
18|0.3355
(6 rows)
remove_provenance

(1 row)
id|exp_detections|exp_total_conf
1|2.1400|1.5350
5|3.0100|1.3461
7|2.5500|1.6465
9|2.2100|1.7205
22|4.3800|2.9976
(5 rows)
add_provenance

(1 row)
remove_provenance

(1 row)
photo_id|species_id|confidence|prob
6|7|0.91|0.9100
9|13|0.92|0.9200
(2 rows)
remove_provenance

(1 row)
species_id|prob
1|0.0091
2|0.7060
3|0.0629
5|0.2106
6|0.2090
7|0.1274
9|0.8300
|0.3000
(8 rows)
remove_provenance

(1 row)
species_id|prob
1|0.0045
2|0.3530
3|0.0314
5|0.1053
6|0.1045
7|0.0637
9|0.4150
|0.0000
(8 rows)
remove_provenance

(1 row)
species_id|prob
1|0.0091
2|0.7060
3|0.0629
5|0.2106
6|0.2090
7|0.1274
9|0.8300
|0.6000
(8 rows)