Transcript "Data Inventory" Presentation

Data inventory
UkrSCES
Current State
Scientific
vessels
DATABASE
on SQL server
WWW
server
IMS
server
Analytic
laboratories
Database
Database
Security
Time checking
SQL server
Personification
Ecological
Meteorology
information
Spatial
information
distribution
Methodics and
equipment

Quality control
Database

Quality
control
Quality control
In cruise
In analytical
laboratories
The critical control
Database
Network Structure
Microsoft
Windows 2003
Server
INTERNET
router
UNIX Server
Antivirus
Firewall
UkrSCES LAN
Database
Proxy
Cache
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
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
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.
Database
Chlorine organics in bottom
sediments;
Radioactive elements in
water;
Radioactive elements in
bottom sediments;
Macrozoobenthos;
Phytoplankton;
Fotosyntetic pigments;
Meyo benthos;
Microphytobenthos;
Macrophytobenthos;
Methods.
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;
Database
the analytical equipment by
means of which the analysis
are made;
personification characteristics;
and an attribute of quality
(quality label).
Spatial distribution
········
··
·
·
·
·
1910-1917
·
·· ··········
·
·
·
·
·
·
·
·
·
·
·····
·
·
·
·
··
·
·
······
···
··
·
··
·
·
··
·
·
··
··
··
·····
·····
···
·······
····
·····
···
·······
················
··
···
· ··············· ·····
····
············
·······
···
····
··
···
·······
·
········
·
·
····
·····
·
·
···
···
·
··
·
·
·
·
·
·
·
·
·············
··········
················
··········
····
···
··· ···································
········
······
·······
1918-1941
···········
····
·
·
··
·
··
·
·
·
·
·
·
·
·
·
·
·
·
·
···········
··
·
··
·····
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
··
·
··
·
·
·
·
·
·
·
·
·
·
·
··
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·· · · · · ··· ···
··························
····
···················
··························································
························
·········
····
···
·
·
····················
·
·
·
·
····
·
··
·
·
·
·
·
····
·
·
······· · ·········
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
··
··
·
·
········
······
·········
··
·
·
········
····
·
·····
·
·
·
·
·
·
·
·
·
·····
·
··
·
·
·
·
·
···
···
·
·
·
·
·
·
·
·
·
··
·
·
··
·
··
··
··
·
·
·
·
·
·
·
·
··
·
·
·
·
·
·
··
·
·
·
·
·
·
·
·
·
·
·
·
···
··
··
·
·
·
·
·
··
·
·
·
·
·
·
·
·
··
·
·
·
·
·
·
·········
··
·
·
·
··
1945-1991
·····
····················
·
·
············
·
·
·
·
·
·
·
·
·
·
·
··
·
·
·
·
·
·
·
·
·
··········
·····················
···
··························
····
·················
·············
··········
················
·
·
·
·
·
·
··
······
·················
·
·
·
·
·
·
·······
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
···········
························································
···························
··························································
·····················
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
··
·
···
··········································································
·············
···· ······
··············
·········
·
·························
············································································
·
·
·
·
·
·
·
·
·
·
·
·
······································································································· 1991-2006
····
············································································································································
···············
·
······································································································································
·················
·········································································································
·
························· · ·········································· · ············
·
·
·
·
·
·
········
···········································································································
························ ······················· · · ············· ···· ········ ·
·
··
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·········
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
··
·
·
·
·······································
······
··························································································································································································································
··························
·
·
·
··
·
··
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·······································································································
··············· ················ ················· ···················· · ·
··································· ····················
················
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
··
·
·
·
······ ····· ······· ········ ···············
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
······
·
·······
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
····································································· ·· ·· ········· ···· ······· ····· ··· ········ ············ ······ ·· ···· ·········· ···········
············
··············
·····················
··
··
·
······················ ································ ········ ············
···························
···
·······························································
····
······· ·· ······ ····· ··············· · ················· ·······
·
·
···············
··········
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·············
··
················································································································· ········· ······· ········ · ·········· ········ · · ···· ··········· ······· · ·········································
··
· ··········· ·· ··· ···· ···· ·· ·
··· · · · · · ······ · · ··· ··· ········
·······
·
·
·
·
·
·
·
·
·
·
·
·
···········································
··
·
·
·
·
·
·
·
·
·
·
·
·
·
··········
··
·· ··· ····· · · ···· ·········· ············ ······
·· ·····
··························································
·············
·
·· ········ ···· ·
··
·
·
·
· ··
·
· ··
1910-2006
Database
“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
Mapping system
Certified
Marine Nautical Charts
ESRI ARCinfo
workstation
ESRI
SDE server
Certified
Thopographical Charts
SQL requests
Mapping system
Topographic chart Ukraine
1:500000
Mapping system
Sea navigating database
SDE
3D Scening
Port Illichivsk
SDE
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
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
Thematic maps
Human activities
in Kerch strait
Pollution sources of
Odessa oblast
Mapping system
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
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 FGDCSTD-001-1998
Metadata