Regional Meeting on Sea-Search Project in the Mediterranean, Eastern Mediterranean Sea, and Black Sea Groups

1. Sea-Search Project Western Mediterranean, Eastern MediterraneanSea and Black Sea groups First Regional Meeting15-17 May 2003 Istanbul – Turkey Israel Oceanographic & Limnological Research Israel Marine Data Center (ISRAMAR) Isaac Gertman, Yan Tsehtik and Irena Lunin

2. Establishment: December 2001 Staff: Isaac Gertman – Head Yan Tsehtik – Database developer and administrator Irena Lunin – Database developer and Webmaster • Equipment: • Server COMPAQ PROLIANT ML 370 • Personal computer Pentium IV 1000 MHZ • Personal Computer Pentium III 600 MHZ • Portable Computer Pentium III 800 MHZ

3. Software: • Windows 2000, Windows XP • Microsoft SQL Server 2000 • Microsoft ACCESS 2000/2002 • Golden Software SURFER 8 • VDS Technologies AspMap 2.0 (http://www.vdstech.com) • Tonec Inc Active Image 4.1 (http://www.tonec.com/) • ORACLE 8i

4. Data Bases: • Mediterranean Oceanographic Cruises - MEDACC • Israel Shelf Oceanographic Time Series • MEDGLOSS • Hydrometeorological Dead Sea Data • Heavy Metal Concentration in Organisms & Sediments • Hydrobiological Reports of IOLR

5. Real Time Data: • Wind, Wave, Sea Level, Sea Water Temperature, Atmospheric Pressure & currents from Mediterranean Hadera station • Sea Level, Sea Water Temperature, Atmospheric Pressure from Red Sea Eilat station • Meteorological Data from the Dead Sea • Mediterranean & Red Sea Tide forecast

6. Hadera Coal Terminal Position of wind and wave gauges

8. Dead Sea Hydrometorological Data • Bottle cast + CTD SEACAT (4-6 times per year) • Measurements (at 20 min interval) of: • total incoming radiation; • wind speed & direction; • air temperature; • relative humidity; • air pressure; • water temperature at 11 levels, between 1 m and 40 m, below the sea surface.

9. Press Desired Date for Astronomic Tide Forecast for Mediterranean Coast of Israel

10. Mediterranean Oceanographic ACCESS Database (MEDACC)

11. Input/output formats of MEDACC MEDATLAS FORMAT MEDATLAS FORMAT MEDACC ODV FORMAT Sea-Bird FORMAT

12. Primary tables

13. Data Load and Secondary tables • Loading data to primary tables and creating secondary tables by the VBA data input procedure. • Secondary tables created according to GF3 codes for measured parameters. Table Of GF3 codes

14. Data tables relationships.

15. Main properties of the MEDACC • File size - 660 Mb • Number of cruisers -1801 • Number of casts - 59092 9748773 10000000 328945 1000000 107015 40156 40049 38381 37284 29368 100000 19380 15856 12315 3036 10000 1959 1621 930 1000 191 180 180 172 100 10 1 PTS IODI FLUI NTRI CA14 TPA1 TUR2 FLUO CHPL SLCA LGHT PROT NTRA PHPH GLUC DOXY PHOS PHEO AMON

16. Time distribution of casts in MEDACC

17. Space distribution of casts in MEDACC

18. Map Building Form

19. Section Form

20. Parameter on Isopicnal Surface

21. Single Cast Graph Form

22. Group Vertical Distribution Form

23. TS Diagram Form

24. WEB interface via Microsoft Internet Explorer Browser Active Server Pages Technology www.medgloss.ocean.org.il/imdc

29. Israel shelf heavy metal information system(Organisms)

30. Interactive map included in the Web interface of the HM information system

31. Time distribution of samples for stations selected by space limits

32. . Advanced Selections page of the organisms database

33. Real time coastal data information system ISRAMAR SERVER

34. Database structure

35. WEB Interface

36. WEB Interface