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 Copepods (#/m2)]      ( date set 1 )
    Column # 3     [ABDT1= Total Mesozooplankton (#/m2)]      ( date set 1 )
    Column # 4     [BIOM1= Total Wet Weight (g/m2)]      ( date set 1 )
    Column # 5     [BIOM2= Total Dry Weight (g/m2)]      ( date set 1 )

    Column # 6     [ DATE-YMD ]       Date Set = 2
    Column # 7     [TEMP1= Temperature ( C ) from 0-10m]      ( date set 2 )
    Column # 8     [PSAL1= Salinity () from 0-10m]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10     [TEMP1= Temperature ( C ) from 75-100m]      ( date set 3 )
    Column # 11     [PSAL1= Salinity () from 75-100m]      ( date set 3 )

    Column # 12     [ DATE-YMD ]       Date Set = 4
    Column # 13     [PSAL1= Salinity () from 0-10m]      ( date set 4 )
    Column # 14     [OTHR= Oxygen (ml/l) from 0-10m]      ( date set 4 )
    Column # 15     [CHLA= Chlorophyll-a (mg/m3) from 0-10m]      ( date set 4 )
    Column # 16     [LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 17     [LOTH1= Phosphate (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 18     [LOTH1= Silicate (mmol/m3) from 0-10m]      ( date set 4 )
    Column # 19     [LOTH1= Ammonium (mmol/m3) from 0-10m]      ( date set 4 )

    Column # 20     [ DATE-YMD ]       Date Set = 5
    Column # 21     [PSAL1= Salinity () from 75-100m]      ( date set 5 )
    Column # 22     [OTHR= Oxygen (ml/l) from 75-100m]      ( date set 5 )
    Column # 23     [CHLA= Chlorophyll-a (mg/m3) from 75-100m]      ( date set 5 )
    Column # 24     [LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 25     [LOTH1= Phosphate (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 26     [LOTH1= Silicate (mmol/m3) from 75-100m]      ( date set 5 )
    Column # 27     [LOTH1= Ammonium (mmol/m3) from 75-100m]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (#/m2) ]
        Column # 3   [ ABDT1= Total Mesozooplankton (#/m2) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 14   [ OTHR= Oxygen (ml/l) from 0-10m ]
        Column # 22   [ OTHR= Oxygen (ml/l) from 75-100m ]

    Temperatures Category
        Column # 7   [ TEMP1= Temperature ( C ) from 0-10m ]
        Column # 10   [ TEMP1= Temperature ( C ) from 75-100m ]

    Salinities Category
        Column # 8   [ PSAL1= Salinity () from 0-10m ]
        Column # 11   [ PSAL1= Salinity () from 75-100m ]
        Column # 13   [ PSAL1= Salinity () from 0-10m ]
        Column # 21   [ PSAL1= Salinity () from 75-100m ]

DATA SORTED BY GROUPING SETS:

    Category 4 Group # 1
        column # 7     [ TEMP1= Temperature ( C ) from 0-10m ]
        column # 10     [ TEMP1= Temperature ( C ) from 75-100m ]

    Category 5 Group # 1
        column # 8     [ PSAL1= Salinity () from 0-10m ]
        column # 11     [ PSAL1= Salinity () from 75-100m ]
        column # 13     [ PSAL1= Salinity () from 0-10m ]
        column # 21     [ PSAL1= Salinity () from 75-100m ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (#/m2) ]
        column # 3     [ ABDT1= Total Mesozooplankton (#/m2) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1999 2017
DATES in Column 6 no problems detected 1997 2018
DATES in Column 9 no problems detected 1998 2018
DATES in Column 12 no problems detected 1968 2018
DATES in Column 20 no problems detected 1968 2017

 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 1999 2017 4 12 1 30
6 DATE-YMD DATE-YMD yes 1997 2018 3 12 1 31
9 DATE-YMD DATE-YMD yes 1998 2018 3 12 1 31
12 DATE-YMD DATE-YMD yes 1968 2018 3 12 1 30
20 DATE-YMD DATE-YMD yes 1968 2017 3 12 1 30



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepods (#/m2) ]
no problems detected 185 8099.88818 961199.938 185
( 100 %)
185
( 100 %)
Column 3 :
[ 05_ABDT1= Total Mesozooplankton (#/m2) ]
no problems detected 185 8207.29980 1561722.00 185
( 100 %)
185
( 100 %)
Column 4 :
[ 06_BIOM1= Total Wet Weight (g/m2) ]
no problems detected 185 7.51516595E-02 242.072159 185
( 100 %)
176
( 95 %)
Column 5 :
[ 07_BIOM2= Total Dry Weight (g/m2) ]
no problems detected 184 2.48996466E-02 50.9795380 184
( 100 %)
146
( 79 %)
Column 7 :
[ 08_TEMP1= Temperature ( C ) from 0-10m ]
no problems detected 16576 -1.70700002 20.8470001 16470
( 99 %)
16461
( 99 %)
Column 8 :
[ 09_PSAL1= Salinity () from 0-10m ]
no problems detected 15953 23.9860001 31.4029999 15953
( 100 %)
15953
( 100 %)
Column 10 :
[ 10_TEMP1= Temperature ( C ) from 75-100m ]
no problems detected 5957 -1.66799998 2.60700011 5745
( 96 %)
832
( 13 %)
Column 11 :
[ 11_PSAL1= Salinity () from 75-100m ]
no problems detected 5951 30.9570007 32.5260010 5951
( 100 %)
5951
( 100 %)
Column 13 :
[ 12_PSAL1= Salinity () from 0-10m ]
no problems detected 207 24.8099995 32.0079994 207
( 100 %)
207
( 100 %)
Column 14 :
[ 13_OTHR= Oxygen (ml/l) from 0-10m ]
no problems detected 93 5.50000000 8.43999958 93
( 100 %)
93
( 100 %)
Column 15 :
[ 14_CHLA= Chlorophyll-a (mg/m3) from 0-10m ]
no problems detected 582 6.70000017E-02 40.5530014 582
( 100 %)
380
( 65 %)
Column 16 :
[ 15_LOTH1= Nitrate + Nitrite (mmol/m3) from 0-10m ]
no problems detected 594 1.00000005E-03 13.3999996 531
( 89 %)
218
( 36 %)
Column 17 :
[ 16_LOTH1= Phosphate (mmol/m3) from 0-10m ]
no problems detected 594 9.99999978E-03 1.34000003 593
( 99 %)
16
( 2 %)
Column 18 :
[ 17_LOTH1= Silicate (mmol/m3) from 0-10m ]
no problems detected 594 4.50000018E-02 22.7649994 575
( 96 %)
391
( 65 %)
Column 19 :
[ 18_LOTH1= Ammonium (mmol/m3) from 0-10m ]
no problems detected 120 5.00000007E-02 5.09299994 120
( 100 %)
32
( 26 %)
Column 21 :
[ 19_PSAL1= Salinity () from 75-100m ]
no problems detected 173 27.8299999 32.6300011 173
( 100 %)
173
( 100 %)
Column 22 :
[ 20_OTHR= Oxygen (ml/l) from 75-100m ]
no problems detected 80 4.78999996 7.84000015 80
( 100 %)
80
( 100 %)
Column 23 :
[ 21_CHLA= Chlorophyll-a (mg/m3) from 75-100m ]
no problems detected 242 3.70000005E-02 8.48600006 242
( 100 %)
22
( 9 %)
Column 24 :
[ 22_LOTH1= Nitrate + Nitrite (mmol/m3) from 75-100m ]
no problems detected 245 3.99999991E-02 17.9669991 245
( 100 %)
243
( 99 %)
Column 25 :
[ 23_LOTH1= Phosphate (mmol/m3) from 75-100m ]
no problems detected 245 0.152999997 2.17400002 245
( 100 %)
232
( 94 %)
Column 26 :
[ 24_LOTH1= Silicate (mmol/m3) from 75-100m ]
no problems detected 245 0.252999991 32.0695000 245
( 100 %)
244
( 99 %)
Column 27 :
[ 25_LOTH1= Ammonium (mmol/m3) from 75-100m ]
no problems detected 69 9.00000036E-02 6.38700008 68
( 98 %)
44
( 63 %)

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