Project

General

Profile

« Previous | Next » 

Revision 6177

mappings/VegCore-VegBIEN.csv: Made taxonoccurrence.verbatimcollectorname an fkey to party, and renamed it to collector_id

View differences:

inputs/XAL/Specimen/VegBIEN.csv
17 17
darwin:InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/referencename/name,
18 18
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
19 19
darwin:ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
20
darwin:Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
20 21
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
21 22
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",
22 23
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
......
51 52
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
52 53
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
53 54
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
54
darwin:Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
55 55
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
56 56
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
57 57
darwin:MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
inputs/bien_web/observation/VegBIEN.csv
18 18
plotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
19 19
collectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
20 20
taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
21
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
21 22
isCultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,
22 23
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
23 24
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",
......
40 41
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
41 42
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
42 43
taxon,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
43
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
44 44
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
45 45
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
46 46
country,/location/locationplace/*_id/place/country,
inputs/bien_web/observation/test.xml.ref
20 20
                            </plantobservation>
21 21
                        </aggregateoccurrence>
22 22
                        <authortaxoncode>$collectionNumber</authortaxoncode>
23
                        <collector_id><party><fullname>$collector</fullname></party></collector_id>
23 24
                        <iscultivated>$isCultivated</iscultivated>
24 25
                        <taxondetermination>
25 26
                            <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
......
126 127
                                </taxonverbatim>
127 128
                            </taxonverbatim_id>
128 129
                        </taxondetermination>
129
                        <verbatimcollectorname>$collector</verbatimcollectorname>
130 130
                    </taxonoccurrence>
131 131
                </locationevent>
132 132
                <locationplace>

Also available in: Unified diff