Revision 9954
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/IRMNG/species_homonyms/map.csv | ||
|---|---|---|
| 3 | 3 |
IRMNG_ID,taxonID,, |
| 4 | 4 |
Homonym,taxonNameOrEpithet,, |
| 5 | 5 |
Homonym_Rank,taxonRank,, |
| 6 |
Authority,authors,,
|
|
| 6 |
Authority,scientificNameAuthorship,,
|
|
| 7 | 7 |
Kingdom,kingdom,, |
| 8 | 8 |
Phylum,phylum,, |
| 9 | 9 |
Class,class,, |
| inputs/IRMNG/species_homonyms/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
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, |
| 16 | 16 |
specificEpithet,/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, |
| 17 | 17 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 18 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
|
| 18 | 19 |
taxonNameOrEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/3, |
| 20 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author, |
|
| 19 | 21 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 20 | 22 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 21 | 23 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 22 | 24 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 23 | 25 |
*row_num,,** No join mapping for *row_num ** |
| 24 |
authors,,** No join mapping for authors ** |
|
| inputs/IRMNG/species_homonyms/test.xml.ref | ||
|---|---|---|
| 101 | 101 |
<_alt> |
| 102 | 102 |
<2> |
| 103 | 103 |
<_join_words> |
| 104 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 105 |
<3>$specificEpithet</3> |
|
| 104 |
<1> |
|
| 105 |
<_join_words> |
|
| 106 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 107 |
<3>$specificEpithet</3> |
|
| 108 |
</_join_words> |
|
| 109 |
</1> |
|
| 110 |
<2>$scientificNameAuthorship</2> |
|
| 106 | 111 |
</_join_words> |
| 107 | 112 |
</2> |
| 108 | 113 |
<3>$taxonNameOrEpithet</3> |
| ... | ... | |
| 112 | 117 |
</taxonomicname> |
| 113 | 118 |
</taxonlabel> |
| 114 | 119 |
</taxonlabel_id> |
| 120 |
<author>$scientificNameAuthorship</author> |
|
| 115 | 121 |
<family>$family</family> |
| 116 | 122 |
<genus>$genus</genus> |
| 117 | 123 |
<specific_epithet>$specificEpithet</specific_epithet> |
| inputs/IRMNG/species_homonyms/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*row_num |
| 2 |
authors |
|
| inputs/IRMNG/map.csv | ||
|---|---|---|
| 3 | 3 |
IRMNG_ID,taxonID,, |
| 4 | 4 |
Homonym,taxonNameOrEpithet,, |
| 5 | 5 |
Homonym_Rank,taxonRank,, |
| 6 |
Authority,authors,,
|
|
| 6 |
Authority,scientificNameAuthorship,,
|
|
| 7 | 7 |
Kingdom,kingdom,, |
| 8 | 8 |
Phylum,phylum,, |
| 9 | 9 |
Class,class,, |
| inputs/IRMNG/family_homonyms/map.csv | ||
|---|---|---|
| 3 | 3 |
IRMNG_ID,taxonID,, |
| 4 | 4 |
Homonym,taxonNameOrEpithet,, |
| 5 | 5 |
Homonym_Rank,taxonRank,, |
| 6 |
Authority,authors,,
|
|
| 6 |
Authority,scientificNameAuthorship,,
|
|
| 7 | 7 |
Kingdom,kingdom,, |
| 8 | 8 |
Phylum,phylum,, |
| 9 | 9 |
Class,class,, |
| inputs/IRMNG/family_homonyms/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
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, |
| 16 | 16 |
specificEpithet,/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, |
| 17 | 17 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 18 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
|
| 18 | 19 |
taxonNameOrEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/3, |
| 20 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author, |
|
| 19 | 21 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 20 | 22 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 21 | 23 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 22 | 24 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 23 | 25 |
*row_num,,** No join mapping for *row_num ** |
| 24 |
authors,,** No join mapping for authors ** |
|
| inputs/IRMNG/family_homonyms/test.xml.ref | ||
|---|---|---|
| 101 | 101 |
<_alt> |
| 102 | 102 |
<2> |
| 103 | 103 |
<_join_words> |
| 104 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 105 |
<3>$specificEpithet</3> |
|
| 104 |
<1> |
|
| 105 |
<_join_words> |
|
| 106 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 107 |
<3>$specificEpithet</3> |
|
| 108 |
</_join_words> |
|
| 109 |
</1> |
|
| 110 |
<2>$scientificNameAuthorship</2> |
|
| 106 | 111 |
</_join_words> |
| 107 | 112 |
</2> |
| 108 | 113 |
<3>$taxonNameOrEpithet</3> |
| ... | ... | |
| 112 | 117 |
</taxonomicname> |
| 113 | 118 |
</taxonlabel> |
| 114 | 119 |
</taxonlabel_id> |
| 120 |
<author>$scientificNameAuthorship</author> |
|
| 115 | 121 |
<family>$family</family> |
| 116 | 122 |
<genus>$genus</genus> |
| 117 | 123 |
<specific_epithet>$specificEpithet</specific_epithet> |
| ... | ... | |
| 127 | 133 |
</path> |
| 128 | 134 |
</_setDefault> |
| 129 | 135 |
</VegBIEN> |
| 130 |
Inserted 14 new rows into database |
|
| 136 |
Inserted 16 new rows into database |
|
| inputs/IRMNG/family_homonyms/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
IRMNG_ID,taxonID,, |
| 2 | 2 |
Homonym,taxonNameOrEpithet,, |
| 3 | 3 |
Homonym_Rank,taxonRank,, |
| 4 |
Authority,authors,, |
|
| 4 |
Authority,scientificNameAuthorship,, |
|
| inputs/IRMNG/family_homonyms/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*row_num |
| 2 |
authors |
|
| inputs/IRMNG/genus_homonyms/map.csv | ||
|---|---|---|
| 3 | 3 |
IRMNG_ID,taxonID,, |
| 4 | 4 |
Homonym,taxonNameOrEpithet,, |
| 5 | 5 |
Homonym_Rank,taxonRank,, |
| 6 |
Authority,authors,,
|
|
| 6 |
Authority,scientificNameAuthorship,,
|
|
| 7 | 7 |
Kingdom,kingdom,, |
| 8 | 8 |
Phylum,phylum,, |
| 9 | 9 |
Class,class,, |
| inputs/IRMNG/genus_homonyms/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
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, |
| 16 | 16 |
specificEpithet,/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, |
| 17 | 17 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 18 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
|
| 18 | 19 |
taxonNameOrEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/3, |
| 20 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author, |
|
| 19 | 21 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family, |
| 20 | 22 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 21 | 23 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 22 | 24 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 23 | 25 |
*row_num,,** No join mapping for *row_num ** |
| 24 |
authors,,** No join mapping for authors ** |
|
| inputs/IRMNG/genus_homonyms/test.xml.ref | ||
|---|---|---|
| 101 | 101 |
<_alt> |
| 102 | 102 |
<2> |
| 103 | 103 |
<_join_words> |
| 104 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 105 |
<3>$specificEpithet</3> |
|
| 104 |
<1> |
|
| 105 |
<_join_words> |
|
| 106 |
<2><_filter_genus><value>$genus</value></_filter_genus></2> |
|
| 107 |
<3>$specificEpithet</3> |
|
| 108 |
</_join_words> |
|
| 109 |
</1> |
|
| 110 |
<2>$scientificNameAuthorship</2> |
|
| 106 | 111 |
</_join_words> |
| 107 | 112 |
</2> |
| 108 | 113 |
<3>$taxonNameOrEpithet</3> |
| ... | ... | |
| 112 | 117 |
</taxonomicname> |
| 113 | 118 |
</taxonlabel> |
| 114 | 119 |
</taxonlabel_id> |
| 120 |
<author>$scientificNameAuthorship</author> |
|
| 115 | 121 |
<family>$family</family> |
| 116 | 122 |
<genus>$genus</genus> |
| 117 | 123 |
<specific_epithet>$specificEpithet</specific_epithet> |
| inputs/IRMNG/genus_homonyms/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
IRMNG_ID,taxonID,, |
| 2 | 2 |
Homonym,taxonNameOrEpithet,, |
| 3 | 3 |
Homonym_Rank,taxonRank,, |
| 4 |
Authority,authors,, |
|
| 4 |
Authority,scientificNameAuthorship,, |
|
| inputs/IRMNG/genus_homonyms/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*row_num |
| 2 |
authors |
|
Also available in: Unified diff
bugfix: inputs/IRMNG/*/map.csv: remapped Authority to scientificNameAuthorship instead of authors (now data_authors <VegCore.vegpath.org?data_authors> for clarity)