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    [ABDT1=Total Copepods (#/m3) from 0-50m]      ( date set 1 )
    Column # 3    [ABDT1=Calanus finmarchicus (#/m3) from 0-50m]      ( date set 1 )
    Column # 4    [ABDT1=Oithona (#/m3) from 0-50m]      ( date set 1 )
    Column # 5    [ABDT1=Temora (#/m3) from 0-50m]      ( date set 1 )
    Column # 6    [ABDT1=Acartia (#/m3) from 0-50m]      ( date set 1 )
    Column # 7    [ABDT1=Other_copepods (#/m3) from 0-50m]      ( date set 1 )
    Column # 8    [ABDT2= Calanus finmarchicus C1 (#/m3) from 0-50m]      ( date set 1 )
    Column # 9    [ABDT2= Calanus finmarchicus C2 (#/m3) from 0-50m]      ( date set 1 )
    Column # 10    [ABDT2= Calanus finmarchicus C3 (#/m3) from 0-50m]      ( date set 1 )
    Column # 11    [ABDT2= Calanus finmarchicus C4 (#/m3) from 0-50m]      ( date set 1 )
    Column # 12    [ABDT2= Calanus finmarchicus C5 (#/m3) from 0-50m]      ( date set 1 )
    Column # 13    [ABDT2= Calanus finmarchicus C6 (#/m3) from 0-50m]      ( date set 1 )

    Column # 14     [ DATE-YMD ]       Date Set = 2
    Column # 15    [BIOM= Total Dry Mass (mg/m3) from 0-50m On-Shelf]      ( date set 2 )

    Column # 16     [ DATE-YMD ]       Date Set = 3
    Column # 17    [BIOM= Total Dry Mass (mg/m3) from 0-50m Off-Shelf]      ( date set 3 )

    Column # 18     [ DATE-YMD ]       Date Set = 4
    Column # 19    [TEMP= Temperature (C) from 5-50m]      ( date set 4 )
    Column # 20    [PSAL= Salinity () from 5-50]      ( date set 4 )

    Column # 21     [ DATE-DMY ]       Date Set = 5
    Column # 22    [CHLA= Chlorophyll-a (ug/L)]      ( date set 5 )

    Column # 23     [ DATE-DMY ]       Date Set = 6
    Column # 24    [LOTH= Nitrate (uM)]      ( date set 6 )

    Column # 25     [ DATE-DMY ]       Date Set = 7
    Column # 26    [LOTH= Silicate (uM)]      ( date set 7 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 15   [ BIOM= Total Dry Mass (mg/m3) from 0-50m On-Shelf ]
        Column # 17   [ BIOM= Total Dry Mass (mg/m3) from 0-50m Off-Shelf ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT1=Total Copepods (#/m3) from 0-50m ]
        Column # 3   [ ABDT1=Calanus finmarchicus (#/m3) from 0-50m ]
        Column # 4   [ ABDT1=Oithona (#/m3) from 0-50m ]
        Column # 5   [ ABDT1=Temora (#/m3) from 0-50m ]
        Column # 6   [ ABDT1=Acartia (#/m3) from 0-50m ]
        Column # 7   [ ABDT1=Other_copepods (#/m3) from 0-50m ]
        Column # 8   [ ABDT2= Calanus finmarchicus C1 (#/m3) from 0-50m ]
        Column # 9   [ ABDT2= Calanus finmarchicus C2 (#/m3) from 0-50m ]
        Column # 10   [ ABDT2= Calanus finmarchicus C3 (#/m3) from 0-50m ]
        Column # 11   [ ABDT2= Calanus finmarchicus C4 (#/m3) from 0-50m ]
        Column # 12   [ ABDT2= Calanus finmarchicus C5 (#/m3) from 0-50m ]
        Column # 13   [ ABDT2= Calanus finmarchicus C6 (#/m3) from 0-50m ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 24   [ LOTH= Nitrate (uM) ]
        Column # 26   [ LOTH= Silicate (uM) ]

    Temperatures Category
        Column # 19   [ TEMP= Temperature (C) from 5-50m ]

    Salinities Category
        Column # 20   [ PSAL= Salinity () from 5-50 ]

    Chlorophyll/Pigments Category
        Column # 22   [ CHLA= Chlorophyll-a (ug/L) ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1=Total Copepods (#/m3) from 0-50m ]
        column # 3     [ ABDT1=Calanus finmarchicus (#/m3) from 0-50m ]
        column # 4     [ ABDT1=Oithona (#/m3) from 0-50m ]
        column # 5     [ ABDT1=Temora (#/m3) from 0-50m ]
        column # 6     [ ABDT1=Acartia (#/m3) from 0-50m ]
        column # 7     [ ABDT1=Other_copepods (#/m3) from 0-50m ]

    Category 8 Group # 2
        column # 8     [ ABDT2= Calanus finmarchicus C1 (#/m3) from 0-50m ]
        column # 9     [ ABDT2= Calanus finmarchicus C2 (#/m3) from 0-50m ]
        column # 10     [ ABDT2= Calanus finmarchicus C3 (#/m3) from 0-50m ]
        column # 11     [ ABDT2= Calanus finmarchicus C4 (#/m3) from 0-50m ]
        column # 12     [ ABDT2= Calanus finmarchicus C5 (#/m3) from 0-50m ]
        column # 13     [ ABDT2= Calanus finmarchicus C6 (#/m3) from 0-50m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1989 2018
DATES in Column 14 no problems detected 1989 2018
DATES in Column 16 no problems detected 1989 2018
DATES in Column 18 no problems detected 1983 2018
DATES in Column 21 no problems detected 1997 2011
DATES in Column 23 no problems detected 1995 2004
DATES in Column 25 no problems detected 1995 2011

 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 1989 2018 06 06 15 15
14 DATE-YMD DATE-YMD yes 1989 2018 06 06 15 15
16 DATE-YMD DATE-YMD yes 1989 2018 06 06 15 15
18 DATE-YMD DATE-YMD yes 1983 2018 06 06 15 15
21 DATE-DMY DATE-DMY yes 1 31 1 12 1997 2011
23 DATE-DMY DATE-DMY yes 1 31 1 12 1995 2004
25 DATE-DMY DATE-DMY yes 1 31 1 12 1995 2011



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1=Total Copepods (#/m3) from 0-50m ]
no problems detected 28 97.2799988 7478.8501 28
( 100%)
28
( 100%)
Column 3 :
[ 05_ABDT1=Calanus finmarchicus (#/m3) from 0-50m ]
no problems detected 28 0.800000012 839.679993 28
( 100%)
27
( 96%)
Column 4 :
[ 06_ABDT1=Oithona (#/m3) from 0-50m ]
no problems detected 28 4.48000002 409.600006 28
( 100%)
28
( 100%)
Column 5 :
[ 07_ABDT1=Temora (#/m3) from 0-50m ]
no problems detected 28 10.0799999 6819.83984 28
( 100%)
28
( 100%)
Column 6 :
[ 08_ABDT1=Acartia (#/m3) from 0-50m ]
no problems detected 28 23.0400009 867.840027 28
( 100%)
28
( 100%)
Column 7 :
[ 09_ABDT1=Other_copepods (#/m3) from 0-50m ]
no problems detected 28 7.19999981 266.23999 28
( 100%)
28
( 100%)
Column 8 :
[ 10_ABDT2= Calanus finmarchicus C1 (#/m3) from 0-50m ]
no problems detected 28 0.319999993 138.979996 25
( 89%)
24
( 85%)
Column 9 :
[ 11_ABDT2= Calanus finmarchicus C2 (#/m3) from 0-50m ]
no problems detected 28 5.11999989 81.9199982 26
( 92%)
26
( 92%)
Column 10 :
[ 12_ABDT2= Calanus finmarchicus C3 (#/m3) from 0-50m ]
no problems detected 28 0.159999996 76.8000031 27
( 96%)
26
( 92%)
Column 11 :
[ 13_ABDT2= Calanus finmarchicus C4 (#/m3) from 0-50m ]
no problems detected 28 0.159999996 197.119995 27
( 96%)
24
( 85%)
Column 12 :
[ 14_ABDT2= Calanus finmarchicus C5 (#/m3) from 0-50m ]
no problems detected 28 0.159999996 337.920013 26
( 92%)
24
( 85%)
Column 13 :
[ 15_ABDT2= Calanus finmarchicus C6 (#/m3) from 0-50m ]
no problems detected 28 1.27999997 174.080002 20
( 71%)
20
( 71%)
Column 15 :
[16_BIOM= Total Dry Mass (mg/m3) from 0-50m On-Shelf ]
There is/are 1 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")

  • 30 0.0199999996 0.540000021 30
    ( 100%)
    0
    ( 0%)
    Column 17 :
    [17_BIOM= Total Dry Mass (mg/m3) from 0-50m Off-Shelf ]
    There is/are 1 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")

  • 29 0.0399999991 0.569999993 29
    ( 100%)
    0
    ( 0%)
    Column 19 :
    [ 18_TEMP= Temperature (C) from 5-50m ]
    no problems detected 33 7.11000013 9.40999985 33
    ( 100%)
    33
    ( 100%)
    Column 20 :
    [ 19_PSAL= Salinity () from 5-50 ]
    no problems detected 33 35.0200005 35.2900009 33
    ( 100%)
    33
    ( 100%)
    Column 22 :
    [ 20_CHLA= Chlorophyll-a (ug/L) ]
    no problems detected 300 0.0399999991 11.6099997 300
    ( 100%)
    142
    ( 47%)
    Column 24 :
    [ 21_LOTH= Nitrate (uM) ]
    no problems detected 760 0.100000001 13.1000004 751
    ( 98%)
    731
    ( 96%)
    Column 26 :
    [ 22_LOTH= Silicate (uM) ]
    no problems detected 1034 0.109999999 9.60000038 1034
    ( 100%)
    1004
    ( 97%)

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