\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)
photo_id|bbox_id|bexpr|formula|why
5|1|{0=Red Deer}[0.400000] ∨ {0=Roe Deer}[0.300000]|Red Deer ⊕ Roe Deer|{{Red Deer},{Roe Deer}}
(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_species|exp_detections|exp_total_conf
1|1.0000|2.1889|1.5701
5|1.8110|3.0490|1.3635
7|1.5672|2.5907|1.6728
9|1.7245|2.2287|1.7351
22|2.7362|4.3803|2.9978
(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)
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)
remove_provenance

(1 row)
species_id|prob
1|0.9909
3|0.9106
5|0.5994
6|0.3410
7|0.7826
|0.3000
(6 rows)
remove_provenance

(1 row)
species_id|prob
1|0.9909
3|0.9106
5|0.5994
6|0.3410
7|0.7826
(5 rows)
remove_provenance

(1 row)
photo_id|bbox_id|label|prob
5|1|Red Deer|0.4000
5|1|Roe Deer|0.3000
5|2|Red Deer|0.4200
5|3|Red Deer|0.3800
5|4|Red Fox|0.4300
5|5|Red Fox|0.4800
(6 rows)
remove_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
photo_id|bbox_id|label|prob
5|1|Red Deer|0.4000
5|1|Roe Deer|0.1800
5|2|Red Deer|0.4200
5|3|Red Deer|0.3800
5|4|Red Fox|0.4300
5|5|Red Fox|0.4800
(6 rows)
remove_provenance

(1 row)
photo_id|bbox_id|label|prob
5|1|Red Deer|0.2800
5|1|Roe Deer|0.3000
(2 rows)