Revision 11752
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/taxonObservation_/header.csv | ||
|---|---|---|
| 1 |
PLANTCONCEPT_ID,TAXONOBSERVATION_ID,OBSERVATION_ID,authorPlantName,taxonObservation_reference_ID,currentTaxonInterpPlantConcept_ID,taxonInferenceArea,taxonObservation_accessionCode,taxonObservation_dba_src_ID,cust_cvs_corner1Presence,cust_cvs_corner2Presence,cust_cvs_corner3Presence,cust_cvs_corner4Presence,cust_cvs_corner5Presence,entry_herbLineID,entry_treeLineID,taxonObservation_entry_sppID,entry_unknownSp,entry_sortOrder,cust_cvs_collectionFlag,taxonObservationNotes,temp_taxonUpToDate,TAXONINTERPRETATION_ID,stemLocation_ID,interpretationDate,taxonInterpretation_PLANTNAME_ID,taxonInterpretation_PARTY_ID,ROLE_ID,interpretationType,reference_ID,originalInterpretation,currentInterpretation,taxonFit,taxonConfidence,collector_ID,collectionNumber,collectionDate,museum_ID,museumAccessionNumber,groupType,notes,notesPublic,notesMgt,revisions,taxonInterpretation_dba_src_ID,taxonInterpretation_accessionCode,PLANTNAME_ID,plantConcept_reference_ID,plantname,plantNameWithAuthority,plantCode,plantDescription,plantConcept_accessionCode,plantConcept_dba_src_ID,plantConcept_entry_sppID,USDAPlantsCode,VascularPlant,denorm_kingdom,denorm_division,denorm_category,denorm_family,denorm_genus,denorm_species,denorm_triAbbr,denorm_triName,denorm_quadAbbr,denorm_quadName,denorm_hybridX,taxonLevel,taxonRank,lowestParentName,lowestParentConcept_ID,lowestChildRank,commonName,growthForm_short,woody,exotic,usda_code,usda_growthForm,sensitiveSpeciesFuzzPlot,Kingdom,Subkingdom,Division,Class,Subclass,Order,composite family,family,tribe,composite genus,*genus,subgenus,section,composite species,species,subspecies,composite variety,variety,division,genus |
|
| 1 |
PLANTCONCEPT_ID,TAXONOBSERVATION_ID,OBSERVATION_ID,authorPlantName,taxonObservation_reference_ID,currentTaxonInterpPlantConcept_ID,taxonInferenceArea,taxonObservation_accessionCode,taxonObservation_dba_src_ID,cust_cvs_corner1Presence,cust_cvs_corner2Presence,cust_cvs_corner3Presence,cust_cvs_corner4Presence,cust_cvs_corner5Presence,entry_herbLineID,entry_treeLineID,taxonObservation_entry_sppID,entry_unknownSp,entry_sortOrder,cust_cvs_collectionFlag,taxonObservationNotes,temp_taxonUpToDate,TAXONINTERPRETATION_ID,stemLocation_ID,interpretationDate,taxonInterpretation_PLANTNAME_ID,taxonInterpretation_PARTY_ID,ROLE_ID,interpretationType,reference_ID,originalInterpretation,currentInterpretation,taxonFit,taxonConfidence,collector_ID,collectionNumber,collectionDate,museum_ID,museumAccessionNumber,groupType,notes,notesPublic,notesMgt,revisions,taxonInterpretation_dba_src_ID,taxonInterpretation_accessionCode,*PLANTNAME_ID,*plantConcept_reference_ID,taxonName,scientificName,*plantCode,*plantDescription,*plantConcept_accessionCode,*plantConcept_dba_src_ID,*plantConcept_entry_sppID,*USDAPlantsCode,*VascularPlant,kingdom,division_main,*category,family,genus_main,specificEpithet,infraspecificRank,infraspecificEpithet,infraspecificRank2,infraspecificEpithet2,*hybridX,taxonRank,OMIT#taxonRank,*lowestParentName,*lowestParentConcept_ID,*lowestChildRank,vernacularName,*growthForm_short,*woody,*exotic,*usda_code,*usda_growthForm,*sensitiveSpeciesFuzzPlot,DUPLICATE#of:denorm_kingdom#Kingdom,*Subkingdom,division_normalized,class,*Subclass,order,*composite family,DUPLICATE#of:denorm_family#family,*tribe,*composite genus,genus_normalized,subgenus,*section,*composite species,speciesBinomial,EQUIV#to:species#subspecies,EQUIV#to:species#composite variety,EQUIV#to:species#variety,division,genus |
|
| inputs/CVS/taxonObservation_/map.csv | ||
|---|---|---|
| 45 | 45 |
revisions,*revisions,, |
| 46 | 46 |
taxonInterpretation_dba_src_ID,*taxonInterpretation_dba_src_ID,, |
| 47 | 47 |
taxonInterpretation_accessionCode,*taxonInterpretation_accessionCode,, |
| 48 |
PLANTNAME_ID,*PLANTNAME_ID,, |
|
| 49 |
plantConcept_reference_ID,*plantConcept_reference_ID,, |
|
| 50 |
plantname,taxonName,,
|
|
| 51 |
plantNameWithAuthority,scientificName,,
|
|
| 52 |
plantCode,*plantCode,, |
|
| 53 |
plantDescription,*plantDescription,, |
|
| 54 |
plantConcept_accessionCode,*plantConcept_accessionCode,, |
|
| 55 |
plantConcept_dba_src_ID,*plantConcept_dba_src_ID,, |
|
| 56 |
plantConcept_entry_sppID,*plantConcept_entry_sppID,, |
|
| 57 |
USDAPlantsCode,*USDAPlantsCode,, |
|
| 58 |
VascularPlant,*VascularPlant,, |
|
| 59 |
denorm_kingdom,kingdom,,
|
|
| 60 |
denorm_division,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 |
denorm_category,*category,,
|
|
| 62 |
denorm_family,family,,
|
|
| 63 |
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus
|
|
| 64 |
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name"
|
|
| 65 |
denorm_triAbbr,infraspecificRank,,
|
|
| 66 |
denorm_triName,infraspecificEpithet,,
|
|
| 67 |
denorm_quadAbbr,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority
|
|
| 68 |
denorm_quadName,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
|
|
| 69 |
denorm_hybridX,*hybridX,,
|
|
| 70 |
taxonLevel,taxonRank,,
|
|
| 71 |
taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form |
|
| 72 |
lowestParentName,*lowestParentName,, |
|
| 73 |
lowestParentConcept_ID,*lowestParentConcept_ID,, |
|
| 74 |
lowestChildRank,*lowestChildRank,, |
|
| 75 |
commonName,vernacularName,,
|
|
| 76 |
growthForm_short,*growthForm_short,, |
|
| 77 |
woody,*woody,, |
|
| 78 |
exotic,*exotic,, |
|
| 79 |
usda_code,*usda_code,, |
|
| 80 |
usda_growthForm,*usda_growthForm,, |
|
| 81 |
sensitiveSpeciesFuzzPlot,*sensitiveSpeciesFuzzPlot,, |
|
| 82 |
Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,, |
|
| 83 |
Subkingdom,*Subkingdom,, |
|
| 84 |
Division,division_normalized,,
|
|
| 85 |
Class,class,,
|
|
| 86 |
Subclass,*Subclass,, |
|
| 87 |
Order,order,,
|
|
| 88 |
composite family,*composite family,, |
|
| 89 |
family,DUPLICATE#of:denorm_family#family,, |
|
| 90 |
tribe,*tribe,, |
|
| 91 |
composite genus,*composite genus,, |
|
| 92 |
*genus,genus_normalized,,"unlike VegBank, does *not* include genus author"
|
|
| 48 |
*PLANTNAME_ID,*PLANTNAME_ID,,
|
|
| 49 |
*plantConcept_reference_ID,*plantConcept_reference_ID,,
|
|
| 50 |
taxonName,taxonName,,
|
|
| 51 |
scientificName,scientificName,,
|
|
| 52 |
*plantCode,*plantCode,,
|
|
| 53 |
*plantDescription,*plantDescription,,
|
|
| 54 |
*plantConcept_accessionCode,*plantConcept_accessionCode,,
|
|
| 55 |
*plantConcept_dba_src_ID,*plantConcept_dba_src_ID,,
|
|
| 56 |
*plantConcept_entry_sppID,*plantConcept_entry_sppID,,
|
|
| 57 |
*USDAPlantsCode,*USDAPlantsCode,,
|
|
| 58 |
*VascularPlant,*VascularPlant,,
|
|
| 59 |
kingdom,kingdom,, |
|
| 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,*category,,
|
|
| 62 |
family,family,, |
|
| 63 |
genus_main,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus
|
|
| 64 |
specificEpithet,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name"
|
|
| 65 |
infraspecificRank,infraspecificRank,,
|
|
| 66 |
infraspecificEpithet,infraspecificEpithet,,
|
|
| 67 |
infraspecificRank2,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority
|
|
| 68 |
infraspecificEpithet2,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
|
|
| 69 |
*hybridX,*hybridX,,
|
|
| 70 |
taxonRank,taxonRank,,
|
|
| 71 |
OMIT#taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form
|
|
| 72 |
*lowestParentName,*lowestParentName,,
|
|
| 73 |
*lowestParentConcept_ID,*lowestParentConcept_ID,,
|
|
| 74 |
*lowestChildRank,*lowestChildRank,,
|
|
| 75 |
vernacularName,vernacularName,,
|
|
| 76 |
*growthForm_short,*growthForm_short,,
|
|
| 77 |
*woody,*woody,,
|
|
| 78 |
*exotic,*exotic,,
|
|
| 79 |
*usda_code,*usda_code,,
|
|
| 80 |
*usda_growthForm,*usda_growthForm,,
|
|
| 81 |
*sensitiveSpeciesFuzzPlot,*sensitiveSpeciesFuzzPlot,,
|
|
| 82 |
DUPLICATE#of:denorm_kingdom#Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,,
|
|
| 83 |
*Subkingdom,*Subkingdom,,
|
|
| 84 |
division_normalized,division_normalized,,
|
|
| 85 |
class,class,,
|
|
| 86 |
*Subclass,*Subclass,,
|
|
| 87 |
order,order,,
|
|
| 88 |
*composite family,*composite family,,
|
|
| 89 |
DUPLICATE#of:denorm_family#family,DUPLICATE#of:denorm_family#family,,
|
|
| 90 |
*tribe,*tribe,,
|
|
| 91 |
*composite genus,*composite genus,,
|
|
| 92 |
genus_normalized,genus_normalized,,"unlike VegBank, does *not* include genus author"
|
|
| 93 | 93 |
subgenus,subgenus,, |
| 94 |
section,*section,, |
|
| 95 |
composite species,*composite species,, |
|
| 96 |
species,speciesBinomial,,full taxonomic name at that rank |
|
| 97 |
subspecies,EQUIV#to:species#subspecies,,full taxonomic name at that rank |
|
| 98 |
composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank |
|
| 99 |
variety,EQUIV#to:species#variety,,full taxonomic name at that rank |
|
| 94 |
*section,*section,,
|
|
| 95 |
*composite species,*composite species,,
|
|
| 96 |
speciesBinomial,speciesBinomial,,full taxonomic name at that rank
|
|
| 97 |
EQUIV#to:species#subspecies,EQUIV#to:species#subspecies,,full taxonomic name at that rank
|
|
| 98 |
EQUIV#to:species#composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank
|
|
| 99 |
EQUIV#to:species#variety,EQUIV#to:species#variety,,full taxonomic name at that rank
|
|
| 100 | 100 |
division,*division,, |
| 101 | 101 |
genus,genus,, |
| 102 | 102 |
:plot,observationGranularity,, |
| inputs/CVS/taxonObservation_/new_terms.csv | ||
|---|---|---|
| 2 | 2 |
stemLocation_ID,stemID,, |
| 3 | 3 |
interpretationDate,dateIdentified,, |
| 4 | 4 |
collectionDate,dateCollected,, |
| 5 |
plantname,taxonName,, |
|
| 6 |
plantNameWithAuthority,scientificName,, |
|
| 7 |
denorm_kingdom,kingdom,, |
|
| 8 |
denorm_division,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" |
|
| 9 |
denorm_category,*category,, |
|
| 10 |
denorm_family,family,, |
|
| 11 |
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus |
|
| 12 |
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name" |
|
| 13 |
denorm_triAbbr,infraspecificRank,, |
|
| 14 |
denorm_triName,infraspecificEpithet,, |
|
| 15 |
denorm_quadAbbr,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority |
|
| 16 |
denorm_quadName,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority |
|
| 17 |
denorm_hybridX,*hybridX,, |
|
| 18 |
taxonLevel,taxonRank,, |
|
| 19 |
composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank |
|
Also available in: Unified diff
inputs/CVS/taxonObservation_/header.csv, map.csv: updated to use plantConcept_ renamed columns