Revision 8078
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/HVAA/Specimen/VegBIEN.csv | ||
---|---|---|
84 | 84 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
85 | 85 |
locality,/location/locationnarrative/_merge/1, |
86 | 86 |
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?" |
87 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
87 | 88 |
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value, |
88 | 89 |
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc, |
89 | 90 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
... | ... | |
97 | 98 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
98 | 99 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
99 | 100 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
100 |
locationRemarks,/location/notespublic, |
|
101 | 101 |
verbatimElevation,/location/verbatimelevation, |
102 | 102 |
associatedTaxa,,** No join mapping for associatedTaxa ** |
103 | 103 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
inputs/HVAA/Specimen/test.xml.ref | ||
---|---|---|
230 | 230 |
<value>$habitat</value> |
231 | 231 |
</_label> |
232 | 232 |
</3> |
233 |
<4>$locationRemarks</4> |
|
233 | 234 |
</_merge> |
234 | 235 |
</locationnarrative> |
235 | 236 |
<locationplace> |
... | ... | |
289 | 290 |
</place> |
290 | 291 |
</place_id> |
291 | 292 |
</locationplace> |
292 |
<notespublic>$locationRemarks</notespublic> |
|
293 | 293 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
294 | 294 |
</location> |
295 | 295 |
</path> |
inputs/ACAD/Specimen/VegBIEN.csv | ||
---|---|---|
70 | 70 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
71 | 71 |
locality,/location/locationnarrative/_merge/1, |
72 | 72 |
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?" |
73 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
73 | 74 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
74 | 75 |
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
75 | 76 |
continent,/location/locationplace/*_id/place/continent, |
... | ... | |
81 | 82 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
82 | 83 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
83 | 84 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
84 |
locationRemarks,/location/notespublic, |
|
85 | 85 |
verbatimElevation,/location/verbatimelevation, |
86 | 86 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
87 | 87 |
bibliographicCitation,,** No join mapping for bibliographicCitation ** |
inputs/ACAD/Specimen/test.xml.ref | ||
---|---|---|
227 | 227 |
<value>$habitat</value> |
228 | 228 |
</_label> |
229 | 229 |
</3> |
230 |
<4>$locationRemarks</4> |
|
230 | 231 |
</_merge> |
231 | 232 |
</locationnarrative> |
232 | 233 |
<locationplace> |
... | ... | |
284 | 285 |
</place> |
285 | 286 |
</place_id> |
286 | 287 |
</locationplace> |
287 |
<notespublic>$locationRemarks</notespublic> |
|
288 | 288 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
289 | 289 |
</location> |
290 | 290 |
</path> |
inputs/SALVIAS/plotMetadata_/VegBIEN.csv | ||
---|---|---|
50 | 50 |
Temp,/location/locationevent/temperature_c, |
51 | 51 |
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" |
52 | 52 |
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?" |
53 |
plot_notes,/location/locationnarrative/_merge/4, |
|
53 | 54 |
LatDec,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
54 | 55 |
LongDec,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
55 | 56 |
lat_string,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude, |
... | ... | |
63 | 64 |
pol2,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,Brad: No pol2=countyParish |
64 | 65 |
PolDiv1,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince |
65 | 66 |
PolDiv1,/location/locationplace/*_id/place/stateprovince,Brad: No; pol1=stateProvince |
66 |
plot_notes,/location/notespublic, |
|
67 | 67 |
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value, |
68 | 68 |
slope_gradient,/location/slopegradient_fraction/_alt/1, |
69 | 69 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
inputs/SALVIAS/plotMetadata_/test.xml.ref | ||
---|---|---|
121 | 121 |
<value>$Habitat</value> |
122 | 122 |
</_label> |
123 | 123 |
</3> |
124 |
<4>$plot_notes</4> |
|
124 | 125 |
</_merge> |
125 | 126 |
</locationnarrative> |
126 | 127 |
<locationplace> |
... | ... | |
180 | 181 |
</place> |
181 | 182 |
</place_id> |
182 | 183 |
</locationplace> |
183 |
<notespublic>$plot_notes</notespublic> |
|
184 | 184 |
<slopeaspect_deg><_compass><value>$slope_aspect</value></_compass></slopeaspect_deg> |
185 | 185 |
<slopegradient_fraction>$slope_gradient</slopegradient_fraction> |
186 | 186 |
</location> |
... | ... | |
189 | 189 |
</path> |
190 | 190 |
</_setDefault> |
191 | 191 |
</VegBIEN> |
192 |
Inserted 16 new rows into database |
|
192 |
Inserted 28 new rows into database |
inputs/HIBG/Specimen/VegBIEN.csv | ||
---|---|---|
70 | 70 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
71 | 71 |
locality,/location/locationnarrative/_merge/1, |
72 | 72 |
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?" |
73 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
73 | 74 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
74 | 75 |
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
75 | 76 |
verbatimCoordinates,/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates, |
... | ... | |
82 | 83 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
83 | 84 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
84 | 85 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
85 |
locationRemarks,/location/notespublic, |
|
86 | 86 |
verbatimElevation,/location/verbatimelevation, |
87 | 87 |
associatedMedia,,** No join mapping for associatedMedia ** |
88 | 88 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
inputs/HIBG/Specimen/test.xml.ref | ||
---|---|---|
209 | 209 |
<value>$habitat</value> |
210 | 210 |
</_label> |
211 | 211 |
</3> |
212 |
<4>$locationRemarks</4> |
|
212 | 213 |
</_merge> |
213 | 214 |
</locationnarrative> |
214 | 215 |
<locationplace> |
... | ... | |
267 | 268 |
</place> |
268 | 269 |
</place_id> |
269 | 270 |
</locationplace> |
270 |
<notespublic>$locationRemarks</notespublic> |
|
271 | 271 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
272 | 272 |
</location> |
273 | 273 |
</path> |
inputs/Madidi/LocationObservation/VegBIEN.csv | ||
---|---|---|
39 | 39 |
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists/_first/1", |
40 | 40 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists/_first/2", |
41 | 41 |
Locality,/location/locationnarrative/_merge/1, |
42 |
Notes,/location/locationnarrative/_merge/4, |
|
43 |
Notes 2,/location/locationnarrative/_merge/4, |
|
42 | 44 |
LatitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
43 | 45 |
LongitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
44 | 46 |
LatitudeDecDeg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
45 | 47 |
LongitudeDecDeg,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
46 |
Notes,/location/notespublic, |
|
47 |
Notes 2,/location/notespublic, |
|
48 | 48 |
Slope,/location/slopegradient_fraction/_alt/1, |
49 | 49 |
PlotName,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists/_first/1", |
50 | 50 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists/_first/2", |
inputs/Madidi/LocationObservation/test.xml.ref | ||
---|---|---|
38 | 38 |
<texture>$Textural Class</texture> |
39 | 39 |
</soilsample> |
40 | 40 |
</locationevent> |
41 |
<locationnarrative>$Locality</locationnarrative> |
|
41 |
<locationnarrative> |
|
42 |
<_merge> |
|
43 |
<1>$Locality</1> |
|
44 |
<4> |
|
45 |
<_alt> |
|
46 |
<0>$Notes</0> |
|
47 |
<1>$Notes 2</1> |
|
48 |
</_alt> |
|
49 |
</4> |
|
50 |
</_merge> |
|
51 |
</locationnarrative> |
|
42 | 52 |
<locationplace> |
43 | 53 |
<place_id> |
44 | 54 |
<place> |
... | ... | |
87 | 97 |
</place> |
88 | 98 |
</place_id> |
89 | 99 |
</locationplace> |
90 |
<notespublic> |
|
91 |
<_alt> |
|
92 |
<0>$Notes</0> |
|
93 |
<1>$Notes 2</1> |
|
94 |
</_alt> |
|
95 |
</notespublic> |
|
96 | 100 |
<slopegradient_fraction>$Slope</slopegradient_fraction> |
97 | 101 |
</location> |
98 | 102 |
</path> |
inputs/Madidi/Location/VegBIEN.csv | ||
---|---|---|
14 | 14 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
15 | 15 |
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
16 | 16 |
LocalityDescription,/location/locationnarrative/_merge/1, |
17 |
Note,/location/locationnarrative/_merge/4, |
|
17 | 18 |
LatitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
18 | 19 |
LongitudeDecDeg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
19 | 20 |
CountryName,/location/locationplace/*_id/place/country, |
... | ... | |
24 | 25 |
LowerName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
25 | 26 |
UpperName,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
26 | 27 |
UpperName,/location/locationplace/*_id/place/stateprovince, |
27 |
Note,/location/notespublic, |
|
28 | 28 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
29 | 29 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
30 | 30 |
FirstSurveyDate,,** No join mapping for *FirstSurveyDate ** |
inputs/Madidi/Location/test.xml.ref | ||
---|---|---|
18 | 18 |
</elevation_m> |
19 | 19 |
<iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated> |
20 | 20 |
<landform>$Topography</landform> |
21 |
<locationnarrative>$LocalityDescription</locationnarrative> |
|
21 |
<locationnarrative> |
|
22 |
<_merge> |
|
23 |
<1>$LocalityDescription</1> |
|
24 |
<4>$Note</4> |
|
25 |
</_merge> |
|
26 |
</locationnarrative> |
|
22 | 27 |
<locationplace> |
23 | 28 |
<place_id> |
24 | 29 |
<place> |
... | ... | |
73 | 78 |
</place> |
74 | 79 |
</place_id> |
75 | 80 |
</locationplace> |
76 |
<notespublic>$Note</notespublic> |
|
77 | 81 |
</location> |
78 | 82 |
</path> |
79 | 83 |
</_simplifyPath> |
inputs/ARIZ/omoccurrences/VegBIEN.csv | ||
---|---|---|
77 | 77 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
78 | 78 |
locality,/location/locationnarrative/_merge/1, |
79 | 79 |
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?" |
80 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
80 | 81 |
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value, |
81 | 82 |
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc, |
82 | 83 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
... | ... | |
90 | 91 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
91 | 92 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
92 | 93 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
93 |
locationRemarks,/location/notespublic, |
|
94 | 94 |
verbatimElevation,/location/verbatimelevation, |
95 | 95 |
associatedCollectors,,** No join mapping for *associatedCollectors ** |
96 | 96 |
associatedOccurrences,,** No join mapping for associatedOccurrences ** |
inputs/ARIZ/omoccurrences/test.xml.ref | ||
---|---|---|
184 | 184 |
<value>$habitat</value> |
185 | 185 |
</_label> |
186 | 186 |
</3> |
187 |
<4>$locationRemarks</4> |
|
187 | 188 |
</_merge> |
188 | 189 |
</locationnarrative> |
189 | 190 |
<locationplace> |
... | ... | |
243 | 244 |
</place> |
244 | 245 |
</place_id> |
245 | 246 |
</locationplace> |
246 |
<notespublic>$locationRemarks</notespublic> |
|
247 | 247 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
248 | 248 |
</location> |
249 | 249 |
</path> |
inputs/TRT/Specimen/VegBIEN.csv | ||
---|---|---|
74 | 74 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
75 | 75 |
locality,/location/locationnarrative/_merge/1, |
76 | 76 |
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?" |
77 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
77 | 78 |
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value, |
78 | 79 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
79 | 80 |
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
... | ... | |
89 | 90 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
90 | 91 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
91 | 92 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
92 |
locationRemarks,/location/notespublic, |
|
93 | 93 |
verbatimElevation,/location/verbatimelevation, |
94 | 94 |
associatedMedia,,** No join mapping for associatedMedia ** |
95 | 95 |
associatedReferences,,** No join mapping for associatedReferences ** |
inputs/TRT/Specimen/test.xml.ref | ||
---|---|---|
242 | 242 |
<value>$habitat</value> |
243 | 243 |
</_label> |
244 | 244 |
</3> |
245 |
<4>$locationRemarks</4> |
|
245 | 246 |
</_merge> |
246 | 247 |
</locationnarrative> |
247 | 248 |
<locationplace> |
... | ... | |
303 | 304 |
</place> |
304 | 305 |
</place_id> |
305 | 306 |
</locationplace> |
306 |
<notespublic>$locationRemarks</notespublic> |
|
307 | 307 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
308 | 308 |
</location> |
309 | 309 |
</path> |
inputs/MO/Specimen/VegBIEN.csv | ||
---|---|---|
53 | 53 |
qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
54 | 54 |
collectionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
55 | 55 |
locality,/location/locationnarrative/_merge/1, |
56 |
notes,/location/locationnarrative/_merge/4, |
|
56 | 57 |
minlatdecdeg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
57 | 58 |
minlongdecdeg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
58 | 59 |
continent,/location/locationplace/*_id/place/continent, |
... | ... | |
64 | 65 |
lower,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
65 | 66 |
upper,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
66 | 67 |
upper,/location/locationplace/*_id/place/stateprovince, |
67 |
notes,/location/notespublic, |
|
68 | 68 |
coord_method,,** No join mapping for georeferenceProtocol ** |
69 | 69 |
description,,** No join mapping for specimenDescription ** |
70 | 70 |
elev_method,,** No join mapping for *elev_method ** |
inputs/MO/Specimen/test.xml.ref | ||
---|---|---|
152 | 152 |
</taxondetermination> |
153 | 153 |
</taxonoccurrence> |
154 | 154 |
</locationevent> |
155 |
<locationnarrative>$locality</locationnarrative> |
|
155 |
<locationnarrative> |
|
156 |
<_merge> |
|
157 |
<1>$locality</1> |
|
158 |
<4>$notes</4> |
|
159 |
</_merge> |
|
160 |
</locationnarrative> |
|
156 | 161 |
<locationplace> |
157 | 162 |
<place_id> |
158 | 163 |
<place> |
... | ... | |
208 | 213 |
</place> |
209 | 214 |
</place_id> |
210 | 215 |
</locationplace> |
211 |
<notespublic>$notes</notespublic> |
|
212 | 216 |
</location> |
213 | 217 |
</path> |
214 | 218 |
</_simplifyPath> |
inputs/TRTE/Specimen/VegBIEN.csv | ||
---|---|---|
66 | 66 |
recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then", |
67 | 67 |
locality,/location/locationnarrative/_merge/1, |
68 | 68 |
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?" |
69 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
69 | 70 |
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
70 | 71 |
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
71 | 72 |
verbatimCoordinates,/location/locationplace/*_id/place/*_id/coordinates/verbatimcoordinates, |
... | ... | |
79 | 80 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
80 | 81 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
81 | 82 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
82 |
locationRemarks,/location/notespublic, |
|
83 | 83 |
verbatimElevation,/location/verbatimelevation, |
84 | 84 |
associatedMedia,,** No join mapping for associatedMedia ** |
85 | 85 |
associatedReferences,,** No join mapping for associatedReferences ** |
inputs/TRTE/Specimen/test.xml.ref | ||
---|---|---|
205 | 205 |
<value>$habitat</value> |
206 | 206 |
</_label> |
207 | 207 |
</3> |
208 |
<4>$locationRemarks</4> |
|
208 | 209 |
</_merge> |
209 | 210 |
</locationnarrative> |
210 | 211 |
<locationplace> |
... | ... | |
264 | 265 |
</place> |
265 | 266 |
</place_id> |
266 | 267 |
</locationplace> |
267 |
<notespublic>$locationRemarks</notespublic> |
|
268 | 268 |
<verbatimelevation>$verbatimElevation</verbatimelevation> |
269 | 269 |
</location> |
270 | 270 |
</path> |
mappings/VegCore-VegBIEN.csv | ||
---|---|---|
327 | 327 |
locality,/location/locationnarrative/_merge/1, |
328 | 328 |
verbatimLocality,/location/locationnarrative/_merge/2, |
329 | 329 |
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?" |
330 |
locationRemarks,/location/locationnarrative/_merge/4, |
|
330 | 331 |
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value, |
331 | 332 |
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc, |
332 | 333 |
latitude_deg,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/deg, |
... | ... | |
372 | 373 |
latLongInCounty,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_first/2/_and/3, |
373 | 374 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
374 | 375 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
375 |
locationRemarks,/location/notespublic, |
|
376 | 376 |
parentPlotName,/location/parent_id/location/authorlocationcode, |
377 | 377 |
parentLocationID,/location/parent_id/location/sourceaccessioncode, |
378 | 378 |
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value, |
mappings/for_review/VegCore-VegBIEN.csv | ||
---|---|---|
327 | 327 |
locality,//location/locationnarrative, |
328 | 328 |
verbatimLocality,//location/locationnarrative, |
329 | 329 |
habitat,"//location/locationnarrative/_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?" |
330 |
locationRemarks,//location/locationnarrative, |
|
330 | 331 |
coordinateUncertaintyInMeters,//coordinates/coordsaccuracy_m, |
331 | 332 |
footprintWKT,//coordinates/footprintgeometry_dwc, |
332 | 333 |
latitude_deg,//coordinates/latitude_deg/_dms_to_dd/deg, |
... | ... | |
372 | 373 |
latLongInCounty,//place/geovalid, |
373 | 374 |
stateProvince,//place/stateprovince, |
374 | 375 |
stateProvince,//place/stateprovince, |
375 |
locationRemarks,//location/notespublic, |
|
376 | 376 |
parentPlotName,//location/authorlocationcode, |
377 | 377 |
parentLocationID,//location/sourceaccessioncode, |
378 | 378 |
slopeAspect,//location/slopeaspect_deg, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: locationRemarks: Remapped to locationnarrative because location.notespublic is a boolean field