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 Phytoplankton (#/L)]      ( date set 1 )
    Column # 3    [ABDT1= Total Diatoms (#/L)]      ( date set 1 )
    Column # 4    [ABDT1= Total Dinoflagellates (#/L)]      ( date set 1 )
    Column # 5    [ABDT1= Other Phytoplankton (#/L)]      ( date set 1 )
    Column # 6    [OTHR2= Diatoms as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 7     [OTHR2= Dinoflagellates as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 8     [OTHR2= Other Phytoplankton as % of Total Phytoplankton (ratio)]      ( date set 1 )
    Column # 9    [OTHR3= Number of Phytoplankton Species]      ( date set 1 )
    Column # 10    [OTHR3= Number of Diatom Species]      ( date set 1 )
    Column # 11    [OTHR3= Number of Dinoflagellate Species]      ( date set 1 )
    Column # 12    [OTHR3= Number of Other Phytoplankton Species]      ( date set 1 )

    Column # 13     [ DATE-DMY ]       Date Set = 2
    Column # 14    [CHLA= Chlorophyll via Fluorescence proxy ()]      ( date set 2 )

    Column # 15     [ DATE-DMY ]       Date Set = 3
    Column # 16    [TEMP= Temperature ( C ) at the surface]      ( date set 3 )
    Column # 17    [PSAL= Salinity (pss) at the surface]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Phytoplankton (#/L) ]
        Column # 3   [ ABDT1= Total Diatoms (#/L) ]
        Column # 4   [ ABDT1= Total Dinoflagellates (#/L) ]
        Column # 5   [ ABDT1= Other Phytoplankton (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 6   [ OTHR2= Diatoms as % of Total Phytoplankton (ratio) ]
        Column # 7   [ OTHR2= Dinoflagellates as % of Total Phytoplankton (ratio) ]
        Column # 8   [ OTHR2= Other Phytoplankton as % of Total Phytoplankton (ratio) ]
        Column # 9   [ OTHR3= Number of Phytoplankton Species ]
        Column # 10   [ OTHR3= Number of Diatom Species ]
        Column # 11   [ OTHR3= Number of Dinoflagellate Species ]
        Column # 12   [ OTHR3= Number of Other Phytoplankton Species ]

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

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

    Chlorophyll/Pigments Category
        Column # 14   [ CHLA= Chlorophyll via Fluorescence proxy () ]

DATA SORTED BY GROUPING SETS:

    Category 6 Group # 2
        column # 6     [ OTHR2= Diatoms as % of Total Phytoplankton (ratio) ]
        column # 7     [ OTHR2= Dinoflagellates as % of Total Phytoplankton (ratio) ]
        column # 8     [ OTHR2= Other Phytoplankton as % of Total Phytoplankton (ratio) ]

    Category 6 Group # 3
        column # 9     [ OTHR3= Number of Phytoplankton Species ]
        column # 10     [ OTHR3= Number of Diatom Species ]
        column # 11     [ OTHR3= Number of Dinoflagellate Species ]
        column # 12     [ OTHR3= Number of Other Phytoplankton Species ]

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Phytoplankton (#/L) ]
        column # 3     [ ABDT1= Total Diatoms (#/L) ]
        column # 4     [ ABDT1= Total Dinoflagellates (#/L) ]
        column # 5     [ ABDT1= Other Phytoplankton (#/L) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1988 2009
DATES in Column 13 no problems detected 2004 2010
DATES in Column 15 no problems detected 1989 2009

 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 1 31 Apr Sep 00 99
13 DATE-DMY DATE-DMY yes 1 31 Apr Sep 04 10
15 DATE-DMY DATE-DMY yes 1 31 Apr Sep 00 99



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Phytoplankton (#/L) ]
no problems detected 646 20. 579220. 646
( 100%)
646
( 100%)
Column 3 :
[ 05_ABDT1= Total Diatoms (#/L) ]
no problems detected 646 20. 463730. 646
( 100%)
646
( 100%)
Column 4 :
[ 06_ABDT1= Total Dinoflagellates (#/L) ]
no problems detected 647 20. 62424. 593
( 91%)
593
( 91%)
Column 5 :
[ 07_ABDT1= Other Phytoplankton (#/L) ]
no problems detected 648 20. 573040. 644
( 99%)
644
( 99%)
Column 6 :
[ 08_OTHR2= Diatoms as % of Total Phytoplankton (ratio) ]
no problems detected 648 0.300403982 100. 648
( 100%)
646
( 99%)
Column 7 :
[ 09_OTHR2= Dinoflagellates as % of Total Phytoplankton (ratio) ]
no problems detected 648 0.0588754788 93.0864182 594
( 91%)
473
( 72%)
Column 8 :
[ 10_OTHR2= Other Phytoplankton as % of Total Phytoplankton (ratio) ]
no problems detected 648 0.154998705 98.9330444 644
( 99%)
625
( 96%)
Column 9 :
[ 11_OTHR3= Number of Phytoplankton Species ]
no problems detected 648 1. 51. 648
( 100%)
646
( 99%)
Column 10 :
[ 12_OTHR3= Number of Diatom Species ]
no problems detected 648 1. 31. 648
( 100%)
644
( 99%)
Column 11 :
[ 13_OTHR3= Number of Dinoflagellate Species ]
no problems detected 594 1. 15. 594
( 100%)
522
( 87%)
Column 12 :
[ 14_OTHR3= Number of Other Phytoplankton Species ]
no problems detected 644 1. 13. 644
( 100%)
621
( 96%)
Column 14 :
[ 15_CHLA= Chlorophyll via Fluorescence proxy () ]
no problems detected 209 -0.389999986 13.8400002 208
( 99%)
173
( 82%)
Column 16 :
[ 16_TEMP= Temperature ( C ) at the surface ]
no problems detected 620 -1.5 17.7999992 609
( 98%)
590
( 95%)
Column 17 :
[ 17_PSAL= Salinity (pss) at the surface ]
no problems detected 589 14.6400003 32.7099991 589
( 100%)
589
( 100%)

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