Project Status Year 1 Milestones and Deliverables Year

Project Status: Year 1

Milestones and Deliverables Year 1 contained: • 25 milestones (from 78) • 9 deliverables (from 38) Of these: • 22 milestones and 7 deliverables completed successfully (3 tasks pending)

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • BASINT

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • New structures for auxiliary data

New symbols for data description line of multiple line data: ozone_column ( O 3 COL ; Dobson Units ; float ; ) Column label for the ozone column in Dobson units snow_cover ( SNOWCVR ; ; int ; ) Column label for snow cover flag (1: snow cover; 0: no snow cover; -1: don’t know) SQL> desc ozone_info cloud_amount ( CLD 8 ; ; int ; ) Name Null? Type ---------------------Column label for cloud amount in oktas (0: clear sky; 1: one okta or less of SUBMIT_ID NOT NULL NUMBER(8) cloud cover; … ; 8: complete overcast; 9: no data due to fog or snow flurry) REGISTERATION_ID NOT NULL NUMBER(5) OZONE_INFO_ID NOT NULL CHAR(14) sunshine_duration ( SUNT ; hours ; float ; ) INSTRUMENT_IDENTIFIER CHAR(20) ALTITUDE NOT NULL NUMBER(6, 2) Column label for sunshine duration in decimal hours LATITUDE NOT NULL NUMBER(6, 4) LONGITUDE NOT NULL NUMBER(7, 4) year_UTC ( UYEAR ; ; int ; [1900: 2100] ) ZONE_STD NUMBER(5, 3) Column label for the year in Coordinated Universal Time UNCERTAINTY_TIME VARCHAR 2(100) UNCERTAINTY_TIME_SEC NUMBER(32) month_UTC ( UMONTH ; ; int ; [1: 12] ) CALIBRATION_DATE DATE SQL> desc ozone_day MODEL_IDENTIFIER CHAR(20) Column label for the month in Coordinated Universal Time Name Null? Type CALIBRATION_PROCEDURE_FILE VARCHAR 2(20) ---------------------day_UTC ( UDAY ; ; int; [1: 31] ) OZONE_INFO_ID NOT NULL CHAR(14) Column label for the day of the month in Coordinated Universal Time DATE_UTC NOT NULL DATE Data types considered: 1. Ozone column (daily representative values and diurnal variation) 2. Information on snow cover 3. Cloud amount 4. Sunshine duration (Oracle structures and Flexstor formats for integrated irradiance already exist. ) OZONE_DAY_ID NOT NULL CHAR(14) OZONE_DAILY NUMBER(5, 2) SQL> desc ozone Name Null? Type --------------------- OZONE_DAY_ID NOT NULL CHAR(14) TIME_UTC NOT NULL NUMBER(7, 5) SOLAR_ZENITH_ANGLE NUMBER(6, 3) OZONE NOT NULL NUMBER(5, 2)

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • New structures for auxiliary data • Statement of user requirements

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • New structures for auxiliary data • Statement of user requirements • Inventory of QC procedures

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • New structures for auxiliary data • Statement of user requirements • Inventory of QC procedures • Topography and surface inhomogeneties

Main results • Installation of new database hardware; transfer of UV database • Web-page interface to the database • New structures for auxiliary data • Statement of user requirements • Inventory of QC procedures • Topography and surface inhomogeneties • Reports on 3 D modelling and flagging

The _________ next 9 months…

WG 1: Data analysis • Progress in description of UV climatology [LAP, RIVM] • Aerosol climatology for UV modelling [UG] • Evaluation of the impact of atmospheric variability on long-term changes in UVR [FMI] • Definition of optimal wavelength band location for investigation of long-term changes in UVR [UH]

WG 2: Database management • Submission of approx. 15, 000 days of UV data [BOKU et al. ] • Database reports [UG] • Addition of structures for auxiliary data [FMI] • Updated and validated metadata pages [UMIST]

WG 2: Database management (continued) • Installation of web-page interface for BASINT tools [BAS] • Flagging of spectral irradiance for wavelength shifts and spectral anomalies [RIVM]

Month 12 15 18 6 a. Development & testing of methods to identify erroneous values of spectral UV irradiance [RIVM] WG 3: Data Flagging 5 e. Outline of method for cloudflagging algorithm [NPI] 6 b. Description of method for the flagging of atmospheric anomalies [NPI] 6 e. Report on analysis of wavelengthshift & spectral anomalies for subsets of data in database[RIVM] 6 d. Report on the method used in the detection of natural spectral distortion [LAP] 5 h. Beta version of cloud-flagging algorithm available for testing [NPI] 21 6. 1 Flagging spectral irradiance for 6 g. Flagging of all valid spectra in wavelength shifts & spectral anomalies [RIVM] database completed [RIVM] 24 6 h. flagging algorithm for atmospheric anomalies made available at the database [NPI] 6. 4 Report on status and meaning of all database flagging [LAP] 27 30 6 i. Report on methods for detection of natural factors influencing spectral measurements [LAP] 6 j. Flagging of atmospheric anomalies 6. 2 Flagging of atmospheric anomalies applied to data with suitable ancillary [NPI] information [NPI]

WG 3: QA/QC • Report on status & relevance of flagging within database [LAP] • Recommendation on QA at sites [BAS] • Quality audit of measuring sites [UG] • Evaluation and distribution of QC tools [RIVM, UI] • Development & application of cloud flagging algorithm [NPI]

WG 4: Modelling • Development, evaluation and installation of fast RT model [NPI] • Algorithm for reconstruction of spectra from filter radiometers [UJF] • Cast study on influence of topography and inhomogeneous surfaces [NILU]