Revision 6313
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1", |
| 4 | 4 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1", |
| 5 | 5 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2", |
| 6 |
id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 6 | 7 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 7 | 8 |
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 |
| 8 | 9 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2, |
| 9 | 10 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/name, |
| 10 | 11 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 12 |
id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 | 13 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value", |
| 12 | 14 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 13 | 15 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot Number,/location/authorlocationcode, |
| 7 |
Id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 7 | 8 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 8 | 9 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 9 | 10 |
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| ... | ... | |
| 22 | 23 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 23 | 24 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 24 | 25 |
Names of Collectors,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 26 |
Id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 25 | 27 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 26 | 28 |
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", |
| 27 | 29 |
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", |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot Number,/location/authorlocationcode, |
| 7 |
Id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 7 | 8 |
Site Name,/location/locationevent/*_id/project/projectname, |
| 8 | 9 |
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 9 | 10 |
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| ... | ... | |
| 22 | 23 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 23 | 24 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 24 | 25 |
Names of Collectors,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 26 |
Id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 25 | 27 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 26 | 28 |
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", |
| 27 | 29 |
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", |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2", |
| 7 | 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 | 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", |
|
| 9 | 11 |
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| 10 | 12 |
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_alt/2/_dateRangeEnd/value", |
| 11 | 13 |
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value", |
| ... | ... | |
| 20 | 22 |
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 21 | 23 |
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2", |
| 22 | 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", |
|
| 23 | 27 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 24 | 28 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 25 | 29 |
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", |
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 5 | 5 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 6 | 6 |
QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site |
| 7 |
MeasureID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 7 | 8 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site |
| 8 | 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 9 | 10 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| ... | ... | |
| 22 | 23 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 23 | 24 |
StemTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 24 | 25 |
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 26 |
MeasureID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 25 | 27 |
MeasureID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 26 | 28 |
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", |
| 27 | 29 |
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", |
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
| 3 | 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 4 | 4 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 5 |
SpeciesInvID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 5 | 6 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 6 | 7 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| 7 | 8 |
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", |
| 8 | 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 9 | 10 |
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 10 | 11 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 12 |
SpeciesInvID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 | 13 |
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 12 | 14 |
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", |
| 13 | 15 |
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", |
| inputs/SALVIAS/stems/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
PlotObsID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 2 | 3 |
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
| 3 | 4 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount, |
| 4 | 5 |
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m, |
| ... | ... | |
| 15 | 16 |
stem_tag1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag/_alt/2,"The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
| 16 | 17 |
stem_tag2,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/1","The second tag supercedes the first. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
| 17 | 18 |
stem_tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2","The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
| 19 |
PlotObsID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 18 | 20 |
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 19 | 21 |
origrecord_id_stems,,** No join mapping for *origrecord_id_stems ** |
| 20 | 22 |
plotobs_id_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
PlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 12 | 12 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 13 | 13 |
Line,/location/authorlocationcode, |
| 14 |
PlotObsID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
|
| 14 | 15 |
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 15 | 16 |
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 16 | 17 |
----- |
| ... | ... | |
| 84 | 85 |
coll_firstname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,Brad: See comment above |
| 85 | 86 |
coll_lastname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 86 | 87 |
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
|
| 88 |
PlotObsID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
|
| 87 | 89 |
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 88 | 90 |
det_by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 89 | 91 |
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", |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| 4 | 4 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 |
ID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 5 | 6 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 6 | 7 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 7 | 8 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 12 | 13 |
Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 13 | 14 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1, |
| 14 | 15 |
Addcoll,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/2, |
| 16 |
ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 15 | 17 |
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 16 | 18 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 17 | 19 |
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", |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
conceptual_darwin_2003_1_0_MinimumElevation,/location/elevation_m/_alt/2/_avg/min, |
| 20 | 20 |
dwc_dwcore_MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 21 | 21 |
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min, |
| 22 |
dwc_dwcore_GlobalUniqueIdentifier,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 22 | 23 |
conceptual_darwin_2003_1_0_DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 23 | 24 |
conceptual_darwin_2003_1_0_MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 24 | 25 |
conceptual_darwin_2003_1_0_YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 82 | 83 |
conceptual_darwin_2003_1_0_Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 83 | 84 |
dwc_dwcore_Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 84 | 85 |
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 86 |
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 85 | 87 |
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 86 | 88 |
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 87 | 89 |
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 8 | 8 |
plotAreaHa,/location/area_m2/_ha_to_m2/value, |
| 9 | 9 |
elevation_m,/location/elevation_m/_alt/1, |
| 10 |
collectionNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 |
isCultivated,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else", |
|
| 10 | 12 |
plotMethod,/location/locationevent/*_id/method/name, |
| 11 | 13 |
plotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 12 | 14 |
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", |
| ... | ... | |
| 19 | 21 |
collectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 20 | 22 |
taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2", |
| 21 | 23 |
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 22 |
isCultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
|
| 24 |
collectionNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 25 |
isCultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then", |
|
| 23 | 26 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 24 | 27 |
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", |
| 25 | 28 |
taxon,"/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", |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
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", |
| 7 | 7 |
MaximumElevation,/location/elevation_m/_alt/2/_avg/max, |
| 8 | 8 |
MinimumElevation,/location/elevation_m/_alt/2/_avg/min/_nullIf:[null=.]/value, |
| 9 |
FieldNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",Usage inconsistent with DwC definition |
|
| 10 |
UniqueNYInternalRecordNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 9 | 11 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 10 | 12 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 11 | 13 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 21 | 23 |
FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",Usage inconsistent with DwC definition |
| 22 | 24 |
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 23 | 25 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 26 |
FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Usage inconsistent with DwC definition |
|
| 27 |
UniqueNYInternalRecordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 24 | 28 |
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 25 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 26 | 30 |
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", |
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
Inventory name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 9 | 9 |
Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 10 | 10 |
Number of subplot,/location/authorlocationcode, |
| 11 |
Tree number,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 | 12 |
Expedition,/location/locationevent/*_id/project/projectname, |
| 12 | 13 |
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 13 | 14 |
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2", |
| ... | ... | |
| 32 | 33 |
Species and morphotypes,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3","Contains less than ""Specie+autor""" |
| 33 | 34 |
Index collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 34 | 35 |
Habit,/location/locationevent/taxonoccurrence/growthform, |
| 36 |
Tree number,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 35 | 37 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 36 | 38 |
Family (revised),"/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", |
| 37 | 39 |
Specie+autor,"/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", |
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
HAVING count(*) > 1 |
| 10 | 10 |
-----" |
| 11 | 11 |
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1", |
| 12 |
accession,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists","Globally unique, although occasionally duplicated. [1] |
|
| 13 |
|
|
| 14 |
[1] Using the following query: |
|
| 15 |
----- |
|
| 16 |
SELECT herbarium, accession, count(*) |
|
| 17 |
FROM ""UNCC"".""Specimen"" |
|
| 18 |
GROUP BY herbarium, accession |
|
| 19 |
HAVING count(*) > 1 |
|
| 20 |
-----" |
|
| 21 |
cultivated,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else",Ignore other values |
|
| 12 | 22 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 13 | 23 |
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 14 | 24 |
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 36 | 46 |
collector1,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/2, |
| 37 | 47 |
collector2,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/3, |
| 38 | 48 |
collector3,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/4, |
| 39 |
cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,Ignore other values |
|
| 49 |
accession,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Globally unique, although occasionally duplicated. [1] |
|
| 50 |
|
|
| 51 |
[1] Using the following query: |
|
| 52 |
----- |
|
| 53 |
SELECT herbarium, accession, count(*) |
|
| 54 |
FROM ""UNCC"".""Specimen"" |
|
| 55 |
GROUP BY herbarium, accession |
|
| 56 |
HAVING count(*) > 1 |
|
| 57 |
-----" |
|
| 58 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then",Ignore other values |
|
| 40 | 59 |
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,"Globally unique, although occasionally duplicated. [1] |
| 41 | 60 |
|
| 42 | 61 |
[1] Using the following query: |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
plot_code,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 12 | 12 |
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 13 | 13 |
subplot,/location/authorlocationcode, |
| 14 |
OBSERVATION_ID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
|
| 15 |
individual_code,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists","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." |
|
| 14 | 16 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists", |
| 15 | 17 |
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows: |
| 16 | 18 |
----- |
| ... | ... | |
| 91 | 93 |
coll_firstname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,Brad: See comment above |
| 92 | 94 |
coll_lastname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 93 | 95 |
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
|
| 96 |
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
|
| 97 |
individual_code,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","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." |
|
| 94 | 98 |
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 95 | 99 |
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", |
| 96 | 100 |
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", |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
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/_alt/2",Don't overwrite CatalogNumberNumeric |
| 9 | 9 |
MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,"Contains some verbatim values, including ranges and units" |
| 10 | 10 |
MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,"Contains some verbatim values, including ranges and units" |
| 11 |
CollectorNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 12 |
GlobalUniqueIdentifier,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 11 | 13 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/0, |
| 12 | 14 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 13 | 15 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 25 | 27 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",Contains the binomial in addition to the authority |
| 26 | 28 |
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 27 | 29 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 30 |
CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 31 |
GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 28 | 32 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 29 | 33 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 30 | 34 |
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", |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1", |
| 5 | 5 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 6 | 6 |
Elevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value", |
| 7 |
Accession Number,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 8 |
Cultivated?,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else", |
|
| 7 | 9 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 8 | 10 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 9 | 11 |
SeriesName,/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 |
| 10 | 12 |
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 11 | 13 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 12 |
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
|
| 14 |
Accession Number,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 15 |
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then", |
|
| 13 | 16 |
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 14 | 17 |
Full Taxon Name,"/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/1", |
| 15 | 18 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1, |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 5 | 5 |
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", |
| 6 | 6 |
MaximumElevation,/location/elevation_m/_alt/2/_avg/max, |
| 7 | 7 |
MinimumElevation,/location/elevation_m/_alt/2/_avg/min, |
| 8 |
CollectorNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 8 | 9 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 9 | 10 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 10 | 11 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 18 | 19 |
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 19 | 20 |
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 20 | 21 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
| 22 |
CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 21 | 23 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname, |
| 22 | 24 |
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", |
| 23 | 25 |
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/2/_join_words/1/_alt/1", |
| inputs/VegBank/stemcount/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
stemcount_id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 2 | 3 |
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
| 3 | 4 |
stemcount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount, |
| 4 | 5 |
stemdiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)" |
| 5 | 6 |
stemheight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)" |
| 6 | 7 |
taxonimportance_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode, |
| 8 |
stemcount_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 7 | 9 |
taxonimportance_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists", |
| 8 | 10 |
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 9 | 11 |
emb_stemcount,,** No join mapping for *emb_stemcount ** |
| inputs/VegBank/stemlocation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
stemcount_id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 2 | 3 |
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
| 3 | 4 |
stemcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode, |
| 4 | 5 |
stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode, |
| 5 | 6 |
stemxposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)" |
| 6 | 7 |
stemyposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)" |
| 8 |
stemcount_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 7 | 9 |
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 8 | 10 |
emb_stemlocation,,** No join mapping for *emb_stemlocation ** |
| 9 | 11 |
stemhealth,,** No join mapping for *stemhealth ** |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists", |
| 3 | 3 |
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 4 |
taxonobservation_id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 4 | 5 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 5 | 6 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists", |
| 6 | 7 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode", |
| ... | ... | |
| 11 | 12 |
authorplantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1", |
| 12 | 13 |
givenname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1, |
| 13 | 14 |
surname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2, |
| 15 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 14 | 16 |
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 15 | 17 |
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", |
| 16 | 18 |
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", |
| inputs/VegBank/taxonimportance/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
VegBank,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 |
taxonobservation_id,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
|
| 3 |
|
|
| 4 |
[1] The following query returns rows: |
|
| 5 |
----- |
|
| 6 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
| 7 |
FROM ""VegBank"".taxonimportance |
|
| 8 |
GROUP BY taxonobservation_id |
|
| 9 |
HAVING count(distinct taxonimportance_id) > 1 |
|
| 10 |
-----" |
|
| 2 | 11 |
cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value, |
| 3 | 12 |
taxonimportance_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode, |
| 13 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
|
| 14 |
|
|
| 15 |
[1] The following query returns rows: |
|
| 16 |
----- |
|
| 17 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
| 18 |
FROM ""VegBank"".taxonimportance |
|
| 19 |
GROUP BY taxonobservation_id |
|
| 20 |
HAVING count(distinct taxonimportance_id) > 1 |
|
| 21 |
-----" |
|
| 4 | 22 |
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,"Note that taxonimportance is not 1:1 with taxonobservation [1]. |
| 5 | 23 |
|
| 6 | 24 |
[1] The following query returns rows: |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/min/_rangeStart/value, |
| 29 | 29 |
verbatimElevation_m,/location/elevationrange_m/_range/from/_rangeStart/value, |
| 30 | 30 |
verbatimElevation_m,/location/elevationrange_m/_range/to/_rangeEnd/value, |
| 31 |
individualID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 32 |
occurrenceID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 33 |
recordNumber,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 34 |
taxonOccurrenceID,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 35 |
cultivated,"/location/iscultivated/_if[@name=""if TaxonOccurrence""]/else", |
|
| 31 | 36 |
landform,/location/landform, |
| 32 | 37 |
samplingProtocol,/location/locationevent/*_id/method/name, |
| 33 | 38 |
observationMeasure,/location/locationevent/*_id/method/observationmeasure, |
| ... | ... | |
| 130 | 135 |
recordedBy.surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2, |
| 131 | 136 |
growthForm,/location/locationevent/taxonoccurrence/growthform, |
| 132 | 137 |
verbatimGrowthForm,/location/locationevent/taxonoccurrence/growthform, |
| 133 |
cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
|
| 138 |
individualID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 139 |
occurrenceID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 140 |
recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 141 |
taxonOccurrenceID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 142 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then", |
|
| 134 | 143 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value", |
| 135 | 144 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 136 | 145 |
taxonOccurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
verbatimElevation_m,//location/elevation_m, |
| 29 | 29 |
verbatimElevation_m,//location/elevationrange_m, |
| 30 | 30 |
verbatimElevation_m,//location/elevationrange_m, |
| 31 |
individualID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 32 |
occurrenceID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 33 |
recordNumber,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 34 |
taxonOccurrenceID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 35 |
cultivated,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/else", |
|
| 31 | 36 |
landform,//location/landform, |
| 32 | 37 |
samplingProtocol,//method/name, |
| 33 | 38 |
observationMeasure,//method/observationmeasure, |
| ... | ... | |
| 130 | 135 |
recordedBy.surName,//party/fullname, |
| 131 | 136 |
growthForm,//taxonoccurrence/growthform, |
| 132 | 137 |
verbatimGrowthForm,//taxonoccurrence/growthform, |
| 133 |
cultivated,//taxonoccurrence/iscultivated, |
|
| 138 |
individualID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 139 |
occurrenceID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 140 |
recordNumber,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 141 |
taxonOccurrenceID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
|
| 142 |
cultivated,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/then", |
|
| 134 | 143 |
establishmentMeans,//taxonoccurrence/iscultivated, |
| 135 | 144 |
establishmentMeans,//taxonoccurrence/isnative, |
| 136 | 145 |
taxonOccurrenceID,//taxonoccurrence/sourceaccessioncode, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Remapped cultivated to location when a TaxonOccurrence is not provided, indicating that the record is a plot