Revision 7476
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv | ||
|---|---|---|
| 70 | 70 |
Accepted_name.Name_matched_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank/_first/2", |
| 71 | 71 |
Accepted_name.Accepted_name_rank,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/*_id/taxonverbatim/verbatimrank/_first/3", |
| 72 | 72 |
:_,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value/_now", |
| 73 |
Family_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/1",
|
|
| 74 |
Genus_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/2",
|
|
| 75 |
Specific_epithet_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/3",
|
|
| 76 |
Max_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/4/_first/1",
|
|
| 77 |
Overall_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/4/_first/2",Assuming is a fraction based on the range of values
|
|
| 73 |
Family_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/1",
|
|
| 74 |
Genus_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/2",
|
|
| 75 |
Specific_epithet_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/3",
|
|
| 76 |
Max_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/4/_first/1",
|
|
| 77 |
Overall_score,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/4/_first/2",Assuming is a fraction based on the range of values
|
|
| 78 | 78 |
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3", |
| 79 | 79 |
:0,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass |
| 80 | 80 |
:0,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,Enables the taxonoccurrence CHECK constraint to pass |
| ... | ... | |
| 111 | 111 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 112 | 112 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 113 | 113 |
:0,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists",Enables the taxonoccurrence CHECK constraint to pass |
| 114 |
Family_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/1",
|
|
| 115 |
Genus_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/2",
|
|
| 116 |
Specific_epithet_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/3",
|
|
| 117 |
Max_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/4/_first/1",
|
|
| 118 |
Overall_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/4/_first/2",Assuming is a fraction based on the range of values
|
|
| 114 |
Family_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/1",
|
|
| 115 |
Genus_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/2",
|
|
| 116 |
Specific_epithet_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/3",
|
|
| 117 |
Max_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/4/_first/1",
|
|
| 118 |
Overall_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/4/_first/2",Assuming is a fraction based on the range of values
|
|
| 119 | 119 |
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now, |
| 120 | 120 |
:matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype, |
| 121 | 121 |
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id, |
| inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref | ||
|---|---|---|
| 149 | 149 |
</taxonverbatim> |
| 150 | 150 |
</taxonverbatim_id> |
| 151 | 151 |
<determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate> |
| 152 |
<taxonfit>
|
|
| 152 |
<taxonconfidence>
|
|
| 153 | 153 |
<_max> |
| 154 | 154 |
<1>$Family_score</1> |
| 155 | 155 |
<2>$Genus_score</2> |
| 156 | 156 |
<3>$Specific_epithet_score</3> |
| 157 | 157 |
<4>$Max_score</4> |
| 158 | 158 |
</_max> |
| 159 |
</taxonfit>
|
|
| 159 |
</taxonconfidence>
|
|
| 160 | 160 |
</taxondetermination> |
| 161 | 161 |
<sourceaccessioncode>0</sourceaccessioncode> |
| 162 | 162 |
<taxondetermination> |
| ... | ... | |
| 255 | 255 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
| 256 | 256 |
</taxonverbatim> |
| 257 | 257 |
</taxonverbatim_id> |
| 258 |
<taxonfit>
|
|
| 258 |
<taxonconfidence>
|
|
| 259 | 259 |
<_max> |
| 260 | 260 |
<1>$Family_score</1> |
| 261 | 261 |
<2>$Genus_score</2> |
| 262 | 262 |
<3>$Specific_epithet_score</3> |
| 263 | 263 |
<4>$Max_score</4> |
| 264 | 264 |
</_max> |
| 265 |
</taxonfit>
|
|
| 265 |
</taxonconfidence>
|
|
| 266 | 266 |
<determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate> |
| 267 | 267 |
<determinationtype>matched</determinationtype> |
| 268 | 268 |
</taxondetermination> |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 146 | 146 |
monthIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 147 | 147 |
yearIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 148 | 148 |
taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes", |
| 149 |
matchedFamilyFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/1", |
|
| 150 |
matchedGenusFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/2", |
|
| 151 |
matchedSpeciesFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/3", |
|
| 152 |
matchedTaxonFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonconfidence/_max/4", |
|
| 149 | 153 |
identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit", |
| 150 |
matchedFamilyFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/1", |
|
| 151 |
matchedGenusFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/2", |
|
| 152 |
matchedSpeciesFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/3", |
|
| 153 |
matchedTaxonFit_fraction,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit/_max/4", |
|
| 154 | 154 |
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1, |
| 155 | 155 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 156 | 156 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 285 | 285 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| 286 | 286 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 287 | 287 |
taxonOccurrenceID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 288 |
matchedFamilyFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/1",
|
|
| 289 |
matchedGenusFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/2",
|
|
| 290 |
matchedSpeciesFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/3",
|
|
| 291 |
matchedTaxonFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/4",
|
|
| 288 |
matchedFamilyFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/1",
|
|
| 289 |
matchedGenusFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/2",
|
|
| 290 |
matchedSpeciesFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/3",
|
|
| 291 |
matchedTaxonFit_fraction,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonconfidence/_max/4",
|
|
| 292 | 292 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value, |
| 293 | 293 |
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 294 | 294 |
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 146 | 146 |
monthIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate", |
| 147 | 147 |
yearIdentified,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/determinationdate", |
| 148 | 148 |
taxonRemarks,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/notes", |
| 149 |
matchedFamilyFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonconfidence", |
|
| 150 |
matchedGenusFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonconfidence", |
|
| 151 |
matchedSpeciesFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonconfidence", |
|
| 152 |
matchedTaxonFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonconfidence", |
|
| 149 | 153 |
identificationQualifier,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit", |
| 150 |
matchedFamilyFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit", |
|
| 151 |
matchedGenusFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit", |
|
| 152 |
matchedSpeciesFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit", |
|
| 153 |
matchedTaxonFit_fraction,"//locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination/taxonfit", |
|
| 154 | 154 |
dateCollected,//aggregateoccurrence/collectiondate, |
| 155 | 155 |
dayCollected,//aggregateoccurrence/collectiondate, |
| 156 | 156 |
monthCollected,//aggregateoccurrence/collectiondate, |
| ... | ... | |
| 285 | 285 |
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/taxonomicname, |
| 286 | 286 |
taxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/verbatimrank, |
| 287 | 287 |
taxonOccurrenceID,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 288 |
matchedFamilyFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonfit",
|
|
| 289 |
matchedGenusFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonfit",
|
|
| 290 |
matchedSpeciesFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonfit",
|
|
| 291 |
matchedTaxonFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonfit",
|
|
| 288 |
matchedFamilyFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonconfidence",
|
|
| 289 |
matchedGenusFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonconfidence",
|
|
| 290 |
matchedSpeciesFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonconfidence",
|
|
| 291 |
matchedTaxonFit_fraction,"//taxonoccurrence/taxondetermination/_if[@name=""if has taxondetermination""]/then/taxonconfidence",
|
|
| 292 | 292 |
dateIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
| 293 | 293 |
dayIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
| 294 | 294 |
monthIdentified,//taxonoccurrence/taxondetermination[]/determinationdate, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: matched*Fit_fraction: Remapped to taxonconfidence instead of taxonfit