Project

General

Profile

« Previous | Next » 

Revision 6343

Added by Aaron Marcuse-Kubitza about 12 years ago

Added inputs/QFA/

View differences:

inputs/QFA/Specimen/map.csv
1 
QFA,VegCore,Filter,Comments
2 
id,occurrenceID,,
3 
rights,dcterms:rights,,
4 
recordNumber,recordNumber,,
5 
family,family,,
6 
associatedSequences,associatedSequences,,
7 
institutionID,institutionID,,
8 
specificEpithet,specificEpithet,,
9 
datasetName,datasetName,,
10 
locality,locality,,
11 
verbatimElevation,verbatimElevation,,
12 
typeStatus,typeStatus,,
13 
verbatimEventDate,verbatimEventDate,,
14 
identifiedBy,identifiedBy,,
15 
associatedReferences,associatedReferences,,
16 
kingdom,kingdom,,
17 
institutionCode,institutionCode,,
18 
catalogNumber,catalogNumber,,
19 
verbatimSRS,verbatimSRS,,
20 
verbatimLongitude,verbatimLongitude,,
21 
rightsHolder,dcterms:rightsHolder,,
22 
dateIdentified,dateIdentified,,
23 
acceptedNameUsage,acceptedNameUsage,,
24 
nomenclaturalCode,nomenclaturalCode,,
25 
bibliographicCitation,dcterms:bibliographicCitation,,
26 
taxonRank,taxonRank,,
27 
decimalLatitude,decimalLatitude,,
28 
genus,genus,,
29 
basisOfRecord,basisOfRecord,,
30 
occurrenceRemarks,occurrenceRemarks,,
31 
type,dcterms:type,,
32 
habitat,habitat,,
33 
geodeticDatum,geodeticDatum,,
34 
decimalLongitude,decimalLongitude,,
35 
verbatimLatitude,verbatimLatitude,,
36 
establishmentMeans,establishmentMeans,,
37 
collectionID,collectionID,,
38 
verbatimCoordinateSystem,verbatimCoordinateSystem,,
39 
infraspecificEpithet,infraspecificEpithet,,
40 
country,country,,
41 
language,dcterms:language,,
42 
eventDate,eventDate,,
43 
collectionCode,collectionCode,,
44 
scientificName,scientificName,,
45 
stateProvince,stateProvince,,
46 
scientificNameAuthorship,scientificNameAuthorship,,
47 
verbatimCoordinates,verbatimCoordinates,,
48 
ownerInstitutionCode,ownerInstitutionCode,,
49 
recordedBy,recordedBy,,
50 
preparations,preparations,,
51 
datasetID,datasetID,,
52 
identificationQualifier,identificationQualifier,,
inputs/QFA/Specimen/VegBIEN.csv
1 
QFA,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
4 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1",
5 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
6 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
7 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
8 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
9 
id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
10 
recordNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
11 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
12 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_alt/2/_dateRangeEnd/value",
13 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",
14 
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,
15 
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,
16 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
17 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
18 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
19 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
20 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/name,
21 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
22 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
23 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
24 
recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
25 
id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
26 
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
27 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",
28 
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
29 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
30 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
31 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",
32 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/1",
33 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
34 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
35 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
36 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
37 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
38 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",
39 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value,
40 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
41 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
42 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
43 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
44 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
45 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
46 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
47 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
48 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
49 
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
50 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
51 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,
52 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/1,
53 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
54 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
55 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
56 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
57 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
58 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
59 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,
60 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
61 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
62 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
63 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
64 
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
65 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,
66 
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
67 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 
locality,/location/locationnarrative/_merge/1,
69 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
70 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
71 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
72 
verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
73 
verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
74 
country,/location/locationplace/*_id/place/country,
75 
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
76 
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
77 
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
78 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
79 
stateProvince,/location/locationplace/*_id/place/stateprovince,
80 
verbatimElevation,/location/verbatimelevation,
81 
acceptedNameUsage,,** No join mapping for acceptedNameUsage **
82 
associatedReferences,,** No join mapping for associatedReferences **
83 
associatedSequences,,** No join mapping for associatedSequences **
84 
basisOfRecord,,** No join mapping for basisOfRecord **
85 
bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation **
86 
datasetID,,** No join mapping for datasetID **
87 
datasetName,,** No join mapping for datasetName **
88 
geodeticDatum,,** No join mapping for geodeticDatum **
89 
institutionID,,** No join mapping for institutionID **
90 
language,,** No join mapping for dcterms:language **
91 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
92 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
93 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
94 
preparations,,** No join mapping for preparations **
95 
rights,,** No join mapping for dcterms:rights **
96 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
97 
type,,** No join mapping for dcterms:type **
98 
typeStatus,,** No join mapping for typeStatus **
99 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
100 
verbatimCoordinates,,** No join mapping for verbatimCoordinates **
101 
verbatimEventDate,,** No join mapping for verbatimEventDate **
102 
verbatimSRS,,** No join mapping for verbatimSRS **
inputs/QFA/Specimen/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
5 
        <path>
6 
            <location>
7 
                <authorlocationcode>
8 
                    <_alt>
9 
                        <1>$id</1>
10 
                        <2>
11 
                            <_join>
12 
                                <1>$institutionCode</1>
13 
                                <2>
14 
                                    <_join>
15 
                                        <1>$collectionCode</1>
16 
                                        <2>$collectionID</2>
17 
                                    </_join>
18 
                                </2>
19 
                                <3>$catalogNumber</3>
20 
                            </_join>
21 
                        </2>
22 
                    </_alt>
23 
                </authorlocationcode>
24 
                <elevation_m>
25 
                    <_units>
26 
                        <to>m</to>
27 
                        <to></to>
28 
                        <value>$verbatimElevation</value>
29 
                    </_units>
30 
                </elevation_m>
31 
                <locationevent>
32 
                    <obsenddate><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></obsenddate>
33 
                    <obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate>
34 
                    <taxonoccurrence>
35 
                        <aggregateoccurrence>
36 
                            <plantobservation>
37 
                                <collectionnumber>$recordNumber</collectionnumber>
38 
                                <specimenreplicate>
39 
                                    <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
40 
                                    <collectioncode_dwc>
41 
                                        <_join>
42 
                                            <1>$collectionCode</1>
43 
                                            <2>$collectionID</2>
44 
                                        </_join>
45 
                                    </collectioncode_dwc>
46 
                                    <institution_id><sourcename><name>$institutionCode</name></sourcename></institution_id>
47 
                                    <sourceaccessioncode>$id</sourceaccessioncode>
48 
                                </specimenreplicate>
49 
                            </plantobservation>
50 
                        </aggregateoccurrence>
51 
                        <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
52 
                        <iscultivated>
53 
                            <_map>
54 
                                <cultivated>t</cultivated>
55 
                                <wild>f</wild>
56 
                                <*></*>
57 
                                <value>$establishmentMeans</value>
58 
                            </_map>
59 
                        </iscultivated>
60 
                        <isnative>
61 
                            <_map>
62 
                                <native>t</native>
63 
                                <exotic>f</exotic>
64 
                                <*></*>
65 
                                <value>$establishmentMeans</value>
66 
                            </_map>
67 
                        </isnative>
68 
                        <sourceaccessioncode>$id</sourceaccessioncode>
69 
                        <taxondetermination>
70 
                            <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
71 
                            <taxonverbatim_id>
72 
                                <taxonverbatim>
73 
                                    <taxonlabel_id>
74 
                                        <taxonlabel>
75 
                                            <matched_label_id>
76 
                                                <taxonlabel>
77 
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
78 
                                                    <taxonomicname>
79 
                                                        <_join_words>
80 
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
81 
                                                            <2>
82 
                                                                <_alt>
83 
                                                                    <1>$scientificName</1>
84 
                                                                    <2>
85 
                                                                        <_join_words>
86 
                                                                            <1>
87 
                                                                                <_join_words>
88 
                                                                                    <2>$genus</2>
89 
                                                                                    <3>$specificEpithet</3>
90 
                                                                                    <5>
91 
                                                                                        <_join_words>
92 
                                                                                            <1>
93 
                                                                                                <_if name="if has infraspecificEpithet">
94 
                                                                                                    <cond>$infraspecificEpithet</cond>
95 
                                                                                                    <then>$taxonRank</then>
96 
                                                                                                </_if>
97 
                                                                                            </1>
98 
                                                                                            <2>$infraspecificEpithet</2>
99 
                                                                                        </_join_words>
100 
                                                                                    </5>
101 
                                                                                </_join_words>
102 
                                                                            </1>
103 
                                                                            <2>$scientificNameAuthorship</2>
104 
                                                                        </_join_words>
105 
                                                                    </2>
106 
                                                                </_alt>
107 
                                                            </2>
108 
                                                        </_join_words>
109 
                                                    </taxonomicname>
110 
                                                </taxonlabel>
111 
                                            </matched_label_id>
112 
                                            <creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate>
113 
                                            <parent_id>
114 
                                                <taxonlabel>
115 
                                                    <rank>$taxonRank</rank>
116 
                                                    <taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>
117 
                                                    <parent_id>
118 
                                                        <taxonlabel>
119 
                                                            <rank>cultivar</rank>
120 
                                                            <parent_id>
121 
                                                                <taxonlabel>
122 
                                                                    <rank>forma</rank>
123 
                                                                    <parent_id>
124 
                                                                        <taxonlabel>
125 
                                                                            <rank>variety</rank>
126 
                                                                            <parent_id>
127 
                                                                                <taxonlabel>
128 
                                                                                    <rank>subspecies</rank>
129 
                                                                                    <parent_id>
130 
                                                                                        <taxonlabel>
131 
                                                                                            <rank>species</rank>
132 
                                                                                            <taxonepithet>$specificEpithet</taxonepithet>
133 
                                                                                            <parent_id>
134 
                                                                                                <taxonlabel>
135 
                                                                                                    <rank>genus</rank>
136 
                                                                                                    <taxonepithet>$genus</taxonepithet>
137 
                                                                                                    <parent_id>
138 
                                                                                                        <taxonlabel>
139 
                                                                                                            <rank>family</rank>
140 
                                                                                                            <taxonepithet>$family</taxonepithet>
141 
                                                                                                            <parent_id>
142 
                                                                                                                <taxonlabel>
143 
                                                                                                                    <rank>order</rank>
144 
                                                                                                                    <parent_id>
145 
                                                                                                                        <taxonlabel>
146 
                                                                                                                            <rank>class</rank>
147 
                                                                                                                            <parent_id>
148 
                                                                                                                                <taxonlabel>
149 
                                                                                                                                    <rank>phylum</rank>
150 
                                                                                                                                    <parent_id>
151 
                                                                                                                                        <taxonlabel>
152 
                                                                                                                                            <rank>kingdom</rank>
153 
                                                                                                                                            <taxonepithet>$kingdom</taxonepithet>
154 
                                                                                                                                        </taxonlabel>
155 
                                                                                                                                    </parent_id>
156 
                                                                                                                                </taxonlabel>
157 
                                                                                                                            </parent_id>
158 
                                                                                                                        </taxonlabel>
159 
                                                                                                                    </parent_id>
160 
                                                                                                                </taxonlabel>
161 
                                                                                                            </parent_id>
162 
                                                                                                        </taxonlabel>
163 
                                                                                                    </parent_id>
164 
                                                                                                </taxonlabel>
165 
                                                                                            </parent_id>
166 
                                                                                        </taxonlabel>
167 
                                                                                    </parent_id>
168 
                                                                                </taxonlabel>
169 
                                                                            </parent_id>
170 
                                                                        </taxonlabel>
171 
                                                                    </parent_id>
172 
                                                                </taxonlabel>
173 
                                                            </parent_id>
174 
                                                        </taxonlabel>
175 
                                                    </parent_id>
176 
                                                    <taxonepithet>$infraspecificEpithet</taxonepithet>
177 
                                                </taxonlabel>
178 
                                            </parent_id>
179 
                                            <rank>$taxonRank</rank>
180 
                                            <taxonomicname>
181 
                                                <_join_words>
182 
                                                    <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
183 
                                                    <2>
184 
                                                        <_alt>
185 
                                                            <1>$scientificName</1>
186 
                                                            <2>
187 
                                                                <_join_words>
188 
                                                                    <1>
189 
                                                                        <_join_words>
190 
                                                                            <2>$genus</2>
191 
                                                                            <3>$specificEpithet</3>
192 
                                                                            <5>
193 
                                                                                <_join_words>
194 
                                                                                    <1>
195 
                                                                                        <_if name="if has infraspecificEpithet">
196 
                                                                                            <cond>$infraspecificEpithet</cond>
197 
                                                                                            <then>$taxonRank</then>
198 
                                                                                        </_if>
199 
                                                                                    </1>
200 
                                                                                    <2>$infraspecificEpithet</2>
201 
                                                                                </_join_words>
202 
                                                                            </5>
203 
                                                                        </_join_words>
204 
                                                                    </1>
205 
                                                                    <2>$scientificNameAuthorship</2>
206 
                                                                </_join_words>
207 
                                                            </2>
208 
                                                        </_alt>
209 
                                                    </2>
210 
                                                </_join_words>
211 
                                            </taxonomicname>
212 
                                        </taxonlabel>
213 
                                    </taxonlabel_id>
214 
                                    <author>$scientificNameAuthorship</author>
215 
                                    <family>$family</family>
216 
                                    <genus>$genus</genus>
217 
                                    <specific_epithet>$specificEpithet</specific_epithet>
218 
                                    <taxonomicname>$scientificName</taxonomicname>
219 
                                    <verbatimrank>$taxonRank</verbatimrank>
220 
                                </taxonverbatim>
221 
                            </taxonverbatim_id>
222 
                            <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>
223 
                            <taxonfit>$identificationQualifier</taxonfit>
224 
                        </taxondetermination>
225 
                    </taxonoccurrence>
226 
                </locationevent>
227 
                <locationnarrative>
228 
                    <_merge>
229 
                        <1>$locality</1>
230 
                        <3>
231 
                            <_label>
232 
                                <label>habitat</label>
233 
                                <value>$habitat</value>
234 
                            </_label>
235 
                        </3>
236 
                    </_merge>
237 
                </locationnarrative>
238 
                <locationplace>
239 
                    <place_id>
240 
                        <place>
241 
                            <coordinates_id>
242 
                                <coordinates>
243 
                                    <latitude_deg>
244 
                                        <_nullIf>
245 
                                            <null>0</null>
246 
                                            <type>float</type>
247 
                                            <value>$decimalLatitude</value>
248 
                                        </_nullIf>
249 
                                    </latitude_deg>
250 
                                    <longitude_deg>
251 
                                        <_nullIf>
252 
                                            <null>0</null>
253 
                                            <type>float</type>
254 
                                            <value>$decimalLongitude</value>
255 
                                        </_nullIf>
256 
                                    </longitude_deg>
257 
                                    <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
258 
                                    <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
259 
                                </coordinates>
260 
                            </coordinates_id>
261 
                            <country>$country</country>
262 
                            <matched_place_id>
263 
                                <place>
264 
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
265 
                                    <coordinates_id>
266 
                                        <coordinates>
267 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
268 
                                            <latitude_deg>
269 
                                                <_nullIf>
270 
                                                    <null>0</null>
271 
                                                    <type>float</type>
272 
                                                    <value>$decimalLatitude</value>
273 
                                                </_nullIf>
274 
                                            </latitude_deg>
275 
                                            <longitude_deg>
276 
                                                <_nullIf>
277 
                                                    <null>0</null>
278 
                                                    <type>float</type>
279 
                                                    <value>$decimalLongitude</value>
280 
                                                </_nullIf>
281 
                                            </longitude_deg>
282 
                                        </coordinates>
283 
                                    </coordinates_id>
284 
                                    <country>$country</country>
285 
                                    <stateprovince>$stateProvince</stateprovince>
286 
                                </place>
287 
                            </matched_place_id>
288 
                            <stateprovince>$stateProvince</stateprovince>
289 
                        </place>
290 
                    </place_id>
291 
                </locationplace>
292 
                <verbatimelevation>$verbatimElevation</verbatimelevation>
293 
            </location>
294 
        </path>
295 
    </_simplifyPath>
296 
</VegBIEN>
297 
Inserted 46 new rows into database
inputs/QFA/Specimen/unmapped_terms.csv
1 
dcterms:rights
2 
associatedSequences
3 
institutionID
4 
datasetName
5 
typeStatus
6 
verbatimEventDate
7 
associatedReferences
8 
verbatimSRS
9 
dcterms:rightsHolder
10 
acceptedNameUsage
11 
nomenclaturalCode
12 
dcterms:bibliographicCitation
13 
basisOfRecord
14 
occurrenceRemarks
15 
dcterms:type
16 
geodeticDatum
17 
verbatimCoordinateSystem
18 
dcterms:language
19 
verbatimCoordinates
20 
ownerInstitutionCode
21 
preparations
22 
datasetID

Also available in: Unified diff