search

zooniverse / wildcam-gorongosa-education

This is WildCam Labs, the education/exploration-oriented extension of the WildCam Gorongosa project.
https://lab.wildcamgorongosa.org/
Apache License 2.0
0 stars 1 forks source link

Can't create Assignments when certain filters are activated #305

Closed shaunanoordin closed 7 years ago

shaunanoordin commented 7 years ago

Issue Overview

When attempting to create Assignments, the process will fail when certain filters are activated.

Status

Reported by Bridget; investigating

Notes

This issue was reported by Bridget on 24 Oct and followed up with on 1 Nov. The following is taken from her e-mail where she details how some filters work when creating Assignments while others fail.

Thank you for the follow-up. I just did thorough testing the Assignments feature and I think that the issue is connected to what type of filters are applied, not necessarily the number of photos. I was not able to create an assignment when I applied filters to the Habitats, Distance to Water, or Distance to Humans, no matter how many images were selected. Here is a log of what I’ve found:

Baboons Assignment (12, 930 images)

  • I created an assignment where I selected baboons, which resulted in about 12k images. This assignment worked as expected, with just a 10 second delay.

Three Habitats Assignment (22,532 images)

  • I began creating an assignment where I selected the first three habitats (all but mixed savanna) and when I hit submit, after 10 seconds the button changed from being inactive to active and the images had disappeared.

Two Habitats (21,839 images)

  • I began creating an assignment where I selected the first two habitats (limestone gorge and floodplain) and when I hit submit, after 10 seconds the button changed from being inactive to active and the images had disappeared.

Floodplain Grassland (13,765 images)

  • I began creating an assignment where I selected the first two habitats (limestone gorge and floodplain) and when I hit submit, after 10 seconds the button changed from being inactive to active and the images had disappeared.

Baboons Again (12, 930 images)

  • I tried the baboons filter again to confirm that this still works, and it did.

Baboons and Civets (13554 images)

  • I filtered for baboons and civets and this also works.

Baboons and Bushbuck (18,252 images)

  • I filtered for baboons and bushbuck to see if it is the number of images or the fact that it is species vs habitats. This worked.

Limestone Gorge (8,074)

  • I selected Limestone Gorge to confirm that the habitats filter does not work. This did not work.

Wet Season (2,651)

  • This worked

Day Time (21,778)

  • I selected “Day” within the Time of Day. This worked.

2013 (5,357)

  • I selected Jan 1, 2013 to Dec 31, 2013 in the date range selector. This worked.

Distance Humans 0 to 100 (25,959)

  • I selected the distance of 0 to 100 meters and this did not work.

Distance Humans 0 to 10 (18,029)

  • I selected the distance of 0 to 10 meters and this did not work.

Distance Humans 100 to 500 (4,128)

  • I selected the distance of 100 to 500 meters and this did not work.

Distance to Water 0 to 100 (7,667)

  • I selected the distance of 0 to 100 meters and this did not work.

Distance to Water 0 to 50 (1,864)

  • I selected the distance of 0 to 50 meters and this did not work.
shaunanoordin commented 7 years ago

Observations

It appears that the Carto results (or the SQL query used to create those Carto results) have erroneous almost-empty rows appended to their end.

For example, create a filter with Distance to Water 0 to 20, then Download the CSV. The CSV should look fine.

Then, create a filter with Distance to Water 0 to 50, then Download the CSV. The CSV will now have three empty row at the end.

Status

WTF?

Notes

I suspect this may be something to do with Cameras with zero Subjects/Classifications attached to them, and how the SQL Query is Joined.