Changeset 2363 for TI07-MOLES/trunk/MDIP/XQueries/NDG-MDIP.xquery

Timestamp:

02/04/07 16:15:07 (14 years ago)

Author:

ko23

Message:

Extended MDIP output from MOLES

File:

• TI07-MOLES/trunk/MDIP/XQueries/NDG-MDIP.xquery (modified) (2 diffs)

TI07-MOLES/trunk/MDIP/XQueries/NDG-MDIP.xquery

@@ -5 +5 @@
 declare namespace gco='http://www.isotc211.org/2005/gco';
 declare namespace xsi='http://www.w3.org/2001/XMLSchema-instance'; 
+(: Keep
 declare variable $targetCollection as xs:string {'TargetCollection'};
 declare variable $repositoryIdentifier as xs:string {'RepositoryID'};
 declare variable $localIdentifier as xs:string {'LocalID'};
+:)
+declare variable $targetCollection as xs:string {'/db/discovery'};
+declare variable $repositoryIdentifier as xs:string {'grid.bodc.nerc.ac.uk'};
+declare variable $localIdentifier as xs:string {'grid.bodc.nerc.ac.uk:DIF:EDMED1048001'};
 
 declare variable $ISO_639-2_ns as xs:string{$voclib:ISO_639-2_ns};
@@ -24 +29 @@
                 return
                         element Language{
-                                element LanguageName {data($lang/dgValidTerm)},
-                                element LanguageVocab {data($lang/dgValidTermID/ParentListID)},
-                                element LanguageCode {data($lang/dgValidTermID/TermID)}
+                                element LanguageName {data($lang/moles:dgValidTerm)},
+                                element LanguageVocab {data($lang/moles:dgValidTermID/moles:ParentListID)},
+                                element LanguageCode {data($lang/moles:dgValidTermID/moles:TermID)}
                         }
                                 
         else (),
 
-        element Abstract {},
-        for $isoTopic in $DE/moles:dgStructuredKeyword[moles:dgValidTermID/moles:ParentListID=''] 
-        return element TopicCategory {},
-        for $subject in distinct-values($DE/dgDataEntity/dgDataSummary/dgParameterSummary/dgStdParameterMeasured[
-        voclib:spot-vocab($voclib:gcmd_science_valids, dgValidTermID/ParentListID) 
-        or voclib:spot-vocab($voclib:gcmd_project_valids, dgValidTermID/ParentListID)
-        or voclib:spot-vocab($voclib:bodc_parameter_usage_vocab, dgValidTermID/ParentListID)
-        or voclib:spot-vocab($voclib:bodc_parameter_discovery_vocab, dgValidTermID/ParentListID)
-        ]/dgValidTerm) 
-        return element Subject {$subject},
+        element Abstract {string($DE/moles:dgMetadataDescription/moles:abstract/moles:abstractText)},
+        for $isoTopic in $DE/moles:dgStructuredKeyword[voclib:spot-vocab($voclib:iso_topic_list, moles:dgValidTermID/moles:ParentListID)] 
+        return element TopicCategory {
+        element TopicCategoryName {data($isoTopic/moles:dgValidTerm)},
+        element TopicCategoryVocab {data($isoTopic/moles:dgValidTermID/moles:ParentListID)},
+        element TopicCategoryCode {data($isoTopic/moles:dgValidTermID/moles:TermID)}
+        },
+        for $subject in ($DE/moles:dgDataEntity/moles:dgDataSummary/moles:dgParameterSummary/moles:dgStdParameterMeasured[
+        voclib:spot-vocab($voclib:gcmd_science_valids, moles:dgValidTermID/moles:ParentListID) 
+        or voclib:spot-vocab($voclib:gcmd_project_valids, moles:dgValidTermID/moles:ParentListID)
+        or voclib:spot-vocab($voclib:gcmd_science_valids_categories, moles:dgValidTermID/moles:ParentListID)
+        or voclib:spot-vocab($voclib:bodc_parameter_usage_vocab, moles:dgValidTermID/moles:ParentListID)
+        or voclib:spot-vocab($voclib:bodc_parameter_discovery_vocab, moles:dgValidTermID/moles:ParentListID)
+        ]) 
+        return (element Subject {
+        element SubjectName {data($subject/moles:dgValidTerm)},
+        element SubjectVocab {data($subject/moles:dgValidTermID/moles:ParentListID)},
+        element SubjectCode {data($subject/moles:dgValidTermID/moles:TermID)}
+        },
+        for $subterm in $subject//moles:dgValidSubterm
+        return (element Subject {
+        element SubjectName {data($subterm/moles:dgValidTerm)},
+        element SubjectVocab {data($subterm/moles:dgValidTermID/moles:ParentListID)},
+        element SubjectCode {data($subterm/moles:dgValidTermID/moles:TermID)}
+        }
+        )
+        ),
+        if (exists($DE//moles:dgTemporalCoverage/(moles:DateSingle | moles:DateRange))) then 
         element Date {
-                element DatasetStartDate {},
-                element DatasetEndDate {}
+                element DatasetStartDate {
+                let $dateStart:=min($DE//moles:dgTemporalCoverage/(moles:DateSingle | moles:DateRange/moles:DateRangeStart) cast as xs:date)
+                return 
+                if (empty($dateStart)) then () 
+                else data($dateStart)
+                },
+                element DatasetEndDate {
+                let $dateEnd:=max($DE//moles:dgTemporalCoverage/(moles:DateSingle | moles:DateRange/moles:DateRangeEnd) cast as xs:date)
+                return
+                if (empty($dateEnd)) then () 
+                else data($dateEnd)
+                }
         }
-}
+        else (),
+        let $west := min($DE/moles:dgDataEntity/moles:dgDataSummary//moles:BoundingBox/moles:LimitWest cast as xs:integer)
+        return element WestCoOrdinate {data($west)},
+        let $east := max($DE/moles:dgDataEntity/moles:dgDataSummary//moles:BoundingBox/moles:LimitEast cast as xs:integer)
+        return element EastCoOrdinate {data($east)},
+        let $north := max($DE/moles:dgDataEntity/moles:dgDataSummary//moles:BoundingBox/moles:LimitNorth cast as xs:integer)
+        return element NorthCoOrdinate {data($north)},
+        let $south := min($DE/moles:dgDataEntity/moles:dgDataSummary//moles:BoundingBox/moles:LimitSouth cast as xs:integer)
+        return element SouthCoOrdinate {data($south)},
+        element DatasetIdentifier {concat($DE/moles:dgMetadataID/moles:repositoryIdentifier, $utillib:moles_id_separator, 'MDIP', $utillib:moles_id_separator, $DE/moles:dgMetadataID/moles:localIdentifier)},
+        for $target in $DE/moles:dgStructuredKeyword[voclib:spot-vocab($voclib:ndg_data_provider_vocab, moles:dgValidTermID/moles:ParentListID) ]
+        return element Target {
+        element TargetName {data($target/moles:dgValidTerm)},
+        element TargetVocab {data($target/moles:dgValidTermID/moles:ParentListID)},
+        element TargetCode {data($target/moles:dgValidTermID/moles:TermID)}
+        }
+        }