Project

General

Profile

« Previous | Next » 

Revision 10683

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/taxonobservation_/map.csv: collector_id: remapped to UNUSED. removed LEFT JOIN collector_id->party since this field is never populated.

View differences:

inputs/VegBank/taxonobservation_/create.sql
1 1 
SELECT *
2 2 
FROM taxonobservation
3 3 
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
4 
LEFT JOIN party collector ON collector.party_id = taxoninterpretation.collector_id
5 4 
LEFT JOIN plantconcept_ USING (plantconcept_id)
6 
;
5 
; -- runtime: 15 s ("Time: 13141.443 ms") @starscream
inputs/VegBank/taxonobservation_/header.csv
1 
plantconcept_id,taxonobservation_id,observation_id,authorplantname,taxonobservation_reference_id,taxoninferencearea,emb_taxonobservation,int_origplantconcept_id,int_origplantscifull,int_origplantscinamenoauth,int_origplantcommon,int_origplantcode,int_currplantconcept_id,int_currplantscifull,int_currplantscinamenoauth,int_currplantcommon,int_currplantcode,taxonobservation_accessioncode,taxoninterpretation_id,stemlocation_id,taxoninterpretation_plantname_id,taxoninterpretation_party_id,role_id,interpretationtype,reference_id,originalinterpretation,currentinterpretation,taxonfit,taxonconfidence,collector_id,collectionnumber,museum_id,museumaccessionnumber,grouptype,notes,notespublic,notesmgt,revisions,interpretationdate,collectiondate,emb_taxoninterpretation,taxoninterpretation_accessioncode,party_id,salutation,givenname,middlename,surname,organizationname,currentname_id,contactinstructions,email,partytype,partypublic,party_d_obscount,accessioncode,plantname_id,plantconcept_reference_id,plantname,plantcode,plantdescription,d_obscount,d_currentaccepted,plantconcept_accessioncode,Kingdom,Subkingdom,Superdivision,Division,Subdivision,Class,Subclass,Order,Family,Genus,Species,Subspecies,Variety,Forma
1 
plantconcept_id,taxonobservation_id,observation_id,authorplantname,taxonobservation_reference_id,taxoninferencearea,emb_taxonobservation,int_origplantconcept_id,int_origplantscifull,int_origplantscinamenoauth,int_origplantcommon,int_origplantcode,int_currplantconcept_id,int_currplantscifull,int_currplantscinamenoauth,int_currplantcommon,int_currplantcode,taxonobservation_accessioncode,taxoninterpretation_id,stemlocation_id,taxoninterpretation_plantname_id,taxoninterpretation_party_id,role_id,interpretationtype,reference_id,originalinterpretation,currentinterpretation,taxonfit,taxonconfidence,collector_id,collectionnumber,museum_id,museumaccessionnumber,grouptype,notes,notespublic,notesmgt,revisions,interpretationdate,collectiondate,emb_taxoninterpretation,taxoninterpretation_accessioncode,plantname_id,plantconcept_reference_id,plantname,plantcode,plantdescription,d_obscount,d_currentaccepted,plantconcept_accessioncode,Kingdom,Subkingdom,Superdivision,Division,Subdivision,Class,Subclass,Order,Family,Genus,Species,Subspecies,Variety,Forma
inputs/VegBank/taxonobservation_/map.csv
28 28 
currentinterpretation,*currentinterpretation,,
29 29 
taxonfit,identificationQualifier,,
30 30 
taxonconfidence,identificationVerificationStatus,,
31 
collector_id,*collector_id,,
31 
collector_id,UNUSED#collector_id,,
32 32 
collectionnumber,collectorNumber,,
33 33 
museum_id,*museum_id,,
34 34 
museumaccessionnumber,accessionNumber,,
......
41 41 
collectiondate,dateCollected,,
42 42 
emb_taxoninterpretation,*emb_taxoninterpretation,,
43 43 
taxoninterpretation_accessioncode,*taxoninterpretation_accessioncode,,
44 
party_id,*party_id,,
45 
salutation,*salutation,,
46 
givenname,recordedBy_givenName,,
47 
middlename,*middlename,,
48 
surname,recordedBy_surName,,
49 
organizationname,*organizationname,,
50 
currentname_id,*currentname_id,,
51 
contactinstructions,*contactinstructions,,
52 
email,*email,,
53 
partytype,*partytype,,
54 
partypublic,*partypublic,,
55 
party_d_obscount,*party_d_obscount,,
56 
accessioncode,*accessioncode,,
57 44 
plantname_id,*plantname_id,,
58 45 
plantconcept_reference_id,*plantconcept_reference_id,,
59 46 
plantname,*plantname,,
inputs/VegBank/taxonobservation_/VegBIEN.csv
23 23 
int_origplantscinamenoauth,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",
24 24 
int_currplantscifull,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
25 25 
int_currplantscinamenoauth,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
26 
givenname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,
27 
surname,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,
28 26 
collectionnumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
29 27 
taxonobservation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
30 28 
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
......
63 61 
Subdivision,,** No join mapping for *Subdivision **
64 62 
Subkingdom,,** No join mapping for *Subkingdom **
65 63 
Superdivision,,** No join mapping for *Superdivision **
66 
accessioncode,,** No join mapping for *accessioncode **
67 
collector_id,,** No join mapping for *collector_id **
68 
contactinstructions,,** No join mapping for *contactinstructions **
64 
collector_id,,** No non-empty join mapping for UNUSED#collector_id **
69 65 
currentinterpretation,,** No join mapping for *currentinterpretation **
70 
currentname_id,,** No join mapping for *currentname_id **
71 66 
d_currentaccepted,,** No join mapping for *d_currentaccepted **
72 67 
d_obscount,,** No join mapping for *d_obscount **
73 
email,,** No join mapping for *email **
74 68 
emb_taxoninterpretation,,** No join mapping for *emb_taxoninterpretation **
75 69 
emb_taxonobservation,,** No join mapping for *emb_taxonobservation **
76 70 
grouptype,,** No join mapping for *grouptype **
......
81 75 
int_origplantcommon,,** No join mapping for originalVernacularName **
82 76 
int_origplantconcept_id,,** No join mapping for *int_origplantconcept_id **
83 77 
int_origplantscifull,,** No non-empty join mapping for EQUIV#to:authorplantname#int_origplantscifull **  = originalScientificName_scrubbed
84 
middlename,,** No join mapping for *middlename **
85 78 
museum_id,,** No join mapping for *museum_id **
86 79 
notesmgt,,** No join mapping for *notesmgt **
87 80 
notespublic,,** No join mapping for *notespublic **
88 
organizationname,,** No join mapping for *organizationname **
89 81 
originalinterpretation,,** No join mapping for *originalinterpretation **
90 
party_d_obscount,,** No join mapping for *party_d_obscount **
91 
party_id,,** No join mapping for *party_id **
92 
partypublic,,** No join mapping for *partypublic **
93 
partytype,,** No join mapping for *partytype **
94 82 
plantcode,,** No join mapping for *plantcode **
95 83 
plantconcept_accessioncode,,** No join mapping for *plantconcept_accessioncode **
96 84 
plantconcept_id,,** No join mapping for *plantconcept_id **
......
101 89 
reference_id,,** No join mapping for *reference_id **
102 90 
revisions,,** No join mapping for *revisions **
103 91 
role_id,,** No join mapping for *role_id **
104 
salutation,,** No join mapping for *salutation **
105 92 
stemlocation_id,,** No join mapping for *stemlocation_id **
106 93 
taxonconfidence,,** No join mapping for identificationVerificationStatus **
107 94 
taxoninferencearea,,** No join mapping for *taxoninferencearea **
inputs/VegBank/taxonobservation_/test.xml.ref
22 22 
                                    </plantobservation>
