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-MDY ]       Date Set = 2
    Column # 10     [CHLA= Chlorophyll (mg/m3)]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12     [BIOM= Total Dry Mass (mg/m3)]      ( date set 3 )

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

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

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


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 # 14   [ ABDT3= Total Diatoms (#/L) ]
        Column # 15   [ ABDT3= Total Centric Diatoms (#/L) ]
        Column # 16   [ ABDT3= Total Pennate Diatoms (#/L) ]
        Column # 17   [ ABDT4= Total Dinoflagellates (#/L) ]
        Column # 18   [ ABDT= Total Flagellates (#/L) ]
        Column # 19   [ ABDT= Total Naked Flagellates (#/L) ]
        Column # 20   [ ABDT= Total Ciliates (#/L) ]
        Column # 21   [ ABDT= Total Coccolithophore (#/L) ]
        Column # 22   [ ABDT= Total Cyanobacteria (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 25   [ OTHR= Oxygen (uM) at the surface ]
        Column # 29   [ OTHR= TCO2 (umol/kg) at the surface ]
        Column # 30   [ OTHR= Total Alkalinity (umol/kg) at the surface ]
        Column # 35   [ OTHR= Turbidity () at the surface ]

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

    Salinities Category
        Column # 24   [ PSAL= Salinity () at the surface ]
        Column # 33   [ 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 # 14     [ ABDT3= Total Diatoms (#/L) ]
        column # 15     [ ABDT3= Total Centric Diatoms (#/L) ]
        column # 16     [ ABDT3= Total Pennate Diatoms (#/L) ]

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



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2009 2015
DATES in Column 9 no problems detected 2009 2014
DATES in Column 11 no problems detected 2009 2015
DATES in Column 13 no problems detected 2009 2015
DATES in Column 23 no problems detected 2008 2015
DATES in Column 31 no problems detected 2008 2015

 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 2009 2015 01 12 02 30
9 DATE-MDY DATE-MDY yes 1 12 7 28 2009 2014
11 DATE-YMD DATE-YMD yes 2009 2015 01 12 02 30
13 DATE-YMD DATE-YMD yes 2009 2015 01 12 02 29
23 DATE-YMD DATE-YMD yes 2008 2015 01 12 02 30
31 DATE-YMD DATE-YMD yes 2008 2015 01 12 01 29



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 31 7.85099983 2571.97021 25
( 80 %)
25
( 80 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ]
no problems detected 31 1.48529994 629.464600 25
( 80 %)
25
( 80 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ]
no problems detected 31 3.53999995E-02 58.3493004 24
( 77 %)
19
( 61 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ]
no problems detected 31 0.176899999 70.7263031 23
( 74 %)
21
( 67 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ]
no problems detected 31 1.20249999 453.546906 25
( 80 %)
25
( 80 %)
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")

  • 31 1.01040006 186.717606 4
    ( 12 %)
    4
    ( 12 %)
    Column 8 :
    [ 10_ABDT2= Doliolidae (#/m3) ]
    no problems detected 31 7.06999972E-02 70.7264023 12
    ( 38 %)
    7
    ( 22 %)
    Column 10 :
    [11_CHLA= Chlorophyll (mg/m3) ]
    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")

  • 31 9.20000002E-02 0.819000006 31
    ( 100 %)
    0
    ( 0 %)
    Column 12 :
    [ 12_BIOM= Total Dry Mass (mg/m3) ]
    no problems detected 29 1.79999997E-03 151.467606 29
    ( 100 %)
    20
    ( 68 %)
    Column 14 :
    [ 13_ABDT3= Total Diatoms (#/L) ]
    no problems detected 30 149.000000 104331.000 30
    ( 100 %)
    30
    ( 100 %)
    Column 15 :
    [ 14_ABDT3= Total Centric Diatoms (#/L) ]
    no problems detected 30 100.000000 102563.000 30
    ( 100 %)
    30
    ( 100 %)
    Column 16 :
    [ 15_ABDT3= Total Pennate Diatoms (#/L) ]
    no problems detected 30 22.0000000 4318.00000 27
    ( 90 %)
    27
    ( 90 %)
    Column 17 :
    [ 16_ABDT4= Total Dinoflagellates (#/L) ]
    no problems detected 30 18.0000000 9630.00000 30
    ( 100 %)
    30
    ( 100 %)
    Column 18 :
    [17_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")

  • 30 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 19 :
    [ 18_ABDT= Total Naked Flagellates (#/L) ]
    no problems detected 30 500.000000 50884.0000 29
    ( 96 %)
    29
    ( 96 %)
    Column 20 :
    [ 19_ABDT= Total Ciliates (#/L) ]
    no problems detected 30 35.0000000 474.000000 8
    ( 26 %)
    8
    ( 26 %)
    Column 21 :
    [20_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")

  • 30 26.0000000 26.0000000 1
    ( 3 %)
    1
    ( 3 %)
    Column 22 :
    [21_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")

  • 30 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 24 :
    [ 22_PSAL= Salinity () at the surface ]
    no problems detected 33 35.5499992 36.2799988 33
    ( 100 %)
    33
    ( 100 %)
    Column 25 :
    [23_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 26 :
    [ 24_LOTH= Silicate (uM) at the surface ]
    no problems detected 32 0.100000001 1.60000002 24
    ( 75 %)
    1
    ( 3 %)
    Column 27 :
    [ 25_LOTH= Nitrate (uM) at the surface ]
    no problems detected 32 0.100000001 0.800000012 17
    ( 53 %)
    0
    ( 0 %)
    Column 28 :
    [ 26_LOTH= Phosphate (uM) at the surface ]
    no problems detected 32 1.99999996E-02 0.349999994 31
    ( 96 %)
    0
    ( 0 %)
    Column 29 :
    [27_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")

  • 30 1.99999996E-02 2.77999997 26
    ( 86 %)
    1
    ( 3 %)
    Column 30 :
    [ 28_OTHR= Total Alkalinity (umol/kg) at the surface ]
    no problems detected 33 2075.03003 2134.43994 33
    ( 100 %)
    33
    ( 100 %)
    Column 32 :
    [ 29_TEMP= Temperature () at the surface ]
    no problems detected 99 14.8355999 19.4759007 99
    ( 100 %)
    99
    ( 100 %)
    Column 33 :
    [ 30_PSAL= Salinity () at the surface ]
    no problems detected 57 35.4718018 36.0667992 57
    ( 100 %)
    57
    ( 100 %)
    Column 34 :
    [31_CHLA= Fluorometric Chlorophyll () 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")

  • 24 9.89999995E-02 2.17939997 24
    ( 100 %)
    1
    ( 4 %)
    Column 35 :
    [32_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".