Project

General

Profile

« Previous | Next » 

Revision 11523

inputs/VegBank/taxonobservation_/create.sql: also join party_id to get the identifiedBy (not mapped yet). note that the inserted row count changes, because taxonobservation_ does not yet have a pkey to do a stable ordering with.

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               USING (party_id)
4 5
LEFT JOIN plantconcept_       USING (plantconcept_id)
5 6
LEFT JOIN plantname           USING (plantname_id)
6
; -- runtime: 20 s ("18564.276") @starscream
7
; -- runtime: 25 s ("23094.379 ms") @starscream
inputs/VegBank/taxonobservation_/header.csv
1
plantname_id,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,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,*plantconcept_--plantconcept_reference_id,scientificName__for_nearest_taxon_concept,*plantconcept_--plantcode,*plantconcept_--plantdescription,*plantconcept_--d_obscount,*plantconcept_--d_currentaccepted,*plantconcept_--plantconcept_accessioncode,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,speciesBinomial,EQUIV#to:Species#Subspecies,EQUIV#to:Species#Variety,EQUIV#to:Species#Forma,plantname,plantname_reference_id,dateentered
1
plantname_id,plantconcept_id,party_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,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,salutation,givenname,middlename,surname,organizationname,currentname_id,contactinstructions,email,partytype,partypublic,party_d_obscount,accessioncode,*plantconcept_--plantconcept_reference_id,scientificName__for_nearest_taxon_concept,*plantconcept_--plantcode,*plantconcept_--plantdescription,*plantconcept_--d_obscount,*plantconcept_--d_currentaccepted,*plantconcept_--plantconcept_accessioncode,kingdom,*Subkingdom,*Superdivision,*Division,*Subdivision,class,*Subclass,order,family,genus,speciesBinomial,EQUIV#to:Species#Subspecies,EQUIV#to:Species#Variety,EQUIV#to:Species#Forma,plantname,plantname_reference_id,dateentered
inputs/VegBank/taxonobservation_/map.csv
1 1
VegBank,VegCore,Filter,Comments
2 2
plantname_id,*taxonobservation_--plantname_id,,
3 3
plantconcept_id,*taxonobservation_--plantconcept_id,,
4
party_id,*taxonobservation_--party_id,,
4 5
taxonobservation_id,taxonOccurrenceID__overall_plot,,
5 6
observation_id,eventID,,
6 7
authorplantname,OMIT#authorplantname,,omitted because not specific to the taxoninterpretation row (this is in a separate taxoninterpretation for the original determination instead). = originalScientificName
......
21 22
taxoninterpretation_id,identificationID,,
22 23
stemlocation_id,*taxonobservation_--stemlocation_id,,
23 24
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,
24
party_id,*taxonobservation_--party_id,,
25 25
role_id,*taxonobservation_--role_id,,
26 26
interpretationtype,identificationType,,
27 27
reference_id,*taxonobservation_--reference_id,,
......
42 42
collectiondate,dateCollected,,
43 43
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,,
44 44
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,,
45
salutation,*taxonobservation--party--salutation,,
46
givenname,*taxonobservation--party--givenname,,
47
middlename,*taxonobservation--party--middlename,,
48
surname,*taxonobservation--party--surname,,
49
organizationname,*taxonobservation--party--organizationname,,
50
currentname_id,*taxonobservation--party--currentname_id,,
51
contactinstructions,*taxonobservation--party--contactinstructions,,
52
email,*taxonobservation--party--email,,
53
partytype,*taxonobservation--party--partytype,,
54
partypublic,*taxonobservation--party--partypublic,,
55
party_d_obscount,*taxonobservation--party--party_d_obscount,,
56
accessioncode,*taxonobservation--party--accessioncode,,
45 57
*plantconcept_--plantconcept_reference_id,*plantconcept_--plantconcept_reference_id,,
46 58
scientificName__for_nearest_taxon_concept,scientificName,,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
47 59
*plantconcept_--plantcode,*plantconcept_--plantcode,,
inputs/VegBank/taxonobservation_/test.xml.ref
126 126
        </path>
127 127
    </_setDefault>
128 128
</VegBIEN>
129
Inserted 20 new rows into database
129
Inserted 12 new rows into database
inputs/VegBank/taxonobservation_/new_terms.csv
1 1
plantname_id,*taxonobservation_--plantname_id,,
2 2
plantconcept_id,*taxonobservation_--plantconcept_id,,
3
party_id,*taxonobservation_--party_id,,
3 4
observation_id,eventID,,
4 5
taxoninferencearea,*taxonobservation_--taxoninferencearea,,
5 6
emb_taxonobservation,*taxonobservation_--emb_taxonobservation,,
......
17 18
taxoninterpretation_id,identificationID,,
18 19
stemlocation_id,*taxonobservation_--stemlocation_id,,
19 20
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,
20
party_id,*taxonobservation_--party_id,,
21 21
role_id,*taxonobservation_--role_id,,
22 22
reference_id,*taxonobservation_--reference_id,,
23 23
museum_id,*taxonobservation_--museum_id,,
......
29 29
collectiondate,dateCollected,,
30 30
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,,
31 31
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,,
32
salutation,*taxonobservation--party--salutation,,
33
givenname,*taxonobservation--party--givenname,,
34
middlename,*taxonobservation--party--middlename,,
35
surname,*taxonobservation--party--surname,,
36
organizationname,*taxonobservation--party--organizationname,,
37
currentname_id,*taxonobservation--party--currentname_id,,
38
contactinstructions,*taxonobservation--party--contactinstructions,,
39
email,*taxonobservation--party--email,,
40
partytype,*taxonobservation--party--partytype,,
41
partypublic,*taxonobservation--party--partypublic,,
42
party_d_obscount,*taxonobservation--party--party_d_obscount,,
43
accessioncode,*taxonobservation--party--accessioncode,,
32 44
scientificName__for_nearest_taxon_concept,scientificName,,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
33 45
plantname,DUPLICATE#of:plantconcept_plantname#plantname,,exact duplicate
34 46
plantname_reference_id,*taxonobservation_--plantname_reference_id,,
inputs/VegBank/taxonobservation_/unmapped_terms.csv
1 1
*taxonobservation_--plantname_id
2 2
*taxonobservation_--plantconcept_id
3
*taxonobservation_--party_id
3 4
taxonOccurrenceID__overall_plot
4 5
*taxonobservation_--taxonobservation_reference_id
5 6
*taxonobservation_--taxoninferencearea
......
8 9
identificationID
9 10
*taxonobservation_--stemlocation_id
10 11
*taxonobservation_--taxoninterpretation_plantname_id
11
*taxonobservation_--party_id
12 12
*taxonobservation_--role_id
13 13
*taxonobservation_--reference_id
14 14
identificationVerificationStatus
......
19 19
*taxonobservation_--revisions
20 20
*taxonobservation_--emb_taxoninterpretation
21 21
*taxonobservation_--taxoninterpretation_accessioncode
22
*taxonobservation--party--salutation
23
*taxonobservation--party--givenname
24
*taxonobservation--party--middlename
25
*taxonobservation--party--surname
26
*taxonobservation--party--organizationname
27
*taxonobservation--party--currentname_id
28
*taxonobservation--party--contactinstructions
29
*taxonobservation--party--email
30
*taxonobservation--party--partytype
31
*taxonobservation--party--partypublic
32
*taxonobservation--party--party_d_obscount
33
*taxonobservation--party--accessioncode
22 34
*plantconcept_--plantconcept_reference_id
23 35
*plantconcept_--plantcode
24 36
*plantconcept_--plantdescription

Also available in: Unified diff