Changeset 1798 for TI07-MOLES/trunk/DIF

Timestamp:

04/12/06 11:50:35 (13 years ago)

Author:

ko23

Message:

Beta version of d2b for DIF

File:

• TI07-MOLES/trunk/DIF/XQuery/DIF2MOLES.xquery (modified) (8 diffs)

TI07-MOLES/trunk/DIF/XQuery/DIF2MOLES.xquery

@@ -6 +6 @@
 declare namespace xsi='http://www.w3.org/2001/XMLSchema-instance'; 
 declare namespace f='http://ndg.nerc.ac.uk/moles/localfunctions';
+declare variable $input_collection as xs:string {'/db/discovery'};
+declare variable $ndg_data_provider_vocab as xs:string {'http://vocab.ndg.nerc.ac.uk/N010'};
 declare variable $gcmd_science_valids as xs:string {'http://gcmd.gsfc.nasa.gov/Resources/valids/gcmd_parameters.html'};
 declare variable $gcmd_project_valids as xs:string {'http://gcmd.gsfc.nasa.gov/Resources/valids/projects.html'};
@@ -14 +16 @@
 
 element dgMetadata {
-for $DIF in collection('/db/discovery')/dif:DIF
+for $DIF in collection($input_collection)/dif:DIF[dif:Entry_ID='NOCSDAT100']
 return
         element dgMetadataRecord {
@@ -28 +30 @@
                                 element localIdentifier {concat('generated_desc-', string($DIF/dif:Entry_ID))}
                         },
-                        element metadataDescriptionLastUpdated {current-dateTime()}                     ,
+                        element metadataDescriptionLastUpdated {current-date()}                 ,
                         element abstract {
                                 element abstractText {string($DIF/dif:Summary)}
@@ -39 +41 @@
                         element dgDataSummary {
                                 element dgParameterSummary {
-                                        element dgStandardParameterMeasured {
+                                        element dgParameterValue {
+                                                element dgValueDataParameter {
+                                                        element Value {''},
+                                                        element dgStandardUnit {
+                                                                element dgValidTerm {'dummy'},
+                                                                element dgValidTermID {
+                                                                        element ParentListID {'http://vocabs.ndg.nerc.ac.uk/null.'},
+                                                                        element TermID {escape-uri('dummy unit', true())}
+                                                                }
+                                                        }
+                                                }
+                                        },
+                                        element dgStdParameterMeasured {
                                                 element dgValidTerm {'dummy'},
                                                 element dgValidTermID {
-                                                        element parentListID {'http://vocabs.ndg.nerc.ac.uk/null.'},
-                                                        element termID {escape-uri('dummy term', true())}
-                                                },
+                                                        element ParentListID {'http://vocabs.ndg.nerc.ac.uk/null.'},
+                                                        element TermID {escape-uri('dummy term', true())}
+                                                }
+                                        },
                                         element ParameterName {'dummy term'},
                                         element ParameterAbbreviation {'dummy term'}
+                                },
+                                if (exists($DIF/(dif:Spatial_Coverage)) or exists($DIF/dif:Temporal_Coverage)) then
+                                        element dgDataCoverage {
+                                                if (exists($DIF/dif:Spatial_Coverage/dif:Northernmost_Latitude)) then
+                                                        element dgSpatialCoverage {
+                                                                for $boundingbox in $DIF/dif:Spatial_Coverage[exists(dif:Northernmost_Latitude)]
+                                                                return
+                                                                        element BoundingBox {
+                                                                                element Limit_North {string($boundingbox/dif:Northernmost_Latitude)},
+                                                                                element Limit_South {string($boundingbox/dif:Southernmost_Latitude)},
+                                                                                element Limit_West {string($boundingbox/dif:Westernmost_Longitude)},
+                                                                                element Limit_East {string($boundingbox/dif:Easternmost_Longitude)}
+                                                                        }
+                                                        }
+                                                else (),
+                                                if (exists($DIF/dif:Temporal_Coverage/dif:Start_Date)) then
+                                                        element dgTemporalCoverage {
+                                                                for $temporalcoverage in $DIF/dif:Temporal_Coverage[exists(dif:Start_Date) and exists(dif:Stop_Date)]
+                                                                return
+                                                                        element DateRange {
+                                                                                element DateRangeStart {string($temporalcoverage/dif:Start_Date)},
+                                                                                element DateRangeEnd {string($temporalcoverage/dif:Stop_Date)}
+                                                                        }
+                                                        }
+                                                else ()
                                         }
-                                }
+                                else ()
                         },
                         element dgDataRoles {
@@ -68 +108 @@
                                                                 element localIdentifier  {escape-uri(concat('generated_orgcit-', string($creatorID)), true())}
                                                         },
-                                                element startDate {current-dateTime()}
+                                                element startDate {current-date()}
                                                 }
                                         }
