Project

General

Profile

« Previous | Next » 

Revision 10675

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/stemlocation_/map.csv: stemcode, stemxposition, stemyposition: remapped to UNUSED. stemhealth is the only data field in this table that is populated, which means that VegBank does not provide data on reobservable stems even though the schema supports it.

View differences:

inputs/VegBank/stemlocation_/map.csv
10 10 
emb_stemcount,*emb_stemcount,,
11 11 
stemlocation_id,stemID,,
12 12 
stemlocation_id,individualID,,
13 
stemcode,authorStemCode,,
14 
stemxposition,organismX_m,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
15 
stemyposition,organismY_m,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
16 
stemhealth,*stemhealth,,
13 
stemcode,UNUSED#stemcode,,
14 
stemxposition,UNUSED#stemxposition,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
15 
stemyposition,UNUSED#stemyposition,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
16 
stemhealth,*stemhealth,,this *is* populated
17 17 
emb_stemlocation,*emb_stemlocation,,
inputs/VegBank/stemlocation_/VegBIEN.csv
2 2 
stemlocation_id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 3 
stemcount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
4 4 
stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/2,
5 
stemcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
6 5 
stemdiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
7 6 
stemheight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
8 7 
stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,
9 
stemxposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
10 
stemyposition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
11 8 
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
12 9 
stemlocation_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
13 10 
stemlocation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
15 12 
stemlocation_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/2",
16 13 
emb_stemcount,,** No join mapping for *emb_stemcount **
17 14 
emb_stemlocation,,** No join mapping for *emb_stemlocation **
15 
stemcode,,** No non-empty join mapping for UNUSED#stemcode **
18 16 
stemdiameteraccuracy,,** No join mapping for *stemdiameteraccuracy **
19 
stemhealth,,** No join mapping for *stemhealth **
17 
stemhealth,,** No join mapping for *stemhealth ** this *is* populated
20 18 
stemheightaccuracy,,** No join mapping for *stemheightaccuracy **
21 19 
stemtaxonarea,,** No join mapping for *stemtaxonarea **
20 
stemxposition,,"** No non-empty join mapping for UNUSED#stemxposition ** ""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
21 
stemyposition,,"** No non-empty join mapping for UNUSED#stemyposition ** ""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
22 22 
taxonimportance_id,,** No non-empty join mapping for OMIT#taxonimportance_id ** Omitted because stemcount_id is more specific
inputs/VegBank/stemlocation_/test.xml.ref
14 14 
                                    <plantobservation>
15 15 
                                        <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>
16 16 
                                        <stemobservation>
17 
                                            <authorstemcode>$stemcode</authorstemcode>
18 17 
                                            <diameterbreastheight_m><_cm_to_m><value>$stemdiameter</value></_cm_to_m></diameterbreastheight_m>
19 18 
                                            <height_m>$stemheight</height_m>
20 19 
                                            <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>
21 
                                            <xposition_m>$stemxposition</xposition_m>
22 
                                            <yposition_m>$stemyposition</yposition_m>
23 20 
                                        </stemobservation>
24 21 
                                    </plantobservation>
25 22 
                                    <sourceaccessioncode>$stemcount_id</sourceaccessioncode>
inputs/VegBank/stemlocation_/new_terms.csv
3 3 
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
4 4 
stemlocation_id,stemID,,
5 5 
stemlocation_id,individualID,,
6 
stemxposition,organismX_m,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
7 
stemyposition,organismY_m,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"

Also available in: Unified diff