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 2013
DATES in Column 9 no problems detected 2009 2013
DATES in Column 11 no problems detected 2009 2013
DATES in Column 13 no problems detected 2009 2013
DATES in Column 23 no problems detected 2009 2013
DATES in Column 31 no problems detected 2009 2013

 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 2013 01 12 09 30
9 DATE-MDY DATE-MDY yes 1 12 10 30 2009 2013
11 DATE-YMD DATE-YMD yes 2009 2013 01 12 09 30
13 DATE-YMD DATE-YMD yes 2009 2013 01 12 10 30
23 DATE-YMD DATE-YMD yes 2009 2013 01 12 10 30
31 DATE-YMD DATE-YMD yes 2009 2013 01 12 09 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 17 864.433716 8385.00293 17
( 100 %)
17
( 100 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ]
no problems detected 17 148.656296 3850.65747 16
( 94 %)
16
( 94 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ]
no problems detected 17 3.92919993 773.569519 17
( 100 %)
17
( 100 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ]
no problems detected 17 51.0801010 377.207306 16
( 94 %)
16
( 94 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ]
no problems detected 17 55.0094986 3104.10132 17
( 100 %)
17
( 100 %)
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")

  • 17 23.5755005 23.5755005 2
    ( 11 %)
    2
    ( 11 %)
    Column 8 :
    [ 10_ABDT2= Doliolidae (#/m3) ]
    no problems detected 17 3.92919993 220.037598 11
    ( 64 %)
    11
    ( 64 %)
    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")

  • 17 0.157000005 0.714999974 17
    ( 100 %)
    0
    ( 0 %)
    Column 12 :
    [ 12_BIOM= Total Dry Mass (mg/m3) ]
    no problems detected 17 3.66199994 23.9526997 17
    ( 100 %)
    17
    ( 100 %)
    Column 14 :
    [ 13_ABDT3= Total Diatoms (#/L) ]
    no problems detected 17 448.000000 19369.0000 17
    ( 100 %)
    17
    ( 100 %)
    Column 15 :
    [ 14_ABDT3= Total Centric Diatoms (#/L) ]
    no problems detected 17 263.000000 19192.0000 17
    ( 100 %)
    17
    ( 100 %)
    Column 16 :
    [ 15_ABDT3= Total Pennate Diatoms (#/L) ]
    no problems detected 17 53.0000000 1219.00000 17
    ( 100 %)
    17
    ( 100 %)
    Column 17 :
    [ 16_ABDT4= Total Dinoflagellates (#/L) ]
    no problems detected 17 196.000000 2113.00000 17
    ( 100 %)
    17
    ( 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")

  • 17 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 19 :
    [ 18_ABDT= Total Naked Flagellates (#/L) ]
    no problems detected 17 498.000000 43394.0000 15
    ( 88 %)
    15
    ( 88 %)
    Column 20 :
    [19_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")

  • 17 124.000000 877.000000 5
    ( 29 %)
    5
    ( 29 %)
    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")

  • 17 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    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")

  • 17 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 24 :
    [ 22_PSAL= Salinity () at the surface ]
    no problems detected 15 35.3899994 35.9099998 15
    ( 100 %)
    15
    ( 100 %)
    Column 25 :
    [ 23_OTHR= Oxygen (uM) at the surface ]
    no problems detected 16 0.699999988 1.79999995 16
    ( 100 %)
    13
    ( 81 %)
    Column 26 :
    [ 24_LOTH= Silicate (uM) at the surface ]
    no problems detected 15 0.100000001 0.200000003 4
    ( 26 %)
    0
    ( 0 %)
    Column 27 :
    [ 25_LOTH= Nitrate (uM) at the surface ]
    no problems detected 15 1.99999996E-02 0.180000007 14
    ( 93 %)
    0
    ( 0 %)
    Column 28 :
    [ 26_LOTH= Phosphate (uM) at the surface ]
    no problems detected 15 1.99999996E-02 0.310000002 15
    ( 100 %)
    0
    ( 0 %)
    Column 29 :
    [27_OTHR= TCO2 (umol/kg) 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 30 :
    [ 28_OTHR= Total Alkalinity (umol/kg) at the surface ]
    no problems detected 17 2030.54004 2082.89990 17
    ( 100 %)
    17
    ( 100 %)
    Column 32 :
    [ 29_TEMP= Temperature () at the surface ]
    no problems detected 47 16.5674992 21.1669006 47
    ( 100 %)
    47
    ( 100 %)
    Column 33 :
    [ 30_PSAL= Salinity () at the surface ]
    no problems detected 47 35.4333000 35.8797989 47
    ( 100 %)
    47
    ( 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")

  • 47 0.134399995 0.465499997 47
    ( 100 %)
    0
    ( 0 %)
    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".