COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2     [ABND= Total Copepoda (#/m3)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4     [ABND= Total Rotifera (#/m3)]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6     [ABND= Total Cladocera (#/m3)]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8     [ABND= Total Bivalvia (#/m3)]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10     [ABND= Total Appendicularia (#/m3)]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12     [ABND= Total Diatoms (#/L)]      ( date set 6 )

    Column # 13     [ DATE-YMD ]       Date Set = 7
    Column # 14     [ABND= Total Dinoflagellates (#/L)]      ( date set 7 )

    Column # 15     [ DATE-YMD ]       Date Set = 8
    Column # 16     [ABND= Total Ciliophora (#/L)]      ( date set 8 )

    Column # 17     [ DATE-YMD ]       Date Set = 9
    Column # 18     [ABND= Total Coccolithophores (#/L)]      ( date set 9 )

    Column # 19     [ DATE-YMD ]       Date Set = 10
    Column # 20     [ABND= Total Cryptomonads (#/L)]      ( date set 10 )

    Column # 21     [ DATE-YMD ]       Date Set = 11
    Column # 22     [TEMP= Temperature (C)]      ( date set 11 )
    Column # 23     [PSAL= Salinity (pss)]      ( date set 11 )
    Column # 24     [OTHR= pH ()]      ( date set 11 )
    Column # 25     [OTHR= Oxygen (ml/l)]      ( date set 11 )
    Column # 26     [OTHR= OxygenSat (%)]      ( date set 11 )
    Column # 27     [LOTH= Po4-P (uM)]      ( date set 11 )
    Column # 28     [LOTH= Tot-P (uM)]      ( date set 11 )
    Column # 29     [LOTH= NO2-N (uM)]      ( date set 11 )
    Column # 30     [LOTH= NO3-N (uM)]      ( date set 11 )
    Column # 31     [LOTH= NH4-N (uM)]      ( date set 11 )
    Column # 32     [LOTH= Tot-N (uM)]      ( date set 11 )
    Column # 33     [LOTH= SiO3-Si (uM)]      ( date set 11 )
    Column # 34     [CHLA= Chlorophyll (ug/l)]      ( date set 11 )

    Column # 35     [ DATE-YMD ]       Date Set = 12
    Column # 36     [ABDT1= Total Copepoda (#/m3)]      ( date set 12 )
    Column # 37     [ABDT1= Total Rotifera (#/m3)]      ( date set 12 )
    Column # 38     [ABDT1= Total Cirripedia (#/m3)]      ( date set 12 )
    Column # 39     [ABDT1= Total Euphausiacea (#/m3)]      ( date set 12 )
    Column # 40     [ABDT1= Total Polychaeta (#/m3)]      ( date set 12 )
    Column # 41     [ABDT1= Total Gastropoda (#/m3)]      ( date set 12 )
    Column # 42     [ABDT1= Total Bivalvia (#/m3)]      ( date set 12 )
    Column # 43     [ABDT1= Total Chaetognatha (#/m3)]      ( date set 12 )
    Column # 44     [ABDT1= Total Echinodermata (#/m3)]      ( date set 12 )
    Column # 45     [ABDT1= Total Appendicularia (#/m3)]      ( date set 12 )
    Column # 46     [ABDT2= Total Copepoda (#/m3)]      ( date set 12 )
    Column # 47     [ABDT2= Acartia spp. (#/m3)]      ( date set 12 )
    Column # 48     [ABDT2= Calanus spp. (#/m3)]      ( date set 12 )
    Column # 49     [ABDT2= Centropages spp. (#/m3)]      ( date set 12 )
    Column # 50     [ABDT2= Microsetella spp. (#/m3)]      ( date set 12 )
    Column # 51     [ABDT2= Oithona spp. (#/m3)]      ( date set 12 )
    Column # 52     [ABDT2= Paracalanus spp. (#/m3)]      ( date set 12 )
    Column # 53     [ABDT2= Temora spp. (#/m3)]      ( date set 12 )
    Column # 54     [ABDT2= Other copepoda (#/m3)]      ( date set 12 )

    Column # 55     [ DATE-YMD ]       Date Set = 13
    Column # 56     [ABDT1= Total Diatoms (#/L)]      ( date set 13 )
    Column # 57     [ABDT1= Total Dinoflagellates (#/L)]      ( date set 13 )
    Column # 58     [ABDT1= Total Cyanobacteria (#/L)]      ( date set 13 )
    Column # 59     [ABDT1= Total Coccolithophorids (#/L)]      ( date set 13 )
    Column # 60     [ABDT1= Total Ciliphora (#/L)]      ( date set 13 )
    Column # 61     [ABDT1= Total Cryptomonads (#/L)]      ( date set 13 )
    Column # 62     [ABDT1= Total Chrysomonads (#/L)]      ( date set 13 )
    Column # 63     [ABDT1= Total Euglenophyta (#/L)]      ( date set 13 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND= Total Copepoda (#/m3) ]
        Column # 4   [ ABND= Total Rotifera (#/m3) ]
        Column # 6   [ ABND= Total Cladocera (#/m3) ]
        Column # 8   [ ABND= Total Bivalvia (#/m3) ]
        Column # 10   [ ABND= Total Appendicularia (#/m3) ]
        Column # 12   [ ABND= Total Diatoms (#/L) ]
        Column # 14   [ ABND= Total Dinoflagellates (#/L) ]
        Column # 16   [ ABND= Total Ciliophora (#/L) ]
        Column # 18   [ ABND= Total Coccolithophores (#/L) ]
        Column # 20   [ ABND= Total Cryptomonads (#/L) ]

    Abundance (with zeros) Category
        Column # 36   [ ABDT1= Total Copepoda (#/m3) ]
        Column # 37   [ ABDT1= Total Rotifera (#/m3) ]
        Column # 38   [ ABDT1= Total Cirripedia (#/m3) ]
        Column # 39   [ ABDT1= Total Euphausiacea (#/m3) ]
        Column # 40   [ ABDT1= Total Polychaeta (#/m3) ]
        Column # 41   [ ABDT1= Total Gastropoda (#/m3) ]
        Column # 42   [ ABDT1= Total Bivalvia (#/m3) ]
        Column # 43   [ ABDT1= Total Chaetognatha (#/m3) ]
        Column # 44   [ ABDT1= Total Echinodermata (#/m3) ]
        Column # 45   [ ABDT1= Total Appendicularia (#/m3) ]
        Column # 46   [ ABDT2= Total Copepoda (#/m3) ]
        Column # 47   [ ABDT2= Acartia spp. (#/m3) ]
        Column # 48   [ ABDT2= Calanus spp. (#/m3) ]
        Column # 49   [ ABDT2= Centropages spp. (#/m3) ]
        Column # 50   [ ABDT2= Microsetella spp. (#/m3) ]
        Column # 51   [ ABDT2= Oithona spp. (#/m3) ]
        Column # 52   [ ABDT2= Paracalanus spp. (#/m3) ]
        Column # 53   [ ABDT2= Temora spp. (#/m3) ]
        Column # 54   [ ABDT2= Other copepoda (#/m3) ]
        Column # 56   [ ABDT1= Total Diatoms (#/L) ]
        Column # 57   [ ABDT1= Total Dinoflagellates (#/L) ]
        Column # 58   [ ABDT1= Total Cyanobacteria (#/L) ]
        Column # 59   [ ABDT1= Total Coccolithophorids (#/L) ]
        Column # 60   [ ABDT1= Total Ciliphora (#/L) ]
        Column # 61   [ ABDT1= Total Cryptomonads (#/L) ]
        Column # 62   [ ABDT1= Total Chrysomonads (#/L) ]
        Column # 63   [ ABDT1= Total Euglenophyta (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 24   [ OTHR= pH () ]
        Column # 25   [ OTHR= Oxygen (ml/l) ]
        Column # 26   [ OTHR= OxygenSat (%) ]

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

    Salinities Category
        Column # 23   [ PSAL= Salinity (pss) ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 36     [ ABDT1= Total Copepoda (#/m3) ]
        column # 37     [ ABDT1= Total Rotifera (#/m3) ]
        column # 38     [ ABDT1= Total Cirripedia (#/m3) ]
        column # 39     [ ABDT1= Total Euphausiacea (#/m3) ]
        column # 40     [ ABDT1= Total Polychaeta (#/m3) ]
        column # 41     [ ABDT1= Total Gastropoda (#/m3) ]
        column # 42     [ ABDT1= Total Bivalvia (#/m3) ]
        column # 43     [ ABDT1= Total Chaetognatha (#/m3) ]
        column # 44     [ ABDT1= Total Echinodermata (#/m3) ]
        column # 45     [ ABDT1= Total Appendicularia (#/m3) ]
        column # 56     [ ABDT1= Total Diatoms (#/L) ]
        column # 57     [ ABDT1= Total Dinoflagellates (#/L) ]
        column # 58     [ ABDT1= Total Cyanobacteria (#/L) ]
        column # 59     [ ABDT1= Total Coccolithophorids (#/L) ]
        column # 60     [ ABDT1= Total Ciliphora (#/L) ]
        column # 61     [ ABDT1= Total Cryptomonads (#/L) ]
        column # 62     [ ABDT1= Total Chrysomonads (#/L) ]
        column # 63     [ ABDT1= Total Euglenophyta (#/L) ]

    Category 8 Group # 2
        column # 46     [ ABDT2= Total Copepoda (#/m3) ]
        column # 47     [ ABDT2= Acartia spp. (#/m3) ]
        column # 48     [ ABDT2= Calanus spp. (#/m3) ]
        column # 49     [ ABDT2= Centropages spp. (#/m3) ]
        column # 50     [ ABDT2= Microsetella spp. (#/m3) ]
        column # 51     [ ABDT2= Oithona spp. (#/m3) ]
        column # 52     [ ABDT2= Paracalanus spp. (#/m3) ]
        column # 53     [ ABDT2= Temora spp. (#/m3) ]
        column # 54     [ ABDT2= Other copepoda (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1998 2023
DATES in Column 3 no problems detected 1998 2018
DATES in Column 5 no problems detected 1998 2023
DATES in Column 7 no problems detected 2007 2018
DATES in Column 9 no problems detected 1998 2018
DATES in Column 11 no problems detected 1995 2023
DATES in Column 13 no problems detected 1995 2023
DATES in Column 15 no problems detected 1995 2023
DATES in Column 17 no problems detected 1995 2023
DATES in Column 19 no problems detected 1995 2023
DATES in Column 21 no problems detected 2001 2012
DATES in Column 35 no problems detected 1998 2010
DATES in Column 55 no problems detected 2001 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1998 2023 01 12 01 31
3 DATE-YMD DATE-YMD yes 1998 2018 01 12 01 31
5 DATE-YMD DATE-YMD yes 1998 2023 01 12 01 31
7 DATE-YMD DATE-YMD yes 2007 2018 01 12 01 31
9 DATE-YMD DATE-YMD yes 1998 2018 01 12 01 31
11 DATE-YMD DATE-YMD yes 1995 2023 01 12 01 31
13 DATE-YMD DATE-YMD yes 1995 2023 01 12 01 31
15 DATE-YMD DATE-YMD yes 1995 2023 01 12 01 31
17 DATE-YMD DATE-YMD yes 1995 2023 01 12 01 31
19 DATE-YMD DATE-YMD yes 1995 2023 01 12 01 31
21 DATE-YMD DATE-YMD yes 2001 2012 1 12 1 31
35 DATE-YMD DATE-YMD yes 1998 2010 01 12 01 31
55 DATE-YMD DATE-YMD yes 2001 2010 01 12 01 31



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND= Total Copepoda (#/m3) ]
no problems detected 312 19.2000008 35911.6406 312
( 100 %)
312
( 100 %)
Column 4 :
[ 05_ABND= Total Rotifera (#/m3) ]
no problems detected 80 0.639999986 52756.5000 80
( 100 %)
79
( 98 %)
Column 6 :
[ 06_ABND= Total Cladocera (#/m3) ]
no problems detected 179 1.27999997 33423.3984 179
( 100 %)
179
( 100 %)
Column 8 :
[ 07_ABND= Total Bivalvia (#/m3) ]
no problems detected 97 1.27999997 47185.9414 97
( 100 %)
97
( 100 %)
Column 10 :
[ 08_ABND= Total Appendicularia (#/m3) ]
no problems detected 166 0.639999986 23592.9590 166
( 100 %)
165
( 99 %)
Column 12 :
[ 09_ABND= Total Diatoms (#/L) ]
no problems detected 505 50.0000000 10910755.0 505
( 100 %)
505
( 100 %)
Column 14 :
[ 10_ABND= Total Dinoflagellates (#/L) ]
no problems detected 512 50.0000000 1062427.00 512
( 100 %)
512
( 100 %)
Column 16 :
[ 11_ABND= Total Ciliophora (#/L) ]
no problems detected 499 40.0000000 310318.281 499
( 100 %)
499
( 100 %)
Column 18 :
[ 12_ABND= Total Coccolithophores (#/L) ]
no problems detected 368 373.000000 12377138.0 368
( 100 %)
368
( 100 %)
Column 20 :
[ 13_ABND= Total Cryptomonads (#/L) ]
no problems detected 505 368.600006 2776162.00 505
( 100 %)
505
( 100 %)
Column 22 :
[ 14_TEMP= Temperature (C) ]
no problems detected 268 -1.01999998 21.6000004 263
( 98 %)
254
( 94 %)
Column 23 :
[ 15_PSAL= Salinity (pss) ]
no problems detected 264 10.0050001 29.3390007 264
( 100 %)
264
( 100 %)
Column 24 :
[ 16_OTHR= pH () ]
no problems detected 258 8.06999969 8.47999954 258
( 100 %)
258
( 100 %)
Column 25 :
[ 17_OTHR= Oxygen (ml/l) ]
no problems detected 269 5.59000015 10.1800003 269
( 100 %)
269
( 100 %)
Column 26 :
[ 18_OTHR= OxygenSat (%) ]
no problems detected 261 96.0000000 129.000000 261
( 100 %)
261
( 100 %)
Column 27 :
[ 19_LOTH= Po4-P (uM) ]
no problems detected 270 1.99999996E-02 0.740000010 270
( 100 %)
0
( 0 %)
Column 28 :
[ 20_LOTH= Tot-P (uM) ]
no problems detected 263 0.129999995 1.17999995 263
( 100 %)
12
( 4 %)
Column 29 :
[ 21_LOTH= NO2-N (uM) ]
no problems detected 269 1.99999996E-02 0.819999993 269
( 100 %)
0
( 0 %)
Column 30 :
[ 22_LOTH= NO3-N (uM) ]
no problems detected 270 0.100000001 9.46000004 270
( 100 %)
51
( 18 %)
Column 31 :
[ 23_LOTH= NH4-N (uM) ]
no problems detected 262 5.00000007E-02 1.08000004 262
( 100 %)
1
( 0 %)
Column 32 :
[ 24_LOTH= Tot-N (uM) ]
no problems detected 265 8.19999981 34.7999992 265
( 100 %)
265
( 100 %)
Column 33 :
[ 25_LOTH= SiO3-Si (uM) ]
no problems detected 270 0.100000001 14.8000002 270
( 100 %)
182
( 67 %)
Column 34 :
[ 26_CHLA= Chlorophyll (ug/l) ]
no problems detected 266 0.100000001 22.2000008 266
( 100 %)
172
( 64 %)
Column 36 :
[ 27_ABDT1= Total Copepoda (#/m3) ]
no problems detected 120 114.080002 147292.172 120
( 100 %)
120
( 100 %)
Column 37 :
[ 28_ABDT1= Total Rotifera (#/m3) ]
no problems detected 120 5.11999989 52756.4805 58
( 48 %)
58
( 48 %)
Column 38 :
[ 29_ABDT1= Total Cirripedia (#/m3) ]
no problems detected 120 2.55999994 1310.71997 15
( 12 %)
15
( 12 %)
Column 39 :
[30_ABDT1= Total Euphausiacea (#/m3) ]
There is/are 2 count WARNING(S)!

Some of your values are zero or "one".

Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 120 20.4799995 327.679993 2
    ( 1 %)
    2
    ( 1 %)
    Column 40 :
    [ 31_ABDT1= Total Polychaeta (#/m3) ]
    no problems detected 120 5.11999989 2293.76001 81
    ( 67 %)
    81
    ( 67 %)
    Column 41 :
    [ 32_ABDT1= Total Gastropoda (#/m3) ]
    no problems detected 120 10.2399998 14417.9199 93
    ( 77 %)
    93
    ( 77 %)
    Column 42 :
    [ 33_ABDT1= Total Bivalvia (#/m3) ]
    no problems detected 120 10.2399998 14417.9199 93
    ( 77 %)
    93
    ( 77 %)
    Column 43 :
    [ 34_ABDT1= Total Chaetognatha (#/m3) ]
    no problems detected 120 0.159999996 655.359985 24
    ( 20 %)
    18
    ( 15 %)
    Column 44 :
    [ 35_ABDT1= Total Echinodermata (#/m3) ]
    no problems detected 120 30.7199993 3276.80005 36
    ( 30 %)
    36
    ( 30 %)
    Column 45 :
    [ 36_ABDT1= Total Appendicularia (#/m3) ]
    no problems detected 120 2.55999994 17694.7207 114
    ( 95 %)
    114
    ( 95 %)
    Column 46 :
    [ 37_ABDT2= Total Copepoda (#/m3) ]
    no problems detected 120 114.080002 147292.172 120
    ( 100 %)
    120
    ( 100 %)
    Column 47 :
    [ 38_ABDT2= Acartia spp. (#/m3) ]
    no problems detected 120 1.27999997 8519.67969 112
    ( 93 %)
    112
    ( 93 %)
    Column 48 :
    [ 39_ABDT2= Calanus spp. (#/m3) ]
    no problems detected 120 7.67999983 655.359985 54
    ( 45 %)
    54
    ( 45 %)
    Column 49 :
    [ 40_ABDT2= Centropages spp. (#/m3) ]
    no problems detected 120 7.67999983 5570.55957 111
    ( 92 %)
    111
    ( 92 %)
    Column 50 :
    [ 41_ABDT2= Microsetella spp. (#/m3) ]
    no problems detected 120 5.11999989 2621.43994 58
    ( 48 %)
    58
    ( 48 %)
    Column 51 :
    [ 42_ABDT2= Oithona spp. (#/m3) ]
    no problems detected 120 57.2799988 92405.7500 120
    ( 100 %)
    120
    ( 100 %)
    Column 52 :
    [ 43_ABDT2= Paracalanus spp. (#/m3) ]
    no problems detected 120 7.67999983 47185.9219 99
    ( 82 %)
    99
    ( 82 %)
    Column 53 :
    [ 44_ABDT2= Temora spp. (#/m3) ]
    no problems detected 120 2.55999994 38338.5586 95
    ( 79 %)
    95
    ( 79 %)
    Column 54 :
    [ 45_ABDT2= Other copepoda (#/m3) ]
    no problems detected 120 10.2399998 28835.8379 116
    ( 96 %)
    116
    ( 96 %)
    Column 56 :
    [ 46_ABDT1= Total Diatoms (#/L) ]
    no problems detected 234 100.000000 20400188.0 231
    ( 98 %)
    231
    ( 98 %)
    Column 57 :
    [ 47_ABDT1= Total Dinoflagellates (#/L) ]
    no problems detected 234 91.0000000 421392.000 232
    ( 99 %)
    232
    ( 99 %)
    Column 58 :
    [ 48_ABDT1= Total Cyanobacteria (#/L) ]
    no problems detected 234 102.000000 13100000.0 70
    ( 29 %)
    70
    ( 29 %)
    Column 59 :
    [ 49_ABDT1= Total Coccolithophorids (#/L) ]
    no problems detected 234 1726.00000 2627200.00 118
    ( 50 %)
    118
    ( 50 %)
    Column 60 :
    [ 50_ABDT1= Total Ciliphora (#/L) ]
    no problems detected 234 51.0000000 50675.0000 166
    ( 70 %)
    166
    ( 70 %)
    Column 61 :
    [ 51_ABDT1= Total Cryptomonads (#/L) ]
    no problems detected 234 1805.00000 425970.000 204
    ( 87 %)
    204
    ( 87 %)
    Column 62 :
    [ 52_ABDT1= Total Chrysomonads (#/L) ]
    no problems detected 234 51.0000000 350406.000 146
    ( 62 %)
    146
    ( 62 %)
    Column 63 :
    [ 53_ABDT1= Total Euglenophyta (#/L) ]
    no problems detected 234 50.0000000 13956.0000 17
    ( 7 %)
    17
    ( 7 %)

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