330 likes | 350 Views
The Maharashtra State Data Centre on the Arabian Sea coast manages surface water data for rivers and Goa. Data entry & validation include field tests, nutrients, organic matter, alkalinity, hardness, coliforms, and biological data. Validation factors and protocols are crucial for ensuring accurate water quality data. Customized parameters, like turbidity, enhance validation processes. Proper validation criteria, checks, and balances are essential for maintaining data integrity.
E N D
SURFACE WATER STATE DATA CENTRE, MAHARASHTRA
Arabiansea WEST COAST RIVERS Goa
WATER QUALITY DATA ENTRY DATA VALIDATION S.K.KSHIRSAGAR
DATA RECORD • FIELD TESTS • B) GENERAL • C) NUTRIENTS • D) ORGANIC MATTER • E) ALKALINITY
Data Record DATA RECORD • F) HARDNESS • G) MAJOR IONS • H) OTHER INORGANIC • COLIFORMS • J) BIOLOGICAL
DATA VALIDATION • DATA VALIDATION – SWDES ONLY • 2) NO ACCESS TO HYMOS FOR W.Q.DATA • 3) VALIDATION IS ON THE BASIS OF PARAMETERS CO-RELATION BETWEEN pH , D.O. BOD,COD etc
DATA VALIDATION DATA VALIDATION FACTORS AFFECTING W.Q.VALIDATION 1)SAMPLING TECHNIQUES 2) FIELD DETERMINATION 3) PRESEVATION IN FIELD 4) PEROD OF SAMPLE RECEIPT TO LAB 5) TREATMENT IN LAB
DATA VALIDATION DATA VALIDATION FACTORS AFFECTING W.Q.VALIDATION FACTORS AFFECTING W.Q.VALIDATION 6) MISSING PARAMETER 7) PARAMETERS IN CUSTOMISED MENU ( LIKE TURBIDITY ) 8) SHORT INFORMATION ENTERED IN ID FORM & ANALYSIS RESULTS
DATA VALIDATION DATA VALIDATION FIRST VALIDATION MINIMUM & MAXIMUM VALUES SERVE AS A FIRST VALIDATION
DATA VALIDATION DATA VALIDATION SECOND VALIDATION UWL & LWL PROVIDED IN THE SOFTWARE TO WARN THE USER
DATA VALIDATION SECOND VALIDATION UWL & LWL UWL < or = MAX LWL > or = MIN PREVENT DATA ENTRY/ BUT DISPLAY WARNING SYMBOL
DATA VALIDATION THIRD VALIDATION LOD :- LIMIT OF DETECTION USED ONLY FOR VALIDATIONPURPOSE IN CASE OF TRACE METALS AND TRACE ORGANICS VALUE < LOD ( Alt-t)
DATA VALIDATION DATA REQUIRED • A) CATIONS – Ca , Mg , Na , K • B) ANIONS – Cl , SO4 , CO2 , HCO2 , NO2 , NO3 • C) TOTAL CATIONS – • D) TOTAL ANIONS –
DATA VALIDATION 1) ION BALANCE :- C – D / C + D 2) ION BALANCE :- Na / Cl 3) EC BALANCE :- TDS / EC 4) CARBON BALANCE :- COD / BOD 5) CO3 BALANCE :- IF pH < 8.3 PHEN ALKALINITY = 0?
DATA VALIDATION DATA VERIFICATION CRITERIA • ION BALANCE < 0.1 • 2) ION BALANCE = 0.8 – 1.2 • 3) EC BALANCE = 0.55 – 0.9 • 4) CARBON BALANCE – 1-10 • 5) CO3 BALANCE = YES ( OK )
DATA VALIDATION 1)Checked By – Here the responsible person or the head of Laboratory,should put his name or initials after checking the outcome of the validation 2) Remarks :- In this field the person who has checked the data may put some remarks i.e. to explain why a sample did not pass a validation check.
DATA VALIDATION SOME KEY POINTS • If sample did not pass the validation check then it is required to reanalyze the sample( If sufficient quantity of collected Sample is available) otherwise reject the sample and collect new sample.
DATA VALIDATION SOME KEY POINTS 2) In such cases it is necessary to see the following aspects i) Check manuscript copy of data ii) Validation should be done manually before entering the data & do not allow to enter the data in the computer before satisfactory manual validation
DATA VALIDATION SOME KEY POINTS iii) Check ERRORS in instruments, Calculations, Check chemist register, Life of stock solution, Type of distilled water, Calibration of instruments, Analytical procedure adopted
Adding Customized Parameters TURBIDITY
Water Quality Data Entry in SWDES Adding Customized Parameters is a part of Validation ( ie,Missing Parameter in Data Entry)
ENTER THE RESULTS OF TURBIDITY IN THE CUSTOMISED PARAMETER MENU