Project

General

Profile

« Previous | Next » 

Revision 7703

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/VegCore-VegBIEN.csv: _avg(): Use numeric param names to work with SQL functions

View differences:

inputs/HVAA/Specimen/VegBIEN.csv
12 12 
rights,/location/accessconditions,
13 13 
accessRights,/location/accesslevel,
14 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
15 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
16 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
15 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
16 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
17 17 
fieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
18 18 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
19 19 
symbiotaId,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
inputs/HVAA/Specimen/test.xml.ref
32 32 
                                </1>
33 33 
                                <2>
34 34 
                                    <_avg>
35 
                                        <max>$maximumElevationInMeters</max>
36 
                                        <min>$minimumElevationInMeters</min>
35 
                                        <1>$minimumElevationInMeters</1>
36 
                                        <2>$maximumElevationInMeters</2>
37 37 
                                    </_avg>
38 38 
                                </2>
39 39 
                            </_alt>
inputs/XAL/Specimen/VegBIEN.csv
6 6 
darwin:InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
7 7 
darwin:CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
8 8 
darwin:CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
9 
darwin:MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
10 
darwin:MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
9 
darwin:MinimumElevation,/location/elevation_m/_alt/2/_avg/1,
10 
darwin:MaximumElevation,/location/elevation_m/_alt/2/_avg/2,
11 11 
darwin:CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12 12 
darwin:Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
13 13 
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
......
55 55 
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
56 56 
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
57 57 
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
58 
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
59 
darwin:MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
58 
darwin:MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
59 
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/2,
60 60 
darwin:Locality,/location/locationnarrative/_merge/1,
61 61 
darwin:Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
62 62 
darwin:Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/WIN/Specimen/VegBIEN.csv
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 13 
rights,/location/accessconditions,
14 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
15 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
15 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
16 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
17 17 
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
18 18 
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
inputs/WIN/Specimen/test.xml.ref
34 34 
                                        <value>$verbatimElevation</value>
35 35 
                                    </_units>
36 36 
                                </1>
37 
                                <2><_avg><min>$minimumElevationInMeters</min></_avg></2>
37 
                                <2><_avg><1>$minimumElevationInMeters</1></_avg></2>
38 38 
                            </_alt>
39 39 
                        </elevation_m>
40 40 
                        <iscultivated>
