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

    Total Biomass Category
        Column # 17   [ BIOM2= Total Diatomophyceae (ug/l) at the surface ]
        Column # 18   [ BIOM2= Total Dinophyceae (ug/l) at the surface ]
        Column # 19   [ BIOM2= Total Cryptophyceae (ug/l) at the surface ]
        Column # 20   [ BIOM2= Total Litostomatea (ug/l) at the surface ]
        Column # 21   [ BIOM2= Total Chrysophyceae (ug/l) at the surface ]
        Column # 22   [ BIOM2= Total Chlorophyceae (ug/l) at the surface ]
        Column # 23   [ BIOM2= Total Nostocophyceae (ug/l) at the surface ]
        Column # 24   [ BIOM2= Total Prymnesiophyceae (ug/l) at the surface ]
        Column # 25   [ BIOM2= Total Prasinophyceae (ug/l) at the surface ]
        Column # 26   [ BIOM2= Total Euglenophyceae (ug/l) at the surface ]
        Column # 27   [ BIOM2= Total Nanoplankton (ug/l) at the surface ]
        Column # 28   [ BIOM2= Total Raphidophyceae (ug/l) at the surface ]
        Column # 29   [ BIOM2= Total Spirotrichea (ug/l) at the surface ]
        Column # 30   [ BIOM2= Total Unidentified (ug/l) at the surface ]

    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 ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 36   [ LOTH= NO3NO2 (uM) ]
        Column # 37   [ LOTH= NH4 (uM) ]
        Column # 38   [ LOTH= Nitrite (uM) ]
        Column # 39   [ LOTH= Nitrate (uM) ]
        Column # 40   [ LOTH= Phosphate (uM) ]
        Column # 41   [ LOTH= Silicate (uM) ]
        Column # 42   [ LOTH= Total Nitrogen (uM) ]
        Column # 43   [ LOTH= Total Phosphorus (uM) ]
        Column # 45   [ LOTH= Turbidity (FTU) ]

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

    Chlorophyll/Pigments Category
        Column # 34   [ CHLA= Chlorophyll-a (ug/L) ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 2
        column # 17     [ BIOM2= Total Diatomophyceae (ug/l) at the surface ]
        column # 18     [ BIOM2= Total Dinophyceae (ug/l) at the surface ]
        column # 19     [ BIOM2= Total Cryptophyceae (ug/l) at the surface ]
        column # 20     [ BIOM2= Total Litostomatea (ug/l) at the surface ]
        column # 21     [ BIOM2= Total Chrysophyceae (ug/l) at the surface ]
        column # 22     [ BIOM2= Total Chlorophyceae (ug/l) at the surface ]
        column # 23     [ BIOM2= Total Nostocophyceae (ug/l) at the surface ]
        column # 24     [ BIOM2= Total Prymnesiophyceae (ug/l) at the surface ]
        column # 25     [ BIOM2= Total Prasinophyceae (ug/l) at the surface ]
        column # 26     [ BIOM2= Total Euglenophyceae (ug/l) at the surface ]
        column # 27     [ BIOM2= Total Nanoplankton (ug/l) at the surface ]
        column # 28     [ BIOM2= Total Raphidophyceae (ug/l) at the surface ]
        column # 29     [ BIOM2= Total Spirotrichea (ug/l) at the surface ]
        column # 30     [ BIOM2= Total Unidentified (ug/l) at the surface ]

    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 1989 2009
DATES in Column 16 no problems detected 1989 2009
DATES in Column 31 no problems detected 1985 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 1989 2009 01 12 01 31
16 DATE-YMD DATE-YMD yes 1989 2009 01 12 01 31
31 DATE-YMD DATE-YMD yes 1985 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 405 49.9990005 609248.438 405
( 100%)
405
( 100%)
Column 3 :
[ 05_ABDT1= Total Dinophyceae (#/l) at the surface ]
no problems detected 405 20. 58649.7617 405
( 100%)
405
( 100%)
Column 4 :
[ 06_ABDT1= Total Cryptophyceae (#/l) at the surface ]
no problems detected 400 2552.5481 616617.312 400
( 100%)
400
( 100%)
Column 5 :
[ 07_ABDT1= Total Litostomatea (#/l) at the surface ]
no problems detected 348 20. 16495.9766 348
( 100%)
348
( 100%)
Column 6 :
[ 08_ABDT1= Total Chrysophyceae (#/l) at the surface ]
no problems detected 364 20. 931680.062 364
( 100%)
364
( 100%)
Column 7 :
[ 09_ABDT1= Total Chlorophyceae (#/l) at the surface ]
no problems detected 74 20. 5315625. 74
( 100%)
74
( 100%)
Column 8 :
[ 10_ABDT1= Total Nostocophyceae (#/l) at the surface ]
no problems detected 198 39.9990005 1102878.62 198
( 100%)
198
( 100%)
Column 9 :
[ 11_ABDT1= Total Prymnesiophyceae (#/l) at the surface ]
no problems detected 285 239.994995 9025810. 285
( 100%)
285
( 100%)
Column 10 :
[ 12_ABDT1= Total Prasinophyceae (#/l) at the surface ]
no problems detected 167 1276.27405 393092.406 167
( 100%)
167
( 100%)
Column 11 :
[ 13_ABDT1= Total Euglenophyceae (#/l) at the surface ]
no problems detected 213 20. 26159.4766 213
( 100%)
213
( 100%)
Column 12 :
[14_ABDT1= Total Nanoplankton (#/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. -9999999. 0
    ( -2147483648%)
    0
    ( -2147483648%)
    Column 13 :
    [ 15_ABDT1= Total Raphidophyceae (#/l) at the surface ]
    no problems detected 88 79.9980011 1977974.5 88
    ( 100%)
    88
    ( 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. -9999999. 0
    ( -2147483648%)
    0
    ( -2147483648%)
    Column 15 :
    [ 17_ABDT1= Total Unidentified (#/l) at the surface ]
    no problems detected 404 6381.36914 12495000. 404
    ( 100%)
    404
    ( 100%)
    Column 17 :
    [ 18_BIOM2= Total Diatomophyceae (ug/l) at the surface ]
    no problems detected 405 0.0114000002 37.0736008 405
    ( 100%)
    253
    ( 62%)
    Column 18 :
    [ 19_BIOM2= Total Dinophyceae (ug/l) at the surface ]
    no problems detected 405 0.0322999991 80.1223984 405
    ( 100%)
    218
    ( 53%)
    Column 19 :
    [ 20_BIOM2= Total Cryptophyceae (ug/l) at the surface ]
    no problems detected 400 0.0110999998 14.2968998 400
    ( 100%)
    108
    ( 27%)
    Column 20 :
    [ 21_BIOM2= Total Litostomatea (ug/l) at the surface ]
    no problems detected 348 0.00389999989 16.1502991 348
    ( 100%)
    64
    ( 18%)
    Column 21 :
    [ 22_BIOM2= Total Chrysophyceae (ug/l) at the surface ]
    no problems detected 364 0.00439999998 17.4594002 364
    ( 100%)
    92
    ( 25%)
    Column 22 :
    [23_BIOM2= Total Chlorophyceae (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")

  • 74 0.000199999995 0.863900006 74
    ( 100%)
    0
    ( 0%)
    Column 23 :
    [ 24_BIOM2= Total Nostocophyceae (ug/l) at the surface ]
    no problems detected 197 0.000199999995 14.8864002 197
    ( 100%)
    13
    ( 6%)
    Column 24 :
    [ 25_BIOM2= Total Prymnesiophyceae (ug/l) at the surface ]
    no problems detected 285 0.00480000023 72.1343994 285
    ( 100%)
    115
    ( 40%)
    Column 25 :
    [ 26_BIOM2= Total Prasinophyceae (ug/l) at the surface ]
    no problems detected 167 0.00789999962 5.93510008 167
    ( 100%)
    11
    ( 6%)
    Column 26 :
    [ 27_BIOM2= Total Euglenophyceae (ug/l) at the surface ]
    no problems detected 213 0.00139999995 7.00750017 213
    ( 100%)
    14
    ( 6%)
    Column 27 :
    [28_BIOM2= Total Nanoplankton (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. -9999999. 0
    ( -2147483648%)
    0
    ( -2147483648%)
    Column 28 :
    [ 29_BIOM2= Total Raphidophyceae (ug/l) at the surface ]
    no problems detected 88 0.0046000001 216.453995 88
    ( 100%)
    21
    ( 23%)
    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. -9999999. 0
    ( -2147483648%)
    0
    ( -2147483648%)
    Column 30 :
    [ 31_BIOM2= Total Unidentified (ug/l) at the surface ]
    no problems detected 404 0.0430999994 18.6604996 404
    ( 100%)
    303
    ( 75%)
    Column 32 :
    [ 32_TEMP= Temperature ( C ) ]
    no problems detected 493 -1.27909994 19.9405003 489
    ( 99%)
    482
    ( 97%)
    Column 33 :
    [ 33_PSAL= Salinity (PSS) ]
    no problems detected 491 15.2838001 32.0255013 491
    ( 100%)
    491
    ( 100%)
    Column 34 :
    [ 34_CHLA= Chlorophyll-a (ug/L) ]
    no problems detected 322 0.400000006 27.2332993 322
    ( 100%)
    281
    ( 87%)
    Column 35 :
    [ 35_OTHR= Oxygen (mg/L) ]
    no problems detected 490 5.61630011 14.8573999 490
    ( 100%)
    490
    ( 100%)
    Column 36 :
    [ 36_LOTH= NO3NO2 (uM) ]
    no problems detected 324 0.107100002 36.0713997 324
    ( 100%)
    156
    ( 48%)
    Column 37 :
    [ 37_LOTH= NH4 (uM) ]
    no problems detected 323 0.142900005 5.92859983 323
    ( 100%)
    102
    ( 31%)
    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. -9999999. 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. -9999999. 0
    ( -2147483648%)
    0
    ( -2147483648%)
    Column 40 :
    [ 40_LOTH= Phosphate (uM) ]
    no problems detected 324 0.0322999991 1.25810003 324
    ( 100%)
    2
    ( 0%)
    Column 41 :
    [ 41_LOTH= Silicate (uM) ]
    no problems detected 324 0.0714000016 40.1786003 324
    ( 100%)
    274
    ( 84%)
    Column 42 :
    [ 42_LOTH= Total Nitrogen (uM) ]
    no problems detected 324 5.82140017 61.25 324
    ( 100%)
    324
    ( 100%)
    Column 43 :
    [ 43_LOTH= Total Phosphorus (uM) ]
    no problems detected 324 0.280600011 4.80649996 324
    ( 100%)
    90
    ( 27%)
    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. -9999999. 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. -9999999. 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".