DV-628 ⁃ Determine which southern African surveys have "Polecat_Striped" or "Weasel_African_Striped" (for cleanup before data request)

[sync-by-unito[bot]]

Build a query to find which surveys have certain species in Southern Africa.

┆Issue is synchronized with this Jira Task by Unito ┆Attachments: Polecat_Striped.csv | Weasel_African_Striped.csv

[sync-by-unito[bot]]

➤ Shannon Dubay commented:

Ran the following queries in Redshift console query editor:

SELECT FROM idsdb.southernafricahub.cmr_spcs_obsrvtn_tbl WHERE value='Polecat_Striped' SELECT FROM idsdb.southernafricahub.cmr_spcs_obsrvtn_tbl WHERE value='Weasel_African_Striped'

[sync-by-unito[bot]]

➤ Shannon Dubay commented:

Attached are all the records for Striped Polecat and African Striped Weasel. NOTE- these are all records that have ever existed, not just the most up to date edits. Therefore, some of these images might have been classified as one of these species at any point in time, but then changed to another species classification (i.e., accidentally put as Polecat but later changed to Civet). So don't be surprised if you check some of these surveys and there aren't images under these categories anymore.

Striped Polecat has a lot of records, while weasel is much less. Since there were so many for the polecat, I made an additional column within the exported spreadsheet (column k), and then removed duplicates and sorted, to give a cleaner list of surveys to check. [^Polecat_Striped.csv] [^Weasel_African_Striped.csv]