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 Phytoplankton (cells/l) at 1m]      ( date set 1 )
    Column # 3    [ABND1= Total Diatoms (cells/l) at 1m]      ( date set 1 )
    Column # 4    [ABND1= Total Dinoflagellates (cells/l) at 1m]      ( date set 1 )

    Column # 5     [ DATE-YMD ]       Date Set = 2
    Column # 6    [TEMP= Temperature ( C ) at 1m]      ( date set 2 )
    Column # 7    [PSAL= Salinity () at 1 m]      ( date set 2 )
    Column # 8    [CHLA= Chlorophyll-a (ug/l) at 1m]      ( date set 2 )
    Column # 9    [CHLA= Chlorophyll-a (ug/l) water-column averaged]      ( date set 2 )
    Column # 10    [CHLA= Chlorophyll-a (ug/l) photic layer averaged]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12    [OTHR= Dissolved Oxygen (ml/l) at 1m]      ( date set 3 )
    Column # 13    [LOTH= Total Nitrogen (uM) at 1m]      ( date set 3 )
    Column # 14    [LOTH= Total Phosphorus (uM) at 1m]      ( date set 3 )
    Column # 15    [LOTH= NH4 (uM) at 1m]      ( date set 3 )
    Column # 16    [LOTH= Nitrite (uM) at 1m]      ( date set 3 )
    Column # 17    [LOTH= Nitrate (uM) at 1m]      ( date set 3 )
    Column # 18    [LOTH= DIN (uM) at 1m]      ( date set 3 )
    Column # 19    [LOTH= Silicate (uM) at 1m]      ( date set 3 )
    Column # 20    [LOTH= Phosphate (uM) at 1m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Phytoplankton (cells/l) at 1m ]
        Column # 3   [ ABND1= Total Diatoms (cells/l) at 1m ]
        Column # 4   [ ABND1= Total Dinoflagellates (cells/l) at 1m ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 13   [ LOTH= Total Nitrogen (uM) at 1m ]
        Column # 14   [ LOTH= Total Phosphorus (uM) at 1m ]
        Column # 15   [ LOTH= NH4 (uM) at 1m ]
        Column # 16   [ LOTH= Nitrite (uM) at 1m ]
        Column # 17   [ LOTH= Nitrate (uM) at 1m ]
        Column # 18   [ LOTH= DIN (uM) at 1m ]
        Column # 19   [ LOTH= Silicate (uM) at 1m ]
        Column # 20   [ LOTH= Phosphate (uM) at 1m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 12   [ OTHR= Dissolved Oxygen (ml/l) at 1m ]

    Temperatures Category
        Column # 6   [ TEMP= Temperature ( C ) at 1m ]

    Salinities Category
        Column # 7   [ PSAL= Salinity () at 1 m ]

    Chlorophyll/Pigments Category
        Column # 8   [ CHLA= Chlorophyll-a (ug/l) at 1m ]
        Column # 9   [ CHLA= Chlorophyll-a (ug/l) water-column averaged ]
        Column # 10   [ CHLA= Chlorophyll-a (ug/l) photic layer averaged ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Phytoplankton (cells/l) at 1m ]
        column # 3     [ ABND1= Total Diatoms (cells/l) at 1m ]
        column # 4     [ ABND1= Total Dinoflagellates (cells/l) at 1m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2002 2015
DATES in Column 5 no problems detected 1986 2015
DATES in Column 11 no problems detected 2002 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 2002 2015 2 12 15 15
5 DATE-YMD DATE-YMD yes 1986 2015 1 12 15 15
11 DATE-YMD DATE-YMD yes 2002 2015 2 12 15 15



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND1= Total Phytoplankton (cells/l) at 1m ]
no problems detected 43 26770. 2030452. 43
( 100%)
43
( 100%)
Column 3 :
[ 05_ABND1= Total Diatoms (cells/l) at 1m ]
no problems detected 43 1. 655032. 41
( 95%)
40
( 93%)
Column 4 :
[ 06_ABND1= Total Dinoflagellates (cells/l) at 1m ]
no problems detected 43 708. 475246. 42
( 97%)
42
( 97%)
Column 6 :
[ 07_TEMP= Temperature ( C ) at 1m ]
no problems detected 232 10.8900003 25.0100002 232
( 100%)
232
( 100%)
Column 7 :
[ 08_PSAL= Salinity () at 1 m ]
no problems detected 232 31.75 35.8100014 232
( 100%)
232
( 100%)
Column 8 :
[ 09_CHLA= Chlorophyll-a (ug/l) at 1m ]
no problems detected 231 0.0399999991 3.29999995 228
( 98%)
31
( 13%)
Column 9 :
[ 10_CHLA= Chlorophyll-a (ug/l) water-column averaged ]
no problems detected 229 0.0931999981 2.00999999 229
( 100%)
7
( 3%)
Column 10 :
[ 11_CHLA= Chlorophyll-a (ug/l) photic layer averaged ]
no problems detected 231 0.109999999 2.7822001 231
( 100%)
26
( 11%)
Column 12 :
[ 12_OTHR= Dissolved Oxygen (ml/l) at 1m ]
no problems detected 56 4.76000023 6.86999989 56
( 100%)
56
( 100%)
Column 13 :
[ 13_LOTH= Total Nitrogen (uM) at 1m ]
no problems detected 42 4.19999981 50. 42
( 100%)
42
( 100%)
Column 14 :
[ 14_LOTH= Total Phosphorus (uM) at 1m ]
no problems detected 42 0.200000003 1.29999995 42
( 100%)
5
( 11%)
Column 15 :
[ 15_LOTH= NH4 (uM) at 1m ]
no problems detected 56 0.100000001 12.5 56
( 100%)
39
( 69%)
Column 16 :
[ 16_LOTH= Nitrite (uM) at 1m ]
no problems detected 56 0.0199999996 1.29999995 56
( 100%)
1
( 1%)
Column 17 :
[ 17_LOTH= Nitrate (uM) at 1m ]
no problems detected 56 0.140000001 16.1000004 56
( 100%)
37
( 66%)
Column 18 :
[ 18_LOTH= DIN (uM) at 1m ]
no problems detected 56 0.460000008 29.2999992 56
( 100%)
55
( 98%)
Column 19 :
[ 19_LOTH= Silicate (uM) at 1m ]
no problems detected 56 0.5 16.7000008 56
( 100%)
34
( 60%)
Column 20 :
[ 20_LOTH= Phosphate (uM) at 1m ]
no problems detected 56 0.0299999993 0.600000024 56
( 100%)
0
( 0%)

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