Towards a Global Sea Ice Mapping System International

Towards a Global Sea Ice Mapping System International Ice Charting Working Group – V Hamburg – April 19 -23, 2004

ISIS - the IT Perspective

Virtual Ice Charting System Ice Analyst Application Browser Interface Archive Ingest Production Database Distribution Click on the boxes for more information

data ISIS - today ISIS Viewer (Imagine) PRODUCTION Data Acquisition System Product Creation (Arc. GIS) Workstation Temporary Storage Arc. SDE Browser Catalogue (coverages) Archive (coverages & simple layers) Product Distribution System users

data ISIS - June ISIS Viewer (Imagine) PRODUCTION Data Acquisition System Product Creation (Arc. GIS) Workstation Temporary Storage Arc. SDE Browser Catalogue Archive (complete geodatabase) Product Distribution System users

Coverages vs Geodatabase Metadata …. . …

Coverages vs Geodatabase Metadata … …. . …

data ISIS – Future? ISIS Viewer (Imagine) Product Creation (Arc. GIS) Workstation Temporary Storage Arc. SDE Geodatabase Archive Browser PRODUCTION Data Acquisition System Arc. SDE Catalogue Product Distribution System users Geodatabase Archive Arc. SDE Geodatabase Archive

The virtual world ice service

Connecting Databases Browser Arc. SDE Geodatabase Oracle Arc. SDE TODAY Geodatabase Oracle

Connecting Databases Browser FUTURE Arc. SDE XML Arc. SDE Geodatabase SQLServer Sybase Flat Oracle File Informix Flat Access Oracle File

Connecting Databases Web Service Internet Web Service Browser Arc. SDE Geodatabase

Common Schema – The Key n n n Database schema is a description of a particular collection of data, using a given data model. Objects e. g. Ice Polygon Attributes e. g. Total Concentration

n n Attribute_Label: CT Attribute_Definition: Total Concentration. Attribute_Definition Source: SIGRID-3 Attribute Domain Values: n n n n n Ice Free 00 Less than 1/10 (open water) Bergy Water 02 1/10 10 2/10 20 3/10 30 4/10 40 5/10 50 6/10 60 7/10 70 8/10 80 9/10 90 10/10 92 9/10– 10/10 91 8/10 – 9/10 89 8/10 – 10/10 81 7/10 – 9/10 79 etc 01

n n n n n n n Code: ICEACT; Reference: Another Schema ECDIS Ice Objects "Workshop on International Standards for Ice Information in ECDIS, " June 2729, 1995, Canada/Germany/United States. E Input Type: Expected Input: ID Meaning 1 1/10 2 2/10 3 3/10 4 4/10 5 5/10 6 6/10 7 7/10 8 8/10 9 9/10 10 <1/10 - 2/10 11 1/10 - 3/10 12 4/10 - 6/10 13 7/10 - 8/10 14 9/10 - <10/10 15 10/10 with openings 16 10/10 without openings 17 <1/10 18 Undetermined or Unknown Definition: ICEACT specifies the total concentration of ice in an area (‘Ct’). Remarks: This attribute represents the ratio expressed in tenths describing the area of

ISIS Schema n n Attribute_Label: Ct Attribute_Definition: Total Concentration. Attribute_Definition Source: MANICE Attribute Domain Values: n n n Less than 1/10 2/10 3/10 4/10 5/10 6/10 7/10 8/10 9+/10 10/10 1/10 (open water) 0 1 2 3 4 5 6 7 8 9 9+ 10

Short Term Benefit of a Common Schema – Code Sharing $Sub_CTotal = CValue($Egg. Codes{"Ca"}) + CValue($Egg. Codes{"Cb"}) + CValue($Egg. Codes{"Cc"}) + $Cd; if ($Sub_CTotal eq 0) { $CTotal = CValue($Egg. Codes{"Ct"}) } else { $CTotal = $Sub_CTotal } print "Total of Ca + Cb + Cc + Cd is ". "$CTotal n"; if ($CTotal > 10) { End. Program($BAD_ARG, "Ca + Cb + Cc + Cd has exceeded 10 tenths"); } if ( CValue($Egg. Codes{"Ct"}) <> $CTotal) { End. Program($BAD_ARG, "Ct must equal Ca + Cb + Cc + derived Cd"); }

Proposal for a Near Term Objective Toward a Global Ice Mapping System n Within the next 2 years, all participating Ice Services implement one common database schema in their ice mapping systems
- Slides: 18