Revision 4565
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/SALVIAS-CSV/Organism/map.csv | ||
|---|---|---|
| 3 | 3 |
PLOT_ID,locationID, |
| 4 | 4 |
plot_code,plotName, |
| 5 | 5 |
census_no,censusNumber,"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." |
| 6 |
census_date,plotEventStartDate,"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:
|
|
| 6 |
census_date,eventDate,"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:
|
|
| 7 | 7 |
----- |
| 8 | 8 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
| 9 | 9 |
FROM ""SALVIAS-CSV"".organisms |
| inputs/SALVIAS-CSV/Organism/map.full.csv | ||
|---|---|---|
| 7 | 7 |
census_no,censusNumber,"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." |
| 8 | 8 |
cover_percent,coverPercent, |
| 9 | 9 |
stem_dbh,diameterBreastHeight, |
| 10 |
census_date,eventDate,"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 |
----- |
|
| 12 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
|
| 13 |
FROM ""SALVIAS-CSV"".organisms |
|
| 14 |
WHERE subplot IS NOT NULL AND census_date IS NOT NULL |
|
| 15 |
GROUP BY ""PLOT_ID"", subplot |
|
| 16 |
HAVING count(DISTINCT census_date) > 1 |
|
| 17 |
-----" |
|
| 10 | 18 |
family,family, |
| 11 | 19 |
genus,genus, |
| 12 | 20 |
habit,habit,"Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| ... | ... | |
| 20 | 28 |
infra_ep_1,infraspecificEpithet, |
| 21 | 29 |
stem_liana_infestation,lianaInfestation, |
| 22 | 30 |
PLOT_ID,locationID, |
| 23 |
census_date,plotEventStartDate,"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 |
----- |
|
| 25 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
|
| 26 |
FROM ""SALVIAS-CSV"".organisms |
|
| 27 |
WHERE subplot IS NOT NULL AND census_date IS NOT NULL |
|
| 28 |
GROUP BY ""PLOT_ID"", subplot |
|
| 29 |
HAVING count(DISTINCT census_date) > 1 |
|
| 30 |
-----" |
|
| 31 | 31 |
plot_code,plotName, |
| 32 | 32 |
tag2,previousTag/_alt/1,"Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other." |
| 33 | 33 |
stem_tag2,previousTag/_alt/2,Brad: see above |
| 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/_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 ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
| 18 | 18 |
FROM ""SALVIAS-CSV"".organisms |
| ... | ... | |
| 20 | 20 |
GROUP BY ""PLOT_ID"", subplot |
| 21 | 21 |
HAVING count(DISTINCT census_date) > 1 |
| 22 | 22 |
-----" |
| 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 |
----- |
|
| 25 |
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count |
|
| 26 |
FROM ""SALVIAS-CSV"".organisms |
|
| 27 |
WHERE subplot IS NOT NULL AND census_date IS NOT NULL |
|
| 28 |
GROUP BY ""PLOT_ID"", subplot |
|
| 29 |
HAVING count(DISTINCT census_date) > 1 |
|
| 30 |
-----" |
|
| 23 | 31 |
no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: 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." |
| 24 | 32 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 25 | 33 |
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." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
</parent_id> |
| 10 | 10 |
<authorlocationcode>$subplot</authorlocationcode> |
| 11 | 11 |
<locationevent> |
| 12 |
<obsstartdate><_date><date>$census_date</date></_date></obsstartdate> |
|
| 12 |
<obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate> |
|
| 13 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate> |
|
| 13 | 14 |
<taxonoccurrence> |
| 14 | 15 |
<aggregateoccurrence> |
| 15 | 16 |
<count>$no_of_individuals</count> |
Also available in: Unified diff
inputs/SALVIAS-CSV/Organism/map.csv: Remapped census_date to eventDate, since it is not the start of a range