Towards a Global Sea Ice Towards a Global Sea Ice Mapping SystemMapping System

International Ice Charting Working International Ice Charting Working Group – VGroup – V

Hamburg – April 19-23, 2004Hamburg – April 19-23, 2004

ISIS - the IT PerspectiveISIS - the IT Perspective

Virtual Ice Charting SystemVirtual Ice Charting System

Archive

BrowserInterface

Distribution

Ingest Production

Ice AnalystApplication

DatabaseDatabase

Database

Click on the boxes for more information

DataAcquisition

System

ProductCreation(ArcGIS)

ISISViewer

(Imagine)

WorkstationTemporary

StorageBrowser

ProductDistribution

System

Archive(coverages &simple layers)

Catalogue(coverages)

PRODUCTION

users

data

ISIS - todayISIS - today

ArcSDE

DataAcquisition

System

ProductCreation(ArcGIS)

ISISViewer

(Imagine)

WorkstationTemporary

StorageBrowser

ProductDistribution

System

Archive(complete

geodatabase)

Catalogue

PRODUCTION

users

data

ISIS - JuneISIS - June

ArcSDE

CoveragesCoverages vs Geodatabase vs Geodatabase

Metadata…

..

…

Metadata…

..

…

Coverages vs Coverages vs GeodatabaseGeodatabase

Metadata…

..

…Metadata

…

..

…

Metadata…

..

…

ISIS – Future?ISIS – Future?

users

data

DataAcquisition

System

ProductCreation(ArcGIS)

ISISViewer

(Imagine)

WorkstationTemporary

StorageBrowser

ProductDistribution

SystemCatalogue

PRODUCTION

GeodatabaseArchive

ArcSDE

GeodatabaseArchive

ArcSDE

GeodatabaseArchive

ArcSDE

GeodatabaseArchive

ArcSDE

The virtual world ice The virtual world ice serviceservice

Connecting DatabasesConnecting Databases

Geodatabase

ArcSDE

Geodatabase

ArcSDE

Oracle OracleTODAY

Browser Browser

Connecting DatabasesConnecting Databases

Geodatabase

ArcSDE

Geodatabase

ArcSDE

Browser Browser

FUTURE

XML

Oracle OracleAccessFlat FileSybaseFlat FileSQLServer Informix

Connecting DatabasesConnecting Databases

Geodatabase

ArcSDE

Geodatabase

ArcSDE

Browser Browser

WebService

WebServiceInternetInternet

Common Schema – The KeyCommon Schema – The Key

Database schema is a description of Database schema is a description of a particular collection of data, using a particular collection of data, using a given data model. a given data model.

Objects e.g. Ice PolygonObjects e.g. Ice Polygon Attributes e.g. Total ConcentrationAttributes e.g. Total Concentration

Attribute_Label: Attribute_Label: CTCT Attribute_Definition: Attribute_Definition: Total Concentration.Total Concentration. Attribute_Definition Source: Attribute_Definition Source: SIGRID-3SIGRID-3 Attribute Domain Values:Attribute Domain Values:

Ice Free 00 Less than 1/10 (open water) 01 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

Another SchemaAnother SchemaECDIS Ice ObjectsECDIS Ice Objects

Code:Code: ICEACT;ICEACT; Reference:Reference: "Workshop on International Standards for Ice Information in "Workshop on International Standards for Ice Information in

ECDIS," June 27-ECDIS," June 27- 29, 1995, Canada/Germany/United States.29, 1995, Canada/Germany/United States. Input Type:Input Type: EE Expected Input:Expected Input: IDID MeaningMeaning 1 1 1/101/10 22 2/102/10 33 3/103/10 44 4/104/10 55 5/105/10 6 6 6/106/10 77 7/107/10 88 8/108/10 99 9/109/10 1010 <1/10 - 2/10<1/10 - 2/10 1111 1/10 - 3/101/10 - 3/10 1212 4/10 - 6/104/10 - 6/10 1313 7/10 - 8/107/10 - 8/10 1414 9/10 - <10/109/10 - <10/10 1515 10/10 with openings10/10 with openings 1616 10/10 without openings10/10 without openings 1717 <1/10<1/10 1818 Undetermined or UnknownUndetermined or Unknown Definition:Definition: ICEACT specifies the total concentration of ice in an area (‘Ct’).ICEACT specifies the total concentration of ice in an area (‘Ct’). Remarks:Remarks: This attribute represents the ratio expressed in tenths describing the area This attribute represents the ratio expressed in tenths describing the area

of of the water surface covered by ice as a fraction of the whole area.the water surface covered by ice as a fraction of the whole area.

ISIS SchemaISIS Schema Attribute_Label: Attribute_Label: CtCt Attribute_Definition: Attribute_Definition: Total Concentration.Total Concentration. Attribute_Definition Source: Attribute_Definition Source: MANICEMANICE Attribute Domain Values:Attribute Domain Values:

Less than 1/10 (open water) 0 1/10 1 2/10 2 3/10 3 4/10 4 5/10 5 6/10 6 7/10 7 8/10 8 9/10 9 9+/10 9+ 10/10 10

Short Term Benefit of a Short Term Benefit of a Common Schema – Code Common Schema – Code

SharingSharing$Sub_CTotal = CValue($EggCodes{"Ca"}) + CValue($EggCodes{"Cb"}) + CValue($EggCodes{"Cc"}) + $Cd;if ($Sub_CTotal eq 0) { $CTotal = CValue($EggCodes{"Ct"})} else { $CTotal = $Sub_CTotal }print "Total of Ca + Cb + Cc + Cd is " . "$CTotal \n";

if ($CTotal > 10) { EndProgram($BAD_ARG, "Ca + Cb + Cc + Cd has exceeded 10 tenths");}if ( CValue($EggCodes{"Ct"}) <> $CTotal) { EndProgram($BAD_ARG, "Ct must equal Ca + Cb + Cc + derived Cd");}

Proposal for a Near Term Proposal for a Near Term Objective Toward a Global Ice Objective Toward a Global Ice

Mapping SystemMapping System

Within the next 2 years, all Within the next 2 years, all participating Ice Services implement participating Ice Services implement one common database schema in one common database schema in their ice mapping systemstheir ice mapping systems