Created
June 29, 2023 15:52
-
-
Save djtfmartin/551e632d75679b574bdc037abaa79208 to your computer and use it in GitHub Desktop.
species list clean up
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| update species_list set is_private=true WHERE list_name REGEXP '^[0-9]' and list_type='OTHER' and is_authoritative is null; | |
| update species_list set is_private=true WHERE list_name REGEXP '^[0-9]' and list_type='SPATIAL_PORTAL' and is_authoritative is null; | |
| update species_list set is_private=true WHERE list_name like 'My species list%' and list_type='OTHER' and is_authoritative is null; | |
| update species_list set is_private=true WHERE list_name = 'My species list' and list_type='SPATIAL_PORTAL' and is_authoritative is null; | |
| update species_list set is_private=true WHERE list_name like 'My species list%' and list_type='SPATIAL_PORTAL' and is_authoritative is null; | |
| update species_list set is_private=true WHERE list_name = 'My species list' and is_authoritative is null; | |
| update species_list set is_private=true | |
| WHERE | |
| ( list_name like 'My species list%' | |
| OR list_name = 'My species list' | |
| OR list_name like 'Assign%' | |
| OR list_name like 'Area%' | |
| OR list_name like 'BB%' | |
| OR list_name like 'big list' | |
| OR list_name like 'big list' | |
| OR list_name like 'Collinsville' | |
| OR list_name like 'data.csv' | |
| OR list_name like 'EC_Species' | |
| OR list_name like 'fuck' | |
| OR list_name like 'robina %' | |
| OR list_name like 'species.csv' | |
| OR list_name like '0662409' | |
| OR list_name like 'ALA List.csv' | |
| OR list_name like 'ALA species list.xlsx' | |
| OR list_name like 'Brett%' | |
| OR list_name like 'bSpecies' | |
| OR list_name like 'CLUSTER 3' | |
| OR list_name like 'mylist' | |
| OR list_name like 'My_species_list' | |
| OR list_name like 'M_ZMy species list' | |
| OR list_name like 'Number of endemic species 0606.csv' | |
| OR list_name like 'Additional plant spp.' | |
| OR list_name like 'A short list of kangaroos' | |
| OR list_name like 'ALA example' | |
| OR list_name like 'BAI 2' | |
| ) | |
| and | |
| ( list_type='OTHER' OR list_type='SPATIAL_PORTAL' OR list_type='LOCAL_LIST') | |
| and is_authoritative is null; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment