Revision 11773
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/taxonObservation_/map.csv | ||
|---|---|---|
| 45 | 45 |
revisions,*taxonObservation_--revisions,, |
| 46 | 46 |
taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_dba_src_ID,, |
| 47 | 47 |
taxonInterpretation_accessionCode,*taxonObservation_--taxonInterpretation_accessionCode,, |
| 48 |
*PLANTNAME_ID,*taxonObservation_--PLANTNAME_ID,,
|
|
| 49 |
*plantConcept_reference_ID,*taxonObservation_--plantConcept_reference_ID,,
|
|
| 48 |
*plantConcept_--PLANTNAME_ID,*plantConcept_--PLANTNAME_ID,,
|
|
| 49 |
*plantConcept_--plantConcept_reference_ID,*plantConcept_--plantConcept_reference_ID,,
|
|
| 50 | 50 |
taxonName,taxonName,, |
| 51 | 51 |
scientificName,scientificName,, |
| 52 |
*plantCode,*taxonObservation_--plantCode,,
|
|
| 53 |
*plantDescription,*taxonObservation_--plantDescription,,
|
|
| 54 |
*plantConcept_accessionCode,*taxonObservation_--plantConcept_accessionCode,,
|
|
| 55 |
*plantConcept_dba_src_ID,*taxonObservation_--plantConcept_dba_src_ID,,
|
|
| 56 |
*plantConcept_entry_sppID,*taxonObservation_--plantConcept_entry_sppID,,
|
|
| 57 |
*USDAPlantsCode,*taxonObservation_--USDAPlantsCode,,
|
|
| 58 |
*VascularPlant,*taxonObservation_--VascularPlant,,
|
|
| 52 |
*plantConcept_--plantCode,*plantConcept_--plantCode,,
|
|
| 53 |
*plantConcept_--plantDescription,*plantConcept_--plantDescription,,
|
|
| 54 |
*plantConcept_--plantConcept_accessionCode,*plantConcept_--plantConcept_accessionCode,,
|
|
| 55 |
*plantConcept_--plantConcept_dba_src_ID,*plantConcept_--plantConcept_dba_src_ID,,
|
|
| 56 |
*plantConcept_--plantConcept_entry_sppID,*plantConcept_--plantConcept_entry_sppID,,
|
|
| 57 |
*plantConcept_--USDAPlantsCode,*plantConcept_--USDAPlantsCode,,
|
|
| 58 |
*plantConcept_--VascularPlant,*plantConcept_--VascularPlant,,
|
|
| 59 | 59 |
kingdom,kingdom,, |
| 60 | 60 |
division_main,division_main,,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row" |
| 61 |
*category,*taxonObservation_--category,,
|
|
| 61 |
*plantConcept_--category,*plantConcept_--category,,
|
|
| 62 | 62 |
family,family,, |
| 63 | 63 |
genus_main,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus |
| 64 | 64 |
specificEpithet,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name" |
| ... | ... | |
| 66 | 66 |
infraspecificEpithet,infraspecificEpithet,, |
| 67 | 67 |
infraspecificRank2,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority |
| 68 | 68 |
infraspecificEpithet2,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority |
| 69 |
*hybridX,*taxonObservation_--hybridX,,
|
|
| 69 |
*hybridX,*hybridX,, |
|
| 70 | 70 |
taxonRank,taxonRank,, |
| 71 | 71 |
OMIT#taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form |
| 72 |
*lowestParentName,*taxonObservation_--lowestParentName,,
|
|
| 73 |
*lowestParentConcept_ID,*taxonObservation_--lowestParentConcept_ID,,
|
|
| 74 |
*lowestChildRank,*taxonObservation_--lowestChildRank,,
|
|
| 72 |
*plantConcept_--lowestParentName,*plantConcept_--lowestParentName,,
|
|
| 73 |
*plantConcept_--lowestParentConcept_ID,*plantConcept_--lowestParentConcept_ID,,
|
|
| 74 |
*plantConcept_--lowestChildRank,*plantConcept_--lowestChildRank,,
|
|
| 75 | 75 |
vernacularName,vernacularName,, |
| 76 |
*growthForm_short,*taxonObservation_--growthForm_short,,
|
|
| 77 |
*woody,*taxonObservation_--woody,,
|
|
| 78 |
*exotic,*taxonObservation_--exotic,,
|
|
| 79 |
*usda_code,*taxonObservation_--usda_code,,
|
|
| 80 |
*usda_growthForm,*taxonObservation_--usda_growthForm,,
|
|
| 81 |
*sensitiveSpeciesFuzzPlot,*taxonObservation_--sensitiveSpeciesFuzzPlot,,
|
|
| 76 |
*plantConcept_--growthForm_short,*plantConcept_--growthForm_short,,
|
|
| 77 |
*plantConcept_--woody,*plantConcept_--woody,,
|
|
| 78 |
*plantConcept_--exotic,*plantConcept_--exotic,,
|
|
| 79 |
*plantConcept_--usda_code,*plantConcept_--usda_code,,
|
|
| 80 |
*plantConcept_--usda_growthForm,*plantConcept_--usda_growthForm,,
|
|
| 81 |
*plantConcept_--sensitiveSpeciesFuzzPlot,*plantConcept_--sensitiveSpeciesFuzzPlot,,
|
|
| 82 | 82 |
DUPLICATE#of:denorm_kingdom#Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,, |
| 83 |
*Subkingdom,*taxonObservation_--Subkingdom,,
|
|
| 83 |
*Subkingdom,*Subkingdom,, |
|
| 84 | 84 |
division_normalized,division_normalized,, |
| 85 | 85 |
class,class,, |
| 86 |
*Subclass,*taxonObservation_--Subclass,,
|
|
| 86 |
*Subclass,*Subclass,, |
|
| 87 | 87 |
order,order,, |
| 88 |
*composite family,*taxonObservation_--composite family,,
|
|
| 88 |
*composite family,*composite family,, |
|
| 89 | 89 |
DUPLICATE#of:denorm_family#family,DUPLICATE#of:denorm_family#family,, |
| 90 |
*tribe,*taxonObservation_--tribe,,
|
|
| 91 |
*composite genus,*taxonObservation_--composite genus,,
|
|
| 90 |
*tribe,*tribe,, |
|
| 91 |
*composite genus,*composite genus,, |
|
| 92 | 92 |
genus_normalized,genus_normalized,,"unlike VegBank, does *not* include genus author" |
| 93 | 93 |
subgenus,subgenus,, |
| 94 |
*section,*taxonObservation_--section,,
|
|
| 95 |
*composite species,*taxonObservation_--composite species,,
|
|
| 94 |
*section,*section,, |
|
| 95 |
*composite species,*composite species,, |
|
| 96 | 96 |
speciesBinomial,speciesBinomial,,full taxonomic name at that rank |
| 97 | 97 |
EQUIV#to:species#subspecies,EQUIV#to:species#subspecies,,full taxonomic name at that rank |
| 98 | 98 |
EQUIV#to:species#composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank |
| inputs/CVS/taxonObservation_/new_terms.csv | ||
|---|---|---|
| 32 | 32 |
revisions,*taxonObservation_--revisions,, |
| 33 | 33 |
taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_dba_src_ID,, |
| 34 | 34 |
taxonInterpretation_accessionCode,*taxonObservation_--taxonInterpretation_accessionCode,, |
| 35 |
*PLANTNAME_ID,*taxonObservation_--PLANTNAME_ID,, |
|
| 36 |
*plantConcept_reference_ID,*taxonObservation_--plantConcept_reference_ID,, |
|
| 37 |
*plantCode,*taxonObservation_--plantCode,, |
|
| 38 |
*plantDescription,*taxonObservation_--plantDescription,, |
|
| 39 |
*plantConcept_accessionCode,*taxonObservation_--plantConcept_accessionCode,, |
|
| 40 |
*plantConcept_dba_src_ID,*taxonObservation_--plantConcept_dba_src_ID,, |
|
| 41 |
*plantConcept_entry_sppID,*taxonObservation_--plantConcept_entry_sppID,, |
|
| 42 |
*USDAPlantsCode,*taxonObservation_--USDAPlantsCode,, |
|
| 43 |
*VascularPlant,*taxonObservation_--VascularPlant,, |
|
| 44 |
*category,*taxonObservation_--category,, |
|
| 45 |
*hybridX,*taxonObservation_--hybridX,, |
|
| 46 |
*lowestParentName,*taxonObservation_--lowestParentName,, |
|
| 47 |
*lowestParentConcept_ID,*taxonObservation_--lowestParentConcept_ID,, |
|
| 48 |
*lowestChildRank,*taxonObservation_--lowestChildRank,, |
|
| 49 |
*growthForm_short,*taxonObservation_--growthForm_short,, |
|
| 50 |
*woody,*taxonObservation_--woody,, |
|
| 51 |
*exotic,*taxonObservation_--exotic,, |
|
| 52 |
*usda_code,*taxonObservation_--usda_code,, |
|
| 53 |
*usda_growthForm,*taxonObservation_--usda_growthForm,, |
|
| 54 |
*sensitiveSpeciesFuzzPlot,*taxonObservation_--sensitiveSpeciesFuzzPlot,, |
|
| 55 |
*Subkingdom,*taxonObservation_--Subkingdom,, |
|
| 56 |
*Subclass,*taxonObservation_--Subclass,, |
|
| 57 |
*composite family,*taxonObservation_--composite family,, |
|
| 58 |
*tribe,*taxonObservation_--tribe,, |
|
| 59 |
*composite genus,*taxonObservation_--composite genus,, |
|
| 60 |
*section,*taxonObservation_--section,, |
|
| 61 |
*composite species,*taxonObservation_--composite species,, |
|
| 62 | 35 |
division,*taxonObservation_--division,, |
| inputs/CVS/taxonObservation_/unmapped_terms.csv | ||
|---|---|---|
| 31 | 31 |
*taxonObservation_--revisions |
| 32 | 32 |
*taxonObservation_--taxonInterpretation_dba_src_ID |
| 33 | 33 |
*taxonObservation_--taxonInterpretation_accessionCode |
| 34 |
*taxonObservation_--PLANTNAME_ID
|
|
| 35 |
*taxonObservation_--plantConcept_reference_ID
|
|
| 36 |
*taxonObservation_--plantCode
|
|
| 37 |
*taxonObservation_--plantDescription
|
|
| 38 |
*taxonObservation_--plantConcept_accessionCode
|
|
| 39 |
*taxonObservation_--plantConcept_dba_src_ID
|
|
| 40 |
*taxonObservation_--plantConcept_entry_sppID
|
|
| 41 |
*taxonObservation_--USDAPlantsCode
|
|
| 42 |
*taxonObservation_--VascularPlant
|
|
| 34 |
*plantConcept_--PLANTNAME_ID
|
|
| 35 |
*plantConcept_--plantConcept_reference_ID
|
|
| 36 |
*plantConcept_--plantCode
|
|
| 37 |
*plantConcept_--plantDescription
|
|
| 38 |
*plantConcept_--plantConcept_accessionCode
|
|
| 39 |
*plantConcept_--plantConcept_dba_src_ID
|
|
| 40 |
*plantConcept_--plantConcept_entry_sppID
|
|
| 41 |
*plantConcept_--USDAPlantsCode
|
|
| 42 |
*plantConcept_--VascularPlant
|
|
| 43 | 43 |
division_main |
| 44 |
*taxonObservation_--category
|
|
| 44 |
*plantConcept_--category
|
|
| 45 | 45 |
genus_main |
| 46 | 46 |
infraspecificRank |
| 47 | 47 |
infraspecificRank2 |
| 48 | 48 |
infraspecificEpithet2 |
| 49 |
*taxonObservation_--hybridX
|
|
| 50 |
*taxonObservation_--lowestParentName
|
|
| 51 |
*taxonObservation_--lowestParentConcept_ID
|
|
| 52 |
*taxonObservation_--lowestChildRank
|
|
| 49 |
*hybridX |
|
| 50 |
*plantConcept_--lowestParentName
|
|
| 51 |
*plantConcept_--lowestParentConcept_ID
|
|
| 52 |
*plantConcept_--lowestChildRank
|
|
| 53 | 53 |
vernacularName |
| 54 |
*taxonObservation_--growthForm_short
|
|
| 55 |
*taxonObservation_--woody
|
|
| 56 |
*taxonObservation_--exotic
|
|
| 57 |
*taxonObservation_--usda_code
|
|
| 58 |
*taxonObservation_--usda_growthForm
|
|
| 59 |
*taxonObservation_--sensitiveSpeciesFuzzPlot
|
|
| 60 |
*taxonObservation_--Subkingdom
|
|
| 54 |
*plantConcept_--growthForm_short
|
|
| 55 |
*plantConcept_--woody
|
|
| 56 |
*plantConcept_--exotic
|
|
| 57 |
*plantConcept_--usda_code
|
|
| 58 |
*plantConcept_--usda_growthForm
|
|
| 59 |
*plantConcept_--sensitiveSpeciesFuzzPlot
|
|
| 60 |
*Subkingdom |
|
| 61 | 61 |
division_normalized |
| 62 |
*taxonObservation_--Subclass
|
|
| 63 |
*taxonObservation_--composite family
|
|
| 64 |
*taxonObservation_--tribe
|
|
| 65 |
*taxonObservation_--composite genus
|
|
| 62 |
*Subclass |
|
| 63 |
*composite family |
|
| 64 |
*tribe |
|
| 65 |
*composite genus |
|
| 66 | 66 |
genus_normalized |
| 67 | 67 |
subgenus |
| 68 |
*taxonObservation_--section
|
|
| 69 |
*taxonObservation_--composite species
|
|
| 68 |
*section |
|
| 69 |
*composite species |
|
| 70 | 70 |
speciesBinomial |
| 71 | 71 |
*taxonObservation_--division |
Also available in: Unified diff
fix: inputs/CVS/taxonObservation_/map.csv: plantConcept_ columns: synced input and output column names to their names in plantConcept_