Project

General

Profile

« Previous | Next » 

Revision 5509

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: Renamed _set_matched_taxonconcept() to _taxonconcept_set_matched_concept_id() so that the function name is prefixed with the table it applies to

View differences:

inputs/.TNRS/tnrs/VegBIEN.csv
10 10 
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
11 11 
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
12 12 
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name
13 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/author,
14 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/family,
15 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
16 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
17 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
18 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,
19 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonname",
20 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
21 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/rank,
22 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
23 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/rank,
24 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/taxonomicname,
25 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/verbatimrank,
13 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/author,
14 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/family,
15 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
16 
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,
17 
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
18 
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,
19 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonname",
20 
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
21 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/rank,
22 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/verbatimrank,
23 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/rank,
24 
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/taxonomicname,
25 
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/verbatimrank,
26 26 
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Contains author based on matched name
27 27 
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,Contains family based on matched name
28 28 
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
inputs/.TNRS/tnrs/test.xml.ref
37 37 
                                            <2>$Name_matched_author</2>
38 38 
                                        </_join_words>
39 39 
                                    </identifyingtaxonomicname>
40 
                                    <_set_matched_taxonconcept>
40 
                                    <_taxonconcept_set_matched_concept_id>
41 41 
                                        <matched_concept_id>
42 42 
                                            <taxonconcept>
43 43 
                                                <author>$Accepted_name_author</author>
......
112 112 
                                                <verbatimrank>$Accepted_name_rank</verbatimrank>
113 113 
                                            </taxonconcept>
114 114 
                                        </matched_concept_id>
115 
                                    </_set_matched_taxonconcept>
115 
                                    </_taxonconcept_set_matched_concept_id>
116 116 
                                    <author>$Name_matched_author</author>
117 117 
                                    <family>$Name_matched_accepted_family</family>
118 118 
                                    <genus>$Genus_matched</genus>
schemas/vegbien.my.sql
110 110 

  		




  111
  111
  
    

  		




  112
  112
  
    
--


  		




  113
  
  
    
-- Name: _set_matched_taxonconcept(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -


  		




  
  113
  
    
-- Name: _taxonconcept_set_matched_concept_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -


  		




  114
  114
  
    
--


  		




  115
  115
  
    

  		




  116
  116
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  261
  261
  
    

  		




  262
  262
  
    

  		




  263
  263
  
    
--


  		




  264
  
  
    
-- Name: _set_matched_taxonconcept(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: -


  		




  
  264
  
    
-- Name: _taxonconcept_set_matched_concept_id(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: -


  		




  265
  265
  
    
--


  		




  266
  266
  
    

  		




  267
  
  
    
CREATE FUNCTION _set_matched_taxonconcept(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer


  		




  
  267
  
    
CREATE FUNCTION _taxonconcept_set_matched_concept_id(taxonconcept_id integer, matched_concept_id integer, matched_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer


  		




  268
  268
  
    
    LANGUAGE sql


  		




  269
  269
  
    
    AS $_$


  		




  270
  270
  
    
UPDATE taxonconcept SET


  		












  

    
      mappings/VegCore-VegBIEN.csv
    
  





  149
  149
  
    
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",


  		




  150
  150
  
    
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/9/_join_words:[1=""cult. ""]/2",


  		




  151
  151
  
    
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",


  		




  152
  
  
    
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/author,


  		




  153
  
  
    
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/family,


  		




  154
  
  
    
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/genus,


  		




  155
  
  
    
acceptedScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/1,


  		




  156
  
  
    
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,


  		




  157
  
  
    
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,


  		




  158
  
  
    
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,


  		




  159
  
  
    
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,


  		




  160
  
  
    
acceptedSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,


  		




  161
  
  
    
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  162
  
  
    
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  163
  
  
    
acceptedInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,


  		




  164
  
  
    
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",


  		




  165
  
  
    
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",


  		




  166
  
  
    
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",


  		




  167
  
  
    
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,


  		




  168
  
  
    
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=cultivar]/taxonname",


  		




  169
  
  
    
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname",


  		




  170
  
  
    
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname",


  		




  171
  
  
    
acceptedSubspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",


  		




  172
  
  
    
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",


  		




  173
  
  
    
acceptedGenus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",


  		




  174
  
  
    
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonname",


  		




  175
  
  
    
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",


  		




  176
  
  
    
acceptedOrder,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",


  		




  177
  
  
    
acceptedClass,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",


  		




  178
  
  
    
acceptedPhylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",


  		




  179
  
  
    
acceptedKingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",


  		




  180
  
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/rank,


  		




  181
  
  
    
acceptedInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/taxonname,


  		




  182
  
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/parent_id/taxonconcept/verbatimrank,


  		




  183
  
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/rank,


  		




  184
  
  
    
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/species,


  		




  185
  
  
    
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/taxonomicname,


  		




  186
  
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_matched_taxonconcept/matched_concept_id/taxonconcept/verbatimrank,


  		




  
  152
  
    
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/author,


  		




  
  153
  
    
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/family,


  		




  
  154
  
    
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/genus,


  		




  
  155
  
    
acceptedScientificNameWithAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/1,


  		




  
  156
  
    
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,


  		




  
  157
  
    
acceptedFamily,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,


  		




  
  158
  
    
acceptedGenus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,


  		




  
  159
  
    
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,


  		




  
  160
  
    
acceptedSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4,


  		




  
  161
  
    
acceptedInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",


  		




  
  162
  
    
acceptedTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",


  		




  
  163
  
    
acceptedInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,


  		




  
  164
  
    
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",


  		




  
  165
  
    
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",


  		




  
  166
  
    
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2",


  		




  
  167
  
    
acceptedScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2,


  		




  
  168
  
    
acceptedCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=cultivar]/taxonname",


  		




  
  169
  
    
acceptedForma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname",


  		




  
  170
  
    
acceptedVariety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname",


  		




  
  171
  
    
acceptedSubspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",


  		




  
  172
  
    
acceptedSpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",


  		




  
  173
  
    
acceptedGenus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",


  		




  
  174
  
    
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonname",


  		




  
  175
  
    
acceptedFamily,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",


  		




  
  176
  
    
acceptedOrder,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",


  		




  
  177
  
    
acceptedClass,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",


  		




  
  178
  
    
acceptedPhylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",


  		




  
  179
  
    
acceptedKingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",


  		




  
  180
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/rank,


  		




  
  181
  
    
acceptedInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/taxonname,


  		




  
  182
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/verbatimrank,


  		




  
  183
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/rank,


  		




  
  184
  
    
acceptedSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/species,


  		




  
  185
  
    
acceptedScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/taxonomicname,


  		




  
  186
  
    
acceptedTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/verbatimrank,


  		




  187
  187
  
    
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,


  		




  188
  188
  
    
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/givenname/_namePart/first,


  		




  189
  189
  
    
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/middlename/_namePart/middle,


  		












Also available in:  Unified diff