Project

General

Profile

« Previous | Next » 

Revision 5861

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore-VegBIEN.csv: Remapped latitude/longitude to new coordinates table

View differences:

inputs/SpeciesLink/Specimen/test.xml.ref
57 57 
                        </min>
58 58 
                    </_avg>
59 59 
                </elevation_m>
60 
                <locationcoords>
61 
                    <coordsaccuracy_deg>
62 
                        <_noCV>
63 
                            <value>
64 
                                <_alt>
65 
                                    <1>$dwc_terms_coordinateUncertaintyInMeters</1>
66 
                                    <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
67 
                                </_alt>
68 
                            </value>
69 
                        </_noCV>
70 
                    </coordsaccuracy_deg>
71 
                    <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
72 
                    <latitude_deg>
73 
                        <_nullIf>
74 
                            <null>0</null>
75 
                            <type>float</type>
76 
                            <value>
77 
                                <_alt>
78 
                                    <0>$conceptual_darwin_2003_1_0_Latitude</0>
79 
                                    <1>$dwc_geospatial_DecimalLatitude</1>
80 
                                    <2>$dwc_terms_decimalLatitude</2>
81 
                                </_alt>
82 
                            </value>
83 
                        </_nullIf>
84 
                    </latitude_deg>
85 
                    <longitude_deg>
86 
                        <_nullIf>
87 
                            <null>0</null>
88 
                            <type>float</type>
89 
                            <value>
90 
                                <_alt>
91 
                                    <0>$conceptual_darwin_2003_1_0_Longitude</0>
92 
                                    <1>$dwc_geospatial_DecimalLongitude</1>
93 
                                    <2>$dwc_terms_decimalLongitude</2>
94 
                                </_alt>
95 
                            </value>
96 
                        </_nullIf>
97 
                    </longitude_deg>
98 
                    <verbatimlatitude>
99 
                        <_alt>
100 
                            <0>$dwc_geospatial_VerbatimLatitude</0>
101 
                            <1>$dwc_terms_verbatimLatitude</1>
102 
                        </_alt>
103 
                    </verbatimlatitude>
104 
                    <verbatimlongitude>
105 
                        <_alt>
106 
                            <0>$dwc_geospatial_VerbatimLongitude</0>
107 
                            <1>$dwc_terms_verbatimLongitude</1>
108 
                        </_alt>
109 
                    </verbatimlongitude>
110 
                </locationcoords>
111 60 
                <locationevent>
112 61 
                    <taxonoccurrence>
113 62 
                        <aggregateoccurrence>
......
633 582 
                <locationplace>
634 583 
                    <place_id>
635 584 
                        <place>
585 
                            <coordinates_id>
586 
                                <coordinates>
587 
                                    <coordsaccuracy_deg>
588 
                                        <_noCV>
589 
                                            <value>
590 
                                                <_alt>
591 
                                                    <1>$dwc_terms_coordinateUncertaintyInMeters</1>
592 
                                                    <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
593 
                                                </_alt>
594 
                                            </value>
595 
                                        </_noCV>
596 
                                    </coordsaccuracy_deg>
597 
                                    <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
598 
                                    <latitude_deg>
599 
                                        <_nullIf>
600 
                                            <null>0</null>
601 
                                            <type>float</type>
602 
                                            <value>
603 
                                                <_alt>
604 
                                                    <0>$conceptual_darwin_2003_1_0_Latitude</0>
605 
                                                    <1>$dwc_geospatial_DecimalLatitude</1>
606 
                                                    <2>$dwc_terms_decimalLatitude</2>
607 
                                                </_alt>
608 
                                            </value>
609 
                                        </_nullIf>
610 
                                    </latitude_deg>
611 
                                    <longitude_deg>
612 
                                        <_nullIf>
613 
                                            <null>0</null>
614 
                                            <type>float</type>
615 
                                            <value>
616 
                                                <_alt>
617 
                                                    <0>$conceptual_darwin_2003_1_0_Longitude</0>
618 
                                                    <1>$dwc_geospatial_DecimalLongitude</1>
619 
                                                    <2>$dwc_terms_decimalLongitude</2>
620 
                                                </_alt>
621 
                                            </value>
622 
                                        </_nullIf>
623 
                                    </longitude_deg>
624 
                                    <verbatimlatitude>
625 
                                        <_alt>
626 
                                            <0>$dwc_geospatial_VerbatimLatitude</0>
627 
                                            <1>$dwc_terms_verbatimLatitude</1>
628 
                                        </_alt>
629 
                                    </verbatimlatitude>
630 
                                    <verbatimlongitude>
631 
                                        <_alt>
632 
                                            <0>$dwc_geospatial_VerbatimLongitude</0>
633 
                                            <1>$dwc_terms_verbatimLongitude</1>
634 
                                        </_alt>
635 
                                    </verbatimlongitude>
636 
                                </coordinates>
637 
                            </coordinates_id>
636 638 
                            <continent>
637 639 
                                <_alt>
638 640 
                                    <0>$conceptual_darwin_2003_1_0_ContinentOcean</0>
