COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2     [ABDT1= Total Diatoms (#/L) at the surface]      ( date set 1 )
    Column # 3     [ABDT1= Total Dinoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 4     [ABDT1= Total Coccolithophores (#/L) at the surface]      ( date set 1 )
    Column # 5     [ABDT1= Total Silicoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 6     [ABDT1= Other nanoflagellates (#/L) at the surface]      ( date set 1 )
    Column # 7     [ABDT1= Total Phytoplankton (#/L) at the surface]      ( date set 1 )

    Column # 8     [ DATE-DMY ]       Date Set = 2
    Column # 9     [TEMP= Temperature ( C ) at the surface]      ( date set 2 )
    Column # 10     [PSAL= Salinity () at the surface]      ( date set 2 )
    Column # 11     [OTHR= Density (kg/m3) at the surface]      ( date set 2 )
    Column # 12     [OTHR= Oxygen (ml/l) at the surface]      ( date set 2 )
    Column # 13     [LOTH= NO3 (uM) at the surface]      ( date set 2 )
    Column # 14     [LOTH= NO2 (uM) at the surface]      ( date set 2 )
    Column # 15     [LOTH= NH4 (uM) at the surface]      ( date set 2 )
    Column # 16     [LOTH= PO4 (uM) at the surface]      ( date set 2 )
    Column # 17     [LOTH= SiO4 (uM) at the surface]      ( date set 2 )
    Column # 18     [CHLA= Chlorophyll (ug/l) at the surface]      ( date set 2 )

    Column # 19     [ DATE-DMY ]       Date Set = 3
    Column # 20     [ABDT1= Total Diatoms (#/L) at 20 m]      ( date set 3 )
    Column # 21     [ABDT1= Total Dinoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 22     [ABDT1= Total Coccolithophores (#/L) at 20 m]      ( date set 3 )
    Column # 23     [ABDT1= Total Silicoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 24     [ABDT1= Other nanoflagellates (#/L) at 20 m]      ( date set 3 )
    Column # 25     [ABDT1= Total Phytoplankton (#/L) at 20 m]      ( date set 3 )

    Column # 26     [ DATE-DMY ]       Date Set = 4
    Column # 27     [TEMP= Temperature ( C ) at 20 m]      ( date set 4 )
    Column # 28     [PSAL= Salinity () at 20 m]      ( date set 4 )
    Column # 29     [OTHR= Density (kg/m3) at 20 m]      ( date set 4 )
    Column # 30     [OTHR= Oxygen (ml/l) at 20 m]      ( date set 4 )
    Column # 31     [LOTH= NO3 (uM) at 20 m]      ( date set 4 )
    Column # 32     [LOTH= NO2 (uM) at 20 m]      ( date set 4 )
    Column # 33     [LOTH= NH4 (uM) at 20 m]      ( date set 4 )
    Column # 34     [LOTH= PO4 (uM) at 20 m]      ( date set 4 )
    Column # 35     [LOTH= SiO4 (uM) at 20 m]      ( date set 4 )
    Column # 36     [CHLA= Chlorophyll (ug/l) at 20 m]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) at the surface ]
        Column # 3   [ ABDT1= Total Dinoflagellates (#/L) at the surface ]
        Column # 4   [ ABDT1= Total Coccolithophores (#/L) at the surface ]
        Column # 5   [ ABDT1= Total Silicoflagellates (#/L) at the surface ]
        Column # 6   [ ABDT1= Other nanoflagellates (#/L) at the surface ]
        Column # 7   [ ABDT1= Total Phytoplankton (#/L) at the surface ]
        Column # 20   [ ABDT1= Total Diatoms (#/L) at 20 m ]
        Column # 21   [ ABDT1= Total Dinoflagellates (#/L) at 20 m ]
        Column # 22   [ ABDT1= Total Coccolithophores (#/L) at 20 m ]
        Column # 23   [ ABDT1= Total Silicoflagellates (#/L) at 20 m ]
        Column # 24   [ ABDT1= Other nanoflagellates (#/L) at 20 m ]
        Column # 25   [ ABDT1= Total Phytoplankton (#/L) at 20 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Density (kg/m3) at the surface ]
        Column # 12   [ OTHR= Oxygen (ml/l) at the surface ]
        Column # 29   [ OTHR= Density (kg/m3) at 20 m ]
        Column # 30   [ OTHR= Oxygen (ml/l) at 20 m ]

    Temperatures Category
        Column # 9   [ TEMP= Temperature ( C ) at the surface ]
        Column # 27   [ TEMP= Temperature ( C ) at 20 m ]

    Salinities Category
        Column # 10   [ PSAL= Salinity () at the surface ]
        Column # 28   [ PSAL= Salinity () at 20 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) at the surface ]
        column # 3     [ ABDT1= Total Dinoflagellates (#/L) at the surface ]
        column # 4     [ ABDT1= Total Coccolithophores (#/L) at the surface ]
        column # 5     [ ABDT1= Total Silicoflagellates (#/L) at the surface ]
        column # 6     [ ABDT1= Other nanoflagellates (#/L) at the surface ]
        column # 7     [ ABDT1= Total Phytoplankton (#/L) at the surface ]
        column # 20     [ ABDT1= Total Diatoms (#/L) at 20 m ]
        column # 21     [ ABDT1= Total Dinoflagellates (#/L) at 20 m ]
        column # 22     [ ABDT1= Total Coccolithophores (#/L) at 20 m ]
        column # 23     [ ABDT1= Total Silicoflagellates (#/L) at 20 m ]
        column # 24     [ ABDT1= Other nanoflagellates (#/L) at 20 m ]
        column # 25     [ ABDT1= Total Phytoplankton (#/L) at 20 m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1990 2014
DATES in Column 8 no problems detected 1990 2014
DATES in Column 19 no problems detected 1990 2014
DATES in Column 26 no problems detected 1990 2014

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014
8 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014
19 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014
26 DATE-DMY DATE-DMY yes 3 31 Apr Sep 1990 2014



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 290 270.000000 4536000.00 288
( 99 %)
288
( 99 %)
Column 3 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ]
no problems detected 290 540.000000 297920.000 289
( 99 %)
289
( 99 %)
Column 4 :
[ 06_ABDT1= Total Coccolithophores (#/L) at the surface ]
no problems detected 290 370.000000 712800.000 286
( 98 %)
286
( 98 %)
Column 5 :
[ 07_ABDT1= Total Silicoflagellates (#/L) at the surface ]
no problems detected 290 270.000000 6480.00000 63
( 21 %)
63
( 21 %)
Column 6 :
[ 08_ABDT1= Other nanoflagellates (#/L) at the surface ]
no problems detected 290 26728.0000 4393400.00 290
( 100 %)
290
( 100 %)
Column 7 :
[ 09_ABDT1= Total Phytoplankton (#/L) at the surface ]
no problems detected 290 66306.0000 5134000.00 290
( 100 %)
290
( 100 %)
Column 9 :
[ 10_TEMP= Temperature ( C ) at the surface ]
no problems detected 306 6.23000002 28.0900002 306
( 100 %)
306
( 100 %)
Column 10 :
[ 11_PSAL= Salinity () at the surface ]
no problems detected 306 28.1200008 38.6599998 306
( 100 %)
306
( 100 %)
Column 11 :
[ 12_OTHR= Density (kg/m3) at the surface ]
no problems detected 306 19.0400009 30.0200005 306
( 100 %)
306
( 100 %)
Column 12 :
[ 13_OTHR= Oxygen (ml/l) at the surface ]
no problems detected 296 3.75000000 7.88999987 296
( 100 %)
296
( 100 %)
Column 13 :
[ 14_LOTH= NO3 (uM) at the surface ]
no problems detected 294 9.99999978E-03 23.2299995 294
( 100 %)
194
( 65 %)
Column 14 :
[ 15_LOTH= NO2 (uM) at the surface ]
no problems detected 294 9.99999978E-03 1.88999999 294
( 100 %)
17
( 5 %)
Column 15 :
[ 16_LOTH= NH4 (uM) at the surface ]
no problems detected 294 9.99999978E-03 7.32999992 294
( 100 %)
114
( 38 %)
Column 16 :
[ 17_LOTH= PO4 (uM) at the surface ]
no problems detected 294 9.99999978E-03 0.639999986 294
( 100 %)
0
( 0 %)
Column 17 :
[ 18_LOTH= SiO4 (uM) at the surface ]
no problems detected 294 9.99999978E-03 34.8600006 294
( 100 %)
267
( 90 %)
Column 18 :
[ 19_CHLA= Chlorophyll (ug/l) at the surface ]
no problems detected 298 5.99999987E-02 12.0600004 298
( 100 %)
108
( 36 %)
Column 20 :
[ 20_ABDT1= Total Diatoms (#/L) at 20 m ]
no problems detected 248 270.000000 3000240.00 248
( 100 %)
248
( 100 %)
Column 21 :
[ 21_ABDT1= Total Dinoflagellates (#/L) at 20 m ]
no problems detected 248 495.000000 83750.0000 240
( 96 %)
240
( 96 %)
Column 22 :
[ 22_ABDT1= Total Coccolithophores (#/L) at 20 m ]
no problems detected 248 540.000000 627480.000 240
( 96 %)
240
( 96 %)
Column 23 :
[ 23_ABDT1= Total Silicoflagellates (#/L) at 20 m ]
no problems detected 248 270.000000 18125.0000 71
( 28 %)
71
( 28 %)
Column 24 :
[ 24_ABDT1= Other nanoflagellates (#/L) at 20 m ]
no problems detected 248 11122.0000 930000.000 248
( 100 %)
248
( 100 %)
Column 25 :
[ 25_ABDT1= Total Phytoplankton (#/L) at 20 m ]
no problems detected 248 38678.0000 3134160.00 248
( 100 %)
248
( 100 %)
Column 27 :
[ 26_TEMP= Temperature ( C ) at 20 m ]
no problems detected 304 5.26000023 23.3600006 304
( 100 %)
304
( 100 %)
Column 28 :
[ 27_PSAL= Salinity () at 20 m ]
no problems detected 304 35.6399994 38.6800003 304
( 100 %)
304
( 100 %)
Column 29 :
[ 28_OTHR= Density (kg/m3) at 20 m ]
no problems detected 304 25.3500004 30.4699993 304
( 100 %)
304
( 100 %)
Column 30 :
[ 29_OTHR= Oxygen (ml/l) at 20 m ]
no problems detected 296 3.28999996 7.48000002 296
( 100 %)
296
( 100 %)
Column 31 :
[ 30_LOTH= NO3 (uM) at 20 m ]
no problems detected 291 9.99999978E-03 17.5900002 291
( 100 %)
183
( 62 %)
Column 32 :
[ 31_LOTH= NO2 (uM) at 20 m ]
no problems detected 292 9.99999978E-03 1.88000000 292
( 100 %)
26
( 8 %)
Column 33 :
[ 32_LOTH= NH4 (uM) at 20 m ]
no problems detected 292 9.99999978E-03 5.51000023 292
( 100 %)
184
( 63 %)
Column 34 :
[ 33_LOTH= PO4 (uM) at 20 m ]
no problems detected 291 9.99999978E-03 1.07000005 291
( 100 %)
1
( 0 %)
Column 35 :
[ 34_LOTH= SiO4 (uM) at 20 m ]
no problems detected 291 9.99999978E-03 41.3300018 291
( 100 %)
280
( 96 %)
Column 36 :
[ 35_CHLA= Chlorophyll (ug/l) at 20 m ]
no problems detected 295 0.170000002 7.44000006 295
( 100 %)
135
( 45 %)

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