Revision 10203
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 31 | 31 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 32 | 32 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 33 | 33 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 34 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 34 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
|
|
| 35 | 35 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 36 | 36 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4, |
| 37 | 37 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
| ... | ... | |
| 39 | 39 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 40 | 40 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 41 | 41 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 42 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 43 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site |
|
| 44 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 45 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site |
|
| 42 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 43 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
|
|
| 44 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
|
|
| 45 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site
|
|
| 46 | 46 |
Description,,** No join mapping for *Description ** |
| 47 | 47 |
ExactDate,,** No join mapping for *ExactDate ** |
| 48 | 48 |
FamilyID,,** No join mapping for *FamilyID ** |
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 17 | 17 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 18 | 18 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 19 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 19 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
|
|
| 20 | 20 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 21 | 21 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4, |
| 22 | 22 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
| ... | ... | |
| 25 | 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 26 | 26 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 27 | 27 |
SpeciesInvID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 28 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 29 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 28 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 29 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
|
|
| 30 | 30 |
Description,,** No join mapping for *Description ** |
| 31 | 31 |
FamilyID,,** No join mapping for *FamilyID ** |
| 32 | 32 |
FieldFamily,,** No join mapping for *FieldFamily ** |
| inputs/CTFS/SubplotObservation/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 14 | 14 |
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 15 | 15 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 16 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 17 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site |
|
| 18 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 19 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site |
|
| 16 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
|
| 17 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site |
|
| 18 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 19 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site |
|
| inputs/CTFS/Subplot/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",Not globally unique; unique only within Site |
| 10 | 10 |
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", |
| 11 | 11 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 12 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 13 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site |
|
| 14 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 15 |
QuadratID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site |
|
| 12 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 13 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
|
|
| 14 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
|
|
| 15 |
QuadratID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",Not globally unique; unique only within Site
|
|
| 16 | 16 |
StartX,/location/sublocationxposition_m, |
| 17 | 17 |
StartY,/location/sublocationyposition_m, |
| 18 | 18 |
DimX,,** No join mapping for *DimX ** |
| inputs/CTFS/PlotObservation/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 20 | 20 |
PlotCensusNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 21 | 21 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 22 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 23 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 22 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 23 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
|
|
| 24 | 24 |
Description,,** No join mapping for *Description ** |
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
| 30 | 30 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
| 31 | 31 |
CountryName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
| 32 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 33 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 32 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
|
| 33 |
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
|
|
| 34 | 34 |
CountryID,,** No join mapping for *CountryID ** |
| 35 | 35 |
ReferenceX,,** No join mapping for *ReferenceX ** Rarely used |
| 36 | 36 |
ReferenceY,,** No join mapping for *ReferenceY ** Rarely used |
Also available in: Unified diff
bugfix: inputs/CTFS/*/VegBIEN.csv: regenerated from map.csv. they may have gotten out of date because they are marked as _no_import, even though they are in import_order.txt.