Revision 4563
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
SiteName,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 12 | 12 |
1haPlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 13 |
ObservationDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 14 |
ObservationDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 13 |
ObservationDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 14 |
ObservationDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 15 | 15 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 16 | 16 |
DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
| 17 | 17 |
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
SiteName,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 12 | 12 |
1haPlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 13 |
ObservationDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 14 |
ObservationDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 13 |
ObservationDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 14 |
ObservationDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 15 | 15 |
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 16 | 16 |
dbh,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight, |
| 17 | 17 |
TreeNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2 |
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 21 | 21 |
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 22 | 22 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 23 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 23 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 24 | 24 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity, |
| 25 | 25 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium, |
| 26 | 26 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon, |
| inputs/Madidi/Plot/test.xml.ref | ||
|---|---|---|
| 129 | 129 |
</commconcept_id> |
| 130 | 130 |
</commdetermination> |
| 131 | 131 |
</commclass> |
| 132 |
<obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 132 |
<obsstartdate><_date><date>$First evaluation</date></_date></obsstartdate>
|
|
| 133 | 133 |
<soilobs> |
| 134 | 134 |
<acidity>$Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05)</acidity> |
| 135 | 135 |
<calcium>$Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)</calcium> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
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", |
| 12 | 12 |
country,"/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 | 13 |
continent,"/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", |
| 14 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 15 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 14 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 15 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 16 | 16 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2, |
| 17 | 17 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 18 | 18 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 12 | 12 |
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 13 | 13 |
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 14 | 14 |
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/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:
|
|
| 15 |
census_date,/location/locationevent/obsstartdate/_*/date/_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:
|
|
| 16 | 16 |
----- |
| 17 | 17 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
| 18 | 18 |
FROM ""SALVIAS-CSV"".organisms |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
</parent_id> |
| 10 | 10 |
<authorlocationcode>$subplot</authorlocationcode> |
| 11 | 11 |
<locationevent> |
| 12 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 12 |
<obsstartdate><_date><date>$census_date</date></_date></obsstartdate>
|
|
| 13 | 13 |
<taxonoccurrence> |
| 14 | 14 |
<aggregateoccurrence> |
| 15 | 15 |
<count>$no_of_individuals</count> |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 23 | 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." |
| 24 | 24 |
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 25 | 25 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 27 |
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 27 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 28 | 28 |
precip_mm,/location/locationevent/precipitation, |
| 29 | 29 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
| 30 | 30 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
| inputs/SALVIAS-CSV/Plot/test.xml.ref | ||
|---|---|---|
| 155 | 155 |
</commconcept_id> |
| 156 | 156 |
</commdetermination> |
| 157 | 157 |
</commclass> |
| 158 |
<obsenddate><_date><date><_dateRangeEnd><value>$date_finish</value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 159 |
<obsstartdate><_date><date><_dateRangeStart><value>$date_start</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 158 |
<obsenddate><_date><date>$date_finish</date></_date></obsenddate>
|
|
| 159 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
|
|
| 160 | 160 |
<precipitation>$precip_mm</precipitation> |
| 161 | 161 |
<soilobs> |
| 162 | 162 |
<acidity> |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 11 | 11 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
| 12 | 12 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
| 13 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 13 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 14 | 14 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 15 | 15 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 16 | 16 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 49 | 49 |
</locationdetermination> |
| 50 | 50 |
<locationevent> |
| 51 | 51 |
<authoreventcode>$authorObsCode</authoreventcode> |
| 52 |
<obsstartdate><_date><date><_dateRangeStart><value>$obsStartDate</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 52 |
<obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>
|
|
| 53 | 53 |
<taxonoccurrence> |
| 54 | 54 |
<aggregateoccurrence><cover>$%cover</cover></aggregateoccurrence> |
| 55 | 55 |
<authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode> |
| inputs/CTFS/PlotObservation/VegBIEN.csv | ||
|---|---|---|
| 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", |
| 13 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
|
| 14 |
startDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
|
| 13 |
endDate,/location/locationevent/obsenddate/_*/date/_alt/1, |
|
| 14 |
startDate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
|
| inputs/CTFS/PlotObservation/test.xml.ref | ||
|---|---|---|
| 5 | 5 |
<locationevent> |
| 6 | 6 |
<authoreventcode>$PlotCensusNumber</authoreventcode> |
| 7 | 7 |
<sourceaccessioncode>$CensusID</sourceaccessioncode> |
| 8 |
<obsenddate><_date><date><_dateRangeEnd><value>$EndDate</value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 9 |
<obsstartdate><_date><date><_dateRangeStart><value>$StartDate</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 8 |
<obsenddate><_date><date>$EndDate</date></_date></obsenddate>
|
|
| 9 |
<obsstartdate><_date><date>$StartDate</date></_date></obsstartdate>
|
|
| 10 | 10 |
</locationevent> |
| 11 | 11 |
</location> |
| 12 | 12 |
</VegBIEN> |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 23 | 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." |
| 24 | 24 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 25 | 25 |
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 27 |
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 26 |
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 27 |
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 28 | 28 |
Precip,/location/locationevent/precipitation, |
| 29 | 29 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
| 30 | 30 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
| inputs/SALVIAS/plotMetadata/test.xml.ref | ||
|---|---|---|
| 155 | 155 |
</commconcept_id> |
| 156 | 156 |
</commdetermination> |
| 157 | 157 |
</commclass> |
| 158 |
<obsenddate><_date><date><_dateRangeEnd><value>$date_finish</value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 159 |
<obsstartdate><_date><date><_dateRangeStart><value>$date_start</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 158 |
<obsenddate><_date><date>$date_finish</date></_date></obsenddate>
|
|
| 159 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
|
|
| 160 | 160 |
<precipitation>$Precip</precipitation> |
| 161 | 161 |
<soilobs> |
| 162 | 162 |
<acidity> |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 12 | 12 |
Line,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| 13 | 13 |
PlotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 14 | 14 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 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:
|
|
| 15 |
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:
|
|
| 16 | 16 |
----- |
| 17 | 17 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| 18 | 18 |
FROM ""SALVIAS"".organisms |
| ... | ... | |
| 20 | 20 |
GROUP BY ""PlotID"", ""Line"" |
| 21 | 21 |
HAVING count(DISTINCT census_date) > 1 |
| 22 | 22 |
-----" |
| 23 |
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/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:
|
|
| 23 |
census_date,/location/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:
|
|
| 24 | 24 |
----- |
| 25 | 25 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| 26 | 26 |
FROM ""SALVIAS"".organisms |
| inputs/VegBank/observation_/VegBIEN.csv | ||
|---|---|---|
| 12 | 12 |
plotID,"/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", |
| 15 |
obsenddate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 16 |
obsstartdate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 15 |
obsenddate,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 16 |
obsstartdate,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 17 | 17 |
baseSaturation,/location/locationevent/soilobs/basesaturation, |
| 18 | 18 |
exchangecapacity,/location/locationevent/soilobs/cationexchangecapacity, |
| 19 | 19 |
soilclay,/location/locationevent/soilobs/clay, |
| inputs/VegBank/observation_/test.xml.ref | ||
|---|---|---|
| 7 | 7 |
<project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id> |
| 8 | 8 |
<authoreventcode>$authorobscode</authoreventcode> |
| 9 | 9 |
<sourceaccessioncode>$observation_id</sourceaccessioncode> |
| 10 |
<obsenddate><_date><date><_dateRangeEnd><value>$obsenddate</value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 11 |
<obsstartdate><_date><date><_dateRangeStart><value>$obsstartdate</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 10 |
<obsenddate><_date><date>$obsenddate</date></_date></obsenddate>
|
|
| 11 |
<obsstartdate><_date><date>$obsstartdate</date></_date></obsstartdate>
|
|
| 12 | 12 |
<soilobs> |
| 13 | 13 |
<basesaturation>$basesaturation</basesaturation> |
| 14 | 14 |
<cationexchangecapacity>$exchangecapacity</cationexchangecapacity> |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
country,"/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", |
| 22 | 22 |
continent,"/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", |
| 23 | 23 |
samplingProtocol,/location/locationevent/*_id/method/name, |
| 24 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 25 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 24 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 25 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 26 | 26 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 27 | 27 |
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 28 | 28 |
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 48 | 48 |
eventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 49 | 49 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 50 | 50 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 51 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 52 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 53 |
startDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 54 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 51 |
endDate,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 52 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 53 |
startDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 54 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 55 | 55 |
precipitation,/location/locationevent/precipitation, |
| 56 | 56 |
acidity,/location/locationevent/soilobs/acidity, |
| 57 | 57 |
baseSaturation,/location/locationevent/soilobs/basesaturation, |
| mappings/Veg+-VegBIEN.csv | ||
|---|---|---|
| 88 | 88 |
plotEventID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 89 | 89 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 90 | 90 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 91 |
endDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 92 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 93 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 94 |
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 95 |
startDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 96 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
|
|
| 91 |
endDate,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 92 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_alt/1,
|
|
| 93 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
|
|
| 94 |
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 95 |
startDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
|
|
| 96 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
|
|
| 97 | 97 |
precipitation,/location/locationevent/precipitation, |
| 98 | 98 |
acidity,/location/locationevent/soilobs/acidity, |
| 99 | 99 |
baseSaturation,/location/locationevent/soilobs/basesaturation, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: startDate, endDate mappings: Removed _dateRangeStart/_dateRangeEnd filters because these are assumed to already be start and end dates of a range. (eventDate should be used for concatenated date ranges.)