Project

General

Profile

« Previous | Next » 

Revision 10696

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/VegBank/stemlocation_/map.csv: also join together taxonimportance_id, stemcount_id for aggregateOrganismObservationID so that the aggregateoccurrence pkeys match up with those imported from stemcount

View differences:

inputs/VegBank/stemlocation_/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 
stemcount_id,aggregateOrganismObservationID,,
3 
taxonimportance_id,OMIT#taxonimportance_id,,Omitted because stemcount_id is more specific
2 
stemcount_id,aggregateOrganismObservationID,/_join/2,
3 
taxonimportance_id,aggregateOrganismObservationID,/_join/1,
4 4 
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>)"
5 5 
stemdiameteraccuracy,*stemdiameteraccuracy,,
6 6 
stemheight,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>)"
inputs/VegBank/stemlocation_/VegBIEN.csv
5 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>)"
6 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>)"
7 7 
stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,
8 
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
8 
taxonimportance_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode/_join/1,
9 
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode/_join/2,
9 10 
stemlocation_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
10 11 
stemlocation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
11 
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",
12 
taxonimportance_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists/_join/1",
13 
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists/_join/2",
12 14 
stemlocation_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/2",
13 15 
emb_stemcount,,** No join mapping for *emb_stemcount **
14 16 
emb_stemlocation,,** No join mapping for *emb_stemlocation **
......
19 21 
stemtaxonarea,,** No join mapping for *stemtaxonarea **
20 22 
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 23 
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 
taxonimportance_id,,** No non-empty join mapping for OMIT#taxonimportance_id ** Omitted because stemcount_id is more specific
inputs/VegBank/stemlocation_/test.xml.ref
19 19 
                                            <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>
20 20 
                                        </stemobservation>
21 21 
                                    </plantobservation>
22 
                                    <sourceaccessioncode>$stemcount_id</sourceaccessioncode>
22 
                                    <sourceaccessioncode>
23 
                                        <_join>
24 
                                            <1>$taxonimportance_id</1>
25 
                                            <2>$stemcount_id</2>
26 
                                        </_join>
27 
                                    </sourceaccessioncode>
23 28 
                                </aggregateoccurrence>
24 29 
                            </taxonoccurrence>
25 30 
                        </locationevent>
inputs/VegBank/stemlocation_/new_terms.csv
1 
stemcount_id,aggregateOrganismObservationID,,
2 
taxonimportance_id,OMIT#taxonimportance_id,,Omitted because stemcount_id is more specific
1 
stemcount_id,aggregateOrganismObservationID,/_join/2,
2 
taxonimportance_id,aggregateOrganismObservationID,/_join/1,
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,,

Also available in: Unified diff