1 / 20

Data inventory

Data inventory. UkrSCES. Scientific vessels. WWW server. DATABASE on SQL server. IMS server. Analytic laboratories. Current State. Security. Time checking. Spatial distribution. Meteorology information. Personification. SQL server. Ecological information.

grover
Download Presentation

Data inventory

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data inventory UkrSCES

  2. Scientific vessels WWW server DATABASE on SQL server IMS server Analytic laboratories Current State Database

  3. Security • Time checking • Spatial distribution • Meteorologyinformation • Personification SQL server • Ecologicalinformation • Methodics andequipment þ þ • Quality control • Quality control Database Database

  4. In cruise In analytical laboratories The critical control Quality control Database

  5. INTERNET Network Structure Microsoft Windows 2003Server router UNIX Server Antivirus Firewall Proxy Cache UkrSCES LAN Database

  6. Providing of Network Security • Working with personal logins; • Possibility of storing data on the central server; • Restrictions for using the administrator rights at the workstations; • Restrictions for remote access to the workstations resources; • Prohibitation of using illegal software; • Using anti-virus software; • Monitoring of INTERNET access. Database

  7. Database Abstract • UkrSCES database “Sea Base” was created in 2002. • In 2005 it was reorganized. • The database at the present time is functioning on the MS SQL Server 2003 platform. • There are 279 parameters in 3 languages: English, Russian and Ukrainian. Database

  8. Database Thematics The new version of DB is presented in 22 tables on the following information: General meteorological information; Hydrology and hydrochemistry; Geology; Pollution in bottom sediments; Pollution in water; Metals in water; Metals in bottom sediments; Polyaromatics in water; Polyaromatics in bottom sediments; Chlorine organics in water. Chlorine organics in bottom sediments; Radioactive elements in water; Radioactive elements in bottom sediments; Macrozoobenthos; Phytoplankton; Fotosyntetic pigments; Meyo benthos; Microphytobenthos; Macrophytobenthos; Methods. Database

  9. Database Structure Each sea station where investigations are made, is identified by: Platform; Research program; Time; and spatial parameters. Each parameter, in turn, is identified by: sample number; the environment of sampling (biota, water, sediments, air, etc.); the technique of measurement; the analytical equipment by means of which the analysis are made; personification characteristics; and an attribute of quality (quality label). Database

  10. Spatial distribution 1910-1917 1918-1941 1945-1991 1991-2006 1910-2006 Database

  11. “Sea Base” total information • Observation period: 06.08.1910 - 30.12.2005 • Expeditions total amount: 1123 • UkrSCES expeditions amount: 210 • Other organizations expeditions amount - 267 • WOD98 expeditions amount: 646 • Stations total amount: 26587 More detailed and accurate information will be given in the Meta data catalog within our future activities Database

  12. Certified Marine Nautical Charts ESRI ARCinfo workstation ESRI SDE server Certified Thopographical Charts SQL requests Mapping system Mapping system

  13. 1:500000 Topographic chart Ukraine Mapping system

  14. Sea navigating database SDE

  15. 3D Scening Port Illichivsk SDE

  16. ESI maps In 2003 within the framework of the project “Development of maps showing possible sources…” have been created maps of ecological sensitivity of the coastal zone of Ukraine to oil pollution. Mapping system

  17. Sea currents (NWBS) In 2004, for the verification of the oil spill model GNOME to the conditions of our region, seasonal fields of sea currents and river flows of the Northwestern part of the Black sea were prepared Mapping System

  18. Human activities in Kerch strait Pollution sources of Odessa oblast Thematic maps Mapping system

  19. Internet Map Services A set of available information at our place became a fundamental set for creating information systems on the basis of ArcGIS and ArcIMS. At the present time an interactive map service is under construction: ecological ATLAS and Marine Information System Accidental Oil Spills. IMS

  20. Metadata preparation ArcCatalog, supplied with ArcGIS 9.1 is the tool able to prepare metadata. Standard form of ArcCatalog for metadata creation and editing correspond with ISO 19115:2003 or american standard FGDC-STD-001-1998 Metadata

More Related