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 Diatomophyceae (#/l) at the surface]      ( date set 1 )
    Column # 3     [ABDT1= Total Dinophyceae (#/l) at the surface]      ( date set 1 )
    Column # 4     [ABDT1= Total Cryptophyceae (#/l) at the surface]      ( date set 1 )
    Column # 5     [ABDT1= Total Litostomatea (#/l) at the surface]      ( date set 1 )
    Column # 6     [ABDT1= Total Chrysophyceae (#/l) at the surface]      ( date set 1 )
    Column # 7     [ABDT1= Total Chlorophyceae (#/l) at the surface]      ( date set 1 )
    Column # 8     [ABDT1= Total Nostocophyceae (#/l) at the surface]      ( date set 1 )
    Column # 9     [ABDT1= Total Prymnesiophyceae (#/l) at the surface]      ( date set 1 )
    Column # 10     [ABDT1= Total Prasinophyceae (#/l) at the surface]      ( date set 1 )
    Column # 11     [ABDT1= Total Euglenophyceae (#/l) at the surface]      ( date set 1 )
    Column # 12     [ABDT1= Total Nanoplankton (#/l) at the surface]      ( date set 1 )
    Column # 13     [ABDT1= Total Raphidophyceae (#/l) at the surface]      ( date set 1 )
    Column # 14     [ABDT1= Total Spirotrichea (#/l) at the surface]      ( date set 1 )
    Column # 15     [ABDT1= Total Unidentified (#/l) at the surface]      ( date set 1 )

    Column # 16     [ DATE-YMD ]       Date Set = 2
    Column # 17     [BIOM2= Total Diatomophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 18     [BIOM2= Total Dinophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 19     [BIOM2= Total Cryptophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 20     [BIOM2= Total Litostomatea (ug/l) at the surface]      ( date set 2 )
    Column # 21     [BIOM2= Total Chrysophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 22     [BIOM2= Total Chlorophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 23     [BIOM2= Total Nostocophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 24     [BIOM2= Total Prymnesiophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 25     [BIOM2= Total Prasinophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 26     [BIOM2= Total Euglenophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 27     [BIOM2= Total Nanoplankton (ug/l) at the surface]      ( date set 2 )
    Column # 28     [BIOM2= Total Raphidophyceae (ug/l) at the surface]      ( date set 2 )
    Column # 29     [BIOM2= Total Spirotrichea (ug/l) at the surface]      ( date set 2 )
    Column # 30     [BIOM2= Total Unidentified (ug/l) at the surface]      ( date set 2 )

    Column # 31     [ DATE-YMD ]       Date Set = 3
    Column # 32     [TEMP= Temperature ( C )]      ( date set 3 )
    Column # 33     [PSAL= Salinity (PSS)]      ( date set 3 )
    Column # 34     [CHLA= Chlorophyll-a (ug/L)]      ( date set 3 )
    Column # 35     [OTHR= Oxygen (mg/L)]      ( date set 3 )
    Column # 36     [LOTH= NO3NO2 (uM)]      ( date set 3 )
    Column # 37     [LOTH= NH4 (uM)]      ( date set 3 )
    Column # 38     [LOTH= Nitrite (uM)]      ( date set 3 )
    Column # 39     [LOTH= Nitrate (uM)]      ( date set 3 )
    Column # 40     [LOTH= Phosphate (uM)]      ( date set 3 )
    Column # 41     [LOTH= Silicate (uM)]      ( date set 3 )
    Column # 42     [LOTH= Total Nitrogen (uM)]      ( date set 3 )
    Column # 43     [LOTH= Total Phosphorus (uM)]      ( date set 3 )
    Column # 44     [OTHR= Suspended Solids (mg/L)]      ( date set 3 )
    Column # 45     [LOTH= Turbidity (FTU)]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatomophyceae (#/l) at the surface ]
        Column # 3   [ ABDT1= Total Dinophyceae (#/l) at the surface ]
        Column # 4   [ ABDT1= Total Cryptophyceae (#/l) at the surface ]
        Column # 5   [ ABDT1= Total Litostomatea (#/l) at the surface ]
        Column # 6   [ ABDT1= Total Chrysophyceae (#/l) at the surface ]
        Column # 7   [ ABDT1= Total Chlorophyceae (#/l) at the surface ]
        Column # 8   [ ABDT1= Total Nostocophyceae (#/l) at the surface ]
        Column # 9   [ ABDT1= Total Prymnesiophyceae (#/l) at the surface ]
        Column # 10   [ ABDT1= Total Prasinophyceae (#/l) at the surface ]
        Column # 11   [ ABDT1= Total Euglenophyceae (#/l) at the surface ]
        Column # 12   [ ABDT1= Total Nanoplankton (#/l) at the surface ]
        Column # 13   [ ABDT1= Total Raphidophyceae (#/l) at the surface ]
        Column # 14   [ ABDT1= Total Spirotrichea (#/l) at the surface ]
        Column # 15   [ ABDT1= Total Unidentified (#/l) at the surface ]

    non-Log10 (linear) Miscellaenous Category
        Column # 35   [ OTHR= Oxygen (mg/L) ]
        Column # 44   [ OTHR= Suspended Solids (mg/L) ]

    Temperatures Category
        Column # 32   [ TEMP= Temperature ( C ) ]

    Salinities Category
        Column # 33   [ PSAL= Salinity (PSS) ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatomophyceae (#/l) at the surface ]
        column # 3     [ ABDT1= Total Dinophyceae (#/l) at the surface ]
        column # 4     [ ABDT1= Total Cryptophyceae (#/l) at the surface ]
        column # 5     [ ABDT1= Total Litostomatea (#/l) at the surface ]
        column # 6     [ ABDT1= Total Chrysophyceae (#/l) at the surface ]
        column # 7     [ ABDT1= Total Chlorophyceae (#/l) at the surface ]
        column # 8     [ ABDT1= Total Nostocophyceae (#/l) at the surface ]
        column # 9     [ ABDT1= Total Prymnesiophyceae (#/l) at the surface ]
        column # 10     [ ABDT1= Total Prasinophyceae (#/l) at the surface ]
        column # 11     [ ABDT1= Total Euglenophyceae (#/l) at the surface ]
        column # 12     [ ABDT1= Total Nanoplankton (#/l) at the surface ]
        column # 13     [ ABDT1= Total Raphidophyceae (#/l) at the surface ]
        column # 14     [ ABDT1= Total Spirotrichea (#/l) at the surface ]
        column # 15     [ ABDT1= Total Unidentified (#/l) at the surface ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1990 2012
DATES in Column 16 no problems detected 1990 2012
DATES in Column 31 no problems detected 1989 2012

 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 1990 2012 01 12 01 31
16 DATE-YMD DATE-YMD yes 1990 2012 01 12 01 31
31 DATE-YMD DATE-YMD yes 1989 2012 01 12 01 31



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Diatomophyceae (#/l) at the surface ]
no problems detected 278 109.970200 2856194.25 278
( 100 %)
278
( 100 %)
Column 3 :
[ 05_ABDT1= Total Dinophyceae (#/l) at the surface ]
no problems detected 141 3.33330011 2960000.00 141
( 100 %)
141
( 100 %)
Column 4 :
[ 06_ABDT1= Total Cryptophyceae (#/l) at the surface ]
no problems detected 195 3402.47168 1159301.75 195
( 100 %)
195
( 100 %)
Column 5 :
[ 07_ABDT1= Total Litostomatea (#/l) at the surface ]
no problems detected 28 19.9946003 97821.0547 28
( 100 %)
28
( 100 %)
Column 6 :
[ 08_ABDT1= Total Chrysophyceae (#/l) at the surface ]
no problems detected 38 100.000000 1199689.00 38
( 100 %)
38
( 100 %)
Column 7 :
[09_ABDT1= Total Chlorophyceae (#/l) 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")

  • 1 12122.0000 12122.0000 1
    ( 100 %)
    1
    ( 100 %)
    Column 8 :
    [10_ABDT1= Total Nostocophyceae (#/l) 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")

  • 5 79.9784012 12553033.0 5
    ( 100 %)
    5
    ( 100 %)
    Column 9 :
    [ 11_ABDT1= Total Prymnesiophyceae (#/l) at the surface ]
    no problems detected 104 8007.98145 93803416.0 104
    ( 100 %)
    104
    ( 100 %)
    Column 10 :
    [ 12_ABDT1= Total Prasinophyceae (#/l) at the surface ]
    no problems detected 16 200.000000 120000.000 16
    ( 100 %)
    16
    ( 100 %)
    Column 11 :
    [13_ABDT1= Total Euglenophyceae (#/l) 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")

  • 2 165.168503 2378.42676 2
    ( 100 %)
    2
    ( 100 %)
    Column 12 :
    [14_ABDT1= Total Nanoplankton (#/l) at the surface ]
    There is/are 1 count WARNING(S)!
    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")

  • 9 15215.1641 1237233.12 9
    ( 100 %)
    9
    ( 100 %)
    Column 13 :
    [15_ABDT1= Total Raphidophyceae (#/l) 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")

  • 5 13613.5684 6387745.50 5
    ( 100 %)
    5
    ( 100 %)
    Column 14 :
    [16_ABDT1= Total Spirotrichea (#/l) 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 15 :
    [ 17_ABDT1= Total Unidentified (#/l) at the surface ]
    no problems detected 117 11341.5723 17876154.0 117
    ( 100 %)
    117
    ( 100 %)
    Column 17 :
    [ 18_BIOM2= Total Diatomophyceae (ug/l) at the surface ]
    no problems detected 278 6.47000000E-02 625.920410 278
    ( 100 %)
    227
    ( 81 %)
    Column 18 :
    [ 19_BIOM2= Total Dinophyceae (ug/l) at the surface ]
    no problems detected 141 1.78999994E-02 810.534973 141
    ( 100 %)
    67
    ( 47 %)
    Column 19 :
    [ 20_BIOM2= Total Cryptophyceae (ug/l) at the surface ]
    no problems detected 195 8.04999992E-02 22.4067001 195
    ( 100 %)
    121
    ( 62 %)
    Column 20 :
    [ 21_BIOM2= Total Litostomatea (ug/l) at the surface ]
    no problems detected 28 1.25000002E-02 491.120697 28
    ( 100 %)
    9
    ( 32 %)
    Column 21 :
    [ 22_BIOM2= Total Chrysophyceae (ug/l) at the surface ]
    no problems detected 38 5.88000007E-02 57.9241982 38
    ( 100 %)
    17
    ( 44 %)
    Column 22 :
    [23_BIOM2= Total Chlorophyceae (ug/l) 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")

  • 1 6.17999993E-02 6.17999993E-02 1
    ( 100 %)
    0
    ( 0 %)
    Column 23 :
    [24_BIOM2= Total Nostocophyceae (ug/l) 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")

  • 5 0.635500014 2.03449988 5
    ( 100 %)
    4
    ( 80 %)
    Column 24 :
    [ 25_BIOM2= Total Prymnesiophyceae (ug/l) at the surface ]
    no problems detected 104 6.12000003E-02 2009.39539 104
    ( 100 %)
    88
    ( 84 %)
    Column 25 :
    [26_BIOM2= Total Prasinophyceae (ug/l) 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")

  • 16 2.66999993E-02 2.75000000 16
    ( 100 %)
    3
    ( 18 %)
    Column 26 :
    [27_BIOM2= Total Euglenophyceae (ug/l) 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")

  • 2 1.98999997E-02 0.346199989 2
    ( 100 %)
    0
    ( 0 %)
    Column 27 :
    [28_BIOM2= Total Nanoplankton (ug/l) at the surface ]
    There is/are 1 count WARNING(S)!
    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")

  • 9 0.330199987 8.07190037 9
    ( 100 %)
    8
    ( 88 %)
    Column 28 :
    [29_BIOM2= Total Raphidophyceae (ug/l) 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")

  • 5 2.11010003 207.596603 5
    ( 100 %)
    5
    ( 100 %)
    Column 29 :
    [30_BIOM2= Total Spirotrichea (ug/l) 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 :
    [ 31_BIOM2= Total Unidentified (ug/l) at the surface ]
    no problems detected 117 1.49999997E-02 38.8235016 117
    ( 100 %)
    90
    ( 76 %)
    Column 32 :
    [ 32_TEMP= Temperature ( C ) ]
    no problems detected 365 -1.01890004 22.1760006 361
    ( 98 %)
    358
    ( 98 %)
    Column 33 :
    [ 33_PSAL= Salinity (PSS) ]
    no problems detected 363 25.5750008 33.7000008 363
    ( 100 %)
    363
    ( 100 %)
    Column 34 :
    [ 34_CHLA= Chlorophyll-a (ug/L) ]
    no problems detected 303 0.300000012 61.0000000 303
    ( 100 %)
    292
    ( 96 %)
    Column 35 :
    [ 35_OTHR= Oxygen (mg/L) ]
    no problems detected 362 5.09999990 15.8000002 362
    ( 100 %)
    362
    ( 100 %)
    Column 36 :
    [ 36_LOTH= NO3NO2 (uM) ]
    no problems detected 303 0.107100002 63.5713997 303
    ( 100 %)
    174
    ( 57 %)
    Column 37 :
    [ 37_LOTH= NH4 (uM) ]
    no problems detected 303 0.214300007 12.8570995 303
    ( 100 %)
    160
    ( 52 %)
    Column 38 :
    [38_LOTH= Nitrite (uM) ]
    There is/are 1 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 39 :
    [39_LOTH= Nitrate (uM) ]
    There is/are 1 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 40 :
    [ 40_LOTH= Phosphate (uM) ]
    no problems detected 303 3.22999991E-02 1.45159996 303
    ( 100 %)
    24
    ( 7 %)
    Column 41 :
    [ 41_LOTH= Silicate (uM) ]
    no problems detected 284 7.14000016E-02 35.7142982 284
    ( 100 %)
    180
    ( 63 %)
    Column 42 :
    [ 42_LOTH= Total Nitrogen (uM) ]
    no problems detected 303 7.85710001 92.8571014 303
    ( 100 %)
    303
    ( 100 %)
    Column 43 :
    [ 43_LOTH= Total Phosphorus (uM) ]
    no problems detected 303 0.354799986 10.6451998 303
    ( 100 %)
    174
    ( 57 %)
    Column 44 :
    [44_OTHR= Suspended Solids (mg/L) ]
    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 45 :
    [45_LOTH= Turbidity (FTU) ]
    There is/are 1 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".