Project

General

Profile

« Previous | Next » 

Revision 5977

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegCore-VegBIEN.csv: subplots: Also complete the locationevent/location diamond (subplot event -> {subplot location, parent plot event} -> parent plot location) when an eventDate or range is specified, as this is also an identifying field for locationevent. This fixes a bug where subplots data without explicit plot events (such as SALVIAS and TEAM) was not being connected to the appropriate parent plot event as well as parent plot location. This should fix the SALVIAS verification # location events, which should include only parent plots' locationevents to correspond with # locations, which only includes parent plots' locations, and uses locationevent.parent_id being NULL to determine what is a parent plot event.

View differences:

inputs/VegBank/observation_/VegBIEN.csv
7 7 
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
8 8 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
9 9 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
10 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
11 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
12 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
13 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
14 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
10 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
11 
obsenddate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
12 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
13 
obsstartdate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
14 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authorlocationcode",
16 
obsenddate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
17 
obsstartdate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
18 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
15 19 
obsenddate,/location/locationevent/obsenddate/_*/date/_alt/1,
16 20 
obsstartdate,/location/locationevent/obsstartdate/_*/date/_alt/1,
17 21 
basesaturation,/location/locationevent/soilobs/basesaturation_fraction/_percent_to_fraction/value,"""Percent base saturation"" (baseSaturation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
inputs/QMOR/Specimen/VegBIEN.csv
9 9 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
10 10 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
11 11 
samplingProtocol,/location/locationevent/*_id/method/name,
12 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
13 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
14 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
12 15 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
13 16 
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
14 17 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
mappings/for_review/VegCore-VegBIEN.csv
35 35 
subplotID,"//location/locationevent/_if[@name=""if subplot""]/cond/_exists",
36 36 
fieldNumber,"//location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
37 37 
eventID,"//location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
38 
eventID,"//location/locationevent/_if[@name=""if event""]/cond/_exists",
39 
fieldNumber,"//location/locationevent/_if[@name=""if event""]/cond/_exists",
40 
plotName,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
41 
locationID,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
42 
fieldNumber,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
43 
eventID,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
38 
endDate,"//location/locationevent/_if[@name=""if has event""]/cond/_exists",
39 
eventDate,"//location/locationevent/_if[@name=""if has event""]/cond/_exists",
40 
eventID,"//location/locationevent/_if[@name=""if has event""]/cond/_exists",
41 
fieldNumber,"//location/locationevent/_if[@name=""if has event""]/cond/_exists",
42 
startDate,"//location/locationevent/_if[@name=""if has event""]/cond/_exists",
43 
plotName,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
44 
locationID,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
45 
fieldNumber,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/authorlocationcode",
46 
endDate,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date",
47 
eventDate,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date",
48 
startDate,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date",
49 
eventDate,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date",
50 
eventID,"//location/locationevent/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
44 51 
communityID,//*/commname,
45 52 
communityName,//commconcept/commdescription,
46 53 
endDate,//locationevent/obsenddate/_*/date,
inputs/TEAM/VL/VegBIEN.csv
7 7 
Method,/location/locationevent/*_id/method/name,
8 8 
Site Name,/location/locationevent/*_id/project/projectname,
9 9 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
10 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
10 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
11 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
12 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
13 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
11 14 
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
12 15 
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
13 16 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
inputs/TEAM/VL/test.xml.ref
9 9 
                <locationevent>
10 10 
                    <method_id><method><name>$Method</name></method></method_id>
11 11 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
12 
                    <parent_id>
13 
                        <locationevent>
14 
                            <location_id><location><authorlocationcode>$1ha Plot Number</authorlocationcode></location></location_id>
15 
                            <obsenddate><_date><date><_dateRangeEnd><value>$Observation Date</value></_dateRangeEnd></date></_date></obsenddate>
16 
                            <obsstartdate><_date><date><_dateRangeStart><value>$Observation Date</value></_dateRangeStart></date></_date></obsstartdate>
17 
                        </locationevent>
18 
                    </parent_id>
12 19 
                    <obsenddate><_date><date><_dateRangeEnd><value>$Observation Date</value></_dateRangeEnd></date></_date></obsenddate>
13 20 
                    <obsstartdate><_date><date><_dateRangeStart><value>$Observation Date</value></_dateRangeStart></date></_date></obsstartdate>
14 21 
                    <taxonoccurrence>
......
167 174 
        </path>
168 175 
    </_simplifyPath>
169 176 
</VegBIEN>
170 
Inserted 33 new rows into database
177 
Inserted 34 new rows into database
inputs/TEAM/VT/VegBIEN.csv
7 7 
Spatial Method,/location/locationevent/*_id/method/name,
8 8 
Site Name,/location/locationevent/*_id/project/projectname,
9 9 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
10 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
10 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
11 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
12 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
13 
Observation Date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
11 14 
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
12 15 
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
13 16 
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
inputs/TEAM/VT/test.xml.ref
9 9 
                <locationevent>
10 10 
                    <method_id><method><name>$Spatial Method</name></method></method_id>
11 11 
                    <project_id><project><projectname>$Site Name</projectname></project></project_id>
12 
                    <parent_id>
13 
                        <locationevent>
14 
                            <location_id><location><authorlocationcode>$1ha Plot Number</authorlocationcode></location></location_id>
15 
                            <obsenddate><_date><date><_dateRangeEnd><value>$Observation Date</value></_dateRangeEnd></date></_date></obsenddate>
16 
                            <obsstartdate><_date><date><_dateRangeStart><value>$Observation Date</value></_dateRangeStart></date></_date></obsstartdate>
17 
                        </locationevent>
18 
                    </parent_id>
12 19 
                    <obsenddate><_date><date><_dateRangeEnd><value>$Observation Date</value></_dateRangeEnd></date></_date></obsenddate>
13 20 
                    <obsstartdate><_date><date><_dateRangeStart><value>$Observation Date</value></_dateRangeStart></date></_date></obsstartdate>
14 21 
                    <taxonoccurrence>
......
167 174 
        </path>
168 175 
    </_simplifyPath>
169 176 
</VegBIEN>
170 
Inserted 31 new rows into database
177 
Inserted 32 new rows into database
inputs/TEAM/TEAM_Sites/VegBIEN.csv
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 4 
Site Name,/location/locationevent/*_id/project/projectname,
5 
Name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
5 
CollectionDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
6 
Name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
7 
CollectionDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
8 
CollectionDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
6 9 
CollectionDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
7 10 
CollectionDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
8 11 
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
inputs/.geoscrub/geoscrub_cleaned_unique/VegBIEN.csv
3 3 
isInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists",
4 4 
geoscrubID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
5 5 
geoscrubID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 
geoscrubID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
6 
geoscrubID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
7 7 
geoscrubID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
8 8 
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
9 9 
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
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 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
10 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
11 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
9 12 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
10 13 
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
11 14 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
inputs/CTFS/StemObservation/VegBIEN.csv
6 6 
QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site
7 7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
8 8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
12 12 
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
13 13 
StemID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
14 14 
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,Assuming units based on the range and precision of values. Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>.
inputs/CTFS/Subplot/VegBIEN.csv
5 5 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 6 
QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site
7 7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
8 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
9 9 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
10 10 
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
11 11 
QuadratID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists",Not globally unique; unique only within Site
inputs/CTFS/PlotObservation/VegBIEN.csv
5 5 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
6 6 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
7 7 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
9 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
12 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
9 
EndDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
10 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
11 
StartDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
12 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
13 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authorlocationcode",
14 
EndDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
15 
StartDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
16 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
13 17 
EndDate,/location/locationevent/obsenddate/_*/date/_alt/1,
14 18 
StartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
15 19 
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 5 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
6 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
7 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
6 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
7 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
9 9 
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
10 10 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
11 11 
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
inputs/CTFS/SubplotObservation/VegBIEN.csv
6 6 
QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site
7 7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
8 8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
12 12 
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
13 13 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
14 14 
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
inputs/CTFS/Plot/VegBIEN.csv
14 14 
GROUP BY ""Elevation""::real , ""LocationName""
15 15 
ORDER BY ""Elevation""::real DESC
16 16 
-----"
17 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
18 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
17 
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
18 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
19 19 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
20 20 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
21 21 
DescriptionOfSite,/location/locationnarrative/_merge/1,
inputs/SALVIAS/plotMetadata/VegBIEN.csv
10 10 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
11 11 
PlotMethod,/location/locationevent/*_id/method/name,
12 12 
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
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)
14 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
13 
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
14 
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
15 
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
16 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
17 
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
18 
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
15 19 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
16 20 
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
17 21 
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
inputs/SALVIAS/plotObservations/VegBIEN.csv
12 12 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
13 13 
Line,/location/authorlocationcode,
14 14 
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15 
PlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
16 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
16 
-----
17 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
18 
FROM ""SALVIAS"".organisms
19 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
20 
GROUP BY ""PlotID"", ""Line""
21 
HAVING count(DISTINCT census_date) > 1
22 
-----"
23 
PlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
24 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
25 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
26 
-----
27 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
28 
FROM ""SALVIAS"".organisms
29 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
30 
GROUP BY ""PlotID"", ""Line""
31 
HAVING count(DISTINCT census_date) > 1
32 
-----"
33 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
34 
-----
35 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
36 
FROM ""SALVIAS"".organisms
37 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
38 
GROUP BY ""PlotID"", ""Line""
39 
HAVING count(DISTINCT census_date) > 1
40 
-----"
17 41 
census_date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
18 42 
-----
19 43 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
inputs/SALVIAS/plotObservations/test.xml.ref
12 12 
                </parent_id>
13 13 
                <authorlocationcode>$Line</authorlocationcode>
14 14 
                <locationevent>
15 
                    <parent_id>
16 
                        <locationevent>
17 
                            <location_id>
18 
                                <location>
19 
                                    <authorlocationcode>$PlotCode</authorlocationcode>
20 
                                    <sourceaccessioncode>$PlotID</sourceaccessioncode>
21 
                                </location>
22 
                            </location_id>
23 
                            <obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate>
24 
                            <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
25 
                        </locationevent>
26 
                    </parent_id>
15 27 
                    <obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate>
16 28 
                    <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
17 29 
                    <taxonoccurrence>
......
359 371 
        </path>
360 372 
    </_simplifyPath>
361 373 
</VegBIEN>
362 
Inserted 51 new rows into database
374 
Inserted 52 new rows into database
inputs/bien_web/observation/VegBIEN.csv
5 5 
plotAreaHa,/location/area_m2/_ha_to_m2/value,
6 6 
elevation_m,/location/elevation_m/_alt/1,
7 7 
plotMethod,/location/locationevent/*_id/method/name,
8 
plotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
8 
plotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
9 9 
observationDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
10 10 
pctCover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
11 11 
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
inputs/Madidi/Organism/VegBIEN.csv
10 10 
Number of subplot,/location/authorlocationcode,
11 11 
Expedition,/location/locationevent/*_id/project/projectname,
12 12 
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
13 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
14 
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
13 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
14 
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 15 
Observations,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
16 16 
Tree number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
17 17 
Specimen,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
inputs/Madidi/Plot/VegBIEN.csv
59 59 
Topographical situation,/location/landform,
60 60 
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data
61 61 
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data
62 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
63 
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
62 
First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
63 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
64 
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
65 
First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
66 
First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
64 67 
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
65 68 
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type
66 69 
First evaluation,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
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 3 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
4 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
5 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
4 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
5 
obsStartDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
6 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authorlocationcode",
7 
obsStartDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
6 8 
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
7 9 
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
8 10 
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
12 12 
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
13 13 
subplot,/location/authorlocationcode,
14 14 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15 
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
16 
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
16 
-----
17 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
18 
FROM ""SALVIAS-CSV"".organisms
19 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
20 
GROUP BY ""PLOT_ID"", subplot
21 
HAVING count(DISTINCT census_date) > 1
22 
-----"
23 
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
24 
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
25 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
26 
-----
27 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
28 
FROM ""SALVIAS-CSV"".organisms
29 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
30 
GROUP BY ""PLOT_ID"", subplot
31 
HAVING count(DISTINCT census_date) > 1
32 
-----"
33 
census_date,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value","This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
34 
-----
35 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
36 
FROM ""SALVIAS-CSV"".organisms
37 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
38 
GROUP BY ""PLOT_ID"", subplot
39 
HAVING count(DISTINCT census_date) > 1
40 
-----"
17 41 
census_date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
18 42 
-----
19 43 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
inputs/SALVIAS-CSV/Organism/test.xml.ref
12 12 
                </parent_id>
13 13 
                <authorlocationcode>$subplot</authorlocationcode>
14 14 
                <locationevent>
15 
                    <parent_id>
16 
                        <locationevent>
17 
                            <location_id>
18 
                                <location>
19 
                                    <authorlocationcode>$plot_code</authorlocationcode>
20 
                                    <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
21 
                                </location>
22 
                            </location_id>
23 
                            <obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate>
24 
                            <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
25 
                        </locationevent>
26 
                    </parent_id>
15 27 
                    <obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate>
16 28 
                    <obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
17 29 
                    <taxonoccurrence>
......
376 388 
        </path>
377 389 
    </_simplifyPath>
378 390 
</VegBIEN>
379 
Inserted 52 new rows into database
391 
Inserted 53 new rows into database
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
10 10 
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
11 11 
plot_methodology,/location/locationevent/*_id/method/name,
12 12 
project,/location/locationevent/*_id/project/projectname,
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)
14 
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
13 
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
14 
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
15 
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
16 
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
17 
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
18 
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
15 19 
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
16 20 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
17 21 
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
inputs/FIA/Organism/VegBIEN.csv
2 2 
PlotCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3 
PlotCD,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
4 4 
PlotCD,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
5 
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
6 6 
MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
7 7 
MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
8 8 
MeasYear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/VegBank/taxonobservation_/VegBIEN.csv
2 2 
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
3 3 
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
4 4 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
5 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
6 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
5 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
6 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
7 7 
collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
8 8 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
9 9 
museumaccessionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
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 
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
11 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
10 
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
11 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
12 12 
authorplotcode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
13 13 
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
14 14 
locationnarrative,/location/locationnarrative/_merge/1,
mappings/VegCore-VegBIEN.csv
35 35 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
36 36 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
37 37 
eventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
38 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
39 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
40 
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
41 
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
42 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
43 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
38 
endDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
39 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
40 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
41 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
42 
startDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
43 
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
44 
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
45 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authorlocationcode",
46 
endDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
47 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value",
48 
startDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
49 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value",
50 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",
44 51 
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
45 52 
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
46 53 
endDate,/location/locationevent/obsenddate/_*/date/_alt/1,

Also available in: Unified diff