Revision 4020
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SALVIAS/test/import.organisms.xml.ref | ||
|---|---|---|
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<authorlocationcode><_alt><1>$Line</1></_alt></authorlocationcode> |
| 5 | 5 |
<locationevent> |
| 6 |
<obsenddate><_date><date><_dateRangeEnd><value>$census_date</value></_dateRangeEnd></date></_date></obsenddate> |
|
| 7 |
<obsstartdate><_date><date><_dateRangeStart><value>$census_date</value></_dateRangeStart></date></_date></obsstartdate> |
|
| 6 | 8 |
<taxonoccurrence> |
| 7 | 9 |
<aggregateoccurrence> |
| 8 | 10 |
<collectiondate><_date><date>$census_date</date></_date></collectiondate> |
| 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: |
|
| 4 |
----- |
|
| 5 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
|
| 6 |
FROM ""SALVIAS"".organisms |
|
| 7 |
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL |
|
| 8 |
GROUP BY ""PlotID"", ""Line"" |
|
| 9 |
HAVING count(DISTINCT census_date) > 1 |
|
| 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: |
|
| 12 |
----- |
|
| 13 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
|
| 14 |
FROM ""SALVIAS"".organisms |
|
| 15 |
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL |
|
| 16 |
GROUP BY ""PlotID"", ""Line"" |
|
| 17 |
HAVING count(DISTINCT census_date) > 1 |
|
| 18 |
-----" |
|
| 3 | 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: |
| 4 | 20 |
----- |
| 5 | 21 |
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count |
| 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, |
|
| 26 | 27 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value, |
| 28 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
|
| 27 | 29 |
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value, |
| 28 | 30 |
precipitation,/location/locationevent/precipitation, |
| 29 | 31 |
acidity,/location/locationevent/soilobs/acidity, |
| mappings/for_review/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
fieldNumber,//locationevent/authoreventcode, |
| 24 | 24 |
communityID,//*/commname, |
| 25 | 25 |
communityName,//commconcept/commdescription, |
| 26 |
eventDate,//locationevent/obsenddate/_*/date, |
|
| 26 | 27 |
plotEventEndDate,//locationevent/obsenddate/_*/date, |
| 28 |
eventDate,//locationevent/obsstartdate/_*/date, |
|
| 27 | 29 |
plotEventStartDate,//locationevent/obsstartdate/_*/date, |
| 28 | 30 |
precipitation,//locationevent/precipitation, |
| 29 | 31 |
acidity,//soilobs/acidity, |
Also available in: Unified diff
mappings/VegCSV-VegBIEN.specimens.csv: eventDate: Added mappings to obsstartdate/obsenddate, since users of this field (currently SALVIAS census_date) intend it as the plot event's date. Keep the mapping to collectiondate because a non-range plot event date is also the collectiondate of all organisms in that plot event.