Revision 7703
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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/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/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
mappings/VegCore-VegBIEN.csv: _avg(): Use numeric param names to work with SQL functions