Project

General

Profile

« Previous | Next » 

Revision 4753

schemas/vegbien.sql: Added units suffix to all core VegBIEN fields that have units. It is the responsibility of the mappings to ensure that all units are properly translated.

View differences:

inputs/SALVIAS/plotObservations/test.xml.ref
78 78
                                        </userdefined_id>
79 79
                                        <definedvalue>$liana_infestation</definedvalue>
80 80
                                    </definedvalue>
81
                                    <diameterbreastheight>$temp_dbh</diameterbreastheight>
82
                                    <height>$height_m</height>
83
                                    <heightfirstbranch>$ht_first_branch_m</heightfirstbranch>
81
                                    <diameterbreastheight_m>$temp_dbh</diameterbreastheight_m>
82
                                    <height_m>$height_m</height_m>
83
                                    <heightfirstbranch_m>$ht_first_branch_m</heightfirstbranch_m>
84 84
                                    <stemtag>
85 85
                                        <iscurrent>
86 86
                                            <_alt>
......
94 94
                                        <iscurrent>true</iscurrent>
95 95
                                        <tag>$tag2</tag>
96 96
                                    </stemtag>
97
                                    <xposition>$x_position</xposition>
98
                                    <yposition>$y_position</yposition>
97
                                    <xposition_m>$x_position</xposition_m>
98
                                    <yposition_m>$y_position</yposition_m>
99 99
                                </stemobservation>
100 100
                            </plantobservation>
101 101
                        </aggregateoccurrence>