23 23 
                                </aggregateoccurrence>
24 24 
                                <authortaxoncode>$collectionnumber</authortaxoncode>
25 
                                <collector_id>
26 
                                    <party>
27 
                                        <fullname>
28 
                                            <_join_words>
29 
                                                <1>$givenname</1>
30 
                                                <2>$surname</2>
31 
                                            </_join_words>
32 
                                        </fullname>
33 
                                    </party>
34 
                                </collector_id>
35 25 
                                <sourceaccessioncode>$taxonobservation_id</sourceaccessioncode>
36 26 
                                <taxondetermination>
37 27 
                                    <taxonverbatim_id>
inputs/VegBank/taxonobservation_/new_terms.csv
7 7 
int_currplantcommon,vernacularName,,
8 8 
interpretationdate,dateIdentified,,
9 9 
collectiondate,dateCollected,,
10 
givenname,recordedBy_givenName,,
11 
surname,recordedBy_surName,,
inputs/VegBank/taxonobservation_/unmapped_terms.csv
18 18 
*originalinterpretation
19 19 
*currentinterpretation
20 20 
identificationVerificationStatus
21 
*collector_id
22 21 
*museum_id
23 22 
*grouptype
24 23 
*notespublic
......
26 25 
*revisions
27 26 
*emb_taxoninterpretation
28 27 
*taxoninterpretation_accessioncode
29 
*party_id
30 
*salutation
31 
*middlename
32 
*organizationname
33 
*currentname_id
34 
*contactinstructions
35 
*email
36 
*partytype
37 
*partypublic
38 
*party_d_obscount
39 
*accessioncode
40 28 
*plantname_id
41 29 
*plantconcept_reference_id
42 30 
*plantname

Also available in: Unified diff