Revision 4753
Added by Aaron Marcuse-Kubitza over 12 years ago
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/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, |
24 |
Precip,/location/locationevent/precipitation, |
|
24 |
Precip,/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/_units:[default=""%"",to=]/value", |
42 |
Temp,/location/locationevent/temperature, |
|
42 |
Temp,/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 |
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
45 | 45 |
MajorGeo,/location/locationplace/*_id/placepath/continent, |
... | ... | |
47 | 47 |
pol2,/location/locationplace/*_id/placepath/county,Brad: No pol2=countyParish |
48 | 48 |
PolDiv1,/location/locationplace/*_id/placepath/stateprovince,Brad: No; pol1=stateProvince |
49 | 49 |
plot_notes,/location/notespublic, |
50 |
slope_aspect,/location/slopeaspect/_alt/1/_compass/value, |
|
51 |
slope_gradient,/location/slopegradient/_alt/1, |
|
50 |
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
|
|
51 |
slope_gradient,/location/slopegradient_frac/_alt/1,
|
|
52 | 52 |
AccessCode,,** No join mapping for AccessCode ** |
53 | 53 |
Country_index,,** No join mapping for Country_index ** |
54 | 54 |
ElevSource,,** No join mapping for ElevSource ** |
inputs/SALVIAS/stems/VegBIEN.csv | ||
---|---|---|
1 | 1 |
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
2 | 2 |
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
3 | 3 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount, |
4 |
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter, |
|
4 |
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter_m,
|
|
5 | 5 |
stem_canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue", |
6 | 6 |
stem_canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue", |
7 | 7 |
gentry_dbh,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue", |
8 | 8 |
stem_liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue", |
9 | 9 |
stem_notes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue", |
10 |
stem_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
|
11 |
stem_height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,"Brad: Same as for height, but applies to individuals stems, not trees. Rare." |
|
12 |
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." |
|
10 |
stem_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
|
|
11 |
stem_height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."
|
|
12 |
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."
|
|
13 | 13 |
stem_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode, |
14 | 14 |
stem_tag1,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
15 | 15 |
stem_tag2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag, |
inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
---|---|---|
41 | 41 |
canopy_form,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue", |
42 | 42 |
canopy_position,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue", |
43 | 43 |
liana_infestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue", |
44 |
temp_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
|
45 |
height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height, |
|
46 |
ht_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch, |
|
44 |
temp_dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m,
|
|
45 |
height_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
|
|
46 |
ht_first_branch_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch_m,
|
|
47 | 47 |
tag1,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag","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" |
48 | 48 |
tag2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
49 |
x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,"Brad: These are important, fundamental values of many tree plots" |
|
50 |
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,Brad: See comment above for x_position |
|
49 |
x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"Brad: These are important, fundamental values of many tree plots"
|
|
50 |
y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,Brad: See comment above for x_position
|
|
51 | 51 |
Ind,/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." |
52 | 52 |
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>" |
53 | 53 |
PlotObsID,/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/U/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</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</value> |
26 | 26 |
</_nullIf> |
27 |
</longitude> |
|
27 |
</longitude_deg>
|
|
28 | 28 |
</locationcoords> |
29 | 29 |
<locationevent> |
30 | 30 |
<taxonoccurrence> |
inputs/GBIF/Specimen/VegBIEN.csv | ||
---|---|---|
2 | 2 |
InstitutionCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1", |
3 | 3 |
CollectionCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1", |
4 | 4 |
CatalogNO,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
5 |
MaximumElevationInMeter,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
|
6 |
MinimumElevationInMeter,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
|
7 |
MinimumElevationInMeter,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
|
8 |
MaximumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
|
9 |
MinimumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
|
10 |
DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
11 |
VerbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
12 |
DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
13 |
VerbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
5 |
MaximumElevationInMeter,"/location/elevation_m/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
|
|
6 |
MinimumElevationInMeter,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
7 |
MinimumElevationInMeter,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
|
|
8 |
MaximumElevationInMeter,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
|
|
9 |
MinimumElevationInMeter,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
|
|
10 |
DecimalLatitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
11 |
VerbatimLatitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
12 |
DecimalLongitude,"/location/locationcoords/longitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
13 |
VerbatimLongitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
14 | 14 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
15 | 15 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
16 | 16 |
CollectionCD,/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/NCU-NCSC/Specimen/test.xml.ref | ||
---|---|---|
15 | 15 |
</2> |
16 | 16 |
</_alt> |
17 | 17 |
</authorlocationcode> |
18 |
<elevation> |
|
18 |
<elevation_m>
|
|
19 | 19 |
<_replace> |
20 | 20 |
<\bca\.?></\bca\.?> |
21 | 21 |
<value>$Elevation</value> |
22 | 22 |
</_replace> |
23 |
</elevation> |
|
23 |
</elevation_m>
|
|
24 | 24 |
<locationcoords> |
25 |
<coordsaccuracy><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy>
|
|
26 |
<latitude> |
|
25 |
<coordsaccuracy_deg><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_deg>
|
|
26 |
<latitude_deg>
|
|
27 | 27 |
<_nullIf> |
28 | 28 |
<null>0</null> |
29 | 29 |
<type>float</type> |
... | ... | |
34 | 34 |
</_replace> |
35 | 35 |
</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> |
... | ... | |
46 | 46 |
</_replace> |
47 | 47 |
</value> |
48 | 48 |
</_nullIf> |
49 |
</longitude> |
|
49 |
</longitude_deg>
|
|
50 | 50 |
</locationcoords> |
51 | 51 |
<locationevent> |
52 | 52 |
<taxonoccurrence> |
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> |
Also available in: Unified diff
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.