inputs/ARIZ/Specimen/VegBIEN.csv
4 4
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5
CatalogNumberNumeric,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else/_alt/1",
6 6
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric
7
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
12
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
13
CoordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1,
7
VerbatimElevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
8
MaximumElevationInMeters,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9
MinimumElevationInMeters,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10
MinimumElevationInMeters,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
MaximumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
12
MinimumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
13
CoordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
14 14
BoundingBox,/location/locationcoords/footprintgeometry_dwc,
15
DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
16
VerbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
17
DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
18
VerbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
15
DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
16
VerbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
17
DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
18
VerbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
19 19
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/0,
20 20
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
21 21
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
......
53 53
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
54 54
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",
55 55
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric
56
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
57
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
56
MaximumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
57
MinimumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
58 58
Locality,/location/locationnarrative/_merge/1,
59 59
ContinentOcean,/location/locationplace/*_id/placepath/continent,
60 60
Country,/location/locationplace/*_id/placepath/country,
inputs/GBIF/Specimen/test.xml.ref
11 11
                        <3>$CatalogNO</3>
12 12
                    </_join>
13 13
                </authorlocationcode>
14
                <elevation>
14
                <elevation_m>
15 15
                    <_avg>
16 16
                        <max>
17 17
                            <_units>
......
44 44
                            </_units>
45 45
                        </min>
46 46
                    </_avg>
47
                </elevation>
48
                <elevationrange>
47
                </elevation_m>
48
                <elevationrange_m>
49 49
                    <_range>
50 50
                        <from>
51 51
                            <_units>
......
92 92
                            </_units>
93 93
                        </to>
94 94
                    </_range>
95
                </elevationrange>
95
                </elevationrange_m>
96 96
                <locationcoords>
97
                    <latitude>
97
                    <latitude_deg>
98 98
                        <_alt>
99 99
                            <1>
100 100
                                <_nullIf>
......
111 111
                                </_nullIf>
112 112
                            </2>
113 113
                        </_alt>
114
                    </latitude>
115
                    <longitude>
114
                    </latitude_deg>
115
                    <longitude_deg>
116 116
                        <_alt>
117 117
                            <1>
118 118
                                <_nullIf>
......
129 129
                                </_nullIf>
130 130
                            </2>
131 131
                        </_alt>
132
                    </longitude>
132
                    </longitude_deg>
133 133
                </locationcoords>
134 134
                <locationevent>
135 135
                    <taxonoccurrence>
inputs/SpeciesLink/Specimen/VegBIEN.csv
10 10
conceptual_darwin_2003_1_0_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
11 11
dwc_dwcore_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
12 12
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
13
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
14
dwc_dwcore_MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
15
dwc_terms_maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
16
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
17
dwc_dwcore_MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
18
dwc_terms_minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
19
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
20
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
21
dwc_terms_minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
22
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
23
dwc_dwcore_MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
24
dwc_terms_maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
25
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
26
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
27
dwc_terms_minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
28
dwc_terms_coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1,
29
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/2,
13
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
14
dwc_dwcore_MaximumElevationInMeters,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
15
dwc_terms_maximumElevationInMeters,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
16
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
17
dwc_dwcore_MinimumElevationInMeters,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
18
dwc_terms_minimumElevationInMeters,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
19
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
20
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
21
dwc_terms_minimumElevationInMeters,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
22
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
23
dwc_dwcore_MaximumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
24
dwc_terms_maximumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
25
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
26
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
27
dwc_terms_minimumElevationInMeters,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
28
dwc_terms_coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
29
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
30 30
conceptual_darwin_2003_1_0_BoundingBox,/location/locationcoords/footprintgeometry_dwc,
31
dwc_geospatial_DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
32
dwc_terms_decimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
33
conceptual_darwin_2003_1_0_Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
34
dwc_geospatial_VerbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
35
dwc_terms_verbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
36
dwc_geospatial_DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
37
dwc_terms_decimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
38
conceptual_darwin_2003_1_0_Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
39
dwc_geospatial_VerbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
40
dwc_terms_verbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
31
dwc_geospatial_DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
32
dwc_terms_decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
33
conceptual_darwin_2003_1_0_Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
34
dwc_geospatial_VerbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
35
dwc_terms_verbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
36
dwc_geospatial_DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
37
dwc_terms_decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
38
conceptual_darwin_2003_1_0_Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
39
dwc_geospatial_VerbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
40
dwc_terms_verbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
41 41
conceptual_darwin_2003_1_0_DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
42 42
conceptual_darwin_2003_1_0_MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
43 43
conceptual_darwin_2003_1_0_YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
148 148
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
149 149
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
150 150
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
151
conceptual_darwin_2003_1_0_MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
152
dwc_dwcore_MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
153
dwc_terms_maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
154
conceptual_darwin_2003_1_0_MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
155
dwc_dwcore_MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
156
dwc_terms_minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
151
conceptual_darwin_2003_1_0_MaximumDepth,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
152
dwc_dwcore_MaximumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
153
dwc_terms_maximumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
154
conceptual_darwin_2003_1_0_MinimumDepth,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
155
dwc_dwcore_MinimumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
156
dwc_terms_minimumDepthInMeters,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
157 157
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
158 158
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
159 159
dwc_terms_locality,/location/locationnarrative/_merge/1,
inputs/XAL/Specimen/VegBIEN.csv
2 2
darwin:InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
3 3
darwin:CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 4
darwin:CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
5
darwin:MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6
darwin:MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7
darwin:MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8
darwin:MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9
darwin:MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10
darwin:CoordinatePrecision,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/2,
11
darwin:Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12
darwin:Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
5
darwin:MaximumElevation,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6
darwin:MinimumElevation,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7
darwin:MinimumElevation,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8
darwin:MaximumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9
darwin:MinimumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10
darwin:CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
11
darwin:Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
12
darwin:Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
13 13
darwin:DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
14 14
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
15 15
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
42 42
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
43 43
darwin:Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
44 44
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
45
darwin:MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
46
darwin:MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
45
darwin:MaximumDepth,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
46
darwin:MinimumDepth,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
47 47
darwin:Locality,/location/locationnarrative/_merge/1,
48 48
darwin:ContinentOcean,/location/locationplace/*_id/placepath/continent,
49 49
darwin:Country,/location/locationplace/*_id/placepath/country,
inputs/TEAM/VL/VegBIEN.csv
4 4
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6
Subplot,/location/authorlocationcode,
7
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
8
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
7
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
8
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
9 9
Method,/location/locationevent/*_id/method/name,
10 10
SiteName,/location/locationevent/*_id/project/projectname,
11 11
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
......
13 13
ObservationDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
14 14
ObservationDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
15 15
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
16
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
16
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
17 17
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
18
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
19
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
18
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,
19
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,
20 20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
21 21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
22 22
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
inputs/TEAM/VL/test.xml.ref
7 7
                <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
8 8
                <authorlocationcode>$Subplot</authorlocationcode>
9 9
                <locationcoords>
10
                    <latitude>
10
                    <latitude_deg>
11 11
                        <_nullIf>
12 12
                            <null>0</null>
13 13
                            <type>float</type>
14 14
                            <value>$Latitude</value>
15 15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
16
                    </latitude_deg>
17
                    <longitude_deg>
18 18
                        <_nullIf>
19 19
                            <null>0</null>
20 20
                            <type>float</type>
21 21
                            <value>$Longitude</value>
22 22
                        </_nullIf>
23
                    </longitude>
23
                    </longitude_deg>
24 24
                </locationcoords>
25 25
                <locationevent>
26 26
                    <method_id><method><name>$Method</name></method></method_id>
......
32 32
                            <plantobservation>
33 33
                                <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
34 34
                                <stemobservation>
35
                                    <diameterbreastheight>$dbh</diameterbreastheight>
35
                                    <diameterbreastheight_m>$dbh</diameterbreastheight_m>
36 36
                                    <stemtag>
37 37
                                        <iscurrent>true</iscurrent>
38 38
                                        <tag>$TreeNumber</tag>
39 39
                                    </stemtag>
40
                                    <xposition>$X_1haPlot</xposition>
41
                                    <yposition>$Y_1haPlot</yposition>
40
                                    <xposition_m>$X_1haPlot</xposition_m>
41
                                    <yposition_m>$Y_1haPlot</yposition_m>
42 42
                                </stemobservation>
43 43
                            </plantobservation>
44 44
                        </aggregateoccurrence>
inputs/TEAM/VT/VegBIEN.csv
4 4
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6
Subplot,/location/authorlocationcode,
7
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
8
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
7
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
8
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
9 9
Method,/location/locationevent/*_id/method/name,
10 10
SiteName,/location/locationevent/*_id/project/projectname,
11 11
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
......
13 13
ObservationDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
14 14
ObservationDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
15 15
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
16
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
16
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
17 17
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
18
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
19
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
18
X_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,
19
Y_1haPlot,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,
20 20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
21 21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
22 22
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
inputs/TEAM/VT/test.xml.ref
7 7
                <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
8 8
                <authorlocationcode>$Subplot</authorlocationcode>
9 9
                <locationcoords>
10
                    <latitude>
10
                    <latitude_deg>
11 11
                        <_nullIf>
12 12
                            <null>0</null>
13 13
                            <type>float</type>
14 14
                            <value>$Latitude</value>
15 15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
16
                    </latitude_deg>
17
                    <longitude_deg>
18 18
                        <_nullIf>
19 19
                            <null>0</null>
20 20
                            <type>float</type>
21 21
                            <value>$Longitude</value>
22 22
                        </_nullIf>
23
                    </longitude>
23
                    </longitude_deg>
24 24
                </locationcoords>
25 25
                <locationevent>
26 26
                    <method_id><method><name>$Method</name></method></method_id>
......
32 32
                            <plantobservation>
33 33
                                <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
34 34
                                <stemobservation>
35
                                    <diameterbreastheight>$dbh</diameterbreastheight>
35
                                    <diameterbreastheight_m>$dbh</diameterbreastheight_m>
36 36
                                    <stemtag>
37 37
                                        <iscurrent>true</iscurrent>
38 38
                                        <tag>$TreeNumber</tag>
39 39
                                    </stemtag>
40
                                    <xposition>$X_1haPlot</xposition>
41
                                    <yposition>$Y_1haPlot</yposition>
40
                                    <xposition_m>$X_1haPlot</xposition_m>
41
                                    <yposition_m>$Y_1haPlot</yposition_m>
42 42
                                </stemobservation>
43 43
                            </plantobservation>
44 44
                        </aggregateoccurrence>
inputs/NY/Specimen/VegBIEN.csv
3 3
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 4
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
6
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
8
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
9
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
10
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
11
CoordinatePrecision,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/2,
6
MaximumElevation,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7
MinimumElevation,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
8
MinimumElevation,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
9
MaximumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
10
MinimumElevation,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
11
CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
12 12
BoundingBox,/location/locationcoords/footprintgeometry_dwc,
13
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
14
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
14
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
15 15
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
16 16
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
17 17
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
44 44
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
45 45
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
46 46
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
47
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
48
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
47
MaximumDepth,"/location/locationevent/waterdepth_m/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
48
MinimumDepth,"/location/locationevent/waterdepth_m/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
49 49
Locality,/location/locationnarrative/_merge/1/_join/1,
50 50
Substrate,"/location/locationnarrative/_merge/1/_join/2/_label[label=""substrate""]/value",
51 51
Vegetation,"/location/locationnarrative/_merge/1/_join/3/_label[label=""vegetation""]/value",
inputs/NY/Specimen/test.xml.ref
16 16
                        </2>
17 17
                    </_alt>
18 18
                </authorlocationcode>
19
                <elevation>
19
                <elevation_m>
20 20
                    <_avg>
21 21
                        <max>
22 22
                            <_units>
......
54 54
                            </_units>
55 55
                        </min>
56 56
                    </_avg>
57
                </elevation>
58
                <elevationrange>
57
                </elevation_m>
58
                <elevationrange_m>
59 59
                    <_range>
60 60
                        <from>
61 61
                            <_units>
......
112 112
                            </_units>
113 113
                        </to>
114 114
                    </_range>
115
                </elevationrange>
115
                </elevationrange_m>
116 116
                <locationcoords>
117
                    <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
117
                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
118 118
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
119
                    <latitude>
119
                    <latitude_deg>
120 120
                        <_nullIf>
121 121
                            <null>0</null>
122 122
                            <type>float</type>
123 123
                            <value>$Latitude</value>
124 124
                        </_nullIf>
125
                    </latitude>
126
                    <longitude>
125
                    </latitude_deg>
126
                    <longitude_deg>
127 127
                        <_nullIf>
128 128
                            <null>0</null>
129 129
                            <type>float</type>
130 130
                            <value>$Longitude</value>
131 131
                        </_nullIf>
132
                    </longitude>
132
                    </longitude_deg>
133 133
                </locationcoords>
134 134
                <locationevent>
135 135
                    <taxonoccurrence>
......
246 246
                        </taxondetermination>
247 247
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
248 248
                    </taxonoccurrence>
249
                    <waterdepth>
249
                    <waterdepth_m>
250 250
                        <_avg>
251 251
                            <max>
252 252
                                <_units>
......
275 275
                                </_units>
276 276
                            </min>
277 277
                        </_avg>
278
                    </waterdepth>
278
                    </waterdepth_m>
279 279
                </locationevent>
280 280
                <locationnarrative>
281 281
                    <_merge>
inputs/Madidi/Organism/VegBIEN.csv
16 16
Specimen,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
17 17
Trunk,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
18 18
Liana presence,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
19
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
20
Total height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
19
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
20
Total height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
21 21
Tag number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
22
Subplot X,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
23
Subplot Y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
22
Subplot X,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,
23
Subplot Y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,
24 24
Tree number,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,
25 25
Specie+autor,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
26 26
Species and morphotypes,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/3,"Contains less than ""Specie+autor"""
inputs/Madidi/Organism/test.xml.ref
30 30
                                        </userdefined_id>
31 31
                                        <definedvalue>$Liana presence</definedvalue>
32 32
                                    </definedvalue>
33
                                    <diameterbreastheight>$Diameter</diameterbreastheight>
34
                                    <height>$Total height</height>
33
                                    <diameterbreastheight_m>$Diameter</diameterbreastheight_m>
34
                                    <height_m>$Total height</height_m>
35 35
                                    <stemtag>
36 36
                                        <iscurrent>true</iscurrent>
37 37
                                        <tag>$Tag number</tag>
38 38
                                    </stemtag>
39
                                    <xposition>$Subplot X</xposition>
40
                                    <yposition>$Subplot Y</yposition>
39
                                    <xposition_m>$Subplot X</xposition_m>
40
                                    <yposition_m>$Subplot Y</yposition_m>
41 41
                                </stemobservation>
42 42
                            </plantobservation>
43 43
                        </aggregateoccurrence>
inputs/Madidi/Plot/VegBIEN.csv
4 4
Inventory code,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 5
Inventory name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6
Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7
Area,/location/area,
8
Altitude,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
9
Minimum altitude,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10
Minimum altitude,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
Minimum altitude,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
7
Area,/location/area_m2,
8
Altitude,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
9
Minimum altitude,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10
Minimum altitude,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
Minimum altitude,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
12 12
Topographical situation,/location/landform,
13
Latitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
14
Latitude (DMS),"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
15
Longitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
16
Longitude (DMS),"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
14
Latitude (DMS),"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
15
Longitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
16
Longitude (DMS),"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
17 17
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data
18 18
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data
19 19
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
......
40 40
Textural class,/location/locationevent/soilobs/texture,
41 41
Locality,/location/locationnarrative/_merge/1,
42 42
Observaciones,/location/notespublic,
43
Direction,/location/slopeaspect/_alt/1/_compass/value/_alt/1,Part files provide either this field or Direction
44
Orientación/exposicion,/location/slopeaspect/_alt/1/_compass/value/_alt/2,Part files provide either this field or Orientación
45
Slope,/location/slopegradient/_alt/1,
43
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Direction
44
Orientación/exposicion,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/2,Part files provide either this field or Orientación
45
Slope,/location/slopegradient_frac/_alt/1,
46 46
Collaborators,,"** No join mapping for Collaborators ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
47 47
Coordinates,,** No join mapping for Coordinates ** Concatenation of Latitude (DMS) and Longitude (DMS)
48 48
Installed and evaluated by,,"** No join mapping for Installed and evaluated by ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
inputs/Madidi/Plot/test.xml.ref
6 6
            <location>
7 7
                <authorlocationcode>$Inventory name</authorlocationcode>
8 8
                <sourceaccessioncode>$Inventory code</sourceaccessioncode>
9
                <area>$Area</area>
10
                <elevation>
9
                <area_m2>$Area</area_m2>
10
                <elevation_m>
11 11
                    <_alt>
12 12
                        <1>
13 13
                            <_replace>
......
37 37
                            </_avg>
38 38
                        </2>
39 39
                    </_alt>
40
                </elevation>
41
                <elevationrange>
40
                </elevation_m>
41
                <elevationrange_m>
42 42
                    <_range>
43 43
                        <from>
44 44
                            <_units>
......
75 75
                            </_units>
76 76
                        </to>
77 77
                    </_range>
78
                </elevationrange>
78
                </elevationrange_m>
79 79
                <landform>$Topographical situation</landform>
80 80
                <locationcoords>
81
                    <latitude>
81
                    <latitude_deg>
82 82
                        <_alt>
83 83
                            <1>
84 84
                                <_nullIf>
......
95 95
                                </_nullIf>
96 96
                            </2>
97 97
                        </_alt>
98
                    </latitude>
99
                    <longitude>
98
                    </latitude_deg>
99
                    <longitude_deg>
100 100
                        <_alt>
101 101
                            <1>
102 102
                                <_nullIf>
......
113 113
                                </_nullIf>
114 114
                            </2>
115 115
                        </_alt>
116
                    </longitude>
116
                    </longitude_deg>
117 117
                </locationcoords>
118 118
                <locationevent>
119 119
                    <project_id>
......
155 155
                </locationevent>
156 156
                <locationnarrative>$Locality</locationnarrative>
157 157
                <notespublic>$Observaciones</notespublic>
158
                <slopeaspect>
158
                <slopeaspect_deg>
159 159
                    <_compass>
160 160
                        <value>
161 161
                            <_alt>
......
164 164
                            </_alt>
165 165
                        </value>
166 166
                    </_compass>
167
                </slopeaspect>
168
                <slopegradient>$Slope</slopegradient>
167
                </slopeaspect_deg>
168
                <slopegradient_frac>$Slope</slopegradient_frac>
169 169
            </location>
170 170
        </path>
171 171
    </_simplifyPath>
inputs/ACAD/Specimen/VegBIEN.csv
4 4
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
6 6
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
7
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8
decimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
9
decimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
7
verbatimElevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
8
decimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
9
decimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
10 10
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
11 11
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
12 12
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
inputs/ACAD/Specimen/test.xml.ref
21 21
                        </2>
22 22
                    </_alt>
23 23
                </authorlocationcode>
24
                <elevation>
24
                <elevation_m>
25 25
                    <_replace>
26 26
                        <\bca\.?></\bca\.?>
27 27
                        <value>$verbatimElevation</value>
28 28
                    </_replace>
29
                </elevation>
29
                </elevation_m>
30 30
                <locationcoords>
31
                    <latitude>
31
                    <latitude_deg>
32 32
                        <_nullIf>
33 33
                            <null>0</null>
34 34
                            <type>float</type>
35 35
                            <value>$decimalLatitude</value>
36 36
                        </_nullIf>
37
                    </latitude>
38
                    <longitude>
37
                    </latitude_deg>
38
                    <longitude_deg>
39 39
                        <_nullIf>
40 40
                            <null>0</null>
41 41
                            <type>float</type>
42 42
                            <value>$decimalLongitude</value>
43 43
                        </_nullIf>
44
                    </longitude>
44
                    </longitude_deg>
45 45
                </locationcoords>
46 46
                <locationevent>
47 47
                    <obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate>
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
37 37
det_type,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
38 38
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Map instead as for voucher_string
39 39
voucher_string,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
40
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
40
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m,
41 41
stem_canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
42 42
stem_canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
43 43
stem_liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
44 44
notes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
45
stem_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
46
stem_height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height/_alt/1,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."
47
height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height/_alt/2,
48
ht_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
49
stem_height_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
45
stem_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
46
stem_height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_alt/1,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."
47
height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_alt/2,
48
ht_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch_m,
49
stem_height_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch_m,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
50 50
tag1,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag/_alt/1","Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once.; Quotes sort it before tag2"
51 51
stem_tag1,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag/_alt/2","Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems.; Quotes sort it before tag2"
52 52
tag2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
53 53
stem_tag2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag/_alt/2,Brad: see above
54
x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,"Brad: These are important, fundamental values of many tree plots"
55
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position
54
x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"Brad: These are important, fundamental values of many tree plots"
55
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,Brad: See comment above for x_position
56 56
individual_code,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
57 57
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
58 58
OBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
inputs/SALVIAS-CSV/Organism/test.xml.ref
50 50
                                    </catalognumber_dwc>
51 51
                                </specimenreplicate>
52 52
                                <stemobservation>
53
                                    <basaldiameter>$basal_diam</basaldiameter>
53
                                    <basaldiameter_m>$basal_diam</basaldiameter_m>
54 54
                                    <definedvalue fkey="tablerecord_id">
55 55
                                        <userdefined_id>
56 56
                                            <userdefined>
......
87 87
                                        </userdefined_id>
88 88
                                        <definedvalue>$notes</definedvalue>
89 89
                                    </definedvalue>
90
                                    <diameterbreastheight>$stem_dbh</diameterbreastheight>
91
                                    <height>
90
                                    <diameterbreastheight_m>$stem_dbh</diameterbreastheight_m>
91
                                    <height_m>
92 92
                                        <_alt>
93 93
                                            <1>$stem_height_m</1>
94 94
                                            <2>$height_m</2>
95 95
                                        </_alt>
96
                                    </height>
97
                                    <heightfirstbranch>
96
                                    </height_m>
97
                                    <heightfirstbranch_m>
98 98
                                        <_alt>
99 99
                                            <0>$ht_first_branch_m</0>
100 100
                                            <1>$stem_height_first_branch_m</1>
101 101
                                        </_alt>
102
                                    </heightfirstbranch>
102
                                    </heightfirstbranch_m>
103 103
                                    <stemtag>
104 104
                                        <iscurrent>
105 105
                                            <_alt>
......
123 123
                                            </_alt>
124 124
                                        </tag>
125 125
                                    </stemtag>
126
                                    <xposition>$x_position</xposition>
127
                                    <yposition>$y_position</yposition>
126
                                    <xposition_m>$x_position</xposition_m>
127
                                    <yposition_m>$y_position</yposition_m>
128 128
                                </stemobservation>
129 129
                            </plantobservation>
130 130
                        </aggregateoccurrence>
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
4 4
PLOT_ID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
5 5
plot_code,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
6 6
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
7
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
8
elev_m,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
9
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
10
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
12
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
13
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14
lat_decimal,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15
long_decimal,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
7
plot_area_ha,/location/area_m2,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
8
elev_m,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
9
elev_max_m,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
10
elev_min_m,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
elev_min_m,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
12
elev_max_m,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
13
elev_min_m,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14
lat_decimal,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
15
long_decimal,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
16 16
plot_methodology,/location/locationevent/*_id/method/name,
17 17
project,/location/locationevent/*_id/project/projectname,
18 18
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
......
21 21
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
22 22
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
23 23
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1,
24
precip_mm,/location/locationevent/precipitation,
24
precip_mm,/location/locationevent/precipitation_m,
25 25
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
26 26
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value",
27 27
soil_Ca,"/location/locationevent/soilobs/calcium/_units:[default=""%"",to=]/value",
......
39 39
silt_percent,"/location/locationevent/soilobs/silt/_units:[default=""%"",to=]/value",
40 40
soil_Na,"/location/locationevent/soilobs/sodium/_units:[default=""%"",to=]/value",
41 41
soil_texture,/location/locationevent/soilobs/texture,
42
temp_c,/location/locationevent/temperature,
42
temp_c,/location/locationevent/temperature_c,
43 43
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
44 44
major_geo,/location/locationplace/*_id/placepath/continent,
45 45
country,/location/locationplace/*_id/placepath/country,
46 46
pol2,/location/locationplace/*_id/placepath/county,Brad: No pol2=countyParish
47 47
pol1,/location/locationplace/*_id/placepath/stateprovince,Brad: No; pol1=stateProvince
48
slope_aspect,/location/slopeaspect/_alt/1/_compass/value,
49
slope_gradient,/location/slopegradient/_alt/1,
48
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
49
slope_gradient,/location/slopegradient_frac/_alt/1,
50 50
observation_type,,"** No join mapping for observation_type ** Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
51 51
recensused,,"** No join mapping for recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/Plot/test.xml.ref
6 6
            <location>
7 7
                <authorlocationcode>$plot_code</authorlocationcode>
8 8
                <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
9
                <area>$plot_area_ha</area>
10
                <elevation>
9
                <area_m2>$plot_area_ha</area_m2>
10
                <elevation_m>
11 11
                    <_alt>
12 12
                        <1>
13 13
                            <_replace>
......
50 50
                            </_avg>
51 51
                        </2>
52 52
                    </_alt>
53
                </elevation>
54
                <elevationrange>
53
                </elevation_m>
54
                <elevationrange_m>
55 55
                    <_range>
56 56
                        <from>
57 57
                            <_units>
......
98 98
                            </_units>
99 99
                        </to>
100 100
                    </_range>
101
                </elevationrange>
101
                </elevationrange_m>
102 102
                <locationcoords>
103
                    <latitude>
103
                    <latitude_deg>
104 104
                        <_nullIf>
105 105
                            <null>0</null>
106 106
                            <type>float</type>
107 107
                            <value>$lat_decimal</value>
108 108
                        </_nullIf>
109
                    </latitude>
110
                    <longitude>
109
                    </latitude_deg>
110
                    <longitude_deg>
111 111
                        <_nullIf>
112 112
                            <null>0</null>
113 113
                            <type>float</type>
114 114
                            <value>$long_decimal</value>
115 115
                        </_nullIf>
116
                    </longitude>
116
                    </longitude_deg>
117 117
                </locationcoords>
118 118
                <locationevent>
119 119
                    <method_id><method><name>$plot_methodology</name></method></method_id>
......
130 130
                    </commclass>
131 131
                    <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
132 132
                    <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
133
                    <precipitation>$precip_mm</precipitation>
133
                    <precipitation_m>$precip_mm</precipitation_m>
134 134
                    <soilobs>
135 135
                        <acidity>
136 136
                            <_units>
......
240 240
                        </sodium>
241 241
                        <texture>$soil_texture</texture>
242 242
                    </soilobs>
243
                    <temperature>$temp_c</temperature>
243
                    <temperature_c>$temp_c</temperature_c>
244 244
                </locationevent>
245 245
                <locationnarrative>$locality_description</locationnarrative>
246 246
                <locationplace>
......
253 253
                        </placepath>
254 254
                    </placepath_id>
255 255
                </locationplace>
256
                <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
257
                <slopegradient>$slope_gradient</slopegradient>
256
                <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
257
                <slopegradient_frac>$slope_gradient</slopegradient_frac>
258 258
            </location>
259 259
        </path>
260 260
    </_simplifyPath>
inputs/CVS/Organism/VegBIEN.csv
1 1
CVS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
authorObsCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
3
locationAccuracy-m,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1,
4
publicLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
5
publicLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
3
locationAccuracy-m,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
4
publicLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
5
publicLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
6 6
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
7 7
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
8 8
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
inputs/CVS/Organism/test.xml.ref
6 6
            <location>
7 7
                <authorlocationcode>$authorObsCode</authorlocationcode>
8 8
                <locationcoords>
9
                    <coordsaccuracy><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy>
10
                    <latitude>
9
                    <coordsaccuracy_deg><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_deg>
10
                    <latitude_deg>
11 11
                        <_nullIf>
12 12
                            <null>0</null>
13 13
                            <type>float</type>
14 14
                            <value>$publicLatitude</value>
15 15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
16
                    </latitude_deg>
17
                    <longitude_deg>
18 18
                        <_nullIf>
19 19
                            <null>0</null>
20 20
                            <type>float</type>
21 21
                            <value>$publicLongitude</value>
22 22
                        </_nullIf>
23
                    </longitude>
23
                    </longitude_deg>
24 24
                </locationcoords>
25 25
                <locationevent>
26 26
                    <authoreventcode>$authorObsCode</authoreventcode>
inputs/REMIB/Specimen/VegBIEN.csv
1 1
REMIB,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
accession_number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
acronym,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4
lat_deg,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
5
long_deg,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
4
lat_deg,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
5
long_deg,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
6 6
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
7 7
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
8 8
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/REMIB/Specimen/test.xml.ref
11 11
                    </_alt>
12 12
                </authorlocationcode>
13 13
                <locationcoords>
14
                    <latitude>
14
                    <latitude_deg>
15 15
                        <_nullIf>
16 16
                            <null>0</null>
17 17
                            <type>float</type>
18 18
                            <value>$lat_deg</value>
19 19
                        </_nullIf>
20
                    </latitude>
21
                    <longitude>
20
                    </latitude_deg>
21
                    <longitude_deg>
22 22
                        <_nullIf>
23 23
                            <null>0</null>
24 24
                            <type>float</type>
25 25
                            <value>$long_deg</value>
26 26
                        </_nullIf>
27
                    </longitude>
27
                    </longitude_deg>
28 28
                </locationcoords>
29 29
                <locationevent>
30 30
                    <taxonoccurrence>
inputs/CTFS/StemObservation/VegBIEN.csv
11 11
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
12 12
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
13 13
StemID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
14
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
14
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
15 15
StemTag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
16 16
Tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
17
x,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
18
y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
17
x,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,
18
y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,
19 19
MeasureID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2,
20 20
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family,
21 21
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
inputs/CTFS/StemObservation/test.xml.ref
19 19
                                <sourceaccessioncode>$MeasureID</sourceaccessioncode>
20 20
                                <stemobservation>
21 21
                                    <authorstemcode>$StemID</authorstemcode>
22
                                    <diameterbreastheight>$DBH</diameterbreastheight>
22
                                    <diameterbreastheight_m>$DBH</diameterbreastheight_m>
23 23
                                    <stemtag>
24 24
                                        <iscurrent>true</iscurrent>
25 25
                                        <tag>
......
29 29
                                            </_alt>
30 30
                                        </tag>
31 31
                                    </stemtag>
32
                                    <xposition>$x</xposition>
33
                                    <yposition>$y</yposition>
32
                                    <xposition_m>$x</xposition_m>
33
                                    <yposition_m>$y</yposition_m>
34 34
                                </stemobservation>
35 35
                            </plantobservation>
36 36
                        </aggregateoccurrence>
inputs/CTFS/Subplot/VegBIEN.csv
6 6
QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site
7 7
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
8 8
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
9
StartX,/location/sublocationxposition,
10
StartY,/location/sublocationyposition,
9
StartX,/location/sublocationxposition_m,
10
StartY,/location/sublocationyposition_m,
11 11
DimX,,** No join mapping for DimX ** 
12 12
DimY,,** No join mapping for DimY ** 
13 13
QuadratName,,** No join mapping for OMIT ** QuadratID is used for the same purpose
inputs/CTFS/Subplot/test.xml.ref
6 6
            <location>
7 7
                <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
8 8
                <authorlocationcode>$QuadratID</authorlocationcode>
9
                <sublocationxposition>$StartX</sublocationxposition>
10
                <sublocationyposition>$StartY</sublocationyposition>
9
                <sublocationxposition_m>$StartX</sublocationxposition_m>
10
                <sublocationyposition_m>$StartY</sublocationyposition_m>
11 11
            </location>
12 12
        </path>
13 13
    </_simplifyPath>
inputs/CTFS/Plot/test.xml.ref
6 6
            <location>
7 7
                <authorlocationcode>$PlotName</authorlocationcode>
8 8
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9
                <area>$SizeOfSite</area>
10
                <elevation>
9
                <area_m2>$SizeOfSite</area_m2>
10
                <elevation_m>
11 11
                    <_replace>
12 12
                        <\bca\.?></\bca\.?>
13 13
                        <value>$Elevation</value>
14 14
                    </_replace>
15
                </elevation>
15
                </elevation_m>
16 16
                <locationcoords>
17 17
                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
18
                    <latitude>
18
                    <latitude_deg>
19 19
                        <_nullIf>
20 20
                            <null>0</null>
21 21
                            <type>float</type>
22 22
                            <value>$Latitude</value>
23 23
                        </_nullIf>
24
                    </latitude>
25
                    <longitude>
24
                    </latitude_deg>
25
                    <longitude_deg>
26 26
                        <_nullIf>
27 27
                            <null>0</null>
28 28
                            <type>float</type>
29 29
                            <value>$Longitude</value>
30 30
                        </_nullIf>
31
                    </longitude>
31
                    </longitude_deg>
32 32
                </locationcoords>
33 33
                <locationnarrative>
34 34
                    <_alt>
inputs/FIA/Organism/test.xml.ref
6 6
            <location>
7 7
                <sourceaccessioncode>$PlotCD</sourceaccessioncode>
8 8
                <locationcoords>
9
                    <latitude>
9
                    <latitude_deg>
10 10
                        <_nullIf>
11 11
                            <null>0</null>
12 12
                            <type>float</type>
13 13
                            <value>$DecimalLatitude</value>
14 14
                        </_nullIf>
15
                    </latitude>
16
                    <longitude>
15
                    </latitude_deg>
16
                    <longitude_deg>
17 17
                        <_nullIf>
18 18
                            <null>0</null>
19 19
                            <type>float</type>
20 20
                            <value>$DecimalLongitude</value>
21 21
                        </_nullIf>
22
                    </longitude>
22
                    </longitude_deg>
23 23
                </locationcoords>
24 24
                <locationevent>
25 25
                    <taxonoccurrence>
......
51 51
                            </collectiondate>
52 52
                            <plantobservation>
53 53
                                <stemobservation>
54
                                    <basaldiameter>$BasalDiameter</basaldiameter>
55
                                    <diameterbreastheight>$DBH</diameterbreastheight>
56
                                    <height>$Height</height>
54
                                    <basaldiameter_m>$BasalDiameter</basaldiameter_m>
55
                                    <diameterbreastheight_m>$DBH</diameterbreastheight_m>
56
                                    <height_m>$Height</height_m>
57 57
                                    <stemtag>
58 58
                                        <iscurrent>true</iscurrent>
59 59
                                        <tag>$TreeTag</tag>
inputs/SALVIAS/plotMetadata/test.xml.ref
6 6
            <location>
7 7
                <authorlocationcode>$SiteCode</authorlocationcode>
8 8
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9
                <area>$plot_area_ha</area>
10
                <elevation>
9
                <area_m2>$plot_area_ha</area_m2>
10
                <elevation_m>
11 11
                    <_alt>
12 12
                        <1>
13 13
                            <_replace>
......
50 50
                            </_avg>
51 51
                        </2>
52 52
                    </_alt>
53
                </elevation>
54
                <elevationrange>
53
                </elevation_m>
54
                <elevationrange_m>
55 55
                    <_range>
56 56
                        <from>
57 57
                            <_units>
......
98 98
                            </_units>
99 99
                        </to>
100 100
                    </_range>
101
                </elevationrange>
101
                </elevationrange_m>
102 102
                <locationcoords>
103
                    <latitude>
103
                    <latitude_deg>
104 104
                        <_nullIf>
105 105
                            <null>0</null>
106 106
                            <type>float</type>
107 107
                            <value>$LatDec</value>
108 108
                        </_nullIf>
109
                    </latitude>
110
                    <longitude>
109
                    </latitude_deg>
110
                    <longitude_deg>
111 111
                        <_nullIf>
112 112
                            <null>0</null>
113 113
                            <type>float</type>
114 114
                            <value>$LongDec</value>
115 115
                        </_nullIf>
116
                    </longitude>
116
                    </longitude_deg>
117 117
                </locationcoords>
118 118
                <locationevent>
119 119
                    <method_id><method><name>$PlotMethod</name></method></method_id>
......
130 130
                    </commclass>
131 131
                    <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
132 132
                    <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
133
                    <precipitation>$Precip</precipitation>
133
                    <precipitation_m>$Precip</precipitation_m>
134 134
                    <soilobs>
135 135
                        <acidity>
136 136
                            <_units>
......
246 246
                            </_units>
247 247
                        </texture>
248 248
                    </soilobs>
249
                    <temperature>$Temp</temperature>
249
                    <temperature_c>$Temp</temperature_c>
250 250
                </locationevent>
251 251
                <locationnarrative>
252 252
                    <_merge>
......
270 270
                    </placepath_id>
271 271
                </locationplace>
272 272
                <notespublic>$plot_notes</notespublic>
273
                <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
274
                <slopegradient>$slope_gradient</slopegradient>
273
                <slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg>
274
                <slopegradient_frac>$slope_gradient</slopegradient_frac>
275 275
            </location>
276 276
        </path>
277 277
    </_simplifyPath>
inputs/SALVIAS/stems/test.xml.ref
11 11
                                <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
12 12
                                <stemcount>$NoInd</stemcount>
13 13
                                <stemobservation>
14
                                    <basaldiameter>$basal_diam</basaldiameter>
14
                                    <basaldiameter_m>$basal_diam</basaldiameter_m>
15 15
                                    <definedvalue fkey="tablerecord_id">
16 16
                                        <userdefined_id>
17 17
                                            <userdefined>
......
57 57
                                        </userdefined_id>
58 58
                                        <definedvalue>$stem_notes</definedvalue>
59 59
                                    </definedvalue>
60
                                    <diameterbreastheight>$stem_dbh</diameterbreastheight>
61
                                    <height>$stem_height_m</height>
62
                                    <heightfirstbranch>$stem_height_first_branch_m</heightfirstbranch>
60
                                    <diameterbreastheight_m>$stem_dbh</diameterbreastheight_m>
61
                                    <height_m>$stem_height_m</height_m>
62
                                    <heightfirstbranch_m>$stem_height_first_branch_m</heightfirstbranch_m>
63 63
                                    <sourceaccessioncode>$stem_id</sourceaccessioncode>
64 64
                                    <stemtag>
65 65
                                        <iscurrent>
inputs/U/Specimen/VegBIEN.csv
1 1
U,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
4
Lat,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
5
Long,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
4
Lat,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
5
Long,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
6 6
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
7 7
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
8 8
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
21 21
                        </2>
22 22
                    </_alt>
23 23
                </authorlocationcode>
24
                <elevation>
24
                <elevation_m>
25 25
                    <_alt>
26 26
                        <1>
27 27
                            <_replace>
......
64 64
                            </_avg>
65 65
                        </2>
66 66
                    </_alt>
67
                </elevation>
68
                <elevationrange>
67
                </elevation_m>
68
                <elevationrange_m>
69 69
                    <_range>
70 70
                        <from>
71 71
                            <_units>
......
112 112
                            </_units>
113 113
                        </to>
114 114
                    </_range>
115
                </elevationrange>
115
                </elevationrange_m>
116 116
                <locationcoords>
117
                    <coordsaccuracy><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy>
117
                    <coordsaccuracy_deg><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg>
118 118
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
119
                    <latitude>
119
                    <latitude_deg>
120 120
                        <_alt>
121 121
                            <1>
122 122
                                <_nullIf>
......
133 133
                                </_nullIf>
134 134
                            </2>
135 135
                        </_alt>
136
                    </latitude>
137
                    <longitude>
136
                    </latitude_deg>
137
                    <longitude_deg>
138 138
                        <_alt>
139 139
                            <1>
140 140
                                <_nullIf>
......
151 151
                                </_nullIf>
152 152
                            </2>
153 153
                        </_alt>
154
                    </longitude>
154
                    </longitude_deg>
155 155
                </locationcoords>
156 156
                <locationevent>
157 157
                    <taxonoccurrence>
......
279 279
                        </taxondetermination>
280 280
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
281 281
                    </taxonoccurrence>
282
                    <waterdepth>
282
                    <waterdepth_m>
283 283
                        <_avg>
284 284
                            <max>
285 285
                                <_units>
......
308 308
                                </_units>
309 309
                            </min>
310 310
                        </_avg>
311
                    </waterdepth>
311
                    </waterdepth_m>
312 312
                </locationevent>
313 313
                <locationnarrative>$Locality</locationnarrative>
314 314
                <locationplace>
inputs/NCU-NCSC/Specimen/VegBIEN.csv
2 2
Accession Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 4
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
5
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
6
Accuracy,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1,
7
Lat (-=S),"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
8
Long (-=W),"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
5
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
6
Accuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
7
Lat (-=S),"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
8
Long (-=W),"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
9 9
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
10 10
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
11 11
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
inputs/CTFS/Plot/VegBIEN.csv
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 5
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7
SizeOfSite,/location/area,
8
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7
SizeOfSite,/location/area_m2,
8
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
9 9
ShapeOfSite,/location/locationcoords/footprintgeometry_dwc,
10
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
11
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
10
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
11
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
12 12
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
13 13
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
14 14
DescriptionOfSite,/location/locationnarrative/_merge/1,
inputs/FIA/Organism/VegBIEN.csv
2 2
PlotCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3
PlotCD,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
4 4
PlotCD,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5
DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
6
DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
5
DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
6
DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
7 7
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 8
MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
9 9
MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
10 10
MeasYear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
11
BasalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
12
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
13
Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
11
BasalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m,
12
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
13
Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
14 14
TreeTag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
15 15
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
16 16
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
inputs/SALVIAS/plotMetadata/VegBIEN.csv
4 4
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
5 5
SiteCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
6 6
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
7
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
8
Elev,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
9
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
10
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
12
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
13
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14
LatDec,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15
LongDec,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
7
plot_area_ha,/location/area_m2,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
8
Elev,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
9
elev_max_m,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
10
elev_min_m,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
elev_min_m,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
12
elev_max_m,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
13
elev_min_m,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14
LatDec,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
15
LongDec,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
16 16
PlotMethod,/location/locationevent/*_id/method/name,
17 17
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
18 18
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
......
21 21
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
22 22
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
23 23
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff