Revision 4458
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
Number of subplot,/location/authorlocationcode, |
| 10 | 10 |
Expedition,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 12 |
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 13 |
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 12 | 14 |
Observations,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
| 13 | 15 |
Tree number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2, |
| 14 | 16 |
Specimen,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
Longitude (DMS),"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
| 17 | 17 |
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data |
| 18 | 18 |
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data |
| 19 |
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 20 |
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 19 | 21 |
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 20 | 22 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 21 | 23 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
PLOT_ID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 11 | 11 |
subplot,/location/authorlocationcode, |
| 12 | 12 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 13 |
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 14 |
PLOT_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 13 | 15 |
census_date,/location/locationevent/obsstartdate/_*/date/_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: |
| 14 | 16 |
----- |
| 15 | 17 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
major_geo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
| 20 | 20 |
plot_methodology,/location/locationevent/*_id/method/name, |
| 21 | 21 |
project,/location/locationevent/*_id/project/projectname, |
| 22 |
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) |
|
| 23 |
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." |
|
| 22 | 24 |
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 23 | 25 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 24 | 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 9 | 9 |
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 10 | 10 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 11 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 11 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 12 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 12 | 13 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| 13 | 14 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 14 | 15 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
QuadratID,/location/authorlocationcode/_first/1, |
| 7 | 7 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 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", |
|
| 10 | 12 |
MeasureID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode, |
| 11 | 13 |
StemID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode, |
| 12 | 14 |
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 4 | 4 |
<parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id> |
| 5 | 5 |
<authorlocationcode>$QuadratID</authorlocationcode> |
| 6 | 6 |
<locationevent> |
| 7 |
<parent_id><locationevent><sourceaccessioncode>$CensusID</sourceaccessioncode></locationevent></parent_id> |
|
| 7 |
<parent_id> |
|
| 8 |
<locationevent> |
|
| 9 |
<location_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></location_id> |
|
| 10 |
<sourceaccessioncode>$CensusID</sourceaccessioncode> |
|
| 11 |
</locationevent> |
|
| 12 |
</parent_id> |
|
| 8 | 13 |
<taxonoccurrence> |
| 9 | 14 |
<aggregateoccurrence> |
| 10 | 15 |
<plantobservation> |
| ... | ... | |
| 77 | 82 |
</locationevent> |
| 78 | 83 |
</location> |
| 79 | 84 |
</VegBIEN> |
| 80 |
Inserted 16 new rows into database |
|
| 85 |
Inserted 19 new rows into database |
|
| inputs/CTFS/Subplot/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
QuadratName,/location/authorlocationcode/_first/2, |
| 9 | 9 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 10 | 10 |
QuadratName,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/2", |
| 11 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 11 | 12 |
StartX,/location/sublocationxposition, |
| 12 | 13 |
StartY,/location/sublocationyposition, |
| 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 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/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", |
|
| 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", |
|
| 10 | 13 |
EndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| 11 | 14 |
StartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| 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/parent_id/locationevent/sourceaccessioncode", |
|
| 6 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 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", |
|
| 7 | 9 |
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 8 | 10 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| 9 | 11 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
| inputs/CTFS/SubplotObservation/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
QuadratID,/location/authorlocationcode/_first/1, |
| 7 | 7 |
QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2/_first/1", |
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 9 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 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", |
|
| inputs/CTFS/SubplotObservation/test.xml.ref | ||
|---|---|---|
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id> |
| 5 | 5 |
<authorlocationcode>$QuadratID</authorlocationcode> |
| 6 |
<locationevent><parent_id><locationevent><sourceaccessioncode>$CensusID</sourceaccessioncode></locationevent></parent_id></locationevent> |
|
| 6 |
<locationevent> |
|
| 7 |
<parent_id> |
|
| 8 |
<locationevent> |
|
| 9 |
<location_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></location_id> |
|
| 10 |
<sourceaccessioncode>$CensusID</sourceaccessioncode> |
|
| 11 |
</locationevent> |
|
| 12 |
</parent_id> |
|
| 13 |
</locationevent> |
|
| 7 | 14 |
</location> |
| 8 | 15 |
</VegBIEN> |
| 9 |
Inserted 6 new rows into database |
|
| 16 |
Inserted 7 new rows into database |
|
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
| 11 | 11 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
| 12 | 12 |
CountryName,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| 13 |
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 14 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 13 | 15 |
DescriptionOfSite,/location/locationnarrative/_merge/1, |
| 14 | 16 |
LocationName,/location/locationnarrative/_merge/1, |
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
| 7 | 7 |
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 8 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 |
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 9 | 10 |
MeasDay,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
| 10 | 11 |
MeasMon,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
| 11 | 12 |
MeasYear,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
MajorGeo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
| 20 | 20 |
PlotMethod,/location/locationevent/*_id/method/name, |
| 21 | 21 |
project_id,/location/locationevent/*_id/project/projectname, |
| 22 |
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) |
|
| 23 |
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." |
|
| 22 | 24 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 23 | 25 |
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 24 | 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 11 | 11 |
Line,/location/authorlocationcode, |
| 12 | 12 |
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 13 |
PlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 14 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 13 | 15 |
census_date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,"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: |
| 14 | 16 |
----- |
| 15 | 17 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 41 | 41 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 42 | 42 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 43 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 44 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 43 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 44 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 45 |
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 46 |
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 47 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 48 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 45 | 49 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 46 | 50 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 47 | 51 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| mappings/Veg+-VegBIEN.csv | ||
|---|---|---|
| 130 | 130 |
PlotEventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 131 | 131 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 132 | 132 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 133 |
AuthorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 134 |
FieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 135 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 136 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 137 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 138 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 139 |
EventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 140 |
PlotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 141 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 142 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 133 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 134 |
EventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 135 |
PlotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 136 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 137 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 138 |
AuthorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 139 |
FieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 140 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 141 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 142 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 143 |
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 144 |
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 145 |
LocationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 146 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 147 |
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 148 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 149 |
AuthorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 150 |
FieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 151 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 152 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 153 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 154 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 155 |
EventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 156 |
PlotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 157 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 158 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 143 | 159 |
CommunityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 144 | 160 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 145 | 161 |
CommunityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| mappings/Veg+.cs-VegBIEN.csv | ||
|---|---|---|
| 71 | 71 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 72 | 72 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 73 | 73 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 74 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 75 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 76 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 77 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 78 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 79 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 74 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 75 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 76 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
|
| 77 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 78 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 79 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
|
| 80 |
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 81 |
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 82 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 83 |
PlotCensusNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 84 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 85 |
fieldNumber,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 86 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 87 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 88 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 80 | 89 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 81 | 90 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 82 | 91 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
subplot,"//location/locationevent/_if[@name=""if subplot""]/cond/2", |
| 41 | 41 |
fieldNumber,"//location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 42 | 42 |
eventID,"//location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 43 |
fieldNumber,"//location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/authorlocationcode", |
|
| 44 |
eventID,"//location/locationevent/_if[@name=""if subplot""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 43 |
eventID,"//location/locationevent/_if[@name=""if event""]/cond/1", |
|
| 44 |
fieldNumber,"//location/locationevent/_if[@name=""if event""]/cond/2", |
|
| 45 |
plotName,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
|
| 46 |
locationID,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
|
| 47 |
fieldNumber,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
|
| 48 |
eventID,"//location/locationevent/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
|
| 45 | 49 |
communityID,//*/commname, |
| 46 | 50 |
communityName,//commconcept/commdescription, |
| 47 | 51 |
endDate,//locationevent/obsenddate/_*/date, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: if subplot: Also forward locationID and plotName to the location of the parent locationevent (in addition to the parent location of the location), in order to "complete the diamond" connecting subplot locationevent -> (parent plot locationevent, subplot location) -> parent plot location