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     [CHLA= Average Chlorophyll (ug/l) from 0-10m]      ( date set 1 )
    Column # 3     [CHLA= Average Chlorophyll (ug/l) from 10-30m]      ( date set 1 )

    Column # 4     [ DATE-YMD ]       Date Set = 2
    Column # 5     [LOTH= Average TSS (mg/l) from 0-10m]      ( date set 2 )
    Column # 6     [LOTH= Average TSS (mg/l) from 10-50m]      ( date set 2 )
    Column # 7     [LOTH= Average PIM (mg/l) from 0-10m]      ( date set 2 )
    Column # 8     [LOTH= Average PIM (mg/l) from 10-50m]      ( date set 2 )
    Column # 9     [LOTH= Average POM (mg/l) from 0-10m]      ( date set 2 )
    Column # 10     [LOTH= Average POM (mg/l) from 10-50m]      ( date set 2 )
    Column # 11     [OTHR= Average POM (%) from 0-10m]      ( date set 2 )
    Column # 12     [OTHR= Average POM (%) from 10-50m]      ( date set 2 )

    Column # 13     [ DATE-YMD ]       Date Set = 3
    Column # 14     [TEMP= Average Temperature (C) from 0-10m]      ( date set 3 )
    Column # 15     [TEMP= Average Temperature (C) from 10-50m]      ( date set 3 )
    Column # 16     [PSAL= Average Salinity () from 0-10m]      ( date set 3 )
    Column # 17     [PSAL= Average Salinity () from 10-50m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Average POM (%) from 0-10m ]
        Column # 12   [ OTHR= Average POM (%) from 10-50m ]

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

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



DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1991 2010
DATES in Column 4 no problems detected 1992 2010
DATES in Column 13 no problems detected 1991 2012

 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 1991 2010 01 12 01 31
4 DATE-YMD DATE-YMD yes 1992 2010 01 12 01 31
13 DATE-YMD DATE-YMD yes 1991 2012 01 12 01 31


DATA REVIEW SECTION
[ Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)		 Maximum Values
> 0 		Values
> 1
Column 2 :
[ 04_CHLA= Average Chlorophyll (ug/l) from 0-10m ] 		no problems detected 1033 9.99999978E-03 14.5500002 926
( 89 %)		 173
( 16 %)
Column 3 :
[ 05_CHLA= Average Chlorophyll (ug/l) from 10-30m ] 		no problems detected 629 1.99999996E-02 7.61000013 579
( 92 %)		 93
( 14 %)
Column 5 :
[ 06_LOTH= Average TSS (mg/l) from 0-10m ] 		no problems detected 884 -0.500000000 133.714005 881
( 99 %)		 757
( 85 %)
Column 6 :
[ 07_LOTH= Average TSS (mg/l) from 10-50m ] 		no problems detected 525 0.100000001 48.0000000 523
( 99 %)		 422
( 80 %)
Column 7 :
[ 08_LOTH= Average PIM (mg/l) from 0-10m ] 		no problems detected 884 -1.00000000 88.5000000 875
( 98 %)		 658
( 74 %)
Column 8 :
[ 09_LOTH= Average PIM (mg/l) from 10-50m ] 		no problems detected 525 0.100000001 36.0000000 514
( 97 %)		 346
( 65 %)
Column 9 :
[ 10_LOTH= Average POM (mg/l) from 0-10m ] 		no problems detected 884 -0.250000000 35.5999985 846
( 95 %)		 530
( 59 %)
Column 10 :
[ 11_LOTH= Average POM (mg/l) from 10-50m ] 		no problems detected 525 -0.800000012 40.0000000 502
( 95 %)		 276
( 52 %)
Column 11 :
[ 12_OTHR= Average POM (%) from 0-10m ] 		no problems detected 884 -6.11999989 144.589996 858
( 97 %)		 858
( 97 %)
Column 12 :
[ 13_OTHR= Average POM (%) from 10-50m ] 		no problems detected 525 1.69000006 200.000000 509
( 96 %)		 509
( 96 %)
Column 14 :
[ 14_TEMP= Average Temperature (C) from 0-10m ] 		no problems detected 24314 -2.00000000 6.51000023 10503
( 43 %)		 6011
( 24 %)
Column 15 :
[ 15_TEMP= Average Temperature (C) from 10-50m ] 		no problems detected 27639 -2.00000000 1.86199999 13855
( 50 %)		 6373
( 23 %)
Column 16 :
[ 16_PSAL= Average Salinity () from 0-10m ] 		no problems detected 23762 1.09000003 40.9099998 23762
( 100 %)		 23762
( 100 %)
Column 17 :
[ 17_PSAL= Average Salinity () from 10-50m ] 		no problems detected 27632 29.9500008 35.2799988 27632
( 100 %)		 27632
( 100 %)

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