Project

General

Profile

« Previous | Next » 

Revision 4014

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SALVIAS*/maps/VegCSV.organisms.csv: census_date: Documented that this is for the subplot, not the organism, as all organisms in a subplot have the same value for it

View differences:

inputs/SALVIAS-CSV/maps/VegCSV.organisms.csv
3 3 
PLOT_ID,parentLocationID,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
4 4 
plot_code,parentPlotName,"Brad: Same as plotCode, above"
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/_date/year,
6 
census_date,plotEventStartDate/_date/year,"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 
-----
8 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
9 
FROM ""SALVIAS-CSV"".organisms
10 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
11 
GROUP BY ""PLOT_ID"", subplot
12 
HAVING count(DISTINCT census_date) > 1
13 
-----"
7 14 
subplot,plotName,
8 15 
individual_code,recordNumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
9 16 
ind_id,,Brad: OMIT
inputs/SALVIAS-CSV/maps/VegCSV.organisms.full.csv
25 25 
OBSERVATION_ID,occurrenceID,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
26 26 
PLOT_ID,parentLocationID,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
27 27 
plot_code,parentPlotName,"Brad: Same as plotCode, above"
28 
census_date,plotEventStartDate/_date/year,
28 
census_date,plotEventStartDate/_date/year,"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:
29 
-----
30 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
31 
FROM ""SALVIAS-CSV"".organisms
32 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
33 
GROUP BY ""PLOT_ID"", subplot
34 
HAVING count(DISTINCT census_date) > 1
35 
-----"
29 36 
subplot,plotName,
30 37 
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."
31 38 
stem_tag2,previousTag/_alt/2,Brad: see above
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
1 1 
SALVIAS-CSV,VegBIEN:,Comments
2 2 
subplot,/location/authorlocationcode/_alt/1,
3 
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_date/year,
3 
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_date/year,"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 ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
6 
FROM ""SALVIAS-CSV"".organisms
7 
WHERE subplot IS NOT NULL AND census_date IS NOT NULL
8 
GROUP BY ""PLOT_ID"", subplot
9 
HAVING count(DISTINCT census_date) > 1
10 
-----"
4 11 
no_of_individuals,/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."
5 12 
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
6 13 
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/maps/VegCSV.organisms.csv
3 3 
PlotID,parentLocationID,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above."
4 4 
PlotCode,parentPlotName,"Brad: Same as plotCode, above"
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,eventDate/_*/date,
6 
census_date,eventDate/_*/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:
7 
-----
8 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
9 
FROM ""SALVIAS"".organisms
10 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
11 
GROUP BY ""PlotID"", ""Line""
12 
HAVING count(DISTINCT census_date) > 1
13 
-----"
7 14 
OrigRecordID,,
8 15 
Line,plotName,
9 16 
Ind,recordNumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
inputs/SALVIAS/maps/VegCSV.organisms.full.csv
12 12 
infra_rank_1,computer.taxonRank,
13 13 
cover_percent,coverPercent,
14 14 
temp_dbh,diameterBreastHeight,
15 
census_date,eventDate/_*/date,
15 
census_date,eventDate/_*/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:
16 
-----
17 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
18 
FROM ""SALVIAS"".organisms
19 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
20 
GROUP BY ""PlotID"", ""Line""
21 
HAVING count(DISTINCT census_date) > 1
22 
-----"
16 23 
OrigFamily,family,Brad: OMIT
17 24 
Notes,fieldNotes,
18 25 
Habit,"growthForm/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
inputs/SALVIAS/maps/VegBIEN.organisms.csv
1 1 
SALVIAS,VegBIEN:,Comments
2 2 
Line,/location/authorlocationcode/_alt/1,
3 
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_*/date,
3 
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_*/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 
-----
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 
-----"
4 11 
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."
5 12 
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
6 13 
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."

Also available in: Unified diff