inputs/BRIT/specimen_flat/VegBIEN.csv
8 8 
specimen_id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
9 9 
Institution_Code,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
10 10 
Catalog_Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
11 
Elevation_Max,/location/elevation_m/_alt/2/_avg/max,Assuming units based on the range and precision of values
12 
Elevation_Min,/location/elevation_m/_alt/2/_avg/min,Assuming units based on the range and precision of values
11 
Elevation_Min,/location/elevation_m/_alt/2/_avg/1,Assuming units based on the range and precision of values
12 
Elevation_Max,/location/elevation_m/_alt/2/_avg/2,Assuming units based on the range and precision of values
13 13 
Collection_Number,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
14 14 
Locality_Summary,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1/_join/1,
15 15 
Locality_Description,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1/_join/2,
inputs/TRT/Specimen/VegBIEN.csv
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 13 
rights,/location/accessconditions,
14 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
15 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
16 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
15 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
16 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
17 17 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
18 18 
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
19 19 
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
inputs/MO/Specimen/VegBIEN.csv
6 6 
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
7 7 
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
8 8 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
9 
MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
10 
MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
9 
MinimumElevation,/location/elevation_m/_alt/2/_avg/1,
10 
MaximumElevation,/location/elevation_m/_alt/2/_avg/2,
11 11 
CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12 12 
Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
13 13 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
inputs/VegBank/plot_/VegBIEN.csv
34 34 
stateprovince,/location/locationplace/*_id/place/stateprovince,
35 35 
parent_id,/location/parent_id/location/sourceaccessioncode,
36 36 
slopeaspect,/location/slopeaspect_deg/_alt/1/_compass/value,
37 
maxslopeaspect,/location/slopeaspect_deg/_alt/2/_avg/max,
38 
minslopeaspect,/location/slopeaspect_deg/_alt/2/_avg/min,
37 
minslopeaspect,/location/slopeaspect_deg/_alt/2/_avg/1,
38 
maxslopeaspect,/location/slopeaspect_deg/_alt/2/_avg/2,
39 39 
slopegradient,/location/slopegradient_fraction/_alt/1,
40 
maxslopegradient,/location/slopegradient_fraction/_alt/2/_avg/max,
41 
minslopegradient,/location/slopegradient_fraction/_alt/2/_avg/min,
40 
minslopegradient,/location/slopegradient_fraction/_alt/2/_avg/1,
41 
maxslopegradient,/location/slopegradient_fraction/_alt/2/_avg/2,
42 42 
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
43 43 
plot_id,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
44 44 
Geographic Name,,** No join mapping for *Geographic Name **
mappings/VegCore-VegBIEN.csv
33 33 
subplot,/location/authorlocationcode,
34 34 
elevationInMeters,/location/elevation_m/_alt/1,
35 35 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
36 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
37 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/max/_rangeEnd/value,
38 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
39 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/min/_rangeStart/value,
36 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
37 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/1/_rangeStart/value,
38 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
39 
verbatimElevation_m,/location/elevation_m/_alt/2/_avg/2/_rangeEnd/value,
40 40 
verbatimElevation_m,/location/elevationrange_m/_range/from/_rangeStart/value,
41 41 
verbatimElevation_m,/location/elevationrange_m/_range/to/_rangeEnd/value,
42 42 
collectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
325 325 
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
326 326 
collectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
327 327 
temperature_C,/location/locationevent/temperature_c,
328 
maximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,
329 
minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,
328 
minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
329 
maximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/2,
330 330 
locality,/location/locationnarrative/_merge/1,
331 331 
verbatimLocality,/location/locationnarrative/_merge/2,
332 332 
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?"
......
379 379 
parentPlotName,/location/parent_id/location/authorlocationcode,
380 380 
parentLocationID,/location/parent_id/location/sourceaccessioncode,
381 381 
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value,
382 
maxSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/max,
383 
minSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/min,
382 
minSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/1,
383 
maxSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/2,
384 384 
slopeGradient,/location/slopegradient_fraction/_alt/1,
385 
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/max,
386 
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/min,
385 
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/1,
386 
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/2,
387 387 
subplotID,/location/sourceaccessioncode,
388 388 
locationID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
389 389 
subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
inputs/BRIT/specimen_flat/test.xml.ref
20 20 
                        </authorlocationcode>
21 21 
                        <elevation_m>
22 22 
                            <_avg>
23 
                                <max>$Elevation_Max</max>
24 
                                <min>$Elevation_Min</min>
23 
                                <1>$Elevation_Min</1>
24 
                                <2>$Elevation_Max</2>
25 25 
                            </_avg>
26 26 
                        </elevation_m>
27 27 
                        <iscultivated>
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
7 7 
AccessCode,"/location/accesslevel/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
8 8 
plot_area_ha,/location/area_m2/_ha_to_m2/value,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
9 9 
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.
10 
elev_max_m,/location/elevation_m/_alt/2/_avg/max,
11 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
10 
elev_min_m,/location/elevation_m/_alt/2/_avg/1,
11 
elev_max_m,/location/elevation_m/_alt/2/_avg/2,
12 12 
Locality_Description,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/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"
13 13 
Habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
14 14 
topography_desc,/location/landform,
inputs/SALVIAS/plotMetadata_/test.xml.ref
23 23 
                                <1>$Elev</1>
24 24 
                                <2>
25 25 
                                    <_avg>
26 
                                        <max>$elev_max_m</max>
27 
                                        <min>$elev_min_m</min>
26 
                                        <1>$elev_min_m</1>
27 
                                        <2>$elev_max_m</2>
28 28 
                                    </_avg>
29 29 
                                </2>
30 30 
                            </_alt>
inputs/GBIF/Specimen/VegBIEN.csv
6 6 
InstitutionCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
7 7 
CollectionCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
8 8 
CatalogNO,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
9 
MaximumElevationInMeter,/location/elevation_m/_alt/2/_avg/max,
10 
MinimumElevationInMeter,/location/elevation_m/_alt/2/_avg/min,
9 
MinimumElevationInMeter,/location/elevation_m/_alt/2/_avg/1,
10 
MaximumElevationInMeter,/location/elevation_m/_alt/2/_avg/2,
11 11 
Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
12 12 
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,
13 13 
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
inputs/GBIF/Specimen/test.xml.ref
16 16 
                        </authorlocationcode>
17 17 
                        <elevation_m>
18 18 
                            <_avg>
19 
                                <max>$MaximumElevationInMeter</max>
20 
                                <min>$MinimumElevationInMeter</min>
19 
                                <1>$MinimumElevationInMeter</1>
20 
                                <2>$MaximumElevationInMeter</2>
21 21 
                            </_avg>
22 22 
                        </elevation_m>
23 23 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
inputs/JBM/Specimen/VegBIEN.csv
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 13 
rights,/location/accessconditions,
14 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
14 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
15 15 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
16 16 
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
17 17 
habitat,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,
inputs/JBM/Specimen/test.xml.ref
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 27 
                        <accessconditions>$rights</accessconditions>
28 
                        <elevation_m><_avg><min>$minimumElevationInMeters</min></_avg></elevation_m>
28 
                        <elevation_m><_avg><1>$minimumElevationInMeters</1></_avg></elevation_m>
29 29 
                        <iscultivated>
30 30 
                            <_locationnarrative_is_cultivated>
31 31 
                                <locationnarrative>
inputs/SpeciesLink/Specimen/VegBIEN.csv
24 24 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
25 25 
dwc_dwcore_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
26 26 
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
27 
conceptual_darwin_2003_1_0_MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
28 
dwc_dwcore_MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
29 
dwc_terms_maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
30 
conceptual_darwin_2003_1_0_MinimumElevation,/location/elevation_m/_alt/2/_avg/min,
31 
dwc_dwcore_MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
32 
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
27 
conceptual_darwin_2003_1_0_MinimumElevation,/location/elevation_m/_alt/2/_avg/1,
28 
dwc_dwcore_MinimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
29 
dwc_terms_minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
30 
conceptual_darwin_2003_1_0_MaximumElevation,/location/elevation_m/_alt/2/_avg/2,
31 
dwc_dwcore_MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
32 
dwc_terms_maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
33 33 
dwc_dwcore_GlobalUniqueIdentifier,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
34 34 
dwc_terms_recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
35 35 
conceptual_darwin_2003_1_0_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
......
253 253 
-----"
254 254 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
255 255 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
256 
conceptual_darwin_2003_1_0_MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
257 
dwc_dwcore_MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,
258 
dwc_terms_maximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,
259 
conceptual_darwin_2003_1_0_MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
260 
dwc_dwcore_MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,
261 
dwc_terms_minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,
256 
conceptual_darwin_2003_1_0_MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
257 
dwc_dwcore_MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
258 
dwc_terms_minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
259 
conceptual_darwin_2003_1_0_MaximumDepth,/location/locationevent/waterdepth_m/_avg/2,
260 
dwc_dwcore_MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/2,
261 
dwc_terms_maximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/2,
262 262 
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
263 263 
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
264 264 
dwc_terms_locality,/location/locationnarrative/_merge/1,
inputs/SpeciesLink/Specimen/test.xml.ref
44 44 
                        </authorlocationcode>
45 45 
                        <elevation_m>
46 46 
                            <_avg>
47 
                                <max>
47 
                                <1>
48 48 
                                    <_alt>
49 
                                        <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
50 
                                        <1>$dwc_dwcore_MinimumElevationInMeters</1>
51 
                                        <2>$dwc_terms_minimumElevationInMeters</2>
52 
                                    </_alt>
53 
                                </1>
54 
                                <2>
55 
                                    <_alt>
49 56 
                                        <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
50 57 
                                        <1>$dwc_dwcore_MaximumElevationInMeters</1>
51 58 
                                        <2>$dwc_terms_maximumElevationInMeters</2>
52 59 
                                    </_alt>
53 
                                </max>
54 
                                <min>
55 
                                    <_alt>
56 
                                        <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
57 
                                        <1>$dwc_dwcore_MinimumElevationInMeters</1>
58 
                                        <2>$dwc_terms_minimumElevationInMeters</2>
59 
                                    </_alt>
60 
                                </min>
60 
                                </2>
61 61 
                            </_avg>
62 62 
                        </elevation_m>
63 63 
                        <iscultivated>
......
487 487 
                            </taxonoccurrence>
488 488 
                            <waterdepth_m>
489 489 
                                <_avg>
490 
                                    <max>
490 
                                    <1>
491 491 
                                        <_alt>
492 
                                            <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
493 
                                            <1>$dwc_dwcore_MinimumDepthInMeters</1>
494 
                                            <2>$dwc_terms_minimumDepthInMeters</2>
495 
                                        </_alt>
496 
                                    </1>
497 
                                    <2>
498 
                                        <_alt>
492 499 
                                            <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
493 500 
                                            <1>$dwc_dwcore_MaximumDepthInMeters</1>
494 501 
                                            <2>$dwc_terms_maximumDepthInMeters</2>
495 502 
                                        </_alt>
496 
                                    </max>
497 
                                    <min>
498 
                                        <_alt>
499 
                                            <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
500 
                                            <1>$dwc_dwcore_MinimumDepthInMeters</1>
501 
                                            <2>$dwc_terms_minimumDepthInMeters</2>
502 
                                        </_alt>
503 
                                    </min>
503 
                                    </2>
504 504 
                                </_avg>
505 505 
                            </waterdepth_m>
506 506 
                        </locationevent>
inputs/NY/Ecatalog_all/VegBIEN.csv
6 6 
InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
7 7 
CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
8 8 
CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
9 
MaximumElevation,/location/elevation_m/_alt/2/_avg/max,
10 
MinimumElevation,/location/elevation_m/_alt/2/_avg/min/_nullIf:[null=.]/value,
9 
MinimumElevation,/location/elevation_m/_alt/2/_avg/1/_nullIf:[null=.]/value,
10 
MaximumElevation,/location/elevation_m/_alt/2/_avg/2,
11 11 
FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",Usage inconsistent with DwC definition
12 12 
Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1/_join/1,
13 13 
Substrate,"/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1/_join/2/_label[label=""substrate""]/value",
......
59 59 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
60 60 
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
61 61 
FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",Usage inconsistent with DwC definition
62 
MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
63 
MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
62 
MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
63 
MaximumDepth,/location/locationevent/waterdepth_m/_avg/2,
64 64 
Locality,/location/locationnarrative/_merge/1/_join/1,
65 65 
Substrate,"/location/locationnarrative/_merge/1/_join/2/_label[label=""substrate""]/value",
66 66 
Vegetation,"/location/locationnarrative/_merge/1/_join/3/_label[label=""vegetation""]/value",
inputs/NY/Ecatalog_all/test.xml.ref
16 16 
                        </authorlocationcode>
17 17 
                        <elevation_m>
18 18 
                            <_avg>
19 
                                <max>$MaximumElevation</max>
20 
                                <min>
19 
                                <1>
21 20 
                                    <_nullIf>
22 21 
                                        <null>.</null>
23 22 
                                        <value>$MinimumElevation</value>
24 23 
                                    </_nullIf>
25 
                                </min>
24 
                                </1>
25 
                                <2>$MaximumElevation</2>
26 26 
                            </_avg>
27 27 
                        </elevation_m>
28 28 
                        <iscultivated>
......
256 256 
                            </taxonoccurrence>
257 257 
                            <waterdepth_m>
258 258 
                                <_avg>
259 
                                    <max>$MaximumDepth</max>
260 
                                    <min>$MinimumDepth</min>
259 
                                    <1>$MinimumDepth</1>
260 
                                    <2>$MaximumDepth</2>
261 261 
                                </_avg>
262 262 
                            </waterdepth_m>
263 263 
                        </locationevent>
inputs/Madidi/Location/VegBIEN.csv
5 5 
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 7 
Area,/location/area_m2/_ha_to_m2/value,
8 
MaximumElevationMeters,/location/elevation_m/_alt/2/_avg/max,
9 
MinimumElevationMeters,/location/elevation_m/_alt/2/_avg/min,
8 
MinimumElevationMeters,/location/elevation_m/_alt/2/_avg/1,
9 
MaximumElevationMeters,/location/elevation_m/_alt/2/_avg/2,
10 10 
LocalityDescription,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
11 11 
Topography,/location/landform,
12 12 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
inputs/Madidi/Location/test.xml.ref
12 12 
                        <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>
13 13 
                        <elevation_m>
14 14 
                            <_avg>
15 
                                <max>$MaximumElevationMeters</max>
16 
                                <min>$MinimumElevationMeters</min>
15 
                                <1>$MinimumElevationMeters</1>
16 
                                <2>$MaximumElevationMeters</2>
17 17 
                            </_avg>
18 18 
                        </elevation_m>
19 19 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocalityDescription</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
6 6 
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
7 7 
plot_area_ha,/location/area_m2/_ha_to_m2/value,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
8 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 
elev_max_m,/location/elevation_m/_alt/2/_avg/max,
10 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
9 
elev_min_m,/location/elevation_m/_alt/2/_avg/1,
10 
elev_max_m,/location/elevation_m/_alt/2/_avg/2,
11 11 
locality_description,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/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"
12 12 
plot_methodology,/location/locationevent/*_id/method/name,
13 13 
observation_type,/location/locationevent/*_id/method/observationmeasure,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
inputs/SALVIAS-CSV/Plot/test.xml.ref
15 15 
                                <1>$elev_m</1>
16 16 
                                <2>
17 17 
                                    <_avg>
18 
                                        <max>$elev_max_m</max>
19 
                                        <min>$elev_min_m</min>
18 
                                        <1>$elev_min_m</1>
19 
                                        <2>$elev_max_m</2>
20 20 
                                    </_avg>
21 21 
                                </2>
22 22 
                            </_alt>
inputs/CVS/plot_/VegBIEN.csv
36 36 
stateProvince,/location/locationplace/*_id/place/stateprovince,
37 37 
PARENT_ID,/location/parent_id/location/sourceaccessioncode,
38 38 
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value,
39 
maxSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/max,
40 
minSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/min,
39 
minSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/1,
40 
maxSlopeAspect,/location/slopeaspect_deg/_alt/2/_avg/2,
41 41 
slopeGradient,/location/slopegradient_fraction/_alt/1,
42 
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/max,
43 
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/min,
42 
minSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/1,
43 
maxSlopeGradient,/location/slopegradient_fraction/_alt/2/_avg/2,
44 44 
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
45 45 
PLOT_ID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
46 46 
Geographic Name,,** No join mapping for *Geographic Name **
inputs/CVS/plot_/test.xml.ref
143 143 
                                <1><_compass><value>$slopeAspect</value></_compass></1>
144 144 
                                <2>
145 145 
                                    <_avg>
146 
                                        <max>$maxSlopeAspect</max>
147 
                                        <min>$minSlopeAspect</min>
146 
                                        <1>$minSlopeAspect</1>
147 
                                        <2>$maxSlopeAspect</2>
148 148 
                                    </_avg>
149 149 
                                </2>
150 150 
                            </_alt>
......
154 154 
                                <1>$slopeGradient</1>
155 155 
                                <2>
156 156 
                                    <_avg>
157 
                                        <max>$maxSlopeGradient</max>
158 
                                        <min>$minSlopeGradient</min>
157 
                                        <1>$minSlopeGradient</1>
158 
                                        <2>$maxSlopeGradient</2>
159 159 
                                    </_avg>
160 160 
                                </2>
161 161 
                            </_alt>
inputs/ARIZ/omoccurrences/VegBIEN.csv
10 10 
occurrenceID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists/_first/2",Not populated for all rows
11 11 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
12 12 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
13 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
14 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
13 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/1,
14 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
15 15 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
16 16 
occid,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/1",
17 17 
occurrenceID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_first/2",Not populated for all rows
inputs/ARIZ/omoccurrences/test.xml.ref
24 24 
                                </1>
25 25 
                                <2>
26 26 
                                    <_avg>
27 
                                        <max>$maximumElevationInMeters</max>
28 
                                        <min>$minimumElevationInMeters</min>
27 
                                        <1>$minimumElevationInMeters</1>
28 
                                        <2>$maximumElevationInMeters</2>
29 29 
                                    </_avg>
30 30 
                                </2>
31 31 
                            </_alt>
inputs/TRT/Specimen/test.xml.ref
36 36 
                                </1>
37 37 
                                <2>
38 38 
                                    <_avg>
39 
                                        <max>$maximumElevationInMeters</max>
40 
                                        <min>$minimumElevationInMeters</min>
39 
                                        <1>$minimumElevationInMeters</1>
40 
                                        <2>$maximumElevationInMeters</2>
41 41 
                                    </_avg>
42 42 
                                </2>
43 43 
                            </_alt>
inputs/MO/Specimen/test.xml.ref
16 16 
                        </authorlocationcode>
17 17 
                        <elevation_m>
18 18 
                            <_avg>
19 
                                <max>$MaximumElevation</max>
20 
                                <min>$MinimumElevation</min>
19 
                                <1>$MinimumElevation</1>
20 
                                <2>$MaximumElevation</2>
21 21 
                            </_avg>
22 22 
                        </elevation_m>
23 23 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
inputs/VegBank/plot_/test.xml.ref
133 133 
                                <1><_compass><value>$slopeaspect</value></_compass></1>
134 134 
                                <2>
135 135 
                                    <_avg>
136 
                                        <max>$maxslopeaspect</max>
137 
                                        <min>$minslopeaspect</min>
136 
                                        <1>$minslopeaspect</1>
137 
                                        <2>$maxslopeaspect</2>
138 138 
                                    </_avg>
139 139 
                                </2>
140 140 
                            </_alt>
......
144 144 
                                <1>$slopegradient</1>
145 145 
                                <2>
146 146 
                                    <_avg>
147 
                                        <max>$maxslopegradient</max>
148 
                                        <min>$minslopegradient</min>
147 
                                        <1>$minslopegradient</1>
148 
                                        <2>$maxslopegradient</2>
149 149 
                                    </_avg>
150 150 
                                </2>
151 151 
                            </_alt>
mappings/for_review/VegCore-VegBIEN.csv
33 33 
subplot,//location/authorlocationcode,
34 34 
elevationInMeters,//location/elevation_m,
35 35 
verbatimElevation,//location/elevation_m,
36 
minimumElevationInMeters,//location/elevation_m,
37 
verbatimElevation_m,//location/elevation_m,
36 38 
maximumElevationInMeters,//location/elevation_m,
37 39 
verbatimElevation_m,//location/elevation_m,
38 
minimumElevationInMeters,//location/elevation_m,
39 
verbatimElevation_m,//location/elevation_m,
40 40 
verbatimElevation_m,//location/elevationrange_m,
41 41 
verbatimElevation_m,//location/elevationrange_m,
42 42 
collectorNumber,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
325 325 
voucherType,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond",
326 326 
collectorNumber,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
327 327 
temperature_C,//locationevent/temperature_c,
328 
minimumDepthInMeters,//locationevent/waterdepth_m,
328 329 
maximumDepthInMeters,//locationevent/waterdepth_m,
329 
minimumDepthInMeters,//locationevent/waterdepth_m,
330 330 
locality,//location/locationnarrative,
331 331 
verbatimLocality,//location/locationnarrative,
332 332 
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?"
......
379 379 
parentPlotName,//location/authorlocationcode,
380 380 
parentLocationID,//location/sourceaccessioncode,
381 381 
slopeAspect,//location/slopeaspect_deg,
382 
minSlopeAspect,//location/slopeaspect_deg,
382 383 
maxSlopeAspect,//location/slopeaspect_deg,
383 
minSlopeAspect,//location/slopeaspect_deg,
384 384 
slopeGradient,//location/slopegradient_fraction,
385 
minSlopeGradient,//location/slopegradient_fraction,
385 386 
maxSlopeGradient,//location/slopegradient_fraction,
386 
minSlopeGradient,//location/slopegradient_fraction,
387 387 
subplotID,//location/sourceaccessioncode,
388 388 
locationID,"//location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
389 389 
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",

Also available in: Unified diff