Project

General

Profile

« Previous | Next » 

Revision 10690

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: inputs/VegBank/taxonobservation_/map.csv: updated input column names for renamings in inputs/VegBank/vegbank.~.clean_up.sql

View differences:

inputs/VegBank/taxonobservation_/map.csv
43 43 
taxoninterpretation_accessioncode,*taxoninterpretation_accessioncode,,
44 44 
plantname_id,*plantname_id,,
45 45 
plantconcept_reference_id,*plantconcept_reference_id,,
46 
plantname,scientificName,/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
46 
plantconcept_plantname,scientificName,/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
47 47 
plantcode,*plantcode,,
48 48 
plantdescription,*plantdescription,,
49 49 
d_obscount,*d_obscount,,
inputs/VegBank/taxonobservation_/VegBIEN.csv
22 22 
collectionnumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
23 23 
int_origplantscinamenoauth,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",
24 24 
int_currplantscifull,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2/_alt/1",
25 
plantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2/_alt/2/_alt/1","when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
25 
plantconcept_plantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2/_alt/2/_alt/1","when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
26 26 
plantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2/_alt/2/_alt/2",
27 27 
int_currplantscinamenoauth,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
28 28 
collectionnumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
35 35 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
36 36 
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
37 37 
int_currplantscifull,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_alt/1,
38 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
38 
plantconcept_plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
39 39 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1/_alt/2/_alt/2,
40 40 
int_currplantscinamenoauth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
41 41 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,includes genus author
......
43 43 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,includes genus author
44 44 
int_currplantscinamenoauth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
45 45 
int_currplantscifull,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname/_alt/1,
46 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
46 
plantconcept_plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
47 47 
plantname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname/_alt/2/_alt/2,
48 48 
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists",
49 49 
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,
inputs/VegBank/taxonobservation_/test.xml.ref
102 102 
                                                                            <1>$int_currplantscifull</1>
103 103 
                                                                            <2>
104 104 
                                                                                <_alt>
105 
                                                                                    <1>$plantname</1>
105 
                                                                                    <1>$plantconcept_plantname</1>
106 106 
                                                                                    <2>$plantname</2>
107 107 
                                                                                </_alt>
108 108 
                                                                            </2>
......
128 128 
                                                    <1>$int_currplantscifull</1>
129 129 
                                                    <2>
130 130 
                                                        <_alt>
131 
                                                            <1>$plantname</1>
131 
                                                            <1>$plantconcept_plantname</1>
132 132 
                                                            <2>$plantname</2>
133 133 
                                                        </_alt>
134 134 
                                                    </2>
inputs/VegBank/taxonobservation_/new_terms.csv
7 7 
int_currplantcommon,vernacularName,,
8 8 
interpretationdate,dateIdentified,,
9 9 
collectiondate,dateCollected,,
10 
plantname,scientificName,/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
10 
plantconcept_plantname,scientificName,/_alt/2/_alt/1,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
11 11 
plantname,scientificName,/_alt/2/_alt/2,

Also available in: Unified diff