Project

General

Profile

« Previous | Next » 

Revision 6881

Added inputs/bien2_traits/

View differences:

inputs/bien2_traits/TraitObservation/header.csv
1
TraitObservationID,TaxonomyID,Family,Genus,SpecificEpithet,InfraspecificRank,InfraspecificEpithet,Taxon,AuthorOfScientificName,Habit,TraitName,TraitValue,Unit,Method,Region,Country,StateProvince,LowerPolitical,LocalityDescription,VerbatimLatitude,VerbatimLongitude,VerbatimElevation,Source,URLSource,SourceCitation,SourceID,VisitingDate,ReferenceID,Access,Project_PI,Project_PI_contact,Observation,Authorship,AuthorshipContact,TaxonomyID_index,Family_index,Taxon_index,TraitName_index,ReferenceID_index
inputs/bien2_traits/TraitObservation/map.csv
1
bien2_traits,VegCore,Filter,Comments
2
TraitObservationID,occurrenceID,,
3
TaxonomyID,UNUSED,,Always 0
4
Family,family,,
5
Genus,genus,,
6
SpecificEpithet,specificEpithet,,
7
InfraspecificRank,taxonRank,,
8
InfraspecificEpithet,infraspecificEpithet,,
9
Taxon,taxonName,,
10
AuthorOfScientificName,scientificNameAuthorship,,
11
Habit,growthForm,,
12
TraitName,measurementType,,
13
TraitValue,measurementValue,,
14
Unit,measurementUnit,,
15
Method,Method,,
16
Region,*Region,,
17
Country,country,,
18
StateProvince,stateProvince,,
19
LowerPolitical,*LowerPolitical,,
20
LocalityDescription,verbatimLocality,,
21
VerbatimLatitude,verbatimLatitude,,
22
VerbatimLongitude,verbatimLongitude,,
23
VerbatimElevation,verbatimElevation,,
24
Source,OMIT,,There isn't a mapping for this yet
25
URLSource,*URLSource,,
26
SourceCitation,*SourceCitation,,
27
SourceID,*SourceID,,
28
VisitingDate,*VisitingDate,,
29
ReferenceID,*ReferenceID,,
30
Access,*Access,,
31
Project_PI,*Project_PI,,
32
Project_PI_contact,*Project_PI_contact,,
33
Observation,*Observation,,
34
Authorship,*Authorship,,
35
AuthorshipContact,*AuthorshipContact,,
36
TaxonomyID_index,OMIT,,
37
Family_index,OMIT,,
38
Taxon_index,OMIT,,
39
TraitName_index,OMIT,,
40
ReferenceID_index,OMIT,,
inputs/bien2_traits/TraitObservation/VegBIEN.csv
1
bien2_traits,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2
TraitObservationID,"/_if[@name=""if specimen""]/cond/_exists",
3
TraitObservationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/1",
4
TraitObservationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
5
VerbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
6
TraitObservationID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
7
LocalityDescription,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2,
8
TraitObservationID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
9
TraitObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
10
Taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
11
Habit,/location/locationevent/taxonoccurrence/growthform,
12
TraitObservationID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
13
TraitObservationID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
14
Taxon,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1",
15
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value",
16
Taxon,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
17
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
18
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
19
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
20
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
21
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
22
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",
23
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
24
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
25
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
26
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
27
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
28
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
29
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
30
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
31
InfraspecificRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
32
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
33
Taxon,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/null/_first/1,
34
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value,
35
Taxon,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
36
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
37
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
38
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
39
InfraspecificRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
40
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
41
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
42
TraitName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/trait/name,
43
Unit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/trait/units,
44
TraitValue,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/trait/value,
45
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,
46
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
47
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
48
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
49
Taxon,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
50
InfraspecificRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
51
LocalityDescription,/location/locationnarrative/_merge/2,
52
VerbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
53
VerbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
54
Country,/location/locationplace/*_id/place/country,
55
Country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
56
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
57
StateProvince,/location/locationplace/*_id/place/stateprovince,
58
VerbatimElevation,/location/verbatimelevation,
59
Access,,** No join mapping for *Access ** 
60
Authorship,,** No join mapping for *Authorship ** 
61
AuthorshipContact,,** No join mapping for *AuthorshipContact ** 
62
Family_index,,** No non-empty join mapping for OMIT ** 
63
LowerPolitical,,** No join mapping for *LowerPolitical ** 
64
Method,,** No join mapping for Method ** 
65
Observation,,** No join mapping for *Observation ** 
66
Project_PI,,** No join mapping for *Project_PI ** 
67
Project_PI_contact,,** No join mapping for *Project_PI_contact ** 
68
ReferenceID,,** No join mapping for *ReferenceID ** 
69
ReferenceID_index,,** No non-empty join mapping for OMIT ** 
70
Region,,** No join mapping for *Region ** 
71
Source,,** No non-empty join mapping for OMIT ** There isn't a mapping for this yet
72
SourceCitation,,** No join mapping for *SourceCitation ** 
73
SourceID,,** No join mapping for *SourceID ** 
74
Taxon_index,,** No non-empty join mapping for OMIT ** 
75
TaxonomyID,,** No non-empty join mapping for UNUSED ** Always 0
76
TaxonomyID_index,,** No non-empty join mapping for OMIT ** 
77
TraitName_index,,** No non-empty join mapping for OMIT ** 
78
URLSource,,** No join mapping for *URLSource ** 
79
VisitingDate,,** No join mapping for *VisitingDate ** 
inputs/bien2_traits/TraitObservation/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>bien2_traits</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <authorlocationcode>$TraitObservationID</authorlocationcode>
11
                        <elevation_m>
12
                            <_units>
13
                                <to>m</to>
14
                                <to></to>
15
                                <value>$VerbatimElevation</value>
16
                            </_units>
17
                        </elevation_m>
18
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
19
                        <locationevent>
20
                            <taxonoccurrence>
21
                                <aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$TraitObservationID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
22
                                <growthform>$Habit</growthform>
23
                                <sourceaccessioncode>$TraitObservationID</sourceaccessioncode>
24
                                <taxondetermination>
25
                                    <taxonverbatim_id>
26
                                        <taxonverbatim>
27
                                            <taxonlabel_id>
28
                                                <taxonlabel>
29
                                                    <matched_label_id>
30
                                                        <taxonlabel>
31
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
32
                                                            <taxonomicname>
33
                                                                <_join_words>
34
                                                                    <1>
35
                                                                        <_taxon_family_require_std>
36
                                                                            <family>
37
                                                                                <_nullIf>
38
                                                                                    <null>$Taxon</null>
39
                                                                                    <value>$Family</value>
40
                                                                                </_nullIf>
41
                                                                            </family>
42
                                                                        </_taxon_family_require_std>
43
                                                                    </1>
44
                                                                    <2>
45
                                                                        <_join_words>
46
                                                                            <1>
47
                                                                                <_alt>
48
                                                                                    <1>$Taxon</1>
49
                                                                                    <2>
50
                                                                                        <_join_words>
51
                                                                                            <2>$Genus</2>
52
                                                                                            <3>$SpecificEpithet</3>
53
                                                                                            <5>
54
                                                                                                <_join_words>
55
                                                                                                    <1>
56
                                                                                                        <_if name="if has infraspecificEpithet">
57
                                                                                                            <cond>$InfraspecificEpithet</cond>
58
                                                                                                            <then>$InfraspecificRank</then>
59
                                                                                                        </_if>
60
                                                                                                    </1>
61
                                                                                                    <2>$InfraspecificEpithet</2>
62
                                                                                                </_join_words>
63
                                                                                            </5>
64
                                                                                        </_join_words>
65
                                                                                    </2>
66
                                                                                </_alt>
67
                                                                            </1>
68
                                                                            <2>$AuthorOfScientificName</2>
69
                                                                        </_join_words>
70
                                                                    </2>
71
                                                                </_join_words>
72
                                                            </taxonomicname>
73
                                                        </taxonlabel>
74
                                                    </matched_label_id>
75
                                                    <parent_id>
76
                                                        <taxonlabel>
77
                                                            <rank>$InfraspecificRank</rank>
78
                                                            <taxonverbatim><verbatimrank>$InfraspecificRank</verbatimrank></taxonverbatim>
79
                                                            <parent_id>
80
                                                                <taxonlabel>
81
                                                                    <rank>cultivar</rank>
82
                                                                    <parent_id>
83
                                                                        <taxonlabel>
84
                                                                            <rank>forma</rank>
85
                                                                            <parent_id>
86
                                                                                <taxonlabel>
87
                                                                                    <rank>variety</rank>
88
                                                                                    <parent_id>
89
                                                                                        <taxonlabel>
90
                                                                                            <rank>subspecies</rank>
91
                                                                                            <parent_id>
92
                                                                                                <taxonlabel>
93
                                                                                                    <rank>species</rank>
94
                                                                                                    <taxonepithet>$SpecificEpithet</taxonepithet>
95
                                                                                                    <parent_id>
96
                                                                                                        <taxonlabel>
97
                                                                                                            <rank>genus</rank>
98
                                                                                                            <taxonepithet>$Genus</taxonepithet>
99
                                                                                                            <parent_id>
100
                                                                                                                <taxonlabel>
101
                                                                                                                    <rank>family</rank>
102
                                                                                                                    <taxonepithet>$Family</taxonepithet>
103
                                                                                                                </taxonlabel>
104
                                                                                                            </parent_id>
105
                                                                                                        </taxonlabel>
106
                                                                                                    </parent_id>
107
                                                                                                </taxonlabel>
108
                                                                                            </parent_id>
109
                                                                                        </taxonlabel>
110
                                                                                    </parent_id>
111
                                                                                </taxonlabel>
112
                                                                            </parent_id>
113
                                                                        </taxonlabel>
114
                                                                    </parent_id>
115
                                                                </taxonlabel>
116
                                                            </parent_id>
117
                                                            <taxonepithet>$InfraspecificEpithet</taxonepithet>
118
                                                        </taxonlabel>
119
                                                    </parent_id>
120
                                                    <rank>$InfraspecificRank</rank>
121
                                                    <taxonomicname>
122
                                                        <_join_words>
123
                                                            <1>
124
                                                                <_taxon_family_require_std>
125
                                                                    <family>
126
                                                                        <_nullIf>
127
                                                                            <null>$Taxon</null>
128
                                                                            <value>$Family</value>
129
                                                                        </_nullIf>
130
                                                                    </family>
131
                                                                </_taxon_family_require_std>
132
                                                            </1>
133
                                                            <2>
134
                                                                <_join_words>
135
                                                                    <1>
136
                                                                        <_alt>
137
                                                                            <1>$Taxon</1>
138
                                                                            <2>
139
                                                                                <_join_words>
140
                                                                                    <2>$Genus</2>
141
                                                                                    <3>$SpecificEpithet</3>
142
                                                                                    <5>
143
                                                                                        <_join_words>
144
                                                                                            <1>
145
                                                                                                <_if name="if has infraspecificEpithet">
146
                                                                                                    <cond>$InfraspecificEpithet</cond>
147
                                                                                                    <then>$InfraspecificRank</then>
148
                                                                                                </_if>
149
                                                                                            </1>
150
                                                                                            <2>$InfraspecificEpithet</2>
151
                                                                                        </_join_words>
152
                                                                                    </5>
153
                                                                                </_join_words>
154
                                                                            </2>
155
                                                                        </_alt>
156
                                                                    </1>
157
                                                                    <2>$AuthorOfScientificName</2>
158
                                                                </_join_words>
159
                                                            </2>
160
                                                        </_join_words>
161
                                                    </taxonomicname>
162
                                                    <trait>
163
                                                        <name>$TraitName</name>
164
                                                        <units>$Unit</units>
165
                                                        <value>$TraitValue</value>
166
                                                    </trait>
167
                                                </taxonlabel>
168
                                            </taxonlabel_id>
169
                                            <author>$AuthorOfScientificName</author>
170
                                            <family>$Family</family>
171
                                            <genus>$Genus</genus>
172
                                            <specific_epithet>$SpecificEpithet</specific_epithet>
173
                                            <taxonname>$Taxon</taxonname>
174
                                            <verbatimrank>$InfraspecificRank</verbatimrank>
175
                                        </taxonverbatim>
176
                                    </taxonverbatim_id>
177
                                </taxondetermination>
178
                            </taxonoccurrence>
179
                        </locationevent>
180
                        <locationnarrative>$LocalityDescription</locationnarrative>
181
                        <locationplace>
182
                            <place_id>
183
                                <place>
184
                                    <coordinates_id>
185
                                        <coordinates>
186
                                            <verbatimlatitude>$VerbatimLatitude</verbatimlatitude>
187
                                            <verbatimlongitude>$VerbatimLongitude</verbatimlongitude>
188
                                        </coordinates>
189
                                    </coordinates_id>
190
                                    <country>$Country</country>
191
                                    <matched_place_id>
192
                                        <place>
193
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
194
                                            <country>$Country</country>
195
                                            <stateprovince>$StateProvince</stateprovince>
196
                                        </place>
197
                                    </matched_place_id>
198
                                    <stateprovince>$StateProvince</stateprovince>
199
                                </place>
200
                            </place_id>
201
                        </locationplace>
202
                        <verbatimelevation>$VerbatimElevation</verbatimelevation>
203
                    </location>
204
                </path>
205
            </_simplifyPath>
206
        </path>
207
    </_setDefault>
208
</VegBIEN>
209
Inserted 35 new rows into database
inputs/bien2_traits/TraitObservation/new_terms.csv
1
TraitObservationID,occurrenceID,,
2
TaxonomyID,UNUSED,,Always 0
3
InfraspecificRank,taxonRank,,
4
AuthorOfScientificName,scientificNameAuthorship,,
5
TraitName,measurementType,,
6
TraitValue,measurementValue,,
7
Unit,measurementUnit,,
8
LocalityDescription,verbatimLocality,,
9
TaxonomyID_index,OMIT,,
10
Family_index,OMIT,,
11
Taxon_index,OMIT,,
12
TraitName_index,OMIT,,
13
ReferenceID_index,OMIT,,
inputs/bien2_traits/TraitObservation/unmapped_terms.csv
1
Method
2
*Region
3
*LowerPolitical
4
*URLSource
5
*SourceCitation
6
*SourceID
7
*VisitingDate
8
*ReferenceID
9
*Access
10
*Project_PI
11
*Project_PI_contact
12
*Observation
13
*Authorship
14
*AuthorshipContact
inputs/bien2_traits/Source/map.csv
1
bien2_traits,VegCore,Filter,Comments
2
:primary database,referenceType,,
inputs/bien2_traits/Source/VegBIEN.csv
1
bien2_traits,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2
:primary database,"/_if[@name=""if specimen""]/else/source:[shortname/_first/2/_env:[name=source]]/sourcetype",
inputs/bien2_traits/Source/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>bien2_traits</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <source>
10
                        <shortname>bien2_traits</shortname>
11
                        <sourcetype>primary database</sourcetype>
12
                    </source>
13
                </path>
14
            </_simplifyPath>
15
        </path>
16
    </_setDefault>
17
</VegBIEN>
18
Inserted 0 new rows into database
inputs/bien2_traits/import_order.txt
1
Source
2
TraitObservation
inputs/bien2_traits/_MySQL/bien2_staging.schema.sql.make
1
#!/bin/sh
2
env server=nimoy schema=1 my2pg_export bien2_staging TraitObservation
0 3

  
inputs/bien2_traits/_MySQL/bien2_staging.schema.sql
1
-- MySQL dump 10.13  Distrib 5.5.28, for debian-linux-gnu (x86_64)
2
--
3
-- Host: localhost    Database: bien2_staging
4
-- ------------------------------------------------------
5
-- Server version	5.5.28-0ubuntu0.12.04.3
6

  
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES latin1 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;
16
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17

  
18
--
19
-- Table structure for table "TraitObservation"
20
--
21

  
22
DROP TABLE IF EXISTS "TraitObservation";
23
/*!40101 SET @saved_cs_client     = @@character_set_client */;
24
/*!40101 SET character_set_client = utf8 */;
25
CREATE TABLE "TraitObservation" (
26
  "TraitObservationID" int(11) unsigned NOT NULL,
27
  "TaxonomyID" int(11) unsigned NOT NULL,
28
  "Family" varchar(100) DEFAULT NULL,
29
  "Genus" varchar(100) DEFAULT NULL,
30
  "SpecificEpithet" varchar(100) DEFAULT NULL,
31
  "InfraspecificRank" varchar(25) DEFAULT NULL,
32
  "InfraspecificEpithet" varchar(100) DEFAULT NULL,
33
  "Taxon" varchar(255) DEFAULT NULL,
34
  "AuthorOfScientificName" varchar(255) DEFAULT NULL,
35
  "Habit" varchar(50) DEFAULT NULL,
36
  "TraitName" varchar(200) DEFAULT NULL,
37
  "TraitValue" varchar(100) DEFAULT NULL,
38
  "Unit" varchar(100) DEFAULT NULL,
39
  "Method" varchar(255) DEFAULT NULL,
40
  "Region" varchar(100) DEFAULT NULL,
41
  "Country" varchar(100) DEFAULT NULL,
42
  "StateProvince" varchar(100) DEFAULT NULL,
43
  "LowerPolitical" varchar(100) DEFAULT NULL,
44
  "LocalityDescription" varchar(100) DEFAULT NULL,
45
  "VerbatimLatitude" varchar(150) DEFAULT NULL,
46
  "VerbatimLongitude" varchar(150) DEFAULT NULL,
47
  "VerbatimElevation" varchar(150) DEFAULT NULL,
48
  "Source" varchar(100) DEFAULT NULL,
49
  "URLSource" varchar(100) DEFAULT NULL,
50
  "SourceCitation" varchar(1000) DEFAULT NULL,
51
  "SourceID" varchar(255) DEFAULT NULL,
52
  "VisitingDate" varchar(100) DEFAULT NULL,
53
  "ReferenceID" int(11) unsigned DEFAULT NULL,
54
  "Access" varchar(100) DEFAULT NULL,
55
  "Project_PI" varchar(255) DEFAULT NULL,
56
  "Project_PI_contact" varchar(100) DEFAULT NULL,
57
  "Observation" varchar(255) DEFAULT NULL,
58
  "Authorship" varchar(255) DEFAULT NULL,
59
  "AuthorshipContact" varchar(100) DEFAULT NULL,
60
  PRIMARY KEY ("TraitObservationID"),
61
  KEY "TaxonomyID" ("TaxonomyID"),
62
  KEY "Family" ("Family"),
63
  KEY "Taxon" ("Taxon"),
64
  KEY "TraitName" ("TraitName"),
65
  KEY "ReferenceID" ("ReferenceID")
66
);
67
/*!40101 SET character_set_client = @saved_cs_client */;
68
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
69

  
70
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
71
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
72
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
73
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
74
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
75
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
76
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
77

  
78
-- Dump completed on 2012-12-17 12:45:51
inputs/bien2_traits/_MySQL/bien2_staging.data.sql.make
1
#!/bin/sh
2
env server=nimoy data=1 my2pg_export bien2_staging TraitObservation
0 3

  
inputs/bien2_traits/bien2_staging.schema.sql
1
SET standard_conforming_strings = off;
2
SET escape_string_warning = off;
3
-- MySQL dump 10.13  Distrib 5.5.28, for debian-linux-gnu (x86_64)
4
--
5
-- Host: localhost    Database: bien2_staging
6
-- ------------------------------------------------------
7
-- Server version	5.5.28-0ubuntu0.12.04.3
8

  
9
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12
SET NAMES 'latin1';
13
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14
/*!40103 SET TIME_ZONE='+00:00' */;
15
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */;
18
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19

  
20
--
21
-- Table structure for table "TraitObservation"
22
--
23

  
24
DROP TABLE IF EXISTS "TraitObservation";
25
/*!40101 SET @saved_cs_client     = @@character_set_client */;
26
/*!40101 SET character_set_client = utf8 */;
27
CREATE TABLE "TraitObservation" (
28
  "TraitObservationID" integer NOT NULL,
29
  "TaxonomyID" integer NOT NULL,
30
  "Family" varchar(100) DEFAULT NULL,
31
  "Genus" varchar(100) DEFAULT NULL,
32
  "SpecificEpithet" varchar(100) DEFAULT NULL,
33
  "InfraspecificRank" varchar(25) DEFAULT NULL,
34
  "InfraspecificEpithet" varchar(100) DEFAULT NULL,
35
  "Taxon" varchar(255) DEFAULT NULL,
36
  "AuthorOfScientificName" varchar(255) DEFAULT NULL,
37
  "Habit" varchar(50) DEFAULT NULL,
38
  "TraitName" varchar(200) DEFAULT NULL,
39
  "TraitValue" varchar(100) DEFAULT NULL,
40
  "Unit" varchar(100) DEFAULT NULL,
41
  "Method" varchar(255) DEFAULT NULL,
42
  "Region" varchar(100) DEFAULT NULL,
43
  "Country" varchar(100) DEFAULT NULL,
44
  "StateProvince" varchar(100) DEFAULT NULL,
45
  "LowerPolitical" varchar(100) DEFAULT NULL,
46
  "LocalityDescription" varchar(100) DEFAULT NULL,
47
  "VerbatimLatitude" varchar(150) DEFAULT NULL,
48
  "VerbatimLongitude" varchar(150) DEFAULT NULL,
49
  "VerbatimElevation" varchar(150) DEFAULT NULL,
50
  "Source" varchar(100) DEFAULT NULL,
51
  "URLSource" varchar(100) DEFAULT NULL,
52
  "SourceCitation" varchar(1000) DEFAULT NULL,
53
  "SourceID" varchar(255) DEFAULT NULL,
54
  "VisitingDate" varchar(100) DEFAULT NULL,
55
  "ReferenceID" integer DEFAULT NULL,
56
  "Access" varchar(100) DEFAULT NULL,
57
  "Project_PI" varchar(255) DEFAULT NULL,
58
  "Project_PI_contact" varchar(100) DEFAULT NULL,
59
  "Observation" varchar(255) DEFAULT NULL,
60
  "Authorship" varchar(255) DEFAULT NULL,
61
  "AuthorshipContact" varchar(100) DEFAULT NULL,
62
  PRIMARY KEY ("TraitObservationID"),
63
  "TaxonomyID_index" boolean,
64
  "Family_index" boolean,
65
  "Taxon_index" boolean,
66
  "TraitName_index" boolean,
67
  "ReferenceID_index" boolean
68
);
69
/*!40101 SET character_set_client = @saved_cs_client */;
70
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
71

  
72
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
73
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
74
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
75
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
76
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
77
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
78
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
79

  
80
-- Dump completed on 2012-12-17 12:45:51

Also available in: Unified diff