COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2     [ABDT1= Total Diatoms (cells/liter)]      ( date set 1 )
    Column # 3     [ABDT2= Total Dinoflagellates (cells/litre)]      ( date set 1 )

    Column # 4     [ DATE-YMD ]       Date Set = 2
    Column # 5     [ABDT1= Skeletonema spp. (cells/liter)]      ( date set 2 )
    Column # 6     [ABDT1= Chaetoceros spp. (cells/liter)]      ( date set 2 )
    Column # 7     [ABDT1= Pseudo-nitzschia spp. (cells/liter)]      ( date set 2 )
    Column # 8     [ABDT1= Rhizosolenia spp. (cells/liter)]      ( date set 2 )
    Column # 9     [ABDT1= Thalassionema nitzschioides (cells/liter)]      ( date set 2 )
    Column # 10     [ABDT2= Gyrodinium spirale (cells/liter)]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12     [ABDT2= Alexandrium catenella/tamarense (cells/liter)]      ( date set 3 )
    Column # 13     [ABDT1= Rhizosolenia pungens/setigera (cells/liter)]      ( date set 3 )
    Column # 14     [ABDT1= Leptocylindrus danicus (cells/liter)]      ( date set 3 )
    Column # 15     [ABDT1= Leptocylindrus minimus (cells/liter)]      ( date set 3 )
    Column # 16     [ABDT2= Heterocapsa triquetra (cells/liter)]      ( date set 3 )
    Column # 17     [ABDT1= Guinardia striata (cells/liter)]      ( date set 3 )

    Column # 18     [ DATE-YMD ]       Date Set = 4
    Column # 19     [ABDT2= Dinophysis sacculus (cells/liter)]      ( date set 4 )
    Column # 20     [ABDT2= Protoperidinium bipes (cells/liter)]      ( date set 4 )

    Column # 21     [ DATE-YMD ]       Date Set = 5
    Column # 22     [ABDT= Euglenophyceae (cells/l)]      ( date set 5 )

    Column # 23     [ DATE-YMD ]       Date Set = 6
    Column # 24     [ABDT= Picoeukaryotes (cells/liter)]      ( date set 6 )

    Column # 25     [ DATE-YMD ]       Date Set = 7
    Column # 26     [ABDT= Picocyanobacteria (cells/ml)]      ( date set 7 )

    Column # 27     [ DATE-YMD ]       Date Set = 8
    Column # 28     [ABDT2= Dinophysis acuminata (cells/liter)]      ( date set 8 )

    Column # 29     [ DATE-YMD ]       Date Set = 9
    Column # 30     [ABDT1= Dactyliosolen fragilissimus (cells/liter)]      ( date set 9 )

    Column # 31     [ DATE-YMD ]       Date Set = 10
    Column # 32     [ABDT1= Ceratoneis closterium (cells/liter)]      ( date set 10 )

    Column # 33     [ DATE-DMY ]       Date Set = 11
    Column # 34     [TEMP= Temperature ( C )]      ( date set 11 )
    Column # 35     [PSAL= Salinity ()]      ( date set 11 )
    Column # 36     [LOTH= Soluble Reactive Phosphorus (umol-P/liter)]      ( date set 11 )

    Column # 37     [ DATE-YMD ]       Date Set = 12
    Column # 38     [LOTH= Nitrate (umol-N/liter)]      ( date set 12 )

    Column # 39     [ DATE-YMD ]       Date Set = 13
    Column # 40     [LOTH= Ammonium (umol-N/liter)]      ( date set 13 )

    Column # 41     [ DATE-YMD ]       Date Set = 14
    Column # 42     [CHLA= Chlorophyll-a (ug/l)]      ( date set 14 )

    Column # 43     [ DATE-YMD ]       Date Set = 15
    Column # 44     [LOTH1= Rainfall (mm)]      ( date set 15 )

    Column # 45     [ DATE-YMD ]       Date Set = 16
    Column # 46     [LOTH= Crassostrea gigas Standing Stock (tons)]      ( date set 16 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (cells/liter) ]
        Column # 3   [ ABDT2= Total Dinoflagellates (cells/litre) ]
        Column # 5   [ ABDT1= Skeletonema spp. (cells/liter) ]
        Column # 6   [ ABDT1= Chaetoceros spp. (cells/liter) ]
        Column # 7   [ ABDT1= Pseudo-nitzschia spp. (cells/liter) ]
        Column # 8   [ ABDT1= Rhizosolenia spp. (cells/liter) ]
        Column # 9   [ ABDT1= Thalassionema nitzschioides (cells/liter) ]
        Column # 10   [ ABDT2= Gyrodinium spirale (cells/liter) ]
        Column # 12   [ ABDT2= Alexandrium catenella/tamarense (cells/liter) ]
        Column # 13   [ ABDT1= Rhizosolenia pungens/setigera (cells/liter) ]
        Column # 14   [ ABDT1= Leptocylindrus danicus (cells/liter) ]
        Column # 15   [ ABDT1= Leptocylindrus minimus (cells/liter) ]
        Column # 16   [ ABDT2= Heterocapsa triquetra (cells/liter) ]
        Column # 17   [ ABDT1= Guinardia striata (cells/liter) ]
        Column # 19   [ ABDT2= Dinophysis sacculus (cells/liter) ]
        Column # 20   [ ABDT2= Protoperidinium bipes (cells/liter) ]
        Column # 22   [ ABDT= Euglenophyceae (cells/l) ]
        Column # 24   [ ABDT= Picoeukaryotes (cells/liter) ]
        Column # 26   [ ABDT= Picocyanobacteria (cells/ml) ]
        Column # 28   [ ABDT2= Dinophysis acuminata (cells/liter) ]
        Column # 30   [ ABDT1= Dactyliosolen fragilissimus (cells/liter) ]
        Column # 32   [ ABDT1= Ceratoneis closterium (cells/liter) ]

    Temperatures Category
        Column # 34   [ TEMP= Temperature ( C ) ]

    Salinities Category
        Column # 35   [ PSAL= Salinity () ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (cells/liter) ]
        column # 5     [ ABDT1= Skeletonema spp. (cells/liter) ]
        column # 6     [ ABDT1= Chaetoceros spp. (cells/liter) ]
        column # 7     [ ABDT1= Pseudo-nitzschia spp. (cells/liter) ]
        column # 8     [ ABDT1= Rhizosolenia spp. (cells/liter) ]
        column # 9     [ ABDT1= Thalassionema nitzschioides (cells/liter) ]
        column # 13     [ ABDT1= Rhizosolenia pungens/setigera (cells/liter) ]
        column # 14     [ ABDT1= Leptocylindrus danicus (cells/liter) ]
        column # 15     [ ABDT1= Leptocylindrus minimus (cells/liter) ]
        column # 17     [ ABDT1= Guinardia striata (cells/liter) ]
        column # 30     [ ABDT1= Dactyliosolen fragilissimus (cells/liter) ]
        column # 32     [ ABDT1= Ceratoneis closterium (cells/liter) ]

    Category 8 Group # 2
        column # 3     [ ABDT2= Total Dinoflagellates (cells/litre) ]
        column # 10     [ ABDT2= Gyrodinium spirale (cells/liter) ]
        column # 12     [ ABDT2= Alexandrium catenella/tamarense (cells/liter) ]
        column # 16     [ ABDT2= Heterocapsa triquetra (cells/liter) ]
        column # 19     [ ABDT2= Dinophysis sacculus (cells/liter) ]
        column # 20     [ ABDT2= Protoperidinium bipes (cells/liter) ]
        column # 28     [ ABDT2= Dinophysis acuminata (cells/liter) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1975 2010
DATES in Column 4 no problems detected 1975 2013
DATES in Column 11 no problems detected 1987 2010
DATES in Column 18 no problems detected 1987 2010
DATES in Column 21 no problems detected 1987 2013
DATES in Column 23 no problems detected 1991 2013
DATES in Column 25 no problems detected 1991 2013
DATES in Column 27 no problems detected 1987 2013
DATES in Column 29 no problems detected 1987 2013
DATES in Column 31 no problems detected 1987 2013
DATES in Column 33 no problems detected 1972 2010
DATES in Column 37 no problems detected 1972 2004
DATES in Column 39 no problems detected 1986 2004
DATES in Column 41 no problems detected 1975 2010
DATES in Column 43 no problems detected 1971 2009
DATES in Column 45 no problems detected 1965 2001

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 apr Sep 00 2010
4 DATE-YMD DATE-YMD yes 1975 2013 Apr Sep 15 15
11 DATE-YMD DATE-YMD yes 1987 2010 Apr Sep 15 15
18 DATE-YMD DATE-YMD yes 1987 2010 Apr Sep 15 15
21 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15
23 DATE-YMD DATE-YMD yes 1991 2013 Apr Sep 15 15
25 DATE-YMD DATE-YMD yes 1991 2013 Apr Sep 15 15
27 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15
29 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15
31 DATE-YMD DATE-YMD yes 1987 2013 Apr Sep 15 15
33 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99
37 DATE-YMD DATE-YMD yes 1972 2004 01 12 15 15
39 DATE-YMD DATE-YMD yes 1986 2004 01 12 15 15
41 DATE-YMD DATE-YMD yes 1975 2010 Apr Sep 15 15
43 DATE-YMD DATE-YMD yes 1971 2009 01 12 15 15
45 DATE-YMD DATE-YMD yes 1965 2001 12 12 15 15



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Diatoms (cells/liter) ]
no problems detected 845 300.000000 50017800.0 755
( 89 %)
755
( 89 %)
Column 3 :
[ 05_ABDT2= Total Dinoflagellates (cells/litre) ]
no problems detected 958 50.0000000 2635000.00 683
( 71 %)
683
( 71 %)
Column 5 :
[ 06_ABDT1= Skeletonema spp. (cells/liter) ]
no problems detected 276 150.000000 33500000.0 173
( 62 %)
173
( 62 %)
Column 6 :
[ 07_ABDT1= Chaetoceros spp. (cells/liter) ]
no problems detected 276 100.000000 2250000.00 247
( 89 %)
247
( 89 %)
Column 7 :
[ 08_ABDT1= Pseudo-nitzschia spp. (cells/liter) ]
no problems detected 276 500.000000 3064000.00 188
( 68 %)
188
( 68 %)
Column 8 :
[ 09_ABDT1= Rhizosolenia spp. (cells/liter) ]
no problems detected 286 50.0000000 651000.000 147
( 51 %)
147
( 51 %)
Column 9 :
[ 10_ABDT1= Thalassionema nitzschioides (cells/liter) ]
no problems detected 285 150.000000 450000.000 60
( 21 %)
60
( 21 %)
Column 10 :
[ 11_ABDT2= Gyrodinium spirale (cells/liter) ]
no problems detected 289 50.0000000 6650.00000 168
( 58 %)
168
( 58 %)
Column 12 :
[ 12_ABDT2= Alexandrium catenella/tamarense (cells/liter) ]
no problems detected 288 25.0000000 53400.0000 55
( 19 %)
55
( 19 %)
Column 13 :
[ 13_ABDT1= Rhizosolenia pungens/setigera (cells/liter) ]
no problems detected 276 50.0000000 420100.000 99
( 35 %)
99
( 35 %)
Column 14 :
[ 14_ABDT1= Leptocylindrus danicus (cells/liter) ]
no problems detected 267 100.000000 401600.000 122
( 45 %)
122
( 45 %)
Column 15 :
[ 15_ABDT1= Leptocylindrus minimus (cells/liter) ]
no problems detected 267 300.000000 1168000.00 145
( 54 %)
145
( 54 %)
Column 16 :
[ 16_ABDT2= Heterocapsa triquetra (cells/liter) ]
no problems detected 276 50.0000000 248000.000 76
( 27 %)
76
( 27 %)
Column 17 :
[ 17_ABDT1= Guinardia striata (cells/liter) ]
no problems detected 275 100.000000 143000.000 60
( 21 %)
60
( 21 %)
Column 19 :
[ 18_ABDT2= Dinophysis sacculus (cells/liter) ]
no problems detected 284 20.0000000 540.000000 32
( 11 %)
32
( 11 %)
Column 20 :
[ 19_ABDT2= Protoperidinium bipes (cells/liter) ]
no problems detected 275 50.0000000 1000000.00 52
( 18 %)
52
( 18 %)
Column 22 :
[ 20_ABDT= Euglenophyceae (cells/l) ]
no problems detected 317 50.0000000 107400.000 188
( 59 %)
188
( 59 %)
Column 24 :
[ 21_ABDT= Picoeukaryotes (cells/liter) ]
no problems detected 107 3100000.00 239254544. 107
( 100 %)
107
( 100 %)
Column 26 :
[ 22_ABDT= Picocyanobacteria (cells/ml) ]
no problems detected 97 4.00000000 1097100.00 84
( 86 %)
84
( 86 %)
Column 28 :
[ 23_ABDT2= Dinophysis acuminata (cells/liter) ]
no problems detected 317 15.0000000 550.000000 59
( 18 %)
59
( 18 %)
Column 30 :
[ 24_ABDT1= Dactyliosolen fragilissimus (cells/liter) ]
no problems detected 311 100.000000 404500.000 120
( 38 %)
120
( 38 %)
Column 32 :
[ 25_ABDT1= Ceratoneis closterium (cells/liter) ]
no problems detected 311 50.0000000 3320000.00 32
( 10 %)
32
( 10 %)
Column 34 :
[ 26_TEMP= Temperature ( C ) ]
no problems detected 427 2.70000005 27.7999992 427
( 100 %)
427
( 100 %)
Column 35 :
[ 27_PSAL= Salinity () ]
no problems detected 1067 22.2999992 40.5999985 1067
( 100 %)
1067
( 100 %)
Column 36 :
[ 28_LOTH= Soluble Reactive Phosphorus (umol-P/liter) ]
no problems detected 230 3.99999991E-02 10.0000000 230
( 100 %)
151
( 65 %)
Column 38 :
[ 29_LOTH= Nitrate (umol-N/liter) ]
no problems detected 233 9.99999978E-03 21.3999996 225
( 96 %)
90
( 38 %)
Column 40 :
[ 30_LOTH= Ammonium (umol-N/liter) ]
no problems detected 82 5.99999987E-02 15.6000004 82
( 100 %)
37
( 45 %)
Column 42 :
[ 31_CHLA= Chlorophyll-a (ug/l) ]
no problems detected 244 0.200000003 13.0000000 244
( 100 %)
190
( 77 %)
Column 44 :
[ 32_LOTH1= Rainfall (mm) ]
no problems detected 420 0.200000003 642.000000 415
( 98 %)
407
( 96 %)
Column 46 :
[ 33_LOTH= Crassostrea gigas Standing Stock (tons) ]
no problems detected 28 2100.00000 19000.0000 28
( 100 %)
28
( 100 %)

The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".