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     [ABND1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3     [ABDT1= Calanidae (#/m3)]      ( date set 1 )
    Column # 4     [ABDT1= Paracalanidae (#/m3)]      ( date set 1 )
    Column # 5     [ABDT1= Acartiidae (#/m3)]      ( date set 1 )
    Column # 6     [ABDT1= Oithonidae (#/m3)]      ( date set 1 )
    Column # 7     [ABDT2= Salpidae (#/m3)]      ( date set 1 )
    Column # 8     [ABDT2= Doliolidae (#/m3)]      ( date set 1 )

    Column # 9     [ DATE-YMD ]       Date Set = 2
    Column # 10     [BIOM= Total Dry Mass (mg/m3)]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12     [ABDT3= Total Diatoms (#/L)]      ( date set 3 )
    Column # 13     [ABDT3= Total Centric Diatoms (#/L)]      ( date set 3 )
    Column # 14     [ABDT3= Total Pennate Diatoms (#/L)]      ( date set 3 )
    Column # 15     [ABDT4= Total Dinoflagellates (#/L)]      ( date set 3 )
    Column # 16     [ABDT= Total Flagellates (#/L)]      ( date set 3 )
    Column # 17     [ABDT= Total Naked Flagellates (#/L)]      ( date set 3 )
    Column # 18     [ABDT= Total Ciliates (#/L)]      ( date set 3 )
    Column # 19     [ABDT= Total Coccolithophore (#/L)]      ( date set 3 )
    Column # 20     [ABDT= Total Cyanobacteria (#/L)]      ( date set 3 )

    Column # 21     [ DATE-YMD ]       Date Set = 4
    Column # 22     [PSAL= Salinity () at the surface]      ( date set 4 )
    Column # 23     [OTHR= Oxygen (uM) at the surface]      ( date set 4 )
    Column # 24     [LOTH= Silicate (uM) at the surface]      ( date set 4 )
    Column # 25     [LOTH= Nitrate (uM) at the surface]      ( date set 4 )
    Column # 26     [LOTH= Phosphate (uM) at the surface]      ( date set 4 )
    Column # 27     [OTHR= TCO2 (umol/kg) at the surface]      ( date set 4 )
    Column # 28     [OTHR= Total Alkalinity (umol/kg) at the surface]      ( date set 4 )

    Column # 29     [ DATE-YMD ]       Date Set = 5
    Column # 30     [TEMP= Temperature () at the surface]      ( date set 5 )
    Column # 31     [PSAL= Salinity () at the surface]      ( date set 5 )
    Column # 32     [CHLA= Fluorometric Chlorophyll () at the surface]      ( date set 5 )
    Column # 33     [OTHR= Turbidity () at the surface]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]

    Abundance (with zeros) Category
        Column # 3   [ ABDT1= Calanidae (#/m3) ]
        Column # 4   [ ABDT1= Paracalanidae (#/m3) ]
        Column # 5   [ ABDT1= Acartiidae (#/m3) ]
        Column # 6   [ ABDT1= Oithonidae (#/m3) ]
        Column # 7   [ ABDT2= Salpidae (#/m3) ]
        Column # 8   [ ABDT2= Doliolidae (#/m3) ]
        Column # 12   [ ABDT3= Total Diatoms (#/L) ]
        Column # 13   [ ABDT3= Total Centric Diatoms (#/L) ]
        Column # 14   [ ABDT3= Total Pennate Diatoms (#/L) ]
        Column # 15   [ ABDT4= Total Dinoflagellates (#/L) ]
        Column # 16   [ ABDT= Total Flagellates (#/L) ]
        Column # 17   [ ABDT= Total Naked Flagellates (#/L) ]
        Column # 18   [ ABDT= Total Ciliates (#/L) ]
        Column # 19   [ ABDT= Total Coccolithophore (#/L) ]
        Column # 20   [ ABDT= Total Cyanobacteria (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 23   [ OTHR= Oxygen (uM) at the surface ]
        Column # 27   [ OTHR= TCO2 (umol/kg) at the surface ]
        Column # 28   [ OTHR= Total Alkalinity (umol/kg) at the surface ]
        Column # 33   [ OTHR= Turbidity () at the surface ]

    Temperatures Category
        Column # 30   [ TEMP= Temperature () at the surface ]

    Salinities Category
        Column # 22   [ PSAL= Salinity () at the surface ]
        Column # 31   [ PSAL= Salinity () at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]

    Category 8 Group # 1
        column # 3     [ ABDT1= Calanidae (#/m3) ]
        column # 4     [ ABDT1= Paracalanidae (#/m3) ]
        column # 5     [ ABDT1= Acartiidae (#/m3) ]
        column # 6     [ ABDT1= Oithonidae (#/m3) ]

    Category 8 Group # 2
        column # 7     [ ABDT2= Salpidae (#/m3) ]
        column # 8     [ ABDT2= Doliolidae (#/m3) ]

    Category 8 Group # 3
        column # 12     [ ABDT3= Total Diatoms (#/L) ]
        column # 13     [ ABDT3= Total Centric Diatoms (#/L) ]
        column # 14     [ ABDT3= Total Pennate Diatoms (#/L) ]

    Category 8 Group # 4
        column # 15     [ ABDT4= Total Dinoflagellates (#/L) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2011 2015
DATES in Column 9 no problems detected 2011 2015
DATES in Column 11 no problems detected 2011 2013
DATES in Column 21 no problems detected 2011 2015
DATES in Column 29 no problems detected 2012 2014

 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 2011 2015 01 12 01 30
9 DATE-YMD DATE-YMD yes 2011 2015 01 12 01 30
11 DATE-YMD DATE-YMD yes 2011 2013 01 12 05 30
21 DATE-YMD DATE-YMD yes 2011 2015 01 12 01 30
29 DATE-YMD DATE-YMD yes 2012 2014 01 12 01 30



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND1= Total Copepods (#/m3) ]
no problems detected 19 356.578705 16728.3164 17
( 89 %)
17
( 89 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ]
no problems detected 19 21.4323006 8640.91602 17
( 89 %)
17
( 89 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ]
no problems detected 19 54.0270004 3745.87769 17
( 89 %)
17
( 89 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ]
no problems detected 19 0.982299984 82.2399979 7
( 36 %)
6
( 31 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ]
no problems detected 19 76.7986984 5196.85010 17
( 89 %)
17
( 89 %)
Column 7 :
[09_ABDT2= Salpidae (#/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")

  • 19 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 8 :
    [10_ABDT2= Doliolidae (#/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")

  • 19 58.9385986 58.9385986 1
    ( 5 %)
    1
    ( 5 %)
    Column 10 :
    [ 11_BIOM= Total Dry Mass (mg/m3) ]
    no problems detected 39 1.37520003 908.465881 39
    ( 100 %)
    39
    ( 100 %)
    Column 12 :
    [ 12_ABDT3= Total Diatoms (#/L) ]
    no problems detected 12 1521.00000 16335.0000 12
    ( 100 %)
    12
    ( 100 %)
    Column 13 :
    [ 13_ABDT3= Total Centric Diatoms (#/L) ]
    no problems detected 12 832.000000 6028.00000 12
    ( 100 %)
    12
    ( 100 %)
    Column 14 :
    [ 14_ABDT3= Total Pennate Diatoms (#/L) ]
    no problems detected 12 323.000000 14334.0000 12
    ( 100 %)
    12
    ( 100 %)
    Column 15 :
    [ 15_ABDT4= Total Dinoflagellates (#/L) ]
    no problems detected 12 46.0000000 640.000000 10
    ( 83 %)
    10
    ( 83 %)
    Column 16 :
    [16_ABDT= Total Flagellates (#/L) ]
    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")

  • 12 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 17 :
    [17_ABDT= Total Naked Flagellates (#/L) ]
    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")

  • 12 29.0000000 26220.0000 2
    ( 16 %)
    2
    ( 16 %)
    Column 18 :
    [18_ABDT= Total Ciliates (#/L) ]
    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")

  • 12 941.000000 989.000000 3
    ( 25 %)
    3
    ( 25 %)
    Column 19 :
    [19_ABDT= Total Coccolithophore (#/L) ]
    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")

  • 12 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 20 :
    [20_ABDT= Total Cyanobacteria (#/L) ]
    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")

  • 12 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 22 :
    [ 21_PSAL= Salinity () at the surface ]
    no problems detected 39 32.0099983 35.0499992 39
    ( 100 %)
    39
    ( 100 %)
    Column 23 :
    [22_OTHR= Oxygen (uM) at the surface ]
    There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!


    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 24 :
    [ 23_LOTH= Silicate (uM) at the surface ]
    no problems detected 42 3.59999990 9.00000000 42
    ( 100 %)
    42
    ( 100 %)
    Column 25 :
    [ 24_LOTH= Nitrate (uM) at the surface ]
    no problems detected 42 0.100000001 2.40000010 32
    ( 76 %)
    9
    ( 21 %)
    Column 26 :
    [ 25_LOTH= Phosphate (uM) at the surface ]
    no problems detected 42 0.159999996 0.870000005 42
    ( 100 %)
    0
    ( 0 %)
    Column 27 :
    [26_OTHR= TCO2 (umol/kg) at the surface ]
    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")

  • 40 9.99999978E-03 0.699999988 38
    ( 95 %)
    0
    ( 0 %)
    Column 28 :
    [ 27_OTHR= Total Alkalinity (umol/kg) at the surface ]
    no problems detected 36 1885.33997 2015.26001 36
    ( 100 %)
    36
    ( 100 %)
    Column 30 :
    [ 28_TEMP= Temperature () at the surface ]
    no problems detected 444 24.0855999 32.2256012 444
    ( 100 %)
    444
    ( 100 %)
    Column 31 :
    [ 29_PSAL= Salinity () at the surface ]
    no problems detected 444 31.9906998 35.0211983 444
    ( 100 %)
    444
    ( 100 %)
    Column 32 :
    [ 30_CHLA= Fluorometric Chlorophyll () at the surface ]
    no problems detected 444 0.123499997 13.3088999 444
    ( 100 %)
    193
    ( 43 %)
    Column 33 :
    [31_OTHR= Turbidity () at the surface ]
    There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!


    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)

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