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 Diatoms (#/L) at the surface]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [ABDT1= Total Dinoflagellates (#/L) at the surface]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6    [TEMP= Temperature (C) at the surface]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8    [PSAL= Salinity () at the surface]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10    [OTHR= Oxygen (ml/l) at the surface]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12    [LOTH= NO3+NO2 (uM) at the surface]      ( date set 6 )

    Column # 13     [ DATE-YMD ]       Date Set = 7
    Column # 14    [LOTH= NH4 (uM) at the surface]      ( date set 7 )

    Column # 15     [ DATE-YMD ]       Date Set = 8
    Column # 16    [LOTH= PO4 (uM) at the surface]      ( date set 8 )

    Column # 17     [ DATE-YMD ]       Date Set = 9
    Column # 18    [LOTH= SiO4 (uM) at the surface]      ( date set 9 )

    Column # 19     [ DATE-YMD ]       Date Set = 10
    Column # 20    [CHLA= Chlorophyll (ug/L) at the surface]      ( date set 10 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) at the surface ]
        Column # 4   [ ABDT1= Total Dinoflagellates (#/L) at the surface ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 12   [ LOTH= NO3+NO2 (uM) at the surface ]
        Column # 14   [ LOTH= NH4 (uM) at the surface ]
        Column # 16   [ LOTH= PO4 (uM) at the surface ]
        Column # 18   [ LOTH= SiO4 (uM) at the surface ]

    non-Log10 (linear) Miscellaenous Category
        Column # 10   [ OTHR= Oxygen (ml/l) at the surface ]

    Temperatures Category
        Column # 6   [ TEMP= Temperature (C) at the surface ]

    Salinities Category
        Column # 8   [ PSAL= Salinity () at the surface ]

    Chlorophyll/Pigments Category
        Column # 20   [ CHLA= Chlorophyll (ug/L) at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) at the surface ]
        column # 4     [ ABDT1= Total Dinoflagellates (#/L) at the surface ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1987 2018
DATES in Column 3 no problems detected 1987 2018
DATES in Column 5 no problems detected 1988 2013
DATES in Column 7 no problems detected 1988 2017
DATES in Column 9 no problems detected 1988 2016
DATES in Column 11 no problems detected 2016 2018
DATES in Column 13 no problems detected 2016 2018
DATES in Column 15 no problems detected 2016 2018
DATES in Column 17 no problems detected 2017 2018
DATES in Column 19 no problems detected 1992 2018

 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 1987 2018 01 12 01 31
3 DATE-YMD DATE-YMD yes 1987 2018 01 12 01 31
5 DATE-YMD DATE-YMD yes 1988 2013 01 12 01 31
7 DATE-YMD DATE-YMD yes 1988 2017 01 12 01 31
9 DATE-YMD DATE-YMD yes 1988 2016 01 11 01 31
11 DATE-YMD DATE-YMD yes 2016 2018 01 12 02 27
13 DATE-YMD DATE-YMD yes 2016 2018 01 12 02 27
15 DATE-YMD DATE-YMD yes 2016 2018 01 12 02 27
17 DATE-YMD DATE-YMD yes 2017 2018 01 12 02 22
19 DATE-YMD DATE-YMD yes 1992 2018 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 Diatoms (#/L) at the surface ]
no problems detected 665 100. 4955200. 660
( 99%)
660
( 99%)
Column 4 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ]
no problems detected 661 100. 10825400. 646
( 97%)
646
( 97%)
Column 6 :
[ 06_TEMP= Temperature (C) at the surface ]
no problems detected 945 1. 99. 945
( 100%)
944
( 99%)
Column 8 :
[ 07_PSAL= Salinity () at the surface ]
no problems detected 943 20.2000008 99. 943
( 100%)
943
( 100%)
Column 10 :
[ 08_OTHR= Oxygen (ml/l) at the surface ]
no problems detected 76 4.03000021 10.3000002 76
( 100%)
76
( 100%)
Column 12 :
[ 09_LOTH= NO3+NO2 (uM) at the surface ]
no problems detected 31 0.100000001 1.88999999 31
( 100%)
2
( 6%)
Column 14 :
[ 10_LOTH= NH4 (uM) at the surface ]
no problems detected 31 0.0799999982 1.37 31
( 100%)
4
( 12%)
Column 16 :
[ 11_LOTH= PO4 (uM) at the surface ]
no problems detected 31 0.00999999978 0.133000001 31
( 100%)
0
( 0%)
Column 18 :
[ 12_LOTH= SiO4 (uM) at the surface ]
no problems detected 20 4.09000015 28.4500008 20
( 100%)
20
( 100%)
Column 20 :
[ 13_CHLA= Chlorophyll (ug/L) at the surface ]
no problems detected 585 0.00400000019 34.3479996 585
( 100%)
314
( 53%)

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