Project

General

Profile

« Previous | Next » 

Revision 6747

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/VegBank/stemlocation/map.csv: Remapped stemcount_id to aggregateOccurrenceID to match stemcount_id's mapping in stemcount_

View differences:

inputs/VegBank/stemlocation/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 2 
stemlocation_id,stemID,,
3 
stemcount_id,individualID,,
3 
stemcount_id,aggregateOccurrenceID,,
4 4 
stemcode,authorStemCode,,
5 5 
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>)"
6 6 
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>)"
inputs/VegBank/stemlocation/VegBIEN.csv
1 1 
VegBank,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
stemcount_id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
4 2 
stemcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
5 3 
stemlocation_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,
6 4 
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>)"
7 5 
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>)"
8 
stemcount_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
9 
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",
6 
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
7 
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",
10 8 
emb_stemlocation,,** No join mapping for *emb_stemlocation **
11 9 
stemhealth,,** No join mapping for *stemhealth **
inputs/VegBank/stemlocation/test.xml.ref
11 11 
                            <taxonoccurrence>
12 12 
                                <aggregateoccurrence>
13 13 
                                    <plantobservation>
14 
                                        <sourceaccessioncode>$stemcount_id</sourceaccessioncode>
15 14 
                                        <stemobservation>
16 15 
                                            <authorstemcode>$stemcode</authorstemcode>
17 16 
                                            <sourceaccessioncode>$stemlocation_id</sourceaccessioncode>
......
19 18 
                                            <yposition_m>$stemyposition</yposition_m>
20 19 
                                        </stemobservation>
21 20 
                                    </plantobservation>
21 
                                    <sourceaccessioncode>$stemcount_id</sourceaccessioncode>
22 22 
                                </aggregateoccurrence>
23 
                                <sourceaccessioncode>$stemcount_id</sourceaccessioncode>
24 23 
                            </taxonoccurrence>
25 24 
                        </locationevent>
26 25 
                    </location>
......
29 28 
        </path>
30 29 
    </_setDefault>
31 30 
</VegBIEN>
32 
Inserted 9 new rows into database
31 
Inserted 7 new rows into database
inputs/VegBank/stemlocation/new_terms.csv
1 1 
stemlocation_id,stemID,,
2 
stemcount_id,individualID,,
2 
stemcount_id,aggregateOccurrenceID,,
3 3 
stemcode,authorStemCode,,
4 4 
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>)"
5 5 
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