Project

General

Profile

« Previous | Next » 

Revision 4987

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore-VegBIEN.csv: Removed unnecessary /_first/# suffix for multiple terms in the same _exists expression, because _exists() only checks whether its node is non-empty, and it does not matter how many child nodes it contains

View differences:

inputs/TEAM/VL/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists",
3 3 
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
......
8 8 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
9 9 
Method,/location/locationevent/*_id/method/name,
10 10 
Site Name,/location/locationevent/*_id/project/projectname,
11 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
11 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
12 12 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
13 13 
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
14 14 
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
inputs/TEAM/VT/VegBIEN.csv
1 1 
TEAM,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
Subplot Number,"/location/_if[@name=""if subplot""]/cond/_exists",
3 3 
1ha Plot Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4 
Id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
5 5 
1ha Plot Number,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
......
8 8 
Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
9 9 
Spatial Method,/location/locationevent/*_id/method/name,
10 10 
Site Name,/location/locationevent/*_id/project/projectname,
11 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
11 
Subplot Number,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
12 12 
1ha Plot Number,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
13 13 
Observation Date,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
14 14 
Observation Date,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
inputs/Madidi/Organism/VegBIEN.csv
1 1 
Madidi,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
Number of subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
Number of subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 3 
Inventory name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4 
Inventory code,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
5 5 
Specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
......
9 9 
Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
10 10 
Number of subplot,/location/authorlocationcode,
11 11 
Expedition,/location/locationevent/*_id/project/projectname,
12 
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
12 
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
13 13 
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
14 14 
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 15 
Observations,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
inputs/ACAD/Specimen/VegBIEN.csv
43 43 
county,/location/locationplace/*_id/placepath/county,
44 44 
stateProvince,/location/locationplace/*_id/placepath/stateprovince,
45 45 
verbatimElevation,/location/verbatimelevation,
46 
basisOfRecord,,** No join mapping for basisOfRecord **
47 
bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation **
48 
dynamicProperties,,** No join mapping for dynamicProperties **
49 
geodeticDatum,,** No join mapping for geodeticDatum **
50 
georeferenceSources,,** No join mapping for georeferenceSources **
51 
georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus **
52 
identificationRemarks,,** No join mapping for identificationRemarks **
53 
language,,** No join mapping for dcterms:language **
54 
locationRemarks,,** No join mapping for locationRemarks **
55 
modified,,** No join mapping for dcterms:modified **
56 
municipality,,** No join mapping for municipality **
57 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
58 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
59 
reproductiveCondition,,** No join mapping for reproductiveCondition **
60 
rights,,** No join mapping for dcterms:rights **
61 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
62 
type,,** No join mapping for dcterms:type **
63 
verbatimDepth,,** No join mapping for verbatimDepth **
46 
basisOfRecord,,** No join mapping for *basisOfRecord **
47 
bibliographicCitation,,** No join mapping for *dcterms:bibliographicCitation **
48 
dynamicProperties,,** No join mapping for *dynamicProperties **
49 
geodeticDatum,,** No join mapping for *geodeticDatum **
50 
georeferenceSources,,** No join mapping for *georeferenceSources **
51 
georeferenceVerificationStatus,,** No join mapping for *georeferenceVerificationStatus **
52 
identificationRemarks,,** No join mapping for *identificationRemarks **
53 
language,,** No join mapping for *dcterms:language **
54 
locationRemarks,,** No join mapping for *locationRemarks **
55 
modified,,** No join mapping for *dcterms:modified **
56 
municipality,,** No join mapping for *municipality **
57 
occurrenceRemarks,,** No join mapping for *occurrenceRemarks **
58 
ownerInstitutionCode,,** No join mapping for *ownerInstitutionCode **
59 
reproductiveCondition,,** No join mapping for *reproductiveCondition **
60 
rights,,** No join mapping for *dcterms:rights **
61 
rightsHolder,,** No join mapping for *dcterms:rightsHolder **
62 
type,,** No join mapping for *dcterms:type **
63 
verbatimDepth,,** No join mapping for *verbatimDepth **
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
1 1 
SALVIAS-CSV,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3 3 
plot_code,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4 
PLOT_ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
5 5 
coll_number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists/_alt/1",Brad: Map instead as for voucher_string
......
11 11 
plot_code,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
12 12 
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
13 13 
subplot,/location/authorlocationcode,
14 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
14 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15 15 
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
16 16 
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
17 17 
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:
inputs/CVS/Organism/VegBIEN.csv
4 4 
publicLatitude,"/location/locationcoords/latitude_deg/_nullIf:[null=0,type=float]/value",
5 5 
publicLongitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",
6 6 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
7 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
7 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
8 8 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
9 9 
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
10 10 
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
inputs/CTFS/StemObservation/VegBIEN.csv
1 1 
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
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 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
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/_first/1",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
10 10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
12 12 
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
inputs/CTFS/Subplot/VegBIEN.csv
1 1 
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
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 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
7 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
8 8 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
9 9 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
10 10 
StartX,/location/sublocationxposition_m,
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/_first/1",
9 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
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 10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 11 
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
12 12 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
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/_first/1",
6 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
7 7 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
8 8 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
9 9 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
inputs/CTFS/SubplotObservation/VegBIEN.csv
1 1 
CTFS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
2 
QuadratID,"/location/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site
3 3 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
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 
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",Not globally unique; unique only within Site
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/_first/1",
9 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
10 10 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
11 11 
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
12 12 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
inputs/SALVIAS/plotObservations/VegBIEN.csv
1 1 
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
Line,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
Line,"/location/_if[@name=""if subplot""]/cond/_exists",
3 3 
PlotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4 
PlotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
5 5 
coll_number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists/_alt/1",Brad: Map instead as for voucher_string
......
11 11 
PlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
12 12 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
13 13 
Line,/location/authorlocationcode,
14 
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
14 
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15 15 
PlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
16 16 
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
17 17 
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:
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/_first/1",
5 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
6 6 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if 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,
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 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1",
11 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
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 12 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
13 13 
authorobscode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
14 14 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
mappings/VegCore-VegBIEN.csv
1 1 
VegCore,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists/_first/1",
3 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
4 3 
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5 4 
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
6 5 
fieldNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
......
38 37 
samplingProtocol,/location/locationevent/*_id/method/name,
39 38 
projectName,/location/locationevent/*_id/project/projectname,
40 39 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
41 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/1",
42 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2",
40 
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
41 
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
43 42 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
44 43 
eventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
45 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1",
46 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
44 
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
45 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists",
47 46 
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
48 47 
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
49 48 
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
......
190 189 
subplotY,/location/sublocationyposition_m,
191 190 
verbatimElevation,/location/verbatimelevation,
192 191 
verbatimElevation_m,/location/verbatimelevation,
192 
subplotID,VegBIEN:/_simplifyPath:[next=parent_id]/path,
193 193 
OMIT,,
194 194 
PRIVATE,,
195 195 
UNUSED,,
mappings/for_review/VegCore-VegBIEN.csv
1 1 
VegCore,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
subplotID,"/location/_if[@name=""if subplot""]/cond/1",
3 
subplot,"/location/_if[@name=""if subplot""]/cond/2",
2 
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
4 3 
plotName,"/location/_if[@name=""if subplot""]/else/authorlocationcode",
5 4 
locationID,"/location/authorlocationcode/_if[@name=""if locationID""]/cond/_exists",
6 5 
fieldNumber,"/location/authorlocationcode/_if[@name=""if locationID""]/else",
......
38 37 
samplingProtocol,//method/name,
39 38 
projectName,//project/projectname,
40 39 
projectID,//project/sourceaccessioncode,
41 
subplotID,"//location/locationevent/_if[@name=""if subplot""]/cond/1",
42 
subplot,"//location/locationevent/_if[@name=""if subplot""]/cond/2",
40 
subplot,"//location/locationevent/_if[@name=""if subplot""]/cond/_exists",
41 
subplotID,"//location/locationevent/_if[@name=""if subplot""]/cond/_exists",
43 42 
fieldNumber,"//location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
44 43 
eventID,"//location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
45 
eventID,"//location/locationevent/_if[@name=""if event""]/cond/1",
46 
fieldNumber,"//location/locationevent/_if[@name=""if event""]/cond/2",
44 
eventID,"//location/locationevent/_if[@name=""if event""]/cond/_exists",
45 
fieldNumber,"//location/locationevent/_if[@name=""if event""]/cond/_exists",
47 46 
plotName,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
48 47 
locationID,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
49 48 
fieldNumber,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
......
190 189 
subplotY,//location/sublocationyposition_m,
191 190 
verbatimElevation,//location/verbatimelevation,
192 191 
verbatimElevation_m,//location/verbatimelevation,
192 
subplotID,VegBIEN:,
193 193 
OMIT,,
194 194 
PRIVATE,,
195 195 
UNUSED,,

Also available in: Unified diff