Project

General

Profile

« Previous | Next » 

Revision 6175

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/VegBank/taxonobservation_/create.sql: Also join to collector_id's party to include collector name

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
4 5 
LEFT JOIN plantconcept_ USING (plantconcept_id)
5 6 
;
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,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
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
inputs/VegBank/taxonobservation_/map.csv
20 20 
taxoninterpretation_id,*taxoninterpretation_id,,
21 21 
stemlocation_id,*stemlocation_id,,
22 22 
taxoninterpretation_plantname_id,*taxoninterpretation_plantname_id,,
23 
party_id,*party_id,,
23 
taxoninterpretation_party_id,*taxoninterpretation_party_id,,
24 24 
role_id,*role_id,,
25 25 
interpretationtype,*interpretationtype,,
26 26 
reference_id,*reference_id,,
......
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,*givenname,,
47 
middlename,*middlename,,
48 
surname,*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,,
44 57 
plantname_id,*plantname_id,,
45 58 
plantconcept_reference_id,*plantconcept_reference_id,,
46 59 
plantname,*plantname,,
inputs/VegBank/taxonobservation_/VegBIEN.csv
48 48 
Subdivision,,** No join mapping for *Subdivision **
49 49 
Subkingdom,,** No join mapping for *Subkingdom **
50 50 
Superdivision,,** No join mapping for *Superdivision **
51 
accessioncode,,** No join mapping for *accessioncode **
51 52 
collectionnumber,,** No join mapping for *collectionnumber **
52 53 
collector_id,,** No join mapping for *collector_id **
54 
contactinstructions,,** No join mapping for *contactinstructions **
53 55 
currentinterpretation,,** No join mapping for *currentinterpretation **
56 
currentname_id,,** No join mapping for *currentname_id **
54 57 
d_currentaccepted,,** No join mapping for *d_currentaccepted **
55 58 
d_obscount,,** No join mapping for *d_obscount **
59 
email,,** No join mapping for *email **
56 60 
emb_taxoninterpretation,,** No join mapping for *emb_taxoninterpretation **
57 61 
emb_taxonobservation,,** No join mapping for *emb_taxonobservation **
62 
givenname,,** No join mapping for *givenname **
58 63 
grouptype,,** No join mapping for *grouptype **
59 64 
int_currplantcode,,** No join mapping for *int_currplantcode **
60 65 
int_currplantcommon,,** No join mapping for *int_currplantcommon **
......
67 72 
int_origplantscifull,,** No join mapping for *int_origplantscifull **
68 73 
int_origplantscinamenoauth,,** No join mapping for *int_origplantscinamenoauth **
69 74 
interpretationtype,,** No join mapping for *interpretationtype **
75 
middlename,,** No join mapping for *middlename **
70 76 
museum_id,,** No join mapping for *museum_id **
71 77 
notesmgt,,** No join mapping for *notesmgt **
72 78 
notespublic,,** No join mapping for *notespublic **
79 
organizationname,,** No join mapping for *organizationname **
73 80 
originalinterpretation,,** No join mapping for *originalinterpretation **
81 
party_d_obscount,,** No join mapping for *party_d_obscount **
74 82 
party_id,,** No join mapping for *party_id **
83 
partypublic,,** No join mapping for *partypublic **
84 
partytype,,** No join mapping for *partytype **
75 85 
plantcode,,** No join mapping for *plantcode **
76 86 
plantconcept_accessioncode,,** No join mapping for *plantconcept_accessioncode **
77 87 
plantconcept_id,,** No join mapping for *plantconcept_id **
......
82 92 
reference_id,,** No join mapping for *reference_id **
83 93 
revisions,,** No join mapping for *revisions **
84 94 
role_id,,** No join mapping for *role_id **
95 
salutation,,** No join mapping for *salutation **
85 96 
stemlocation_id,,** No join mapping for *stemlocation_id **
97 
surname,,** No join mapping for *surname **
86 98 
taxonconfidence,,** No join mapping for *taxonconfidence **
87 99 
taxoninferencearea,,** No join mapping for *taxoninferencearea **
88 100 
taxoninterpretation_accessioncode,,** No join mapping for *taxoninterpretation_accessioncode **
89 101 
taxoninterpretation_id,,** No join mapping for *taxoninterpretation_id **
102 
taxoninterpretation_party_id,,** No join mapping for *taxoninterpretation_party_id **
90 103 
taxoninterpretation_plantname_id,,** No join mapping for *taxoninterpretation_plantname_id **
91 104 
taxonobservation_accessioncode,,** No join mapping for *taxonobservation_accessioncode **
92 105 
taxonobservation_reference_id,,** No join mapping for *taxonobservation_reference_id **
inputs/VegBank/taxonobservation_/unmapped_terms.csv
32 32 
*revisions
33 33 
*emb_taxoninterpretation
34 34 
*taxoninterpretation_accessioncode
35 
*party_id
36 
*salutation
37 
*givenname
38 
*middlename
39 
*surname
40 
*organizationname
41 
*currentname_id
42 
*contactinstructions
43 
*email
44 
*partytype
45 
*partypublic
46 
*party_d_obscount
47 
*accessioncode
35 48 
*plantname_id
36 49 
*plantconcept_reference_id
37 50 
*plantname

Also available in: Unified diff