Project

General

Profile

« Previous | Next » 

Revision 7305

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: taxondetermination_set_iscurrent(): Changed TNRS determinationtype from computer to matched, to allow for a separate accepted determinationtype

View differences:

inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
31 31 
Source,*Source,,
32 32 
Warnings,*Warnings,,
33 33 
:true,taxonIsCanonical,,"This table contains only canonicalized names. (Not all names are accepted, but those that aren’t don’t (yet) have an accepted match.)"
34 
:computer,identificationType,,
34 
:matched,identificationType,,
35 35 
:_,dateIdentified,/_now,
36 36 
:0,taxonOccurrenceID,,Enables the taxonoccurrence CHECK constraint to pass
inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
46 46 
Specific_epithet_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/3",
47 47 
Overall_score,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/then/taxonfit/_max/4",Assuming is a fraction based on the range of values
48 48 
:_,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value/_now,
49 
:computer,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,
49 
:matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype,
50 50 
taxonoccurrence_id,/location/locationevent/taxonoccurrence/taxonoccurrence_id,
51 51 
Annotations,,** No join mapping for *Annotations **
52 52 
Author_score,,** No join mapping for *Author_score **
inputs/.TNRS/public.unscrubbed_taxondetermination_view/test.xml.ref
127 127 
                                        </_max>
128 128 
                                    </taxonfit>
129 129 
                                    <determinationdate><_dateRangeStart><value><_now>_</_now></value></_dateRangeStart></determinationdate>
130 
                                    <determinationtype>computer</determinationtype>
130 
                                    <determinationtype>matched</determinationtype>
131 131 
                                </taxondetermination>
132 132 
                                <taxonoccurrence_id>$taxonoccurrence_id</taxonoccurrence_id>
133 133 
                            </taxonoccurrence>
schemas/vegbien.sql
1070 1070 
        WHERE taxonoccurrence_id = taxonoccurrence_id_
1071 1071 
        ORDER BY
1072 1072 
            -- Scrubbed determinations must come first for scrub.make to work
1073 
            COALESCE(determinationtype = 'computer', false) DESC/*true first*/
1073 
            COALESCE(determinationtype = 'matched', false) DESC/*true first*/
1074 1074 
            , isoriginal/*false first*/
1075 1075 
            , determinationdate DESC NULLS LAST
1076 1076 
        LIMIT 1

Also available in: Unified diff