search

jbrzusto / TO_DO

sensorgnome / motus TODO list for jbrzusto
0 stars 0 forks source link

more incorrect project labels #21

Closed jbrzusto closed 8 years ago

jbrzusto commented 8 years ago

A number of incorrect project labels were sent from sensorgnome.org to motus. These can be fixed with something like:

update projects set code='Quebec'        where id= 3; -- was 'Desrochers'
update projects set code='HolbSESA'      where id= 8; -- was 'Holbt'
update projects set code='Pau'           where id= 9; -- was 'RHC_SSTS'
update projects set code='Dossman'       where id=18; -- was 'Dosmn'
update projects set code='R5_SALS'       where id=25; -- was 'Obrien'
update projects set code='Dowling'       where id=32; -- was 'DowlingMig'
update projects set code='OntLOSH'       where id=37; -- was 'Wheeler'
update projects set code='Tremblay'      where id=42; -- was 'Jonas'
update projects set code='AdamSmith'     where id=45; -- was 'ASmith'
update projects set code='QC-Thrush'     where id=49; -- was 'JTThrush'
update projects set code='Protandry'     where id=50; -- was 'Morbey'
update projects set code='NJA-DEBay'     where id=59; -- was 'DEBay'
update projects set code='Tonra'         where id=64; -- was 'BurkeBANS'
update projects set code='Churchill'     where id=67; -- was 'Nol'
update projects set code='PADEP'         where id=71; -- was 'LPBats'
update projects set code='CTRiver'       where id=74; -- was 'Hulsey'
update projects set code='Stantial'      where id=77; -- was 'NJChickSurvival'
update projects set code='Shoener'       where id=80; -- was 'RomanoBats'
update projects set code='MA_REKN'       where id=88; -- was 'Monomoy'
jbrzusto commented 8 years ago

fixed upstream by Denis Lepage - thanks!