Revision 4044
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SALVIAS/test/import.organisms.xml.ref | ||
|---|---|---|
| 7 | 7 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate> |
| 8 | 8 |
<taxonoccurrence> |
| 9 | 9 |
<aggregateoccurrence> |
| 10 |
<collectiondate><_date><date>$census_date</date></_date></collectiondate> |
|
| 11 | 10 |
<count>$NoInd</count> |
| 12 | 11 |
<cover>$cover_percent</cover> |
| 13 | 12 |
<definedvalue fkey="tablerecord_id"> |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:,Comments |
| 2 | 2 |
Line,/location/authorlocationcode/_alt/1, |
| 3 |
census_date,/location/locationevent/obsenddate/_*/date/_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: |
|
| 3 |
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:
|
|
| 4 | 4 |
----- |
| 5 | 5 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| 6 | 6 |
FROM ""SALVIAS"".organisms |
| ... | ... | |
| 8 | 8 |
GROUP BY ""PlotID"", ""Line"" |
| 9 | 9 |
HAVING count(DISTINCT census_date) > 1 |
| 10 | 10 |
-----" |
| 11 |
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: |
|
| 11 |
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:
|
|
| 12 | 12 |
----- |
| 13 | 13 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| 14 | 14 |
FROM ""SALVIAS"".organisms |
| ... | ... | |
| 16 | 16 |
GROUP BY ""PlotID"", ""Line"" |
| 17 | 17 |
HAVING count(DISTINCT census_date) > 1 |
| 18 | 18 |
-----" |
| 19 |
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,"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: |
|
| 20 |
----- |
|
| 21 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
|
| 22 |
FROM ""SALVIAS"".organisms |
|
| 23 |
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL |
|
| 24 |
GROUP BY ""PlotID"", ""Line"" |
|
| 25 |
HAVING count(DISTINCT census_date) > 1 |
|
| 26 |
-----" |
|
| 27 | 19 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 28 | 20 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 29 | 21 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| mappings/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
fieldNumber,/location/locationevent/authoreventcode, |
| 24 | 24 |
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 25 | 25 |
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 26 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
|
| 27 | 26 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| 28 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 27 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
|
|
| 29 | 28 |
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| 29 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1, |
|
| 30 | 30 |
precipitation,/location/locationevent/precipitation, |
| 31 | 31 |
acidity,/location/locationevent/soilobs/acidity, |
| 32 | 32 |
baseSaturation,/location/locationevent/soilobs/basesaturation, |
| ... | ... | |
| 45 | 45 |
silt,/location/locationevent/soilobs/silt, |
| 46 | 46 |
sodium,/location/locationevent/soilobs/sodium, |
| 47 | 47 |
texture,/location/locationevent/soilobs/texture, |
| 48 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date, |
|
| 49 | 48 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 50 | 49 |
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 51 | 50 |
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue", |
| mappings/for_review/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
fieldNumber,//locationevent/authoreventcode, |
| 24 | 24 |
communityID,//*/commname, |
| 25 | 25 |
communityName,//commconcept/commdescription, |
| 26 |
plotEventEndDate,//locationevent/obsenddate/_*/date, |
|
| 26 | 27 |
eventDate,//locationevent/obsenddate/_*/date, |
| 27 |
plotEventEndDate,//locationevent/obsenddate/_*/date,
|
|
| 28 |
plotEventStartDate,//locationevent/obsstartdate/_*/date,
|
|
| 28 | 29 |
eventDate,//locationevent/obsstartdate/_*/date, |
| 29 |
plotEventStartDate,//locationevent/obsstartdate/_*/date, |
|
| 30 | 30 |
precipitation,//locationevent/precipitation, |
| 31 | 31 |
acidity,//soilobs/acidity, |
| 32 | 32 |
baseSaturation,//soilobs/basesaturation, |
| ... | ... | |
| 45 | 45 |
silt,//soilobs/silt, |
| 46 | 46 |
sodium,//soilobs/sodium, |
| 47 | 47 |
texture,//soilobs/texture, |
| 48 |
eventDate,//aggregateoccurrence/collectiondate/_*/date, |
|
| 49 | 48 |
individualCount,//aggregateoccurrence/count, |
| 50 | 49 |
coverPercent,//aggregateoccurrence/cover, |
| 51 | 50 |
censusNumber,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue", |
Also available in: Unified diff
mappings/VegCSV-VegBIEN.specimens.csv: eventDate mappings: Removed collectiondate mapping because the eventDate refers only to the plot event. Added /_alt suffixes for mergability with DwC.