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 Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABND1= Acartia longiremis (#/m3)]      ( date set 1 )
    Column # 4    [ABND1= Pseudocalanus minutus (#/m3)]      ( date set 1 )
    Column # 5    [ABND1= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 6    [BIOM2= Acartia longiremis biomass (ug/m3)]      ( date set 1 )
    Column # 7    [BIOM2= Pseudocalanus minutus biomass (ug/m3)]      ( date set 1 )
    Column # 8    [BIOM2= Temora longicornis biomass (ug/m3)]      ( date set 1 )
    Column # 9     [OTHR3= Acartia longiremis relative abundance (% of three)]      ( date set 1 )
    Column # 10     [OTHR3= Pseudocalanus minutus relative abundance (% of three)]      ( date set 1 )
    Column # 11     [OTHR3= Temora longicornis relative abundance (% of three)]      ( date set 1 )

    Column # 12     [ DATE-MDY ]       Date Set = 2
    Column # 13    [ABND= Total Abundance (#/m3)]      ( date set 2 )
    Column # 14    [BIOM= Total Wet Mass (mg/m3)]      ( date set 2 )

    Column # 15     [ DATE-YMD ]       Date Set = 3
    Column # 16    [TEMP= Average Temperature ( C ) from 0-10 m]      ( date set 3 )
    Column # 17    [PSAL= Average Salinity () from 0-10 m]      ( date set 3 )
    Column # 18    [CHLA= Average Chlorophyll (ug/l) from 0-10 m]      ( date set 3 )
    Column # 19    [OTHR= Average Oxygen (ml/l) from 0-10 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 6   [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        Column # 7   [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        Column # 8   [ BIOM2= Temora longicornis biomass (ug/m3) ]
        Column # 14   [ BIOM= Total Wet Mass (mg/m3) ]

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Copepods (#/m3) ]
        Column # 3   [ ABND1= Acartia longiremis (#/m3) ]
        Column # 4   [ ABND1= Pseudocalanus minutus (#/m3) ]
        Column # 5   [ ABND1= Temora longicornis (#/m3) ]
        Column # 13   [ ABND= Total Abundance (#/m3) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 9   [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        Column # 10   [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        Column # 11   [ OTHR3= Temora longicornis relative abundance (% of three) ]
        Column # 19   [ OTHR= Average Oxygen (ml/l) from 0-10 m ]

    Temperatures Category
        Column # 16   [ TEMP= Average Temperature ( C ) from 0-10 m ]

    Salinities Category
        Column # 17   [ PSAL= Average Salinity () from 0-10 m ]

    Chlorophyll/Pigments Category
        Column # 18   [ CHLA= Average Chlorophyll (ug/l) from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 2
        column # 6     [ BIOM2= Acartia longiremis biomass (ug/m3) ]
        column # 7     [ BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
        column # 8     [ BIOM2= Temora longicornis biomass (ug/m3) ]

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]
        column # 3     [ ABND1= Acartia longiremis (#/m3) ]
        column # 4     [ ABND1= Pseudocalanus minutus (#/m3) ]
        column # 5     [ ABND1= Temora longicornis (#/m3) ]

    Category 6 Group # 3
        column # 9     [ OTHR3= Acartia longiremis relative abundance (% of three) ]
        column # 10     [ OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
        column # 11     [ OTHR3= Temora longicornis relative abundance (% of three) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1979 2010
DATES in Column 12 no problems detected 2002 2010
DATES in Column 15 no problems detected 1979 2010

 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 2 12 1 31 1979 2010
12 DATE-MDY DATE-MDY yes 3 11 1 31 2002 2010
15 DATE-YMD DATE-YMD yes 1979 2010 01 12 15 15



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND1= Total Copepods (#/m3) ]
no problems detected 124 56. 16425. 124
( 100%)
124
( 100%)
Column 3 :
[ 05_ABND1= Acartia longiremis (#/m3) ]
no problems detected 124 10. 4485. 124
( 100%)
124
( 100%)
Column 4 :
[ 06_ABND1= Pseudocalanus minutus (#/m3) ]
no problems detected 124 3. 12314. 124
( 100%)
124
( 100%)
Column 5 :
[ 07_ABND1= Temora longicornis (#/m3) ]
no problems detected 124 14. 6684. 124
( 100%)
124
( 100%)
Column 6 :
[ 08_BIOM2= Acartia longiremis biomass (ug/m3) ]
no problems detected 124 1. 71628. 123
( 99%)
122
( 98%)
Column 7 :
[ 09_BIOM2= Pseudocalanus minutus biomass (ug/m3) ]
no problems detected 124 16. 474371. 123
( 99%)
123
( 99%)
Column 8 :
[ 10_BIOM2= Temora longicornis biomass (ug/m3) ]
no problems detected 124 1. 258658. 123
( 99%)
122
( 98%)
Column 9 :
[ 11_OTHR3= Acartia longiremis relative abundance (% of three) ]
no problems detected 124 0.479999989 52.6100006 124
( 100%)
119
( 95%)
Column 10 :
[ 12_OTHR3= Pseudocalanus minutus relative abundance (% of three) ]
no problems detected 124 0.230000004 98.8000031 124
( 100%)
123
( 99%)
Column 11 :
[ 13_OTHR3= Temora longicornis relative abundance (% of three) ]
no problems detected 124 0.50999999 90.2799988 124
( 100%)
120
( 96%)
Column 13 :
[ 14_ABND= Total Abundance (#/m3) ]
no problems detected 38 549. 94424. 38
( 100%)
38
( 100%)
Column 14 :
[ 15_BIOM= Total Wet Mass (mg/m3) ]
no problems detected 37 3. 663. 37
( 100%)
37
( 100%)
Column 16 :
[ 16_TEMP= Average Temperature ( C ) from 0-10 m ]
no problems detected 6743 0.610000014 23.1700001 6743
( 100%)
6721
( 99%)
Column 17 :
[ 17_PSAL= Average Salinity () from 0-10 m ]
no problems detected 6636 6.1500001 14.6029997 6636
( 100%)
6636
( 100%)
Column 18 :
[ 18_CHLA= Average Chlorophyll (ug/l) from 0-10 m ]
no problems detected 1796 0.0599999987 23.7999992 1792
( 99%)
1197
( 66%)
Column 19 :
[ 19_OTHR= Average Oxygen (ml/l) from 0-10 m ]
no problems detected 6269 0.119999997 12.4899998 6269
( 100%)
6039
( 96%)

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