1 2 Are error messages generated for illegal inputs? 3 Is the on-screen layout of the data input form similar to the layout of the paper form containing the data? 4 Does the system allow the user to design customized data input forms? Daily-Hourly - 30 Minute -15 Minute. 5 Can the user commit data to the database from the data input form? 6 Are checks made to test the validity of data types for numeric, text, and tick mark entry fields? 7 Do the validity checks test for impossible combinations of data values? (ex: maximum temperature < minimum temperature) (QC). 8 Do the validity checks test for Seasonal data? 9 Does the system allow key entry personnel to ignore validity checking and continue entering data? 10 Are quality control procedures applied during key entry as the form data are entered by the data entry personnel? 11 Are quality control procedures applied during the process of committing data to the database? 12 Is the on-line documentation available to the operator during the key entry process? 13 QC is performed as data are being entered into the form ? 14 QC flags have many levels to show source of data and level of QC? Requirements of the system:Climate Database Do Entry forms prevent illegal user input in entry fields? . DATA ENTRY & VALIDATION & QUALITY CONTROL National Center of Meteorology & Seismology Department of Meteorology, Climate Division Subject: CLDB REQUIREMENTS.15 Import of Digital Data ( Clicom format - Hourly Data from Spreadsheet - 15 min Data ). 16 Indicate the standard GTS message format this system can ingest into the database. a) TEMP b) PILOT c) METAR d) CLIMAT e) BUOYS f) BUFR g) SYNOP 17 Does this system offer replacement estimates for observations that "fail" QC? 18 Can a user override the value suggested by the QC process? 19 Does this system record the date of the QC change? 20 Does this system provide QC flags 21 that indicate the reason for replacing an observation? 22 Is the consistency of a set of observations validated by comparing an element to other elements in the same observation record? 23 Is temporal coherence validated by comparing elements to other elements (of similar type) in the time series? 24 Is spatial coherence validated by comparing an observation to similar observations from adjacent stations? 25 Are the QC routines compliant with WMO guidelines? 1 Air Temperature,Relative Humidity ,Vapour Pressure,Wet Bulb temperature,Dew point. 2 QNH,QFF,QFE. 3 Wind speed converter (m/s -Knot-Km/h). 4 Solar Radiation converter (Wh/m2 - mwh/cm2 ) 5 Does this system can interpolate missing data from the nearest station according to each elements & coordinates of stations in meta data. 1 Does this system have the ability to import data files containing multiple stations? 2 Does this system have the ability to import multiple data files containing single stations? 3 Does this system have the ability to import data from Automated Weather Stations (AWS)? 4 Does this system have the ability to import data from other digital sources? (Specify) 5 Does this system allow the user to define the input format of data files that a user wants to import to the database? 6 Daily ozone data (O3 - SO2 -DUV ). 7 Can this system import data from External files (CLICOM - Speadsheet).? a) 15-minute observations b) Hourly observations Meteorological Calculations IMPORT DATAc) 3-Hourly observations d) Daily observations e) Monthly observations f) Marine observation (buoys- Excel sheet data). g) Upper air observations 1 Are station metadata elements required to extract climate data? a) Station name b) station number/identifier c) period (dates) d) latitude/longitude e) elevation f) country g) climate element (temperature, etc) 2 Does the system support graphical data types such as pictures of the climate station or scanned information such as instrument manuals? 3 Does the system allow for the maintenance of historical metadata information that provides a history of changes to station behavior? 4 Does the system store information describing individual elements? 5 1 Tabular summary of statistical analysis 2 Daily summary 3 Monthly summary 4 Annual summary. 5 Long Term summary. 6 10-day summary 7 Typical types of statistical analyses a) Means, totals, and standard deviations b) Frequency analyses c) Normals d) Percile , Tercile e) Count of missing values f) Extreme values 8 Graphical products a) Time series plots of single data variables Does this metadata include information describing the instrument used to perform the observation? (Height, type). REPORTS META DATAb) Time series plots of multiple variables c) Upper air sounding d) Wind roses from Monthly - Annual - long term for sepecify date (Hour-Month-Year). e) Contour analyses ( Application related surfer & ArcGis softwares ) f) Gragh ( Related to Surfer - Grapher - ArcGis softwares). 1 Exporting Main hours (24 Hours) from Raw data (15 min). 2 Exporting data with converting time from GMT To local time. 3 Exporting data by using Statistical functions (Mean - Average -Max -Min- Sum -Count - Standard deviation - Correlation -Regression Analysis). 4 Count of Weather Phenomena (Daily-Monthly-Annual-Long Term) according to present weather code ( FG-TS- SS/DS-RS - Days With Rain ) 5 Template with logo of NCMS for requested data (After retrieving data from CLDB). 1 Indicate the type of output formats supported for output data and/or products a)ASCII text b) PDF c) HTML d) XML e) Comma separated values (CSV) f ) Export to CLICOM (DataEase) g) Other (specify) 2 WMO message formats a) CLIMAT b) CREX c) CLIMAT TEMP d) Gridded data output (specify) e) GRIB f) GIS formats QUERY OF DATA DATA FORMATg) ArcInfo h) Spreadsheet formats k) MicroSoft Excel 1 Are built-in facilities provided for routine backup and restore of the database? 2 Does the system provide facilities to recover the database and database information in the event of a system crash? 3 Does the system provide transaction processing that allows the user to roll-back transactions. 4 Do facilities exist to provide different database access privileges at the user level? Tadministrative privileges? 5 Does the system provide facilities to have two historical tables, one keep data as received from datalogger and other one for corrected data. 6 Does the system provide the capability of remote (off-site) administration?. 7 Decoding and encoding of data into various WMO formats (e.g. CLIMAT). 8 Possibility to add more elements and stations. BACKUP & ADMINISTRATION