Revision 4703
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 177 | 177 |
</party_id> |
| 178 | 178 |
<plantconcept_id> |
| 179 | 179 |
<plantconcept> |
| 180 |
<plantname_id> |
|
| 181 |
<plantname> |
|
| 182 |
<rank>binomial</rank> |
|
| 183 |
<plantname>$ScientificName</plantname> |
|
| 184 |
<parent_id> |
|
| 185 |
<plantname> |
|
| 186 |
<rank>authority</rank> |
|
| 187 |
<plantname>$AuthorOfScientificName</plantname> |
|
| 188 |
<parent_id> |
|
| 189 |
<plantname> |
|
| 190 |
<rank>subspecies</rank> |
|
| 191 |
<plantname>$InfraspecificEpithet</plantname> |
|
| 192 |
<parent_id> |
|
| 193 |
<plantname> |
|
| 194 |
<rank>species</rank> |
|
| 195 |
<plantname>$SpecificEpithet</plantname> |
|
| 196 |
<parent_id> |
|
| 197 |
<plantname> |
|
| 198 |
<rank>genus</rank> |
|
| 199 |
<plantname>$Genus</plantname> |
|
| 200 |
<parent_id> |
|
| 201 |
<plantname> |
|
| 202 |
<rank>family</rank> |
|
| 203 |
<plantname>$Family</plantname> |
|
| 204 |
</plantname> |
|
| 205 |
</parent_id> |
|
| 206 |
</plantname> |
|
| 207 |
</parent_id> |
|
| 208 |
</plantname> |
|
| 209 |
</parent_id> |
|
| 210 |
</plantname> |
|
| 211 |
</parent_id> |
|
| 212 |
</plantname> |
|
| 213 |
</parent_id> |
|
| 214 |
</plantname> |
|
| 215 |
</plantname_id> |
|
| 180 |
<family>$Family</family> |
|
| 181 |
<genus>$Genus</genus> |
|
| 182 |
<scientificname>$ScientificName</scientificname> |
|
| 183 |
<scientificnameauthor>$AuthorOfScientificName</scientificnameauthor> |
|
| 184 |
<species>$SpecificEpithet</species> |
|
| 185 |
<subspecies>$InfraspecificEpithet</subspecies> |
|
| 216 | 186 |
</plantconcept> |
| 217 | 187 |
</plantconcept_id> |
| 218 | 188 |
</taxondetermination> |
| ... | ... | |
| 220 | 190 |
<isoriginal>true</isoriginal> |
| 221 | 191 |
<plantconcept_id> |
| 222 | 192 |
<plantconcept> |
| 223 |
<plantname_id> |
|
| 224 |
<plantname> |
|
| 225 |
<rank>binomial</rank> |
|
| 226 |
<plantname>$ScientificNameOriginal</plantname> |
|
| 227 |
<parent_id> |
|
| 228 |
<plantname> |
|
| 229 |
<rank>authority</rank> |
|
| 230 |
<parent_id> |
|
| 231 |
<plantname> |
|
| 232 |
<rank>subspecies</rank> |
|
| 233 |
<parent_id> |
|
| 234 |
<plantname> |
|
| 235 |
<rank>species</rank> |
|
| 236 |
<parent_id> |
|
| 237 |
<plantname> |
|
| 238 |
<rank>genus</rank> |
|
| 239 |
<plantname>$GBIFGenusOriginal</plantname> |
|
| 240 |
<parent_id> |
|
| 241 |
<plantname> |
|
| 242 |
<rank>family</rank> |
|
| 243 |
<plantname>$GBIFFamilyOriginal</plantname> |
|
| 244 |
</plantname> |
|
| 245 |
</parent_id> |
|
| 246 |
</plantname> |
|
| 247 |
</parent_id> |
|
| 248 |
</plantname> |
|
| 249 |
</parent_id> |
|
| 250 |
</plantname> |
|
| 251 |
</parent_id> |
|
| 252 |
</plantname> |
|
| 253 |
</parent_id> |
|
| 254 |
</plantname> |
|
| 255 |
</plantname_id> |
|
| 193 |
<family>$GBIFFamilyOriginal</family> |
|
| 194 |
<genus>$GBIFGenusOriginal</genus> |
|
| 195 |
<scientificname>$ScientificNameOriginal</scientificname> |
|
| 256 | 196 |
</plantconcept> |
| 257 | 197 |
</plantconcept_id> |
| 258 | 198 |
</taxondetermination> |
| ... | ... | |
| 264 | 204 |
</path> |
| 265 | 205 |
</_simplifyPath> |
| 266 | 206 |
</VegBIEN> |
| 267 |
Inserted 37 new rows into database |
|
| 207 |
Inserted 27 new rows into database |
|
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 119 | 119 |
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 120 | 120 |
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 121 | 121 |
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 122 |
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 123 |
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 124 |
dwc_terms_scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 125 |
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/1",
|
|
| 126 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
|
|
| 127 |
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/3",
|
|
| 128 |
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 129 |
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 130 |
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 131 |
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 132 |
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 133 |
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 134 |
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 135 |
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 136 |
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 137 |
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 138 |
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 139 |
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 140 |
conceptual_darwin_2003_1_0_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 141 |
dwc_dwcore_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 142 |
dwc_terms_order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 143 |
conceptual_darwin_2003_1_0_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 144 |
dwc_dwcore_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 145 |
dwc_terms_class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 146 |
conceptual_darwin_2003_1_0_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 147 |
dwc_dwcore_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 148 |
dwc_terms_phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 149 |
conceptual_darwin_2003_1_0_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 150 |
dwc_dwcore_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 151 |
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 122 |
conceptual_darwin_2003_1_0_Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 123 |
dwc_dwcore_Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 124 |
dwc_terms_class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 125 |
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 126 |
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 127 |
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 128 |
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 129 |
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 130 |
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 131 |
conceptual_darwin_2003_1_0_Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 132 |
dwc_dwcore_Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 133 |
dwc_terms_kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 134 |
conceptual_darwin_2003_1_0_Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 135 |
dwc_dwcore_Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 136 |
dwc_terms_order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 137 |
conceptual_darwin_2003_1_0_Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 138 |
dwc_dwcore_Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 139 |
dwc_terms_phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 140 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 141 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 142 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 143 |
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor/_alt/1,
|
|
| 144 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor/_alt/2,
|
|
| 145 |
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor/_alt/3,
|
|
| 146 |
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 147 |
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 148 |
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 149 |
conceptual_darwin_2003_1_0_Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 150 |
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 151 |
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 152 | 152 |
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 153 | 153 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 154 | 154 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| inputs/MO/Specimen/test.xml.ref | ||
|---|---|---|
| 193 | 193 |
</party_id> |
| 194 | 194 |
<plantconcept_id> |
| 195 | 195 |
<plantconcept> |
| 196 |
<plantname_id> |
|
| 197 |
<plantname> |
|
| 198 |
<rank>binomial</rank> |
|
| 199 |
<plantname>$ScientificName</plantname> |
|
| 200 |
<parent_id> |
|
| 201 |
<plantname> |
|
| 202 |
<rank>authority</rank> |
|
| 203 |
<plantname>$ScientificNameAuthor</plantname> |
|
| 204 |
<parent_id> |
|
| 205 |
<plantname> |
|
| 206 |
<rank>subspecies</rank> |
|
| 207 |
<plantname>$Subspecies</plantname> |
|
| 208 |
<parent_id> |
|
| 209 |
<plantname> |
|
| 210 |
<rank>species</rank> |
|
| 211 |
<plantname>$species</plantname> |
|
| 212 |
<parent_id> |
|
| 213 |
<plantname> |
|
| 214 |
<rank>genus</rank> |
|
| 215 |
<plantname>$genus</plantname> |
|
| 216 |
<parent_id> |
|
| 217 |
<plantname> |
|
| 218 |
<rank>family</rank> |
|
| 219 |
<plantname>$family</plantname> |
|
| 220 |
<parent_id> |
|
| 221 |
<plantname> |
|
| 222 |
<rank>order</rank> |
|
| 223 |
<parent_id> |
|
| 224 |
<plantname> |
|
| 225 |
<rank>class</rank> |
|
| 226 |
<parent_id> |
|
| 227 |
<plantname> |
|
| 228 |
<rank>subkingdom</rank> |
|
| 229 |
<parent_id> |
|
| 230 |
<plantname> |
|
| 231 |
<rank>kingdom</rank> |
|
| 232 |
<plantname>$Kingdom</plantname> |
|
| 233 |
</plantname> |
|
| 234 |
</parent_id> |
|
| 235 |
</plantname> |
|
| 236 |
</parent_id> |
|
| 237 |
</plantname> |
|
| 238 |
</parent_id> |
|
| 239 |
</plantname> |
|
| 240 |
</parent_id> |
|
| 241 |
</plantname> |
|
| 242 |
</parent_id> |
|
| 243 |
</plantname> |
|
| 244 |
</parent_id> |
|
| 245 |
</plantname> |
|
| 246 |
</parent_id> |
|
| 247 |
</plantname> |
|
| 248 |
</parent_id> |
|
| 249 |
</plantname> |
|
| 250 |
</parent_id> |
|
| 251 |
</plantname> |
|
| 252 |
</plantname_id> |
|
| 196 |
<family>$family</family> |
|
| 197 |
<genus>$genus</genus> |
|
| 198 |
<kingdom>$Kingdom</kingdom> |
|
| 199 |
<scientificname>$ScientificName</scientificname> |
|
| 200 |
<scientificnameauthor>$ScientificNameAuthor</scientificnameauthor> |
|
| 201 |
<species>$species</species> |
|
| 202 |
<subspecies>$Subspecies</subspecies> |
|
| 253 | 203 |
</plantconcept> |
| 254 | 204 |
</plantconcept_id> |
| 255 | 205 |
</taxondetermination> |
| ... | ... | |
| 261 | 211 |
</path> |
| 262 | 212 |
</_simplifyPath> |
| 263 | 213 |
</VegBIEN> |
| 264 |
Inserted 38 new rows into database |
|
| 214 |
Inserted 26 new rows into database |
|
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
| 15 | 15 |
Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height, |
| 16 | 16 |
TreeTag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| 17 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 18 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 17 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 18 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 19 | 19 |
HOM,,** No join mapping for HOM ** |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 51 | 51 |
Ind,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 52 | 52 |
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
| 53 | 53 |
PlotObsID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 54 |
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: This is the author of the scientificName.
|
|
| 55 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
|
|
| 56 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 57 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 58 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 59 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 54 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 55 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 56 |
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,Brad: This is the author of the scientificName.
|
|
| 57 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 58 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first,
|
|
| 59 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 60 | 60 |
cfaff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank." |
| 61 |
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",Brad: OMIT
|
|
| 62 |
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 63 |
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",Brad: OMIT
|
|
| 61 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/family,Brad: OMIT
|
|
| 62 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/genus,
|
|
| 63 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/species,Brad: OMIT
|
|
| 64 | 64 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,Brad: See comment above |
| 65 | 65 |
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 66 | 66 |
DetType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 16 | 16 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 17 | 17 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 18 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 19 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 18 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 19 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 20 | 20 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 21 | 21 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 22 | 22 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 39 | 39 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 40 | 40 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 41 | 41 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 42 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/1",Contains the binomial in addition to the authority
|
|
| 43 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/2",
|
|
| 44 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 45 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 46 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 47 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 48 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 49 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 50 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 51 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 42 |
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 43 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 44 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 45 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 46 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 47 |
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 48 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname/_alt/1,Contains the binomial in addition to the authority
|
|
| 49 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname/_alt/2,
|
|
| 50 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 51 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 52 | 52 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 53 | 53 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 54 | 54 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 24 | 24 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 25 | 25 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 26 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 27 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 28 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 29 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 30 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 31 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 32 |
ScientificNameOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 33 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 34 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 28 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 29 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 30 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 31 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 32 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/family,
|
|
| 33 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/genus,
|
|
| 34 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/scientificname,
|
|
| 35 | 35 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 36 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 37 | 37 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 80 | 80 |
</aggregateoccurrence> |
| 81 | 81 |
<authortaxoncode>$Full Taxon Name</authortaxoncode> |
| 82 | 82 |
<iscultivated>$Cultivated?</iscultivated> |
| 83 |
<taxondetermination> |
|
| 84 |
<plantconcept_id> |
|
| 85 |
<plantconcept> |
|
| 86 |
<plantname_id> |
|
| 87 |
<plantname> |
|
| 88 |
<rank>binomial</rank> |
|
| 89 |
<plantname>$Full Taxon Name</plantname> |
|
| 90 |
</plantname> |
|
| 91 |
</plantname_id> |
|
| 92 |
</plantconcept> |
|
| 93 |
</plantconcept_id> |
|
| 94 |
</taxondetermination> |
|
| 83 |
<taxondetermination><plantconcept_id><plantconcept><scientificname>$Full Taxon Name</scientificname></plantconcept></plantconcept_id></taxondetermination> |
|
| 95 | 84 |
</taxonoccurrence> |
| 96 | 85 |
</locationevent> |
| 97 | 86 |
</location> |
| 98 | 87 |
</path> |
| 99 | 88 |
</_simplifyPath> |
| 100 | 89 |
</VegBIEN> |
| 101 |
Inserted 26 new rows into database |
|
| 90 |
Inserted 24 new rows into database |
|
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 29 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 30 | 30 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 31 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 32 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 33 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 34 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 35 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 36 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 37 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 31 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 32 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 33 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 34 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 35 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 36 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 37 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 38 | 38 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 39 | 39 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 40 | 40 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 12 | 12 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value", |
| 13 | 13 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 14 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 15 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 14 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 15 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 16 | 16 |
locality,/location/locationnarrative/_merge/1, |
| 17 | 17 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| 18 | 18 |
countryCode,,** No join mapping for countryCode ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 79 | 79 |
<taxondetermination> |
| 80 | 80 |
<plantconcept_id> |
| 81 | 81 |
<plantconcept> |
| 82 |
<plantname_id> |
|
| 83 |
<plantname> |
|
| 84 |
<rank>binomial</rank> |
|
| 85 |
<parent_id> |
|
| 86 |
<plantname> |
|
| 87 |
<rank>authority</rank> |
|
| 88 |
<parent_id> |
|
| 89 |
<plantname> |
|
| 90 |
<rank>subspecies</rank> |
|
| 91 |
<parent_id> |
|
| 92 |
<plantname> |
|
| 93 |
<rank>species</rank> |
|
| 94 |
<parent_id> |
|
| 95 |
<plantname> |
|
| 96 |
<rank>genus</rank> |
|
| 97 |
<plantname>$genus</plantname> |
|
| 98 |
<parent_id> |
|
| 99 |
<plantname> |
|
| 100 |
<rank>family</rank> |
|
| 101 |
<plantname>$family</plantname> |
|
| 102 |
</plantname> |
|
| 103 |
</parent_id> |
|
| 104 |
</plantname> |
|
| 105 |
</parent_id> |
|
| 106 |
</plantname> |
|
| 107 |
</parent_id> |
|
| 108 |
</plantname> |
|
| 109 |
</parent_id> |
|
| 110 |
</plantname> |
|
| 111 |
</parent_id> |
|
| 112 |
</plantname> |
|
| 113 |
</plantname_id> |
|
| 82 |
<family>$family</family> |
|
| 83 |
<genus>$genus</genus> |
|
| 114 | 84 |
</plantconcept> |
| 115 | 85 |
</plantconcept_id> |
| 116 | 86 |
</taxondetermination> |
| ... | ... | |
| 121 | 91 |
</path> |
| 122 | 92 |
</_simplifyPath> |
| 123 | 93 |
</VegBIEN> |
| 124 |
Inserted 22 new rows into database |
|
| 94 |
Inserted 20 new rows into database |
|
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 31 | 31 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 32 | 32 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 33 | 33 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 34 |
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 35 |
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 36 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 37 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 38 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 39 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 40 |
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 41 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 42 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 43 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 34 |
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 35 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 36 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 37 |
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 38 |
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 39 |
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 40 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 41 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 42 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 43 |
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 44 | 44 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 45 | 45 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 46 | 46 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 17 | 17 |
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| 18 | 18 |
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition, |
| 19 | 19 |
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 22 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 20 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 22 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 23 | 23 |
Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 24 | 24 |
Comments,,** No join mapping for Comments ** |
| 25 | 25 |
ConditionCodes,,** No join mapping for ConditionCodes ** |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 45 | 45 |
<taxondetermination> |
| 46 | 46 |
<plantconcept_id> |
| 47 | 47 |
<plantconcept> |
| 48 |
<plantname_id> |
|
| 49 |
<plantname> |
|
| 50 |
<rank>binomial</rank> |
|
| 51 |
<parent_id> |
|
| 52 |
<plantname> |
|
| 53 |
<rank>authority</rank> |
|
| 54 |
<parent_id> |
|
| 55 |
<plantname> |
|
| 56 |
<rank>subspecies</rank> |
|
| 57 |
<parent_id> |
|
| 58 |
<plantname> |
|
| 59 |
<rank>species</rank> |
|
| 60 |
<plantname>$SpecificEpithet</plantname> |
|
| 61 |
<parent_id> |
|
| 62 |
<plantname> |
|
| 63 |
<rank>genus</rank> |
|
| 64 |
<plantname>$Genus</plantname> |
|
| 65 |
<parent_id> |
|
| 66 |
<plantname> |
|
| 67 |
<rank>family</rank> |
|
| 68 |
<plantname>$Family</plantname> |
|
| 69 |
</plantname> |
|
| 70 |
</parent_id> |
|
| 71 |
</plantname> |
|
| 72 |
</parent_id> |
|
| 73 |
</plantname> |
|
| 74 |
</parent_id> |
|
| 75 |
</plantname> |
|
| 76 |
</parent_id> |
|
| 77 |
</plantname> |
|
| 78 |
</parent_id> |
|
| 79 |
</plantname> |
|
| 80 |
</plantname_id> |
|
| 48 |
<family>$Family</family> |
|
| 49 |
<genus>$Genus</genus> |
|
| 50 |
<species>$SpecificEpithet</species> |
|
| 81 | 51 |
</plantconcept> |
| 82 | 52 |
</plantconcept_id> |
| 83 | 53 |
</taxondetermination> |
| ... | ... | |
| 88 | 58 |
</path> |
| 89 | 59 |
</_simplifyPath> |
| 90 | 60 |
</VegBIEN> |
| 91 |
Inserted 23 new rows into database |
|
| 61 |
Inserted 18 new rows into database |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 17 | 17 |
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| 18 | 18 |
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition, |
| 19 | 19 |
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition, |
| 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 22 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 20 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 22 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 23 | 23 |
Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 24 | 24 |
Comments,,** No join mapping for Comments ** |
| 25 | 25 |
ConditionCodes,,** No join mapping for ConditionCodes ** |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 34 | 34 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 35 | 35 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 36 | 36 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 37 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 38 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 39 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
|
|
| 40 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 42 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 43 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 44 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 45 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 46 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 47 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 37 |
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 38 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 39 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 40 |
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 41 |
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 42 |
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 43 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 44 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 45 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 46 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first,
|
|
| 47 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 48 | 48 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 49 | 49 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 50 | 50 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 18 | 18 |
<taxondetermination> |
| 19 | 19 |
<plantconcept_id> |
| 20 | 20 |
<plantconcept> |
| 21 |
<plantname_id> |
|
| 22 |
<plantname> |
|
| 23 |
<rank>binomial</rank> |
|
| 24 |
<parent_id> |
|
| 25 |
<plantname> |
|
| 26 |
<rank>authority</rank> |
|
| 27 |
<parent_id> |
|
| 28 |
<plantname> |
|
| 29 |
<rank>subspecies</rank> |
|
| 30 |
<plantname>$Subspecies</plantname> |
|
| 31 |
<parent_id> |
|
| 32 |
<plantname> |
|
| 33 |
<rank>species</rank> |
|
| 34 |
<plantname>$Species</plantname> |
|
| 35 |
<parent_id> |
|
| 36 |
<plantname> |
|
| 37 |
<rank>genus</rank> |
|
| 38 |
<plantname>$Genus</plantname> |
|
| 39 |
<parent_id> |
|
| 40 |
<plantname> |
|
| 41 |
<rank>family</rank> |
|
| 42 |
<plantname>$Family</plantname> |
|
| 43 |
<parent_id> |
|
| 44 |
<plantname> |
|
| 45 |
<rank>order</rank> |
|
| 46 |
<plantname>$Order</plantname> |
|
| 47 |
<parent_id> |
|
| 48 |
<plantname> |
|
| 49 |
<rank>class</rank> |
|
| 50 |
<plantname>$Class</plantname> |
|
| 51 |
<parent_id> |
|
| 52 |
<plantname> |
|
| 53 |
<rank>subkingdom</rank> |
|
| 54 |
<parent_id> |
|
| 55 |
<plantname> |
|
| 56 |
<rank>kingdom</rank> |
|
| 57 |
<plantname>$Kingdom</plantname> |
|
| 58 |
</plantname> |
|
| 59 |
</parent_id> |
|
| 60 |
</plantname> |
|
| 61 |
</parent_id> |
|
| 62 |
</plantname> |
|
| 63 |
</parent_id> |
|
| 64 |
</plantname> |
|
| 65 |
</parent_id> |
|
| 66 |
</plantname> |
|
| 67 |
</parent_id> |
|
| 68 |
</plantname> |
|
| 69 |
</parent_id> |
|
| 70 |
</plantname> |
|
| 71 |
</parent_id> |
|
| 72 |
</plantname> |
|
| 73 |
</parent_id> |
|
| 74 |
</plantname> |
|
| 75 |
</parent_id> |
|
| 76 |
</plantname> |
|
| 77 |
</plantname_id> |
|
| 21 |
<class>$Class</class> |
|
| 22 |
<family>$Family</family> |
|
| 23 |
<genus>$Genus</genus> |
|
| 24 |
<kingdom>$Kingdom</kingdom> |
|
| 25 |
<order>$Order</order> |
|
| 26 |
<species>$Species</species> |
|
| 27 |
<subspecies>$Subspecies</subspecies> |
|
| 78 | 28 |
</plantconcept> |
| 79 | 29 |
</plantconcept_id> |
| 80 | 30 |
<determinationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></determinationdate> |
| ... | ... | |
| 82 | 32 |
</taxondetermination> |
| 83 | 33 |
<taxondetermination> |
| 84 | 34 |
<isoriginal>true</isoriginal> |
| 85 |
<plantconcept_id> |
|
| 86 |
<plantconcept> |
|
| 87 |
<plantname_id> |
|
| 88 |
<plantname> |
|
| 89 |
<rank>binomial</rank> |
|
| 90 |
<plantname>$authorplantname</plantname> |
|
| 91 |
</plantname> |
|
| 92 |
</plantname_id> |
|
| 93 |
</plantconcept> |
|
| 94 |
</plantconcept_id> |
|
| 35 |
<plantconcept_id><plantconcept><scientificname>$authorplantname</scientificname></plantconcept></plantconcept_id> |
|
| 95 | 36 |
</taxondetermination> |
| 96 | 37 |
</taxonoccurrence> |
| 97 | 38 |
</locationevent> |
| ... | ... | |
| 99 | 40 |
</path> |
| 100 | 41 |
</_simplifyPath> |
| 101 | 42 |
</VegBIEN> |
| 102 |
Inserted 19 new rows into database |
|
| 43 |
Inserted 18 new rows into database |
|
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 45 | 45 |
<taxondetermination> |
| 46 | 46 |
<plantconcept_id> |
| 47 | 47 |
<plantconcept> |
| 48 |
<plantname_id> |
|
| 49 |
<plantname> |
|
| 50 |
<rank>binomial</rank> |
|
| 51 |
<parent_id> |
|
| 52 |
<plantname> |
|
| 53 |
<rank>authority</rank> |
|
| 54 |
<parent_id> |
|
| 55 |
<plantname> |
|
| 56 |
<rank>subspecies</rank> |
|
| 57 |
<parent_id> |
|
| 58 |
<plantname> |
|
| 59 |
<rank>species</rank> |
|
| 60 |
<plantname>$SpecificEpithet</plantname> |
|
| 61 |
<parent_id> |
|
| 62 |
<plantname> |
|
| 63 |
<rank>genus</rank> |
|
| 64 |
<plantname>$Genus</plantname> |
|
| 65 |
<parent_id> |
|
| 66 |
<plantname> |
|
| 67 |
<rank>family</rank> |
|
| 68 |
<plantname>$Family</plantname> |
|
| 69 |
</plantname> |
|
| 70 |
</parent_id> |
|
| 71 |
</plantname> |
|
| 72 |
</parent_id> |
|
| 73 |
</plantname> |
|
| 74 |
</parent_id> |
|
| 75 |
</plantname> |
|
| 76 |
</parent_id> |
|
| 77 |
</plantname> |
|
| 78 |
</parent_id> |
|
| 79 |
</plantname> |
|
| 80 |
</plantname_id> |
|
| 48 |
<family>$Family</family> |
|
| 49 |
<genus>$Genus</genus> |
|
| 50 |
<species>$SpecificEpithet</species> |
|
| 81 | 51 |
</plantconcept> |
| 82 | 52 |
</plantconcept_id> |
| 83 | 53 |
</taxondetermination> |
| ... | ... | |
| 88 | 58 |
</path> |
| 89 | 59 |
</_simplifyPath> |
| 90 | 60 |
</VegBIEN> |
| 91 |
Inserted 23 new rows into database |
|
| 61 |
Inserted 18 new rows into database |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 33 | 33 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 34 | 34 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 35 | 35 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 36 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 37 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 38 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 39 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 40 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 41 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 42 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 43 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 44 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 45 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 36 |
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 37 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 38 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 39 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 40 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 41 |
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 42 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 43 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 44 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 45 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 46 | 46 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 47 | 47 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 48 | 48 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 230 | 230 |
</party_id> |
| 231 | 231 |
<plantconcept_id> |
| 232 | 232 |
<plantconcept> |
| 233 |
<plantname_id> |
|
| 234 |
<plantname> |
|
| 235 |
<rank>binomial</rank> |
|
| 236 |
<plantname>$ScientificName</plantname> |
|
| 237 |
<parent_id> |
|
| 238 |
<plantname> |
|
| 239 |
<rank>authority</rank> |
|
| 240 |
<plantname>$ScientificNameAuthor</plantname> |
|
| 241 |
<parent_id> |
|
| 242 |
<plantname> |
|
| 243 |
<rank>subspecies</rank> |
|
| 244 |
<plantname>$Subspecies</plantname> |
|
| 245 |
<parent_id> |
|
| 246 |
<plantname> |
|
| 247 |
<rank>species</rank> |
|
| 248 |
<plantname>$Species</plantname> |
|
| 249 |
<parent_id> |
|
| 250 |
<plantname> |
|
| 251 |
<rank>genus</rank> |
|
| 252 |
<plantname>$Genus</plantname> |
|
| 253 |
<parent_id> |
|
| 254 |
<plantname> |
|
| 255 |
<rank>family</rank> |
|
| 256 |
<plantname>$Family</plantname> |
|
| 257 |
<parent_id> |
|
| 258 |
<plantname> |
|
| 259 |
<rank>order</rank> |
|
| 260 |
<plantname>$Order</plantname> |
|
| 261 |
<parent_id> |
|
| 262 |
<plantname> |
|
| 263 |
<rank>class</rank> |
|
| 264 |
<plantname>$Class</plantname> |
|
| 265 |
<parent_id> |
|
| 266 |
<plantname> |
|
| 267 |
<rank>subkingdom</rank> |
|
| 268 |
<plantname>$Phylum</plantname> |
|
| 269 |
<parent_id> |
|
| 270 |
<plantname> |
|
| 271 |
<rank>kingdom</rank> |
|
| 272 |
<plantname>$Kingdom</plantname> |
|
| 273 |
</plantname> |
|
| 274 |
</parent_id> |
|
| 275 |
</plantname> |
|
| 276 |
</parent_id> |
|
| 277 |
</plantname> |
|
| 278 |
</parent_id> |
|
| 279 |
</plantname> |
|
| 280 |
</parent_id> |
|
| 281 |
</plantname> |
|
| 282 |
</parent_id> |
|
| 283 |
</plantname> |
|
| 284 |
</parent_id> |
|
| 285 |
</plantname> |
|
| 286 |
</parent_id> |
|
| 287 |
</plantname> |
|
| 288 |
</parent_id> |
|
| 289 |
</plantname> |
|
| 290 |
</parent_id> |
|
| 291 |
</plantname> |
|
| 292 |
</plantname_id> |
|
| 233 |
<class>$Class</class> |
|
| 234 |
<family>$Family</family> |
|
| 235 |
<genus>$Genus</genus> |
|
| 236 |
<kingdom>$Kingdom</kingdom> |
|
| 237 |
<order>$Order</order> |
|
| 238 |
<phylum>$Phylum</phylum> |
|
| 239 |
<scientificname>$ScientificName</scientificname> |
|
| 240 |
<scientificnameauthor>$ScientificNameAuthor</scientificnameauthor> |
|
| 241 |
<species>$Species</species> |
|
| 242 |
<subspecies>$Subspecies</subspecies> |
|
| 293 | 243 |
</plantconcept> |
| 294 | 244 |
</plantconcept_id> |
| 295 | 245 |
<determinationdate> |
| ... | ... | |
| 382 | 332 |
</path> |
| 383 | 333 |
</_simplifyPath> |
| 384 | 334 |
</VegBIEN> |
| 385 |
Inserted 39 new rows into database |
|
| 335 |
Inserted 30 new rows into database |
|
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 27 | 27 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 28 | 28 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 29 | 29 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 30 |
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 31 |
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 32 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 33 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 34 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 30 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 31 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 32 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 33 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 34 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 35 | 35 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 36 |
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",Often = Genera
|
|
| 37 |
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 36 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/family,
|
|
| 37 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/genus,Often = Genera
|
|
| 38 | 38 |
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 39 | 39 |
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 40 | 40 |
Basal area,,"** No join mapping for Basal area ** Would be basalDiameter, but need formula to translate" |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 78 | 78 |
</party_id> |
| 79 | 79 |
<plantconcept_id> |
| 80 | 80 |
<plantconcept> |
| 81 |
<plantname_id> |
|
| 82 |
<plantname> |
|
| 83 |
<rank>binomial</rank> |
|
| 84 |
<plantname>$Specie+autor</plantname> |
|
| 85 |
<parent_id> |
|
| 86 |
<plantname> |
|
| 87 |
<rank>authority</rank> |
|
| 88 |
<plantname>$Autor (revised)</plantname> |
|
| 89 |
<parent_id> |
|
| 90 |
<plantname> |
|
| 91 |
<rank>subspecies</rank> |
|
| 92 |
<parent_id> |
|
| 93 |
<plantname> |
|
| 94 |
<rank>species</rank> |
|
| 95 |
<plantname>$Specific epithet</plantname> |
|
| 96 |
<parent_id> |
|
| 97 |
<plantname> |
|
| 98 |
<rank>genus</rank> |
|
| 99 |
<plantname>$Genera</plantname> |
|
| 100 |
<parent_id> |
|
| 101 |
<plantname> |
|
| 102 |
<rank>family</rank> |
|
| 103 |
<plantname>$Family (revised)</plantname> |
|
| 104 |
</plantname> |
|
| 105 |
</parent_id> |
|
| 106 |
</plantname> |
|
| 107 |
</parent_id> |
|
| 108 |
</plantname> |
|
| 109 |
</parent_id> |
|
| 110 |
</plantname> |
|
| 111 |
</parent_id> |
|
| 112 |
</plantname> |
|
| 113 |
</parent_id> |
|
| 114 |
</plantname> |
|
| 115 |
</plantname_id> |
|
| 81 |
<family>$Family (revised)</family> |
|
| 82 |
<genus>$Genera</genus> |
|
| 83 |
<scientificname>$Specie+autor</scientificname> |
|
| 84 |
<scientificnameauthor>$Autor (revised)</scientificnameauthor> |
|
| 85 |
<species>$Specific epithet</species> |
|
| 116 | 86 |
</plantconcept> |
| 117 | 87 |
</plantconcept_id> |
| 118 | 88 |
<taxonfit>$Qualifier</taxonfit> |
| ... | ... | |
| 121 | 91 |
<isoriginal>true</isoriginal> |
| 122 | 92 |
<plantconcept_id> |
| 123 | 93 |
<plantconcept> |
| 124 |
<plantname_id> |
|
| 125 |
<plantname> |
|
| 126 |
<rank>binomial</rank> |
|
| 127 |
<parent_id> |
|
| 128 |
<plantname> |
|
| 129 |
<rank>authority</rank> |
|
| 130 |
<parent_id> |
|
| 131 |
<plantname> |
|
| 132 |
<rank>subspecies</rank> |
|
| 133 |
<parent_id> |
|
| 134 |
<plantname> |
|
| 135 |
<rank>species</rank> |
|
| 136 |
<parent_id> |
|
| 137 |
<plantname> |
|
| 138 |
<rank>genus</rank> |
|
| 139 |
<plantname>$Field name</plantname> |
|
| 140 |
<parent_id> |
|
| 141 |
<plantname> |
|
| 142 |
<rank>family</rank> |
|
| 143 |
<plantname>$Field family</plantname> |
|
| 144 |
</plantname> |
|
| 145 |
</parent_id> |
|
| 146 |
</plantname> |
|
| 147 |
</parent_id> |
|
| 148 |
</plantname> |
|
| 149 |
</parent_id> |
|
| 150 |
</plantname> |
|
| 151 |
</parent_id> |
|
| 152 |
</plantname> |
|
| 153 |
</parent_id> |
|
| 154 |
</plantname> |
|
| 155 |
</plantname_id> |
|
| 94 |
<family>$Field family</family> |
|
| 95 |
<genus>$Field name</genus> |
|
| 156 | 96 |
</plantconcept> |
| 157 | 97 |
</plantconcept_id> |
| 158 | 98 |
</taxondetermination> |
| ... | ... | |
| 163 | 103 |
</path> |
| 164 | 104 |
</_simplifyPath> |
| 165 | 105 |
</VegBIEN> |
| 166 |
Inserted 40 new rows into database |
|
| 106 |
Inserted 30 new rows into database |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
collectno,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1, |
| 21 | 21 |
SciName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 22 | 22 |
cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,Ignore other values |
| 23 |
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 24 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 25 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first/_alt/1",
|
|
| 26 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first/_alt/2",
|
|
| 27 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 28 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 29 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 30 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 23 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 24 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 25 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 26 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 27 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 28 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first/_alt/1,
|
|
| 29 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first/_alt/2,
|
|
| 30 |
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 31 | 31 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| 32 | 32 |
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2, |
| 33 | 33 |
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/3, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 102 | 102 |
<taxondetermination> |
| 103 | 103 |
<plantconcept_id> |
| 104 | 104 |
<plantconcept> |
| 105 |
<plantname_id> |
|
| 106 |
<plantname> |
|
| 107 |
<rank>binomial</rank> |
|
| 108 |
<plantname>$SciName</plantname> |
|
| 109 |
<parent_id> |
|
| 110 |
<plantname> |
|
| 111 |
<rank>authority</rank> |
|
| 112 |
<plantname>$authors</plantname> |
|
| 113 |
<parent_id> |
|
| 114 |
<plantname> |
|
| 115 |
<rank>subspecies</rank> |
|
| 116 |
<plantname> |
|
| 117 |
<_name> |
|
| 118 |
<first> |
|
| 119 |
<_alt> |
|
| 120 |
<1>$usdaRank</1> |
|
| 121 |
<2>$infrarank</2> |
|
| 122 |
</_alt> |
|
| 123 |
</first> |
|
| 124 |
<last>$infraname</last> |
|
| 125 |
</_name> |
|
| 126 |
</plantname> |
|
| 127 |
<parent_id> |
|
| 128 |
<plantname> |
|
| 129 |
<rank>species</rank> |
|
| 130 |
<plantname>$species</plantname> |
|
| 131 |
<parent_id> |
|
| 132 |
<plantname> |
|
| 133 |
<rank>genus</rank> |
|
| 134 |
<plantname>$genus</plantname> |
|
| 135 |
<parent_id> |
|
| 136 |
<plantname> |
|
| 137 |
<rank>family</rank> |
|
| 138 |
<plantname>$family</plantname> |
|
| 139 |
</plantname> |
|
| 140 |
</parent_id> |
|
| 141 |
</plantname> |
|
| 142 |
</parent_id> |
|
| 143 |
</plantname> |
|
| 144 |
</parent_id> |
|
| 145 |
</plantname> |
|
| 146 |
</parent_id> |
|
| 147 |
</plantname> |
|
| 148 |
</parent_id> |
|
| 149 |
</plantname> |
|
| 150 |
</plantname_id> |
|
| 105 |
<family>$family</family> |
|
| 106 |
<genus>$genus</genus> |
|
| 107 |
<scientificname>$SciName</scientificname> |
|
| 108 |
<scientificnameauthor>$authors</scientificnameauthor> |
|
| 109 |
<species>$species</species> |
|
| 110 |
<subspecies> |
|
| 111 |
<_name> |
|
| 112 |
<first> |
|
| 113 |
<_alt> |
|
| 114 |
<1>$usdaRank</1> |
|
| 115 |
<2>$infrarank</2> |
|
| 116 |
</_alt> |
|
| 117 |
</first> |
|
| 118 |
<last>$infraname</last> |
|
| 119 |
</_name> |
|
| 120 |
</subspecies> |
|
| 151 | 121 |
</plantconcept> |
| 152 | 122 |
</plantconcept_id> |
| 153 | 123 |
</taxondetermination> |
| ... | ... | |
| 176 | 146 |
</path> |
| 177 | 147 |
</_simplifyPath> |
| 178 | 148 |
</VegBIEN> |
| 179 |
Inserted 22 new rows into database |
|
| 149 |
Inserted 21 new rows into database |
|
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 24 | 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 25 | 25 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 26 | 26 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 27 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 28 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
|
|
| 29 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
|
|
| 30 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 31 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 32 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 33 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 34 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
|
|
| 35 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
|
|
| 36 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
|
|
| 37 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
|
|
| 27 |
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/class,
|
|
| 28 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 29 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 30 |
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/kingdom,
|
|
| 31 |
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/order,
|
|
| 32 |
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/phylum,
|
|
| 33 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 34 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,
|
|
| 35 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 36 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first,
|
|
| 37 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 38 | 38 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 39 | 39 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 40 | 40 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 103 | 103 |
</party_id> |
| 104 | 104 |
<plantconcept_id> |
| 105 | 105 |
<plantconcept> |
| 106 |
<plantname_id> |
|
| 107 |
<plantname> |
|
| 108 |
<rank>binomial</rank> |
|
| 109 |
<plantname>$scientificName</plantname> |
|
| 110 |
<parent_id> |
|
| 111 |
<plantname> |
|
| 112 |
<rank>authority</rank> |
|
| 113 |
<plantname>$scientificNameAuthorship</plantname> |
|
| 114 |
<parent_id> |
|
| 115 |
<plantname> |
|
| 116 |
<rank>subspecies</rank> |
|
| 117 |
<plantname> |
|
| 118 |
<_name> |
|
| 119 |
<first>$taxonRank</first> |
|
| 120 |
<last>$infraspecificEpithet</last> |
|
| 121 |
</_name> |
|
| 122 |
</plantname> |
|
| 123 |
<parent_id> |
|
| 124 |
<plantname> |
|
| 125 |
<rank>species</rank> |
|
| 126 |
<plantname>$specificEpithet</plantname> |
|
| 127 |
<parent_id> |
|
| 128 |
<plantname> |
|
| 129 |
<rank>genus</rank> |
|
| 130 |
<plantname>$genus</plantname> |
|
| 131 |
<parent_id> |
|
| 132 |
<plantname> |
|
| 133 |
<rank>family</rank> |
|
| 134 |
<plantname>$family</plantname> |
|
| 135 |
<parent_id> |
|
| 136 |
<plantname> |
|
| 137 |
<rank>order</rank> |
|
| 138 |
<plantname>$order</plantname> |
|
| 139 |
<parent_id> |
|
| 140 |
<plantname> |
|
| 141 |
<rank>class</rank> |
|
| 142 |
<plantname>$class</plantname> |
|
| 143 |
<parent_id> |
|
| 144 |
<plantname> |
|
| 145 |
<rank>subkingdom</rank> |
|
| 146 |
<plantname>$phylum</plantname> |
|
| 147 |
<parent_id> |
|
| 148 |
<plantname> |
|
| 149 |
<rank>kingdom</rank> |
|
| 150 |
<plantname>$kingdom</plantname> |
|
| 151 |
</plantname> |
|
| 152 |
</parent_id> |
|
| 153 |
</plantname> |
|
| 154 |
</parent_id> |
|
| 155 |
</plantname> |
|
| 156 |
</parent_id> |
|
| 157 |
</plantname> |
|
| 158 |
</parent_id> |
|
| 159 |
</plantname> |
|
| 160 |
</parent_id> |
|
| 161 |
</plantname> |
|
| 162 |
</parent_id> |
|
| 163 |
</plantname> |
|
| 164 |
</parent_id> |
|
| 165 |
</plantname> |
|
| 166 |
</parent_id> |
|
| 167 |
</plantname> |
|
| 168 |
</parent_id> |
|
| 169 |
</plantname> |
|
| 170 |
</plantname_id> |
|
| 106 |
<class>$class</class> |
|
| 107 |
<family>$family</family> |
|
| 108 |
<genus>$genus</genus> |
|
| 109 |
<kingdom>$kingdom</kingdom> |
|
| 110 |
<order>$order</order> |
|
| 111 |
<phylum>$phylum</phylum> |
|
| 112 |
<scientificname>$scientificName</scientificname> |
|
| 113 |
<scientificnameauthor>$scientificNameAuthorship</scientificnameauthor> |
|
| 114 |
<species>$specificEpithet</species> |
|
| 115 |
<subspecies> |
|
| 116 |
<_name> |
|
| 117 |
<first>$taxonRank</first> |
|
| 118 |
<last>$infraspecificEpithet</last> |
|
| 119 |
</_name> |
|
| 120 |
</subspecies> |
|
| 171 | 121 |
</plantconcept> |
| 172 | 122 |
</plantconcept_id> |
| 173 | 123 |
<determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate> |
| ... | ... | |
| 190 | 140 |
</path> |
| 191 | 141 |
</_simplifyPath> |
| 192 | 142 |
</VegBIEN> |
| 193 |
Inserted 39 new rows into database |
|
| 143 |
Inserted 26 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 56 | 56 |
individual_code,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 57 | 57 |
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
| 58 | 58 |
OBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 59 |
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: This is the author of the scientificName.
|
|
| 60 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
|
|
| 61 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
|
|
| 62 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 63 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 64 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 59 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 60 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 61 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificnameauthor,Brad: This is the author of the scientificName.
|
|
| 62 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 63 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/first,
|
|
| 64 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/subspecies/_name/last,
|
|
| 65 | 65 |
cf_aff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank." |
| 66 |
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",Brad: OMIT
|
|
| 67 |
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",Brad: OMIT
|
|
| 66 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/family,Brad: OMIT
|
|
| 67 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/species,Brad: OMIT
|
|
| 68 | 68 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,Brad: See comment above |
| 69 | 69 |
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 70 | 70 |
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 154 | 154 |
<taxondetermination> |
| 155 | 155 |
<plantconcept_id> |
| 156 | 156 |
<plantconcept> |
| 157 |
<plantname_id> |
|
| 158 |
<plantname> |
|
| 159 |
<rank>binomial</rank> |
|
| 160 |
<parent_id> |
|
| 161 |
<plantname> |
|
| 162 |
<rank>authority</rank> |
|
| 163 |
<plantname>$specific_authority</plantname> |
|
| 164 |
<parent_id> |
|
| 165 |
<plantname> |
|
| 166 |
<rank>subspecies</rank> |
|
| 167 |
<plantname> |
|
| 168 |
<_name> |
|
| 169 |
<first>$infra_rank_1</first> |
|
| 170 |
<last>$infra_ep_1</last> |
|
| 171 |
</_name> |
|
| 172 |
</plantname> |
|
| 173 |
<parent_id> |
|
| 174 |
<plantname> |
|
| 175 |
<rank>species</rank> |
|
| 176 |
<plantname>$specific_epithet</plantname> |
|
| 177 |
<parent_id> |
|
| 178 |
<plantname> |
|
| 179 |
<rank>genus</rank> |
|
| 180 |
<plantname>$genus</plantname> |
|
| 181 |
<parent_id> |
|
| 182 |
<plantname> |
|
| 183 |
<rank>family</rank> |
|
| 184 |
<plantname>$family</plantname> |
|
| 185 |
</plantname> |
|
| 186 |
</parent_id> |
|
| 187 |
</plantname> |
|
| 188 |
</parent_id> |
|
| 189 |
</plantname> |
|
| 190 |
</parent_id> |
|
| 191 |
</plantname> |
|
| 192 |
</parent_id> |
|
| 193 |
</plantname> |
|
| 194 |
</parent_id> |
|
| 195 |
</plantname> |
|
| 196 |
</plantname_id> |
|
| 157 |
<family>$family</family> |
|
| 158 |
<genus>$genus</genus> |
|
| 159 |
<scientificnameauthor>$specific_authority</scientificnameauthor> |
|
| 160 |
<species>$specific_epithet</species> |
|
| 161 |
<subspecies> |
|
| 162 |
<_name> |
|
| 163 |
<first>$infra_rank_1</first> |
|
| 164 |
<last>$infra_ep_1</last> |
|
| 165 |
</_name> |
|
| 166 |
</subspecies> |
|
| 197 | 167 |
</plantconcept> |
| 198 | 168 |
</plantconcept_id> |
| 199 | 169 |
<taxonfit>$cf_aff</taxonfit> |
| ... | ... | |
| 202 | 172 |
<isoriginal>true</isoriginal> |
| 203 | 173 |
<plantconcept_id> |
| 204 | 174 |
<plantconcept> |
| 205 |
<plantname_id> |
|
| 206 |
<plantname> |
|
| 207 |
<rank>binomial</rank> |
|
| 208 |
<parent_id> |
|
| 209 |
<plantname> |
|
| 210 |
<rank>authority</rank> |
|
| 211 |
<parent_id> |
|
| 212 |
<plantname> |
|
| 213 |
<rank>subspecies</rank> |
|
| 214 |
<parent_id> |
|
| 215 |
<plantname> |
|
| 216 |
<rank>species</rank> |
|
| 217 |
<plantname>$orig_species</plantname> |
|
| 218 |
<parent_id> |
|
| 219 |
<plantname> |
|
| 220 |
<rank>genus</rank> |
|
| 221 |
<parent_id> |
|
| 222 |
<plantname> |
|
| 223 |
<rank>family</rank> |
|
| 224 |
<plantname>$orig_family</plantname> |
|
| 225 |
</plantname> |
|
| 226 |
</parent_id> |
|
| 227 |
</plantname> |
|
| 228 |
</parent_id> |
|
| 229 |
</plantname> |
|
| 230 |
</parent_id> |
|
| 231 |
</plantname> |
|
| 232 |
</parent_id> |
|
| 233 |
</plantname> |
|
| 234 |
</parent_id> |
|
| 235 |
</plantname> |
|
| 236 |
</plantname_id> |
|
| 175 |
<family>$orig_family</family> |
|
| 176 |
<species>$orig_species</species> |
|
| 237 | 177 |
</plantconcept> |
| 238 | 178 |
</plantconcept_id> |
| 239 | 179 |
</taxondetermination> |
| ... | ... | |
| 271 | 211 |
</path> |
| 272 | 212 |
</_simplifyPath> |
| 273 | 213 |
</VegBIEN> |
| 274 |
Inserted 51 new rows into database |
|
| 214 |
Inserted 43 new rows into database |
|
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 12 | 12 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 13 | 13 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 14 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
|
|
| 14 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/scientificname,
|
|
| 15 | 15 |
confidentialityStatus,,** No join mapping for confidentialityStatus ** |
| 16 | 16 |
realLatitude,,** No join mapping for OMIT ** |
| 17 | 17 |
realLongitude,,** No join mapping for OMIT ** |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 40 | 40 |
<taxonoccurrence> |
| 41 | 41 |
<aggregateoccurrence><cover>$%cover</cover></aggregateoccurrence> |
| 42 | 42 |
<authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode> |
| 43 |
<taxondetermination> |
|
| 44 |
<plantconcept_id> |
|
| 45 |
<plantconcept> |
|
| 46 |
<plantname_id> |
|
| 47 |
<plantname> |
|
| 48 |
<rank>binomial</rank> |
|
| 49 |
<plantname>$currentTaxonName sec Weakley 2006</plantname> |
|
| 50 |
</plantname> |
|
| 51 |
</plantname_id> |
|
| 52 |
</plantconcept> |
|
| 53 |
</plantconcept_id> |
|
| 54 |
</taxondetermination> |
|
| 43 |
<taxondetermination><plantconcept_id><plantconcept><scientificname>$currentTaxonName sec Weakley 2006</scientificname></plantconcept></plantconcept_id></taxondetermination> |
|
| 55 | 44 |
</taxonoccurrence> |
| 56 | 45 |
</locationevent> |
| 57 | 46 |
</location> |
| 58 | 47 |
</path> |
| 59 | 48 |
</_simplifyPath> |
| 60 | 49 |
</VegBIEN> |
| 61 |
Inserted 16 new rows into database |
|
| 50 |
Inserted 14 new rows into database |
|
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 12 | 12 |
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 13 | 13 |
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 14 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
|
|
| 15 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
|
|
| 16 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
|
|
| 14 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/family,
|
|
| 15 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/genus,
|
|
| 16 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/species,
|
|
| 17 | 17 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 18 | 18 |
locality,/location/locationnarrative/_merge/1, |
| 19 | 19 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 82 | 82 |
<taxondetermination> |
| 83 | 83 |
<plantconcept_id> |
| 84 | 84 |
<plantconcept> |
| 85 |
<plantname_id> |
|
| 86 |
<plantname> |
|
| 87 |
<rank>binomial</rank> |
|
| 88 |
<parent_id> |
|
| 89 |
<plantname> |
|
| 90 |
<rank>authority</rank> |
|
| 91 |
<parent_id> |
|
| 92 |
<plantname> |
|
| 93 |
<rank>subspecies</rank> |
|
| 94 |
<parent_id> |
|
| 95 |
<plantname> |
|
| 96 |
<rank>species</rank> |
|
| 97 |
<plantname>$specificEpithet</plantname> |
|
| 98 |
<parent_id> |
|
| 99 |
<plantname> |
|
| 100 |
<rank>genus</rank> |
|
| 101 |
<plantname>$genus</plantname> |
|
| 102 |
<parent_id> |
|
| 103 |
<plantname> |
|
| 104 |
<rank>family</rank> |
|
| 105 |
<plantname>$family</plantname> |
|
| 106 |
</plantname> |
|
| 107 |
</parent_id> |
|
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Taxonomic names: Remapped to new denormalized fields in plantconcept