COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2    [BIOM1= Total Wet Mass (mg/m3)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [BIOM1= Pseudocalanus sp. (mg/m3)]      ( date set 2 )
    Column # 5    [BIOM1= Temora longicornis (mg/m3)]      ( date set 2 )
    Column # 6    [BIOM1= Acartia spp. (mg/m3)]      ( date set 2 )
    Column # 7    [BIOM1= Centropages hamatus (mg/m3)]      ( date set 2 )

    Column # 8     [ DATE-YMD ]       Date Set = 3
    Column # 9    [TEMP= Temperature ( C )]      ( date set 3 )
    Column # 10    [PSAL= Salinity ()]      ( date set 3 )
    Column # 11    [OTHR= Oxygen (ml/l)]      ( date set 3 )
    Column # 12    [OTHR= Oxygen Saturation (%)]      ( date set 3 )
    Column # 13    [LOTH= Phosphate (um)]      ( date set 3 )
    Column # 14    [LOTH= Silicate (um)]      ( date set 3 )
    Column # 15    [LOTH= Nitrite (um)]      ( date set 3 )
    Column # 16    [LOTH= NO3NO2 (um)]      ( date set 3 )
    Column # 17    [LOTH= Ammonium (um)]      ( date set 3 )
    Column # 18    [LOTH= Total Phosphate (um)]      ( date set 3 )
    Column # 19    [LOTH= Total Nitrogen (um)]      ( date set 3 )
    Column # 20    [OTHR= Secchi Depth (m)]      ( date set 3 )
    Column # 21    [OTHR= pH]      ( date set 3 )
    Column # 22    [CHLA= Chlorophyll-a (ug/l)]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 2   [ BIOM1= Total Wet Mass (mg/m3) ]
        Column # 4   [ BIOM1= Pseudocalanus sp. (mg/m3) ]
        Column # 5   [ BIOM1= Temora longicornis (mg/m3) ]
        Column # 6   [ BIOM1= Acartia spp. (mg/m3) ]
        Column # 7   [ BIOM1= Centropages hamatus (mg/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 13   [ LOTH= Phosphate (um) ]
        Column # 14   [ LOTH= Silicate (um) ]
        Column # 15   [ LOTH= Nitrite (um) ]
        Column # 16   [ LOTH= NO3NO2 (um) ]
        Column # 17   [ LOTH= Ammonium (um) ]
        Column # 18   [ LOTH= Total Phosphate (um) ]
        Column # 19   [ LOTH= Total Nitrogen (um) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Oxygen (ml/l) ]
        Column # 12   [ OTHR= Oxygen Saturation (%) ]
        Column # 20   [ OTHR= Secchi Depth (m) ]
        Column # 21   [ OTHR= pH ]

    Temperatures Category
        Column # 9   [ TEMP= Temperature ( C ) ]

    Salinities Category
        Column # 10   [ PSAL= Salinity () ]

    Chlorophyll/Pigments Category
        Column # 22   [ CHLA= Chlorophyll-a (ug/l) ]

DATA SORTED BY GROUPING SETS:

    Category 1 Group # 1
        column # 2     [ BIOM1= Total Wet Mass (mg/m3) ]
        column # 4     [ BIOM1= Pseudocalanus sp. (mg/m3) ]
        column # 5     [ BIOM1= Temora longicornis (mg/m3) ]
        column # 6     [ BIOM1= Acartia spp. (mg/m3) ]
        column # 7     [ BIOM1= Centropages hamatus (mg/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1960 2017
DATES in Column 3 no problems detected 1960 2017
DATES in Column 8 no problems detected 1965 2011

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1960 2017 05 10 15 15
3 DATE-YMD DATE-YMD yes 1960 2017 05 10 15 15
8 DATE-YMD DATE-YMD yes 1965 2011 1 11 1 31



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_BIOM1= Total Wet Mass (mg/m3) ]
no problems detected 160 24.25 931.299988 160
( 100%)
160
( 100%)
Column 4 :
[ 05_BIOM1= Pseudocalanus sp. (mg/m3) ]
no problems detected 160 5.30000019 131.699997 160
( 100%)
160
( 100%)
Column 5 :
[ 06_BIOM1= Temora longicornis (mg/m3) ]
no problems detected 160 0.600000024 253.199997 160
( 100%)
158
( 98%)
Column 6 :
[ 07_BIOM1= Acartia spp. (mg/m3) ]
no problems detected 160 0.800000012 142. 160
( 100%)
159
( 99%)
Column 7 :
[ 08_BIOM1= Centropages hamatus (mg/m3) ]
no problems detected 160 0.0700000003 86.0999985 151
( 94%)
127
( 79%)
Column 9 :
[ 09_TEMP= Temperature ( C ) ]
no problems detected 380 0.200000003 21.5312004 380
( 100%)
377
( 99%)
Column 10 :
[ 10_PSAL= Salinity () ]
no problems detected 383 6.42369986 7.96999979 383
( 100%)
383
( 100%)
Column 11 :
[ 11_OTHR= Oxygen (ml/l) ]
no problems detected 246 5.70800018 10.3299999 246
( 100%)
246
( 100%)
Column 12 :
[ 12_OTHR= Oxygen Saturation (%) ]
no problems detected 237 79.5999985 142. 237
( 100%)
237
( 100%)
Column 13 :
[ 13_LOTH= Phosphate (um) ]
no problems detected 145 0.0399999991 0.800000012 71
( 48%)
0
( 0%)
Column 14 :
[ 14_LOTH= Silicate (um) ]
no problems detected 108 1.70000005 20.7999992 108
( 100%)
108
( 100%)
Column 15 :
[ 15_LOTH= Nitrite (um) ]
no problems detected 106 0.0599999987 0.219999999 42
( 39%)
0
( 0%)
Column 16 :
[ 16_LOTH= NO3NO2 (um) ]
no problems detected 111 0.100000001 5.78999996 64
( 57%)
39
( 35%)
Column 17 :
[ 17_LOTH= Ammonium (um) ]
no problems detected 111 0.300000012 5.69999981 27
( 24%)
5
( 4%)
Column 18 :
[ 18_LOTH= Total Phosphate (um) ]
no problems detected 142 0.109999999 1.15999997 120
( 84%)
5
( 3%)
Column 19 :
[ 19_LOTH= Total Nitrogen (um) ]
no problems detected 104 9.39999962 31.1000004 104
( 100%)
104
( 100%)
Column 20 :
[ 20_OTHR= Secchi Depth (m) ]
no problems detected 31 4.5 13. 31
( 100%)
31
( 100%)
Column 21 :
[ 21_OTHR= pH ]
no problems detected 128 7.73000002 8.85999966 128
( 100%)
128
( 100%)
Column 22 :
[ 22_CHLA= Chlorophyll-a (ug/l) ]
no problems detected 58 0.200000003 4.67999983 58
( 100%)
50
( 86%)

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