COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2    [ABND1= Total Zooplankton (#/m3)]      ( date set 1 )
    Column # 3    [BIOM= Total Dry Mass (mg/m3)]      ( date set 1 )
    Column # 4    [ABND1= Total Copepoda (#/m3)]      ( date set 1 )

    Column # 5     [ DATE-MDY ]       Date Set = 2
    Column # 6    [ABDT2= Total Diatoms (#/ml)]      ( date set 2 )
    Column # 7    [ABDT2= Total Dinoflagellates (#/ml)]      ( date set 2 )
    Column # 8    [ABDT3= Total Bacteria (#/ul)]      ( date set 2 )
    Column # 9    [ABDT4= Synechococcus (#/ul)]      ( date set 2 )
    Column # 10    [ABDT4= Prochlorococcus (#/ul)]      ( date set 2 )
    Column # 11    [ABDT4= Picophytoeukariots < 2 um (#/ul)]      ( date set 2 )
    Column # 12    [ABDT4= Picophytoeukariots > 2 um (#/ul)]      ( date set 2 )

    Column # 13     [ DATE-MDY ]       Date Set = 3
    Column # 14    [TEMP= Temperature (C) from 0-5m]      ( date set 3 )
    Column # 15    [PSAL= Salinity () from 0-5m]      ( date set 3 )
    Column # 16    [CHLA= Chlorophyll-a (mg/m3) from 0-5m]      ( date set 3 )
    Column # 17    [LOTH1= NO3+NO2 (uM) from 0-5m]      ( date set 3 )
    Column # 18    [LOTH1= NO3 (uM) from 0-5m]      ( date set 3 )
    Column # 19    [LOTH1= NO2 (uM) from 0-5m]      ( date set 3 )
    Column # 20    [LOTH1= Ammonium (uM) from 0-5m]      ( date set 3 )
    Column # 21    [LOTH1= PO4 (uM) from 0-5m]      ( date set 3 )
    Column # 22    [LOTH1= SiO4 (uM) from 0-5m]      ( date set 3 )
    Column # 23    [OTHR= Dissolved Oxygen (ml/l) from 0-5m]      ( date set 3 )
    Column # 24    [LOTH= Primary Production (mg-C/m3/hr) from 0-5m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 3   [ BIOM= Total Dry Mass (mg/m3) ]

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Zooplankton (#/m3) ]
        Column # 4   [ ABND1= Total Copepoda (#/m3) ]

    Abundance (with zeros) Category
        Column # 6   [ ABDT2= Total Diatoms (#/ml) ]
        Column # 7   [ ABDT2= Total Dinoflagellates (#/ml) ]
        Column # 8   [ ABDT3= Total Bacteria (#/ul) ]
        Column # 9   [ ABDT4= Synechococcus (#/ul) ]
        Column # 10   [ ABDT4= Prochlorococcus (#/ul) ]
        Column # 11   [ ABDT4= Picophytoeukariots < 2 um (#/ul) ]
        Column # 12   [ ABDT4= Picophytoeukariots > 2 um (#/ul) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 17   [ LOTH1= NO3+NO2 (uM) from 0-5m ]
        Column # 18   [ LOTH1= NO3 (uM) from 0-5m ]
        Column # 19   [ LOTH1= NO2 (uM) from 0-5m ]
        Column # 20   [ LOTH1= Ammonium (uM) from 0-5m ]
        Column # 21   [ LOTH1= PO4 (uM) from 0-5m ]
        Column # 22   [ LOTH1= SiO4 (uM) from 0-5m ]
        Column # 24   [ LOTH= Primary Production (mg-C/m3/hr) from 0-5m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 23   [ OTHR= Dissolved Oxygen (ml/l) from 0-5m ]

    Temperatures Category
        Column # 14   [ TEMP= Temperature (C) from 0-5m ]

    Salinities Category
        Column # 15   [ PSAL= Salinity () from 0-5m ]

    Chlorophyll/Pigments Category
        Column # 16   [ CHLA= Chlorophyll-a (mg/m3) from 0-5m ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Zooplankton (#/m3) ]
        column # 4     [ ABND1= Total Copepoda (#/m3) ]

    Category 8 Group # 2
        column # 6     [ ABDT2= Total Diatoms (#/ml) ]
        column # 7     [ ABDT2= Total Dinoflagellates (#/ml) ]

    Category 8 Group # 3
        column # 8     [ ABDT3= Total Bacteria (#/ul) ]

    Category 8 Group # 4
        column # 9     [ ABDT4= Synechococcus (#/ul) ]
        column # 10     [ ABDT4= Prochlorococcus (#/ul) ]
        column # 11     [ ABDT4= Picophytoeukariots < 2 um (#/ul) ]
        column # 12     [ ABDT4= Picophytoeukariots > 2 um (#/ul) ]

    Category 9 Group # 1
        column # 17     [ LOTH1= NO3+NO2 (uM) from 0-5m ]
        column # 18     [ LOTH1= NO3 (uM) from 0-5m ]
        column # 19     [ LOTH1= NO2 (uM) from 0-5m ]
        column # 20     [ LOTH1= Ammonium (uM) from 0-5m ]
        column # 21     [ LOTH1= PO4 (uM) from 0-5m ]
        column # 22     [ LOTH1= SiO4 (uM) from 0-5m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1988 2015
DATES in Column 5 no problems detected 1989 2015
DATES in Column 13 no problems detected 1989 2015

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 1 12 1 31 1988 2015
5 DATE-MDY DATE-MDY yes 1 12 1 31 1989 2015
13 DATE-MDY DATE-MDY yes 1 12 1 31 1989 2015



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND1= Total Zooplankton (#/m3) ]
no problems detected 317 126. 19704. 317
( 100%)
317
( 100%)
Column 3 :
[ 05_BIOM= Total Dry Mass (mg/m3) ]
no problems detected 318 0.550000012 111.209999 318
( 100%)
317
( 99%)
Column 4 :
[ 06_ABND1= Total Copepoda (#/m3) ]
no problems detected 246 56. 13419. 246
( 100%)
246
( 100%)
Column 6 :
[ 07_ABDT2= Total Diatoms (#/ml) ]
no problems detected 262 40. 10333500. 258
( 98%)
258
( 98%)
Column 7 :
[ 08_ABDT2= Total Dinoflagellates (#/ml) ]
no problems detected 262 1100. 1464310. 262
( 100%)
262
( 100%)
Column 8 :
[ 09_ABDT3= Total Bacteria (#/ul) ]
no problems detected 145 17166. 2012185. 131
( 90%)
131
( 90%)
Column 9 :
[ 10_ABDT4= Synechococcus (#/ul) ]
no problems detected 145 34. 145743. 139
( 95%)
139
( 95%)
Column 10 :
[ 11_ABDT4= Prochlorococcus (#/ul) ]
no problems detected 145 11. 81132. 81
( 55%)
81
( 55%)
Column 11 :
[ 12_ABDT4= Picophytoeukariots < 2 um (#/ul) ]
no problems detected 145 7. 99999. 131
( 90%)
131
( 90%)
Column 12 :
[ 13_ABDT4= Picophytoeukariots > 2 um (#/ul) ]
no problems detected 145 4. 11345. 108
( 74%)
108
( 74%)
Column 14 :
[ 14_TEMP= Temperature (C) from 0-5m ]
no problems detected 534 11.5874996 19.4197998 534
( 100%)
534
( 100%)
Column 15 :
[ 15_PSAL= Salinity () from 0-5m ]
no problems detected 520 26.7914009 35.9417992 520
( 100%)
520
( 100%)
Column 16 :
[ 16_CHLA= Chlorophyll-a (mg/m3) from 0-5m ]
no problems detected 576 0.0419999994 23.3910007 576
( 100%)
231
( 40%)
Column 17 :
[ 17_LOTH1= NO3+NO2 (uM) from 0-5m ]
no problems detected 551 0.0199999996 11.4499998 551
( 100%)
341
( 61%)
Column 18 :
[ 18_LOTH1= NO3 (uM) from 0-5m ]
no problems detected 551 0.00999999978 10.8199997 547
( 99%)
325
( 58%)
Column 19 :
[ 19_LOTH1= NO2 (uM) from 0-5m ]
no problems detected 549 0.00999999978 1.36000001 546
( 99%)
3
( 0%)
Column 20 :
[ 20_LOTH1= Ammonium (uM) from 0-5m ]
no problems detected 563 0.00999999978 0.899999976 481
( 85%)
0
( 0%)
Column 21 :
[ 21_LOTH1= PO4 (uM) from 0-5m ]
no problems detected 426 0.00999999978 1.99000001 423
( 99%)
71
( 16%)
Column 22 :
[ 22_LOTH1= SiO4 (uM) from 0-5m ]
no problems detected 500 0.0199999996 14.0100002 492
( 98%)
314
( 62%)
Column 23 :
[ 23_OTHR= Dissolved Oxygen (ml/l) from 0-5m ]
no problems detected 470 4.4000001 8.65999985 470
( 100%)
470
( 100%)
Column 24 :
[ 24_LOTH= Primary Production (mg-C/m3/hr) from 0-5m ]
no problems detected 543 0.0199999996 173.539993 543
( 100%)
456
( 83%)

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