@@ -86 +126 @@
                                                         element localIdentifier {$input_repository_local}
                                                 },
-                                        element startDate {current-dateTime()}
+                                        element startDate {current-date()}
                                         }
                                 }
                         }
                 },
-                for $structuredKeywords in $DIF/Keywords
+                element dgStructuredKeyword {
+                        element dgValidTerm {'MDIP'},
+                        element dgValidTermID {
+                                element ParentListID {$ndg_data_provider_vocab},
+                                element TermID {'NDGO0001'}
+                        }
+                },
+                for $structuredKeywords in $DIF/dif:Keywords
                 return 
-                        element dgStructuredKeywords {
+                        element dgStructuredKeyword {
                                 element dgValidTerm {$structuredKeywords},
                                 element dgValidTermID {
-                                        element parentListID {'http://vocab.ndg.nerc.ac.uk/null.'},
-                                        element termID {escape-uri($structuredKeywords, true())}
+                                        element ParentListID {'http://vocab.ndg.nerc.ac.uk/null.'},
+                                        element TermID {escape-uri($structuredKeywords, true())}
+                                }
+                        },
+                for $structuredKeywords in $DIF/dif:ISO_Topic_Category
+                return 
+                        element dgStructuredKeyword {
+                                element dgValidTerm {string($structuredKeywords)},
+                                element dgValidTermID {
+                                        element ParentListID {'http://vocab.ndg.nerc.ac.uk/null.'},
+                                        element TermID {escape-uri(string($structuredKeywords), true())}
                                 }
                         },
@@ -104 +160 @@
                                 if (exists($DIF/dif:DIF_Creation_Date)) then
                                         element RecordCreation {
-                                                element CreatedDate {string($DIF/dif:DIF_Creation_Date)},
-                                                element CreatedBy {$input_repository}
+                                                element CreatedDate {
+                                                        if (string($DIF/dif:DIF_Creation_Date) castable as xs:date) then 
+                                                                string($DIF/dif:DIF_Creation_Date) cast as xs:date
+                                                        else (current-date())
+                                                },
+                                        element CreatedBy {$input_repository}
                                         }
                                 else 
                                         element RecordCreation {
-                                                element CreatedDate {current-dateTime()},
+                                                element CreatedDate {current-date()},
                                                 element CreatedBy {'MOLES Import'}
                                         },
                                 if (exists($DIF/dif:Last_DIF_Revision_Date)) then
                                         element RecordUpdate {
-                                                element UpdateDate {$DIF/dif:Last_DIF_Revision_Date},
-                                                element UpdateBy {$input_repository}
+                                                element UpdateDate {
+                                                        if (string($DIF/dif:Last_DIF_Revision_Date) castable as xs:date) then 
+                                                                string($DIF/dif:Last_DIF_Revision_Date) cast as xs:date
+                                                        else (current-date())
+                                                },
+                                                element UpdatedBy {$input_repository}
                                         }
                                 else ()
@@ -121 +185 @@
                 else ()
         } (: </dgMetadataRecord>:),
-        for $creator in distinct-values(collection('/db/discovery')/dif:DIF/dif:Data_Set_Citation/dif:Dataset_Creator | dif:Originating_Center)
+        for $creator in distinct-values(collection($input_collection)/dif:DIF/dif:Data_Set_Citation/dif:Dataset_Creator | dif:Originating_Center)
         return
                 element dgOrganisation {