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/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) ]

    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 ]

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) ]



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.000000 19704.0000 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.0000000 13419.0000 246
( 100 %)
246
( 100 %)
Column 6 :
[ 07_ABDT2= Total Diatoms (#/ml) ]
no problems detected 262 40.0000000 10333500.0 258
( 98 %)
258
( 98 %)
Column 7 :
[ 08_ABDT2= Total Dinoflagellates (#/ml) ]
no problems detected 262 1100.00000 1464310.00 262
( 100 %)
262
( 100 %)
Column 8 :
[ 09_ABDT3= Total Bacteria (#/ul) ]
no problems detected 145 17166.0000 2012185.00 131
( 90 %)
131
( 90 %)
Column 9 :
[ 10_ABDT4= Synechococcus (#/ul) ]
no problems detected 145 34.0000000 145743.000 139
( 95 %)
139
( 95 %)
Column 10 :
[ 11_ABDT4= Prochlorococcus (#/ul) ]
no problems detected 145 11.0000000 81132.0000 81
( 55 %)
81
( 55 %)
Column 11 :
[ 12_ABDT4= Picophytoeukariots < 2 um (#/ul) ]
no problems detected 145 7.00000000 99999.0000 131
( 90 %)
131
( 90 %)
Column 12 :
[ 13_ABDT4= Picophytoeukariots > 2 um (#/ul) ]
no problems detected 145 4.00000000 11345.0000 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 4.19999994E-02 23.3910007 576
( 100 %)
231
( 40 %)
Column 17 :
[ 17_LOTH1= NO3+NO2 (uM) from 0-5m ]
no problems detected 551 1.99999996E-02 11.4499998 551
( 100 %)
341
( 61 %)
Column 18 :
[ 18_LOTH1= NO3 (uM) from 0-5m ]
no problems detected 551 9.99999978E-03 10.8199997 547
( 99 %)
325
( 58 %)
Column 19 :
[ 19_LOTH1= NO2 (uM) from 0-5m ]
no problems detected 549 9.99999978E-03 1.36000001 546
( 99 %)
3
( 0 %)
Column 20 :
[ 20_LOTH1= Ammonium (uM) from 0-5m ]
no problems detected 563 9.99999978E-03 0.899999976 481
( 85 %)
0
( 0 %)
Column 21 :
[ 21_LOTH1= PO4 (uM) from 0-5m ]
no problems detected 426 9.99999978E-03 1.99000001 423
( 99 %)
71
( 16 %)
Column 22 :
[ 22_LOTH1= SiO4 (uM) from 0-5m ]
no problems detected 500 1.99999996E-02 14.0100002 492
( 98 %)
314
( 62 %)
Column 23 :
[ 23_OTHR= Dissolved Oxygen (ml/l) from 0-5m ]
no problems detected 470 4.40000010 8.65999985 470
( 100 %)
470
( 100 %)
Column 24 :
[ 24_LOTH= Primary Production (mg-C/m3/hr) from 0-5m ]
no problems detected 543 1.99999996E-02 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".