Revision 7713
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/Madidi/IndividualObservation/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 24 | 24 |
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode", |
| 25 | 25 |
CurrentDetQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 26 |
TreeNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 26 |
TreeNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 27 | 27 |
Tree,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1, |
| 28 | 28 |
CollectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 29 | 29 |
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/ARIZ/omoccurrences/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes", |
| 29 | 29 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 30 | 30 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 31 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 31 | 32 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 32 | 33 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 33 | 34 |
reproductiveCondition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| ... | ... | |
| 136 | 137 |
month,,** No join mapping for month ** |
| 137 | 138 |
municipality,,** No join mapping for municipality ** |
| 138 | 139 |
observeruid,,** No join mapping for *observeruid ** |
| 139 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 140 | 140 |
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** |
| 141 | 141 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** Only populated for 547 rows |
| 142 | 142 |
preparations,,** No join mapping for preparations ** |
| inputs/TRT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 24 | 24 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 25 | 25 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 26 | 26 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 27 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 27 | 28 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 28 | 29 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 29 | 30 |
reproductiveCondition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| ... | ... | |
| 108 | 109 |
language,,** No join mapping for language ** |
| 109 | 110 |
municipality,,** No join mapping for municipality ** |
| 110 | 111 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 111 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 112 | 112 |
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** |
| 113 | 113 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 114 | 114 |
previousIdentifications,,** No join mapping for previousIdentifications ** |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
interpretationdate,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 14 | 14 |
taxonfit,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 15 | 15 |
collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 16 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 16 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 17 | 17 |
collectionnumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 18 | 18 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 19 | 19 |
collectionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else", |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 15 | 15 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 16 | 16 |
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 17 |
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 18 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 17 |
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 18 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 19 | 19 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 20 | 20 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 21 | 21 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| inputs/UBC/Specimen/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 48 | 48 |
<taxonoccurrence> |
| 49 | 49 |
<aggregateoccurrence> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<specimenreplicate> |
| inputs/HIBG/Specimen/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value, |
| 22 | 22 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 23 | 23 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 24 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 24 | 25 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 25 | 26 |
reproductiveCondition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 26 | 27 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| ... | ... | |
| 99 | 100 |
modified,,** No join mapping for modified ** |
| 100 | 101 |
municipality,,** No join mapping for municipality ** |
| 101 | 102 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 102 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 103 | 103 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 104 | 104 |
references,,** No join mapping for distributors ** |
| 105 | 105 |
rightsHolder,,** No join mapping for dataOwners ** |
| inputs/HIBG/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 17 | 17 |
modified |
| 18 | 18 |
identificationRemarks |
| 19 | 19 |
georeferenceVerificationStatus |
| 20 |
occurrenceRemarks |
|
| 21 | 20 |
municipality |
| 22 | 21 |
type |
| 23 | 22 |
language |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 106 | 106 |
<2>$dwc_terms_individualCount</2> |
| 107 | 107 |
</_alt> |
| 108 | 108 |
</count> |
| 109 |
<notes>$conceptual_darwin_2003_1_0_Notes</notes> |
|
| 109 |
<notes> |
|
| 110 |
<_join> |
|
| 111 |
<1>$dwc_terms_occurrenceRemarks</1> |
|
| 112 |
<2>$conceptual_darwin_2003_1_0_Notes</2> |
|
| 113 |
</_join> |
|
| 114 |
</notes> |
|
| 110 | 115 |
<plantobservation> |
| 111 | 116 |
<authorplantcode> |
| 112 | 117 |
<_alt> |
| inputs/NY/Ecatalog_all/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 21 | 21 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 22 | 22 |
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 23 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 24 |
PlantFungDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_label[label=""plant fungus""]/value", |
|
| 23 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/1,
|
|
| 24 |
PlantFungDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/2/_label[label=""plant fungus""]/value",
|
|
| 25 | 25 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,Usage inconsistent with DwC definition |
| 26 | 26 |
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 27 | 27 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/CVS/taxonObservation_/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
interpretationDate,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 14 | 14 |
taxonFit,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 15 | 15 |
collectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 16 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 16 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 17 | 17 |
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 18 | 18 |
museumAccessionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 19 | 19 |
collectionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else", |
| inputs/ARIZ/omoccurrences/unmapped_terms.csv | ||
|---|---|---|
| 17 | 17 |
endDayOfYear |
| 18 | 18 |
verbatimEventDate |
| 19 | 19 |
*substrate |
| 20 |
occurrenceRemarks |
|
| 21 | 20 |
informationWithheld |
| 22 | 21 |
dataGeneralizations |
| 23 | 22 |
associatedOccurrences |
| inputs/TRT/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
typeStatus |
| 2 |
occurrenceRemarks |
|
| 3 | 2 |
associatedReferences |
| 4 | 3 |
georeferenceProtocol |
| 5 | 4 |
type |
| inputs/HVAA/Specimen/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes", |
| 30 | 30 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 31 | 31 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 32 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 32 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 33 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2, |
|
| 33 | 34 |
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 34 | 35 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 35 | 36 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| ... | ... | |
| 118 | 119 |
modified,,** No join mapping for modified ** |
| 119 | 120 |
month,,** No join mapping for month ** |
| 120 | 121 |
municipality,,** No join mapping for municipality ** |
| 121 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 122 | 122 |
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** |
| 123 | 123 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 124 | 124 |
preparations,,** No join mapping for preparations ** |
| inputs/HVAA/Specimen/test.xml.ref | ||
|---|---|---|
| 55 | 55 |
<taxonoccurrence> |
| 56 | 56 |
<aggregateoccurrence> |
| 57 | 57 |
<count>$individualCount</count> |
| 58 |
<notes>$fieldNotes</notes> |
|
| 58 |
<notes> |
|
| 59 |
<_join> |
|
| 60 |
<1>$occurrenceRemarks</1> |
|
| 61 |
<2>$fieldNotes</2> |
|
| 62 |
</_join> |
|
| 63 |
</notes> |
|
| 59 | 64 |
<plantobservation> |
| 60 | 65 |
<authorplantcode> |
| 61 | 66 |
<_alt> |
| inputs/HVAA/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 10 | 10 |
startDayOfYear |
| 11 | 11 |
endDayOfYear |
| 12 | 12 |
verbatimEventDate |
| 13 |
occurrenceRemarks |
|
| 14 | 13 |
dynamicProperties |
| 15 | 14 |
associatedTaxa |
| 16 | 15 |
lifeStage |
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
rights,/location/accessconditions, |
| 10 | 10 |
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
| 11 | 11 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 12 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 12 | 13 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| 13 | 14 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2, |
| 14 | 15 |
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists", |
| ... | ... | |
| 31 | 32 |
countryCode,,** No join mapping for countryCode ** |
| 32 | 33 |
datasetName,,** No join mapping for dataset ** |
| 33 | 34 |
language,,** No join mapping for language ** |
| 34 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 35 | 35 |
rightsHolder,,** No join mapping for dataOwners ** |
| 36 | 36 |
type,,** No join mapping for type ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 14 | 14 |
<taxonoccurrence> |
| 15 | 15 |
<aggregateoccurrence> |
| 16 | 16 |
<count>$individualCount</count> |
| 17 |
<notes>$occurrenceRemarks</notes> |
|
| 17 | 18 |
<plantobservation> |
| 18 | 19 |
<specimenreplicate> |
| 19 | 20 |
<collectioncode_dwc> |
| inputs/MT/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
language |
| 2 |
occurrenceRemarks |
|
| 3 | 2 |
type |
| 4 | 3 |
dataset |
| 5 | 4 |
dataOwners |
| inputs/TRTE/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 17 | 17 |
verbatimSRS |
| 18 | 18 |
associatedReferences |
| 19 | 19 |
associatedMedia |
| 20 |
occurrenceRemarks |
|
| inputs/TRTE/Specimen/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 48 | 48 |
<taxonoccurrence> |
| 49 | 49 |
<aggregateoccurrence> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<specimenreplicate> |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 164 | 164 |
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue", |
| 165 | 165 |
intercept_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m, |
| 166 | 166 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m/_cm_to_m/value, |
| 167 |
organismNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 167 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 168 |
organismNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2, |
|
| 168 | 169 |
individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1, |
| 169 | 170 |
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 170 | 171 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 17 | 17 |
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 18 | 18 |
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 19 | 19 |
darwin:IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 20 |
darwin:Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 20 |
darwin:Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 21 | 21 |
darwin:CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 22 | 22 |
darwin:Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 23 | 23 |
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/NCU/Specimen/VegBIEN.csv | ||
|---|---|---|
| 17 | 17 |
VerbatimLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/1, |
| 18 | 18 |
CityLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/2, |
| 19 | 19 |
CollectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 20 |
Description,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 20 |
Description,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 21 | 21 |
firstCollectorRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,"Actually the collector's number, not remarks" |
| 22 | 22 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 23 | 23 |
CollectionGUID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2, |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value, |
| 22 | 22 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 23 | 23 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 24 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 24 | 25 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 25 | 26 |
reproductiveCondition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 26 | 27 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| ... | ... | |
| 92 | 93 |
language,,** No join mapping for language ** |
| 93 | 94 |
modified,,** No join mapping for modified ** |
| 94 | 95 |
municipality,,** No join mapping for municipality ** |
| 95 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 96 | 96 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 97 | 97 |
rightsHolder,,** No join mapping for dataOwners ** |
| 98 | 98 |
type,,** No join mapping for type ** |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 48 | 48 |
<taxonoccurrence> |
| 49 | 49 |
<aggregateoccurrence> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<reproductivecondition>$reproductiveCondition</reproductivecondition> |
| inputs/ACAD/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 9 | 9 |
type |
| 10 | 10 |
identificationRemarks |
| 11 | 11 |
dataOwners |
| 12 |
occurrenceRemarks |
|
| 13 | 12 |
specimenOwner |
| 14 | 13 |
bibliographicCitation |
| 15 | 14 |
dynamicProperties |
| inputs/WIN/Specimen/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value, |
| 23 | 23 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 24 | 24 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 25 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 25 | 26 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 26 | 27 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 27 | 28 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| ... | ... | |
| 88 | 89 |
language,,** No join mapping for language ** |
| 89 | 90 |
municipality,,** No join mapping for municipality ** |
| 90 | 91 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 91 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 92 | 92 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 93 | 93 |
rightsHolder,,** No join mapping for dataOwners ** |
| 94 | 94 |
type,,** No join mapping for type ** |
| inputs/WIN/Specimen/test.xml.ref | ||
|---|---|---|
| 52 | 52 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 53 | 53 |
<taxonoccurrence> |
| 54 | 54 |
<aggregateoccurrence> |
| 55 |
<notes>$occurrenceRemarks</notes> |
|
| 55 | 56 |
<plantobservation> |
| 56 | 57 |
<authorplantcode>$recordNumber</authorplantcode> |
| 57 | 58 |
<specimenreplicate> |
| inputs/WIN/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 4 | 4 |
verbatimSRS |
| 5 | 5 |
datasetURL |
| 6 | 6 |
bibliographicCitation |
| 7 |
occurrenceRemarks |
|
| 8 | 7 |
type |
| 9 | 8 |
verbatimEventDate |
| 10 | 9 |
dataset |
| inputs/TEX/Specimen/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
ECOLOGICAL INFORMATION,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3, |
| 11 | 11 |
COLL. DATE (EXACT),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/1, |
| 12 | 12 |
COLL. DATE (GENERAL),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/2, |
| 13 |
SPECIMEN NOTES,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 13 |
SPECIMEN NOTES,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 14 | 14 |
COLLECTOR NUMBER,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 15 | 15 |
PHENOLOGY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 16 | 16 |
ACCESSION NO.,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/TEX/Specimen2/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
DET DATE,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 8 | 8 |
EXACT DATE,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/1, |
| 9 | 9 |
GENERAL DATE,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/2, |
| 10 |
PLANT DATA,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 10 |
MISC NOTES,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 11 |
PLANT DATA,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2, |
|
| 11 | 12 |
COLLECTOR NUMBER,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 12 | 13 |
PHENOLOGY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 13 | 14 |
HERBARIUM,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| ... | ... | |
| 65 | 66 |
END DATE,,** No non-empty join mapping for UNUSED ** |
| 66 | 67 |
LATLONG DATUM,,** No join mapping for *LATLONG DATUM ** |
| 67 | 68 |
LATLONG SOURCE,,** No join mapping for *LATLONG SOURCE ** |
| 68 |
MISC NOTES,,** No join mapping for occurrenceRemarks ** |
|
| 69 | 69 |
SUBSPECIES AUTHOR,,** No join mapping for *SUBSPECIES AUTHOR ** |
| 70 | 70 |
UTM,,** No join mapping for *UTM ** |
| 71 | 71 |
VARIETY AUTHOR,,** No join mapping for *VARIETY AUTHOR ** |
| inputs/TEX/Specimen2/test.xml.ref | ||
|---|---|---|
| 33 | 33 |
<2>$GENERAL DATE</2> |
| 34 | 34 |
</_alt> |
| 35 | 35 |
</collectiondate> |
| 36 |
<notes>$PLANT DATA</notes> |
|
| 36 |
<notes> |
|
| 37 |
<_join> |
|
| 38 |
<1>$MISC NOTES</1> |
|
| 39 |
<2>$PLANT DATA</2> |
|
| 40 |
</_join> |
|
| 41 |
</notes> |
|
| 37 | 42 |
<plantobservation> |
| 38 | 43 |
<authorplantcode>$COLLECTOR NUMBER</authorplantcode> |
| 39 | 44 |
<reproductivecondition>$PHENOLOGY</reproductivecondition> |
| inputs/TEX/Specimen2/unmapped_terms.csv | ||
|---|---|---|
| 4 | 4 |
*LATLONG SOURCE |
| 5 | 5 |
*LATLONG DATUM |
| 6 | 6 |
*DATABASED BY |
| 7 |
occurrenceRemarks |
|
| 8 | 7 |
*UTM |
| 9 | 8 |
*DETERMINER INSTITUTION |
| 10 | 9 |
identificationRemarks |
| inputs/BRIT/specimen_flat/VegBIEN.csv | ||
|---|---|---|
| 26 | 26 |
Day_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 27 | 27 |
Month_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 28 | 28 |
Year_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 29 |
Notes_Plant,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 29 |
Notes_Plant,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 30 | 30 |
Collection_Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 31 | 31 |
Phenology_Stage,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 32 | 32 |
Catalog_Number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 60 | 60 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value, |
| 61 | 61 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| 62 | 62 |
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m/_cm_to_m/value,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance." |
| 63 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 63 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 64 | 64 |
Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 65 | 65 |
coll_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,Brad: Map instead as for voucher_string |
| 66 | 66 |
SourceVoucher,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 17 | 17 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 18 | 18 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 19 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 19 |
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2,
|
|
| 20 | 20 |
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 21 | 21 |
Phenology,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition, |
| 22 | 22 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/QFA/Specimen/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 23 | 23 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 24 | 24 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 25 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 25 | 26 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 26 | 27 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 27 | 28 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| ... | ... | |
| 92 | 93 |
institutionID,,** No non-empty join mapping for UNUSED ** |
| 93 | 94 |
language,,** No join mapping for language ** |
| 94 | 95 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 95 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 96 | 96 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 97 | 97 |
preparations,,** No join mapping for preparations ** |
| 98 | 98 |
rightsHolder,,** No join mapping for dataOwners ** |
| inputs/QFA/Specimen/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 48 | 48 |
<taxonoccurrence> |
| 49 | 49 |
<aggregateoccurrence> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<specimenreplicate> |
| inputs/QFA/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 9 | 9 |
nomenclaturalCode |
| 10 | 10 |
bibliographicCitation |
| 11 | 11 |
basisOfRecord |
| 12 |
occurrenceRemarks |
|
| 13 | 12 |
type |
| 14 | 13 |
geodeticDatum |
| 15 | 14 |
verbatimCoordinateSystem |
| inputs/UBC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 24 | 24 |
taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes", |
| 25 | 25 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 26 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 26 | 27 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 27 | 28 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 28 | 29 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| ... | ... | |
| 98 | 99 |
language,,** No join mapping for language ** |
| 99 | 100 |
modified,,** No join mapping for modified ** |
| 100 | 101 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 101 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 102 | 102 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 103 | 103 |
preparations,,** No join mapping for preparations ** |
| 104 | 104 |
previousIdentifications,,** No join mapping for previousIdentifications ** |
| inputs/UBC/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
nomenclaturalCode |
| 2 |
occurrenceRemarks |
|
| 3 | 2 |
dataOwners |
| 4 | 3 |
preparations |
| 5 | 4 |
geodeticDatum |
| inputs/HIBG/Specimen/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 48 | 48 |
<taxonoccurrence> |
| 49 | 49 |
<aggregateoccurrence> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<reproductivecondition>$reproductiveCondition</reproductivecondition> |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 63 | 63 |
conceptual_darwin_2003_1_0_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 64 | 64 |
dwc_curatorial_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 65 | 65 |
dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 66 |
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
|
| 66 |
dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 67 |
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2, |
|
| 67 | 68 |
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1, |
| 68 | 69 |
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec) |
| 69 | 70 |
----- |
| ... | ... | |
| 320 | 321 |
dwc_terms_endDayOfYear,,** No join mapping for endDayOfYear ** |
| 321 | 322 |
dwc_terms_eventTime,,** No join mapping for eventTime ** |
| 322 | 323 |
dwc_terms_month,,** No join mapping for month ** |
| 323 |
dwc_terms_occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 324 | 324 |
dwc_terms_otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** |
| 325 | 325 |
dwc_terms_preparations,,** No join mapping for preparations ** |
| 326 | 326 |
dwc_terms_startDayOfYear,,** No join mapping for startDayOfYear ** |
| inputs/SpeciesLink/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 5 | 5 |
modified |
| 6 | 6 |
basisOfRecord |
| 7 | 7 |
typeStatus |
| 8 |
occurrenceRemarks |
|
| 9 | 8 |
preparations |
| 10 | 9 |
otherCatalogNumbers |
| 11 | 10 |
eventTime |
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 43 | 43 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 44 | 44 |
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 45 | 45 |
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 46 |
comment1,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 47 |
comment2,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2, |
|
| 48 |
comment3,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/3, |
|
| 49 |
comment4,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/4, |
|
| 50 |
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/5/_label[label=""campus""]/value", |
|
| 51 |
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/6/_label[label=""loaned to""]/value", |
|
| 52 |
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/7/_label[label=""in or out""]/value", |
|
| 46 |
comment1,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/1,
|
|
| 47 |
comment2,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/2,
|
|
| 48 |
comment3,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/3,
|
|
| 49 |
comment4,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/4,
|
|
| 50 |
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/5/_label[label=""campus""]/value",
|
|
| 51 |
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/6/_label[label=""loaned to""]/value",
|
|
| 52 |
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/2/_join/7/_label[label=""in or out""]/value",
|
|
| 53 | 53 |
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 54 | 54 |
flower,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?" |
| 55 | 55 |
fruit,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?" |
| inputs/ARIZ/omoccurrences/test.xml.ref | ||
|---|---|---|
| 47 | 47 |
<taxonoccurrence> |
| 48 | 48 |
<aggregateoccurrence> |
| 49 | 49 |
<count>$individualCount</count> |
| 50 |
<notes>$occurrenceRemarks</notes> |
|
| 50 | 51 |
<plantobservation> |
| 51 | 52 |
<authorplantcode>$recordNumber</authorplantcode> |
| 52 | 53 |
<definedvalue fkey="tablerecord_id"> |
| inputs/TRT/Specimen/test.xml.ref | ||
|---|---|---|
| 57 | 57 |
<obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate> |
| 58 | 58 |
<taxonoccurrence> |
| 59 | 59 |
<aggregateoccurrence> |
| 60 |
<notes>$occurrenceRemarks</notes> |
|
| 60 | 61 |
<plantobservation> |
| 61 | 62 |
<authorplantcode>$recordNumber</authorplantcode> |
| 62 | 63 |
<definedvalue fkey="tablerecord_id"> |
| inputs/TRTE/Specimen/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value, |
| 22 | 22 |
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value, |
| 23 | 23 |
dateIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value", |
| 24 |
occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1, |
|
| 24 | 25 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2, |
| 25 | 26 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 26 | 27 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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 |
| ... | ... | |
| 93 | 94 |
modified,,** No join mapping for modified ** |
| 94 | 95 |
municipality,,** No join mapping for municipality ** |
| 95 | 96 |
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** |
| 96 |
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** |
|
| 97 | 97 |
ownerInstitutionCode,,** No join mapping for specimenOwner ** |
| 98 | 98 |
previousIdentifications,,** No join mapping for previousIdentifications ** |
| 99 | 99 |
rightsHolder,,** No join mapping for dataOwners ** |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 164 | 164 |
censusNumber,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue", |
| 165 | 165 |
intercept_m,//aggregateoccurrence/linecover_m, |
| 166 | 166 |
intercept_cm,//aggregateoccurrence/linecover_m/_cm_to_m/value, |
| 167 |
occurrenceRemarks,//aggregateoccurrence/notes, |
|
| 167 | 168 |
organismNotes,//aggregateoccurrence/notes, |
| 168 | 169 |
individualCode,//plantobservation/authorplantcode, |
| 169 | 170 |
collectorNumber,//plantobservation/authorplantcode, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Mapped occurrenceRemarks