Project

General

Profile

« Previous | Next » 

Revision 4531

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/VegBank/taxonobservation_/map.csv: Mapped observation_id to eventID

View differences:

inputs/VegBank/taxonobservation_/map.csv
1 1 
VegBank[Veg+],Veg+,Comments
2 2 
plantconcept_id,,
3 3 
taxonobservation_id,taxonOccurrenceID,
4 
observation_id,,
4 
observation_id,eventID,
5 5 
authorplantname,verbatimScientificName,
6 6 
taxonobservation_reference_id,,
7 7 
taxoninferencearea,,
inputs/VegBank/taxonobservation_/map.full.csv
2 2 
museumaccessionnumber,catalogNumber,
3 3 
class,class
4 4 
collectiondate,collectedDate,
5 
observation_id,eventID,
5 6 
family,family
6 7 
genus,genus
7 8 
interpretationdate,identifiedDate,
inputs/VegBank/taxonobservation_/VegBIEN.csv
1 1 
VegBank[Veg+],VegBIEN:,Comments
2 2 
museumaccessionnumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
3 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",
4 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1",
5 
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",
3 6 
collectiondate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3,
4 7 
collectiondate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/3,
5 8 
collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/3,
inputs/VegBank/taxonobservation_/test.xml.ref
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>$museumaccessionnumber</authorlocationcode>
5 5 
        <locationevent>
6 
            <sourceaccessioncode>$observation_id</sourceaccessioncode>
6 7 
            <obsenddate><_date><date><_dateRangeEnd><value>$collectiondate</value></_dateRangeEnd></date></_date></obsenddate>
7 8 
            <obsstartdate><_date><date><_dateRangeStart><value>$collectiondate</value></_dateRangeStart></date></_date></obsstartdate>
8 9 
            <taxonoccurrence>
......
105 106 
        </locationevent>
106 107 
    </location>
107 108 
</VegBIEN>
108 
Inserted 18 new rows into database
109 
Inserted 19 new rows into database

Also available in: Unified diff