Revision 11724
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/plantConcept_/map.csv | ||
|---|---|---|
| 12 | 12 |
USDAPlantsCode,*USDAPlantsCode,, |
| 13 | 13 |
VascularPlant,*VascularPlant,, |
| 14 | 14 |
denorm_kingdom,kingdom,, |
| 15 |
denorm_division,division_main,/_alt/1,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
|
|
| 15 |
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" |
|
| 16 | 16 |
denorm_category,*category,, |
| 17 | 17 |
denorm_family,family,, |
| 18 |
denorm_genus,genus_main,/_alt/1,must be _alt-ed with genus because this is missing in 1 row that has genus
|
|
| 18 |
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus |
|
| 19 | 19 |
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name" |
| 20 | 20 |
denorm_triAbbr,infraspecificRank,, |
| 21 | 21 |
denorm_triName,infraspecificEpithet,, |
| ... | ... | |
| 35 | 35 |
usda_growthForm,*usda_growthForm,, |
| 36 | 36 |
Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,, |
| 37 | 37 |
Subkingdom,*Subkingdom,, |
| 38 |
Division,division_normalized,/_alt/2,
|
|
| 38 |
Division,division_normalized,, |
|
| 39 | 39 |
Class,class,, |
| 40 | 40 |
Subclass,*Subclass,, |
| 41 | 41 |
Order,order,, |
| ... | ... | |
| 43 | 43 |
family,DUPLICATE#of:denorm_family#family,, |
| 44 | 44 |
tribe,*tribe,, |
| 45 | 45 |
composite genus,*composite genus,, |
| 46 |
genus,genus_normalized,/_alt/2,"unlike VegBank, does *not* include genus author"
|
|
| 46 |
genus,genus_normalized,,"unlike VegBank, does *not* include genus author" |
|
| 47 | 47 |
subgenus,subgenus,, |
| 48 | 48 |
section,*section,, |
| 49 | 49 |
composite species,*composite species,, |
| inputs/CVS/plantConcept_/VegBIEN.csv | ||
|---|---|---|
| 25 | 25 |
plantname,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/taxonname, |
| 26 | 26 |
plantNameWithAuthority,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/taxonomicname, |
| 27 | 27 |
taxonLevel,/location/locationevent/locationevent:[@fkey=parent_id]/taxonoccurrence/taxondetermination[!isoriginal=true]/*_id/taxonverbatim/verbatimrank, |
| 28 |
Division,,** No join mapping for division_normalized/_alt/2 **
|
|
| 28 |
Division,,** No join mapping for division_normalized ** |
|
| 29 | 29 |
Kingdom,,** No non-empty join mapping for DUPLICATE#of:denorm_kingdom#Kingdom ** |
| 30 | 30 |
PLANTCONCEPT_ID,,** No join mapping for *PLANTCONCEPT_ID ** |
| 31 | 31 |
PLANTNAME_ID,,** No join mapping for *PLANTNAME_ID ** |
| ... | ... | |
| 39 | 39 |
composite species,,** No join mapping for *composite species ** |
| 40 | 40 |
composite variety,,** No non-empty join mapping for EQUIV#to:species#composite variety ** full taxonomic name at that rank |
| 41 | 41 |
denorm_category,,** No join mapping for *category ** |
| 42 |
denorm_division,,"** No join mapping for division_main/_alt/1 ** must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
|
|
| 43 |
denorm_genus,,** No join mapping for genus_main/_alt/1 ** must be _alt-ed with genus because this is missing in 1 row that has genus
|
|
| 42 |
denorm_division,,"** No join mapping for 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" |
|
| 43 |
denorm_genus,,** No join mapping for genus_main ** must be _alt-ed with genus because this is missing in 1 row that has genus |
|
| 44 | 44 |
denorm_hybridX,,** No join mapping for *hybridX ** |
| 45 | 45 |
denorm_quadAbbr,,** No join mapping for infraspecificRank2 ** sometimes misparsed as the last + sign in the plantNameWithAuthority |
| 46 | 46 |
denorm_quadName,,** No join mapping for infraspecificEpithet2 ** sometimes misparsed as the part after the last + sign in the plantNameWithAuthority |
| ... | ... | |
| 48 | 48 |
division,,** No join mapping for division ** |
| 49 | 49 |
exotic,,** No join mapping for *exotic ** |
| 50 | 50 |
family,,** No non-empty join mapping for DUPLICATE#of:denorm_family#family ** |
| 51 |
genus,,"** No join mapping for genus_normalized/_alt/2 ** unlike VegBank, does *not* include genus author"
|
|
| 51 |
genus,,"** No join mapping for genus_normalized ** unlike VegBank, does *not* include genus author" |
|
| 52 | 52 |
growthForm_short,,** No join mapping for *growthForm_short ** |
| 53 | 53 |
lowestChildRank,,** No join mapping for *lowestChildRank ** |
| 54 | 54 |
lowestParentConcept_ID,,** No join mapping for *lowestParentConcept_ID ** |
| inputs/CVS/plantConcept_/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
plantname,taxonName,, |
| 2 | 2 |
plantNameWithAuthority,scientificName,, |
| 3 | 3 |
denorm_kingdom,kingdom,, |
| 4 |
denorm_division,division_main,/_alt/1,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
|
|
| 4 |
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" |
|
| 5 | 5 |
denorm_category,*category,, |
| 6 | 6 |
denorm_family,family,, |
| 7 |
denorm_genus,genus_main,/_alt/1,must be _alt-ed with genus because this is missing in 1 row that has genus
|
|
| 7 |
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus |
|
| 8 | 8 |
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name" |
| 9 | 9 |
denorm_triAbbr,infraspecificRank,, |
| 10 | 10 |
denorm_triName,infraspecificEpithet,, |
Also available in: Unified diff
inputs/CVS/plantConcept_/: translated multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#1-Translate-filters-to-postprocessing-derived-columns