Skip to content

Instantly share code, notes, and snippets.

@djtfmartin

djtfmartin/NVC SQL

Last active July 31, 2017 18:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save djtfmartin/89538df7421d9214d39459e17a2a81d3 to your computer and use it in GitHub Desktop.
Save djtfmartin/89538df7421d9214d39459e17a2a81d3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
NVC SQL
delete from "65" where COMMUN_CAT IS NULL;
update "65" set COMMUN_CAT = 'A, Aquatic Communities' where COMMUN_CAT='A';
update "65" set COMMUN_CAT = 'CG, Calciolous Grassland' where COMMUN_CAT='CG';
update "65" set COMMUN_CAT = 'H, Heathland' where COMMUN_CAT='H';
update "65" set COMMUN_CAT = 'M, Mires' where COMMUN_CAT='M';
update "65" set COMMUN_CAT = 'MC, Maritime Cliff Communities' where COMMUN_CAT='MC';
update "65" set COMMUN_CAT = 'MG, Mesotrophic Grassland' where COMMUN_CAT='MG';
update "65" set COMMUN_CAT = 'N/A, Non-standard code' where COMMUN_CAT='N/A';
update "65" set COMMUN_CAT = 'S, Swamps and tall-herb fens' where COMMUN_CAT='S';
update "65" set COMMUN_CAT = 'OW, Open Water' where COMMUN_CAT='OW';
update "65" set COMMUN_CAT = 'OV, Open Vegetation' where COMMUN_CAT='OV';
update "65" set COMMUN_CAT = 'SD, Sand Dunes, Strand-line & Shingle Communities' where COMMUN_CAT='SD';
update "65" set COMMUN_CAT = 'SM, Saltmarsh' where COMMUN_CAT='SM';
update "65" set COMMUN_CAT = 'U, Calcifugous Grasslands and Montane Communities' where COMMUN_CAT='U';
update "65" set COMMUN_CAT = 'W, Woodlands' where COMMUN_CAT='W';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment