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 )

    Column # 36     [ DATE-YMD ]       Date Set = 7
    Column # 37     [TEMP= Temperature ( C ) at 5m]      ( date set 7 )
    Column # 38     [TEMP= Temperature ( C ) at 10m]      ( date set 7 )
    Column # 39     [TEMP= Temperature ( C ) at 20m]      ( date set 7 )
    Column # 40     [TEMP= Temperature ( C ) at 30m]      ( date set 7 )
    Column # 41     [TEMP= Temperature ( C ) at 40m]      ( date set 7 )
    Column # 42     [TEMP= Temperature ( C ) at 50m]      ( date set 7 )


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 ]
        Column # 37   [ TEMP= Temperature ( C ) at 5m ]
        Column # 38   [ TEMP= Temperature ( C ) at 10m ]
        Column # 39   [ TEMP= Temperature ( C ) at 20m ]
        Column # 40   [ TEMP= Temperature ( C ) at 30m ]
        Column # 41   [ TEMP= Temperature ( C ) at 40m ]
        Column # 42   [ TEMP= Temperature ( C ) at 50m ]

    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 2009 2015
DATES in Column 31 no problems detected 2009 2012
DATES in Column 36 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 2015 01 12 01 31
9 DATE-MDY DATE-MDY yes 1 12 1 31 2009 2014
11 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 31
13 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 31
23 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 31
31 DATE-YMD DATE-YMD yes 2009 2012 01 12 01 31
36 DATE-YMD DATE-YMD yes 2009 2013 Apr Sep 1 31



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 68 15.9476004 2126.84302 67
( 98 %)
67
( 98 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ]
no problems detected 68 2.58179998 716.693787 67
( 98 %)
67
( 98 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ]
no problems detected 68 0.353599995 439.513794 67
( 98 %)
64
( 94 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ]
no problems detected 68 0.221000001 580.966614 63
( 92 %)
59
( 86 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ]
no problems detected 68 1.94500005 572.441528 67
( 98 %)
67
( 98 %)
Column 7 :
[ 09_ABDT2= Salpidae (#/m3) ]
no problems detected 68 0.736699998 87.2292023 16
( 23 %)
14
( 20 %)
Column 8 :
[ 10_ABDT2= Doliolidae (#/m3) ]
no problems detected 68 0.884100020 88.4078979 18
( 26 %)
17
( 25 %)
Column 10 :
[ 11_CHLA= Chlorophyll (mg/m3) ]
no problems detected 57 9.89999995E-02 1.66400003 57
( 100 %)
8
( 14 %)
Column 12 :
[ 12_BIOM= Total Dry Mass (mg/m3) ]
no problems detected 68 0.185599998 84.4142990 68
( 100 %)
60
( 88 %)
Column 14 :
[ 13_ABDT3= Total Diatoms (#/L) ]
no problems detected 65 24.0000000 202955.000 62
( 95 %)
62
( 95 %)
Column 15 :
[ 14_ABDT3= Total Centric Diatoms (#/L) ]
no problems detected 65 19.0000000 200492.000 61
( 93 %)
61
( 93 %)
Column 16 :
[ 15_ABDT3= Total Pennate Diatoms (#/L) ]
no problems detected 65 24.0000000 12086.0000 56
( 86 %)
56
( 86 %)
Column 17 :
[ 16_ABDT4= Total Dinoflagellates (#/L) ]
no problems detected 65 23.0000000 12534.0000 60
( 92 %)
60
( 92 %)
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")

  • 65 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 19 :
    [ 18_ABDT= Total Naked Flagellates (#/L) ]
    no problems detected 65 375.000000 66255.0000 61
    ( 93 %)
    61
    ( 93 %)
    Column 20 :
    [ 19_ABDT= Total Ciliates (#/L) ]
    no problems detected 65 19.0000000 2661.00000 47
    ( 72 %)
    47
    ( 72 %)
    Column 21 :
    [ 20_ABDT= Total Coccolithophore (#/L) ]
    no problems detected 65 24.0000000 550.000000 6
    ( 9 %)
    6
    ( 9 %)
    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")

  • 65 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 24 :
    [ 22_PSAL= Salinity () at the surface ]
    no problems detected 67 34.9700012 35.5999985 67
    ( 100 %)
    67
    ( 100 %)
    Column 25 :
    [ 23_OTHR= Oxygen (uM) at the surface ]
    no problems detected 51 238.300003 291.399994 51
    ( 100 %)
    51
    ( 100 %)
    Column 26 :
    [ 24_LOTH= Silicate (uM) at the surface ]
    no problems detected 70 0.100000001 2.00000000 65
    ( 92 %)
    14
    ( 20 %)
    Column 27 :
    [ 25_LOTH= Nitrate (uM) at the surface ]
    no problems detected 70 0.100000001 5.19999981 56
    ( 80 %)
    42
    ( 60 %)
    Column 28 :
    [ 26_LOTH= Phosphate (uM) at the surface ]
    no problems detected 70 5.00000007E-02 0.460000008 70
    ( 100 %)
    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")

  • 67 9.99999978E-03 0.469999999 59
    ( 88 %)
    0
    ( 0 %)
    Column 30 :
    [ 28_OTHR= Total Alkalinity (umol/kg) at the surface ]
    no problems detected 61 2048.22998 2099.73999 61
    ( 100 %)
    61
    ( 100 %)
    Column 32 :
    [ 29_TEMP= Temperature () at the surface ]
    no problems detected 132 12.1183996 18.3096008 132
    ( 100 %)
    132
    ( 100 %)
    Column 33 :
    [ 30_PSAL= Salinity () at the surface ]
    no problems detected 132 34.9772987 36.0998001 132
    ( 100 %)
    132
    ( 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")

  • 131 3.97999994E-02 0.525200009 131
    ( 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 %)
    Column 37 :
    [ 33_TEMP= Temperature ( C ) at 5m ]
    no problems detected 38 12.1183996 18.0846004 38
    ( 100 %)
    38
    ( 100 %)
    Column 38 :
    [ 34_TEMP= Temperature ( C ) at 10m ]
    no problems detected 38 11.9761000 17.8822002 38
    ( 100 %)
    38
    ( 100 %)
    Column 39 :
    [ 35_TEMP= Temperature ( C ) at 20m ]
    no problems detected 38 11.9110003 17.8052006 38
    ( 100 %)
    38
    ( 100 %)
    Column 40 :
    [ 36_TEMP= Temperature ( C ) at 30m ]
    no problems detected 38 11.8393002 17.6387005 38
    ( 100 %)
    38
    ( 100 %)
    Column 41 :
    [ 37_TEMP= Temperature ( C ) at 40m ]
    no problems detected 38 11.8374996 17.3941002 38
    ( 100 %)
    38
    ( 100 %)
    Column 42 :
    [ 38_TEMP= Temperature ( C ) at 50m ]
    no problems detected 38 11.7868996 17.2168999 38
    ( 100 %)
    38
    ( 100 %)

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