inputs/MO/Specimen/VegBIEN.csv
5 5 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
6 6 
MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
7 7 
MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
8 
latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
9 
longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
10 8 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
11 9 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
12 10 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
48 46 
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
49 47 
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
50 48 
Locality,/location/locationnarrative/_merge/1,
49 
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
50 
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
51 51 
ContinentOcean,/location/locationplace/*_id/place/continent,
52 52 
Country,/location/locationplace/*_id/place/country,
53 53 
County,/location/locationplace/*_id/place/county,
inputs/VegBank/plot_/test.xml.ref
9 9 
                <area_m2>$area</area_m2>
10 10 
                <elevation_m>$elevation</elevation_m>
11 11 
                <landform>$landform</landform>
12 
                <locationcoords>
13 
                    <coordsaccuracy_deg><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy_deg>
14 
                    <footprintgeometry_dwc>$shape</footprintgeometry_dwc>
15 
                    <latitude_deg>
16 
                        <_nullIf>
17 
                            <null>0</null>
18 
                            <type>float</type>
19 
                            <value>$latitude</value>
20 
                        </_nullIf>
21 
                    </latitude_deg>
22 
                    <longitude_deg>
23 
                        <_nullIf>
24 
                            <null>0</null>
25 
                            <type>float</type>
26 
                            <value>$longitude</value>
27 
                        </_nullIf>
28 
                    </longitude_deg>
29 
                </locationcoords>
30 12 
                <locationnarrative>$locationnarrative</locationnarrative>
31 13 
                <locationplace>
32 14 
                    <place_id>
33 15 
                        <place>
16 
                            <coordinates_id>
17 
                                <coordinates>
18 
                                    <coordsaccuracy_deg><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy_deg>
19 
                                    <footprintgeometry_dwc>$shape</footprintgeometry_dwc>
20 
                                    <latitude_deg>
21 
                                        <_nullIf>
22 
                                            <null>0</null>
23 
                                            <type>float</type>
24 
                                            <value>$latitude</value>
25 
                                        </_nullIf>
26 
                                    </latitude_deg>
27 
                                    <longitude_deg>
28 
                                        <_nullIf>
29 
                                            <null>0</null>
30 
                                            <type>float</type>
31 
                                            <value>$longitude</value>
32 
                                        </_nullIf>
33 
                                    </longitude_deg>
34 
                                </coordinates>
35 
                            </coordinates_id>
34 36 
                            <continent>$continent</continent>
35 37 
                            <country>
36 38 
                                <_alt>
inputs/U/Specimen/VegBIEN.csv
2 2 
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
4 4 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
5 
Lat,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
6 
Long,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
7 5 
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
8 6 
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
9 7 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
35 33 
Newgazett,"/location/locationnarrative/_merge/2/_join/1/_label[label=""gazetteer""]/value/_join/2",Only used in 1 row
36 34 
Locnotes,/location/locationnarrative/_merge/2/_join/2,
37 35 
Ecology,"/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?"
36 
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
37 
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
38 38 
Country,/location/locationplace/*_id/place/country,
39 39 
Alt,,** No join mapping for *Alt ** What is this?
40 40 
Alt2,,** No join mapping for *Alt2 ** What is this?
inputs/ARIZ/Specimen/VegBIEN.csv
8 8 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric
9 9 
MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,"Contains some verbatim values, including ranges and units"
10 10 
MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,"Contains some verbatim values, including ranges and units"
11 
CoordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
12 
BoundingBox,/location/locationcoords/footprintgeometry_dwc,
13 
DecimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
14 
DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
15 11 
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/0,
16 12 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
17 13 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
......
72 68 
MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,
73 69 
MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,
74 70 
Locality,/location/locationnarrative/_merge/1,
71 
CoordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
72 
BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
73 
DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
74 
DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
75 75 
ContinentOcean,/location/locationplace/*_id/place/continent,
76 76 
Country,/location/locationplace/*_id/place/country,
77 77 
County,/location/locationplace/*_id/place/county,
inputs/GBIF/Specimen/VegBIEN.csv
5 5 
CatalogNO,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
6 6 
MaximumElevationInMeter,/location/elevation_m/_alt/2/_avg/max,
7 7 
MinimumElevationInMeter,/location/elevation_m/_alt/2/_avg/min,
8 
VerbatimLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
9 
VerbatimLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
10 8 
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
11 9 
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
12 10 
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
......
54 52 
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
55 53 
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
56 54 
Locality,/location/locationnarrative/_merge/1,
55 
VerbatimLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
56 
VerbatimLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
57 57 
Country,/location/locationplace/*_id/place/country,
58 58 
County,/location/locationplace/*_id/place/county,
59 59 
StateProvince,/location/locationplace/*_id/place/stateprovince,
inputs/NCU-NCSC/Specimen/VegBIEN.csv
4 4 
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
5 5 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
6 6 
Elevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
7 
Accuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
8 
Lat (-=S),"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
9 
Long (-=W),"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
10 7 
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
11 8 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
12 9 
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
......
18 15 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
19 16 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/binomial,
20 17 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
18 
Accuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
19 
Lat (-=S),"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
20 
Long (-=W),"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
21 21 
Country,/location/locationplace/*_id/place/country,
22 22 
County,/location/locationplace/*_id/place/county,
23 23 
State,/location/locationplace/*_id/place/stateprovince,
inputs/SpeciesLink/Specimen/VegBIEN.csv
19 19 
conceptual_darwin_2003_1_0_MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
20 20 
dwc_dwcore_MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
21 21 
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
22 
dwc_terms_coordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
23 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
24 
conceptual_darwin_2003_1_0_BoundingBox,/location/locationcoords/footprintgeometry_dwc,
25 
conceptual_darwin_2003_1_0_Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
26 
dwc_geospatial_DecimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
27 
dwc_terms_decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
28 
conceptual_darwin_2003_1_0_Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
29 
dwc_geospatial_DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
30 
dwc_terms_decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
31 
dwc_geospatial_VerbatimLatitude,/location/locationcoords/verbatimlatitude,Contains a mix of DMS and other verbatim coordinates
32 
dwc_terms_verbatimLatitude,/location/locationcoords/verbatimlatitude,
33 
dwc_geospatial_VerbatimLongitude,/location/locationcoords/verbatimlongitude,Contains a mix of DMS and other verbatim coordinates
34 
dwc_terms_verbatimLongitude,/location/locationcoords/verbatimlongitude,
35 22 
conceptual_darwin_2003_1_0_DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
36 23 
conceptual_darwin_2003_1_0_MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
37 24 
conceptual_darwin_2003_1_0_YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
208 195 
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
209 196 
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
210 197 
dwc_terms_locality,/location/locationnarrative/_merge/1,
198 
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
199 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
200 
conceptual_darwin_2003_1_0_BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
201 
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
202 
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
203 
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
204 
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
205 
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
206 
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
207 
dwc_geospatial_VerbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,Contains a mix of DMS and other verbatim coordinates
208 
dwc_terms_verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
209 
dwc_geospatial_VerbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,Contains a mix of DMS and other verbatim coordinates
210 
dwc_terms_verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
211 211 
conceptual_darwin_2003_1_0_ContinentOcean,/location/locationplace/*_id/place/continent,
212 212 
dwc_dwcore_Continent,/location/locationplace/*_id/place/continent,
213 213 
dwc_terms_continent,/location/locationplace/*_id/place/continent,
inputs/bien_web/observation/test.xml.ref
7 7 
                <authorlocationcode>$plotCode</authorlocationcode>
8 8 
                <area_m2><_ha_to_m2><value>$plotAreaHa</value></_ha_to_m2></area_m2>
9 9 
                <elevation_m>$elevation_m</elevation_m>
10 
                <locationcoords>
11 
                    <latitude_deg>
12 
                        <_nullIf>
13 
                            <null>0</null>
14 
                            <type>float</type>
15 
                            <value>$latitude</value>
16 
                        </_nullIf>
17 
                    </latitude_deg>
18 
                    <longitude_deg>
19 
                        <_nullIf>
20 
                            <null>0</null>
21 
                            <type>float</type>
22 
                            <value>$longitude</value>
23 
                        </_nullIf>
24 
                    </longitude_deg>
25 
                </locationcoords>
26 10 
                <locationevent>
27 11 
                    <method_id><method><name>$plotMethod</name></method></method_id>
28 12 
                    <taxonoccurrence>
......
158 142 
                <locationplace>
159 143 
                    <place_id>
160 144 
                        <place>
145 
                            <coordinates_id>
146 
                                <coordinates>
147 
                                    <latitude_deg>
148 
                                        <_nullIf>
149 
                                            <null>0</null>
150 
                                            <type>float</type>
151 
                                            <value>$latitude</value>
152 
                                        </_nullIf>
153 
                                    </latitude_deg>
154 
                                    <longitude_deg>
155 
                                        <_nullIf>
156 
                                            <null>0</null>
157 
                                            <type>float</type>
158 
                                            <value>$longitude</value>
159 
                                        </_nullIf>
160 
                                    </longitude_deg>
161 
                                </coordinates>
162 
                            </coordinates_id>
161 163 
                            <country>$country</country>
162 164 
                            <county>$countyParish</county>
163 165 
                            <stateprovince>$stateProvince</stateprovince>
inputs/VegBank/plot_/VegBIEN.csv
7 7 
area,/location/area_m2,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
8 8 
elevation,/location/elevation_m/_alt/1,"""The elevation of the plot origin in meters above sea level"" (elevation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
9 9 
landform,/location/landform,
10 
locationaccuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1,
11 
shape,/location/locationcoords/footprintgeometry_dwc,
12 
latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
13 
longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
14 10 
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
15 11 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
16 12 
authorplotcode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
17 13 
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
18 14 
locationnarrative,/location/locationnarrative/_merge/1,
15 
locationaccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
16 
shape,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
17 
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
18 
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
19 19 
continent,/location/locationplace/*_id/place/continent,
20 20 
area|country|territory,/location/locationplace/*_id/place/country,
21 21 
country,/location/locationplace/*_id/place/country,
inputs/XAL/Specimen/VegBIEN.csv
5 5 
darwin:CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
6 6 
darwin:MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
7 7 
darwin:MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
8 
darwin:CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
9 
darwin:Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
10 
darwin:Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
11 8 
darwin:DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
12 9 
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
13 10 
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
60 57 
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
61 58 
darwin:MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
62 59 
darwin:Locality,/location/locationnarrative/_merge/1,
60 
darwin:CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
61 
darwin:Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
62 
darwin:Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
63 63 
darwin:ContinentOcean,/location/locationplace/*_id/place/continent,
64 64 
darwin:Country,/location/locationplace/*_id/place/country,
65 65 
darwin:County,/location/locationplace/*_id/place/county,
inputs/TEAM/VL/VegBIEN.csv
4 4 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6 
Subplot Number,/location/authorlocationcode,
7 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
8 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
9 7 
Method,/location/locationevent/*_id/method/name,
10 8 
Site Name,/location/locationevent/*_id/project/projectname,
11 9 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
......
35 33 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
36 34 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
37 35 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
36 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
37 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
38 38 
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",
39 39 
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
40 40 
Subplot Number,/location/sourceaccessioncode/_join/2,
inputs/TEAM/VL/test.xml.ref
6 6 
            <location>
7 7 
                <parent_id><location><authorlocationcode>$1ha Plot Number</authorlocationcode></location></parent_id>
8 8 
                <authorlocationcode>$Subplot Number</authorlocationcode>
9 
                <locationcoords>
10 
                    <latitude_deg>
11 
                        <_nullIf>
12 
                            <null>0</null>
13 
                            <type>float</type>
14 
                            <value>$Latitude</value>
15 
                        </_nullIf>
16 
                    </latitude_deg>
17 
                    <longitude_deg>
18 
                        <_nullIf>
19 
                            <null>0</null>
20 
                            <type>float</type>
21 
                            <value>$Longitude</value>
22 
                        </_nullIf>
23 
                    </longitude_deg>
24 
                </locationcoords>
25 9 
                <locationevent>
26 10 
                    <method_id><method><name>$Method</name></method></method_id>
27 11 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
......
131 115 
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
132 116 
                    </taxonoccurrence>
133 117 
                </locationevent>
118 
                <locationplace>
119 
                    <place_id>
120 
                        <place>
121 
                            <coordinates_id>
122 
                                <coordinates>
123 
                                    <latitude_deg>
124 
                                        <_nullIf>
125 
                                            <null>0</null>
126 
                                            <type>float</type>
127 
                                            <value>$Latitude</value>
128 
                                        </_nullIf>
129 
                                    </latitude_deg>
130 
                                    <longitude_deg>
131 
                                        <_nullIf>
132 
                                            <null>0</null>
133 
                                            <type>float</type>
134 
                                            <value>$Longitude</value>
135 
                                        </_nullIf>
136 
                                    </longitude_deg>
137 
                                </coordinates>
138 
                            </coordinates_id>
139 
                        </place>
140 
                    </place_id>
141 
                </locationplace>
134 142 
                <sourceaccessioncode>
135 143 
                    <_join>
136 144 
                        <1>$1ha Plot Number</1>
......
141 149 
        </path>
142 150 
    </_simplifyPath>
143 151 
</VegBIEN>
144 
Inserted 34 new rows into database
152 
Inserted 32 new rows into database
inputs/TEAM/VT/VegBIEN.csv
4 4 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6 
Subplot Number,/location/authorlocationcode,
7 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
8 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
9 7 
Spatial Method,/location/locationevent/*_id/method/name,
10 8 
Site Name,/location/locationevent/*_id/project/projectname,
11 9 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
......
35 33 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
36 34 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
37 35 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
36 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
37 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
38 38 
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",
39 39 
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
40 40 
Subplot Number,/location/sourceaccessioncode/_join/2,
inputs/TEAM/VT/test.xml.ref
6 6 
            <location>
7 7 
                <parent_id><location><authorlocationcode>$1ha Plot Number</authorlocationcode></location></parent_id>
8 8 
                <authorlocationcode>$Subplot Number</authorlocationcode>
9 
                <locationcoords>
10 
                    <latitude_deg>
11 
                        <_nullIf>
12 
                            <null>0</null>
13 
                            <type>float</type>
14 
                            <value>$Latitude</value>
15 
                        </_nullIf>
16 
                    </latitude_deg>
17 
                    <longitude_deg>
18 
                        <_nullIf>
19 
                            <null>0</null>
20 
                            <type>float</type>
21 
                            <value>$Longitude</value>
22 
                        </_nullIf>
23 
                    </longitude_deg>
24 
                </locationcoords>
25 9 
                <locationevent>
26 10 
                    <method_id><method><name>$Spatial Method</name></method></method_id>
27 11 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
......
131 115 
                        <verbatimcollectorname>$Names of Collectors</verbatimcollectorname>
132 116 
                    </taxonoccurrence>
133 117 
                </locationevent>
118 
                <locationplace>
119 
                    <place_id>
120 
                        <place>
121 
                            <coordinates_id>
122 
                                <coordinates>
123 
                                    <latitude_deg>
124 
                                        <_nullIf>
125 
                                            <null>0</null>
126 
                                            <type>float</type>
127 
                                            <value>$Latitude</value>
128 
                                        </_nullIf>
129 
                                    </latitude_deg>
130 
                                    <longitude_deg>
131 
                                        <_nullIf>
132 
                                            <null>0</null>
133 
                                            <type>float</type>
134 
                                            <value>$Longitude</value>
135 
                                        </_nullIf>
136 
                                    </longitude_deg>
137 
                                </coordinates>
138 
                            </coordinates_id>
139 
                        </place>
140 
                    </place_id>
141 
                </locationplace>
134 142 
                <sourceaccessioncode>
135 143 
                    <_join>
136 144 
                        <1>$1ha Plot Number</1>
......
141 149 
        </path>
142 150 
    </_simplifyPath>
143 151 
</VegBIEN>
144 
Inserted 31 new rows into database
152 
Inserted 30 new rows into database
inputs/TEAM/TEAM_Sites/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2 
Name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
3 3 
Name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
4 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
5 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
6 4 
Site Name,/location/locationevent/*_id/project/projectname,
7 5 
Name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
8 6 
CollectionDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
9 7 
CollectionDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
10 8 
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
9 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
10 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
11 11 
Name,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
12 12 
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate **
inputs/TEAM/TEAM_Sites/test.xml.ref
5 5 
        <path>
6 6 
            <location>
7 7 
                <authorlocationcode>$Name</authorlocationcode>
8 
                <locationcoords>
9 
                    <latitude_deg>
10 
                        <_nullIf>
11 
                            <null>0</null>
12 
                            <type>float</type>
13 
                            <value>$Latitude</value>
14 
                        </_nullIf>
15 
                    </latitude_deg>
16 
                    <longitude_deg>
17 
                        <_nullIf>
18 
                            <null>0</null>
19 
                            <type>float</type>
20 
                            <value>$Longitude</value>
21 
                        </_nullIf>
22 
                    </longitude_deg>
23 
                </locationcoords>
24 8 
                <locationevent>
25 9 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
26 10 
                    <obsenddate><_date><date><_dateRangeEnd><value>$CollectionDate</value></_dateRangeEnd></date></_date></obsenddate>
27 11 
                    <obsstartdate><_date><date><_dateRangeStart><value>$CollectionDate</value></_dateRangeStart></date></_date></obsstartdate>
28 12 
                </locationevent>
13 
                <locationplace>
14 
                    <place_id>
15 
                        <place>
16 
                            <coordinates_id>
17 
                                <coordinates>
18 
                                    <latitude_deg>
19 
                                        <_nullIf>
20 
                                            <null>0</null>
21 
                                            <type>float</type>
22 
                                            <value>$Latitude</value>
23 
                                        </_nullIf>
24 
                                    </latitude_deg>
25 
                                    <longitude_deg>
26 
                                        <_nullIf>
27 
                                            <null>0</null>
28 
                                            <type>float</type>
29 
                                            <value>$Longitude</value>
30 
                                        </_nullIf>
31 
                                    </longitude_deg>
32 
                                </coordinates>
33 
                            </coordinates_id>
34 
                        </place>
35 
                    </place_id>
36 
                </locationplace>
29 37 
            </location>
30 38 
        </path>
31 39 
    </_simplifyPath>
32 40 
</VegBIEN>
33 
Inserted 8 new rows into database
41 
Inserted 12 new rows into database
inputs/NY/Specimen/VegBIEN.csv
6 6 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
7 7 
MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
8 8 
MinimumElevation,/location/elevation_m/_alt/2/_avg/min/_nullIf:[null=.]/value,
9 
CoordinatePrecision,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/2,
10 
BoundingBox,/location/locationcoords/footprintgeometry_dwc,
11 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
12 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
13 9 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
14 10 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
15 11 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
68 64 
Substrate,"/location/locationnarrative/_merge/1/_join/2/_label[label=""substrate""]/value",
69 65 
Vegetation,"/location/locationnarrative/_merge/1/_join/3/_label[label=""vegetation""]/value",
70 66 
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?"
67 
CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
68 
BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
69 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
70 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
71 71 
ContinentOcean,/location/locationplace/*_id/place/continent,
72 72 
Country,/location/locationplace/*_id/place/country,
73 73 
County,/location/locationplace/*_id/place/county,
inputs/NY/Specimen/test.xml.ref
27 27 
                        </min>
28 28 
                    </_avg>
29 29 
                </elevation_m>
30 
                <locationcoords>
31 
                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
32 
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
33 
                    <latitude_deg>
34 
                        <_nullIf>
35 
                            <null>0</null>
36 
                            <type>float</type>
37 
                            <value>$Latitude</value>
38 
                        </_nullIf>
39 
                    </latitude_deg>
40 
                    <longitude_deg>
41 
                        <_nullIf>
42 
                            <null>0</null>
43 
                            <type>float</type>
44 
                            <value>$Longitude</value>
45 
                        </_nullIf>
46 
                    </longitude_deg>
47 
                </locationcoords>
48 30 
                <locationevent>
49 31 
                    <taxonoccurrence>
50 32 
                        <aggregateoccurrence>
......
337 319 
                <locationplace>
338 320 
                    <place_id>
339 321 
                        <place>
322 
                            <coordinates_id>
323 
                                <coordinates>
324 
                                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
325 
                                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
326 
                                    <latitude_deg>
327 
                                        <_nullIf>
328 
                                            <null>0</null>
329 
                                            <type>float</type>
330 
                                            <value>$Latitude</value>
331 
                                        </_nullIf>
332 
                                    </latitude_deg>
333 
                                    <longitude_deg>
334 
                                        <_nullIf>
335 
                                            <null>0</null>
336 
                                            <type>float</type>
337 
                                            <value>$Longitude</value>
338 
                                        </_nullIf>
339 
                                    </longitude_deg>
340 
                                </coordinates>
341 
                            </coordinates_id>
340 342 
                            <continent>$ContinentOcean</continent>
341 343 
                            <country>$Country</country>
342 344 
                            <county>$County</county>
inputs/Madidi/Plot/VegBIEN.csv
57 57 
-----
58 58 
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"
59 59 
Topographical situation,/location/landform,
60 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
61 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
62 
Latitude (DMS),/location/locationcoords/verbatimlatitude,
63 
Longitude (DMS),/location/locationcoords/verbatimlongitude,
64 60 
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data
65 61 
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data
66 62 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
......
88 84 
Inventory code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
89 85 
Inventory name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
90 86 
Locality,/location/locationnarrative/_merge/1,
87 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
88 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
89 
Latitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
90 
Longitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
91 91 
Observaciones,/location/notespublic,
92 92 
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación
93 93 
Orientación/exposicion,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/2,Part files provide either this field or Direction
inputs/Madidi/Plot/test.xml.ref
25 25 
                    </_range>
26 26 
                </elevationrange_m>
27 27 
                <landform>$Topographical situation</landform>
28 
                <locationcoords>
29 
                    <latitude_deg>
30 
                        <_nullIf>
31 
                            <null>0</null>
32 
                            <type>float</type>
33 
                            <value>$Latitude</value>
34 
                        </_nullIf>
35 
                    </latitude_deg>
36 
                    <longitude_deg>
37 
                        <_nullIf>
38 
                            <null>0</null>
39 
                            <type>float</type>
40 
                            <value>$Longitude</value>
41 
                        </_nullIf>
42 
                    </longitude_deg>
43 
                    <verbatimlatitude>$Latitude (DMS)</verbatimlatitude>
44 
                    <verbatimlongitude>$Longitude (DMS)</verbatimlongitude>
45 
                </locationcoords>
46 28 
                <locationevent>
47 29 
                    <project_id>
48 30 
                        <project>
......
82 64 
                    </soilobs>
83 65 
                </locationevent>
84 66 
                <locationnarrative>$Locality</locationnarrative>
67 
                <locationplace>
68 
                    <place_id>
69 
                        <place>
70 
                            <coordinates_id>
71 
                                <coordinates>
72 
                                    <latitude_deg>
73 
                                        <_nullIf>
74 
                                            <null>0</null>
75 
                                            <type>float</type>
76 
                                            <value>$Latitude</value>
77 
                                        </_nullIf>
78 
                                    </latitude_deg>
79 
                                    <longitude_deg>
80 
                                        <_nullIf>
81 
                                            <null>0</null>
82 
                                            <type>float</type>
83 
                                            <value>$Longitude</value>
84 
                                        </_nullIf>
85 
                                    </longitude_deg>
86 
                                    <verbatimlatitude>$Latitude (DMS)</verbatimlatitude>
87 
                                    <verbatimlongitude>$Longitude (DMS)</verbatimlongitude>
88 
                                </coordinates>
89 
                            </coordinates_id>
90 
                        </place>
91 
                    </place_id>
92 
                </locationplace>
85 93 
                <notespublic>$Observaciones</notespublic>
86 94 
                <slopeaspect_deg>
87 95 
                    <_compass>
......
99 107 
        </path>
100 108 
    </_simplifyPath>
101 109 
</VegBIEN>
102 
Inserted 19 new rows into database
110 
Inserted 23 new rows into database
inputs/ACAD/Specimen/VegBIEN.csv
6 6 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
7 7 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
8 8 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
9 
decimalLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
10 
decimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
11 9 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
12 10 
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
13 11 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
......
64 62 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
65 63 
locality,/location/locationnarrative/_merge/1,
66 64 
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?"
65 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
66 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
67 67 
continent,/location/locationplace/*_id/place/continent,
68 68 
country,/location/locationplace/*_id/place/country,
69 69 
county,/location/locationplace/*_id/place/county,
inputs/ACAD/Specimen/test.xml.ref
28 28 
                        <value>$verbatimElevation</value>
29 29 
                    </_units>
30 30 
                </elevation_m>
31 
                <locationcoords>
32 
                    <latitude_deg>
33 
                        <_nullIf>
34 
                            <null>0</null>
35 
                            <type>float</type>
36 
                            <value>$decimalLatitude</value>
37 
                        </_nullIf>
38 
                    </latitude_deg>
39 
                    <longitude_deg>
40 
                        <_nullIf>
41 
                            <null>0</null>
42 
                            <type>float</type>
43 
                            <value>$decimalLongitude</value>
44 
                        </_nullIf>
45 
                    </longitude_deg>
46 
                </locationcoords>
47 31 
                <locationevent>
48 32 
                    <obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate>
49 33 
                    <obsstartdate><_date><date><_dateRangeStart><value>$eventDate</value></_dateRangeStart></date></_date></obsstartdate>
......
251 235 
                <locationplace>
252 236 
                    <place_id>
253 237 
                        <place>
238 
                            <coordinates_id>
239 
                                <coordinates>
240 
                                    <latitude_deg>
241 
                                        <_nullIf>
242 
                                            <null>0</null>
243 
                                            <type>float</type>
244 
                                            <value>$decimalLatitude</value>
245 
                                        </_nullIf>
246 
                                    </latitude_deg>
247 
                                    <longitude_deg>
248 
                                        <_nullIf>
249 
                                            <null>0</null>
250 
                                            <type>float</type>
251 
                                            <value>$decimalLongitude</value>
252 
                                        </_nullIf>
253 
                                    </longitude_deg>
254 
                                </coordinates>
255 
                            </coordinates_id>
254 256 
                            <continent>$continent</continent>
255 257 
                            <country>$country</country>
256 258 
                            <county>$county</county>
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
8 8 
elev_m,/location/elevation_m/_alt/1,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 9 
elev_max_m,/location/elevation_m/_alt/2/_avg/max,
10 10 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
11 
lat_decimal,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
12 
long_decimal,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
13 11 
plot_methodology,/location/locationevent/*_id/method/name,
14 12 
project,/location/locationevent/*_id/project/projectname,
15 13 
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)
......
40 38 
plot_code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
41 39 
temp_c,/location/locationevent/temperature_c,
42 40 
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"
41 
lat_decimal,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
42 
long_decimal,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
43 43 
major_geo,/location/locationplace/*_id/place/continent,
44 44 
country,/location/locationplace/*_id/place/country,
45 45 
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish
inputs/SALVIAS-CSV/Plot/test.xml.ref
18 18 
                        </2>
19 19 
                    </_alt>
20 20 
                </elevation_m>
21 
                <locationcoords>
22 
                    <latitude_deg>
23 
                        <_nullIf>
24 
                            <null>0</null>
25 
                            <type>float</type>
26 
                            <value>$lat_decimal</value>
27 
                        </_nullIf>
28 
                    </latitude_deg>
29 
                    <longitude_deg>
30 
                        <_nullIf>
31 
                            <null>0</null>
32 
                            <type>float</type>
33 
                            <value>$long_decimal</value>
34 
                        </_nullIf>
35 
                    </longitude_deg>
36 
                </locationcoords>
37 21 
                <locationevent>
38 22 
                    <method_id><method><name>$plot_methodology</name></method></method_id>
39 23 
                    <project_id><project><projectname>$project</projectname></project></project_id>
......
95 79 
                <locationplace>
96 80 
                    <place_id>
97 81 
                        <place>
82 
                            <coordinates_id>
83 
                                <coordinates>
84 
                                    <latitude_deg>
85 
                                        <_nullIf>
86 
                                            <null>0</null>
87 
                                            <type>float</type>
88 
                                            <value>$lat_decimal</value>
89 
                                        </_nullIf>
90 
                                    </latitude_deg>
91 
                                    <longitude_deg>
92 
                                        <_nullIf>
93 
                                            <null>0</null>
94 
                                            <type>float</type>
95 
                                            <value>$long_decimal</value>
96 
                                        </_nullIf>
97 
                                    </longitude_deg>
98 
                                </coordinates>
99 
                            </coordinates_id>
98 100 
                            <continent>$major_geo</continent>
99 101 
                            <country>$country</country>
100 102 
                            <county>$pol2</county>
......
108 110 
        </path>
109 111 
    </_simplifyPath>
110 112 
</VegBIEN>
111 
Inserted 16 new rows into database
113 
Inserted 15 new rows into database
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_deg/_noCV/value/_alt/1,
4 
publicLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
5 
publicLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
6 3 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
7 4 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
8 5 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
......
13 10 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
14 11 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
15 12 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/binomial,
13 
locationAccuracy-m,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
14 
publicLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
15 
publicLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
16 16 
county,/location/locationplace/*_id/place/county,
17 17 
state,/location/locationplace/*_id/place/stateprovince,
18 18 
confidentialityStatus,,** No join mapping for *confidentialityStatus **
inputs/CVS/Organism/test.xml.ref
5 5 
        <path>
6 6 
            <location>
7 7 
                <authorlocationcode>$authorObsCode</authorlocationcode>
8 
                <locationcoords>
9 
                    <coordsaccuracy_deg><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_deg>
10 
                    <latitude_deg>
11 
                        <_nullIf>
12 
                            <null>0</null>
13 
                            <type>float</type>
14 
                            <value>$publicLatitude</value>
15 
                        </_nullIf>
16 
                    </latitude_deg>
17 
                    <longitude_deg>
18 
                        <_nullIf>
19 
                            <null>0</null>
20 
                            <type>float</type>
21 
                            <value>$publicLongitude</value>
22 
                        </_nullIf>
23 
                    </longitude_deg>
24 
                </locationcoords>
25 8 
                <locationevent>
26 9 
                    <authoreventcode>$authorObsCode</authoreventcode>
27 10 
                    <obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>
......
56 39 
                <locationplace>
57 40 
                    <place_id>
58 41 
                        <place>
42 
                            <coordinates_id>
43 
                                <coordinates>
44 
                                    <coordsaccuracy_deg><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_deg>
45 
                                    <latitude_deg>
46 
                                        <_nullIf>
47 
                                            <null>0</null>
48 
                                            <type>float</type>
49 
                                            <value>$publicLatitude</value>
50 
                                        </_nullIf>
51 
                                    </latitude_deg>
52 
                                    <longitude_deg>
53 
                                        <_nullIf>
54 
                                            <null>0</null>
55 
                                            <type>float</type>
56 
                                            <value>$publicLongitude</value>
57 
                                        </_nullIf>
58 
                                    </longitude_deg>
59 
                                </coordinates>
60 
                            </coordinates_id>
59 61 
                            <county>$county</county>
60 62 
                            <stateprovince>$state</stateprovince>
61 63 
                        </place>
inputs/REMIB/Specimen/VegBIEN.csv
18 18 
GROUP BY acronym, accession_number
19 19 
HAVING count(*) > 1
20 20 
-----"
21 
lat_deg,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
22 
long_deg,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
23 21 
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
24 22 
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
25 23 
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
......
59 57 
-----"
60 58 
locality,/location/locationnarrative/_merge/1,
61 59 
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?"
60 
lat_deg,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
61 
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
62 62 
country,/location/locationplace/*_id/place/country,
63 63 
county,/location/locationplace/*_id/place/county,
64 64 
state,/location/locationplace/*_id/place/stateprovince,
inputs/REMIB/Specimen/test.xml.ref
10 10 
                        <3>$accession_number</3>
11 11 
                    </_join>
12 12 
                </authorlocationcode>
13 
                <locationcoords>
14 
                    <latitude_deg>
15 
                        <_nullIf>
16 
                            <null>0</null>
17 
                            <type>float</type>
18 
                            <value>$lat_deg</value>
19 
                        </_nullIf>
20 
                    </latitude_deg>
21 
                    <longitude_deg>
22 
                        <_nullIf>
23 
                            <null>0</null>
24 
                            <type>float</type>
25 
                            <value>$long_deg</value>
26 
                        </_nullIf>
27 
                    </longitude_deg>
28 
                </locationcoords>
29 13 
                <locationevent>
30 14 
                    <taxonoccurrence>
31 15 
                        <aggregateoccurrence>
......
165 149 
                <locationplace>
166 150 
                    <place_id>
167 151 
                        <place>
152 
                            <coordinates_id>
153 
                                <coordinates>
154 
                                    <latitude_deg>
155 
                                        <_nullIf>
156 
                                            <null>0</null>
157 
                                            <type>float</type>
158 
                                            <value>$lat_deg</value>
159 
                                        </_nullIf>
160 
                                    </latitude_deg>
161 
                                    <longitude_deg>
162 
                                        <_nullIf>
163 
                                            <null>0</null>
164 
                                            <type>float</type>
165 
                                            <value>$long_deg</value>
166 
                                        </_nullIf>
167 
                                    </longitude_deg>
168 
                                </coordinates>
169 
                            </coordinates_id>
168 170 
                            <country>$country</country>
169 171 
                            <county>$county</county>
170 172 
                            <stateprovince>$state</stateprovince>
......
175 177 
        </path>
176 178 
    </_simplifyPath>
177 179 
</VegBIEN>
178 
Inserted 27 new rows into database
180 
Inserted 26 new rows into database
inputs/CTFS/Plot/VegBIEN.csv
14 14 
GROUP BY ""Elevation""::real , ""LocationName""
15 15 
ORDER BY ""Elevation""::real DESC
16 16 
-----"
17 
ShapeOfSite,/location/locationcoords/footprintgeometry_dwc,
18 
Latitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
19 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
20 17 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
21 18 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
22 19 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
23 20 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
24 21 
DescriptionOfSite,/location/locationnarrative/_merge/1,
25 22 
LocationName,/location/locationnarrative/_merge/1,
23 
ShapeOfSite,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
24 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
25 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
26 26 
CountryName,/location/locationplace/*_id/place/country,
27 27 
PlotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1",
28 28 
PlotName,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",
inputs/CTFS/Plot/test.xml.ref
8 8 
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9 9 
                <area_m2><_ha_to_m2><value>$SizeOfSite</value></_ha_to_m2></area_m2>
10 10 
                <elevation_m>$Elevation</elevation_m>
11 
                <locationcoords>
12 
                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
13 
                    <latitude_deg>
14 
                        <_nullIf>
15 
                            <null>0</null>
16 
                            <type>float</type>
17 
                            <value>$Latitude</value>
18 
                        </_nullIf>
19 
                    </latitude_deg>
20 
                    <longitude_deg>
21 
                        <_nullIf>
22 
                            <null>0</null>
23 
                            <type>float</type>
24 
                            <value>$Longitude</value>
25 
                        </_nullIf>
26 
                    </longitude_deg>
27 
                </locationcoords>
28 11 
                <locationnarrative>
29 12 
                    <_alt>
30 13 
                        <0>$DescriptionOfSite</0>
31 14 
                        <1>$LocationName</1>
32 15 
                    </_alt>
33 16 
                </locationnarrative>
34 
                <locationplace><place_id><place><country>$CountryName</country></place></place_id></locationplace>
17 
                <locationplace>
18 
                    <place_id>
19 
                        <place>
20 
                            <coordinates_id>
21 
                                <coordinates>
22 
                                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
23 
                                    <latitude_deg>
24 
                                        <_nullIf>
25 
                                            <null>0</null>
26 
                                            <type>float</type>
27 
                                            <value>$Latitude</value>
28 
                                        </_nullIf>
29 
                                    </latitude_deg>
30 
                                    <longitude_deg>
31 
                                        <_nullIf>
32 
                                            <null>0</null>
33 
                                            <type>float</type>
34 
                                            <value>$Longitude</value>
35 
                                        </_nullIf>
36 
                                    </longitude_deg>
37 
                                </coordinates>
38 
                            </coordinates_id>
39 
                            <country>$CountryName</country>
40 
                        </place>
41 
                    </place_id>
42 
                </locationplace>
35 43 
            </location>
36 44 
        </path>
37 45 
    </_simplifyPath>
38 46 
</VegBIEN>
39 
Inserted 8 new rows into database
47 
Inserted 9 new rows into database
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_deg/_nullIf:[null=0,type=float]/value",
6 
DecimalLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
7 5 
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 6 
MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
9 7 
MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
......
25 23 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
26 24 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
27 25 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
26 
DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
27 
DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
28 28 
County,/location/locationplace/*_id/place/county,
29 29 
StateProvince,/location/locationplace/*_id/place/stateprovince,
30 30 
PlotCD,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1",
inputs/FIA/Organism/test.xml.ref
5 5 
        <path>
6 6 
            <location>
7 7 
                <sourceaccessioncode>$PlotCD</sourceaccessioncode>
8 
                <locationcoords>
9 
                    <latitude_deg>
10 
                        <_nullIf>
11 
                            <null>0</null>
12 
                            <type>float</type>
13 
                            <value>$DecimalLatitude</value>
14 
                        </_nullIf>
15 
                    </latitude_deg>
16 
                    <longitude_deg>
17 
                        <_nullIf>
18 
                            <null>0</null>
19 
                            <type>float</type>
20 
                            <value>$DecimalLongitude</value>
21 
                        </_nullIf>
22 
                    </longitude_deg>
23 
                </locationcoords>
24 8 
                <locationevent>
25 9 
                    <taxonoccurrence>
26 10 
                        <aggregateoccurrence>
......
134 118 
                <locationplace>
135 119 
                    <place_id>
136 120 
                        <place>
121 
                            <coordinates_id>
122 
                                <coordinates>
123 
                                    <latitude_deg>
124 
                                        <_nullIf>
125 
                                            <null>0</null>
126 
                                            <type>float</type>
127 
                                            <value>$DecimalLatitude</value>
128 
                                        </_nullIf>
129 
                                    </latitude_deg>
130 
                                    <longitude_deg>
131 
                                        <_nullIf>
132 
                                            <null>0</null>
133 
                                            <type>float</type>
134 
                                            <value>$DecimalLongitude</value>
135 
                                        </_nullIf>
136 
                                    </longitude_deg>
137 
                                </coordinates>
138 
                            </coordinates_id>
137 139 
                            <county>$County</county>
138 140 
                            <stateprovince>$StateProvince</stateprovince>
139 141 
                        </place>
inputs/SALVIAS/plotMetadata/VegBIEN.csv
8 8 
Elev,/location/elevation_m/_alt/1,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 9 
elev_max_m,/location/elevation_m/_alt/2/_avg/max,
10 10 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
11 
LatDec,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
12 
LongDec,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
13 11 
PlotMethod,/location/locationevent/*_id/method/name,
14 12 
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
15 13 
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)
......
41 39 
Temp,/location/locationevent/temperature_c,
42 40 
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"
43 41 
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?"
42 
LatDec,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
43 
LongDec,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
44 44 
MajorGeo,/location/locationplace/*_id/place/continent,
45 45 
Country,/location/locationplace/*_id/place/country,
46 46 
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish
inputs/SALVIAS/plotMetadata/test.xml.ref
18 18 
                        </2>
19 19 
                    </_alt>
20 20 
                </elevation_m>
21 
                <locationcoords>
22 
                    <latitude_deg>
23 
                        <_nullIf>
24 
                            <null>0</null>
25 
                            <type>float</type>
26 
                            <value>$LatDec</value>
27 
                        </_nullIf>
28 
                    </latitude_deg>
29 
                    <longitude_deg>
30 
                        <_nullIf>
31 
                            <null>0</null>
32 
                            <type>float</type>
33 
                            <value>$LongDec</value>
34 
                        </_nullIf>
35 
                    </longitude_deg>
36 
                </locationcoords>
37 21 
                <locationevent>
38 22 
                    <method_id><method><name>$PlotMethod</name></method></method_id>
39 23 
                    <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
......
105 89 
                <locationplace>
106 90 
                    <place_id>
107 91 
                        <place>
92 
                            <coordinates_id>
93 
                                <coordinates>
94 
                                    <latitude_deg>
95 
                                        <_nullIf>
96 
                                            <null>0</null>
97 
                                            <type>float</type>
98 
                                            <value>$LatDec</value>
99 
                                        </_nullIf>
100 
                                    </latitude_deg>
101 
                                    <longitude_deg>
102 
                                        <_nullIf>
103 
                                            <null>0</null>
104 
                                            <type>float</type>
105 
                                            <value>$LongDec</value>
106 
                                        </_nullIf>
107 
                                    </longitude_deg>
108 
                                </coordinates>
109 
                            </coordinates_id>
108 110 
                            <continent>$MajorGeo</continent>
109 111 
                            <country>$Country</country>
110 112 
                            <county>$pol2</county>
inputs/U/Specimen/test.xml.ref
10 10 
                        <2>$Barcode</2>
11 11 
                    </_alt>
12 12 
                </authorlocationcode>
13 
                <locationcoords>
14 
                    <latitude_deg>
15 
                        <_nullIf>
16 
                            <null>0</null>
17 
                            <type>float</type>
18 
                            <value>$Lat</value>
19 
                        </_nullIf>
20 
                    </latitude_deg>
21 
                    <longitude_deg>
22 
                        <_nullIf>
23 
                            <null>0</null>
24 
                            <type>float</type>
25 
                            <value>$Long</value>
26 
                        </_nullIf>
27 
                    </longitude_deg>
28 
                </locationcoords>
29 13 
                <locationevent>
30 14 
                    <taxonoccurrence>
31 15 
                        <aggregateoccurrence>
......
203 187 
                        </3>
204 188 
                    </_merge>
205 189 
                </locationnarrative>
206 
                <locationplace><place_id><place><country>$Country</country></place></place_id></locationplace>
190 
                <locationplace>
191 
                    <place_id>
192 
                        <place>
193 
                            <coordinates_id>
194 
                                <coordinates>
195 
                                    <latitude_deg>
196 
                                        <_nullIf>
197 
                                            <null>0</null>
198 
                                            <type>float</type>
199 
                                            <value>$Lat</value>
200 
                                        </_nullIf>
201 
                                    </latitude_deg>
202 
                                    <longitude_deg>
203 
                                        <_nullIf>
204 
                                            <null>0</null>
205 
                                            <type>float</type>
206 
                                            <value>$Long</value>
207 
                                        </_nullIf>
208 
                                    </longitude_deg>
209 
                                </coordinates>
210 
                            </coordinates_id>
211 
                            <country>$Country</country>
212 
                        </place>
213 
                    </place_id>
214 
                </locationplace>
207 215 
            </location>
208 216 
        </path>
209 217 
    </_simplifyPath>
210 218 
</VegBIEN>
211 
Inserted 32 new rows into database
219 
Inserted 31 new rows into database
inputs/ARIZ/Specimen/test.xml.ref
27 27 
                        <min>$MinimumElevationInMeters</min>
28 28 
                    </_avg>
29 29 
                </elevation_m>
30 
                <locationcoords>
31 
                    <coordsaccuracy_deg><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg>
32 
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
33 
                    <latitude_deg>
34 
                        <_nullIf>
35 
                            <null>0</null>
36 
                            <type>float</type>
37 
                            <value>$DecimalLatitude</value>
38 
                        </_nullIf>
39 
                    </latitude_deg>
40 
                    <longitude_deg>
41 
                        <_nullIf>
42 
                            <null>0</null>
43 
                            <type>float</type>
44 
                            <value>$DecimalLongitude</value>
45 
                        </_nullIf>
46 
                    </longitude_deg>
47 
                </locationcoords>
48 30 
                <locationevent>
49 31 
                    <taxonoccurrence>
50 32 
                        <aggregateoccurrence>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff