Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save djtfmartin/551e632d75679b574bdc037abaa79208 to your computer and use it in GitHub Desktop.
Save djtfmartin/551e632d75679b574bdc037abaa79208 to your computer and use it in GitHub Desktop.
species list clean up
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