Revision 5608
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 7 | 7 |
<locationevent> |
| 8 | 8 |
<taxonoccurrence> |
| 9 | 9 |
<taxondetermination> |
| 10 |
<taxonconcept_id>
|
|
| 11 |
<taxonconcept>
|
|
| 10 |
<taxonlabel_id>
|
|
| 11 |
<taxonlabel>
|
|
| 12 | 12 |
<identifyingtaxonomicname> |
| 13 | 13 |
<_join_words> |
| 14 | 14 |
<1> |
| ... | ... | |
| 37 | 37 |
<2>$Name_matched_author</2> |
| 38 | 38 |
</_join_words> |
| 39 | 39 |
</identifyingtaxonomicname> |
| 40 |
<_taxonconcept_set_matched_concept_id>
|
|
| 41 |
<matched_concept_id>
|
|
| 42 |
<taxonconcept>
|
|
| 40 |
<_taxonlabel_set_matched_label_id>
|
|
| 41 |
<matched_label_id>
|
|
| 42 |
<taxonlabel>
|
|
| 43 | 43 |
<author>$Accepted_name_author</author> |
| 44 | 44 |
<family>$Accepted_name_family</family> |
| 45 | 45 |
<identifyingtaxonomicname> |
| ... | ... | |
| 54 | 54 |
</_join_words> |
| 55 | 55 |
</identifyingtaxonomicname> |
| 56 | 56 |
<parent_id> |
| 57 |
<taxonconcept>
|
|
| 57 |
<taxonlabel>
|
|
| 58 | 58 |
<parent_id> |
| 59 |
<taxonconcept>
|
|
| 59 |
<taxonlabel>
|
|
| 60 | 60 |
<rank>cultivar</rank> |
| 61 | 61 |
<parent_id> |
| 62 |
<taxonconcept>
|
|
| 62 |
<taxonlabel>
|
|
| 63 | 63 |
<rank>forma</rank> |
| 64 | 64 |
<parent_id> |
| 65 |
<taxonconcept>
|
|
| 65 |
<taxonlabel>
|
|
| 66 | 66 |
<rank>variety</rank> |
| 67 | 67 |
<parent_id> |
| 68 |
<taxonconcept>
|
|
| 68 |
<taxonlabel>
|
|
| 69 | 69 |
<rank>subspecies</rank> |
| 70 | 70 |
<parent_id> |
| 71 |
<taxonconcept>
|
|
| 71 |
<taxonlabel>
|
|
| 72 | 72 |
<rank>species</rank> |
| 73 | 73 |
<parent_id> |
| 74 |
<taxonconcept>
|
|
| 74 |
<taxonlabel>
|
|
| 75 | 75 |
<rank>genus</rank> |
| 76 | 76 |
<parent_id> |
| 77 |
<taxonconcept>
|
|
| 77 |
<taxonlabel>
|
|
| 78 | 78 |
<rank>family</rank> |
| 79 |
<matched_concept_id>
|
|
| 80 |
<taxonconcept>
|
|
| 79 |
<matched_label_id>
|
|
| 80 |
<taxonlabel>
|
|
| 81 | 81 |
<creator_id> |
| 82 | 82 |
<party> |
| 83 | 83 |
<creator_id>0</creator_id> |
| ... | ... | |
| 86 | 86 |
</creator_id> |
| 87 | 87 |
<rank>family</rank> |
| 88 | 88 |
<taxonepithet>$Accepted_name_family</taxonepithet> |
| 89 |
</taxonconcept>
|
|
| 90 |
</matched_concept_id>
|
|
| 89 |
</taxonlabel>
|
|
| 90 |
</matched_label_id>
|
|
| 91 | 91 |
<taxonepithet>$Accepted_name_family</taxonepithet> |
| 92 |
</taxonconcept>
|
|
| 92 |
</taxonlabel>
|
|
| 93 | 93 |
</parent_id> |
| 94 |
</taxonconcept>
|
|
| 94 |
</taxonlabel>
|
|
| 95 | 95 |
</parent_id> |
| 96 |
</taxonconcept>
|
|
| 96 |
</taxonlabel>
|
|
| 97 | 97 |
</parent_id> |
| 98 |
</taxonconcept>
|
|
| 98 |
</taxonlabel>
|
|
| 99 | 99 |
</parent_id> |
| 100 |
</taxonconcept>
|
|
| 100 |
</taxonlabel>
|
|
| 101 | 101 |
</parent_id> |
| 102 |
</taxonconcept>
|
|
| 102 |
</taxonlabel>
|
|
| 103 | 103 |
</parent_id> |
| 104 |
</taxonconcept>
|
|
| 104 |
</taxonlabel>
|
|
| 105 | 105 |
</parent_id> |
| 106 | 106 |
<rank>$Accepted_name_rank</rank> |
| 107 | 107 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
| 108 |
</taxonconcept>
|
|
| 108 |
</taxonlabel>
|
|
| 109 | 109 |
</parent_id> |
| 110 | 110 |
<rank>$Accepted_name_rank</rank> |
| 111 | 111 |
<taxonomicname>$Accepted_name</taxonomicname> |
| 112 | 112 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
| 113 |
</taxonconcept>
|
|
| 114 |
</matched_concept_id>
|
|
| 115 |
</_taxonconcept_set_matched_concept_id>
|
|
| 113 |
</taxonlabel>
|
|
| 114 |
</matched_label_id>
|
|
| 115 |
</_taxonlabel_set_matched_label_id>
|
|
| 116 | 116 |
<author>$Name_matched_author</author> |
| 117 | 117 |
<family>$Name_matched_accepted_family</family> |
| 118 | 118 |
<genus>$Genus_matched</genus> |
| 119 | 119 |
<parent_id> |
| 120 |
<taxonconcept>
|
|
| 120 |
<taxonlabel>
|
|
| 121 | 121 |
<rank>$Name_matched_rank</rank> |
| 122 | 122 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
| 123 | 123 |
<parent_id> |
| 124 |
<taxonconcept>
|
|
| 124 |
<taxonlabel>
|
|
| 125 | 125 |
<rank>cultivar</rank> |
| 126 | 126 |
<parent_id> |
| 127 |
<taxonconcept>
|
|
| 127 |
<taxonlabel>
|
|
| 128 | 128 |
<rank>forma</rank> |
| 129 | 129 |
<parent_id> |
| 130 |
<taxonconcept>
|
|
| 130 |
<taxonlabel>
|
|
| 131 | 131 |
<rank>variety</rank> |
| 132 | 132 |
<parent_id> |
| 133 |
<taxonconcept>
|
|
| 133 |
<taxonlabel>
|
|
| 134 | 134 |
<rank>subspecies</rank> |
| 135 | 135 |
<parent_id> |
| 136 |
<taxonconcept>
|
|
| 136 |
<taxonlabel>
|
|
| 137 | 137 |
<rank>species</rank> |
| 138 | 138 |
<taxonepithet>$Specific_epithet_matched</taxonepithet> |
| 139 | 139 |
<parent_id> |
| 140 |
<taxonconcept>
|
|
| 140 |
<taxonlabel>
|
|
| 141 | 141 |
<rank>genus</rank> |
| 142 | 142 |
<taxonepithet>$Genus_matched</taxonepithet> |
| 143 | 143 |
<parent_id> |
| 144 |
<taxonconcept>
|
|
| 144 |
<taxonlabel>
|
|
| 145 | 145 |
<rank>family</rank> |
| 146 | 146 |
<taxonepithet>$Name_matched_accepted_family</taxonepithet> |
| 147 |
</taxonconcept>
|
|
| 147 |
</taxonlabel>
|
|
| 148 | 148 |
</parent_id> |
| 149 |
</taxonconcept>
|
|
| 149 |
</taxonlabel>
|
|
| 150 | 150 |
</parent_id> |
| 151 |
</taxonconcept>
|
|
| 151 |
</taxonlabel>
|
|
| 152 | 152 |
</parent_id> |
| 153 |
</taxonconcept>
|
|
| 153 |
</taxonlabel>
|
|
| 154 | 154 |
</parent_id> |
| 155 |
</taxonconcept>
|
|
| 155 |
</taxonlabel>
|
|
| 156 | 156 |
</parent_id> |
| 157 |
</taxonconcept>
|
|
| 157 |
</taxonlabel>
|
|
| 158 | 158 |
</parent_id> |
| 159 |
</taxonconcept>
|
|
| 159 |
</taxonlabel>
|
|
| 160 | 160 |
</parent_id> |
| 161 | 161 |
<taxonepithet>$Infraspecific_epithet_matched</taxonepithet> |
| 162 |
</taxonconcept>
|
|
| 162 |
</taxonlabel>
|
|
| 163 | 163 |
</parent_id> |
| 164 | 164 |
<rank>$Name_matched_rank</rank> |
| 165 | 165 |
<sourceaccessioncode>$Name_matched_url</sourceaccessioncode> |
| 166 | 166 |
<species>$Specific_epithet_matched</species> |
| 167 |
<taxonconcept fkey="matched_concept_id">
|
|
| 167 |
<taxonlabel fkey="matched_label_id">
|
|
| 168 | 168 |
<author>$Author_matched</author> |
| 169 | 169 |
<family>$Family_matched</family> |
| 170 | 170 |
<genus>$Genus_matched</genus> |
| 171 | 171 |
<identifyingtaxonomicname>$Name_submitted</identifyingtaxonomicname> |
| 172 |
<matched_concept_fit_fraction>
|
|
| 172 |
<matched_label_fit_fraction>
|
|
| 173 | 173 |
<_max> |
| 174 | 174 |
<1>$Family_score</1> |
| 175 | 175 |
<2>$Genus_score</2> |
| 176 | 176 |
<3>$Specific_epithet_score</3> |
| 177 | 177 |
<4>$Overall_score</4> |
| 178 | 178 |
</_max> |
| 179 |
</matched_concept_fit_fraction>
|
|
| 179 |
</matched_label_fit_fraction>
|
|
| 180 | 180 |
<species>$Specific_epithet_matched</species> |
| 181 | 181 |
<taxonepithet>$Unmatched_terms</taxonepithet> |
| 182 | 182 |
<taxonomicname>$Name_matched</taxonomicname> |
| 183 | 183 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
| 184 |
</taxonconcept>
|
|
| 184 |
</taxonlabel>
|
|
| 185 | 185 |
<taxonomicname>$Name_matched</taxonomicname> |
| 186 | 186 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
| 187 |
</taxonconcept>
|
|
| 188 |
</taxonconcept_id>
|
|
| 187 |
</taxonlabel>
|
|
| 188 |
</taxonlabel_id>
|
|
| 189 | 189 |
</taxondetermination> |
| 190 | 190 |
</taxonoccurrence> |
| 191 | 191 |
</locationevent> |
| ... | ... | |
| 193 | 193 |
</path> |
| 194 | 194 |
</_simplifyPath> |
| 195 | 195 |
</VegBIEN> |
| 196 |
Inserted 11 new rows into database |
|
| 196 |
Inserted 12 new rows into database |
|
Also available in: Unified diff
schemas/vegbien.sql: Renamed taxonconcept to taxonlabel per today's conference call, where it was decided that taxonconcept contained too many unrelated fields to be purely a taxon concept