Revision 4368
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/CTFS/import_order.txt | ||
|---|---|---|
| 2 | 2 |
Subplot |
| 3 | 3 |
PlotObservation |
| 4 | 4 |
SubplotObservation |
| 5 |
TaxonOccurrence |
|
| 5 | 6 |
StemObservation |
| inputs/CTFS/TaxonOccurrence/src.csv | ||
|---|---|---|
| 1 |
CTFS[Veg+],Veg+,Comments |
|
| 2 |
FamilyID,, |
|
| 3 |
GenusID,, |
|
| 4 |
SpeciesID,, |
|
| 5 |
SubSpeciesID,, |
|
| 6 |
SpeciesInvID,, |
|
| 7 |
CensusID,, |
|
| 8 |
PlotID,, |
|
| 9 |
SubSpeciesCurrentTaxonFlag,, |
|
| 10 |
SubSpeciesObsoleteTaxonFlag,, |
|
| 11 |
SubSpeciesName,, |
|
| 12 |
SubSpeciesMnemonic,, |
|
| 13 |
SubSpeciesAuthority,, |
|
| 14 |
InfraSpecificLevel,, |
|
| 15 |
SpeciesCurrentTaxonFlag,, |
|
| 16 |
SpeciesObsoleteTaxonFlag,, |
|
| 17 |
SpeciesReferenceID,, |
|
| 18 |
SpeciesName,, |
|
| 19 |
SpeciesMnemonic,, |
|
| 20 |
SpeciesAuthority,, |
|
| 21 |
IDLevel,, |
|
| 22 |
FieldFamily,, |
|
| 23 |
Description,, |
|
| 24 |
Genus,, |
|
| 25 |
GenusReferenceID,, |
|
| 26 |
GenusAuthority,, |
|
| 27 |
Family,, |
|
| 28 |
ReferenceID,, |
|
| 29 |
row_num,, |
|
| inputs/CTFS/TaxonOccurrence/header.csv | ||
|---|---|---|
| 1 |
FamilyID,GenusID,SpeciesID,SubSpeciesID,SpeciesInvID,CensusID,PlotID,SubSpeciesCurrentTaxonFlag,SubSpeciesObsoleteTaxonFlag,SubSpeciesName,SubSpeciesMnemonic,SubSpeciesAuthority,InfraSpecificLevel,SpeciesCurrentTaxonFlag,SpeciesObsoleteTaxonFlag,SpeciesReferenceID,SpeciesName,SpeciesMnemonic,SpeciesAuthority,IDLevel,FieldFamily,Description,Genus,GenusReferenceID,GenusAuthority,Family,ReferenceID,row_num |
|
| inputs/CTFS/TaxonOccurrence/map.csv | ||
|---|---|---|
| 1 |
CTFS[Veg+],Veg+,Comments |
|
| 2 |
FamilyID,, |
|
| 3 |
GenusID,, |
|
| 4 |
SpeciesID,, |
|
| 5 |
SubSpeciesID,, |
|
| 6 |
SpeciesInvID,, |
|
| 7 |
SubSpeciesCurrentTaxonFlag,, |
|
| 8 |
SubSpeciesObsoleteTaxonFlag,, |
|
| 9 |
SubSpeciesMnemonic,, |
|
| 10 |
SubSpeciesAuthority,, |
|
| 11 |
InfraSpecificLevel,, |
|
| 12 |
SpeciesCurrentTaxonFlag,, |
|
| 13 |
SpeciesObsoleteTaxonFlag,, |
|
| 14 |
SpeciesReferenceID,, |
|
| 15 |
SpeciesMnemonic,, |
|
| 16 |
SpeciesAuthority,, |
|
| 17 |
IDLevel,, |
|
| 18 |
FieldFamily,, |
|
| 19 |
Description,, |
|
| 20 |
GenusReferenceID,, |
|
| 21 |
GenusAuthority,, |
|
| 22 |
ReferenceID,, |
|
| 23 |
row_num,, |
|
| inputs/CTFS/TaxonOccurrence/map.full.csv | ||
|---|---|---|
| 1 |
CTFS[Veg+],Veg+,Comments |
|
| 2 |
CensusID,CensusID |
|
| 3 |
Family,Family |
|
| 4 |
Genus,Genus |
|
| 5 |
PlotID,PlotID |
|
| 6 |
SpeciesName,SpeciesName |
|
| 7 |
SubSpeciesName,SubSpeciesName |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 1 |
CTFS[Veg+],VegBIEN:,Comments |
|
| 2 |
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
|
| 3 |
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode", |
|
| 4 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
|
| 5 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
|
| 6 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 7 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
|
| 8 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
|
| 9 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 10 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| inputs/CTFS/TaxonOccurrence/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<location id="-1"> |
|
| 4 |
<sourceaccessioncode>$PlotID</sourceaccessioncode> |
|
| 5 |
<locationevent> |
|
| 6 |
<sourceaccessioncode>$CensusID</sourceaccessioncode> |
|
| 7 |
<taxonoccurrence> |
|
| 8 |
<taxondetermination> |
|
| 9 |
<plantconcept_id> |
|
| 10 |
<plantconcept> |
|
| 11 |
<plantname_id> |
|
| 12 |
<_simplifyPath> |
|
| 13 |
<next>parent_id</next> |
|
| 14 |
<path> |
|
| 15 |
<plantname> |
|
| 16 |
<rank>binomial</rank> |
|
| 17 |
<parent_id> |
|
| 18 |
<plantname> |
|
| 19 |
<rank>authority</rank> |
|
| 20 |
<parent_id> |
|
| 21 |
<plantname> |
|
| 22 |
<rank>subspecies</rank> |
|
| 23 |
<plantname>$SubSpeciesName</plantname> |
|
| 24 |
<parent_id> |
|
| 25 |
<plantname> |
|
| 26 |
<rank>species</rank> |
|
| 27 |
<plantname>$SpeciesName</plantname> |
|
| 28 |
<parent_id> |
|
| 29 |
<plantname> |
|
| 30 |
<rank>genus</rank> |
|
| 31 |
<plantname>$Genus</plantname> |
|
| 32 |
<parent_id> |
|
| 33 |
<plantname> |
|
| 34 |
<rank>family</rank> |
|
| 35 |
<plantname>$Family</plantname> |
|
| 36 |
</plantname> |
|
| 37 |
</parent_id> |
|
| 38 |
</plantname> |
|
| 39 |
</parent_id> |
|
| 40 |
</plantname> |
|
| 41 |
</parent_id> |
|
| 42 |
</plantname> |
|
| 43 |
</parent_id> |
|
| 44 |
</plantname> |
|
| 45 |
</parent_id> |
|
| 46 |
</plantname> |
|
| 47 |
</path> |
|
| 48 |
</_simplifyPath> |
|
| 49 |
</plantname_id> |
|
| 50 |
</plantconcept> |
|
| 51 |
</plantconcept_id> |
|
| 52 |
</taxondetermination> |
|
| 53 |
</taxonoccurrence> |
|
| 54 |
</locationevent> |
|
| 55 |
</location> |
|
| 56 |
</VegBIEN> |
|
| 57 |
Inserted 14 new rows into database |
|
Also available in: Unified diff
inputs/CTFS/: Added TaxonOccurrence/ and its joined tables