Project

General

Profile

« Previous | Next » 

Revision 8186

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/FIA/COND/import: oldGrowth: Updated expr column names

View differences:

import
18 18 
ALTER TABLE "COND" ADD   COLUMN "oldGrowth"      boolean;
19 19 
ALTER TABLE "COND" ALTER COLUMN "oldGrowth" TYPE boolean USING
20 20 
(
21 
    "COND.STDAGE"::integer>80
22 
    AND ("COND.TRTCD1"='0' OR "COND.TRTCD1" IS NULL)
23 
    AND (("COND.DSTRBCD1"<>'30' AND "COND.DSTRBCD1"<>'31' AND "COND.DSTRBCD1"<>'32' AND "COND.DSTRBCD1"<>'80') OR "COND.DSTRBCD1" IS NULL)
24 
    AND ("COND.STUMP_CD_PNWRS"='N' OR "COND.STUMP_CD_PNWRS" IS NULL)
25 
    AND "COND.HARVEST_TYPE1_SRS" IS NULL
26 
    AND "COND.PRESNFCD" IS NULL
27 
    AND ("COND.STDORGCD"='0' OR "COND.STDORGCD" IS NULL)
21 
    "COND
22 
STDAGE"::integer>80
23 
    AND ("COND
24 
TRTCD1"='0' OR "COND
25 
TRTCD1" IS NULL)
26 
    AND (("COND
27 
DSTRBCD1"<>'30' AND "COND
28 
DSTRBCD1"<>'31' AND "COND
29 
DSTRBCD1"<>'32' AND "COND
30 
DSTRBCD1"<>'80') OR "COND
31 
DSTRBCD1" IS NULL)
32 
    AND ("COND
33 
STUMP_CD_PNWRS"='N' OR "COND
34 
STUMP_CD_PNWRS" IS NULL)
35 
    AND "COND
36 
HARVEST_TYPE1_SRS" IS NULL
37 
    AND "COND
38 
PRESNFCD" IS NULL
39 
    AND ("COND
40 
STDORGCD"='0' OR "COND
41 
STDORGCD" IS NULL)
28 42 
)
29 
OR "COND.STND_COND_CD_PNWRS"='7'
43 
OR "COND
44 
STND_COND_CD_PNWRS"='7'
30 45 
;
31 46 
$$);
32 47 

  		












Also available in:  Unified diff